Script started on Sat 28 Nov 2009 11:17:05 PM EST slim:/usr/local/mysql# gdb GNU gdb (GDB) 7.0-debian Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "i486-linux-gnu". For bug reporting instructions, please see: . (gdb) file libexec/mysqld Reading symbols from /usr/local/mysql/libexec/mysqld...done. (gdb) run --gdb Starting program: /usr/local/mysql/libexec/mysqld --gdb [Thread debugging using libthread_db enabled] [New Thread 0xb7ddfb70 (LWP 24789)] [Thread 0xb7ddfb70 (LWP 24789) exited] 091128 23:17:20 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead. 091128 23:17:20 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 091128 23:17:20 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys' [New Thread 0xb7ddfb70 (LWP 24790)] [New Thread 0x72799b70 (LWP 24791)] [New Thread 0x71f98b70 (LWP 24792)] [New Thread 0x71797b70 (LWP 24793)] InnoDB: Log scan progressed past the checkpoint lsn 21 3049364088 091128 23:17:21 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: Doing recovery: scanned up to log sequence number 21 3049941951 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 892204 row operations to undo InnoDB: Trx id counter is 0 705024 091128 23:17:22 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 1472705. InnoDB: You may have to recover from a backup. 091128 23:17:22 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex <<< snipped; please email mysql@barillari.org if you would like it >>> 091128 23:17:22 InnoDB: Page checksum 125329116, prior-to-4.0.14-form checksum 707139577 InnoDB: stored checksum 431743609, prior-to-4.0.14-form stored checksum 742971059 InnoDB: Page lsn 21 3049098859, low 4 bytes of lsn at page end 3049675044 InnoDB: Page number (if stored to page already) 1472705, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be an index page where index id is 0 636 InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 1472705. InnoDB: You may have to recover from a backup. InnoDB: It is also possible that your operating InnoDB: system has corrupted its own file cache InnoDB: and rebooting your computer removes the InnoDB: error. InnoDB: If the corrupt page is an index page InnoDB: you can also try to fix the corruption InnoDB: by dumping, dropping, and reimporting InnoDB: the corrupt table. You can use CHECK InnoDB: TABLE to scan your table for corruption. InnoDB: See also http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x71f98b70 (LWP 24792)] page_rec_find_owner_rec (cursor=0x71f97d7c, tuple=0x0, index=0xb5a9f468, rec=0x71f977e8 "", offsets=0x71f97be8, mtr=0x71f97e70) at ../../storage/innobase/include/page0page.ic:682 682 while (rec_get_n_owned(rec, TRUE) == 0) { Current language: auto The current source language is "auto; currently c". (gdb) backtrace #0 page_rec_find_owner_rec (cursor=0x71f97d7c, tuple=0x0, index=0xb5a9f468, rec=0x71f977e8 "", offsets=0x71f97be8, mtr=0x71f97e70) at ../../storage/innobase/include/page0page.ic:682 #1 page_cur_insert_rec_low (cursor=0x71f97d7c, tuple=0x0, index=0xb5a9f468, rec=0x71f977e8 "", offsets=0x71f97be8, mtr=0x71f97e70) at page/page0cur.c:1044 #2 0x0842522b in page_cur_rec_insert (is_short=0, ptr=0x756fbb07 "\251", , end_ptr=0x756fbb09 "", index=0xb5a9f468, page=0x75994000 "\031\273\342y", mtr=0x71f97e70) at ../../storage/innobase/include/page0cur.ic:207 #3 page_cur_parse_insert_rec (is_short=0, ptr=0x756fbb07 "\251", , end_ptr=0x756fbb09 "", index=0xb5a9f468, page=0x75994000 "\031\273\342y", mtr=0x71f97e70) at page/page0cur.c:889 #4 0x08412ca5 in recv_parse_or_apply_log_rec_body (type=38 '&', ptr=0x756fbb04 "-\234\004\251", , end_ptr=0x756fbb09 "", page=0x75994000 "\031\273\342y", mtr=0x71f97e70) at log/log0recv.c:813 #5 0x084148db in recv_recover_page (recover_backup=0, just_read_in=1, page=0x75994000 "\031\273\342y", space=0, page_no=1472705) at log/log0recv.c:1288 #6 0x083d5761 in buf_page_io_complete (block=0x73ba1d84) at buf/buf0buf.c:2032 #7 0x083eccde in fil_aio_wait (segment=2) at fil/fil0fil.c:4270 #8 0x084527b8 in io_handler_thread (arg=0x8747de8) at srv/srv0start.c:435 #9 0xb7fb47f5 in start_thread () from /lib/i686/cmov/libpthread.so.0 #10 0xb7ead05e in clone () from /lib/i686/cmov/libc.so.6 (gdb) info local No locals. (gdb) up #1 page_cur_insert_rec_low (cursor=0x71f97d7c, tuple=0x0, index=0xb5a9f468, rec=0x71f977e8 "", offsets=0x71f97be8, mtr=0x71f97e70) at page/page0cur.c:1044 1044 owner_rec = page_rec_find_owner_rec(insert_rec); (gdb) info local insert_buf = rec_size = 15 last_insert = insert_rec = 0x0 heap_no = 773 current_rec = 0x75996d9c "\217\262", next_rec = owner_slot = owner_rec = n_owned = heap = 0x0 comp = 32768 (gdb) up #2 0x0842522b in page_cur_rec_insert (is_short=0, ptr=0x756fbb07 "\251", , end_ptr=0x756fbb09 "", index=0xb5a9f468, page=0x75994000 "\031\273\342y", mtr=0x71f97e70) at ../../storage/innobase/include/page0cur.ic:207 207 return(page_cur_insert_rec_low(cursor, NULL, index, rec, (gdb) info local No locals. (gdb) up #3 page_cur_parse_insert_rec (is_short=0, ptr=0x756fbb07 "\251", , end_ptr=0x756fbb09 "", index=0xb5a9f468, page=0x75994000 "\031\273\342y", mtr=0x71f97e70) at page/page0cur.c:889 889 page_cur_rec_insert(&cursor, buf + origin_offset, index, offsets, mtr); (gdb) info local extra_info_yes = 0 offset = 11676 origin_offset = 6 end_seg_len = 2 mismatch_index = 13 cursor_rec = 0x75996d9c "\217\262", buf1 = "\000\000\030 \000\017\217\262\365\000\000\016\253\251\360j\032\240\000\000\016\253\256v\000\026v\035", '\000' , "+\t\000\000\000\377\377\377\377w\300\210u\000\000e\265\000\000euh\270\250\265\000\000\000\000\030\000\000\000\304{\371q\002\000\000pp\000\000\000p\300\210u\000\300\210uh}\371q\263\225B\bp\300\210uh\364\251\265\274{\371q\377\377\377\377L}\371q\033\210_\b\033\003", '\000' , "\032", '\000' , "~\300\210u\001\000\000\000p\300\210u\274{\371q\000\200\000\000\005", '\000' "\300, \210u*\300\210u+\300\210u\326\375\210u\004\200\255\373\000\300\210u*\300\210u+\300\210u\220[\371q\237[\371q\220{\371q\327=\000\000\000\000\000\000\000\000\000\000d\000\000\000d\000\000\000\004\200\255\373\006\000\000\200\003\000\000\000\000\000\000\000\300[\371q\302[\000q", '\000' buf = 0x71f977e8 "" info_and_status_bits = 0 cursor = {rec = 0x75996d9c "\217\262", } heap = 0x0 offsets_ = {100, 2, 2147483654, 3, 9, 0, 3086707671, 1912167466, 3086712777, 0, 3086707671, 3085965303, 24792, 141862464, 3086707671, 148, 3086712777, 139437196, 3086707671, 3086708257, 24792, 141985300, 0, 9, 1912175736, 139437196, 141985300, 3047812344, 24792, 0, 141985300, 9, 1912175768, 139437645, 3047814168, 141985280, 1912175768, 138547249, 141985300, 140477645, 708, 0, 141985280, 9, 1912175832, 138514847, 141985300, 1, 140430692, 43, 141985300, 140477645, 3047812652, 138848156, 3047814188, 3047812652, 8, 3047814184, 400, 3047812648, 1912175864, 138510784, 3047814188, 3047812652, 1912175912, 138327724, 8, 140441178, 12, 8388610, 3047813288, 12, 22, 138276382, 3047814248, 0, 0, 3047795752, 3047812200, 3047814248, 1912175960, 138276994, 3047812200, 3047795752, 140441178, 8, 258, 7, 0, 2, 2, 3047812200, 1912176024, 138517037, 3047812200, 3047795752, 3047812480, 0, 0, 6} offsets = 0x71f97be8 (gdb) up #4 0x08412ca5 in recv_parse_or_apply_log_rec_body (type=38 '&', ptr=0x756fbb04 "-\234\004\251", , end_ptr=0x756fbb09 "", page=0x75994000 "\031\273\342y", mtr=0x71f97e70) at log/log0recv.c:813 813 ptr = page_cur_parse_insert_rec(FALSE, ptr, end_ptr, (gdb) info local index = 0x75994000 (gdb) up #5 0x084148db in recv_recover_page (recover_backup=0, just_read_in=1, page=0x75994000 "\031\273\342y", space=0, page_no=1472705) at log/log0recv.c:1288 1288 recv_parse_or_apply_log_rec_body(recv->type, buf, (gdb) info local block = 0x73ba1d84 recv_addr = 0x756fbad8 recv = 0x756fbab0 buf = 0x756fbafc "" modification_to_page = 1 success = mtr = {state = 0, memo = {heap = 0x0, used = 8, data = "\002\000\000\000\204\035\272s", '\000' , base = {count = 3084806080, start = 0xd696910, end = 0x71f980c0}, list = { prev = 0xb7feba50, next = 0xb7df4766}}, log = {heap = 0x0, used = 0, data = "\364\037\362\267\000\000\000\000\210\236\371\267\002\000\371q\320\021\377\267\024\350\n\b|\232\371\267\364\357\377\267\370;\336\267\a\000\000\000\060\201\371qu\275\376\267\222\371\344\267\000\000\000\000\327k\373\267\003\000\000\000\311\177\373\267\240]\336\267\350\264\377\267\374\200\371q\027\000\000\000L\325\325\006\\\236\371\267\227\251\272\332\t", '\000' , "\005\000\000\000\242\000\000\000\210\236\371\267Ț\371\267o\350\n\b`\356\336\267H\202\a\b\001\000\000\000\364\357\377\267\020\202\371q(\370\377\267\344\201\371qٿ\376\267ԁ\371qH\202\a\bȁ\371q\314\367\377\267\000\000\000\000\210\236\371\267\005\000\000\000\000\000\000\000\001\000\000\000\214\244O\b\310\017\323\t\240\201\371q\001\000\000\000q\245\346\267\070\336t\b \330t\b\001\000\000\000 \330t\b\364\037\362\267\263\000\000\000\001\000\000\000\300\201\371q\260\262\346\267<\336t\b\346\217\346\267v\002\000\000\355\377\377\377\000\000\000\000\331\a\000\000\331\a\000\000\320\a\000\000\364\037\362\267\064\202\371q`\202\371q\360\201\371q\210\257\346\267`\202\371q\260\271\377\377\064\202\371q܁\371q\374\201\371q`\202\371q\000@\231u\371\027&*\b\202\371q\177\216\342\267\b\202\371qL\226\346\267\177\216\342\267`%\362\267^(`\b\030\202\371qh\202\371qi\266F\b`%\362\267^(`"..., base = {count = 0, start = 0x85ee05c, end = 0x9d32da0}, list = {prev = 0x0, next = 0xb7f21ff4}}, modifications = 0, n_log_recs = 0, log_mode = 22, start_lsn = { high = 3085165562, low = 3086099808}, end_lsn = {high = 140435548, low = 501}, magic_n = 1912179568} (gdb) up #6 0x083d5761 in buf_page_io_complete (block=0x73ba1d84) at buf/buf0buf.c:2032 2032 recv_recover_page(FALSE, TRUE, block->frame, (gdb) info local read_page_no = 1472705 read_space_id = 0 io_type = 561 (gdb) up #7 0x083eccde in fil_aio_wait (segment=2) at fil/fil0fil.c:4270 4270 buf_page_io_complete(message); (gdb) info local system = 0xb5a8b668 ret = fil_node = 0xb5a8e468 message = 0x73ba1d84 type = 10 (gdb) up #8 0x084527b8 in io_handler_thread (arg=0x8747de8) at srv/srv0start.c:435 435 fil_aio_wait(segment); (gdb) info local segment = 2 (gdb) q A debugging session is active. Inferior 1 [process 24786] will be killed. Quit anyway? (y or n) y slim:/usr/local/mysql# exit Script done on Sat 28 Nov 2009 11:18:21 PM EST