Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
Can result in hang or crash
Description
Assertion found while testing MDEV-28730
|
origin/main-MDEV-28730 1ee1317ddd1103587eb9625729b0fb425da1bb50 |
# 2025-11-24T21:45:35 [2762060] | 2025-11-24 21:45:20 20 [ERROR] InnoDB: (Duplicate key) while updating last optimized word!
|
# 2025-11-24T21:45:35 [2762060] | mariadbd: /data/Server/MDEV-28730/storage/innobase/include/trx0trx.h:1119: void trx_t::assert_freed() const: Assertion `!lock.wait_thr' failed.
|
|
Stacktrace |
# 2025-11-24T21:47:07 [2762060] | Thread 3 (Thread 2765529.2771421 (one_connection)):
|
# 2025-11-24T21:47:07 [2762060] | #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
# 2025-11-24T21:47:07 [2762060] | #1 __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
|
# 2025-11-24T21:47:07 [2762060] | #2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
# 2025-11-24T21:47:07 [2762060] | #3 0x00007ab453b1126e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
# 2025-11-24T21:47:07 [2762060] | #4 0x00007ab453af48ff in __GI_abort () at ./stdlib/abort.c:79
|
# 2025-11-24T21:47:07 [2762060] | #5 0x00007ab453af481b in __assert_fail_base (fmt=0x7ab453c9c1e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6255266da8a9 "!lock.wait_thr", file=file@entry=0x6255265ce7d8 "/data/Server/MDEV-28730/storage/innobase/include/trx0trx.h", line=line@entry=1119, function=function@entry=0x6255266348c8 "void trx_t::assert_freed() const") at ./assert/assert.c:94
|
# 2025-11-24T21:47:07 [2762060] | #6 0x00007ab453b07507 in __assert_fail (assertion=0x6255266da8a9 "!lock.wait_thr", file=0x6255265ce7d8 "/data/Server/MDEV-28730/storage/innobase/include/trx0trx.h", line=1119, function=0x6255266348c8 "void trx_t::assert_freed() const") at ./assert/assert.c:103
|
# 2025-11-24T21:47:07 [2762060] | #7 0x000062552625cfd3 in trx_t::assert_freed (this=this@entry=0x19720ce2c580) at /data/Server/MDEV-28730/storage/innobase/include/trx0trx.h:1119
|
# 2025-11-24T21:47:07 [2762060] | #8 0x0000625526259231 in trx_t::commit_cleanup (this=this@entry=0x19720ce2c580) at /data/Server/MDEV-28730/storage/innobase/trx/trx0trx.cc:1538
|
# 2025-11-24T21:47:07 [2762060] | #9 0x000062552625a22f in trx_t::commit (this=this@entry=0x19720ce2c580) at /data/Server/MDEV-28730/storage/innobase/trx/trx0trx.cc:1617
|
# 2025-11-24T21:47:07 [2762060] | #10 0x000062552625a443 in trx_commit_for_mysql (trx=0x19720ce2c580) at /data/Server/MDEV-28730/storage/innobase/trx/trx0trx.cc:1726
|
# 2025-11-24T21:47:07 [2762060] | #11 0x0000625526345198 in fts_optimize_indexes (optim=optim@entry=0x6b071c030488) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1776
|
# 2025-11-24T21:47:07 [2762060] | #12 0x0000625526345325 in fts_optimize_table (table=0x641444030438) at /data/Server/MDEV-28730/storage/innobase/fts/fts0opt.cc:1952
|
# 2025-11-24T21:47:07 [2762060] | #13 0x0000625526099568 in ha_innobase::optimize (this=0x6b071c10d3a0, thd=<optimized out>) at /data/Server/MDEV-28730/storage/innobase/handler/ha_innodb.cc:15168
|
# 2025-11-24T21:47:07 [2762060] | #14 0x0000625525e49cc0 in handler::ha_optimize (this=0x6b071c10d3a0, thd=thd@entry=0x6b071c000d58, check_opt=check_opt@entry=0x6b071c006500) at /data/Server/MDEV-28730/sql/handler.cc:5626
|
# 2025-11-24T21:47:07 [2762060] | #15 0x0000625525cdfea8 in mysql_admin_table (thd=thd@entry=0x6b071c000d58, tables=tables@entry=0x6b071c015ca0, check_opt=check_opt@entry=0x6b071c006500, operator_name=operator_name@entry=0x625526dd4760 <msg_optimize>, lock_type=lock_type@entry=TL_WRITE, org_open_for_modify=org_open_for_modify@entry=true, no_errors_from_open=false, extra_open_options=0, prepare_func=0x0, operator_func=<optimized out>, view_operator_func=0x0, is_cmd_replicated=true) at /data/Server/MDEV-28730/sql/sql_admin.cc:949
|
# 2025-11-24T21:47:07 [2762060] | #16 0x0000625525ce1b2e in Sql_cmd_optimize_table::execute (this=<optimized out>, thd=0x6b071c000d58) at /data/Server/MDEV-28730/sql/sql_admin.cc:1707
|
# 2025-11-24T21:47:07 [2762060] | #17 0x0000625525b97c5f in mysql_execute_command (thd=thd@entry=0x6b071c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/MDEV-28730/sql/sql_parse.cc:5861
|
# 2025-11-24T21:47:07 [2762060] | #18 0x0000625525b9880b in mysql_parse (thd=thd@entry=0x6b071c000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x6255246963d0) at /data/Server/MDEV-28730/sql/sql_parse.cc:7888
|
# 2025-11-24T21:47:07 [2762060] | #19 0x0000625525b99ded in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x6b071c000d58, packet=packet@entry=0x6b071c00b3b9 "", packet_length=packet_length@entry=80, blocking=blocking@entry=true) at /data/Server/MDEV-28730/sql/sql_parse.cc:1878
|
# 2025-11-24T21:47:07 [2762060] | #20 0x0000625525b9b343 in do_command (thd=thd@entry=0x6b071c000d58, blocking=blocking@entry=true) at /data/Server/MDEV-28730/sql/sql_parse.cc:1417
|
# 2025-11-24T21:47:07 [2762060] | #21 0x0000625525ccfc0f in do_handle_one_connection (connect=<optimized out>, connect@entry=0x625529874158, put_in_cache=put_in_cache@entry=true) at /data/Server/MDEV-28730/sql/sql_connect.cc:1503
|
# 2025-11-24T21:47:07 [2762060] | #22 0x0000625525ccfe2c in handle_one_connection (arg=0x625529874158) at /data/Server/MDEV-28730/sql/sql_connect.cc:1415
|
# 2025-11-24T21:47:07 [2762060] | #23 0x00007ab453b68a94 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
|
# 2025-11-24T21:47:07 [2762060] | #24 0x00007ab453bf5a34 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
|
RR trace is present on SDP:-
/data/results/1764049434/TBR-1443
Attachments
Issue Links
- is caused by
-
MDEV-28730 Remove internal parser usage from InnoDB fts
-
- Stalled
-