Bug #79290 | 5.6 crashes on a 5.7 datadir | ||
---|---|---|---|
Submitted: | 16 Nov 2015 8:56 | Modified: | 3 Feb 2016 16:22 |
Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Logging | Severity: | S3 (Non-critical) |
Version: | 5.6.27, 5.6.29 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | downgrade |
[16 Nov 2015 8:56]
Daniël van Eeden
[16 Nov 2015 8:58]
Daniël van Eeden
Related: Bug #72187 Crash with 5.5 datadir
[16 Nov 2015 9:04]
Daniël van Eeden
This happens because mysql.* of 5.7 is not downwards compatible. When running with --skip-grant-tables this happens: 2015-11-16 08:42:14 38657 [Note] InnoDB: Highest supported file format is Barracuda. InnoDB: No valid checkpoint found. InnoDB: If this error appears when you are creating an InnoDB database, InnoDB: the problem may be that during an earlier attempt you managed InnoDB: to create the InnoDB data files, but log file creation failed. InnoDB: If that is the case, please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html 2015-11-16 08:42:14 38657 [ERROR] Plugin 'InnoDB' init function returned error. 2015-11-16 08:42:14 38657 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2015-11-16 08:42:14 38657 [ERROR] Unknown/unsupported storage engine: InnoDB 2015-11-16 08:42:14 38657 [ERROR] Aborting This is because the new logfile format for InnoDB.
[16 Nov 2015 10:23]
MySQL Verification Team
Hello Daniël, Thank you for the report. Observed this when starting 5.6.29 with 5.7.11 datadir. Thanks, Umesh
[16 Nov 2015 10:23]
MySQL Verification Team
// 5.6.29 (gdb) bt #0 0x00007f44c876c771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000006a4f3a in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/signal_handler.cc:230 #2 <signal handler called> #3 0x00000000005c0c10 in ha_resolve_by_name (thd=0x7ffe0a2da0e0, name=0x7ffe0a2d9a60, is_temp_table=false) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/handler.cc:340 #4 0x00000000007c12a3 in open_binary_frm (file=<optimized out>, head=<optimized out>, share=<optimized out>, thd=<optimized out>) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/table.cc:1262 #5 open_table_def (thd=0x7ffe0a2da0e0, share=0x18f08b0, db_flags=8192) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/table.cc:746 #6 0x00000000006d4649 in get_table_share (thd=0x7ffe0a2da0e0, table_list=0x7ffe0a2dd410, key=<optimized out>, key_length=13, db_flags=8192, error=0x7ffe0a2d9ec8, hash_value=1324052888) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/sql_base.cc:508 #7 0x00000000006d6b1c in get_table_share_with_discover (thd=0x148c860 <LOCK_plugin>, table_list=0x0, key=0x18ed108 "\240", <incomplete sequence \323>, key_length=66, db_flags=0, error=0xffff, hash_value=1324052888) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/sql_base.cc:587 #8 0x00000000006de466 in open_table (thd=0x7ffe0a2da0e0, table_list=0x7ffe0a2dd410, ot_ctx=0x7ffe0a2d9f60) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/sql_base.cc:3038 #9 0x00000000006e062c in open_and_process_table (ot_ctx=<optimized out>, has_prelocking_list=<optimized out>, prelocking_strategy=<optimized out>, flags=<optimized out>, counter=<optimized out>, tables=<optimized out>, lex=0x7ffe0a2dbe88, thd=<optimized out>) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/sql_base.cc:4736 #10 open_tables (thd=0x7ffe0a2da0e0, start=0x7ffe0a2da018, counter=0x7ffe0a2da03c, flags=2048, prelocking_strategy=0x7ffe0a2ddc80) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/sql_base.cc:5169 #11 0x00000000006e088e in open_and_lock_tables (thd=0x148c860 <LOCK_plugin>, tables=0x7ffe0a2dd410, derived=false, flags=66, prelocking_strategy=0x0) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/sql_base.cc:5813 #12 0x00000000007355a5 in plugin_init (argc=0x1485814 <remaining_argc>, argv=0x1806c70, flags=<optimized out>) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/sql_base.h:472 #13 0x00000000005b5e90 in init_server_components () at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/mysqld.cc:4850 #14 0x00000000005b6d05 in mysqld_main (argc=8, argv=0x1806c70) at /export/home/pb2/build/sb_0-17052149-1447421659.07/mysqlcom-pro-5.6.29/sql/mysqld.cc:5447 #15 0x00007f44c735eaf5 in __libc_start_main () from /lib64/libc.so.6 #16 0x00000000005aa9b9 in _start () (gdb)
[3 Feb 2016 16:22]
Paul DuBois
Noted in 5.6.30 changelog. A MySQL 5.6 server exited during startup if used with a 5.7 data directory due to the change in 5.7 of the mysql.plugin table from MyISAM to InnoDB. A safe shutdown now occurs in this circumstance.