[MDEV-32062] Assertion `name == rdb_xid_to_string(xid)' failed in virtual void myrocks::Rdb_transaction_impl::set_name() Created: 2023-09-01  Updated: 2024-01-23  Resolved: 2024-01-23

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 11.3
Fix Version/s: 11.3.2

Type: Bug Priority: Critical
Reporter: Ramesh Sivaraman Assignee: Sergei Petrunia
Resolution: Cannot Reproduce Votes: 0
Labels: regression


 Description   

INSTALL PLUGIN RocksDB SONAME 'ha_rocksdb';
SET default_storage_engine=RocksDB;
CREATE TABLE t (c INT);
LOCK TABLE t READ;
SELECT * FROM t ORDER BY c2;
SELECT * FROM t ORDER BY c2;

Leads to:

11.3.0 8951f7d940166063db3fe64c35c40a5e5fabcf7d (Debug)

mariadbd: /test/11.3_dbg/storage/rocksdb/ha_rocksdb.cc:3804: virtual void myrocks::Rdb_transaction_impl::set_name(): Assertion `name == rdb_xid_to_string(xid)' failed.

11.3.0 8951f7d940166063db3fe64c35c40a5e5fabcf7d (Debug)

Core was generated by `/test/MD240823-mariadb-11.3.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --cor'.
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 0x15112d713700 (LWP 1063875))]
(gdb) bt
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1  0x0000151145e90859 in __GI_abort () at abort.c:79
#2  0x0000151145e90729 in __assert_fail_base (fmt=0x151146026588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x15112d4f72f0 "name == rdb_xid_to_string(xid)", file=0x15112d4ed428 "/test/11.3_dbg/storage/rocksdb/ha_rocksdb.cc", line=3804, function=<optimized out>) at assert.c:92
#3  0x0000151145ea1fd6 in __GI___assert_fail (assertion=assertion@entry=0x15112d4f72f0 "name == rdb_xid_to_string(xid)", file=file@entry=0x15112d4ed428 "/test/11.3_dbg/storage/rocksdb/ha_rocksdb.cc", line=line@entry=3804, function=function@entry=0x15112d4f7310 "virtual void myrocks::Rdb_transaction_impl::set_name()") at assert.c:101
#4  0x000015112cf7a9ea in myrocks::Rdb_transaction_impl::set_name (this=<optimized out>) at /usr/include/c++/9/bits/basic_string.h:934
#5  0x000015112cf50aba in myrocks::rocksdb_register_tx (tx=0x1510f4314ac0, thd=0x1510f4000d48, hton=<optimized out>) at /test/11.3_dbg/storage/rocksdb/ha_rocksdb.cc:5168
#6  myrocks::ha_rocksdb::start_stmt (this=0x1510f405fbd0, thd=0x1510f4000d48, lock_type=<optimized out>) at /test/11.3_dbg/storage/rocksdb/ha_rocksdb.cc:12239
#7  0x0000564ceefcd31e in check_lock_and_start_stmt (thd=thd@entry=0x1510f4000d48, prelocking_ctx=<optimized out>, table_list=table_list@entry=0x1510f4013948) at /test/11.3_dbg/sql/sql_base.cc:5384
#8  0x0000564ceefcfac9 in lock_tables (thd=thd@entry=0x1510f4000d48, tables=0x1510f4013948, count=<optimized out>, flags=flags@entry=0) at /test/11.3_dbg/sql/sql_base.cc:5959
#9  0x0000564ceefd1656 in open_and_lock_tables (thd=thd@entry=0x1510f4000d48, options=<optimized out>, tables=<optimized out>, tables@entry=0x1510f4013948, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x15112d711810) at /test/11.3_dbg/sql/sql_base.cc:5616
#10 0x0000564cef0463df in open_and_lock_tables (flags=0, derived=true, tables=0x1510f4013948, thd=0x1510f4000d48) at /test/11.3_dbg/sql/sql_base.h:525
#11 execute_sqlcom_select (thd=thd@entry=0x1510f4000d48, all_tables=0x1510f4013948) at /test/11.3_dbg/sql/sql_parse.cc:5943
#12 0x0000564cef052b3d in mysql_execute_command (thd=thd@entry=0x1510f4000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.3_dbg/sql/sql_parse.cc:3922
#13 0x0000564cef040cf7 in mysql_parse (thd=thd@entry=0x1510f4000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x15112d7122c0) at /test/11.3_dbg/sql/sql_parse.cc:7760
#14 0x0000564cef04e302 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1510f4000d48, packet=packet@entry=0x1510f400af59 "SELECT * FROM t ORDER BY c2", packet_length=packet_length@entry=27, blocking=blocking@entry=true) at /test/11.3_dbg/sql/sql_class.h:1489
#15 0x0000564cef0507ba in do_command (thd=0x1510f4000d48, blocking=blocking@entry=true) at /test/11.3_dbg/sql/sql_parse.cc:1406
#16 0x0000564cef1b8623 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564cf2870bd8, put_in_cache=put_in_cache@entry=true) at /test/11.3_dbg/sql/sql_connect.cc:1445
#17 0x0000564cef1b8af2 in handle_one_connection (arg=0x564cf2870bd8) at /test/11.3_dbg/sql/sql_connect.cc:1347
#18 0x00001511463a1609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#19 0x0000151145f8d133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Bug confirmed present in:
MariaDB: 11.3.0 (dbg)

Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.31 (dbg), 10.4.31 (opt), 10.4.32 (dbg), 10.4.32 (opt), 10.5.22 (dbg), 10.5.22 (opt), 10.6.15 (opt), 10.6.15 (dbg), 10.9.8 (dbg), 10.9.8 (opt), 10.10.6 (dbg), 10.10.6 (opt), 10.11.5 (dbg), 10.11.5 (opt), 11.0.3 (dbg), 11.0.3 (opt), 11.1.2 (dbg), 11.1.2 (opt), 11.2.0 (dbg), 11.2.0 (opt), 11.2.2 (dbg), 11.2.2 (opt), 11.3.0 (opt)



 Comments   
Comment by Ramesh Sivaraman [ 2024-01-23 ]

Could not reproduce the issue on latest 11.3 build 83a79ba33b0d39f005deeb3b2392cf85b7cf0fc5

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