Assertion `thd->ha_da ta[ht_arg->slot].ha_ptr_backup == __null || (thd->get_transaction()->xid_state()-> has_state(XID_STATE::XA_ACTIVE))' failed.
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:
Incomplete
Details
Assignee
UnassignedUnassignedReporter
Ramesh SivaramanRamesh Sivaraman(Deactivated)Labels
Affects versions
Priority
Medium
Details
Details
Assignee
Unassigned
UnassignedReporter
Ramesh Sivaraman
Ramesh Sivaraman(Deactivated)Labels
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created April 6, 2017 at 9:36 AM
Updated March 6, 2024 at 11:21 PM
Resolved November 2, 2022 at 10:56 AM
GDB info
#0 0x00007f31f5ac4771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x000000000188d018 in my_write_core (sig=6) at /sda/pquery/perf/percona-xtradb-cluster/mysys/stacktrace.c:249 #2 0x0000000000e8e058 in handle_fatal_signal (sig=6) at /sda/pquery/perf/percona-xtradb-cluster/sql/signal_handler.cc:235 #3 <signal handler called> #4 0x00007f31f3c4c5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007f31f3c4dcc8 in __GI_abort () at abort.c:90 #6 0x00007f31f3c45546 in __assert_fail_base (fmt=0x7f31f3d95128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x1e13f40 "thd->ha_data[ht_arg->slot].ha_ptr_backup == __null || (thd->get_transaction()->xid_state()-> has_state(XID_STATE::XA_ACTIVE))", file=file@entry=0x1e139f0 "/sda/pquery/perf/percona-xtradb-cluster/sql/handler.cc", line=line@entry=1419, function=function@entry=0x1e16820 <trans_register_ha(THD*, bool, handlerton*, unsigned long long const*)::__PRETTY_FUNCTION__> "void trans_register_ha(THD*, bool, handlerton*, const ulonglong*)") at assert.c:92 #7 0x00007f31f3c455f2 in __GI___assert_fail (assertion=0x1e13f40 "thd->ha_data[ht_arg->slot].ha_ptr_backup == __null || (thd->get_transaction()->xid_state()-> has_state(XID_STATE::XA_ACTIVE))", file=0x1e139f0 "/sda/pquery/perf/percona-xtradb-cluster/sql/handler.cc", line=1419, function=0x1e16820 <trans_register_ha(THD*, bool, handlerton*, unsigned long long const*)::__PRETTY_FUNCTION__> "void trans_register_ha(THD*, bool, handlerton*, const ulonglong*)") at assert.c:101 #8 0x0000000000f35343 in trans_register_ha (thd=0x7f31bc819000, all=true, ht_arg=0x7f31eb3eb4e0, trxid=0x7f31f5ff64c8) at /sda/pquery/perf/percona-xtradb-cluster/sql/handler.cc:1417 #9 0x000000000194fb11 in innobase_register_trx (hton=0x7f31eb3eb4e0, thd=0x7f31bc819000, trx=0x7f31db4010a0) at /sda/pquery/perf/percona-xtradb-cluster/storage/innobase/handler/ha_innodb.cc:3283 #10 0x000000000196cf58 in ha_innobase::external_lock (this=0x7f31ba827830, thd=0x7f31bc819000, lock_type=0) at /sda/pquery/perf/percona-xtradb-cluster/storage/innobase/handler/ha_innodb.cc:17780 #11 0x0000000000f458b2 in handler::ha_external_lock (this=0x7f31ba827830, thd=0x7f31bc819000, lock_type=0) at /sda/pquery/perf/percona-xtradb-cluster/sql/handler.cc:8489 #12 0x000000000143d0aa in lock_external (thd=0x7f31bc819000, tables=0x7f31bc852ba8, count=6) at /sda/pquery/perf/percona-xtradb-cluster/sql/lock.cc:396 #13 0x000000000143cd95 in mysql_lock_tables (thd=0x7f31bc819000, tables=0x7f31bb371e40, count=6, flags=0) at /sda/pquery/perf/percona-xtradb-cluster/sql/lock.cc:329 #14 0x00000000014c3f49 in lock_tables (thd=0x7f31bc819000, tables=0x7f31b9f920e0, count=6, flags=0) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_base.cc:6859 #15 0x00000000015a1935 in handle_query (thd=0x7f31bc819000, lex=0x7f31bc81b650, result=0x7f31b9f92d28, added_options=0, removed_options=0) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_select.cc:152 #16 0x0000000001554a62 in execute_sqlcom_select (thd=0x7f31bc819000, all_tables=0x7f31b9f920e0) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_parse.cc:6431 #17 0x000000000154a965 in mysql_execute_command (thd=0x7f31bc819000, first_level=true) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_parse.cc:3412 #18 0x0000000001555b0e in mysql_parse (thd=0x7f31bc819000, parser_state=0x7f31f5ff7f70) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_parse.cc:6894 #19 0x0000000001558009 in wsrep_mysql_parse (thd=0x7f31bc819000, rawbuf=0x7f31b9f91030 "select * from t1 as a, t2 as b, t1 as c, t2 as d, t1 as e, t2 as f", length=66, parser_state=0x7f31f5ff7f70) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_parse.cc:7875 #20 0x0000000001546c60 in dispatch_command (thd=0x7f31bc819000, com_data=0x7f31f5ff8850, command=COM_QUERY) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_parse.cc:1837 #21 0x0000000001544f68 in do_command (thd=0x7f31bc819000) at /sda/pquery/perf/percona-xtradb-cluster/sql/sql_parse.cc:1174 #22 0x000000000168c115 in handle_connection (arg=0x7f31c8fd6ee0) at /sda/pquery/perf/percona-xtradb-cluster/sql/conn_handler/connection_handler_per_thread.cc:312 #23 0x0000000001d26a35 in pfs_spawn_thread (arg=0x7f31ec3c3520) at /sda/pquery/perf/percona-xtradb-cluster/storage/perfschema/pfs.cc:2188 #24 0x00007f31f5abfdf5 in start_thread (arg=0x7f31f5ff9700) at pthread_create.c:308 #25 0x00007f31f3d0d1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113