| Bug #53248 | compressed tables page checksum mismatch after re-enabling innodb_checksums | ||
|---|---|---|---|
| Submitted: | 28 Apr 2010 12:26 | Modified: | 17 Aug 2010 20:18 |
| Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: InnoDB Plugin storage engine | Severity: | S1 (Critical) |
| Version: | 1.0.6, 1.0.7 | OS: | Any (Windows, Mac OS X) |
| Assigned to: | Marko Mäkelä | CPU Architecture: | Any |
| Tags: | compressed, innodb_checksums | ||
[28 Apr 2010 12:26]
Shane Bester
[28 Apr 2010 13:57]
Valeriy Kravchuk
Thank you for the bug report. Verified just as described, also - with mysql-trunk on Mac OS X: ... 100428 16:53:42 InnoDB Plugin 1.0.6 started; log sequence number 46853 100428 16:53:42 [Note] Event Scheduler: Loaded 0 events 100428 16:53:42 [Note] /Users/openxs/dbs/trunk/libexec/mysqld: ready for connections. Version: '5.5.5-m3-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution 100428 16:53:49 InnoDB: compressed page checksum mismatch (space 1 page 3): 3735928559 != 683020721 100428 16:53:49 - mysqld got signal 10 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337852 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x101ee18 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0xb06fcf34 thread_stack 0x30000 0 mysqld 0x005b6161 my_print_stacktrace + 44 1 mysqld 0x00104982 handle_segfault + 876 2 libSystem.B.dylib 0x940472bb _sigtramp + 43 3 ??? 0xffffffff 0x0 + 4294967295 4 mysqld 0x00398ecf init_heap_psi_keys + 1603 5 mysqld 0x00399565 init_heap_psi_keys + 3289 6 mysqld 0x003c5093 init_heap_psi_keys + 182279 7 mysqld 0x003c5179 init_heap_psi_keys + 182509 8 mysqld 0x003bf53e init_heap_psi_keys + 158898 9 mysqld 0x003e2cae init_heap_psi_keys + 304162 10 mysqld 0x00253ce0 _ZN7handler7ha_openEP5TABLEPKcii + 320 11 mysqld 0x0017a421 _Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb + 2761 12 mysqld 0x0016e24f _Z10open_tableP3THDP10TABLE_LISTP11st_mem_rootP18Open_table_contextj + 3393 13 mysqld 0x0016f04c _Z28open_system_table_for_updateP3THDP10TABLE_LIST + 836 14 mysqld 0x0016f709 _Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy + 579 15 mysqld 0x0000c591 _Z11open_tablesP3THDPP10TABLE_LISTPjj + 57 16 mysqld 0x0016fb39 _Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj + 143 17 mysqld 0x002a3365 _Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc + 123 18 mysqld 0x00122719 _Z16dispatch_command19enum_server_commandP3THDPcj + 4069 19 mysqld 0x001235b9 _Z10do_commandP3THD + 621 20 mysqld 0x0010fb67 _Z24do_handle_one_connectionP3THD + 425 21 mysqld 0x0010fc2b handle_one_connection + 37 22 libSystem.B.dylib 0x9400c095 _pthread_start + 321 23 libSystem.B.dylib 0x9400bf52 thread_start + 34 Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x10a1c40 = thd->thread_id=1 thd->killed=NOT_KILLED ...
[3 May 2010 10:47]
Marko Mäkelä
The bug is that buf_zip_decompress() forgets to check "&& stamp_checksum != BUF_NO_CHECKSUM_MAGIC" before complaining, like buf_page_is_corrupted() does. Furthermore, the caller is not prepared for buf_page_get_gen() returning NULL. I guess we should trigger an assertion failure on buf_zip_decompress() failure.
[3 May 2010 12:29]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/107196
[3 May 2010 12:29]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/107197
[4 May 2010 8:07]
Sunny Bains
OK to commit!
[17 Jun 2010 6:15]
Bugs System
Pushed into 5.5.5-m3 (revid:alexey.kopytov@sun.com-20100615145247-8bj0vmuqlotbqsn9) (version source revid:marko.makela@oracle.com-20100503122859-k73bl51re93o0mt4) (merge vers: 5.1.47) (pib:16)
[17 Jun 2010 6:18]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100615150216-cubqoyn1fj9b6a2p) (version source revid:marko.makela@oracle.com-20100503122859-k73bl51re93o0mt4) (pib:16)
[17 Jun 2010 11:46]
Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:martin.skold@mysql.com-20100616204905-jxjg342w35ks9vfy) (merge vers: 5.1.47-ndb-7.0.16) (pib:16)
[17 Jun 2010 12:24]
Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:martin.skold@mysql.com-20100615090726-jotpykke96le59w5) (merge vers: 5.1.47-ndb-6.2.19) (pib:16)
[17 Jun 2010 13:11]
Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:martin.skold@mysql.com-20100616120453-jh7wr05z1vf7r8pm) (merge vers: 5.1.47-ndb-6.3.35) (pib:16)
[17 Aug 2010 20:18]
John Russell
Added to 5.1 and 5.5 change log: Fixed a checksum error reported for compressed tables when the --innodb_checksums option is enabled. Although the message stated that the table was corrupted, the table is actually fine after the fix.
