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.

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.

Kommentar verfassen

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

Scroll to Top