The test case is for reproducing purposes only, don't put it into the regression suite! Create a proper synchronized one instead.
If it's not reproducible, try to increase the $run value inside the test. Running with --repeat is also possible, but use --nocheck-testcases.
--source include/have_perfschema.inc
|
|
SET GLOBAL table_open_cache= 10;
|
|
--connect (con1,localhost,root,,test)
|
|
--let $run= 1000
|
|
while ($run)
|
{
|
--connection con1
|
CREATE TABLE t1 SELECT 1;
|
|
--connection default
|
UPDATE performance_schema.setup_consumers SET enabled = 'NO';
|
UPDATE performance_schema.setup_timers SET timer_name = 'MICROSECOND';
|
TRUNCATE TABLE performance_schema.events_waits_current;
|
TRUNCATE TABLE performance_schema.file_summary_by_instance;
|
--send
|
DROP TABLE IF EXISTS t1;
|
|
--connection con1
|
DROP TABLE IF EXISTS non_existing_table;
|
|
--connection default
|
--reap
|
|
--dec $run
|
}
|
10.2 1cc1d0429da
|
mysqld: /data/src/10.2/sql/table_cache.cc:1128: bool tdc_remove_table(THD*, enum_tdc_remove_table_type, const char*, const char*, bool): Assertion `element->all_tables.is_empty() || remove_type != TDC_RT_REMOVE_ALL' failed.
|
180718 12:48:58 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fb5bb3c6ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055d5c3faf312 in tdc_remove_table (thd=0x7fb5a4000b00, remove_type=TDC_RT_REMOVE_ALL, db=0x7fb5a4012b60 "test", table_name=0x7fb5a4012518 "t1", kill_delayed_threads=false) at /data/src/10.2/sql/table_cache.cc:1128
|
#9 0x000055d5c3e815d3 in mysql_rm_table_no_locks (thd=0x7fb5a4000b00, tables=0x7fb5a4012550, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false, dont_free_locks=false) at /data/src/10.2/sql/sql_table.cc:2457
|
#10 0x000055d5c3e808bf in mysql_rm_table (thd=0x7fb5a4000b00, tables=0x7fb5a4012550, if_exists=1 '\001', drop_temporary=0 '\000') at /data/src/10.2/sql/sql_table.cc:2088
|
#11 0x000055d5c3dc1ef1 in mysql_execute_command (thd=0x7fb5a4000b00) at /data/src/10.2/sql/sql_parse.cc:4756
|
#12 0x000055d5c3dcbe89 in mysql_parse (thd=0x7fb5a4000b00, rawbuf=0x7fb5a4012478 "DROP TABLE IF EXISTS t1", length=23, parser_state=0x7fb5b56a2200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7995
|
#13 0x000055d5c3db99ae in dispatch_command (command=COM_QUERY, thd=0x7fb5a4000b00, packet=0x7fb5a4177371 "DROP TABLE IF EXISTS t1", packet_length=23, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1821
|
#14 0x000055d5c3db8311 in do_command (thd=0x7fb5a4000b00) at /data/src/10.2/sql/sql_parse.cc:1375
|
#15 0x000055d5c3f095d2 in do_handle_one_connection (connect=0x55d5c725b390) at /data/src/10.2/sql/sql_connect.cc:1335
|
#16 0x000055d5c3f0935f in handle_one_connection (arg=0x55d5c725b390) at /data/src/10.2/sql/sql_connect.cc:1241
|
#17 0x000055d5c432b658 in pfs_spawn_thread (arg=0x55d5c7235ed0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#18 0x00007fb5bd09d494 in start_thread (arg=0x7fb5b56a3700) at pthread_create.c:333
|
#19 0x00007fb5bb48393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Reproducible with MyISAM and InnoDB.
Not reproducible on 10.1.
- relates to
-
MDEV-14894
[Draft] Assorted crashes and assertion failures in and around tdc_remove_table
-
-
Closed
{"report":{"fcp":673.7999999523163,"ttfb":143.40000009536743,"pageVisibility":"visible","entityId":68731,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"cf962b4b-4c24-411d-9789-aa922fc0fba7","navigationType":0,"readyForUser":755.9000000953674,"redirectCount":0,"resourceLoadedEnd":782,"resourceLoadedStart":149,"resourceTiming":[{"duration":5.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":149,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":149,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":154.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":6,"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":149.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":149.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":155.20000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":63,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":149.40000009536743,"connectEnd":149.40000009536743,"connectStart":149.40000009536743,"domainLookupEnd":149.40000009536743,"domainLookupStart":149.40000009536743,"fetchStart":149.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":149.40000009536743,"responseEnd":212.40000009536743,"responseStart":212.40000009536743,"secureConnectionStart":149.40000009536743},{"duration":166.29999995231628,"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":149.40000009536743,"connectEnd":149.40000009536743,"connectStart":149.40000009536743,"domainLookupEnd":149.40000009536743,"domainLookupStart":149.40000009536743,"fetchStart":149.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":149.40000009536743,"responseEnd":315.7000000476837,"responseStart":315.7000000476837,"secureConnectionStart":149.40000009536743},{"duration":169.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":149.5,"connectEnd":149.5,"connectStart":149.5,"domainLookupEnd":149.5,"domainLookupStart":149.5,"fetchStart":149.5,"redirectEnd":0,"redirectStart":0,"requestStart":149.5,"responseEnd":319.40000009536743,"responseStart":319.40000009536743,"secureConnectionStart":149.5},{"duration":170.59999990463257,"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":149.60000014305115,"connectEnd":149.60000014305115,"connectStart":149.60000014305115,"domainLookupEnd":149.60000014305115,"domainLookupStart":149.60000014305115,"fetchStart":149.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":149.60000014305115,"responseEnd":320.2000000476837,"responseStart":320.2000000476837,"secureConnectionStart":149.60000014305115},{"duration":171,"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":149.79999995231628,"connectEnd":149.79999995231628,"connectStart":149.79999995231628,"domainLookupEnd":149.79999995231628,"domainLookupStart":149.79999995231628,"fetchStart":149.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":149.79999995231628,"responseEnd":320.7999999523163,"responseStart":320.7999999523163,"secureConnectionStart":149.79999995231628},{"duration":171.59999990463257,"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":149.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":149.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":321.5,"responseStart":0,"secureConnectionStart":0},{"duration":171.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":150,"connectEnd":150,"connectStart":150,"domainLookupEnd":150,"domainLookupStart":150,"fetchStart":150,"redirectEnd":0,"redirectStart":0,"requestStart":150,"responseEnd":321.5,"responseStart":321.5,"secureConnectionStart":150},{"duration":172,"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":150.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":150.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":322.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":172.09999990463257,"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":150.20000004768372,"connectEnd":150.20000004768372,"connectStart":150.20000004768372,"domainLookupEnd":150.20000004768372,"domainLookupStart":150.20000004768372,"fetchStart":150.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":150.20000004768372,"responseEnd":322.2999999523163,"responseStart":322.2999999523163,"secureConnectionStart":150.20000004768372},{"duration":395.40000009536743,"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":155.79999995231628,"connectEnd":155.79999995231628,"connectStart":155.79999995231628,"domainLookupEnd":155.79999995231628,"domainLookupStart":155.79999995231628,"fetchStart":155.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":155.79999995231628,"responseEnd":551.2000000476837,"responseStart":551.2000000476837,"secureConnectionStart":155.79999995231628},{"duration":433,"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":156.60000014305115,"connectEnd":156.60000014305115,"connectStart":156.60000014305115,"domainLookupEnd":156.60000014305115,"domainLookupStart":156.60000014305115,"fetchStart":156.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":156.60000014305115,"responseEnd":589.6000001430511,"responseStart":589.6000001430511,"secureConnectionStart":156.60000014305115},{"duration":189.89999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":361.60000014305115,"connectEnd":361.60000014305115,"connectStart":361.60000014305115,"domainLookupEnd":361.60000014305115,"domainLookupStart":361.60000014305115,"fetchStart":361.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":361.60000014305115,"responseEnd":551.5,"responseStart":551.5,"secureConnectionStart":361.60000014305115},{"duration":187.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":594.5,"connectEnd":594.5,"connectStart":594.5,"domainLookupEnd":594.5,"domainLookupStart":594.5,"fetchStart":594.5,"redirectEnd":0,"redirectStart":0,"requestStart":594.5,"responseEnd":782,"responseStart":782,"secureConnectionStart":594.5},{"duration":168,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":666.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":666.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":834.7000000476837,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":10,"responseStart":143,"responseEnd":154,"domLoading":147,"domInteractive":817,"domContentLoadedEventStart":817,"domContentLoadedEventEnd":863,"domComplete":1816,"loadEventStart":1816,"loadEventEnd":1816,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":794.6000001430511},{"name":"bigPipe.sidebar-id.end","time":795.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":795.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":798},{"name":"activityTabFullyLoaded","time":875.7999999523163}],"measures":[],"correlationId":"36793beb29038e","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":74,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}