mysql_upgrade fails from 5.5 to 5.6
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Unassigned |
Bug Description
It seems that a basic in place upgrade has problems:
1- create 5.5 server instance with my.cnf and start:
[client]
port=10000
socket=
[mysqld]
basedir=
datadir=
tmpdir=
port=10000
socket=
pid-file=
console
user=root
server-id=1
innodb_
innodb_
innodb_
innodb_
2- create and load in sakila database
3 - shutdown 5.5 server
4 - create 5.6 server instance with my.cnf
[client]
port=10001
socket=
[mysqld]
basedir=
datadir=
tmpdir=
port=10001
socket=
pid-file=
console
user=root
server-id=2
innodb_
innodb_
innodb_
innodb_
5 - delete 5.6 data dir and copy over 5.5 data dir to same location
6 - start 5.6 server with --skip-grant-tables
7 - run mysql_upgrade
5.6 mysql.log when started with --skip-
2013-07-02 13:13:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2013-07-02 13:13:52 11815 [Note] Plugin 'FEDERATED' is disabled.
2013-07-02 13:13:52 11815 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-02 13:13:52 11815 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-07-02 13:13:52 11815 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-02 13:13:52 11815 [Note] InnoDB: Using Linux native AIO
2013-07-02 13:13:52 11815 [Note] InnoDB: Using CPU crc32 instructions
2013-07-02 13:13:52 11815 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2013-07-02 13:13:52 11815 [Note] InnoDB: Completed initialization of buffer pool
2013-07-02 13:13:52 11815 [Note] InnoDB: Highest supported file format is Barracuda.
2013-07-02 13:13:52 11815 [Note] InnoDB: 128 rollback segment(s) are active.
2013-07-02 13:13:52 11815 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-07-02 13:13:52 11815 [Note] InnoDB: Tablespace and datafile system tables created.
2013-07-02 13:13:52 11815 [Note] InnoDB: Waiting for purge to start
2013-07-02 13:13:52 11815 [Note] InnoDB: Percona XtraDB (http://
2013-07-02 13:13:52 11815 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ea327020-
2013-07-02 13:13:52 11815 [Note] Server hostname (bind-address): '*'; port: 10001
2013-07-02 13:13:52 11815 [Note] IPv6 is available.
2013-07-02 13:13:52 11815 [Note] - '::' resolves to '::';
2013-07-02 13:13:52 11815 [Note] Server socket created on IP: '::'.
2013-07-02 13:13:52 11815 [Warning] Info table is not ready to be used. Table 'mysql.
2013-07-02 13:13:52 11815 [Warning] Info table is not ready to be used. Table 'mysql.
2013-07-02 13:13:52 11815 [ERROR] Column count of mysql.events_
2013-07-02 13:13:52 11815 [ERROR] Column count of mysql.events_
2013-07-02 13:13:52 11815 [ERROR] Column count of mysql.events_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Incorrect definition of table performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Column count of mysql.file_
2013-07-02 13:13:52 11815 [ERROR] Column count of mysql.file_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Incorrect definition of table performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Incorrect definition of table performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50532, now running 50612. Please use mysql_upgrade to fix this error.
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [ERROR] Native table 'performance_
2013-07-02 13:13:52 11815 [Note] mysqld: ready for connections.
Version: '5.6.12' socket: '/data/
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."actor" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."address" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."category" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."city" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."country" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."customer" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."film" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."language" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."payment" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."rental" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."staff" but the required system tables mysql.innodb_
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Table "mysql"
2013-07-02 13:13:52 7fe238071700 InnoDB: Error: Fetch of persistent statistics requested for table "sakila"."store" but the required system tables mysql.innodb_
2013-07-02 13:13:53 11815 [Note] mysqld: Normal shutdown
2013-07-02 13:13:53 11815 [Note] Giving 0 client threads a chance to die gracefully
2013-07-02 13:13:53 11815 [Note] Shutting down slave threads
2013-07-02 13:13:53 11815 [Note] Forcefully disconnecting 0 remaining clients
2013-07-02 13:13:53 11815 [Note] Binlog end
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'partition'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'BLACKHOLE'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'PERFORMANCE_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'ARCHIVE'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_METRICS'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_CMP'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'INNODB_TRX'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'XTRADB_RSEG'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'XTRADB_
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2013-07-02 13:13:53 11815 [Note] Shutting down plugin 'InnoDB'
2013-07-02 13:13:53 11815 [Note] InnoDB: FTS optimize thread exiting.
2013-07-02 13:13:53 11815 [Note] InnoDB: Starting shutdown...
2013-07-02 13:13:54 11815 [Note] InnoDB: Shutdown completed; log sequence number 8441732
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'MEMORY'
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'MyISAM'
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'MRG_MYISAM'
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'CSV'
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'sha256_password'
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'mysql_
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'mysql_
2013-07-02 13:13:54 11815 [Note] Shutting down plugin 'binlog'
2013-07-02 13:13:54 11815 [Note] mysqld: Shutdown complete
mysql_upgrade.log
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--socket=
Running 'mysqlcheck' with connection arguments: '--socket=
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_
mysql.time_
mysql.time_
mysql.time_
mysql.user OK
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
performance_
sakila.actor OK
sakila.address OK
sakila.category OK
sakila.city OK
sakila.country OK
sakila.customer OK
sakila.film OK
sakila.film_actor OK
sakila.
sakila.film_text OK
sakila.inventory OK
sakila.language OK
sakila.payment OK
sakila.rental OK
sakila.staff OK
sakila.store OK
Running 'mysql_
ERROR 1426 (42000) at line 47: Too big precision 14 specified for column 'Timestamp'. Maximum is 6.
ERROR 1426 (42000) at line 49: Too big precision 14 specified for column 'Timestamp'. Maximum is 6.
ERROR 1426 (42000) at line 81: Too big precision 14 specified for column 'Timestamp'. Maximum is 6.
ERROR 1193 (HY000) at line 85: Unknown system variable 'have_csv'
ERROR 1064 (42000) at line 87: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 89: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1193 (HY000) at line 93: Unknown system variable 'have_csv'
ERROR 1064 (42000) at line 95: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 97: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1426 (42000) at line 483: Too big precision 14 specified for column 'Timestamp'. Maximum is 6.
FATAL ERROR: Upgrade failed
If 5.6 server is restarted without --skip-
This is probably upstream but I can not find a report of anything similar (or I am completely missing something).