Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13085

InnoDB: Failing assertion: xid_seqno > trx_sys_cur_xid_seqno with wsrep_provider_options=repl.commit_order=2

    XMLWordPrintable

Details

    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

          Activity

            People

              jplindst Jan Lindström (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.