120828 09:51:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data 120828 9:51:54 InnoDB: The InnoDB memory heap is disabled 120828 9:51:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120828 9:51:54 InnoDB: Compressed tables use zlib 1.2.3 120828 9:51:54 InnoDB: Using Linux native AIO 120828 9:51:54 InnoDB: Initializing buffer pool, size = 128.0M 120828 9:51:54 InnoDB: Completed initialization of buffer pool 120828 9:51:54 InnoDB: highest supported file format is Barracuda. 120828 9:51:54 InnoDB: Waiting for the background threads to start 120828 9:51:55 Percona XtraDB (http://www.percona.com) 1.1.8-26.0 started; log sequence number 7861657718337 120828 9:51:55 [Note] Plugin 'FEEDBACK' is disabled. 120828 9:51:55 [Note] Event Scheduler: Loaded 0 events 120828 9:51:55 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.25-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 120828 9:52:11 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.165988' at position 386178790, relay log '/var/log/mysql/replication/slave-bin.064890' position: 262147 120828 9:52:11 [Note] Slave I/O thread: connected to master 'replicate@db1-main-master:3306',replication started in log 'master-bin.165988' at position 456265341 120828 9:52:11 [Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error: Unknown system variable 'binlog_checksum', Error_code: 1193 120828 9:52:11 [ERROR] 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. To report this bug, see http://kb.askmonty.org/en/reporting-bugs 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. Server version: 5.5.25-MariaDB key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466118 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0xfc00570 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 = 0x40ab20b8 thread_stack 0x48000 ??:0(my_print_stacktrace)[0xa8783e] ??:0(handle_fatal_signal)[0x6d048c] ??:0(??)[0x31b800ebe0] ??:0(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x53d81d] ??:0(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x53e5ce] ??:0(mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool))[0x56a19a] ??:0(mysql_execute_command(THD*))[0x5827dd] ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x583a41] ??:0(Query_log_event::do_apply_event(Relay_log_info const*, char const*, unsigned int))[0x7a7bb9] ??:0(apply_event_and_update_pos(Log_event*, THD*, Relay_log_info*))[0x50ca52] ??:0(exec_relay_log_event(THD*, Relay_log_info*))[0x514710] ??:0(handle_slave_sql)[0x515a24] ??:0(??)[0x31b800677d] ??:0(??)[0x31b78d33ed] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2aaac8002f93): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED 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=off 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. 120828 09:52:11 mysqld_safe Number of processes running now: 0 120828 09:52:11 mysqld_safe mysqld restarted 120828 9:52:11 InnoDB: The InnoDB memory heap is disabled 120828 9:52:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120828 9:52:11 InnoDB: Compressed tables use zlib 1.2.3 120828 9:52:11 InnoDB: Using Linux native AIO 120828 9:52:11 InnoDB: Initializing buffer pool, size = 128.0M 120828 9:52:11 InnoDB: Completed initialization of buffer pool 120828 9:52:11 InnoDB: highest supported file format is Barracuda. 120828 9:52:11 InnoDB: Waiting for the background threads to start 120828 9:52:12 Percona XtraDB (http://www.percona.com) 1.1.8-26.0 started; log sequence number 7861657718337 120828 9:52:12 [Note] Plugin 'FEEDBACK' is disabled. 120828 9:52:12 [Note] Event Scheduler: Loaded 0 events 120828 9:52:12 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.25-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 120828 9:58:58 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.165988' at position 386178790, relay log '/var/log/mysql/replication/slave-bin.064890' position: 262147 120828 9:58:58 [Note] Slave I/O thread: connected to master 'replicate@db1-main-master:3306',replication started in log 'master-bin.165988' at position 456620187 120828 9:58:58 [Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error: Unknown system variable 'binlog_checksum', Error_code: 1193 120828 9:58:58 [ERROR] 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. To report this bug, see http://kb.askmonty.org/en/reporting-bugs 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. Server version: 5.5.25-MariaDB key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=8 max_threads=153 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466118 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x100bd500 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 = 0x4ba460b8 thread_stack 0x48000 ??:0(my_print_stacktrace)[0xa8783e] ??:0(handle_fatal_signal)[0x6d048c] ??:0(??)[0x31b800ebe0] ??:0(??)[0x31b7878082] ??:0(TABLE::init(THD*, TABLE_LIST*))[0x60e327] ??:0(open_table(THD*, TABLE_LIST*, st_mem_root*, Open_table_context*))[0x53b595] ??:0(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x53d89e] ??:0(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x53e5ce] ??:0(mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool))[0x56a19a] ??:0(mysql_execute_command(THD*))[0x5827dd] ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x583a41] ??:0(Query_log_event::do_apply_event(Relay_log_info const*, char const*, unsigned int))[0x7a7bb9] ??:0(apply_event_and_update_pos(Log_event*, THD*, Relay_log_info*))[0x50ca52] ??:0(exec_relay_log_event(THD*, Relay_log_info*))[0x514710] ??:0(handle_slave_sql)[0x515a24] ??:0(??)[0x31b800677d] ??:0(??)[0x31b78d33ed] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x100c8883): INSERT INTO olx_marketing_queue (email, user_id, create_date) VALUES (NULL, 5930722, @now) ON DUPLICATE KEY UPDATE last_update = CURRENT_TIMESTAMP Connection ID (thread ID): 19 Status: NOT_KILLED 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=off 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. 120828 09:58:58 mysqld_safe Number of processes running now: 0 120828 09:58:58 mysqld_safe mysqld restarted 120828 9:58:58 InnoDB: The InnoDB memory heap is disabled 120828 9:58:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120828 9:58:58 InnoDB: Compressed tables use zlib 1.2.3 120828 9:58:58 InnoDB: Using Linux native AIO 120828 9:58:58 InnoDB: Initializing buffer pool, size = 128.0M 120828 9:58:58 InnoDB: Completed initialization of buffer pool 120828 9:58:58 InnoDB: highest supported file format is Barracuda. 120828 9:58:58 InnoDB: Waiting for the background threads to start 120828 9:58:59 Percona XtraDB (http://www.percona.com) 1.1.8-26.0 started; log sequence number 7861657718337 120828 9:58:59 [Note] Plugin 'FEEDBACK' is disabled. 120828 9:58:59 [Note] Event Scheduler: Loaded 0 events 120828 9:58:59 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.25-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 120828 10:18:00 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.165988' at position 386178790, relay log '/var/log/mysql/replication/slave-bin.064890' position: 262147 120828 10:18:00 [Note] Slave I/O thread: connected to master 'replicate@db1-main-master:3306',replication started in log 'master-bin.165988' at position 457089528 120828 10:18:00 [Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error: Unknown system variable 'binlog_checksum', Error_code: 1193 120828 10:18:00 [ERROR] 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. To report this bug, see http://kb.askmonty.org/en/reporting-bugs 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. Server version: 5.5.25-MariaDB key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=9 max_threads=153 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466118 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x91fcde0 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 = 0x4b50e0b8 thread_stack 0x48000 ??:0(my_print_stacktrace)[0xa8783e] ??:0(handle_fatal_signal)[0x6d048c] ??:0(??)[0x31b800ebe0] ??:0(??)[0x31b7878082] ??:0(TABLE::init(THD*, TABLE_LIST*))[0x60e327] ??:0(open_table(THD*, TABLE_LIST*, st_mem_root*, Open_table_context*))[0x53b595] ??:0(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x53d89e] ??:0(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x53e5ce] ??:0(mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool))[0x56a19a] ??:0(mysql_execute_command(THD*))[0x5827dd] ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x583a41] ??:0(Query_log_event::do_apply_event(Relay_log_info const*, char const*, unsigned int))[0x7a7bb9] ??:0(apply_event_and_update_pos(Log_event*, THD*, Relay_log_info*))[0x50ca52] ??:0(exec_relay_log_event(THD*, Relay_log_info*))[0x514710] ??:0(handle_slave_sql)[0x515a24] ??:0(??)[0x31b800677d] ??:0(??)[0x31b78d33ed] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x91f83e3): INSERT INTO olx_marketing_queue (email, user_id, create_date) VALUES (NULL, 5930722, @now) ON DUPLICATE KEY UPDATE last_update = CURRENT_TIMESTAMP Connection ID (thread ID): 37 Status: NOT_KILLED 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=off 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. 120828 10:18:00 mysqld_safe Number of processes running now: 0 120828 10:18:00 mysqld_safe mysqld restarted 120828 10:18:00 InnoDB: The InnoDB memory heap is disabled 120828 10:18:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120828 10:18:00 InnoDB: Compressed tables use zlib 1.2.3 120828 10:18:00 InnoDB: Using Linux native AIO 120828 10:18:00 InnoDB: Initializing buffer pool, size = 128.0M 120828 10:18:00 InnoDB: Completed initialization of buffer pool 120828 10:18:00 InnoDB: highest supported file format is Barracuda. 120828 10:18:01 InnoDB: Waiting for the background threads to start 120828 10:18:02 Percona XtraDB (http://www.percona.com) 1.1.8-26.0 started; log sequence number 7861657718337 120828 10:18:02 [Note] Plugin 'FEEDBACK' is disabled. 120828 10:18:02 [Note] Event Scheduler: Loaded 0 events 120828 10:18:02 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.25-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server