Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.2
Description
The test case is non-deterministic, run with --repeat=N. It usually fails for me withing several runs in shm, but it may vary on different machines in builds. It takes much longer with rr, but it is rr-able.
CREATE TABLE t (fld VARCHAR(8)) ENGINE=Aria; |
SELECT * FROM t; |
|
|
--connect (con1,localhost,root,,)
|
--send
|
INSERT INTO t SELECT 'x'; |
|
|
--connection default
|
--error ER_NO_SUCH_TABLE
|
SELECT * FROM non_existing; |
|
|
UPDATE t SET fld = 'xx'; |
|
|
DROP TABLE t; |
|
10.6 7093e1c4a9f96b3f9e43127407cbb7de337912da |
mariadbd: /data/bld/10.6/storage/maria/ma_trnman.h:35: void _ma_set_trn_for_table(MARIA_HA*, TRN*): Assertion `tbl->trn == 0' failed.
|
251221 23:05:01 [ERROR] /share8t/bld/10.6/sql/mariadbd got signal 6 ;
|
|
|
#10 0x00007f3764c53eb2 in __GI___assert_fail (assertion=0x55edeec72fc0 "tbl->trn == 0", file=0x55edeec72ea0 "/data/bld/10.6/storage/maria/ma_trnman.h", line=35, function=0x55edeec72f00 "void _ma_set_trn_for_table(MARIA_HA*, TRN*)") at ./assert/assert.c:101
|
#11 0x000055edece0e75d in _ma_set_trn_for_table (tbl=tbl@entry=0x6290004ba218, newtrn=newtrn@entry=0x612000002ed8) at /data/bld/10.6/storage/maria/ma_trnman.h:35
|
#12 0x000055edece15ed0 in maria_create_trn_for_mysql (info=0x6290004ba218) at /data/bld/10.6/storage/maria/ha_maria.cc:958
|
#13 0x000055edecddd3fb in _ma_setup_live_state (info=info@entry=0x6290004ba218) at /data/bld/10.6/storage/maria/ma_state.c:66
|
#14 0x000055edecde15c8 in _ma_block_start_trans (param=0x6290004ba218) at /data/bld/10.6/storage/maria/ma_state.c:667
|
#15 0x000055edee3c5fd5 in thr_multi_lock (data=0x62d00005b038, count=<optimized out>, owner=0x62b00007fff0, lock_wait_timeout=86400) at /data/bld/10.6/mysys/thr_lock.c:1194
|
#16 0x000055edec9bda3e in mysql_lock_tables (thd=thd@entry=0x62b00007e218, sql_lock=sql_lock@entry=0x62d00005b010, flags=flags@entry=0) at /data/bld/10.6/sql/lock.cc:352
|
#17 0x000055edec9c1393 in mysql_lock_tables (thd=thd@entry=0x62b00007e218, tables=tables@entry=0x62d00005b000, count=count@entry=1, flags=flags@entry=0) at /data/bld/10.6/sql/lock.cc:304
|
#18 0x000055edeac2cfcb in lock_tables (thd=thd@entry=0x62b00007e218, tables=tables@entry=0x62d00005a548, count=<optimized out>, flags=flags@entry=0) at /data/bld/10.6/sql/sql_base.cc:5671
|
#19 0x000055edeb532a9b in mysql_update (thd=thd@entry=0x62b00007e218, table_list=<optimized out>, fields=..., values=..., conds=conds@entry=0x0, order_num=order_num@entry=0, order=<optimized out>, limit=<optimized out>, ignore=<optimized out>, found_return=<optimized out>, updated_return=<optimized out>) at /data/bld/10.6/sql/sql_update.cc:447
|
#20 0x000055edeaf8c746 in mysql_execute_command (thd=thd@entry=0x62b00007e218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/10.6/sql/sql_parse.cc:4477
|
#21 0x000055edeafa96f8 in mysql_parse (thd=thd@entry=0x62b00007e218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f375ab84ac0) at /data/bld/10.6/sql/sql_parse.cc:8200
|
#22 0x000055edeafb29c8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b00007e218, packet=packet@entry=0x6290003b1219 "UPDATE t SET fld = 'xx'", packet_length=packet_length@entry=23, blocking=blocking@entry=true) at /data/bld/10.6/sql/sql_parse.cc:1908
|
#23 0x000055edeafbf61a in do_command (thd=thd@entry=0x62b00007e218, blocking=blocking@entry=true) at /data/bld/10.6/sql/sql_parse.cc:1421
|
#24 0x000055edeb740f48 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000002f38, put_in_cache=put_in_cache@entry=true) at /data/bld/10.6/sql/sql_connect.cc:1386
|
#25 0x000055edeb7420a5 in handle_one_connection (arg=0x608000002f38) at /data/bld/10.6/sql/sql_connect.cc:1298
|
#26 0x000055eded1730ff in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/10.6/storage/perfschema/pfs.cc:2201
|
#27 0x00007f3764ca81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#28 0x00007f3764d2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
The failure started happening after this commit in 10.6:
commit eedee458857aaf2889461fdac398883a11c2f380 11dc83e06fe59e18c93d50d3d5de4c48347e6ca7
|
Author: Monty
|
AuthorDate: Mon Dec 1 11:19:17 2025 +0200
|
|
|
MDEV-23132 Assertion `trn->locked_tables == 0 && trn->used_instances == 0' failed in trnman_end_trn
|
However since the commit added the assertion, so I'm not sure whether it's a new problem or just became visible now.
I didn't get any obvious problem on a non-debug build, but with a such a sporadic failure it's hard to be sure.
Attachments
Issue Links
- is caused by
-
-
- Closed
-