Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1(EOL), 10.2(EOL)
-
None
Description
_Note: there is already a bug report about such assertion failure, MDEV-10379, but it says only XtraDB is affected, and only REPLACE. In my case it happens with InnoDB (10.1 and 10.2), and there is wsrep_provider_options=repl.commit_order involved, it has to be lower than default 3.
You might need to run the test case more than once. It fails reliably for me, but sometimes it can fail too early because of Galera not being ready to serve.
perl ./mtr mytest --mysqld=--binlog_format=ROW --mysqld=--wsrep_on=ON --mysqld=--wsrep_provider=/usr/lib/galera/libgalera_smm.so --mysqld=--wsrep_cluster_address=gcomm:// --mysqld=--wsrep_provider_options=repl.commit_order=2
|
mytest |
--source include/have_innodb.inc
|
--send
|
CREATE TABLE IF NOT EXISTS test.t1 (id BIGINT, PRIMARY KEY(id)) ENGINE = InnoDB; |
--connect (con10,localhost,root,,test)
|
--error ER_OPTION_PREVENTS_STATEMENT
|
SELECT 'test' INTO OUTFILE '/tmp/31231.tmp'; |
CREATE TABLE IF NOT EXISTS test.t1 (id BIGINT, PRIMARY KEY(id)) ENGINE = InnoDB; |
INSERT INTO test.t1 SET id = 1; |
10.1 3976ec1e83 |
2017-06-13 23:58:09 140432838343424 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2017-06-13 23:58:09 140432838343424 [Note] WSREP: REPL Protocols: 7 (3, 2)
|
2017-06-13 23:58:09 140432838343424 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
|
2017-06-13 23:58:09 140432553375488 [Note] WSREP: Service thread queue flushed.
|
2017-06-13 23:58:09 140432838343424 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00d37a01-507b-11e7-bb54-57a0f29bc5b6:0)
|
2017-06-13 23:58:09 140432838343424 [Note] WSREP: Synchronized with group, ready for connections
|
2017-06-13 23:58:09 140432838343424 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2017-06-13 23:58:10 140432837065472 [Note] WSREP: MDL BF-BF conflict
|
schema: test
|
request: (6 seqno 2 wsrep (2, 1, 0) cmd 3 1 CREATE TABLE IF NOT EXISTS test.t1 (id BIGINT, PRIMARY KEY(id)) ENGINE = InnoDB)
|
granted: (5 seqno 1 wsrep (2, 1, 0) cmd 3 1 CREATE TABLE IF NOT EXISTS test.t1 (id BIGINT, PRIMARY KEY(id)) ENGINE = InnoDB)
|
2017-06-13 23:58:10 7fb91162db00 InnoDB: Assertion failure in thread 140432837368576 in file trx0sys.cc line 358
|
InnoDB: Failing assertion: xid_seqno > trx_sys_cur_xid_seqno
|
#5 0x00007fb90f3e73fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x000055bb00fc3c30 in trx_sys_update_wsrep_checkpoint (xid=0x7fb91162acc0, sys_header=0x7fb8f93dc026 "", mtr=0x7fb91162a200) at /data/src/10.1/storage/xtradb/trx/trx0sys.cc:358
|
#7 0x000055bb00e4ad05 in innobase_wsrep_set_checkpoint (hton=0x7fb90e8380f0, xid=0x7fb91162acc0) at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:19804
|
#8 0x000055bb00a80c7a in set_SE_checkpoint (unused=0x0, plugin=0x7fb91162ac28, arg=0x7fb91162acc0) at /data/src/10.1/sql/wsrep_xid.cc:87
|
#9 0x000055bb008dabd1 in plugin_foreach_with_mask (thd=0x0, func=0x55bb00a80b03 <set_SE_checkpoint(THD*, plugin_ref, void*)>, type=1, state_mask=4294967287, arg=0x7fb91162acc0) at /data/src/10.1/sql/sql_plugin.cc:2362
|
#10 0x000055bb00a80cc3 in wsrep_set_SE_checkpoint (xid=...) at /data/src/10.1/sql/wsrep_xid.cc:94
|
#11 0x000055bb00a80d2b in wsrep_set_SE_checkpoint (uuid=..., seqno=1) at /data/src/10.1/sql/wsrep_xid.cc:101
|
#12 0x000055bb00a6c9ed in wsrep_TOI_end (thd=0x7fb8fa6e5070) at /data/src/10.1/sql/wsrep_mysqld.cc:1475
|
#13 0x000055bb00a6d982 in wsrep_to_isolation_end (thd=0x7fb8fa6e5070) at /data/src/10.1/sql/wsrep_mysqld.cc:1658
|
#14 0x000055bb008ca24a in mysql_execute_command (thd=0x7fb8fa6e5070) at /data/src/10.1/sql/sql_parse.cc:5809
|
#15 0x000055bb008ce06b in mysql_parse (thd=0x7fb8fa6e5070, rawbuf=0x7fb8ebc43088 "CREATE TABLE IF NOT EXISTS test.t1 (id BIGINT, PRIMARY KEY(id)) ENGINE = InnoDB", length=79, parser_state=0x7fb91162c5e0) at /data/src/10.1/sql/sql_parse.cc:7339
|
#16 0x000055bb008cd7e6 in wsrep_mysql_parse (thd=0x7fb8fa6e5070, rawbuf=0x7fb8ebc43088 "CREATE TABLE IF NOT EXISTS test.t1 (id BIGINT, PRIMARY KEY(id)) ENGINE = InnoDB", length=79, parser_state=0x7fb91162c5e0) at /data/src/10.1/sql/sql_parse.cc:7162
|
#17 0x000055bb008bd018 in dispatch_command (command=COM_QUERY, thd=0x7fb8fa6e5070, packet=0x7fb8fabdd071 "CREATE TABLE IF NOT EXISTS test.t1 (id BIGINT, PRIMARY KEY(id)) ENGINE = InnoDB", packet_length=79) at /data/src/10.1/sql/sql_parse.cc:1488
|
#18 0x000055bb008bbdb7 in do_command (thd=0x7fb8fa6e5070) at /data/src/10.1/sql/sql_parse.cc:1109
|
#19 0x000055bb009f34a9 in do_handle_one_connection (thd_arg=0x7fb8fa6e5070) at /data/src/10.1/sql/sql_connect.cc:1349
|
#20 0x000055bb009f320d in handle_one_connection (arg=0x7fb8fa6e5070) at /data/src/10.1/sql/sql_connect.cc:1261
|
#21 0x000055bb00da9e88 in pfs_spawn_thread (arg=0x7fb8fa641770) at /data/src/10.1/storage/perfschema/pfs.cc:1860
|
#22 0x00007fb911350494 in start_thread (arg=0x7fb91162db00) at pthread_create.c:333
|
#23 0x00007fb90f49b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Issue Links
- relates to
-
MDEV-10379 Failing assertion: xid_seqno > trx_sys_cur_xid_seqno
- Closed