[MDEV-15589] InnoDB: Failing assertion: xid_seqno > trx_sys_cur_xid_seqno in trx_sys_update_wsrep_checkpoint Created: 2018-03-16  Updated: 2022-01-20  Resolved: 2022-01-20

Status: Closed
Project: MariaDB Server
Component/s: Galera, Storage Engine - InnoDB, wsrep
Affects Version/s: 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 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.



 Comments   
Comment by Elena Stepanova [ 2022-01-15 ]

jplindst,

The issue is closed as fixed, but there are no related commits, and not surprisingly, it is still reproducible on 10.2. Could you please clarify?

Comment by Jan Lindström (Inactive) [ 2022-01-20 ]

 

mysqltest: At line 4: query 'SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-1'' failed: 1231: Variable 'wsrep_start_position' can't be set to the value of '00000000-0000-0000-0000-000000000000:-1'
{noformat]

Generated at Thu Feb 08 08:22:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.