Bug #77804 mysqld crash on broken InnoDB data during recovery
| Submitted: | 23 Jul 2015 0:44 | Modified: | 23 Jul 2015 13:52 |
|---|---|---|---|
| Reporter: | Martin Mokrejs | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: InnoDB Plugin storage engine | Severity: | S1 (Critical) |
| Version: | 5.6.24 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any |
[23 Jul 2015 0:44]
Martin Mokrejs
[23 Jul 2015 1:34]
Martin Mokrejs
Actually, here is from the mysqld.err a preceding entry. Not sure if I upgraded the tables or not, it is not logged in the error file obviously. Could this eventually cause the recovery to fail? 150311 16:29:55 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin ' to avoid this problem. 150311 16:29:55 InnoDB: The InnoDB memory heap is disabled 150311 16:29:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150311 16:29:55 InnoDB: Compressed tables use zlib 1.2.7 150311 16:29:55 InnoDB: Using Linux native AIO 150311 16:29:55 InnoDB: Initializing buffer pool, size = 128.0M 150311 16:29:55 InnoDB: Completed initialization of buffer pool 150311 16:29:56 InnoDB: highest supported file format is Barracuda. 150311 16:29:56 InnoDB: Warning: allocated tablespace 1, old maximum was 0 150311 16:29:56 InnoDB: Waiting for the background threads to start 150311 16:29:57 InnoDB: 5.5.30 started; log sequence number 14091345 150311 16:29:57 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated' 150311 16:29:58 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 150311 16:29:58 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 150311 16:29:58 [Note] Server socket created on IP: '127.0.0.1'. 150311 16:29:58 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 150311 16:29:58 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 150311 16:29:58 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 150311 16:29:58 [Note] Event Scheduler: Loaded 0 events 150311 16:29:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.30-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution
[23 Jul 2015 5:49]
MySQL Verification Team
Hello Martin, Thank you for the report. This is most likely duplicate of Bug #72351 Thanks, Umesh
[23 Jul 2015 13:52]
Martin Mokrejs
Thank you, you were right, downgrading to 5.5.44 version enabled me to run through the recovery process: 150723 15:17:16 InnoDB: The InnoDB memory heap is disabled 150723 15:17:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150723 15:17:16 InnoDB: Compressed tables use zlib 1.2.8 150723 15:17:16 InnoDB: Using Linux native AIO 150723 15:17:16 InnoDB: Initializing buffer pool, size = 128.0M 150723 15:17:16 InnoDB: Completed initialization of buffer pool 150723 15:17:16 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 150723 15:17:16 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Last MySQL binlog file position 0 19242, file name ./mysqld-bin.000050 150723 15:17:17 InnoDB: 5.5.44 started; log sequence number 14137088 150723 15:17:17 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated' 150723 15:17:17 [Note] Recovering after a crash using mysqld-bin 150723 15:17:17 [Note] Starting crash recovery... 150723 15:17:17 [Note] Crash recovery finished. 150723 15:17:17 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 150723 15:17:17 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 150723 15:17:17 [Note] Server socket created on IP: '127.0.0.1'. 150723 15:17:17 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 150723 15:17:17 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 150723 15:17:17 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 150723 15:17:17 [Note] Event Scheduler: Loaded 0 events 150723 15:17:17 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.44-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution I did run mysql_update and things are fine again. Well, still need to go from 5.5.x to 5.6.x. ;-)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.043 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.