Details
-
Bug
-
Status: In Testing (View Workflow)
-
Critical
-
Resolution: Unresolved
-
N/A
-
None
Description
SET sql_mode='', enforce_storage_engine=Aria; |
CREATE GLOBAL TEMPORARY TABLE t1 (c INT); |
CREATE GLOBAL TEMPORARY TABLE t2 (c INT); |
LOCK TABLES t2 WRITE,t1 WRITE;
|
CREATE OR REPLACE GLOBAL TEMPORARY TABLE t2 SELECT 0 t1; |
ANALYZE TABLE t2; |
Leads to:
|
MDEV-35915-v10 CS 12.2.0 2ef81706c8c4782b2f8a45a05ac90377403de2e1 (Debug, Clang 21.1.3-20250923) Build 31/12/2025 |
mariadbd: /test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc:3053: virtual int ha_maria::start_stmt(THD *, thr_lock_type): Assertion `file->trn == trn' failed.
|
|
MDEV-35915-v10 CS 12.2.0 2ef81706c8c4782b2f8a45a05ac90377403de2e1 (Debug, Clang 21.1.3-20250923) Build 31/12/2025 |
Core was generated by `/test/MDEV-35915_v10_MD311225-mariadb-12.2.0-linux-x86_64-dbg/bin/mariadbd --no'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 2756843)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x00007c99d2a4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007c99d2a288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007c99d2a2881b in __assert_fail_base (fmt=0x7c99d2bd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x62d20702df11 "file->trn == trn", file=file@entry=0x62d206fcaae3 "/test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc", line=line@entry=3053, function=function@entry=0x62d2070913fe "virtual int ha_maria::start_stmt(THD *, thr_lock_type)") at ./assert/assert.c:94
|
#6 0x00007c99d2a3b507 in __assert_fail (assertion=0x62d20702df11 "file->trn == trn", file=0x62d206fcaae3 "/test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc", line=3053, function=0x62d2070913fe "virtual int ha_maria::start_stmt(THD *, thr_lock_type)") at ./assert/assert.c:103
|
#7 0x000062d2080518a0 in ha_maria::start_stmt (this=0x7c98a4036b28, thd=0x7c98a4000d58, lock_type=TL_READ_NO_INSERT)at /test/bb-12.2-nikita-global-tmp_dbg/storage/maria/ha_maria.cc:3053
|
#8 0x000062d207af0026 in check_lock_and_start_stmt (thd=0x7c98a4000d58, prelocking_ctx=0x7c98a4005080, table_list=0x7c98a4019f40)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.cc:5532
|
#9 0x000062d207aefaee in lock_tables (thd=0x7c98a4000d58, tables=0x7c98a4019f40, count=1, flags=0)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.cc:6122
|
#10 0x000062d207af019f in open_and_lock_tables (thd=0x7c98a4000d58, options=@0x7c98a4006734: {m_options = DDL_options_st::OPT_NONE}, tables=0x7c98a4019f40, derived=true, flags=0, prelocking_strategy=0x7c99cbf64800)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.cc:5765
|
#11 0x000062d20797280e in open_and_lock_tables (thd=0x7c98a4000d58, tables=0x7c98a4019f40, derived=true, flags=0)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_base.h:544
|
#12 0x000062d207e52a21 in open_only_one_table (thd=0x7c98a4000d58, table=0x7c98a4019f40, repair_table_use_frm=false, is_view_operator_func=false)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_admin.cc:436
|
#13 0x000062d207e4df64 in mysql_admin_table (thd=0x7c98a4000d58, tables=0x7c98a4019f40, check_opt=0x7c98a40064d0, operator_name=0x62d2089ec7e8 <msg_analyze>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=true, no_errors_from_open=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x62d207809d30 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0, is_cmd_replicated=true)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_admin.cc:653
|
#14 0x000062d207e51716 in Sql_cmd_analyze_table::execute (this=0x7c98a401a678, thd=0x7c98a4000d58)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_admin.cc:1659
|
#15 0x000062d207c5192b in mysql_execute_command (thd=0x7c98a4000d58, is_called_from_prepared_stmt=false)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:5879
|
#16 0x000062d207c42b98 in mysql_parse (thd=0x7c98a4000d58, rawbuf=0x7c98a4019e80 "ANALYZE TABLE t2", length=16, parser_state=0x7c99cbf67a10)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:7912
|
#17 0x000062d207c40379 in dispatch_command (command=COM_QUERY, thd=0x7c98a4000d58, packet=0x7c98a400b1f9 "", packet_length=16, blocking=true) at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:1898
|
#18 0x000062d207c4361a in do_command (thd=0x7c98a4000d58, blocking=true)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_parse.cc:1437
|
#19 0x000062d207e3601e in do_handle_one_connection (connect=0x62d20a959118, put_in_cache=true)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_connect.cc:1414
|
#20 0x000062d207e35e01 in handle_one_connection (arg=0x62d20a9e14d8)at /test/bb-12.2-nikita-global-tmp_dbg/sql/sql_connect.cc:1326
|
#21 0x00007c99d2a9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#22 0x00007c99d2b29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Testcase is MTR and CLI compatible.
Attachments
Issue Links
- is caused by
-
MDEV-35915 Implement Global temporary tables
-
- Stalled
-