Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Warning] IP address '192.168.15.118' could not be resolved: Name or service not known Sep 25 11:36:10 orchid mysqld: 2014-09-25 11:36:10 8e9b5b70 InnoDB: Assertion failure in thread 2392546160 in file ha_innodb.cc line 9400 Sep 25 11:36:10 orchid mysqld: InnoDB: Failing assertion: prebuilt->trx == thd_to_trx(ha_thd()) Sep 25 11:36:10 orchid mysqld: InnoDB: We intentionally generate a memory trap. Sep 25 11:36:10 orchid mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Sep 25 11:36:10 orchid mysqld: InnoDB: If you get repeated assertion failures or crashes, even Sep 25 11:36:10 orchid mysqld: InnoDB: immediately after the mysqld startup, there may be Sep 25 11:36:10 orchid mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to Sep 25 11:36:10 orchid mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html Sep 25 11:36:10 orchid mysqld: InnoDB: about forcing recovery. Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [ERROR] mysqld got signal 6 ; Sep 25 11:36:10 orchid mysqld: This could be because you hit a bug. It is also possible that this binary Sep 25 11:36:10 orchid mysqld: or one of the libraries it was linked against is corrupt, improperly built, Sep 25 11:36:10 orchid mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Sep 25 11:36:10 orchid mysqld: Sep 25 11:36:10 orchid mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs Sep 25 11:36:10 orchid mysqld: Sep 25 11:36:10 orchid mysqld: We will try our best to scrape up some info that will hopefully help Sep 25 11:36:10 orchid mysqld: diagnose the problem, but since we have already crashed, Sep 25 11:36:10 orchid mysqld: something is definitely wrong and this may fail. Sep 25 11:36:10 orchid mysqld: Sep 25 11:36:10 orchid mysqld: Server version: 10.0.13-MariaDB Sep 25 11:36:10 orchid mysqld: key_buffer_size=134217728 Sep 25 11:36:10 orchid mysqld: read_buffer_size=131072 Sep 25 11:36:10 orchid mysqld: max_used_connections=1 Sep 25 11:36:10 orchid mysqld: max_threads=153 Sep 25 11:36:10 orchid mysqld: thread_count=1 Sep 25 11:36:10 orchid mysqld: It is possible that mysqld could use up to Sep 25 11:36:10 orchid mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466051 K bytes of memory Sep 25 11:36:10 orchid mysqld: Hope that's ok; if not, decrease some variables in the equation. Sep 25 11:36:10 orchid mysqld: Sep 25 11:36:10 orchid mysqld: Thread pointer: 0x0xa52aa008 Sep 25 11:36:10 orchid mysqld: Attempting backtrace. You can use the following information to find out Sep 25 11:36:10 orchid mysqld: where mysqld died. If you see no messages after this, something went Sep 25 11:36:10 orchid mysqld: terribly wrong... Sep 25 11:36:10 orchid mysqld: stack_bottom = 0x8e9b529c thread_stack 0x48000 Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2d)[0x87bfe3d] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x472)[0x8349352] Sep 25 11:36:10 orchid mysqld: [0xd32400] Sep 25 11:36:10 orchid mysqld: /lib/libc.so.6(abort+0x17a)[0x30e13a] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld[0x84bdf1e] Sep 25 11:36:10 orchid mysqld: /usr/lib/mysql/plugin/ha_oqgraph.so(_ZNK8oqgraph36cursor15record_positionEv+0x4d)[0x59fa0d] Sep 25 11:36:10 orchid mysqld: /usr/lib/mysql/plugin/ha_oqgraph.so(_ZNK8oqgraph310cursor_ptrneERKS0_+0x32)[0x59fd22] Sep 25 11:36:10 orchid mysqld: /usr/lib/mysql/plugin/ha_oqgraph.so(_ZN5boost19breadth_first_visitIN8oqgraph35graphENS_19d_ary_heap_indirectIyLj4ENS_19vector_property_mapIjNS1_25vertex_index_property_mapEEENS_17lazy_property_mapINS_9unordered13unordered_mapIydNS_4hashIyEESt8equal_toIyESaISt4pairIKydEEEENS_17value_initializerIdEEEESt4lessIdESt6vectorIySaIyEEEENS_6detail20dijkstra_bfs_visitorINS_16dijkstra_visitorIN10open_query12oqgraph_goalILb1ENS_16on_finish_vertexENS_24associative_property_mapINS9_IyySB_SD_SaISE_ISF_yEEEEEEEEEESR_NS1_24edge_weight_property_mapENS7_IS11_NS_20identity_initializerIyEEEESL_NS_11closed_plusIdEESN_EENS_16two_bit_judy_mapIS5_EEEEvRKT_NS_12graph_traitsIS1E_E17vertex_descriptorERT0_T1_T2_+0x623)[0x59e1f3] Sep 25 11:36:10 orchid mysqld: /usr/lib/mysql/plugin/ha_oqgraph.so(_ZN10open_query7oqgraph6searchEPiPyS2_+0xef8)[0x594798] Sep 25 11:36:10 orchid mysqld: /usr/lib/mysql/plugin/ha_oqgraph.so(_ZN10ha_oqgraph14index_read_idxEPhjPKhj16ha_rkey_function+0x2b5)[0x590be5] Sep 25 11:36:10 orchid mysqld: /usr/lib/mysql/plugin/ha_oqgraph.so(_ZN10ha_oqgraph10index_readEPhPKhj16ha_rkey_function+0x59)[0x590ee9] Sep 25 11:36:10 orchid mysqld: /usr/lib/mysql/plugin/ha_oqgraph.so(_ZN7handler14index_read_mapEPhPKhm16ha_rkey_function+0x61)[0x591a11] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function+0x169)[0x834ab29] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld[0x820ff9c] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x10f)[0x81fb01f] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld[0x8201c84] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x1185)[0x82274d5] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x20b)[0x82257db] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x29f)[0x822906f] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld[0x81ca5dc] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x54a5)[0x81d35e5] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x11)[0x8457bc1] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0xa8)[0x845c8d8] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x167)[0x845ceb7] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x716)[0x845ab06] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5a6)[0x845d866] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x35e6)[0x81d1726] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x400)[0x81d58c0] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x19f1)[0x81d79d1] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0xdd)[0x81d847d] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x148)[0x82a4018] Sep 25 11:36:10 orchid mysqld: /usr/sbin/mysqld(handle_one_connection+0x3c)[0x82a434c] Sep 25 11:36:10 orchid mysqld: /lib/libpthread.so.0(+0x6b39)[0xf1bb39] Sep 25 11:36:10 orchid mysqld: /lib/libc.so.6(clone+0x5e)[0x3c4ace] Sep 25 11:36:10 orchid mysqld: Sep 25 11:36:10 orchid mysqld: Trying to get some variables. Sep 25 11:36:10 orchid mysqld: Some pointers may be invalid and cause the dump to abort. Sep 25 11:36:10 orchid mysqld: Query (0xa5248138): is an invalid pointer Sep 25 11:36:10 orchid mysqld: Connection ID (thread ID): 3 Sep 25 11:36:10 orchid mysqld: Status: NOT_KILLED Sep 25 11:36:10 orchid mysqld: Sep 25 11:36:10 orchid mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on Sep 25 11:36:10 orchid mysqld: Sep 25 11:36:10 orchid mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Sep 25 11:36:10 orchid mysqld: information that should help you find out what is causing the crash. Sep 25 11:36:10 orchid mysqld_safe: Number of processes running now: 0 Sep 25 11:36:10 orchid mysqld_safe: mysqld restarted Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: The InnoDB memory heap is disabled Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Compressed tables use zlib 1.2.3 Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Using Linux native AIO Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Not using CPU crc32 instructions Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Initializing buffer pool, size = 128.0M Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Completed initialization of buffer pool Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Highest supported file format is Barracuda. Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: The log sequence numbers 1629281 and 1629281 in ibdata files do not match the log sequence number 1688808 in the ib_logfiles! Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Database was not shutdown normally! Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Starting crash recovery. Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Reading tablespace information from the .ibd files... Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Restoring possible half-written data pages Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: from the doublewrite buffer... Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: 128 rollback segment(s) are active. Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Waiting for purge to start Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.19-67.0 started; log sequence number 1688808 Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] Plugin 'FEEDBACK' is disabled. Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] Server socket created on IP: '::'. Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] Event Scheduler: Loaded 0 events Sep 25 11:36:10 orchid mysqld: 140925 11:36:10 [Note] /usr/sbin/mysqld: ready for connections. Sep 25 11:36:10 orchid mysqld: Version: '10.0.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Sep 25 11:36:12 orchid mysqld: 140925 11:36:12 [Warning] IP address '192.168.15.118' could not be resolved: Name or service not known