MySQL Forums
Forum List  »  Install & Repo

Problems upgrading from 8.0.15 to 8.0.16
Posted by: Mike Tipping
Date: April 25, 2019 05:57AM

My server decided to do an auto update from 8.0.15 to 8.0.16 last night and failed.

The error output is below:

2019-04-24T23:01:16.031665Z 1 [System] [MY-011090] [Server] Data dictionary upgrading from version '80014' to '80016'.
2019-04-24T23:01:16.452964Z 1 [System] [MY-013413] [Server] Data dictionary upgrade from version '80014' to '80016' completed.
mysqld: Table 'information_schema.TABLES' doesn't exist
mysqld: Table 'information_schema.ROUTINES' doesn't exist
mysqld: Table 'information_schema.TABLES' doesn't exist
mysqld: Table 'information_schema.TABLES' doesn't exist
mysqld: Table 'information_schema.TRIGGERS' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.global_variables' doesn't exist
2019-04-24T23:01:19.751312Z 4 [System] [MY-013381] [Server] Server upgrade from '80015' to '80016' started.
2019-04-24T23:01:19.770517Z 4 [ERROR] [MY-010725] [Server] Couldn't repair table: mysql.general_log
2019-04-24T23:01:19.770538Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'CREATE TABLE IF NOT EXISTS general_log (event_time TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), user_host MEDIUMTEXT NOT NULL, thread_id BIGINT(21) UNSIGNED NOT NULL, server_id INTEGER UNSIGNED NOT NULL, command_type VARCHAR(64) NOT NULL, argument MEDIUMBLOB NOT NULL) engine=CSV CHARACTER SET utf8 comment="General log";
' failed with error code = 1034, error message = 'Incorrect key file for table 'general_log'; try to repair it'.
2019-04-24T23:01:19.771969Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2019-04-24T23:01:19.772156Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-04-24T23:01:22.385908Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.

MYSQL will run in debug mode and reports that it is running 8.1.16 but when run in normal mode it repeats the above output and fails.

Options: ReplyQuote


Subject
Written By
Posted
Problems upgrading from 8.0.15 to 8.0.16
April 25, 2019 05:57AM


Sorry, you can't reply to this topic. It has been closed.

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.