Prevent cleanup of statement diagnostic area in case of transaction replay.
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:
Venkatesh Prasad August 6, 2020 at 6:46 AMEdited
Hi Kamil!
I just saw that the same test can fail with two different reasons.
1. Test fails due to the wrong value of ROW_COUNT() returned by the previous update query.
56 if (`SELECT @@error_count = 0`) {
57 if (`SELECT $row_count = 0`) {
58 --die ROW_COUNT() = 0
59 }
60 }and when it happens, the test fails with below error.
galera.MW-329 w5 [ fail ]
Test ended at 2020-08-06 11:46:25CURRENT_TEST: galera.MW-329
mysqltest: At line 58: ROW_COUNT() = 0The result from queries just before the failure was:
CREATE TABLE t1 (f1 INTEGER, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
INSERT INTO t1 (f1) VALUES (1),(65535);
FLUSH STATUS;
SELECT VARIABLE_VALUE = 0 FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_replays';
VARIABLE_VALUE = 0
1
CREATE PROCEDURE proc_insert ()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
SET SESSION wsrep_sync_wait = 0;
WHILE 1 DO
INSERT INTO t1 (f1) VALUES (FLOOR( 1 + RAND( ) * 65535 ));
END WHILE;
END|
CALL proc_insert();;
select sleep(0.5);
sleep(0.5)
0
safe_process[77406]: Child process: 77407, exit: 1 - the logfile can be found in '/home/venki/work/pxc/3352/80/bld/mysql-test/var/log/galera.MW-329/MW-329.log'
Only 1 of 41 completed.
Not all tests completed. This means that a test scheduled for a worker did not report anything, the worker most likely crashed.
------------------------------------------------------------------------------
The servers were restarted 0 times2. Test fails due to the default timeout by the MTR.
galera.MW-329 w1 [ pass ] 14162
worker[2] Trying to dump core for [mysqltest - pid: 81605, winpid: 81605]
worker[2] Trying to dump core for [mysqld.1 - pid: 77858, winpid: 77858]
worker[2] Trying to dump core for [mysqld.2 - pid: 77948, winpid: 77948]
galera.MW-329 w2 [ fail ] timeout after 120 seconds
Test ended at 2020-08-06 11:55:44Test case timeout after 120 secondsmysqltest: At line 53: UPDATE t1 SET f2 = '$signature'== /home/venki/work/pxc/3352/80/bld/mysql-test/var/2/log/MW-329.log ==
CREATE TABLE t1 (f1 INTEGER, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
INSERT INTO t1 (f1) VALUES (1),(65535);
FLUSH STATUS;
SELECT VARIABLE_VALUE = 0 FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_replays';
VARIABLE_VALUE = 0
1
CREATE PROCEDURE proc_insert ()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
SET SESSION wsrep_sync_wait = 0;
WHILE 1 DO
INSERT INTO t1 (f1) VALUES (FLOOR( 1 + RAND( ) * 65535 ));
END WHILE;
END|
CALL proc_insert();;
select sleep(0.5);
sleep(0.5)
0
Server [mysqld.1 - pid: 77858, winpid: 77858, exit: 256] log:
The test is not a deterministic test case as it one session performs concurrent inserts on node1 and performs updates on node2. Also that we RAND() is being used for inserting the rows on node1, there is a possiblity that updates on node2 may conflict with the inserts coming from node1 and may cause the test to hang. Below are the stack traces from node2
Applier thread waiting in the lock_wait.
Thread 8 (Thread 0x7f4f6b02d700 (LWP 77960)):
warning: Unexpected size of section `.reg-xstate/77960' in core file.
#0 futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x7f4f540dd274) at ../sysdeps/nptl/futex-internal.h:183
#1 __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x7f4f540dd220, cond=0x7f4f540dd248) at pthread_cond_wait.c:508
#2 __pthread_cond_wait (cond=0x7f4f540dd248, mutex=0x7f4f540dd220) at pthread_cond_wait.c:638
#3 0x000055e29a0ee5fc in os_event::wait (this=0x7f4f540dd208) at /home/venki/work/pxc/3352/80/storage/innobase/os/os0event.cc:189
#4 0x000055e29a0ed300 in os_event::wait_low (this=0x7f4f540dd208, reset_sig_count=18) at /home/venki/work/pxc/3352/80/storage/innobase/os/os0event.cc:372
#5 0x000055e29a0eda28 in os_event_wait_low (event=0x7f4f540dd208, reset_sig_count=0) at /home/venki/work/pxc/3352/80/storage/innobase/os/os0event.cc:608
#6 0x000055e29a05b1dd in lock_wait_suspend_thread (thr=0x7f4f540b61c8) at /home/venki/work/pxc/3352/80/storage/innobase/lock/lock0wait.cc:398
#7 0x000055e29a17afe0 in row_mysql_handle_errors (new_err=0x7f4f6b0297f8, trx=0x7f4f6850ed50, thr=0x7f4f540b61c8, savept=0x7f4f6b029800) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0mysql.cc:1175
#8 0x000055e29a17db74 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7f4f5401ef88 "\371", <incomplete sequence \344>, prebuilt=0x7f4f540b5688) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0mysql.cc:2119
#9 0x000055e29a17e15d in row_insert_for_mysql (mysql_rec=0x7f4f5401ef88 "\371", <incomplete sequence \344>, prebuilt=0x7f4f540b5688) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0mysql.cc:2236
#10 0x000055e299f37af6 in ha_innobase::write_row (this=0x7f4f540b3d18, record=0x7f4f5401ef88 "\371", <incomplete sequence \344>) at /home/venki/work/pxc/3352/80/storage/innobase/handler/ha_innodb.cc:9926
#11 0x000055e2984fecc3 in handler::ha_write_row (this=0x7f4f540b3d18, buf=0x7f4f5401ef88 "\371", <incomplete sequence \344>) at /home/venki/work/pxc/3352/80/sql/handler.cc:8477
#12 0x000055e299a3c3cb in Write_rows_log_event::write_row (this=0x7f4f55246fa0, rli=0x7f4f5400a740, overwrite=false) at /home/venki/work/pxc/3352/80/sql/log_event.cc:12076
#13 0x000055e299a3cfb8 in Write_rows_log_event::do_exec_row (this=0x7f4f55246fa0, rli=0x7f4f5400a740) at /home/venki/work/pxc/3352/80/sql/log_event.cc:12253
#14 0x000055e299a323c4 in Rows_log_event::do_apply_row (this=0x7f4f55246fa0, rli=0x7f4f5400a740) at /home/venki/work/pxc/3352/80/sql/log_event.cc:8789
#15 0x000055e299a35fa9 in Rows_log_event::do_apply_event (this=0x7f4f55246fa0, rli=0x7f4f5400a740) at /home/venki/work/pxc/3352/80/sql/log_event.cc:10077
#16 0x000055e299a1cd9e in Log_event::apply_event (this=0x7f4f55246fa0, rli=0x7f4f5400a740) at /home/venki/work/pxc/3352/80/sql/log_event.cc:3243
#17 0x000055e298e566b3 in wsrep_apply_events (thd=0x7f4f54000b80, rli=0x7f4f5400a740, events_buf=0x7f4f707d26e0, buf_len=0) at /home/venki/work/pxc/3352/80/sql/wsrep_applier.cc:201
#18 0x000055e298bb1f20 in Wsrep_applier_service::apply_write_set (this=0x7f4f6b02cc30, ws_meta=..., data=...) at /home/venki/work/pxc/3352/80/sql/wsrep_high_priority_service.cc:585
#19 0x000055e29a96c853 in apply_write_set (server_state=..., high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /home/venki/work/pxc/3352/80/wsrep-lib/src/server_state.cpp:330
#20 0x000055e29a970540 in wsrep::server_state::on_apply (this=0x55e29e7ab320, high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /home/venki/work/pxc/3352/80/wsrep-lib/src/server_state.cpp:1120
#21 0x000055e29a987fa9 in wsrep::high_priority_service::apply (this=0x7f4f6b02cc30, ws_handle=..., ws_meta=..., data=...) at /home/venki/work/pxc/3352/80/wsrep-lib/include/wsrep/high_priority_service.hpp:46
#22 0x000055e29a9850cb in (anonymous namespace)::apply_cb (ctx=0x7f4f6b02cc30, wsh=0x7f4f6b02bc40, flags=65, buf=0x7f4f6b02bc50, meta=0x7f4f6b02bf10, exit_loop=0x7f4f6b02becf) at /home/venki/work/pxc/3352/80/wsrep-lib/src/wsrep_provider_v26.cpp:500
#23 0x00007f4f7639a7b2 in galera::TrxHandleSlave::apply (this=this@entry=0x7f4f54a4d180, recv_ctx=recv_ctx@entry=0x7f4f6b02cc30, apply_cb=0x55e29a984e98 <(anonymous namespace)::apply_cb(void*, wsrep_ws_handle_t const*, uint32_t, wsrep_buf_t const*, wsrep_trx_meta_t const*, wsrep_bool_t*)>, meta=..., exit_loop=exit_loop@entry=@0x7f4f6b02becf: false) at galera/src/trx_handle.cpp:418
#24 0x00007f4f763e145b in galera::ReplicatorSMM::apply_trx (this=0x55e29e7e16e0, recv_ctx=0x7f4f6b02cc30, ts=...) at galera/src/replicator_smm.cpp:591
#25 0x00007f4f763e8b6f in galera::ReplicatorSMM::process_trx (this=0x55e29e7e16e0, recv_ctx=0x7f4f6b02cc30, ts_ptr=...) at galera/src/replicator_smm.cpp:2277
#26 0x00007f4f763bb972 in galera::GcsActionSource::process_writeset (this=0x55e29e7ed7d0, recv_ctx=0x7f4f6b02cc30, act=..., exit_loop=@0x7f4f6b02c7df: false) at galera/src/gcs_action_source.cpp:62
#27 0x00007f4f763bbb13 in galera::GcsActionSource::dispatch (this=<optimized out>, recv_ctx=<optimized out>, act=..., exit_loop=<optimized out>) at galera/src/gcs_action_source.cpp:109
#28 0x00007f4f763bbd38 in galera::GcsActionSource::process (this=0x55e29e7ed7d0, recv_ctx=0x7f4f6b02cc30, exit_loop=@0x7f4f6b02c7df: false) at galera/src/gcs_action_source.cpp:182
#29 0x00007f4f763e6203 in galera::ReplicatorSMM::async_recv (this=0x55e29e7e16e0, recv_ctx=0x7f4f6b02cc30) at galera/src/replicator_smm.cpp:466
#30 0x00007f4f764037d2 in galera_recv (gh=<optimized out>, recv_ctx=<optimized out>) at galera/src/wsrep_provider.cpp:236
#31 0x000055e29a985ef0 in wsrep::wsrep_provider_v26::run_applier (this=0x55e29e7ab680, applier_ctx=0x7f4f6b02cc30) at /home/venki/work/pxc/3352/80/wsrep-lib/src/wsrep_provider_v26.cpp:715
#32 0x000055e298bde653 in wsrep_replication_process (thd=0x7f4f54000b80, arg=0x0) at /home/venki/work/pxc/3352/80/sql/wsrep_thd.cc:58
#33 0x000055e298721f4b in start_wsrep_THD (arg=0x55e29e826f60) at /home/venki/work/pxc/3352/80/sql/mysqld.cc:9352
#34 0x000055e29a61666b in pfs_spawn_thread (arg=0x55e29e80a800) at /home/venki/work/pxc/3352/80/storage/perfschema/pfs.cc:2855
#35 0x00007f4f8146e609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#36 0x00007f4f80bde103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Client thread rolling back the transaction. Probably because of commit error.
Thread 12 (Thread 0x7f4f68397700 (LWP 81584)):
warning: Unexpected size of section `.reg-xstate/81584' in core file.
#0 0x000055e299f74fc2 in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x7f4f4c348588, n_spins=30, n_delay=6, name=0x55e29bf85a70 "/home/venki/work/pxc/3352/80/storage/innobase/buf/buf0buf.cc", line=5455) at /home/venki/work/pxc/3352/80/storage/innobase/include/ib0mutex.h:761
#1 0x000055e29a36e065 in buf_page_io_complete (bpage=0x7f4f49ed3bc0, evict=false) at /home/venki/work/pxc/3352/80/storage/innobase/buf/buf0buf.cc:5455
#2 0x000055e29a3a70ea in buf_read_page_low (err=0x7f4f6838f594, sync=true, type=0, mode=132, page_id=..., page_size=..., unzip=false, trx=0x0, should_buffer=false) at /home/venki/work/pxc/3352/80/storage/innobase/buf/buf0rea.cc:143
#3 0x000055e29a3a7812 in buf_read_page (page_id=..., page_size=..., trx=0x0) at /home/venki/work/pxc/3352/80/storage/innobase/buf/buf0rea.cc:291
#4 0x000055e29a377d77 in Buf_fetch<Buf_fetch_normal>::read_page (this=0x7f4f6838fa10) at /home/venki/work/pxc/3352/80/storage/innobase/buf/buf0buf.cc:3875
#5 0x000055e29a369aba in Buf_fetch_normal::get (this=0x7f4f6838fa10, block=@0x7f4f6838f978: 0x0) at /home/venki/work/pxc/3352/80/storage/innobase/buf/buf0buf.cc:3517
#6 0x000055e29a378b6f in Buf_fetch<Buf_fetch_normal>::single_page (this=0x7f4f6838fa10) at /home/venki/work/pxc/3352/80/storage/innobase/buf/buf0buf.cc:4081
#7 0x000055e29a36a0ae in buf_page_get_gen (page_id=..., page_size=..., rw_latch=2, guess=0x0, mode=Page_fetch::NORMAL, file=0x55e29bf0b280 "/home/venki/work/pxc/3352/80/storage/innobase/row/row0row.cc", line=912, mtr=0x7f4f68391600, dirty_with_no_latch=false, err=0x7f4f6838fce0) at /home/venki/work/pxc/3352/80/storage/innobase/buf/buf0buf.cc:4279
#8 0x000055e29a32ab33 in btr_cur_search_to_nth_level (index=0x7f4f540b9148, level=0, tuple=0x7f4ea40f4e20, mode=PAGE_CUR_LE, latch_mode=2, cursor=0x7f4ea44dbb08, has_search_latch=0, file=0x55e29bf0b280 "/home/venki/work/pxc/3352/80/storage/innobase/row/row0row.cc", line=912, mtr=0x7f4f68391600) at /home/venki/work/pxc/3352/80/storage/innobase/btr/btr0cur.cc:996
#9 0x000055e29a00e888 in btr_pcur_t::open (this=0x7f4ea44dbb08, index=0x7f4f540b9148, level=0, tuple=0x7f4ea40f4e20, mode=PAGE_CUR_LE, latch_mode=2, mtr=0x7f4f68391600, file=0x55e29bf0b280 "/home/venki/work/pxc/3352/80/storage/innobase/row/row0row.cc", line=912) at /home/venki/work/pxc/3352/80/storage/innobase/include/btr0pcur.h:649
#10 0x000055e29a1d0c6e in row_search_on_row_ref (pcur=0x7f4ea44dbb08, mode=2, table=0x7f4f540b8458, ref=0x7f4ea40f4e20, mtr=0x7f4f68391600) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0row.cc:912
#11 0x000055e29a1ee0e1 in row_undo_search_clust_to_pcur (node=0x7f4ea44dba98) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0undo.cc:178
#12 0x000055e29a58006c in row_undo_mod_parse_undo_rec (node=0x7f4ea44dba98, thd=0x7f4ea45e5450, mdl=0x7f4f68391bd8) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0umod.cc:1257
#13 0x000055e29a5802e6 in row_undo_mod (node=0x7f4ea44dba98, thr=0x7f4ea4002da0) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0umod.cc:1289
#14 0x000055e29a1ee6ca in row_undo (node=0x7f4ea44dba98, thr=0x7f4ea4002da0) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0undo.cc:300
#15 0x000055e29a1ee93f in row_undo_step (thr=0x7f4ea4002da0) at /home/venki/work/pxc/3352/80/storage/innobase/row/row0undo.cc:362
#16 0x000055e29a11ef62 in que_thr_step (thr=0x7f4ea4002da0) at /home/venki/work/pxc/3352/80/storage/innobase/que/que0que.cc:923
#17 0x000055e29a11f13c in que_run_threads_low (thr=0x7f4ea4002da0) at /home/venki/work/pxc/3352/80/storage/innobase/que/que0que.cc:976
#18 0x000055e29a11f31d in que_run_threads (thr=0x7f4ea4002da0) at /home/venki/work/pxc/3352/80/storage/innobase/que/que0que.cc:1011
#19 0x000055e29a28e567 in trx_rollback_to_savepoint_low (trx=0x7f4f6850f1b0, savept=0x0) at /home/venki/work/pxc/3352/80/storage/innobase/trx/trx0roll.cc:117
#20 0x000055e29a28e896 in trx_rollback_for_mysql_low (trx=0x7f4f6850f1b0) at /home/venki/work/pxc/3352/80/storage/innobase/trx/trx0roll.cc:176
#21 0x000055e29a28ec12 in trx_rollback_low (trx=0x7f4f6850f1b0) at /home/venki/work/pxc/3352/80/storage/innobase/trx/trx0roll.cc:206
#22 0x000055e29a28f004 in trx_rollback_for_mysql (trx=0x7f4f6850f1b0) at /home/venki/work/pxc/3352/80/storage/innobase/trx/trx0roll.cc:282
#23 0x000055e299f2db2e in innobase_rollback (hton=0x55e29e8d6580, thd=0x7f4ea45e5450, rollback_trx=false) at /home/venki/work/pxc/3352/80/storage/innobase/handler/ha_innodb.cc:6325
#24 0x000055e2984ea310 in ha_rollback_low (thd=0x7f4ea45e5450, all=false) at /home/venki/work/pxc/3352/80/sql/handler.cc:2129
#25 0x000055e2999e1bf1 in MYSQL_BIN_LOG::rollback (this=0x55e29d3ce700 <mysql_bin_log>, thd=0x7f4ea45e5450, all=false) at /home/venki/work/pxc/3352/80/sql/binlog.cc:2581
#26 0x000055e2984eaa7f in ha_rollback_trans (thd=0x7f4ea45e5450, all=false) at /home/venki/work/pxc/3352/80/sql/handler.cc:2231
#27 0x000055e2984e9773 in ha_commit_trans (thd=0x7f4ea45e5450, all=false, ignore_global_read_lock=false) at /home/venki/work/pxc/3352/80/sql/handler.cc:1841
#28 0x000055e298b233b3 in trans_commit_stmt (thd=0x7f4ea45e5450, ignore_global_read_lock=false) at /home/venki/work/pxc/3352/80/sql/transaction.cc:556
#29 0x000055e29898517e in mysql_execute_command (thd=0x7f4ea45e5450, first_level=true) at /home/venki/work/pxc/3352/80/sql/sql_parse.cc:5667
#30 0x000055e2989876cf in mysql_parse (thd=0x7f4ea45e5450, parser_state=0x7f4f68395b40, update_userstat=false) at /home/venki/work/pxc/3352/80/sql/sql_parse.cc:6369
#31 0x000055e29898b764 in wsrep_mysql_parse (thd=0x7f4ea45e5450, rawbuf=0x7f4ea483fb08 "UPDATE t1 SET f2 = '032dcc085e'", length=31, parser_state=0x7f4f68395b40, update_userstat=false) at /home/venki/work/pxc/3352/80/sql/sql_parse.cc:7650
#32 0x000055e2989788c4 in dispatch_command (thd=0x7f4ea45e5450, com_data=0x7f4f68396c10, command=COM_QUERY) at /home/venki/work/pxc/3352/80/sql/sql_parse.cc:2125
#33 0x000055e2989761d9 in do_command (thd=0x7f4ea45e5450) at /home/venki/work/pxc/3352/80/sql/sql_parse.cc:1433
#34 0x000055e298b80d92 in handle_connection (arg=0x55e29e8dbfd0) at /home/venki/work/pxc/3352/80/sql/conn_handler/connection_handler_per_thread.cc:312
#35 0x000055e29a61666b in pfs_spawn_thread (arg=0x55e29e774520) at /home/venki/work/pxc/3352/80/storage/perfschema/pfs.cc:2855
#36 0x00007f4f8146e609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#37 0x00007f4f80bde103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Kamil Holubicki August 5, 2020 at 2:05 PM
Hi @Venkatesh Prasad,
I'm not sure if this is the same. I was able to reproduce test instability with the following:
./mysql-test/mtr MW-329{,} --parallel=2 --memor even faster:
./mysql-test/mtr MW-329{,} --parallel=2 --mem --testcase-timeout=2But the result is slightly different
worker[5] Trying to dump core for [mysqltest - pid: 11443, winpid: 11443]
worker[5] Trying to dump core for [mysqld.1 - pid: 16172, winpid: 16172]
worker[5] Trying to dump core for [mysqld.2 - pid: 16601, winpid: 16601]
galera.MW-329 w5 [ fail ] timeout after 900 seconds
Test ended at 2020-08-05 15:27:43Test case timeout after 900 secondsmysqltest: At line 53: UPDATE t1 SET f2 = '$signature'== /home/kamil/repo/pxc/8.0/bld/mysql-test/var/5/log/MW-329.log ==
CREATE TABLE t1 (f1 INTEGER, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
INSERT INTO t1 (f1) VALUES (1),(65535);
FLUSH STATUS;
SELECT VARIABLE_VALUE = 0 FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_replays';
VARIABLE_VALUE = 0
1
CREATE PROCEDURE proc_insert ()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
SET SESSION wsrep_sync_wait = 0;
WHILE 1 DO
INSERT INTO t1 (f1) VALUES (FLOOR( 1 + RAND( ) * 65535 ));
END WHILE;
END|
CALL proc_insert();;
select sleep(0.5);
sleep(0.5)
0
It is reproducible 100% time.
Is it the same as for you (test failing with timeout)?
Done
Details
Details
Assignee
Kamil Holubicki
Kamil HolubickiReporter
Venkatesh Prasad
Venkatesh PrasadNeeds Review
Yes
Original estimate
Time tracking
Fix versions
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created June 5, 2020 at 11:57 AM
Updated March 6, 2024 at 9:30 PM
Resolved September 1, 2020 at 2:40 PM
The galera test MW-329 fails under high load.
galera.MW-329 w5 [ fail ] Test ended at 2020-06-05 11:18:37CURRENT_TEST: galera.MW-329 mysqltest: At line 58: ROW_COUNT() = 0The result from queries just before the failure was: CREATE TABLE t1 (f1 INTEGER, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB; INSERT INTO t1 (f1) VALUES (1),(65535); FLUSH STATUS; SELECT VARIABLE_VALUE = 0 FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_replays'; VARIABLE_VALUE = 0 1 CREATE PROCEDURE proc_insert () BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END; SET SESSION wsrep_sync_wait = 0; WHILE 1 DO INSERT INTO t1 (f1) VALUES (FLOOR( 1 + RAND( ) * 65535 )); END WHILE; END| CALL proc_insert();; select sleep(0.5); sleep(0.5) 0 safe_process[29206]: Child process: 29208, exit: 1Steps to reproduce:
./mtr MW-329{,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,} --parallel=6 --mem