Sep 9 07:32:59 mysql mysqld: 04:32:59 UTC - mysqld got signal 11 ; Sep 9 07:32:59 mysql mysqld: This could be because you hit a bug. It is also possible that this binary Sep 9 07:32:59 mysql mysqld: or one of the libraries it was linked against is corrupt, improperly built, Sep 9 07:32:59 mysql mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Sep 9 07:32:59 mysql mysqld: We will try our best to scrape up some info that will hopefully help Sep 9 07:32:59 mysql mysqld: diagnose the problem, but since we have already crashed, Sep 9 07:32:59 mysql mysqld: something is definitely wrong and this may fail. Sep 9 07:32:59 mysql mysqld: Sep 9 07:32:59 mysql mysqld: key_buffer_size=16777216 Sep 9 07:32:59 mysql mysqld: read_buffer_size=131072 Sep 9 07:32:59 mysql mysqld: max_used_connections=110 Sep 9 07:32:59 mysql mysqld: max_threads=151 Sep 9 07:32:59 mysql mysqld: thread_count=68 Sep 9 07:32:59 mysql mysqld: connection_count=68 Sep 9 07:32:59 mysql mysqld: It is possible that mysqld could use up to Sep 9 07:32:59 mysql mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346521 K bytes of memory Sep 9 07:32:59 mysql mysqld: Hope that's ok; if not, decrease some variables in the equation. Sep 9 07:32:59 mysql mysqld: Sep 9 07:32:59 mysql mysqld: Thread pointer: 0x7f96882e9470 Sep 9 07:32:59 mysql mysqld: Attempting backtrace. You can use the following information to find out Sep 9 07:32:59 mysql mysqld: where mysqld died. If you see no messages after this, something went Sep 9 07:32:59 mysql mysqld: terribly wrong... Sep 9 07:32:59 mysql mysqld: stack_bottom = 7f9697a20e88 thread_stack 0x30000 Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7f98d173e689] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x483) [0x7f98d1552a53] Sep 9 07:32:59 mysql mysqld: /lib/libpthread.so.0(+0xeff0) [0x7f98d0ca4ff0] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(rec_get_offsets_func+0x169) [0x7f98d1680579] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(page_copy_rec_list_end_to_created_page+0x275) [0x7f98d166f6d5] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(page_copy_rec_list_end+0x15d) [0x7f98d1676e0d] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(page_move_rec_list_end+0x86) [0x7f98d1677b36] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(btr_page_split_and_insert+0x9a8) [0x7f98d16c6128] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(btr_cur_pessimistic_insert+0x197) [0x7f98d16091d7] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(+0x57c5ee) [0x7f98d164e5ee] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(ibuf_insert+0x121) [0x7f98d164ea71] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(btr_cur_search_to_nth_level+0x3b9) [0x7f98d160d739] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(row_ins_index_entry_low+0x13b) [0x7f98d168411b] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(row_ins+0x18f) [0x7f98d168559f] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(row_ins_step+0x129) [0x7f98d1685909] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(row_insert_for_mysql+0x388) [0x7f98d1687378] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(ha_innobase::write_row(unsigned char*)+0xe3) [0x7f98d16039d3] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(handler::ha_write_row(unsigned char*)+0x68) [0x7f98d1544dc8] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(write_record(THD*, st_table*, st_copy_info*)+0x6c) [0x7f98d14caaac] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool)+0xede) [0x7f98d14ceabe] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0xbd9) [0x7f98d14572d9] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x3fb) [0x7f98d145c1fb] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x115a) [0x7f98d145d36a] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(do_command(THD*)+0xea) [0x7f98d145dcaa] Sep 9 07:32:59 mysql mysqld: /usr/sbin/mysqld(handle_one_connection+0x236) [0x7f98d144f796] Sep 9 07:32:59 mysql mysqld: /lib/libpthread.so.0(+0x68ca) [0x7f98d0c9c8ca] Sep 9 07:32:59 mysql mysqld: /lib/libc.so.6(clone+0x6d) [0x7f98cf7e492d] Sep 9 07:32:59 mysql mysqld: Sep 9 07:32:59 mysql mysqld: Trying to get some variables. Sep 9 07:32:59 mysql mysqld: Some pointers may be invalid and cause the dump to abort. Sep 9 07:32:59 mysql mysqld: Query (7f968c0ca8b0): is an invalid pointer Sep 9 07:32:59 mysql mysqld: Connection ID (thread ID): 5081837 Sep 9 07:32:59 mysql mysqld: Status: NOT_KILLED Sep 9 07:32:59 mysql mysqld: Sep 9 07:32:59 mysql mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Sep 9 07:32:59 mysql mysqld: information that should help you find out what is causing the crash. Sep 9 07:33:00 mysql mysqld_safe: Number of processes running now: 0 Sep 9 07:33:00 mysql mysqld_safe: mysqld restarted Sep 9 07:33:00 mysql mysqld: 120909 4:33:00 [Note] Plugin 'FEDERATED' is disabled. Sep 9 07:33:00 mysql mysqld: 120909 4:33:00 InnoDB: Initializing buffer pool, size = 8.0G Sep 9 07:33:01 mysql mysqld: 120909 4:33:01 InnoDB: Completed initialization of buffer pool Sep 9 07:33:01 mysql mysqld: InnoDB: Log scan progressed past the checkpoint lsn 69 2336905034 Sep 9 07:33:01 mysql mysqld: 120909 4:33:01 InnoDB: Database was not shut down normally! Sep 9 07:33:01 mysql mysqld: InnoDB: Starting crash recovery. Sep 9 07:33:01 mysql mysqld: InnoDB: Reading tablespace information from the .ibd files... Sep 9 07:33:03 mysql mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite Sep 9 07:33:03 mysql mysqld: InnoDB: buffer... Sep 9 07:33:03 mysql mysqld: InnoDB: Doing recovery: scanned up to log sequence number 69 2342147584 Sep 9 07:33:03 mysql mysqld: InnoDB: Doing recovery: scanned up to log sequence number 69 2343670693 Sep 9 07:33:03 mysql mysqld: InnoDB: 1 transaction(s) which must be rolled back or cleaned up Sep 9 07:33:03 mysql mysqld: InnoDB: in total 1 row operations to undo Sep 9 07:33:03 mysql mysqld: InnoDB: Trx id counter is 0 1497251840 Sep 9 07:33:03 mysql mysqld: 120909 4:33:03 InnoDB: Starting an apply batch of log records to the database... Sep 9 07:33:10 mysql mysqld: InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Sep 9 07:33:10 mysql mysqld: InnoDB: Apply batch completed Sep 9 07:33:10 mysql mysqld: InnoDB: Starting in background the rollback of uncommitted transactions Sep 9 07:33:10 mysql mysqld: 120909 4:33:10 InnoDB: Rolling back trx with id 0 1497251450, 1 rows to undo Sep 9 07:33:10 mysql mysqld: 120909 4:33:10 InnoDB: Started; log sequence number 69 2343670693 Sep 9 07:33:10 mysql mysqld: InnoDB: Error: trying to access page number 981078925 in space 0, Sep 9 07:33:10 mysql mysqld: InnoDB: space name ./ibdata1, Sep 9 07:33:10 mysql mysqld: InnoDB: which is outside the tablespace bounds. Sep 9 07:33:10 mysql mysqld: InnoDB: Byte offset 0, len 16384, i/o type 10. Sep 9 07:33:10 mysql mysqld: InnoDB: If you get this error at mysqld startup, please check that Sep 9 07:33:10 mysql mysqld: InnoDB: your my.cnf matches the ibdata files that you have in the Sep 9 07:33:10 mysql mysqld: InnoDB: MySQL server. Sep 9 07:33:10 mysql mysqld: 120909 4:33:10 InnoDB: Assertion failure in thread 139785594218240 in file ../../../storage/innobase/fil/fil0fil.c line 4135 Sep 9 07:33:10 mysql mysqld: InnoDB: We intentionally generate a memory trap. Sep 9 07:33:10 mysql mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Sep 9 07:33:10 mysql mysqld: InnoDB: If you get repeated assertion failures or crashes, even Sep 9 07:33:10 mysql mysqld: InnoDB: immediately after the mysqld startup, there may be Sep 9 07:33:10 mysql mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to Sep 9 07:33:10 mysql mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html Sep 9 07:33:10 mysql mysqld: InnoDB: about forcing recovery. Sep 9 07:33:10 mysql mysqld: 04:33:10 UTC - mysqld got signal 6 ; Sep 9 07:33:10 mysql mysqld: This could be because you hit a bug. It is also possible that this binary Sep 9 07:33:10 mysql mysqld: or one of the libraries it was linked against is corrupt, improperly built, Sep 9 07:33:10 mysql mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Sep 9 07:33:10 mysql mysqld: We will try our best to scrape up some info that will hopefully help Sep 9 07:33:10 mysql mysqld: diagnose the problem, but since we have already crashed, Sep 9 07:33:10 mysql mysqld: something is definitely wrong and this may fail. Sep 9 07:33:10 mysql mysqld: Sep 9 07:33:10 mysql mysqld: key_buffer_size=16777216 Sep 9 07:33:10 mysql mysqld: read_buffer_size=131072 Sep 9 07:33:10 mysql mysqld: max_used_connections=0 Sep 9 07:33:10 mysql mysqld: max_threads=151 Sep 9 07:33:10 mysql mysqld: thread_count=0 Sep 9 07:33:10 mysql mysqld: connection_count=0 Sep 9 07:33:10 mysql mysqld: It is possible that mysqld could use up to Sep 9 07:33:10 mysql mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346521 K bytes of memory Sep 9 07:33:10 mysql mysqld: Hope that's ok; if not, decrease some variables in the equation. Sep 9 07:33:10 mysql mysqld: Sep 9 07:33:10 mysql mysqld: Thread pointer: 0x0 Sep 9 07:33:10 mysql mysqld: Attempting backtrace. You can use the following information to find out Sep 9 07:33:10 mysql mysqld: where mysqld died. If you see no messages after this, something went Sep 9 07:33:10 mysql mysqld: terribly wrong... Sep 9 07:33:10 mysql mysqld: stack_bottom = 0 thread_stack 0x30000 Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7f2494f5c689] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x483) [0x7f2494d70a53] Sep 9 07:33:10 mysql mysqld: /lib/libpthread.so.0(+0xeff0) [0x7f24944c2ff0] Sep 9 07:33:10 mysql mysqld: /lib/libc.so.6(gsignal+0x35) [0x7f2492f651b5] Sep 9 07:33:10 mysql mysqld: /lib/libc.so.6(abort+0x180) [0x7f2492f67fc0] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(fil_io+0x4b0) [0x7f2494e581d0] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(+0x54dc63) [0x7f2494e3dc63] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(buf_read_page+0x22d) [0x7f2494e3e6ad] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(buf_page_get_gen+0x393) [0x7f2494e37d83] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(flst_insert_before+0x25e) [0x7f2494e631ae] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(btr_compress+0x585) [0x7f2494ee7d45] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(btr_cur_compress_if_useful+0xfd) [0x7f2494e258dd] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(btr_cur_pessimistic_delete+0x2cd) [0x7f2494e266fd] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(+0x57a019) [0x7f2494e6a019] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(ibuf_merge_or_delete_for_page+0x80d) [0x7f2494e6af0d] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(buf_page_io_complete+0x2be) [0x7f2494e3762e] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(+0x54dd25) [0x7f2494e3dd25] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(buf_read_page+0x22d) [0x7f2494e3e6ad] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(buf_page_get_gen+0x393) [0x7f2494e37d83] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(btr_cur_search_to_nth_level+0x464) [0x7f2494e2b7e4] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(row_search_index_entry+0x5b) [0x7f2494eac65b] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(+0x6046ee) [0x7f2494ef46ee] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(row_undo_ins+0x10d) [0x7f2494ef49fd] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(row_undo_step+0x256) [0x7f2494eb5df6] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(que_run_threads+0x4fe) [0x7f2494e98e1e] Sep 9 07:33:10 mysql mysqld: /usr/sbin/mysqld(trx_rollback_or_clean_all_without_sess+0x367) [0x7f2494ed1ad7] Sep 9 07:33:10 mysql mysqld: /lib/libpthread.so.0(+0x68ca) [0x7f24944ba8ca] Sep 9 07:33:10 mysql mysqld: /lib/libc.so.6(clone+0x6d) [0x7f249300292d] Sep 9 07:33:10 mysql mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Sep 9 07:33:10 mysql mysqld: information that should help you find out what is causing the crash. Sep 9 07:33:10 mysql mysqld_safe: Number of processes running now: 0 Sep 9 07:33:10 mysql mysqld_safe: mysqld restarted Sep 9 07:33:10 mysql mysqld: 120909 4:33:10 [Note] Plugin 'FEDERATED' is disabled. Sep 9 07:33:10 mysql mysqld: 120909 4:33:10 InnoDB: Initializing buffer pool, size = 8.0G Sep 9 07:33:11 mysql mysqld: 120909 4:33:11 InnoDB: Completed initialization of buffer pool Sep 9 07:33:11 mysql mysqld: InnoDB: Log scan progressed past the checkpoint lsn 69 2336905237 Sep 9 07:33:11 mysql mysqld: 120909 4:33:11 InnoDB: Database was not shut down normally! Sep 9 07:33:11 mysql mysqld: InnoDB: Starting crash recovery. Sep 9 07:33:11 mysql mysqld: InnoDB: Reading tablespace information from the .ibd files... Sep 9 07:33:11 mysql mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite Sep 9 07:33:11 mysql mysqld: InnoDB: buffer... Sep 9 07:33:11 mysql mysqld: InnoDB: Doing recovery: scanned up to log sequence number 69 2342148096 Sep 9 07:33:11 mysql mysqld: InnoDB: Doing recovery: scanned up to log sequence number 69 2343670693 Sep 9 07:33:11 mysql mysqld: InnoDB: 1 transaction(s) which must be rolled back or cleaned up Sep 9 07:33:11 mysql mysqld: InnoDB: in total 1 row operations to undo Sep 9 07:33:11 mysql mysqld: InnoDB: Trx id counter is 0 1497251840 Sep 9 07:33:11 mysql mysqld: 120909 4:33:11 InnoDB: Starting an apply batch of log records to the database... Sep 9 07:33:17 mysql mysqld: InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Sep 9 07:33:17 mysql mysqld: InnoDB: Apply batch completed Sep 9 07:33:18 mysql mysqld: InnoDB: Starting in background the rollback of uncommitted transactions Sep 9 07:33:18 mysql mysqld: 120909 4:33:18 InnoDB: Rolling back trx with id 0 1497251450, 1 rows to undo Sep 9 07:33:18 mysql mysqld: 120909 4:33:18 InnoDB: Started; log sequence number 69 2343670693 Sep 9 07:33:18 mysql mysqld: InnoDB: Error: trying to access page number 981078925 in space 0, Sep 9 07:33:18 mysql mysqld: InnoDB: space name ./ibdata1, Sep 9 07:33:18 mysql mysqld: InnoDB: which is outside the tablespace bounds. Sep 9 07:33:18 mysql mysqld: InnoDB: Byte offset 0, len 16384, i/o type 10. Sep 9 07:33:18 mysql mysqld: InnoDB: If you get this error at mysqld startup, please check that Sep 9 07:33:18 mysql mysqld: InnoDB: your my.cnf matches the ibdata files that you have in the Sep 9 07:33:18 mysql mysqld: InnoDB: MySQL server. Sep 9 07:33:18 mysql mysqld: 120909 4:33:18 InnoDB: Assertion failure in thread 139976719886080 in file ../../../storage/innobase/fil/fil0fil.c line 4135 Sep 9 07:33:18 mysql mysqld: InnoDB: We intentionally generate a memory trap. Sep 9 07:33:18 mysql mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Sep 9 07:33:18 mysql mysqld: InnoDB: If you get repeated assertion failures or crashes, even Sep 9 07:33:18 mysql mysqld: InnoDB: immediately after the mysqld startup, there may be Sep 9 07:33:18 mysql mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to Sep 9 07:33:18 mysql mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html Sep 9 07:33:18 mysql mysqld: InnoDB: about forcing recovery. Sep 9 07:33:18 mysql mysqld: 04:33:18 UTC - mysqld got signal 6 ; Sep 9 07:33:18 mysql mysqld: This could be because you hit a bug. It is also possible that this binary Sep 9 07:33:18 mysql mysqld: or one of the libraries it was linked against is corrupt, improperly built, Sep 9 07:33:18 mysql mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Sep 9 07:33:18 mysql mysqld: We will try our best to scrape up some info that will hopefully help Sep 9 07:33:18 mysql mysqld: diagnose the problem, but since we have already crashed, Sep 9 07:33:18 mysql mysqld: something is definitely wrong and this may fail. Sep 9 07:33:18 mysql mysqld: Sep 9 07:33:18 mysql mysqld: key_buffer_size=16777216 Sep 9 07:33:18 mysql mysqld: read_buffer_size=131072 Sep 9 07:33:18 mysql mysqld: max_used_connections=0 Sep 9 07:33:18 mysql mysqld: max_threads=151 Sep 9 07:33:18 mysql mysqld: thread_count=0 Sep 9 07:33:18 mysql mysqld: connection_count=0 Sep 9 07:33:18 mysql mysqld: It is possible that mysqld could use up to Sep 9 07:33:18 mysql mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346521 K bytes of memory Sep 9 07:33:18 mysql mysqld: Hope that's ok; if not, decrease some variables in the equation. Sep 9 07:33:18 mysql mysqld: Sep 9 07:33:18 mysql mysqld: Thread pointer: 0x0 Sep 9 07:33:18 mysql mysqld: Attempting backtrace. You can use the following information to find out Sep 9 07:33:18 mysql mysqld: where mysqld died. If you see no messages after this, something went Sep 9 07:33:18 mysql mysqld: terribly wrong... Sep 9 07:33:18 mysql mysqld: stack_bottom = 0 thread_stack 0x30000 Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7f5114f00689] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x483) [0x7f5114d14a53] Sep 9 07:33:18 mysql mysqld: /lib/libpthread.so.0(+0xeff0) [0x7f5114466ff0] Sep 9 07:33:18 mysql mysqld: /lib/libc.so.6(gsignal+0x35) [0x7f5112f091b5] Sep 9 07:33:18 mysql mysqld: /lib/libc.so.6(abort+0x180) [0x7f5112f0bfc0] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(fil_io+0x4b0) [0x7f5114dfc1d0] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(+0x54dc63) [0x7f5114de1c63] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(buf_read_page+0x22d) [0x7f5114de26ad] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(buf_page_get_gen+0x393) [0x7f5114ddbd83] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(flst_insert_before+0x25e) [0x7f5114e071ae] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(btr_compress+0x585) [0x7f5114e8bd45] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(btr_cur_compress_if_useful+0xfd) [0x7f5114dc98dd] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(btr_cur_pessimistic_delete+0x2cd) [0x7f5114dca6fd] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(+0x57a019) [0x7f5114e0e019] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(ibuf_merge_or_delete_for_page+0x80d) [0x7f5114e0ef0d] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(buf_page_io_complete+0x2be) [0x7f5114ddb62e] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(+0x54dd25) [0x7f5114de1d25] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(buf_read_page+0x22d) [0x7f5114de26ad] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(buf_page_get_gen+0x393) [0x7f5114ddbd83] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(btr_cur_search_to_nth_level+0x464) [0x7f5114dcf7e4] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(row_search_index_entry+0x5b) [0x7f5114e5065b] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(+0x6046ee) [0x7f5114e986ee] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(row_undo_ins+0x10d) [0x7f5114e989fd] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(row_undo_step+0x256) [0x7f5114e59df6] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(que_run_threads+0x4fe) [0x7f5114e3ce1e] Sep 9 07:33:18 mysql mysqld: /usr/sbin/mysqld(trx_rollback_or_clean_all_without_sess+0x367) [0x7f5114e75ad7] Sep 9 07:33:18 mysql mysqld: /lib/libpthread.so.0(+0x68ca) [0x7f511445e8ca] Sep 9 07:33:18 mysql mysqld: /lib/libc.so.6(clone+0x6d) [0x7f5112fa692d] Sep 9 07:33:18 mysql mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Sep 9 07:33:18 mysql mysqld: information that should help you find out what is causing the crash. Sep 9 07:33:18 mysql mysqld_safe: Number of processes running now: 0 Sep 9 07:33:18 mysql mysqld_safe: mysqld restarted Sep 9 07:33:18 mysql mysqld: 120909 4:33:18 [Note] Plugin 'FEDERATED' is disabled. Sep 9 07:33:18 mysql mysqld: 120909 4:33:18 InnoDB: Initializing buffer pool, size = 8.0G Sep 9 07:33:18 mysql mysqld: 120909 4:33:18 InnoDB: Completed initialization of buffer pool Sep 9 07:33:18 mysql mysqld: InnoDB: Log scan progressed past the checkpoint lsn 69 2336905237 Sep 9 07:33:18 mysql mysqld: 120909 4:33:18 InnoDB: Database was not shut down normally! Sep 9 07:33:18 mysql mysqld: InnoDB: Starting crash recovery. Sep 9 07:33:18 mysql mysqld: InnoDB: Reading tablespace information from the .ibd files... Sep 9 07:33:18 mysql mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite Sep 9 07:33:18 mysql mysqld: InnoDB: buffer... Sep 9 07:33:19 mysql mysqld: InnoDB: Doing recovery: scanned up to log sequence number 69 2342148096 Sep 9 07:33:19 mysql mysqld: InnoDB: Doing recovery: scanned up to log sequence number 69 2343670693 Sep 9 07:33:19 mysql mysqld: InnoDB: 1 transaction(s) which must be rolled back or cleaned up Sep 9 07:33:19 mysql mysqld: InnoDB: in total 1 row operations to undo Sep 9 07:33:19 mysql mysqld: InnoDB: Trx id counter is 0 1497251840 Sep 9 07:33:19 mysql mysqld: 120909 4:33:19 InnoDB: Starting an apply batch of log records to the database... Sep 9 07:33:25 mysql mysqld: InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Sep 9 07:33:25 mysql mysqld: InnoDB: Apply batch completed Sep 9 07:33:25 mysql mysqld: InnoDB: Starting in background the rollback of uncommitted transactions Sep 9 07:33:25 mysql mysqld: 120909 4:33:25 InnoDB: Rolling back trx with id 0 1497251450, 1 rows to undo Sep 9 07:33:25 mysql mysqld: 120909 4:33:25 InnoDB: Started; log sequence number 69 2343670693 Sep 9 07:33:25 mysql mysqld: 120909 4:33:25 [Note] Event Scheduler: Loaded 0 events Sep 9 07:33:25 mysql mysqld: 120909 4:33:25 [Note] /usr/sbin/mysqld: ready for connections. Sep 9 07:33:25 mysql mysqld: Version: '5.1.63-0+squeeze1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) Sep 9 07:33:25 mysql mysqld: InnoDB: Error: trying to access page number 981078925 in space 0, Sep 9 07:33:25 mysql mysqld: InnoDB: space name ./ibdata1, Sep 9 07:33:25 mysql mysqld: InnoDB: which is outside the tablespace bounds. Sep 9 07:33:25 mysql mysqld: InnoDB: Byte offset 0, len 16384, i/o type 10. Sep 9 07:33:25 mysql mysqld: InnoDB: If you get this error at mysqld startup, please check that Sep 9 07:33:25 mysql mysqld: InnoDB: your my.cnf matches the ibdata files that you have in the Sep 9 07:33:25 mysql mysqld: InnoDB: MySQL server. Sep 9 07:33:25 mysql mysqld: 120909 4:33:25 InnoDB: Assertion failure in thread 139984616974080 in file ../../../storage/innobase/fil/fil0fil.c line 4135 Sep 9 07:33:25 mysql mysqld: InnoDB: We intentionally generate a memory trap. Sep 9 07:33:25 mysql mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Sep 9 07:33:25 mysql mysqld: InnoDB: If you get repeated assertion failures or crashes, even Sep 9 07:33:25 mysql mysqld: InnoDB: immediately after the mysqld startup, there may be Sep 9 07:33:25 mysql mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to Sep 9 07:33:25 mysql mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html Sep 9 07:33:25 mysql mysqld: InnoDB: about forcing recovery. Sep 9 07:33:25 mysql mysqld: 04:33:25 UTC - mysqld got signal 6 ;