-
Bug
-
-
Critical
-
Resolution:
Fixed
-
None
-
-
-
CREATE OR REPLACE TABLE t1 ( i serial ) AS SELECT * FROM (values(1),(2)) dt;
|
10.11 49cee4e21a8e3cc0eccff3a6f9
|
/git/10.11/sql/handler.cc:7058: int handler::ha_external_lock(THD*, int): Assertion `next_insert_id == 0' failed.
|
220923 13:18:30 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.11.0-MariaDB-debug-log
|
|
??:0(__assert_fail)[0x7f37bb1ec102]
|
sql/handler.cc:7060(handler::ha_external_lock(THD*, int))[0x555dd0ccd919]
|
sql/sql_insert.cc:4300(select_insert::prepare_eof())[0x555dd0326cd3]
|
sql/sql_insert.cc:5220(select_create::send_eof())[0x555dd033070d]
|
sql/sql_select.cc:21364(do_select(JOIN*, Procedure*))[0x555dd05609fe]
|
sql/sql_select.cc:4813(JOIN::exec_inner())[0x555dd04e9f9e]
|
sql/sql_select.cc:4592(JOIN::exec())[0x555dd04e74e0]
|
sql/sql_select.cc:5073(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x555dd04eb8d5]
|
sql/sql_select.cc:582(handle_select(THD*, LEX*, select_result*, unsigned long))[0x555dd04bbd85]
|
sql/sql_table.cc:12740(Sql_cmd_create_table_like::execute(THD*))[0x555dd06d67cd]
|
sql/sql_parse.cc:5997(mysql_execute_command(THD*, bool))[0x555dd03e2f4f]
|
sql/sql_parse.cc:8037(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x555dd03f02c2]
|
sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x555dd03c688e]
|
sql/sql_parse.cc:1407(do_command(THD*, bool))[0x555dd03c35ab]
|
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x555dd086a7cb]
|
sql/sql_connect.cc:1320(handle_one_connection)[0x555dd086a121]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x555dd151021f]
|
nptl/pthread_create.c:487(start_thread)[0x7f37bb6abfa3]
|
x86_64/clone.S:97(clone)[0x7f37bb2b4eff]
|
|
Query (0x6290000e6450): CREATE OR REPLACE TABLE t1 ( i serial ) AS SELECT * FROM (values(1),(2)) dt
|
|
- is caused by
-
MDEV-25292
Atomic CREATE OR REPLACE TABLE
-
-
Stalled
{"report":{"fcp":857.3999999761581,"ttfb":198.89999997615814,"pageVisibility":"visible","entityId":114913,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"c4cca080-44db-41a9-8953-61a31adafc2d","navigationType":0,"readyForUser":934.3999999761581,"redirectCount":0,"resourceLoadedEnd":779,"resourceLoadedStart":204,"resourceTiming":[{"duration":156.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":204,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":360.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":156.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":204.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":361,"responseStart":0,"secureConnectionStart":0},{"duration":165.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":204.5,"connectEnd":204.5,"connectStart":204.5,"domainLookupEnd":204.5,"domainLookupStart":204.5,"fetchStart":204.5,"redirectEnd":0,"redirectStart":0,"requestStart":204.5,"responseEnd":370,"responseStart":370,"secureConnectionStart":204.5},{"duration":236.10000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":204.69999998807907,"connectEnd":204.69999998807907,"connectStart":204.69999998807907,"domainLookupEnd":204.69999998807907,"domainLookupStart":204.69999998807907,"fetchStart":204.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":204.69999998807907,"responseEnd":440.80000001192093,"responseStart":440.80000001192093,"secureConnectionStart":204.69999998807907},{"duration":240.0999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":204.80000001192093,"connectEnd":204.80000001192093,"connectStart":204.80000001192093,"domainLookupEnd":204.80000001192093,"domainLookupStart":204.80000001192093,"fetchStart":204.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":204.80000001192093,"responseEnd":444.89999997615814,"responseStart":444.89999997615814,"secureConnectionStart":204.80000001192093},{"duration":240.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":205,"connectEnd":205,"connectStart":205,"domainLookupEnd":205,"domainLookupStart":205,"fetchStart":205,"redirectEnd":0,"redirectStart":0,"requestStart":205,"responseEnd":445.39999997615814,"responseStart":445.39999997615814,"secureConnectionStart":205},{"duration":240.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":205.19999998807907,"connectEnd":205.19999998807907,"connectStart":205.19999998807907,"domainLookupEnd":205.19999998807907,"domainLookupStart":205.19999998807907,"fetchStart":205.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":205.19999998807907,"responseEnd":445.69999998807907,"responseStart":445.69999998807907,"secureConnectionStart":205.19999998807907},{"duration":306,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":205.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":511.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":240.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":205.5,"connectEnd":205.5,"connectStart":205.5,"domainLookupEnd":205.5,"domainLookupStart":205.5,"fetchStart":205.5,"redirectEnd":0,"redirectStart":0,"requestStart":205.5,"responseEnd":446.19999998807907,"responseStart":446.19999998807907,"secureConnectionStart":205.5},{"duration":305.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":205.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":511.5999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":240.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":206,"connectEnd":206,"connectStart":206,"domainLookupEnd":206,"domainLookupStart":206,"fetchStart":206,"redirectEnd":0,"redirectStart":0,"requestStart":206,"responseEnd":446.69999998807907,"responseStart":446.69999998807907,"secureConnectionStart":206},{"duration":322.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":211.19999998807907,"connectEnd":211.19999998807907,"connectStart":211.19999998807907,"domainLookupEnd":211.19999998807907,"domainLookupStart":211.19999998807907,"fetchStart":211.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":211.19999998807907,"responseEnd":534,"responseStart":534,"secureConnectionStart":211.19999998807907},{"duration":347.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":211.30000001192093,"connectEnd":211.30000001192093,"connectStart":211.30000001192093,"domainLookupEnd":211.30000001192093,"domainLookupStart":211.30000001192093,"fetchStart":211.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":211.30000001192093,"responseEnd":559,"responseStart":559,"secureConnectionStart":211.30000001192093},{"duration":21.100000023841858,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":538.3999999761581,"connectEnd":538.3999999761581,"connectStart":538.3999999761581,"domainLookupEnd":538.3999999761581,"domainLookupStart":538.3999999761581,"fetchStart":538.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":538.3999999761581,"responseEnd":559.5,"responseStart":559.5,"secureConnectionStart":538.3999999761581},{"duration":216.19999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/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","startTime":562.8000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":562.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":779,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":38,"responseStart":199,"responseEnd":204,"domLoading":202,"domInteractive":987,"domContentLoadedEventStart":987,"domContentLoadedEventEnd":1028,"domComplete":1750,"loadEventStart":1750,"loadEventEnd":1752,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":968.6999999880791},{"name":"bigPipe.sidebar-id.end","time":969.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.start","time":969.5999999642372},{"name":"bigPipe.activity-panel-pipe-id.end","time":972.5},{"name":"activityTabFullyLoaded","time":1035.8999999761581}],"measures":[],"correlationId":"6f9a2780d0e646","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}