110915 11:47:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110915 11:47:14 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110915 11:47:14 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110915 11:47:14 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 110915 11:47:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 110915 11:47:14 InnoDB: The InnoDB memory heap is disabled 110915 11:47:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110915 11:47:14 InnoDB: Compressed tables use zlib 1.2.3 110915 11:47:15 InnoDB: Initializing buffer pool, size = 256.0M 110915 11:47:15 InnoDB: Completed initialization of buffer pool 110915 11:47:15 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 110915 11:47:15 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110915 11:48:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110915 11:48:15 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110915 11:48:15 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110915 11:48:15 [Note] Plugin 'FEDERATED' is disabled. 110915 11:48:15 InnoDB: The InnoDB memory heap is disabled 110915 11:48:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110915 11:48:15 InnoDB: Compressed tables use zlib 1.2.3 110915 11:48:15 InnoDB: Initializing buffer pool, size = 256.0M 110915 11:48:16 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 110915 11:48:16 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 110915 11:48:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 110915 11:48:16 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: 127 rollback segment(s) active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 110915 11:48:16 InnoDB: Waiting for the background threads to start 110915 11:48:17 InnoDB: 1.1.8 started; log sequence number 0 110915 11:48:17 [Note] Event Scheduler: Loaded 0 events 110915 11:48:17 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110915 19:26:26 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110915 19:26:26 [Note] Event Scheduler: Purging the queue. 0 events 110915 19:26:26 InnoDB: Starting shutdown... 110915 19:26:27 InnoDB: Shutdown completed; log sequence number 765017837 110915 19:26:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110915 19:26:27 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110915 22:16:45 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110915 22:16:45 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110915 22:16:45 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110915 22:16:45 [Note] Plugin 'FEDERATED' is disabled. 110915 22:16:45 InnoDB: The InnoDB memory heap is disabled 110915 22:16:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110915 22:16:45 InnoDB: Compressed tables use zlib 1.2.3 110915 22:16:45 InnoDB: Initializing buffer pool, size = 256.0M 110915 22:16:45 InnoDB: Completed initialization of buffer pool 110915 22:16:45 InnoDB: highest supported file format is Barracuda. 110915 22:16:46 InnoDB: Waiting for the background threads to start 110915 22:16:47 InnoDB: 1.1.8 started; log sequence number 765017837 110915 22:16:48 [Note] Event Scheduler: Loaded 0 events 110915 22:16:48 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110916 0:30:00 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110916 0:30:00 [Note] Event Scheduler: Purging the queue. 0 events 110916 0:30:00 InnoDB: Starting shutdown... 110916 0:30:00 InnoDB: Shutdown completed; log sequence number 765017837 110916 0:30:00 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110916 00:30:00 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110916 08:51:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110916 8:51:49 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110916 8:51:49 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110916 8:51:49 [Note] Plugin 'FEDERATED' is disabled. 110916 8:51:49 InnoDB: The InnoDB memory heap is disabled 110916 8:51:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110916 8:51:49 InnoDB: Compressed tables use zlib 1.2.3 110916 8:51:49 InnoDB: Initializing buffer pool, size = 256.0M 110916 8:51:49 InnoDB: Completed initialization of buffer pool 110916 8:51:49 InnoDB: highest supported file format is Barracuda. 110916 8:51:52 InnoDB: Waiting for the background threads to start 110916 8:51:53 InnoDB: 1.1.8 started; log sequence number 765017837 110916 8:51:53 [Note] Event Scheduler: Loaded 0 events 110916 8:51:53 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110916 10:18:17 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110916 10:18:17 [Note] Event Scheduler: Purging the queue. 0 events 110916 10:18:17 InnoDB: Starting shutdown... 110916 10:18:17 InnoDB: Shutdown completed; log sequence number 765017837 110916 10:18:17 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110916 10:18:17 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110916 10:40:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110916 10:40:03 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110916 10:40:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110916 10:40:03 [Note] Plugin 'FEDERATED' is disabled. 110916 10:40:03 InnoDB: The InnoDB memory heap is disabled 110916 10:40:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110916 10:40:03 InnoDB: Compressed tables use zlib 1.2.3 110916 10:40:04 InnoDB: Initializing buffer pool, size = 256.0M 110916 10:40:04 InnoDB: Completed initialization of buffer pool 110916 10:40:04 InnoDB: highest supported file format is Barracuda. 110916 10:40:13 InnoDB: Waiting for the background threads to start 110916 10:40:14 InnoDB: 1.1.8 started; log sequence number 765017837 110916 10:40:14 [Note] Event Scheduler: Loaded 0 events 110916 10:40:14 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110916 13:57:00 - 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=402653184 read_buffer_size=1048576 max_used_connections=2 max_threads=500 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 = 1934872 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x134077400 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 = 0x136c46eb8 thread_stack 0x40000 0 mysqld 0x000000010022db0b my_print_stacktrace + 57 1 mysqld 0x00000001000c9087 handle_segfault + 557 2 libsystem_c.dylib 0x00007fff9035ecfa _sigtramp + 26 3 mysqld 0x00000001007eb0a0 my_charset_latin1 + 0 4 mysqld 0x0000000100177814 _ZN13st_join_table7cleanupEv + 118 5 mysqld 0x000000010017de6a _ZN4JOIN7cleanupEb + 106 6 mysqld 0x000000010017e699 _ZN4JOIN7destroyEv + 175 7 mysqld 0x00000001001b0ed2 _ZN13st_select_lex7cleanupEv + 36 8 mysqld 0x0000000100186ef6 _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 655 9 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 10 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 11 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 12 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 13 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 14 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 15 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 16 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 17 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 18 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 19 mysqld 0x00000001000754b7 _ZN12Item_func_sp7val_intEv + 17 20 mysqld 0x000000010003c757 _ZN4Item13save_in_fieldEP5Fieldb + 443 21 mysqld 0x0000000100054210 _ZL21convert_constant_itemP3THDP10Item_fieldPP4Item + 217 22 mysqld 0x0000000100057376 _ZN15Item_bool_func218fix_length_and_decEv + 336 23 mysqld 0x000000010006a884 _ZN9Item_func10fix_fieldsEP3THDPP4Item + 392 24 mysqld 0x0000000100119ffc _Z11setup_condsP3THDP10TABLE_LISTS2_PP4Item + 250 25 mysqld 0x000000010018c5b6 _Z19setup_without_groupP3THDPP4ItemP10TABLE_LISTS5_R4ListIS1_ES8_S3_P8st_orderSA_Pb + 120 26 mysqld 0x0000000100180ed7 _ZN4JOIN7prepareEPPP4ItemP10TABLE_LISTjS1_jP8st_orderS7_S1_S7_P13st_select_lexP18st_select_lex_unit + 563 27 mysqld 0x0000000100186e2c _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 453 28 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 29 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 30 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 31 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 32 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 33 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 34 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 35 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 36 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 37 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 38 mysqld 0x00000001000754b7 _ZN12Item_func_sp7val_intEv + 17 39 mysqld 0x000000010003c757 _ZN4Item13save_in_fieldEP5Fieldb + 443 40 mysqld 0x0000000100039317 _ZN4Item25save_in_field_no_warningsEP5Fieldb + 77 41 mysqld 0x00000001000d4310 _ZL12get_mm_partsP15RANGE_OPT_PARAMP4ItemP5FieldN9Item_func8FunctypeES2_11Item_result + 1858 42 mysqld 0x00000001000d9e3f _ZL11get_mm_treeP15RANGE_OPT_PARAMP4Item + 1167 43 mysqld 0x00000001000d9a00 _ZL11get_mm_treeP15RANGE_OPT_PARAMP4Item + 80 44 mysqld 0x00000001000dabd4 _ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyyb + 1300 45 mysqld 0x000000010017d02b _ZL20make_join_statisticsP4JOINP10TABLE_LISTP4ItemP16st_dynamic_array + 5168 46 mysqld 0x0000000100183646 _ZN4JOIN8optimizeEv + 1320 47 mysqld 0x0000000100186e46 _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 479 48 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 49 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 50 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 51 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 52 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 53 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 54 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 55 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 56 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 57 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 58 mysqld 0x00000001000754b7 _ZN12Item_func_sp7val_intEv + 17 59 mysqld 0x0000000100058de1 _ZN9Item_func7is_nullEv + 21 60 mysqld 0x00000001000541f7 _ZL21convert_constant_itemP3THDP10Item_fieldPP4Item + 192 61 mysqld 0x0000000100057376 _ZN15Item_bool_func218fix_length_and_decEv + 336 62 mysqld 0x000000010006a884 _ZN9Item_func10fix_fieldsEP3THDPP4Item + 392 63 mysqld 0x0000000100051572 _ZN9Item_cond10fix_fieldsEP3THDPP4Item + 378 64 mysqld 0x0000000100119ffc _Z11setup_condsP3THDP10TABLE_LISTS2_PP4Item + 250 65 mysqld 0x000000010018c5b6 _Z19setup_without_groupP3THDPP4ItemP10TABLE_LISTS5_R4ListIS1_ES8_S3_P8st_orderSA_Pb + 120 66 mysqld 0x0000000100180ed7 _ZN4JOIN7prepareEPPP4ItemP10TABLE_LISTjS1_jP8st_orderS7_S1_S7_P13st_select_lexP18st_select_lex_unit + 563 67 mysqld 0x0000000100186e2c _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 453 68 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 69 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 70 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 71 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 72 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 73 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 74 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 75 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 76 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 77 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 78 mysqld 0x0000000100075699 _ZN12Item_func_sp7val_strEP6String + 93 79 mysqld 0x000000010003c619 _ZN4Item13save_in_fieldEP5Fieldb + 125 80 mysqld 0x00000001000f4784 _Z12sp_eval_exprP3THDP5FieldPP4Item + 128 81 mysqld 0x00000001000fbddd _ZN11sp_rcontext12set_variableEP3THDP5FieldPP4Item + 47 82 mysqld 0x000000010012c05d _ZN14select_dumpvar9send_dataER4ListI4ItemE + 163 83 mysqld 0x00000001001898b3 _ZN4JOIN4execEv + 497 84 mysqld 0x0000000100186e9b _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 564 85 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 86 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 87 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 88 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 89 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 90 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 91 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 92 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 93 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 94 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 95 mysqld 0x0000000100075699 _ZN12Item_func_sp7val_strEP6String + 93 96 mysqld 0x000000010003c619 _ZN4Item13save_in_fieldEP5Fieldb + 125 97 mysqld 0x00000001000f4784 _Z12sp_eval_exprP3THDP5FieldPP4Item + 128 98 mysqld 0x00000001000fbddd _ZN11sp_rcontext12set_variableEP3THDP5FieldPP4Item + 47 99 mysqld 0x000000010012c05d _ZN14select_dumpvar9send_dataER4ListI4ItemE + 163 100 mysqld 0x00000001001898b3 _ZN4JOIN4execEv + 497 101 mysqld 0x0000000100186e9b _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 564 102 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 103 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 104 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 105 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 106 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 107 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 108 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 109 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 110 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 111 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 112 mysqld 0x0000000100075699 _ZN12Item_func_sp7val_strEP6String + 93 113 mysqld 0x000000010003c619 _ZN4Item13save_in_fieldEP5Fieldb + 125 114 mysqld 0x000000010011a371 _Z36fill_record_n_invoke_before_triggersP3THDR4ListI4ItemES4_bP19Table_triggers_list14trg_event_type + 212 115 mysqld 0x00000001001b5d6a _Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_ + 3246 116 mysqld 0x00000001001507dd _Z21mysql_execute_commandP3THD + 5351 117 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 118 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 119 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 120 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 121 mysqld 0x00000001000f80c4 _ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE + 924 122 mysqld 0x00000001001529ab _Z21mysql_execute_commandP3THD + 14005 123 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 124 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 125 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 126 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 127 mysqld 0x00000001000f855a _ZN7sp_head15execute_triggerEP3THDPK19st_mysql_lex_stringS4_P13st_grant_info + 638 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x1016f9e58): SELECT `contact_enrolment_classes`.`contact_enrolment_class_id` INTO value FROM `class` LEFT JOIN `contact_enrolment_classes` ON `contact_enrolment_classes`.`class_id` = `class`.`class_id` WHERE `contact_enrolment_classes`.`contact_enrolment_id` = cmf_contact_get_current_enrolment_id( NAME_CONST('contact',1017639) ) AND ( IF( SUBSTRING( `contact_enrolment_classes`.`contact_enrolment_class_date_start` , 6, 2 ) = '09' AND ( SUBSTRING( CURRENT_DATE, 6, 2 ) = '07' OR SUBSTRING( CURRENT_DATE, 6, 2 ) = '08' OR SUBSTRING( CURRENT_DATE, 6, 2 ) = '09' ), CONCAT( SUBSTRING( `contact_enrolment_classes`.`contact_enrolment_class_date_start`, 1, 4 ), '-07-01' ), `contact_enrolment_classes`.`contact_enrolment_class_date_start` ) <= CURRENT_DATE ) AND ( `contact_enrolment_classes`.`contact_enrolment_class_date_end` >= CURRENT_DATE OR `contact_enrolment_classes`.`contact_enrolment_class_date_end` = '0000-00-00' ) AND ( Connection ID (thread ID): 159 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. 110916 13:57:00 mysqld_safe mysqld restarted 110916 13:57:00 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110916 13:57:00 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110916 13:57:00 [Note] Plugin 'FEDERATED' is disabled. 110916 13:57:00 InnoDB: The InnoDB memory heap is disabled 110916 13:57:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110916 13:57:00 InnoDB: Compressed tables use zlib 1.2.3 110916 13:57:00 InnoDB: Initializing buffer pool, size = 256.0M 110916 13:57:00 InnoDB: Completed initialization of buffer pool 110916 13:57:00 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 786271256 110916 13:57:00 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 786358386 110916 13:57:00 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 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 InnoDB: Apply batch completed 110916 13:57:01 InnoDB: Waiting for the background threads to start 110916 13:57:02 InnoDB: 1.1.8 started; log sequence number 786358386 110916 13:57:02 [Note] Event Scheduler: Loaded 0 events 110916 13:57:02 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110916 15:26:18 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110916 15:26:18 [Note] Event Scheduler: Purging the queue. 0 events 110916 15:26:18 InnoDB: Starting shutdown... 110916 15:26:20 InnoDB: Shutdown completed; log sequence number 786478324 110916 15:26:20 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110916 15:26:20 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110916 15:49:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110916 15:49:34 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110916 15:49:34 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110916 15:49:34 [Note] Plugin 'FEDERATED' is disabled. 110916 15:49:34 InnoDB: The InnoDB memory heap is disabled 110916 15:49:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110916 15:49:34 InnoDB: Compressed tables use zlib 1.2.3 110916 15:49:34 InnoDB: Initializing buffer pool, size = 256.0M 110916 15:49:34 InnoDB: Completed initialization of buffer pool 110916 15:49:34 InnoDB: highest supported file format is Barracuda. 110916 15:49:37 InnoDB: Waiting for the background threads to start 110916 15:49:38 InnoDB: 1.1.8 started; log sequence number 786478324 110916 15:49:38 [Note] Event Scheduler: Loaded 0 events 110916 15:49:38 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110916 16:11:50 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110916 16:11:50 [Note] Event Scheduler: Purging the queue. 0 events 110916 16:11:50 InnoDB: Starting shutdown... 110916 16:11:51 InnoDB: Shutdown completed; log sequence number 786478324 110916 16:11:51 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110916 16:11:51 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110918 11:35:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110918 11:35:56 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110918 11:35:56 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110918 11:35:56 [Note] Plugin 'FEDERATED' is disabled. 110918 11:35:56 InnoDB: The InnoDB memory heap is disabled 110918 11:35:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110918 11:35:56 InnoDB: Compressed tables use zlib 1.2.3 110918 11:35:56 InnoDB: Initializing buffer pool, size = 256.0M 110918 11:35:56 InnoDB: Completed initialization of buffer pool 110918 11:35:56 InnoDB: highest supported file format is Barracuda. 110918 11:36:08 InnoDB: Waiting for the background threads to start 110918 11:36:10 InnoDB: 1.1.8 started; log sequence number 786478324 110918 11:36:11 [Note] Event Scheduler: Loaded 0 events 110918 11:36:11 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110919 20:11:50 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110919 20:11:50 [Note] Event Scheduler: Purging the queue. 0 events 110919 20:11:50 InnoDB: Starting shutdown... 110919 20:11:51 InnoDB: Shutdown completed; log sequence number 788167001 110919 20:11:51 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110919 20:11:51 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110920 08:54:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110920 8:54:16 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110920 8:54:16 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110920 8:54:16 [Note] Plugin 'FEDERATED' is disabled. 110920 8:54:16 InnoDB: The InnoDB memory heap is disabled 110920 8:54:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110920 8:54:16 InnoDB: Compressed tables use zlib 1.2.3 110920 8:54:16 InnoDB: Initializing buffer pool, size = 256.0M 110920 8:54:16 InnoDB: Completed initialization of buffer pool 110920 8:54:16 InnoDB: highest supported file format is Barracuda. 110920 8:54:24 InnoDB: Waiting for the background threads to start 110920 8:54:25 InnoDB: 1.1.8 started; log sequence number 788167001 110920 8:54:26 [Note] Event Scheduler: Loaded 0 events 110920 8:54:26 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110920 18:05:38 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110920 18:05:38 [Note] Event Scheduler: Purging the queue. 0 events 110920 18:05:39 InnoDB: Starting shutdown... 110920 18:05:41 InnoDB: Shutdown completed; log sequence number 788204572 110920 18:05:41 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110920 18:05:41 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110921 08:44:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110921 8:44:10 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110921 8:44:10 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110921 8:44:10 [Note] Plugin 'FEDERATED' is disabled. 110921 8:44:10 InnoDB: The InnoDB memory heap is disabled 110921 8:44:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110921 8:44:10 InnoDB: Compressed tables use zlib 1.2.3 110921 8:44:10 InnoDB: Initializing buffer pool, size = 256.0M 110921 8:44:10 InnoDB: Completed initialization of buffer pool 110921 8:44:10 InnoDB: highest supported file format is Barracuda. 110921 8:44:10 InnoDB: Waiting for the background threads to start 110921 8:44:11 InnoDB: 1.1.8 started; log sequence number 788204572 110921 8:44:11 [Note] Event Scheduler: Loaded 0 events 110921 8:44:11 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110921 20:19:35 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110921 20:19:35 [Note] Event Scheduler: Purging the queue. 0 events 110921 20:19:35 InnoDB: Starting shutdown... 110921 20:19:37 InnoDB: Shutdown completed; log sequence number 788622394 110921 20:19:37 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110921 20:19:37 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110921 20:20:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110921 20:20:36 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110921 20:20:36 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110921 20:20:37 [Note] Plugin 'FEDERATED' is disabled. 110921 20:20:37 InnoDB: The InnoDB memory heap is disabled 110921 20:20:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110921 20:20:37 InnoDB: Compressed tables use zlib 1.2.3 110921 20:20:37 InnoDB: Initializing buffer pool, size = 256.0M 110921 20:20:37 InnoDB: Completed initialization of buffer pool 110921 20:20:37 InnoDB: highest supported file format is Barracuda. 110921 20:20:38 InnoDB: Waiting for the background threads to start 110921 20:20:39 InnoDB: 1.1.8 started; log sequence number 788622394 110921 20:20:40 [Note] Event Scheduler: Loaded 0 events 110921 20:20:40 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110921 22:01:26 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110921 22:01:26 [Note] Event Scheduler: Purging the queue. 0 events 110921 22:01:26 InnoDB: Starting shutdown... 110921 22:01:27 InnoDB: Shutdown completed; log sequence number 788622394 110921 22:01:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110921 22:01:27 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110922 07:52:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110922 7:52:40 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110922 7:52:40 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110922 7:52:40 [Note] Plugin 'FEDERATED' is disabled. 110922 7:52:40 InnoDB: The InnoDB memory heap is disabled 110922 7:52:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110922 7:52:40 InnoDB: Compressed tables use zlib 1.2.3 110922 7:52:40 InnoDB: Initializing buffer pool, size = 256.0M 110922 7:52:40 InnoDB: Completed initialization of buffer pool 110922 7:52:40 InnoDB: highest supported file format is Barracuda. 110922 7:52:44 InnoDB: Waiting for the background threads to start 110922 7:52:45 InnoDB: 1.1.8 started; log sequence number 788622394 110922 7:52:45 [Note] Event Scheduler: Loaded 0 events 110922 7:52:45 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110922 19:52:20 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110922 19:52:20 [Note] Event Scheduler: Purging the queue. 0 events 110922 19:52:21 InnoDB: Starting shutdown... 110922 19:52:22 InnoDB: Shutdown completed; log sequence number 797593182 110922 19:52:22 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110922 19:52:22 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110923 10:03:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110923 10:03:20 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110923 10:03:20 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110923 10:03:20 [Note] Plugin 'FEDERATED' is disabled. 110923 10:03:20 InnoDB: The InnoDB memory heap is disabled 110923 10:03:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110923 10:03:20 InnoDB: Compressed tables use zlib 1.2.3 110923 10:03:20 InnoDB: Initializing buffer pool, size = 256.0M 110923 10:03:20 InnoDB: Completed initialization of buffer pool 110923 10:03:20 InnoDB: highest supported file format is Barracuda. 110923 10:03:21 InnoDB: Waiting for the background threads to start 110923 10:03:22 InnoDB: 1.1.8 started; log sequence number 797593182 110923 10:03:22 [Note] Event Scheduler: Loaded 0 events 110923 10:03:22 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110923 10:58:00 - 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=402653184 read_buffer_size=1048576 max_used_connections=2 max_threads=500 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 = 1934872 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x135203e00 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 = 0x135b89eb8 thread_stack 0x40000 0 mysqld 0x000000010022db0b my_print_stacktrace + 57 1 mysqld 0x00000001000c9087 handle_segfault + 557 2 libsystem_c.dylib 0x00007fff8f234cfa _sigtramp + 26 3 ??? 0x0000000100c47a00 0x0 + 4307843584 4 mysqld 0x00000001001777b8 _ZN13st_join_table7cleanupEv + 26 5 mysqld 0x000000010017de6a _ZN4JOIN7cleanupEb + 106 6 mysqld 0x000000010017e699 _ZN4JOIN7destroyEv + 175 7 mysqld 0x00000001001b0ed2 _ZN13st_select_lex7cleanupEv + 36 8 mysqld 0x0000000100186ef6 _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 655 9 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 10 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 11 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 12 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 13 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 14 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 15 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 16 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 17 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 18 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 19 mysqld 0x00000001000754b7 _ZN12Item_func_sp7val_intEv + 17 20 mysqld 0x0000000100058de1 _ZN9Item_func7is_nullEv + 21 21 mysqld 0x00000001000541f7 _ZL21convert_constant_itemP3THDP10Item_fieldPP4Item + 192 22 mysqld 0x0000000100057376 _ZN15Item_bool_func218fix_length_and_decEv + 336 23 mysqld 0x000000010006a884 _ZN9Item_func10fix_fieldsEP3THDPP4Item + 392 24 mysqld 0x0000000100051572 _ZN9Item_cond10fix_fieldsEP3THDPP4Item + 378 25 mysqld 0x0000000100119ffc _Z11setup_condsP3THDP10TABLE_LISTS2_PP4Item + 250 26 mysqld 0x000000010018c5b6 _Z19setup_without_groupP3THDPP4ItemP10TABLE_LISTS5_R4ListIS1_ES8_S3_P8st_orderSA_Pb + 120 27 mysqld 0x0000000100180ed7 _ZN4JOIN7prepareEPPP4ItemP10TABLE_LISTjS1_jP8st_orderS7_S1_S7_P13st_select_lexP18st_select_lex_unit + 563 28 mysqld 0x0000000100186e2c _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 453 29 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 30 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 31 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 32 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 33 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 34 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 35 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 36 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 37 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 38 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 39 mysqld 0x0000000100075699 _ZN12Item_func_sp7val_strEP6String + 93 40 mysqld 0x000000010003c619 _ZN4Item13save_in_fieldEP5Fieldb + 125 41 mysqld 0x00000001000f4784 _Z12sp_eval_exprP3THDP5FieldPP4Item + 128 42 mysqld 0x00000001000fbddd _ZN11sp_rcontext12set_variableEP3THDP5FieldPP4Item + 47 43 mysqld 0x000000010012c05d _ZN14select_dumpvar9send_dataER4ListI4ItemE + 163 44 mysqld 0x00000001001898b3 _ZN4JOIN4execEv + 497 45 mysqld 0x0000000100186e9b _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 564 46 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 47 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 48 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 49 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 50 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 51 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 52 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 53 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 54 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 55 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 56 mysqld 0x0000000100075699 _ZN12Item_func_sp7val_strEP6String + 93 57 mysqld 0x000000010003c619 _ZN4Item13save_in_fieldEP5Fieldb + 125 58 mysqld 0x00000001000f4784 _Z12sp_eval_exprP3THDP5FieldPP4Item + 128 59 mysqld 0x00000001000fbddd _ZN11sp_rcontext12set_variableEP3THDP5FieldPP4Item + 47 60 mysqld 0x000000010012c05d _ZN14select_dumpvar9send_dataER4ListI4ItemE + 163 61 mysqld 0x00000001001898b3 _ZN4JOIN4execEv + 497 62 mysqld 0x0000000100186e9b _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 564 63 mysqld 0x000000010018b8f7 _Z13handle_selectP3THDP3LEXP13select_resultm + 373 64 mysqld 0x000000010014c8ee _ZL21execute_sqlcom_selectP3THDP10TABLE_LIST + 737 65 mysqld 0x000000010014fae4 _Z21mysql_execute_commandP3THD + 2030 66 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 67 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 68 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 69 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 70 mysqld 0x00000001000f9850 _ZN7sp_head16execute_functionEP3THDPP4ItemjP5Field + 1784 71 mysqld 0x000000010006ebfc _ZN12Item_func_sp12execute_implEP3THD + 390 72 mysqld 0x0000000100071473 _ZN12Item_func_sp7executeEv + 39 73 mysqld 0x0000000100075699 _ZN12Item_func_sp7val_strEP6String + 93 74 mysqld 0x000000010003c619 _ZN4Item13save_in_fieldEP5Fieldb + 125 75 mysqld 0x000000010011a371 _Z36fill_record_n_invoke_before_triggersP3THDR4ListI4ItemES4_bP19Table_triggers_list14trg_event_type + 212 76 mysqld 0x00000001001b5d6a _Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_ + 3246 77 mysqld 0x00000001001507dd _Z21mysql_execute_commandP3THD + 5351 78 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 79 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 80 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 81 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 82 mysqld 0x00000001000f80c4 _ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE + 924 83 mysqld 0x00000001001529ab _Z21mysql_execute_commandP3THD + 14005 84 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 85 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 86 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 87 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 88 mysqld 0x00000001000f855a _ZN7sp_head15execute_triggerEP3THDPK19st_mysql_lex_stringS4_P13st_grant_info + 638 89 mysqld 0x00000001001ac85f _ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb + 319 90 mysqld 0x00000001001b5f1c _Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_ + 3680 91 mysqld 0x00000001001507dd _Z21mysql_execute_commandP3THD + 5351 92 mysqld 0x00000001000f62ab _ZN13sp_instr_stmt9exec_coreEP3THDPj + 95 93 mysqld 0x00000001000f5253 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 567 94 mysqld 0x00000001000f8ff4 _ZN13sp_instr_stmt7executeEP3THDPj + 1356 95 mysqld 0x00000001000f78cd _ZN7sp_head7executeEP3THDb + 1163 96 mysqld 0x00000001000f855a _ZN7sp_head15execute_triggerEP3THDPK19st_mysql_lex_stringS4_P13st_grant_info + 638 97 mysqld 0x00000001001ac85f _ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb + 319 98 mysqld 0x000000010013c0da _Z12write_recordP3THDP5TABLEP12st_copy_info + 1633 99 mysqld 0x000000010013e2d2 _Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb + 2438 100 mysqld 0x0000000100150a13 _Z21mysql_execute_commandP3THD + 5917 101 mysqld 0x0000000100153bc1 _Z11mysql_parseP3THDPcjP12Parser_state + 298 102 mysqld 0x0000000100154361 _Z16dispatch_command19enum_server_commandP3THDPcj + 1814 103 mysqld 0x0000000100154fe5 _Z10do_commandP3THD + 257 104 mysqld 0x00000001001e2f8e _Z24do_handle_one_connectionP3THD + 256 105 mysqld 0x00000001001e306e handle_one_connection + 84 106 libsystem_c.dylib 0x00007fff8f1e08bf _pthread_start + 335 107 libsystem_c.dylib 0x00007fff8f1e3b75 thread_start + 13 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x1386f11c8): is an invalid pointer Connection ID (thread ID): 21 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. 110923 10:58:00 mysqld_safe mysqld restarted 110923 10:58:00 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110923 10:58:00 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110923 10:58:00 [Note] Plugin 'FEDERATED' is disabled. 110923 10:58:00 InnoDB: The InnoDB memory heap is disabled 110923 10:58:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110923 10:58:00 InnoDB: Compressed tables use zlib 1.2.3 110923 10:58:01 InnoDB: Initializing buffer pool, size = 256.0M 110923 10:58:01 InnoDB: Completed initialization of buffer pool 110923 10:58:01 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 797602344 110923 10:58:01 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 798220130 110923 10:58:01 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 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 InnoDB: Apply batch completed 110923 10:58:02 InnoDB: Waiting for the background threads to start 110923 10:58:03 InnoDB: 1.1.8 started; log sequence number 798220130 110923 10:58:03 [Note] Event Scheduler: Loaded 0 events 110923 10:58:03 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.15-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110923 10:59:42 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 110923 10:59:42 [Note] Event Scheduler: Purging the queue. 0 events 110923 10:59:42 InnoDB: Starting shutdown... 110923 10:59:43 InnoDB: Shutdown completed; log sequence number 798332665 110923 10:59:43 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110923 10:59:43 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended 110923 10:59:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/ 110923 10:59:49 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110923 10:59:49 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110923 10:59:49 [Note] Plugin 'FEDERATED' is disabled. 110923 10:59:49 InnoDB: The InnoDB memory heap is disabled 110923 10:59:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110923 10:59:49 InnoDB: Compressed tables use zlib 1.2.3 110923 10:59:49 InnoDB: Initializing buffer pool, size = 256.0M 110923 10:59:49 InnoDB: Completed initialization of buffer pool 110923 10:59:49 InnoDB: highest supported file format is Barracuda. 110923 10:59:50 InnoDB: Waiting for the background threads to start 110923 10:59:51 InnoDB: 1.1.8 started; log sequence number 798332665 110923 10:59:51 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--debug' 110923 10:59:51 [ERROR] Aborting 110923 10:59:51 InnoDB: Starting shutdown... 110923 10:59:51 InnoDB: Shutdown completed; log sequence number 798332665 110923 10:59:51 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110923 10:59:51 mysqld_safe mysqld from pid file /usr/local/mysql/data//loox.local.pid ended