[MDEV-25842] Assertion `thd->wsrep_trx_meta.gtid.seqno == (-1) in int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*) Created: 2021-06-02  Updated: 2023-04-11  Resolved: 2023-04-11

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: not-10.2, not-10.4, not-10.5, not-10.6


 Description   

10.3.30 950a2200603d5b4a8f7e978624f38a46bca896bc

mysqld: /test/10.3_dbg/sql/wsrep_mysqld.cc:1867: int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*): Assertion `thd->wsrep_trx_meta.gtid.seqno == (-1)' failed.

10.3.30 950a2200603d5b4a8f7e978624f38a46bca896bc

Core was generated by `/test/GAL_MD010621-mariadb-10.3.30-linux-x86_64-dbg/bin/mysqld --defaults-file='.
Program terminated with signal SIGABRT, Aborted.
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
[Current thread is 1 (Thread 0x752220bd2700 (LWP 2816096))]
(gdb) bt
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1  0x000049bc55b68859 in __GI_abort () at abort.c:79
#2  0x000049bc55b68729 in __assert_fail_base (fmt=0x49bc55cfe588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5575adabefb8 "thd->wsrep_trx_meta.gtid.seqno == (-1)", file=0x5575adabf9c8 "/test/10.3_dbg/sql/wsrep_mysqld.cc", line=1867, function=<optimized out>) at assert.c:92
#3  0x000049bc55b79f36 in __GI___assert_fail (assertion=assertion@entry=0x5575adabefb8 "thd->wsrep_trx_meta.gtid.seqno == (-1)", file=file@entry=0x5575adabf9c8 "/test/10.3_dbg/sql/wsrep_mysqld.cc", line=line@entry=1867, function=function@entry=0x5575adac0420 "int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*)") at assert.c:101
#4  0x00005575ad0cb734 in wsrep_to_isolation_begin (thd=thd@entry=0x9354c000d90, db_=0x0, table_=0x0, table_list=table_list@entry=0x9354c011708, alter_info=alter_info@entry=0x752220bcf2e0) at /test/10.3_dbg/sql/wsrep_mysqld.cc:1867
#5  0x00005575ad02be6a in Sql_cmd_alter_table::execute (this=0x9354c011e40, thd=0x9354c000d90) at /test/10.3_dbg/sql/sql_alter.cc:509
#6  0x00005575acef8106 in mysql_execute_command (thd=thd@entry=0x9354c000d90) at /test/10.3_dbg/sql/sql_parse.cc:6075
#7  0x00005575acefa109 in mysql_parse (thd=thd@entry=0x9354c000d90, rawbuf=rawbuf@entry=0x9354c011628 "ALTER TABLE t1 ADD INDEX a(a)", length=length@entry=29, parser_state=parser_state@entry=0x752220bd1530, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_parse.cc:7870
#8  0x00005575acefb7c8 in wsrep_mysql_parse (thd=thd@entry=0x9354c000d90, rawbuf=0x9354c011628 "ALTER TABLE t1 ADD INDEX a(a)", length=29, parser_state=parser_state@entry=0x752220bd1530, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_parse.cc:7662
#9  0x00005575acefc8e3 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x9354c000d90, packet=packet@entry=0x9354c008e41 "ALTER TABLE t1 ADD INDEX a(a);", packet_length=packet_length@entry=30, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_class.h:1152
#10 0x00005575aceffa58 in do_command (thd=0x9354c000d90) at /test/10.3_dbg/sql/sql_parse.cc:1398
#11 0x00005575ad027cea in do_handle_one_connection (connect=connect@entry=0x5575aed1b100) at /test/10.3_dbg/sql/sql_connect.cc:1403
#12 0x00005575ad027f21 in handle_one_connection (arg=0x5575aed1b100) at /test/10.3_dbg/sql/sql_connect.cc:1308
#13 0x00000e9901508609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#14 0x000049bc55c65293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.3.30 950a2200603d5b4a8f7e978624f38a46bca896bc

mysqld: /test/10.3_dbg/sql/wsrep_mysqld.cc:1867: int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*): Assertion `thd->wsrep_trx_meta.gtid.seqno == (-1)' failed.

10.3.30 950a2200603d5b4a8f7e978624f38a46bca896bc

Core was generated by `/test/GAL_MD010621-mariadb-10.3.30-linux-x86_64-dbg/bin/mysqld --defaults-file='.
Program terminated with signal SIGABRT, Aborted.
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
[Current thread is 1 (Thread 0x44e66e097700 (LWP 4075614))]
(gdb) bt
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1  0x000000006fe33859 in __GI_abort () at abort.c:79
#2  0x000000006fe33729 in __assert_fail_base (fmt=0x6ffc9588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55919e242fb8 "thd->wsrep_trx_meta.gtid.seqno == (-1)", file=0x55919e2439c8 "/test/10.3_dbg/sql/wsrep_mysqld.cc", line=1867, function=<optimized out>) at assert.c:92
#3  0x000000006fe44f36 in __GI___assert_fail (assertion=assertion@entry=0x55919e242fb8 "thd->wsrep_trx_meta.gtid.seqno == (-1)", file=file@entry=0x55919e2439c8 "/test/10.3_dbg/sql/wsrep_mysqld.cc", line=line@entry=1867, function=function@entry=0x55919e244420 "int wsrep_to_isolation_begin(THD*, const char*, const char*, const TABLE_LIST*, Alter_info*)") at assert.c:101
#4  0x000055919d84f734 in wsrep_to_isolation_begin (thd=thd@entry=0xedf340012c0, db_=0xedf340122a8 "test", table_=0xedf34011bf8 "t1", table_list=table_list@entry=0x0, alter_info=alter_info@entry=0x0) at /test/10.3_dbg/sql/wsrep_mysqld.cc:1867
#5  0x000055919d7380c1 in Sql_cmd_create_table_like::execute (this=0xedf34011c28, thd=0xedf340012c0) at /test/10.3_dbg/sql/sql_table.cc:11375
#6  0x000055919d67c106 in mysql_execute_command (thd=thd@entry=0xedf340012c0) at /test/10.3_dbg/sql/sql_parse.cc:6075
#7  0x000055919d67e109 in mysql_parse (thd=thd@entry=0xedf340012c0, rawbuf=rawbuf@entry=0xedf34011b58 "CREATE TABLE t1 (id INT)", length=length@entry=24, parser_state=parser_state@entry=0x44e66e096530, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_parse.cc:7870
#8  0x000055919d67f7c8 in wsrep_mysql_parse (thd=thd@entry=0xedf340012c0, rawbuf=0xedf34011b58 "CREATE TABLE t1 (id INT)", length=24, parser_state=parser_state@entry=0x44e66e096530, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_parse.cc:7662
#9  0x000055919d6808e3 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0xedf340012c0, packet=packet@entry=0xedf340232c1 "CREATE TABLE t1 (id INT);", packet_length=packet_length@entry=25, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_class.h:1152
#10 0x000055919d683a58 in do_command (thd=0xedf340012c0) at /test/10.3_dbg/sql/sql_parse.cc:1398
#11 0x000055919d7abcea in do_handle_one_connection (connect=connect@entry=0x5591a16fb360) at /test/10.3_dbg/sql/sql_connect.cc:1403
#12 0x000055919d7abf21 in handle_one_connection (arg=0x5591a16fb360) at /test/10.3_dbg/sql/sql_connect.cc:1308
#13 0x00001462f4159609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#14 0x000000006ff30293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95



 Comments   
Comment by Ramesh Sivaraman [ 2022-05-09 ]

jplindst Found similar assertions in 10.2 multi thread run. rr traces are saved in /qa-dev/MDEV-25842/10.2

thd->wsrep_trx_meta.gtid.seqno == (-1)|SIGABRT|Diagnostics_area::set_error_status|THD::raise_condition|my_message_sql|my_error > rr trace directory /qa-dev/MDEV-25842/10.2/436
thd->wsrep_trx_meta.gtid.seqno == (-1)|SIGABRT|wsrep_prepare|prepare_or_error|ha_commit_trans|trans_commit_stmt > rr trace directory /qa-dev/MDEV-25842/10.2/323
thd->wsrep_trx_meta.gtid.seqno == (-1)|SIGABRT|wsrep_to_isolation_begin|mysql_create_view|mysql_execute_command|mysql_parse > rr trace directory /qa-dev/MDEV-25842/10.2/118
thd->wsrep_trx_meta.gtid.seqno == (-1)|SIGABRT|wsrep_to_isolation_begin|mysql_execute_command|mysql_parse|wsrep_mysql_parse > rr trace directory /qa-dev/MDEV-25842/10.2/53
thd->wsrep_trx_meta.gtid.seqno == (-1)|SIGABRT|wsrep_to_isolation_begin|Sql_cmd_create_table::execute|mysql_execute_command|mysql_parse > rr trace directory /qa-dev/MDEV-25842/10.2/16

Generated at Thu Feb 08 09:40:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.