-
Bug
-
-
Critical
-
Resolution:
Fixed
-
10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
-
-
Affects 11.2 73915d2cdad2d539ce984529bb6e64dc082ecd52 and does not affect 10.4 e9f3ca612528c5f917e27ef6113fd1deda2aef26
Test to reproduce (put under say spider/bugfix suite):
--disable_query_log
|
--disable_result_log
|
--source ../../t/test_init.inc
|
--enable_result_log
|
--enable_query_log
|
|
evalp CREATE SERVER srv FOREIGN DATA WRAPPER mysql
|
OPTIONS (SOCKET "$MASTER_1_MYSOCK", DATABASE 'test',user 'root');
|
|
set session spider_delete_all_rows_type=0;
|
create table t2 (c int);
|
create table t1 (c int) ENGINE=Spider
|
COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2", delete_all_rows_type "0"';
|
insert ignore into t1 values (42), (378);
|
select * from t1;
|
delete from t1;
|
select * from t1;
|
|
drop table t1, t2;
|
|
drop server srv;
|
--disable_query_log
|
--disable_result_log
|
--source ../../t/test_deinit.inc
|
--enable_result_log
|
--enable_query_log
|
--echo #
|
--echo # end of test tmp
|
--echo #
|
Trace in mtr output:
mysys/stacktrace.c:215(my_print_stacktrace)[0x55bf85b4b891]
|
sql/signal_handler.cc:241(handle_fatal_signal)[0x55bf852ce514]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x13140)[0x7fcad4843140]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x15e319)[0x7fcad4078319]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x68f76)[0x7fcad3f82f76]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x69f44)[0x7fcad3f83f44]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x670d4)[0x7fcad3f810d4]
|
/lib/x86_64-linux-gnu/libc.so.6(_IO_fprintf+0x96)[0x7fcad3f6dcc6]
|
mysys/thr_mutex.c:296(safe_mutex_lock)[0x55bf85b5013b]
|
mysys/my_thr_init.c:487(psi_mutex_lock)[0x55bf85b49a1d]
|
psi/mysql_thread.h:746(inline_mysql_mutex_lock)[0x7fcac0277fdb]
|
spider/spd_db_conn.cc:6701(spider_db_delete_all_rows(ha_spider*))[0x7fcac029a508]
|
spider/ha_spider.cc:8422(ha_spider::delete_all_rows())[0x7fcac0341e4c]
|
sql/handler.cc:5272(handler::ha_delete_all_rows())[0x55bf852e0a30]
|
sql/sql_delete.cc:438(Sql_cmd_delete::delete_from_single_table(THD*))[0x55bf84e80b99]
|
sql/sql_delete.cc:1794(Sql_cmd_delete::execute_inner(THD*))[0x55bf84e85a95]
|
sql/sql_select.cc:33356(Sql_cmd_dml::execute(THD*))[0x55bf84fa76f5]
|
sql/sql_parse.cc:4394(mysql_execute_command(THD*, bool))[0x55bf84ee9c51]
|
sql/sql_parse.cc:7799(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55bf84ef4fe7]
|
sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55bf84ee2592]
|
sql/sql_parse.cc:1406(do_command(THD*, bool))[0x55bf84ee0f60]
|
sql/sql_connect.cc:1445(do_handle_one_connection(CONNECT*, bool))[0x55bf850c8c0a]
|
sql/sql_connect.cc:1349(handle_one_connection)[0x55bf850c8975]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55bf855dc062]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7ea7)[0x7fcad4837ea7]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fcad4016a2f]
|
{"report":{"fcp":1282.5999999046326,"ttfb":239.39999961853027,"pageVisibility":"visible","entityId":124472,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"56de5a84-f2a7-4dc3-85cb-8ce8e92e4e52","navigationType":0,"readyForUser":1386.7999997138977,"redirectCount":0,"resourceLoadedEnd":1471.5,"resourceLoadedStart":245.2999997138977,"resourceTiming":[{"duration":185,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":245.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":430.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":201.2999997138977,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":245.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":245.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":446.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":481.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":245.7999997138977,"connectEnd":245.7999997138977,"connectStart":245.7999997138977,"domainLookupEnd":245.7999997138977,"domainLookupStart":245.7999997138977,"fetchStart":245.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":245.7999997138977,"responseEnd":727.1999998092651,"responseStart":727.1999998092651,"secureConnectionStart":245.7999997138977},{"duration":610.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":245.89999961853027,"connectEnd":245.89999961853027,"connectStart":245.89999961853027,"domainLookupEnd":245.89999961853027,"domainLookupStart":245.89999961853027,"fetchStart":245.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":245.89999961853027,"responseEnd":856.0999999046326,"responseStart":856.0999999046326,"secureConnectionStart":245.89999961853027},{"duration":614.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":246.09999990463257,"connectEnd":246.09999990463257,"connectStart":246.09999990463257,"domainLookupEnd":246.09999990463257,"domainLookupStart":246.09999990463257,"fetchStart":246.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":246.09999990463257,"responseEnd":860.3999996185303,"responseStart":860.3999996185303,"secureConnectionStart":246.09999990463257},{"duration":615.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":246.2999997138977,"connectEnd":246.2999997138977,"connectStart":246.2999997138977,"domainLookupEnd":246.2999997138977,"domainLookupStart":246.2999997138977,"fetchStart":246.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":246.2999997138977,"responseEnd":861.5,"responseStart":861.5,"secureConnectionStart":246.2999997138977},{"duration":615.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":246.59999990463257,"connectEnd":246.59999990463257,"connectStart":246.59999990463257,"domainLookupEnd":246.59999990463257,"domainLookupStart":246.59999990463257,"fetchStart":246.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":246.59999990463257,"responseEnd":862.0999999046326,"responseStart":862.0999999046326,"secureConnectionStart":246.59999990463257},{"duration":676.1999998092651,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":246.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":246.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":922.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":616.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":247,"connectEnd":247,"connectStart":247,"domainLookupEnd":247,"domainLookupStart":247,"fetchStart":247,"redirectEnd":0,"redirectStart":0,"requestStart":247,"responseEnd":863.5,"responseStart":863.5,"secureConnectionStart":247},{"duration":675.9000000953674,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":247.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":247.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":923,"responseStart":0,"secureConnectionStart":0},{"duration":617.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":247.2999997138977,"connectEnd":247.2999997138977,"connectStart":247.2999997138977,"domainLookupEnd":247.2999997138977,"domainLookupStart":247.2999997138977,"fetchStart":247.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":247.2999997138977,"responseEnd":865,"responseStart":865,"secureConnectionStart":247.2999997138977},{"duration":741.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":256.69999980926514,"connectEnd":256.69999980926514,"connectStart":256.69999980926514,"domainLookupEnd":256.69999980926514,"domainLookupStart":256.69999980926514,"fetchStart":256.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":256.69999980926514,"responseEnd":997.7999997138977,"responseStart":997.7999997138977,"secureConnectionStart":256.69999980926514},{"duration":892.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":256.7999997138977,"connectEnd":256.7999997138977,"connectStart":256.7999997138977,"domainLookupEnd":256.7999997138977,"domainLookupStart":256.7999997138977,"fetchStart":256.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":256.7999997138977,"responseEnd":1149.5999999046326,"responseStart":1149.5999999046326,"secureConnectionStart":256.7999997138977},{"duration":82.39999961853027,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":945.5,"connectEnd":945.5,"connectStart":945.5,"domainLookupEnd":945.5,"domainLookupStart":945.5,"fetchStart":945.5,"redirectEnd":0,"redirectStart":0,"requestStart":945.5,"responseEnd":1027.8999996185303,"responseStart":1027.8999996185303,"secureConnectionStart":945.5},{"duration":239.10000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1232.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1232.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1471.5,"responseStart":0,"secureConnectionStart":0},{"duration":218.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/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&whisper-enabled=true","startTime":1233.3999996185303,"connectEnd":1233.3999996185303,"connectStart":1233.3999996185303,"domainLookupEnd":1233.3999996185303,"domainLookupStart":1233.3999996185303,"fetchStart":1233.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1233.3999996185303,"responseEnd":1452.2999997138977,"responseStart":1452.2999997138977,"secureConnectionStart":1233.3999996185303},{"duration":225.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1233.7999997138977,"connectEnd":1233.7999997138977,"connectStart":1233.7999997138977,"domainLookupEnd":1233.7999997138977,"domainLookupStart":1233.7999997138977,"fetchStart":1233.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1233.7999997138977,"responseEnd":1459.2999997138977,"responseStart":1459.2999997138977,"secureConnectionStart":1233.7999997138977},{"duration":218.19999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1276.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1276.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1494.3999996185303,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":63,"responseStart":240,"responseEnd":249,"domLoading":243,"domInteractive":1505,"domContentLoadedEventStart":1505,"domContentLoadedEventEnd":1568,"domComplete":1696,"loadEventStart":1696,"loadEventEnd":1697,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1474.2999997138977},{"name":"bigPipe.sidebar-id.end","time":1475.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1475.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1476.5999999046326},{"name":"activityTabFullyLoaded","time":1591.5999999046326}],"measures":[],"correlationId":"f09fb3e17a1403","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":108,"dbReadsTimeInMs":26,"dbConnsTimeInMs":36,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}