MySQL Forums
Forum List  »  InnoDB

Re: Database corruption
Posted by: Francisco Vega
Date: August 02, 2011 08:04PM

110728 21:00:06 InnoDB: Page checksum 1659718047, prior-to-4.0.14-form checksum 2135894816
InnoDB: stored checksum 1659718047, prior-to-4.0.14-form stored checksum 2135894816
InnoDB: Page lsn 57 2654465461, low 4 bytes of lsn at page end 2654465461
InnoDB: Page number (if stored to page already) 51,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be an insert undo log page
InnoDB: Page directory corruption: supremum not pointed to
110728 21:00:06 InnoDB: Page dump in ascii and hex (16384 bytes):


110728 21:00:06 InnoDB: Page checksum 1659718047, prior-to-4.0.14-form checksum 2135894816
InnoDB: stored checksum 1659718047, prior-to-4.0.14-form stored checksum 2135894816
InnoDB: Page lsn 57 2654465461, low 4 bytes of lsn at page end 2654465461
InnoDB: Page number (if stored to page already) 51,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be an insert undo log page
110728 21:00:06 - mysqld got signal 11 ;
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=16777216
read_buffer_size=131072
max_used_connections=292
max_threads=370
threads_connected=23
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 825267 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x7fc44501f1e0
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 = 0x7fc478f35e58 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7fc47968d169]
/usr/sbin/mysqld(handle_segfault+0x404) [0x7fc47939a884]
/lib/libpthread.so.0(+0xf8f0) [0x7fc478c0b8f0]
/usr/sbin/mysqld(rec_get_offsets_func+0x44) [0x7fc4795cfd74]
/usr/sbin/mysqld(page_cur_search_with_match+0x5b0) [0x7fc4795bf800]
/usr/sbin/mysqld(btr_cur_search_to_nth_level+0x629) [0x7fc47955c479]
/usr/sbin/mysqld(row_ins_index_entry_low+0x13b) [0x7fc4795d3a2b]
/usr/sbin/mysqld(row_ins+0x18f) [0x7fc4795d4f1f]
/usr/sbin/mysqld(row_ins_step+0x129) [0x7fc4795d5289]
/usr/sbin/mysqld(row_insert_for_mysql+0x388) [0x7fc4795dc398]
/usr/sbin/mysqld(ha_innobase::write_row(unsigned char*)+0xe7) [0x7fc479550a27]
/usr/sbin/mysqld(handler::ha_write_row(unsigned char*)+0x86) [0x7fc479497476]
/usr/sbin/mysqld(write_record(THD*, st_table*, st_copy_info*)+0x3b8) [0x7fc47941f378]
/usr/sbin/mysqld(select_insert::send_data(List<Item>&)+0x9c) [0x7fc47941f8ec]


I hope with this could be enough.

Thanks for your time.

Options: ReplyQuote


Subject
Views
Written By
Posted
2233
August 02, 2011 01:29PM
976
August 02, 2011 01:51PM
2379
August 02, 2011 02:00PM
1262
August 02, 2011 02:48PM
2068
August 02, 2011 04:19PM
1164
August 02, 2011 05:23PM
1174
August 02, 2011 06:04PM
1068
August 02, 2011 06:17PM
Re: Database corruption
1897
August 02, 2011 08:04PM
1148
August 02, 2011 08:43PM
1243
August 03, 2011 06:34AM
1241
August 28, 2011 05:25AM
995
August 02, 2011 02:15PM


Sorry, you can't reply to this topic. It has been closed.

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.