Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.0(EOL) , 10.1(EOL) , 10.2(EOL) , 10.3(EOL) , 10.4(EOL)
test case:
SET sql_mode= '' ;
SET default_storage_engine = 'Connect' ;
CREATE TABLE tmp AS SELECT 1654509913105235968 - '1994-09-26' FROM dual;
CREATE or replace TABLE tmp AS SELECT 1654509913105235968 - '1994-09-26' FROM dual;
10.0 c631060713a2af2890284f
Thread 1 (Thread 0x7fbe67d4e700 (LWP 2931)):
#0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1 0x0000000000ea8d92 in my_write_core (sig=11) at /git/10.0/mysys/stacktrace.c:478
#2 0x0000000000865a87 in handle_fatal_signal (sig=11) at /git/10.0/sql/signal_handler.cc:285
#3 <signal handler called>
#4 0x00007fbe5f50b42d in PlugCloseFile (g=0x7fbe5c75e000, fp=0x3030303030303030, all=true) at /git/10.0/storage/connect/plgdbutl.cpp:873
#5 0x00007fbe5f50b6d4 in PlugCleanup (g=0x7fbe5c75e000, dofree=true) at /git/10.0/storage/connect/plgdbutl.cpp:972
#6 0x00007fbe5f4b3b7b in PopUser (xp=0x7fbe5c41a0e0) at /git/10.0/storage/connect/ha_connect.cc:941
#7 0x00007fbe5f4b39fd in ha_connect::~ha_connect (this=0x7fbe5c77d888, __in_chrg=<optimized out>) at /git/10.0/storage/connect/ha_connect.cc:910
#8 0x00007fbe5f4b3a82 in ha_connect::~ha_connect (this=0x7fbe5c77d888, __in_chrg=<optimized out>) at /git/10.0/storage/connect/ha_connect.cc:911
#9 0x0000000000748587 in closefrm (table=0x7fbe5c49e470, free_share=true) at /git/10.0/sql/table.cc:2975
#10 0x00000000005ed4d2 in intern_close_table (table=0x7fbe5c49e470) at /git/10.0/sql/sql_base.cc:337
#11 0x00000000007f4464 in tdc_remove_table (thd=0x7fbe603fa070, remove_type=TDC_RT_REMOVE_ALL, db=0x7fbe5c5a27c0 "test", table_name=0x7fbe5c5a21a8 "tmp", kill_delayed_threads=false) at /git/10.0/sql/table_cache.cc:1029
#12 0x00000000005f0a3a in drop_open_table (thd=0x7fbe603fa070, table=0x7fbe5c49e470, db_name=0x7fbe5c5a27c0 "test", table_name=0x7fbe5c5a21a8 "tmp") at /git/10.0/sql/sql_base.cc:1882
#13 0x00000000006430be in select_create::abort_result_set (this=0x7fbe5c5a2c38) at /git/10.0/sql/sql_insert.cc:4378
#14 0x000000000068fe15 in handle_select (thd=0x7fbe603fa070, lex=0x7fbe603fd940, result=0x7fbe5c5a2c38, setup_tables_done_option=0) at /git/10.0/sql/sql_select.cc:383
#15 0x0000000000659b7b in mysql_execute_command (thd=0x7fbe603fa070) at /git/10.0/sql/sql_parse.cc:3012
#16 0x0000000000663bc8 in mysql_parse (thd=0x7fbe603fa070, rawbuf=0x7fbe5c5a2088 "CREATE or replace TABLE tmp AS SELECT 1654509913105235968 - '1994-09-26' FROM dual", length=82, parser_state=0x7fbe67d4d670) at /git/10.0/sql/sql_parse.cc:6637
#17 0x0000000000655a92 in dispatch_command (command=COM_QUERY, thd=0x7fbe603fa070, packet=0x7fbe617e5071 "CREATE or replace TABLE tmp AS SELECT 1654509913105235968 - '1994-09-26' FROM dual", packet_length=82) at /git/10.0/sql/sql_parse.cc:1300
#18 0x0000000000654d05 in do_command (thd=0x7fbe603fa070) at /git/10.0/sql/sql_parse.cc:1003
#19 0x000000000078ab06 in do_handle_one_connection (thd_arg=0x7fbe603fa070) at /git/10.0/sql/sql_connect.cc:1377
#20 0x000000000078a854 in handle_one_connection (arg=0x7fbe603fa070) at /git/10.0/sql/sql_connect.cc:1292
#21 0x0000000000e49508 in pfs_spawn_thread (arg=0x7fbe6037c0f0) at /git/10.0/storage/perfschema/pfs.cc:1861
#22 0x00007fbe66ef76ba in start_thread (arg=0x7fbe67d4e700) at pthread_create.c:333
#23 0x00007fbe665a241d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
duplicates
MDEV-12553
[Draft] Server crashes in PlugCleanup / PopUser / ha_connect::~ha_connect
Closed
{"report":{"fcp":1095.5,"ttfb":276,"pageVisibility":"visible","entityId":66700,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"f1896c04-7029-43db-a9dd-f7f9497a8bec","navigationType":0,"readyForUser":1168,"redirectCount":0,"resourceLoadedEnd":825.8999999761581,"resourceLoadedStart":282.60000002384186,"resourceTiming":[{"duration":154.79999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":282.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":282.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":437.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":156.5,"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":282.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":282.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":439.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":409.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":283.10000002384186,"connectEnd":439.80000001192093,"connectStart":439.80000001192093,"domainLookupEnd":439.80000001192093,"domainLookupStart":439.80000001192093,"fetchStart":283.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":440.10000002384186,"responseEnd":692.3999999761581,"responseStart":453.5,"secureConnectionStart":439.80000001192093},{"duration":542.5999999642372,"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":283.30000001192093,"connectEnd":283.30000001192093,"connectStart":283.30000001192093,"domainLookupEnd":283.30000001192093,"domainLookupStart":283.30000001192093,"fetchStart":283.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":440.80000001192093,"responseEnd":825.8999999761581,"responseStart":463.39999997615814,"secureConnectionStart":283.30000001192093},{"duration":187,"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":283.39999997615814,"connectEnd":283.39999997615814,"connectStart":283.39999997615814,"domainLookupEnd":283.39999997615814,"domainLookupStart":283.39999997615814,"fetchStart":283.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":441.69999998807907,"responseEnd":470.39999997615814,"responseStart":465,"secureConnectionStart":283.39999997615814},{"duration":187.19999998807907,"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":283.60000002384186,"connectEnd":283.60000002384186,"connectStart":283.60000002384186,"domainLookupEnd":283.60000002384186,"domainLookupStart":283.60000002384186,"fetchStart":283.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":442.39999997615814,"responseEnd":470.80000001192093,"responseStart":466.89999997615814,"secureConnectionStart":283.60000002384186},{"duration":182.89999997615814,"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":283.80000001192093,"connectEnd":283.80000001192093,"connectStart":283.80000001192093,"domainLookupEnd":283.80000001192093,"domainLookupStart":283.80000001192093,"fetchStart":283.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":443.89999997615814,"responseEnd":466.69999998807907,"responseStart":461.89999997615814,"secureConnectionStart":283.80000001192093},{"duration":158.60000002384186,"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":283.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":283.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":442.5,"responseStart":0,"secureConnectionStart":0},{"duration":187.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":284.10000002384186,"connectEnd":284.10000002384186,"connectStart":284.10000002384186,"domainLookupEnd":284.10000002384186,"domainLookupStart":284.10000002384186,"fetchStart":284.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":444.60000002384186,"responseEnd":471.30000001192093,"responseStart":468.39999997615814,"secureConnectionStart":284.10000002384186},{"duration":160.10000002384186,"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":284.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":444.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":189.5,"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":284.39999997615814,"connectEnd":284.39999997615814,"connectStart":284.39999997615814,"domainLookupEnd":284.39999997615814,"domainLookupStart":284.39999997615814,"fetchStart":284.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":449.39999997615814,"responseEnd":473.89999997615814,"responseStart":471.39999997615814,"secureConnectionStart":284.39999997615814},{"duration":521.1999999880791,"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":290.19999998807907,"connectEnd":290.19999998807907,"connectStart":290.19999998807907,"domainLookupEnd":290.19999998807907,"domainLookupStart":290.19999998807907,"fetchStart":290.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":537.5,"responseEnd":811.3999999761581,"responseStart":802.1000000238419,"secureConnectionStart":290.19999998807907},{"duration":521.8000000119209,"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":290.30000001192093,"connectEnd":290.30000001192093,"connectStart":290.30000001192093,"domainLookupEnd":290.30000001192093,"domainLookupStart":290.30000001192093,"fetchStart":290.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":622.1999999880791,"responseEnd":812.1000000238419,"responseStart":804.3000000119209,"secureConnectionStart":290.30000001192093},{"duration":234,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":853.8999999761581,"connectEnd":853.8999999761581,"connectStart":853.8999999761581,"domainLookupEnd":853.8999999761581,"domainLookupStart":853.8999999761581,"fetchStart":853.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1057.8999999761581,"responseEnd":1087.8999999761581,"responseStart":1087.1000000238419,"secureConnectionStart":853.8999999761581}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":107,"responseStart":276,"responseEnd":289,"domLoading":280,"domInteractive":1279,"domContentLoadedEventStart":1279,"domContentLoadedEventEnd":1325,"domComplete":1928,"loadEventStart":1928,"loadEventEnd":1928,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1225.199999988079},{"name":"bigPipe.sidebar-id.end","time":1225.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.start","time":1226},{"name":"bigPipe.activity-panel-pipe-id.end","time":1227},{"name":"activityTabFullyLoaded","time":1341.699999988079}],"measures":[],"correlationId":"93625040685504","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":106,"dbReadsTimeInMs":26,"dbConnsTimeInMs":35,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}