[MDEV-37313] Spider: Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status upon CREATE TEMPORARY TABLE ... LIKE - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.6, 10.11, 11.4, 11.8, 12.0(EOL), 12.1
Fix Version/s: 10.6, 10.11, 11.4, 11.8, 12.0(EOL)
Component/s: Data Definition - Temporary, Storage Engine - Spider
Labels:
None

Bug Category:
Can result in hang or crash

Description

Somewhat similar to MDEV-30268 (but no CHECK is used here), and MDEV-35917 (but no IN is used here), and this testcase needs Spider.

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE TEMPORARY TABLE t1 (c INT);

CREATE TABLE t2 (c INT) ENGINE=Spider;

CREATE TEMPORARY TABLE IF NOT EXISTS t1 LIKE t2;

Leads to:

CS 12.0.1 107291bf980822fcc3c02bd4e01ecbc4db7fd192 (Debug, Clang) Build 30/06/2025
mariadbd: /test/12.0_dbg/sql/sql_error.cc:357: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char *): Assertion `!is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())' failed.

CS 12.0.1 107291bf980822fcc3c02bd4e01ecbc4db7fd192 (Debug, Clang) Build 30/06/2025
Core was generated by `/test/MD300625-mariadb-12.0.1-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
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 1930274)]
(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 0x0000768e4c24526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
#4 0x0000768e4c2288ff in __GI_abort () at ./stdlib/abort.c:79
#5 0x0000768e4c22881b in __assert_fail_base (fmt=0x768e4c3d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x62bb08f22cd7 "!is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x62bb08f156c4 "/test/12.0_dbg/sql/sql_error.cc", line=line@entry=357, function=function@entry=0x62bb08f22d0d "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char *)") at ./assert/assert.c:94
#6 0x0000768e4c23b507 in __assert_fail (assertion=0x62bb08f22cd7 "!is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())", file=0x62bb08f156c4 "/test/12.0_dbg/sql/sql_error.cc", line=357, function=0x62bb08f22d0d "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char *)") at ./assert/assert.c:103
#7 0x000062bb09a9f3ab in Diagnostics_area::set_ok_status (this=0x768cf8006e60, affected_rows=0, last_insert_id=0, message=0x0)at /test/12.0_dbg/sql/sql_error.cc:357
#8 0x000062bb0981176f in my_ok (thd=0x768cf8000d58, affected_rows_arg=0, id=0, message=0x0) at /test/12.0_dbg/sql/sql_class.h:6303
#9 0x000062bb09c64fec in Sql_cmd_create_table_like::execute (this=0x768cf8019fa8, thd=0x768cf8000d58)at /test/12.0_dbg/sql/sql_table.cc:13701
#10 0x000062bb09b17b0d in mysql_execute_command (thd=0x768cf8000d58, is_called_from_prepared_stmt=false) at /test/12.0_dbg/sql/sql_parse.cc:5861
#11 0x000062bb09b06e44 in mysql_parse (thd=0x768cf8000d58, rawbuf=0x768cf8019ef0 "CREATE TEMPORARY TABLE IF NOT EXISTS t1 LIKE t2", length=47, parser_state=0x768e4865ea10)at /test/12.0_dbg/sql/sql_parse.cc:7882
#12 0x000062bb09b04218 in dispatch_command (command=COM_QUERY, thd=0x768cf8000d58, packet=0x768cf800b269 "CREATE TEMPORARY TABLE IF NOT EXISTS t1 LIKE t2", packet_length=47, blocking=true) at /test/12.0_dbg/sql/sql_parse.cc:1877
#13 0x000062bb09b079f3 in do_command (thd=0x768cf8000d58, blocking=true)at /test/12.0_dbg/sql/sql_parse.cc:1416
#14 0x000062bb09d24d89 in do_handle_one_connection (connect=0x62bb0c859b08, put_in_cache=true) at /test/12.0_dbg/sql/sql_connect.cc:1414
#15 0x000062bb09d24b2e in handle_one_connection (arg=0x62bb0c871aa8)at /test/12.0_dbg/sql/sql_connect.cc:1326
#16 0x0000768e4c29ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
#17 0x0000768e4c329c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

Bug Detection Matrix
Rel o/d Build Commit UniqueID observed
CS 10.6 dbg 060625 643319a7fb1e273797c2a1e46d76cfac0fa1da8f !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
CS 10.6 opt 060625 643319a7fb1e273797c2a1e46d76cfac0fa1da8f No bug found
CS 10.11 dbg 060625 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
CS 10.11 opt 060625 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 No bug found
CS 11.4 dbg 060625 8c6cbb336081a5e1ad781df4a9778b61e3b4d73f !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
CS 11.4 opt 060625 8c6cbb336081a5e1ad781df4a9778b61e3b4d73f No bug found
CS 11.8 dbg 060625 67e6fdee05ead4974fe632e91c38941ade369b0c !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
CS 11.8 opt 060625 67e6fdee05ead4974fe632e91c38941ade369b0c No bug found
CS 12.0 dbg 300625 107291bf980822fcc3c02bd4e01ecbc4db7fd192 !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
CS 12.0 opt 300625 107291bf980822fcc3c02bd4e01ecbc4db7fd192 No bug found
CS 12.1 dbg 170725 ce7ab467dbdfb5fc83a22bd53d923f7d0d1c6a3e !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
CS 12.1 opt 170725 ce7ab467dbdfb5fc83a22bd53d923f7d0d1c6a3e No bug found
ES 10.5 dbg 060625 ec7bc4f84e490b25f52db7422a1e0e8bbea72fb1 !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
ES 10.5 opt 060625 ec7bc4f84e490b25f52db7422a1e0e8bbea72fb1 No bug found
ES 10.6 dbg 060625 8541ea1e4c2fa15789dd162f6ba4b32681f74e61 !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
ES 10.6 opt 060625 8541ea1e4c2fa15789dd162f6ba4b32681f74e61 No bug found
ES 11.4 dbg 060625 1c8b2d3059f5ccb67c042868baca3ee269c6eca7 !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
ES 11.4 opt 060625 1c8b2d3059f5ccb67c042868baca3ee269c6eca7 No bug found
ES 11.8 dbg 110625 b9f97a5bc42a4f23889996d2891bcbb0cafcf0bc !is_set() \|\| (m_status == DA_OK_BULK && is_bulk_op())\|SIGABRT\|Diagnostics_area::set_ok_status\|my_ok\|Sql_cmd_create_table_like::execute\|mysql_execute_command
ES 11.8 opt 110625 b9f97a5bc42a4f23889996d2891bcbb0cafcf0bc No bug found

The testcase is CLI and MTR compatible.

Attachments

Issue Links

relates to

MDEV-30268 Server crashes when using temporary table with BIGINT field on providing incorrect value to CHECK function

Confirmed

MDEV-35917 Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status after CREATE TEMPORARY TABLE

Confirmed

Spider: Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status upon CREATE TEMPORARY TABLE ... LIKE

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration