Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.0.13-galera
-
None
-
RHEL 6.5 x86-64
Description
I'm doing INSERT on one node and UPDATE on another. It often leads to a crash on the node where I'm executing UPDATE.
Thread pointer: 0x0x7f711aff3008
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 = 0x7f710b5b4ce0 thread_stack 0x48000
/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xb9541b]
/usr/sbin/mysqld(handle_fatal_signal+0x398)[0x744b48]
/lib64/libpthread.so.0[0x3166e0f710]
/lib64/libc.so.6[0x3166b3f3c0]
/usr/sbin/mysqld(_ZNK19rpl_sql_thread_info22cached_charset_compareEPc+0x20)[0x69b460]
/usr/sbin/mysqld(_ZN15Query_log_event14do_apply_eventEP14rpl_group_infoPKcj+0x86f)[0x802bdf]
/usr/sbin/mysqld(_Z14wsrep_apply_cbPvPKvmjPK14wsrep_trx_meta+0x525)[0x6f1c05]
/usr/lib64/galera/libgalera_smm.so(ZNK6galera9TrxHandle5applyEPvPF15wsrep_cb_statusS1_PKvmjPK14wsrep_trx_metaERS6+0xb1)[0x7f71409542c1]
/usr/lib64/galera/libgalera_smm.so(+0x1aaf95)[0x7f714098bf95]
/usr/lib64/galera/libgalera_smm.so(_ZN6galera13ReplicatorSMM10replay_trxEPNS_9TrxHandleEPv+0x12e)[0x7f714098c85e]
/usr/lib64/galera/libgalera_smm.so(galera_replay_trx+0x5c)[0x7f71409a045c]
/usr/sbin/mysqld(_Z24wsrep_replay_transactionP3THD+0x2de)[0x6f379e]
/usr/sbin/mysqld[0x5e24b0]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x16d0)[0x5e3c30]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x132)[0x5e4402]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x54b)[0x6a31cb]
/usr/sbin/mysqld(handle_one_connection+0x42)[0x6a32c2]
/lib64/libpthread.so.0[0x3166e079d1]
/lib64/libc.so.6(clone+0x6d)[0x3166ae886d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f711b19f351): UPDATE t1 SET v=v+1 WHERE k=30
Connection ID (thread ID): 5
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=on,exists_to_in=on
Tail of general log:
140912 17:02:44 1 Query INSERT INTO t1 (k,j) VALUES (29,11)
1 Query INSERT INTO t1 (k,j) VALUES (29,12)
1 Query INSERT INTO t1 (k,j) VALUES (29,13)
1 Query INSERT INTO t1 (k,j) VALUES (29,14)
1 Query INSERT INTO t1 (k,j) VALUES (29,15)
1 Query INSERT INTO t1 (k,j) VALUES (29,16)
1 Query INSERT INTO t1 (k,j) VALUES (29,17)
1 Query INSERT INTO t1 (k,j) VALUES (29,18)
1 Query INSERT INTO t1 (k,j) VALUES (29,19)
5 Query UPDATE t1 SET v=v+1 WHERE k=29
1 Query INSERT INTO t1 (k,j) VALUES (30,0)
1 Query INSERT INTO t1 (k,j) VALUES (30,1)
1 Query INSERT INTO t1 (k,j) VALUES (30,2)
1 Query INSERT INTO t1 (k,j) VALUES (30,3)
1 Query INSERT INTO t1 (k,j) VALUES (30,4)
1 Query INSERT INTO t1 (k,j) VALUES (30,5)
1 Query INSERT INTO t1 (k,j) VALUES (30,6)
1 Query INSERT INTO t1 (k,j) VALUES (30,7)
1 Query INSERT INTO t1 (k,j) VALUES (30,8)
1 Query INSERT INTO t1 (k,j) VALUES (30,9)
1 Query INSERT INTO t1 (k,j) VALUES (30,10)
1 Query INSERT INTO t1 (k,j) VALUES (30,11)
1 Query INSERT INTO t1 (k,j) VALUES (30,12)
1 Query INSERT INTO t1 (k,j) VALUES (30,13)
1 Query INSERT INTO t1 (k,j) VALUES (30,14)
1 Query INSERT INTO t1 (k,j) VALUES (30,15)
1 Query INSERT INTO t1 (k,j) VALUES (30,16)
1 Query INSERT INTO t1 (k,j) VALUES (30,17)
5 Query UPDATE t1 SET v=v+1 WHERE k=30
1 Query INSERT INTO t1 (k,j) VALUES (30,18)
1 Query INSERT INTO t1 (k,j) VALUES (30,19)