[MDEV-30513] Assertion `state_ == s_exec' failed in int wsrep::client_state::start_transaction(const wsrep::transaction_id&) Created: 2023-01-30  Updated: 2023-04-11

Status: Open
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.6
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Jan Lindström
Resolution: Unresolved Votes: 0
Labels: None

Attachments: Text File bt_all.txt     Text File bt_all_trial_52.txt    

 Description   

The crash is from galera multi-thread pquery run.

10.6.12 282f75262e98461608d079c46a4e96382aa2c6a3

mysqld: /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp:319: int wsrep::client_state::start_transaction(const wsrep::transaction_id&): Assertion `state_ == s_exec' failed.

10.6.12 282f75262e98461608d079c46a4e96382aa2c6a3

Core was generated by `/test/mtest/MDEV-24623/10.6_v2/mariadb-10.6.12-linux-x86_64/bin/mysqld --defaul'.
Program terminated with signal SIGABRT, Aborted.
#0  __pthread_kill (threadid=<optimized out>, signo=6)
    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
[Current thread is 1 (Thread 0x151b2d152700 (LWP 52338))]
(gdb) bt
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1  0x000055b1a2c5cc71 in my_write_core (sig=6) at /test/mtest/MDEV-24623/10.6_v2/mysys/stacktrace.c:424
#2  0x000055b1a237b9cc in handle_fatal_signal (sig=6) at /test/mtest/MDEV-24623/10.6_v2/sql/signal_handler.cc:357
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5  0x0000151b81291859 in __GI_abort () at abort.c:79
#6  0x0000151b81291729 in __assert_fail_base (fmt=0x151b81427588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55b1a2d73a10 "state_ == s_exec", file=0x55b1a2d739c8 "/test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp", line=319, function=<optimized out>) at assert.c:92
#7  0x0000151b812a2fd6 in __GI___assert_fail (assertion=0x55b1a2d73a10 "state_ == s_exec", file=0x55b1a2d739c8 "/test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp", line=319, function=0x55b1a2d73978 "int wsrep::client_state::start_transaction(const wsrep::transaction_id&)") at assert.c:101
#8  0x000055b1a1f9644d in wsrep::client_state::start_transaction (this=0x151a90057ef8, id=@0x151b2d150158: {id_ = 5259}) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp:319
#9  0x000055b1a27866e9 in Wsrep_storage_service::start_transaction (this=0x151a900b8460, ws_handle=@0x151a90007990: {transaction_id_ = {id_ = 5259}, opaque_ = 0x151a8401bf20}) at /test/mtest/MDEV-24623/10.6_v2/sql/wsrep_storage_service.cc:86
#10 0x000055b1a2d1e67d in wsrep::transaction::certify_fragment (this=0x151a90007930, lock=@0x151b2d150640: {_M_device = 0x151a90007890, _M_owns = false}) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/src/transaction.cpp:1554
#11 0x000055b1a2d1df63 in wsrep::transaction::streaming_step (this=0x151a90007930, lock=@0x151b2d150640: {_M_device = 0x151a90007890, _M_owns = false}, force=false) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/src/transaction.cpp:1437
#12 0x000055b1a2d198fd in wsrep::transaction::after_row (this=0x151a90007930) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/src/transaction.cpp:268
#13 0x000055b1a239a67d in wsrep::client_state::after_row (this=0x151a900078c8) at /test/mtest/MDEV-24623/10.6_v2/wsrep-lib/include/wsrep/client_state.hpp:399
#14 0x000055b1a237cfb7 in wsrep_after_row_internal (thd=0x151a90001138) at /test/mtest/MDEV-24623/10.6_v2/sql/wsrep_trans_observer.h:175
#15 0x000055b1a2393774 in wsrep_after_row (thd=0x151a90001138) at /test/mtest/MDEV-24623/10.6_v2/sql/handler.cc:7182
#16 0x000055b1a239546a in handler::ha_write_row (this=0x151a90186100, buf=0x151a9004cca0 "u'") at /test/mtest/MDEV-24623/10.6_v2/sql/handler.cc:7597
#17 0x000055b1a1f8b7e9 in write_record (thd=0x151a90001138, table=0x151a900494d8, info=0x151b2d1509e0, sink=0x0) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_insert.cc:2156
#18 0x000055b1a1f883fa in mysql_insert (thd=0x151a90001138, table_list=0x151a90014348, fields=@0x151a90006380: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x151a90014b78, last = 0x151a90015050, elements = 5}, <No data fields>}, values_list=@0x151a900063c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x151a90015d10, last = 0x151a90015d10, elements = 1}, <No data fields>}, update_fields=@0x151a900063b0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b1a394ff20 <end_of_list>, last = 0x151a900063b0, elements = 0}, <No data fields>}, update_values=@0x151a90006398: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b1a394ff20 <end_of_list>, last = 0x151a90006398, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=true, result=0x0) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_insert.cc:1128
#19 0x000055b1a1fde126 in mysql_execute_command (thd=0x151a90001138, is_called_from_prepared_stmt=false) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:4568
#20 0x000055b1a1fe9bb8 in mysql_parse (thd=0x151a90001138, rawbuf=0x151a900140d0 "insert ignore into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10101,'impossible_function_1',@category1_id,'description of \\n impossible_function1\\n','example of \\n"..., length=223, parser_state=0x151b2d151320) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:8019
#21 0x000055b1a1fe92b5 in wsrep_mysql_parse (thd=0x151a90001138, rawbuf=0x151a900140d0 "insert ignore into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10101,'impossible_function_1',@category1_id,'description of \\n impossible_function1\\n','example of \\n"..., length=223, parser_state=0x151b2d151320) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:7831
#22 0x000055b1a1fd5f44 in dispatch_command (command=COM_QUERY, thd=0x151a90001138, packet=0x151a9000b7e9 "insert ignore into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10101,'impossible_function_1',@category1_id,'description of \\n impossible_function1\\n','example of \\n"..., packet_length=224, blocking=true) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:1883
#23 0x000055b1a1fd49f2 in do_command (thd=0x151a90001138, blocking=true) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_parse.cc:1409
#24 0x000055b1a2196ca1 in do_handle_one_connection (connect=0x55b1a5c9cc38, put_in_cache=true) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_connect.cc:1416
#25 0x000055b1a21969fd in handle_one_connection (arg=0x55b1a5c9cc38) at /test/mtest/MDEV-24623/10.6_v2/sql/sql_connect.cc:1318
#26 0x000055b1a26cd679 in pfs_spawn_thread (arg=0x55b1a5659d58) at /test/mtest/MDEV-24623/10.6_v2/storage/perfschema/pfs.cc:2201
#27 0x0000151b817bd609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#28 0x0000151b8138e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95


Generated at Thu Feb 08 10:16:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.