InnoDB Error: Column last_update

I had a look into the syslog file of my debian server and found out that there are innodb errors spamming the logfile.

Inhaltsverzeichnis
InnoDB Error Column last_update : unexpected structure

Error message

mysqld[62708]: 2018-11-10 14:06:49 7fe0b5287b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
mysqld[62708]: 2018-11-10 14:06:49 7fe0b5287b00 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

Solution

mattionline:~# mysqldump -p –events –quick –single-transaction mysql > mysql-dump.sql
Enter password:
mattionline:~# mysql mysql < mysql-dump.sql
ERROR 1045 (28000): Access denied for user root’@’localhost (using password: NO)
mattionline:~# mysql -p mysql < mysql-dump.sql
Enter password:
mattionline:~# systemctl restart mysql

Export the database to a sql file and directly import it again (mysql server don’t need to be stopped).

After the restart of the mysql server the innodb errors disappeared.

About The Author

Kommentar verfassen

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert

Nach oben scrollen