CREATE TABLE t1 (a INT);
|
CREATE TEMPORARY TABLE tmp (b INT);
|
LOCK TABLE t1 READ;
|
--error ER_UNKNOWN_SEQUENCES
|
DROP SEQUENCE tmp;
|
|
# Cleanup
|
UNLOCK TABLES;
|
DROP TABLE t1;
|
10.3 a2335b79
|
mysqld: /data/src/10.3/sql/sql_table.cc:2395: int mysql_rm_table_no_locks(THD*, TABLE_LIST*, bool, bool, bool, bool, bool, bool): Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, table->db.str, table->table_name.str, MDL_SHARED)' failed.
|
190417 19:02:21 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f1437b17ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000562c267cde8c in mysql_rm_table_no_locks (thd=0x7f1420000b00, tables=0x7f1420014db8, if_exists=false, drop_temporary=false, drop_view=false, drop_sequence=true, dont_log_query=false, dont_free_locks=false) at /data/src/10.3/sql/sql_table.cc:2393
|
#9 0x0000562c267cd494 in mysql_rm_table (thd=0x7f1420000b00, tables=0x7f1420014db8, if_exists=false, drop_temporary=false, drop_sequence=true) at /data/src/10.3/sql/sql_table.cc:2124
|
#10 0x0000562c26706f53 in mysql_execute_command (thd=0x7f1420000b00) at /data/src/10.3/sql/sql_parse.cc:5055
|
#11 0x0000562c26710781 in mysql_parse (thd=0x7f1420000b00, rawbuf=0x7f1420014ce8 "DROP SEQUENCE tmp", length=17, parser_state=0x7f1431cbe5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091
|
#12 0x0000562c266fda50 in dispatch_command (command=COM_QUERY, thd=0x7f1420000b00, packet=0x7f142000b1f1 "DROP SEQUENCE tmp", packet_length=17, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1857
|
#13 0x0000562c266fc43a in do_command (thd=0x7f1420000b00) at /data/src/10.3/sql/sql_parse.cc:1403
|
#14 0x0000562c2686503d in do_handle_one_connection (connect=0x562c2909f0b0) at /data/src/10.3/sql/sql_connect.cc:1402
|
#15 0x0000562c26864dc1 in handle_one_connection (arg=0x562c2909f0b0) at /data/src/10.3/sql/sql_connect.cc:1308
|
#16 0x0000562c26d016a3 in pfs_spawn_thread (arg=0x562c28fe3f50) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#17 0x00007f1439c0c494 in start_thread (arg=0x7f1431cbf700) at pthread_create.c:333
|
#18 0x00007f1437bd493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
No obvious problems on a non-debug build with the test case above, but here is another one which does cause a crash on a non-debug build (and the same assertion failure on a debug build):
CREATE TABLE t (a INT);
|
CREATE TEMPORARY TABLE s (f INT);
|
CREATE SEQUENCE s;
|
LOCK TABLE t WRITE;
|
DROP SEQUENCE s;
|
|
# Cleanup
|
UNLOCK TABLES;
|
DROP TABLE t;
|
10.3 a2335b79 non-debug
|
#2 <signal handler called>
|
#3 0x000055ca45f79e0c in MDL_ticket::has_stronger_or_equal_type (this=this@entry=0x0, type=type@entry=MDL_EXCLUSIVE) at /data/src/10.3/sql/mdl.cc:1720
|
#4 0x000055ca45f7bd60 in MDL_context::upgrade_shared_lock (this=this@entry=0x7f3670000ac8, mdl_ticket=0x0, new_type=new_type@entry=MDL_EXCLUSIVE, lock_wait_timeout=86400) at /data/src/10.3/sql/mdl.cc:2330
|
#5 0x000055ca45e3ede5 in wait_while_table_is_used (thd=thd@entry=0x7f36700009a8, table=0x7f367006bf78, function=function@entry=HA_EXTRA_NOT_USED) at /data/src/10.3/sql/sql_base.cc:1246
|
#6 0x000055ca45f1aeb7 in mysql_rm_table_no_locks (thd=0x7f36700009a8, tables=<optimized out>, if_exists=<optimized out>, drop_temporary=<optimized out>, drop_view=<optimized out>, drop_sequence=<optimized out>, dont_log_query=false, dont_free_locks=false) at /data/src/10.3/sql/sql_table.cc:2487
|
#7 0x000055ca45f1c055 in mysql_rm_table (thd=0x7f36700009a8, tables=0x7f3670011758, if_exists=false, drop_temporary=3, drop_sequence=false) at /data/src/10.3/sql/sql_table.cc:2124
|
#8 0x000055ca45e992fb in mysql_execute_command (thd=0x7f36700009a8) at /data/src/10.3/sql/sql_parse.cc:5055
|
#9 0x000055ca45e9d8e1 in mysql_parse (thd=0x7f36700009a8, rawbuf=<optimized out>, length=15, parser_state=0x7f368139f630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:8091
|
#10 0x000055ca45ea0028 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f36700009a8, packet=packet@entry=0x7f3670009329 "DROP SEQUENCE s", packet_length=packet_length@entry=15, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1857
|
#11 0x000055ca45ea09e0 in do_command (thd=0x7f36700009a8) at /data/src/10.3/sql/sql_parse.cc:1403
|
#12 0x000055ca45f73994 in do_handle_one_connection (connect=connect@entry=0x55ca49089f08) at /data/src/10.3/sql/sql_connect.cc:1402
|
#13 0x000055ca45f73b34 in handle_one_connection (arg=arg@entry=0x55ca49089f08) at /data/src/10.3/sql/sql_connect.cc:1308
|
#14 0x000055ca46258614 in pfs_spawn_thread (arg=0x55ca4908a168) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#15 0x00007f36892ef494 in start_thread (arg=0x7f36813a0700) at pthread_create.c:333
|
#16 0x00007f36872b793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
- blocks
-
MDEV-21657
Crash in has_stronger_or_equal_type Query doing a LOCK TABLE
-
-
Open
- is duplicated by
-
MDEV-23205
Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str, table_name.str, MDL_SHARED)' failed in mysql_rm_table_no_locks
-
-
Closed
- relates to
-
MDEV-19400
Assertion `!table->s->tmp_table' failed in wait_while_table_is_used or server crash in MDL_ticket::has_stronger_or_equal_type
-
-
Closed
-
MDEV-24382
Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, db, table_name, MDL_EXCLUSIVE)' failed in tdc_remove_table
-
-
Stalled
-
MDEV-34789
Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str, table_name.str, MDL_SHARED)' failed in mysql_rm_table_no_locks on DROP TABLE, including via scripts/mariadb-install-db
-
-
Closed
{"report":{"fcp":821.7000000476837,"ttfb":279.90000009536743,"pageVisibility":"visible","entityId":75436,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"498a48d0-10ef-45f6-911b-2ba86b4df921","navigationType":0,"readyForUser":957.5,"redirectCount":0,"resourceLoadedEnd":683.0999999046326,"resourceLoadedStart":284.7000000476837,"resourceTiming":[{"duration":65.20000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":284.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":349.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":65.29999995231628,"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":284.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":350.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":178.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":285.09999990463257,"connectEnd":285.09999990463257,"connectStart":285.09999990463257,"domainLookupEnd":285.09999990463257,"domainLookupStart":285.09999990463257,"fetchStart":285.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":355,"responseEnd":463.2999999523163,"responseStart":368.2999999523163,"secureConnectionStart":285.09999990463257},{"duration":283.10000014305115,"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":285.09999990463257,"connectEnd":285.09999990463257,"connectStart":285.09999990463257,"domainLookupEnd":285.09999990463257,"domainLookupStart":285.09999990463257,"fetchStart":285.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":356.5,"responseEnd":568.2000000476837,"responseStart":372.7999999523163,"secureConnectionStart":285.09999990463257},{"duration":90.90000009536743,"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":285.2999999523163,"connectEnd":285.2999999523163,"connectStart":285.2999999523163,"domainLookupEnd":285.2999999523163,"domainLookupStart":285.2999999523163,"fetchStart":285.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":357,"responseEnd":376.2000000476837,"responseStart":375.2999999523163,"secureConnectionStart":285.2999999523163},{"duration":93.79999995231628,"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":285.2999999523163,"connectEnd":285.2999999523163,"connectStart":285.2999999523163,"domainLookupEnd":285.2999999523163,"domainLookupStart":285.2999999523163,"fetchStart":285.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":359.59999990463257,"responseEnd":379.09999990463257,"responseStart":377,"secureConnectionStart":285.2999999523163},{"duration":93.89999985694885,"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":285.40000009536743,"connectEnd":285.40000009536743,"connectStart":285.40000009536743,"domainLookupEnd":285.40000009536743,"domainLookupStart":285.40000009536743,"fetchStart":285.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":359.90000009536743,"responseEnd":379.2999999523163,"responseStart":377.59999990463257,"secureConnectionStart":285.40000009536743},{"duration":73.40000009536743,"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":285.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":359,"responseStart":0,"secureConnectionStart":0},{"duration":94.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":285.59999990463257,"connectEnd":285.59999990463257,"connectStart":285.59999990463257,"domainLookupEnd":285.59999990463257,"domainLookupStart":285.59999990463257,"fetchStart":285.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":361.90000009536743,"responseEnd":379.90000009536743,"responseStart":378.40000009536743,"secureConnectionStart":285.59999990463257},{"duration":74.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":285.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":360.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":97,"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":285.7999999523163,"connectEnd":285.7999999523163,"connectStart":285.7999999523163,"domainLookupEnd":285.7999999523163,"domainLookupStart":285.7999999523163,"fetchStart":285.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":367.09999990463257,"responseEnd":382.7999999523163,"responseStart":382,"secureConnectionStart":285.7999999523163},{"duration":304,"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":291.7999999523163,"connectEnd":291.7999999523163,"connectStart":291.7999999523163,"domainLookupEnd":291.7999999523163,"domainLookupStart":291.7999999523163,"fetchStart":291.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":486.59999990463257,"responseEnd":595.7999999523163,"responseStart":590.5999999046326,"secureConnectionStart":291.7999999523163},{"duration":391.2999999523163,"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":291.7999999523163,"connectEnd":291.7999999523163,"connectStart":291.7999999523163,"domainLookupEnd":291.7999999523163,"domainLookupStart":291.7999999523163,"fetchStart":291.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":671.4000000953674,"responseEnd":683.0999999046326,"responseStart":682.2999999523163,"secureConnectionStart":291.7999999523163},{"duration":117.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":590.7999999523163,"connectEnd":590.7999999523163,"connectStart":590.7999999523163,"domainLookupEnd":590.7999999523163,"domainLookupStart":590.7999999523163,"fetchStart":590.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":678.7000000476837,"responseEnd":708.7000000476837,"responseStart":708,"secureConnectionStart":590.7999999523163},{"duration":254.89999985694885,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":815.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":815.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1070.2999999523163,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":117,"responseStart":280,"responseEnd":289,"domLoading":283,"domInteractive":1025,"domContentLoadedEventStart":1025,"domContentLoadedEventEnd":1072,"domComplete":1735,"loadEventStart":1735,"loadEventEnd":1735,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1001.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1001.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1002},{"name":"bigPipe.activity-panel-pipe-id.end","time":1003.5},{"name":"activityTabFullyLoaded","time":1091.9000000953674}],"measures":[],"correlationId":"b4c0a5feddb9c6","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":87,"dbReadsTimeInMs":15,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
MDEV-23205Marked as duplicate of this one, slightly different testcase, please check against fix.