Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.9
-
Debian GNU/Linux 7 (wheezy)
# uname -a
Linux int-tel-mysql-th2-03 3.2.0-4-amd64 #1 SMP Debian 3.2.68-1+deb7u3 x86_64 GNU/Linux
Description
MariaDB [(none)]>
|
MariaDB [(none)]> SET GLOBAL gtid_slave_pos='1-101-1050,10-103-166151';
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [(none)]>
|
MariaDB [(none)]> SELECT @@GLOBAL.gtid_slave_pos;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/srv/cluster/tmp/mysqld.sock' (111 "Connection refused")
|
ERROR: Can't connect to the server
|
|
unknown [(none)]>
|
unknown [(none)]> Bye
|
LOG ERROR :
2015-12-15 16:42:31 140628723922688 [Note] WSREP: Service thread queue flushed.
|
2015-12-15 16:42:31 140628641969920 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
|
2015-12-15 16:42:31 140628723922688 [Note] WSREP: Service thread queue flushed.
|
2015-12-15 16:42:31 140628641969920 [Note] WSREP: Synchronized with group, ready for connections
|
2015-12-15 16:42:31 140628641969920 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2015-12-15 16:42:31 140637492361056 [Note] Reading of all Master_info entries succeded
|
2015-12-15 16:42:31 140637492361056 [Note] Added new Master_info '' to hash table
|
2015-12-15 16:42:31 140637492361056 [Note] /opt/mariadb/bin/mysqld: ready for connections.
|
Version: '10.1.9-MariaDB-log' socket: '/srv/cluster/tmp/mysqld.sock' port: 3306 MariaDB Server
|
2015-12-15 16:48:05 140626764977920 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
|
2015-12-15 16:48:06 140626764977920 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='xxx.xxx.xxx.xxx', master_port='3306', master_log_file='', master_log_pos='4'.
|
2015-12-15 16:48:06 140626764977920 [Note] Previous Using_Gtid=No. New Using_Gtid=Slave_Pos
|
151215 16:48:52 [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: 10.1.9-MariaDB-log
|
key_buffer_size=10485760
|
read_buffer_size=1048576
|
max_used_connections=1
|
max_threads=102
|
thread_count=8
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 221198 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0x7fe63e22d008
|
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 = 0x7fe6385f4e08 thread_stack 0x48000
|
mysys/stacktrace.c:247(my_print_stacktrace)[0xbf822e]
|
sql/signal_handler.cc:160(handle_fatal_signal)[0x760e24]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf0a0)[0x7fe8b78370a0]
|
mysys/my_bitmap.c:600(bitmap_bits_set)[0xbee820]
|
sql/rpl_record.cc:68(pack_row(TABLE*, st_bitmap const*, unsigned char*, unsigned char const*))[0x86256d]
|
sql/sql_class.cc:6178(THD::binlog_write_row(TABLE*, bool, unsigned char const*))[0x57ca66]
|
sql/log_event.h:4567(Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, bool, unsigned char const*, unsigned char const*))[0x76c0cf]
|
sql/handler.cc:5757(binlog_log_row)[0x7679a0]
|
sql/handler.cc:5885(handler::ha_write_row(unsigned char*))[0x769cf3]
|
sql/rpl_gtid.cc:596(rpl_slave_state::record_gtid(THD*, rpl_gtid const*, unsigned long long, bool, bool))[0x6e2c20]
|
sql/rpl_gtid.cc:1094(rpl_slave_state::load(THD*, char*, unsigned long, bool, bool))[0x6e510d]
|
sql/sql_repl.cc:4477(rpl_gtid_pos_update(THD*, char*, unsigned long))[0x5cc583]
|
sql/sys_vars.cc:1631(Sys_var_gtid_slave_pos::global_update(THD*, set_var*))[0x6a2a62]
|
sql/set_var.cc:199(sys_var::update(THD*, set_var*))[0x52f484]
|
sql/set_var.cc:795(set_var::update(THD*))[0x52fd4d]
|
sql/set_var.cc:696(sql_set_variables(THD*, List<set_var_base>*, bool))[0x52f039]
|
sql/sql_parse.cc:4295(mysql_execute_command(THD*))[0x5b2fd0]
|
sql/sql_parse.cc:7302(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5b7ed9]
|
sql/sql_parse.cc:7126(wsrep_mysql_parse)[0x5b7f68]
|
sql/sql_parse.cc:1489(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x5ba035]
|
sql/sql_parse.cc:1111(do_command(THD*))[0x5bb2f7]
|
sql/sql_connect.cc:1349(do_handle_one_connection(THD*))[0x689883]
|
sql/sql_connect.cc:1263(handle_one_connection)[0x689aa2]
|
perfschema/pfs.cc:1863(pfs_spawn_thread)[0xafa679]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x6b50)[0x7fe8b782eb50]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fe8b655b95d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fe637e3d020): is an invalid pointer
|
Connection ID (thread ID): 13
|
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,exists_to_in=on
|
|
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.
|
151215 16:48:54 mysqld_safe Number of processes running now: 0
|
151215 16:48:54 mysqld_safe WSREP: not restarting wsrep node automatically
|
151215 16:48:54 mysqld_safe mysqld from pid file /srv/cluster/tmp/mysqld.pid ended
|
Attachments
Issue Links
- relates to
-
MDEV-9401 wsrep_forced_binlog_format With Binlog Causes Crash
- Closed