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

    Details

      Description

      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
      

      To reproduce:

      git clone https://github.com/elenst/rqg --branch mdev15589 rqg-mdev15589
      cd rqg-mdev15589
      perl ./runall-new.pl \
      --grammar=conf/mariadb/oltp.yy \
      --gendata=conf/mariadb/oltp.zz \
      --redefine=conf/mariadb/bulk_insert.yy \
      --duration=300 --threads=2 \
      --mysqld=--log-bin --mysqld=--binlog-format=row \
      --mysqld=--wsrep-on --mysqld=--wsrep_cluster_address=gcomm:// \
      --mysqld=--innodb_autoinc_lock_mode=2 --mysqld=--innodb_flush_log_at_trx_commit=0 --mysqld=--innodb_locks_unsafe_for_binlog=1 \
      --vardir=/dev/shm/vardir \
      --mysqld=--wsrep-provider=<your galera library> \
      --basedir=<your basedir>
      

        Attachments

          Activity

            People

            • Assignee:
              jplindst Jan Lindström
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: