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

InnoDB: Failing assertion: xid_seqno > trx_sys_cur_xid_seqno in trx_sys_update_wsrep_checkpoint

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-1';
      SET @@global.wsrep_start_position=default;
      

      10.1 dbb3960ad8d

      2018-03-16 19:26:33 7f31f79f5b00  InnoDB: Assertion failure in thread 139852584540928 in file trx0sys.cc line 364
      InnoDB: Failing assertion: xid_seqno > trx_sys_cur_xid_seqno
       
      # 2018-03-16T19:26:39 [10420] #5  0x00007f31f8c4f3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
      # 2018-03-16T19:26:39 [10420] #6  0x00005622d7658f5e in trx_sys_update_wsrep_checkpoint (xid=0x7f31bcd27f78, sys_header=0x7f31d77dc026 "", mtr=0x7f31f79f2cb0) at /data/src/10.1/storage/xtradb/trx/trx0sys.cc:364
      # 2018-03-16T19:26:39 [10420] #7  0x00005622d766014d in trx_write_serialisation_history (trx=0x7f31bcd27d78, mtr=0x7f31f79f2cb0) at /data/src/10.1/storage/xtradb/trx/trx0trx.cc:1236
      # 2018-03-16T19:26:39 [10420] #8  0x00005622d76611b9 in trx_commit_low (trx=0x7f31bcd27d78, mtr=0x7f31f79f2cb0) at /data/src/10.1/storage/xtradb/trx/trx0trx.cc:1621
      # 2018-03-16T19:26:39 [10420] #9  0x00005622d766127d in trx_commit (trx=0x7f31bcd27d78) at /data/src/10.1/storage/xtradb/trx/trx0trx.cc:1668
      # 2018-03-16T19:26:39 [10420] #10 0x00005622d7661c26 in trx_commit_for_mysql (trx=0x7f31bcd27d78) at /data/src/10.1/storage/xtradb/trx/trx0trx.cc:1932
      # 2018-03-16T19:26:39 [10420] #11 0x00005622d74c1432 in innobase_commit_low (trx=0x7f31bcd27d78) at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:4685
      # 2018-03-16T19:26:39 [10420] #12 0x00005622d74c170f in innobase_commit_ordered_2 (trx=0x7f31bcd27d78, thd=0x7f31c72f9070) at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:4829
      # 2018-03-16T19:26:39 [10420] #13 0x00005622d74c1ad2 in innobase_commit (hton=0x7f31f84376f0, thd=0x7f31c72f9070, commit_trx=false) at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:4966
      # 2018-03-16T19:26:39 [10420] #14 0x00005622d718dc85 in commit_one_phase_2 (thd=0x7f31c72f9070, all=false, trans=0x7f31c72fc288, is_real_trans=true) at /data/src/10.1/sql/handler.cc:1570
      # 2018-03-16T19:26:39 [10420] #15 0x00005622d718d7ae in ha_commit_trans (thd=0x7f31c72f9070, all=false) at /data/src/10.1/sql/handler.cc:1470
      # 2018-03-16T19:26:39 [10420] #16 0x00005622d7097864 in trans_commit_stmt (thd=0x7f31c72f9070) at /data/src/10.1/sql/transaction.cc:431
      # 2018-03-16T19:26:39 [10420] #17 0x00005622d6f58194 in mysql_execute_command (thd=0x7f31c72f9070) at /data/src/10.1/sql/sql_parse.cc:5747
      # 2018-03-16T19:26:39 [10420] #18 0x00005622d6f5c2c6 in mysql_parse (thd=0x7f31c72f9070, rawbuf=0x7f31bcc25088 "LOAD DATA INFILE 'load_oltp3' REPLACE INTO TABLE oltp3 /* QNO 486 CON_ID 10 */", length=78, parser_state=0x7f31f79f4630) at /data/src/10.1/sql/sql_parse.cc:7352
      # 2018-03-16T19:26:39 [10420] #19 0x00005622d6f5ba28 in wsrep_mysql_parse (thd=0x7f31c72f9070, rawbuf=0x7f31bcc25088 "LOAD DATA INFILE 'load_oltp3' REPLACE INTO TABLE oltp3 /* QNO 486 CON_ID 10 */", length=78, parser_state=0x7f31f79f4630) at /data/src/10.1/sql/sql_parse.cc:7175
      # 2018-03-16T19:26:39 [10420] #20 0x00005622d6f4b0f2 in dispatch_command (command=COM_QUERY, thd=0x7f31c72f9070, packet=0x7f31c7304071 " LOAD DATA INFILE 'load_oltp3' REPLACE INTO TABLE oltp3 /* QNO 486 CON_ID 10 */ ", packet_length=80) at /data/src/10.1/sql/sql_parse.cc:1475
      # 2018-03-16T19:26:39 [10420] #21 0x00005622d6f49eb7 in do_command (thd=0x7f31c72f9070) at /data/src/10.1/sql/sql_parse.cc:1106
      # 2018-03-16T19:26:39 [10420] #22 0x00005622d7082c43 in do_handle_one_connection (thd_arg=0x7f31c72f9070) at /data/src/10.1/sql/sql_connect.cc:1330
      # 2018-03-16T19:26:39 [10420] #23 0x00005622d70829a7 in handle_one_connection (arg=0x7f31c72f9070) at /data/src/10.1/sql/sql_connect.cc:1242
      # 2018-03-16T19:26:39 [10420] #24 0x00007f31fa94a494 in start_thread (arg=0x7f31f79f5b00) at pthread_create.c:333
      # 2018-03-16T19:26:39 [10420] #25 0x00007f31f8d0393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Not reproducible on 10.3+.
      No obvious problem on a non-debug build.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.