MySQL Forums
Forum List  »  Install & Repo

Upgrading 5.7 to 8.0.21 getting errors when starting up
Posted by: Michael delos Reyes
Date: December 11, 2020 02:15PM

Hi everyone,

I'm getting errors when mysql 8 starts to do the inplace upgrade of percona 8.0.22 from 5.7

How do I find which tables are giving me the [ERROR] [MY-013140] [Server] BLOB/TEXT column 'id' used in key specification without a key length errors?



2020-12-11T19:20:51.447877Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-12) starting as process 4301

2020-12-11T19:20:51.495429Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.

2020-12-11T19:20:51.541495Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.

2020-12-11T19:20:51.541591Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2020-12-11T19:21:24.303887Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2020-12-11T19:21:26.673453Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock

2020-12-11T19:21:26.673910Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001287 - 'validate password plugin' is deprecated and will be removed in a future release. Please use validate_password component instead

2020-12-11T19:22:31.033652Z 2 [ERROR] [MY-013140] [Server] BLOB/TEXT column 'id' used in key specification without a key length

2020-12-11T19:22:31.732431Z 2 [ERROR] [MY-013140] [Server] BLOB/TEXT column 'id' used in key specification without a key length

2020-12-11T19:22:33.806794Z 2 [ERROR] [MY-013140] [Server] BLOB/TEXT column 'id' used in key specification without a key length

2020-12-11T19:22:42.906158Z 2 [ERROR] [MY-010520] [Server] Invalid (old?) table or database name 'lost+found'

2020-12-11T19:22:42.906668Z 2 [Warning] [MY-010772] [Server] db.opt file not found for lost+found database. Using default Character set.

2020-12-11T19:22:42.912252Z 2 [Warning] [MY-010772] [Server] db.opt file not found for mplustemp database. Using default Character set.

2020-12-11T19:22:53.653014Z 2 [Warning] [MY-010772] [Server] db.opt file not found for tmp database. Using default Character set.

2020-12-11T19:23:07.181430Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.

2020-12-11T19:23:07.182187Z 0 [ERROR] [MY-010119] [Server] Aborting

2020-12-11T19:23:08.750182Z 0 [Warning] [MY-011068] [Server] The syntax 'validate password plugin' is deprecated and will be removed in a future release. Please use validate_password component instead.

2020-12-11T19:23:12.268221Z 0 [Warning] [MY-010738] [Server] Plugin 'audit_log' will be forced to shutdown

2020-12-11T19:23:12.277628Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-12) Percona Server (GPL), Release 12, Revision 7ddfdfe.

Options: ReplyQuote


Subject
Written By
Posted
Upgrading 5.7 to 8.0.21 getting errors when starting up
December 11, 2020 02:15PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.