Created
November 20, 2012 17:55
-
-
Save marcomorain/4119620 to your computer and use it in GitHub Desktop.
MySQL Crash
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
121120 17:54:55 InnoDB: Assertion failure in thread 4507598848 in file row0sel.c line 2441 | |
InnoDB: Failing assertion: buf + data_len <= original_buf + buf_len | |
InnoDB: We intentionally generate a memory trap. | |
InnoDB: Submit a detailed bug report to http://bugs.mysql.com. | |
InnoDB: If you get repeated assertion failures or crashes, even | |
InnoDB: immediately after the mysqld startup, there may be | |
InnoDB: corruption in the InnoDB tablespace. Please refer to | |
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html | |
InnoDB: about forcing recovery. | |
17:54:55 UTC - mysqld got signal 6 ; | |
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 = 338482 K bytes of memory | |
Hope that's ok; if not, decrease some variables in the equation. | |
Thread pointer: 0x10f000000 | |
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 = 10cac7eb8 thread_stack 0x40000 | |
0 mysqld 0x00000001002326f2 my_print_stacktrace + 53 | |
1 mysqld 0x0000000100032e8b handle_fatal_signal + 706 | |
2 libsystem_c.dylib 0x00007fff905388ea _sigtramp + 26 | |
3 ??? 0x0000000000000000 0x0 + 0 | |
4 libsystem_c.dylib 0x00007fff9058fdce abort + 143 | |
5 mysqld 0x00000001002cc224 row_sel_convert_mysql_key_to_innobase + 777 | |
6 mysqld 0x00000001002af061 _ZN11ha_innobase16records_in_rangeEjP12st_key_rangeS1_ + 421 | |
7 mysqld 0x00000001000d4229 _ZL16check_quick_keysP5PARAMjP7SEL_ARGPhjiS3_ji + 1528 | |
8 mysqld 0x00000001000d3eec _ZL16check_quick_keysP5PARAMjP7SEL_ARGPhjiS3_ji + 699 | |
9 mysqld 0x00000001000d3eec _ZL16check_quick_keysP5PARAMjP7SEL_ARGPhjiS3_ji + 699 | |
10 mysqld 0x00000001000d3eec _ZL16check_quick_keysP5PARAMjP7SEL_ARGPhjiS3_ji + 699 | |
11 mysqld 0x00000001000d3eec _ZL16check_quick_keysP5PARAMjP7SEL_ARGPhjiS3_ji + 699 | |
12 mysqld 0x00000001000d3ccf _ZL16check_quick_keysP5PARAMjP7SEL_ARGPhjiS3_ji + 158 | |
13 mysqld 0x00000001000d4414 _ZL18check_quick_selectP5PARAMjP7SEL_ARGb + 272 | |
14 mysqld 0x00000001000d57d1 _ZL20get_key_scans_paramsP5PARAMP8SEL_TREEbbd + 243 | |
15 mysqld 0x00000001000de15e _ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyyb + 5470 | |
16 mysqld 0x0000000100181029 _ZL20make_join_statisticsP4JOINP10TABLE_LISTP4ItemP16st_dynamic_array + 5168 | |
17 mysqld 0x0000000100187038 _ZN4JOIN8optimizeEv + 1320 | |
18 mysqld 0x000000010018a846 _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 483 | |
19 mysqld 0x000000010018f305 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 | |
20 mysqld 0x000000010014ff56 _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 | |
21 mysqld 0x0000000100153187 _Z21mysql_execute_commandP3THD + 2037 | |
22 mysqld 0x0000000100157265 _Z11mysql_parseP3THDPcjP12Parser_state + 298 | |
23 mysqld 0x0000000100157a2e _Z16dispatch_command19enum_server_commandP3THDPcj + 1815 | |
24 mysqld 0x00000001001586ba _Z10do_commandP3THD + 257 | |
25 mysqld 0x00000001001e7075 _Z24do_handle_one_connectionP3THD + 256 | |
26 mysqld 0x00000001001e7155 handle_one_connection + 84 | |
27 libsystem_c.dylib 0x00007fff9054a742 _pthread_start + 327 | |
28 libsystem_c.dylib 0x00007fff90537181 thread_start + 13 | |
Trying to get some variables. | |
Some pointers may be invalid and cause the dump to abort. | |
Query (10c000010): SELECT `install_tracking_results`.* FROM `install_tracking_results` WHERE `install_tracking_results`.`game_id` IN (1, 2, 3) AND `install_tracking_results`.`target_game_id` = 2 AND `install_tracking_results`.`segment_id` = 'default_segment' AND `install_tracking_results`.`category` = 'clickthru' AND `install_tracking_results`.`source` IN ('test') AND (`install_tracking_results`.`time` BETWEEN 'D-2012-10-10' AND 'D-2012-10-11') | |
Connection ID (thread ID): 1 | |
Status: NOT_KILLED | |
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains | |
information that should help you find out what is causing the crash. | |
121120 17:54:55 mysqld_safe mysqld restarted | |
121120 17:54:55 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive | |
121120 17:54:55 [Note] Plugin 'FEDERATED' is disabled. | |
121120 17:54:55 InnoDB: The InnoDB memory heap is disabled | |
121120 17:54:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
121120 17:54:55 InnoDB: Compressed tables use zlib 1.2.3 | |
121120 17:54:55 InnoDB: Initializing buffer pool, size = 128.0M | |
121120 17:54:55 InnoDB: Completed initialization of buffer pool | |
121120 17:54:55 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! | |
121120 17:54:55 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... | |
121120 17:54:55 InnoDB: Waiting for the background threads to start | |
121120 17:54:56 InnoDB: 1.1.8 started; log sequence number 65930925 | |
121120 17:54:56 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 | |
121120 17:54:56 [Note] - '0.0.0.0' resolves to '0.0.0.0'; | |
121120 17:54:56 [Note] Server socket created on IP: '0.0.0.0'. | |
121120 17:54:56 [Note] Event Scheduler: Loaded 0 events | |
121120 17:54:56 [Note] /usr/local/mysql/bin/mysqld: ready for connections. | |
Version: '5.5.28' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment