Type:
Bug
Priority:
Critical
Resolution:
Unresolved
Affects Version/s:
10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL) , 11.1(EOL)
CREATE TABLE t (c ENUM ( '' '' )) ENGINE=InnoDB;
LOCK TABLE t WRITE;
SET sql_mode=strict_all_tables;
CREATE OR REPLACE TABLE t (a INT ) ENGINE=Aria COMMENT= '' SELECT '' AS a;
Leads to:
11.1.0 2b61ff8f2221745f0a96855a0feb0825c426f993 (Debug)
mariadbd: /test/11.1_dbg/sql/mdl.cc:3261: void MDL_context::set_transaction_duration_for_all_locks(): Assertion `m_tickets[MDL_STATEMENT].is_empty()' failed.
11.1.0 2b61ff8f2221745f0a96855a0feb0825c426f993 (Debug)
Core was generated by `/test/MD070423-mariadb-11.1.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --cor'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22428113688128)
at ./nptl/pthread_kill.c:44
[Current thread is 1 (Thread 0x1465f3bfd640 (LWP 3787284))]
(gdb) bt
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=22428113688128) at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=22428113688128) at ./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=22428113688128, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
#3 0x000014662cb67476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#4 0x000014662cb4d7f3 in __GI_abort () at ./stdlib/abort.c:79
#5 0x000014662cb4d71b in __assert_fail_base (fmt=0x14662cd02150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55bd05740338 "m_tickets[MDL_STATEMENT].is_empty()", file=0x55bd0573fd19 "/test/11.1_dbg/sql/mdl.cc", line=3261, function=<optimized out>) at ./assert/assert.c:92
#6 0x000014662cb5ee96 in __GI___assert_fail (assertion=0x55bd05740338 "m_tickets[MDL_STATEMENT].is_empty()", file=0x55bd0573fd19 "/test/11.1_dbg/sql/mdl.cc", line=3261, function=0x55bd05740db8 "void MDL_context::set_transaction_duration_for_all_locks()") at ./assert/assert.c:101
#7 0x000055bd04d6e704 in MDL_context::set_transaction_duration_for_all_locks (this=this@entry=0x1465c0000eb0) at /test/11.1_dbg/sql/mdl.cc:3261
#8 0x000055bd04ba3f60 in THD::leave_locked_tables_mode (this=this@entry=0x1465c0000d58) at /test/11.1_dbg/sql/sql_class.cc:6020
#9 0x000055bd04b84130 in Locked_tables_list::unlock_locked_tables (this=this@entry=0x1465c0004db8, thd=thd@entry=0x1465c0000d58) at /test/11.1_dbg/sql/sql_base.cc:2595
#10 0x000055bd04b842a9 in Locked_tables_list::unlock_locked_table (this=0x1465c0004db8, thd=0x1465c0000d58, mdl_ticket=<optimized out>) at /test/11.1_dbg/sql/sql_base.cc:2643
#11 0x000055bd04bc08f0 in select_create::abort_result_set (this=0x1465c0014a00) at /test/11.1_dbg/sql/sql_insert.cc:5329
#12 0x000055bd04c93044 in handle_select (thd=thd@entry=0x1465c0000d58, lex=lex@entry=0x1465c0004ec8, result=result@entry=0x1465c0014a00, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/11.1_dbg/sql/sql_select.cc:629
#13 0x000055bd04ce2974 in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x1465c0000d58) at /test/11.1_dbg/sql/sql_table.cc:12422
#14 0x000055bd04c09604 in mysql_execute_command (thd=thd@entry=0x1465c0000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.1_dbg/sql/sql_parse.cc:5760
#15 0x000055bd04c0af05 in mysql_parse (thd=thd@entry=0x1465c0000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1465f3bfc230) at /test/11.1_dbg/sql/sql_parse.cc:7760
#16 0x000055bd04c0d099 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1465c0000d58, packet=packet@entry=0x1465c000ae49 "CREATE OR REPLACE TABLE t (a INT) ENGINE=Aria COMMENT=''SELECT'' AS a", packet_length=packet_length@entry=69, blocking=blocking@entry=true) at /test/11.1_dbg/sql/sql_class.h:242
#17 0x000055bd04c0eef5 in do_command (thd=0x1465c0000d58, blocking=blocking@entry=true) at /test/11.1_dbg/sql/sql_parse.cc:1405
#18 0x000055bd04d60cfc in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55bd08081e98, put_in_cache=put_in_cache@entry=true) at /test/11.1_dbg/sql/sql_connect.cc:1416
#19 0x000055bd04d60f5b in handle_one_connection (arg=0x55bd08081e98) at /test/11.1_dbg/sql/sql_connect.cc:1318
#20 0x000014662cbb9b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#21 0x000014662cc4ba00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
Bug confirmed present in:
MariaDB: 10.6.13 (dbg), 10.7.8 (dbg), 10.8.8 (dbg), 10.9.6 (dbg), 10.10.4 (dbg), 10.11.3 (dbg), 11.0.2 (dbg), 11.1.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.29 (dbg), 10.4.29 (opt), 10.5.20 (dbg), 10.5.20 (opt), 10.6.13 (opt), 10.7.8 (opt), 10.8.8 (opt), 10.9.6 (opt), 10.10.4 (opt), 10.11.3 (opt), 11.0.2 (opt), 11.1.0 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.40 (dbg), 5.7.40 (opt), 8.0.31 (dbg), 8.0.31 (opt)
Transition
Time In Source Status
Execution Times
Open
Confirmed
1h 37m
1
{"report":{"fcp":879.5999999046326,"ttfb":243.79999995231628,"pageVisibility":"visible","entityId":120953,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"77b3407d-86d2-41d9-bde5-baffeed4082c","navigationType":0,"readyForUser":942,"redirectCount":0,"resourceLoadedEnd":928.4000000953674,"resourceLoadedStart":248.59999990463257,"resourceTiming":[{"duration":219.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":248.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":248.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":468,"responseStart":0,"secureConnectionStart":0},{"duration":219.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":249,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":468.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":228.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":249.09999990463257,"connectEnd":249.09999990463257,"connectStart":249.09999990463257,"domainLookupEnd":249.09999990463257,"domainLookupStart":249.09999990463257,"fetchStart":249.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":249.09999990463257,"responseEnd":477.90000009536743,"responseStart":477.90000009536743,"secureConnectionStart":249.09999990463257},{"duration":290.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":249.20000004768372,"connectEnd":249.20000004768372,"connectStart":249.20000004768372,"domainLookupEnd":249.20000004768372,"domainLookupStart":249.20000004768372,"fetchStart":249.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":249.20000004768372,"responseEnd":540,"responseStart":540,"secureConnectionStart":249.20000004768372},{"duration":294.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":249.29999995231628,"connectEnd":249.29999995231628,"connectStart":249.29999995231628,"domainLookupEnd":249.29999995231628,"domainLookupStart":249.29999995231628,"fetchStart":249.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":249.29999995231628,"responseEnd":543.7999999523163,"responseStart":543.7999999523163,"secureConnectionStart":249.29999995231628},{"duration":294.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":249.29999995231628,"connectEnd":249.29999995231628,"connectStart":249.29999995231628,"domainLookupEnd":249.29999995231628,"domainLookupStart":249.29999995231628,"fetchStart":249.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":249.29999995231628,"responseEnd":544.2000000476837,"responseStart":544.2000000476837,"secureConnectionStart":249.29999995231628},{"duration":295.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":249.40000009536743,"connectEnd":249.40000009536743,"connectStart":249.40000009536743,"domainLookupEnd":249.40000009536743,"domainLookupStart":249.40000009536743,"fetchStart":249.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":249.40000009536743,"responseEnd":544.5,"responseStart":544.5,"secureConnectionStart":249.40000009536743},{"duration":295.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":249.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":544.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":295.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":249.70000004768372,"connectEnd":249.70000004768372,"connectStart":249.70000004768372,"domainLookupEnd":249.70000004768372,"domainLookupStart":249.70000004768372,"fetchStart":249.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":249.70000004768372,"responseEnd":545,"responseStart":545,"secureConnectionStart":249.70000004768372},{"duration":295.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":249.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":545.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":295.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":249.90000009536743,"connectEnd":249.90000009536743,"connectStart":249.90000009536743,"domainLookupEnd":249.90000009536743,"domainLookupStart":249.90000009536743,"fetchStart":249.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":249.90000009536743,"responseEnd":545.5,"responseStart":545.5,"secureConnectionStart":249.90000009536743},{"duration":623.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":262.09999990463257,"connectEnd":262.09999990463257,"connectStart":262.09999990463257,"domainLookupEnd":262.09999990463257,"domainLookupStart":262.09999990463257,"fetchStart":262.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":262.09999990463257,"responseEnd":885.7999999523163,"responseStart":885.7999999523163,"secureConnectionStart":262.09999990463257},{"duration":664.6000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":263.7999999523163,"connectEnd":263.7999999523163,"connectStart":263.7999999523163,"domainLookupEnd":263.7999999523163,"domainLookupStart":263.7999999523163,"fetchStart":263.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":263.7999999523163,"responseEnd":928.4000000953674,"responseStart":928.4000000953674,"secureConnectionStart":263.7999999523163},{"duration":200,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":688,"connectEnd":688,"connectStart":688,"domainLookupEnd":688,"domainLookupStart":688,"fetchStart":688,"redirectEnd":0,"redirectStart":0,"requestStart":688,"responseEnd":888,"responseStart":888,"secureConnectionStart":688},{"duration":162,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":858.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":858.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1020.7000000476837,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":103,"responseStart":244,"responseEnd":264,"domLoading":247,"domInteractive":1049,"domContentLoadedEventStart":1049,"domContentLoadedEventEnd":1090,"domComplete":1340,"loadEventStart":1340,"loadEventEnd":1341,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1031.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1031.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1032.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1032.9000000953674},{"name":"activityTabFullyLoaded","time":1104.9000000953674}],"measures":[],"correlationId":"4a9311d81d87d7","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":74,"dbReadsTimeInMs":15,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}