CREATE TABLE t1 (f1 INT);
|
INSERT INTO t1 VALUES (1),(2);
|
|
CREATE TABLE t2 (f2 INT);
|
INSERT INTO t2 VALUES (3),(4);
|
|
CREATE TABLE t3 (f3 INT);
|
INSERT INTO t3 VALUES (5),(6);
|
|
PREPARE stmt FROM '
|
UPDATE t1, t2
|
SET f1 = 5
|
WHERE 8 IN ( SELECT MIN(f3) FROM t3 )
|
';
|
|
EXECUTE stmt;
|
EXECUTE stmt;
|
Stack trace from 10.0 commit 50d98e9c
|
10.0/sql/sql_acl.cc:10717: static const ACL_internal_schema_access* ACL_internal_schema_registry::lookup(const char*): Assertion `name != __null' failed.
|
150409 20:14:21 [ERROR] mysqld got signal 6 ;
|
|
#6 0x00007f5990d3b311 in *__GI___assert_fail (assertion=0xef24c4 "name != __null", file=<optimized out>, line=10717, function=0xef3aa0 "static const ACL_internal_schema_access* ACL_internal_schema_registry::lookup(const char*)") at assert.c:81
|
#7 0x000000000060fe2a in ACL_internal_schema_registry::lookup (name=0x0) at 10.0/sql/sql_acl.cc:10717
|
#8 0x000000000060fee0 in get_cached_schema_access (grant_internal_info=0x7f59891f4358, schema_name=0x0) at 10.0/sql/sql_acl.cc:10744
|
#9 0x000000000060ff63 in get_cached_table_access (grant_internal_info=0x7f59891f4358, schema_name=0x0, table_name=0x0) at 10.0/sql/sql_acl.cc:10767
|
#10 0x0000000000605179 in check_grant (thd=0x7f598bb2f070, want_access=4, tables=0x7f59891f4088, any_combination_will_do=false, number=0, no_errors=true) at 10.0/sql/sql_acl.cc:6680
|
#11 0x00000000006898e2 in multi_update_precheck (thd=0x7f598bb2f070, tables=0x7f59893475c0) at 10.0/sql/sql_parse.cc:7746
|
#12 0x000000000067e437 in mysql_execute_command (thd=0x7f598bb2f070) at 10.0/sql/sql_parse.cc:3313
|
#13 0x000000000069f51e in Prepared_statement::execute (this=0x7f5989291470, expanded_query=0x7f5992f43ae0, open_cursor=false) at 10.0/sql/sql_prepare.cc:3971
|
#14 0x000000000069e5f9 in Prepared_statement::execute_loop (this=0x7f5989291470, expanded_query=0x7f5992f43ae0, open_cursor=false, packet=0x0, packet_end=0x0) at 10.0/sql/sql_prepare.cc:3626
|
#15 0x000000000069c8fb in mysql_sql_stmt_execute (thd=0x7f598bb2f070) at 10.0/sql/sql_prepare.cc:2777
|
#16 0x000000000067c68c in mysql_execute_command (thd=0x7f598bb2f070) at 10.0/sql/sql_parse.cc:2560
|
#17 0x0000000000686e85 in mysql_parse (thd=0x7f598bb2f070, rawbuf=0x7f59890e0088 "EXECUTE stmt", length=12, parser_state=0x7f5992f44600) at 10.0/sql/sql_parse.cc:6517
|
#18 0x00000000006798b1 in dispatch_command (command=COM_QUERY, thd=0x7f598bb2f070, packet=0x7f598afeb071 "EXECUTE stmt", packet_length=12) at 10.0/sql/sql_parse.cc:1300
|
#19 0x0000000000678c47 in do_command (thd=0x7f598bb2f070) at 10.0/sql/sql_parse.cc:996
|
#20 0x0000000000796457 in do_handle_one_connection (thd_arg=0x7f598bb2f070) at 10.0/sql/sql_connect.cc:1375
|
#21 0x00000000007961aa in handle_one_connection (arg=0x7f598bb2f070) at 10.0/sql/sql_connect.cc:1289
|
#22 0x0000000000cd391e in pfs_spawn_thread (arg=0x7f598af6ce70) at 10.0/storage/perfschema/pfs.cc:1860
|
#23 0x00007f5992b35b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#24 0x00007f5990deb95d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
The problem appeared in 10.0 tree with this commit:
commit 775528ada3c2cc3a2a7ebafadebbcf44530aab50 0f8b194146b50afe442682c5a14a8a179e28f3b8
|
Author: Sergei Petrunia <psergey@askmonty.org>
|
Date: Fri Feb 20 03:17:46 2015 +0300
|
|
MDEV-7220: Materialization strategy is not used for REPLACE ... SELECT
|
|
Enable subquery materialization for non-SELECT queries with a SELECT part
|
- relates to
-
MDEV-8309
Stored procedure crashes server
-
-
Closed
Transition |
Time In Source Status |
Execution Times |
Open |
|
Closed |
|
115d 17h 8m
|
1
|
{"report":{"fcp":1327.6000001430511,"ttfb":254.29999995231628,"pageVisibility":"visible","entityId":50827,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"1fdff0ce-36e2-4fa4-bf7a-2c39f67d1387","navigationType":0,"readyForUser":1431,"redirectCount":0,"resourceLoadedEnd":2325.100000143051,"resourceLoadedStart":259.90000009536743,"resourceTiming":[{"duration":474.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":259.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":259.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":734.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":474.7000000476837,"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":260.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":260.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":734.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":496.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":260.40000009536743,"connectEnd":260.40000009536743,"connectStart":260.40000009536743,"domainLookupEnd":260.40000009536743,"domainLookupStart":260.40000009536743,"fetchStart":260.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":260.40000009536743,"responseEnd":756.5,"responseStart":756.5,"secureConnectionStart":260.40000009536743},{"duration":529.3999998569489,"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":260.60000014305115,"connectEnd":260.60000014305115,"connectStart":260.60000014305115,"domainLookupEnd":260.60000014305115,"domainLookupStart":260.60000014305115,"fetchStart":260.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":260.60000014305115,"responseEnd":790,"responseStart":790,"secureConnectionStart":260.60000014305115},{"duration":533.9000000953674,"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":260.7000000476837,"connectEnd":260.7000000476837,"connectStart":260.7000000476837,"domainLookupEnd":260.7000000476837,"domainLookupStart":260.7000000476837,"fetchStart":260.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":260.7000000476837,"responseEnd":794.6000001430511,"responseStart":794.6000001430511,"secureConnectionStart":260.7000000476837},{"duration":534.2000000476837,"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":260.90000009536743,"connectEnd":260.90000009536743,"connectStart":260.90000009536743,"domainLookupEnd":260.90000009536743,"domainLookupStart":260.90000009536743,"fetchStart":260.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":260.90000009536743,"responseEnd":795.1000001430511,"responseStart":795.1000001430511,"secureConnectionStart":260.90000009536743},{"duration":534.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":261.2000000476837,"connectEnd":261.2000000476837,"connectStart":261.2000000476837,"domainLookupEnd":261.2000000476837,"domainLookupStart":261.2000000476837,"fetchStart":261.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":261.2000000476837,"responseEnd":795.7000000476837,"responseStart":795.7000000476837,"secureConnectionStart":261.2000000476837},{"duration":679.8000001907349,"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":261.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":941.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":534.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":261.5,"connectEnd":261.5,"connectStart":261.5,"domainLookupEnd":261.5,"domainLookupStart":261.5,"fetchStart":261.5,"redirectEnd":0,"redirectStart":0,"requestStart":261.5,"responseEnd":796.2000000476837,"responseStart":796.2000000476837,"secureConnectionStart":261.5},{"duration":680.0999999046326,"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":261.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":941.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":534.9000000953674,"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":261.7999999523163,"connectEnd":261.7999999523163,"connectStart":261.7999999523163,"domainLookupEnd":261.7999999523163,"domainLookupStart":261.7999999523163,"fetchStart":261.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":261.7999999523163,"responseEnd":796.7000000476837,"responseStart":796.7000000476837,"secureConnectionStart":261.7999999523163},{"duration":927.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":272.7000000476837,"connectEnd":272.7000000476837,"connectStart":272.7000000476837,"domainLookupEnd":272.7000000476837,"domainLookupStart":272.7000000476837,"fetchStart":272.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":272.7000000476837,"responseEnd":1199.7999999523163,"responseStart":1199.7999999523163,"secureConnectionStart":272.7000000476837},{"duration":2034.9000000953674,"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":272.7000000476837,"connectEnd":272.7000000476837,"connectStart":272.7000000476837,"domainLookupEnd":272.7000000476837,"domainLookupStart":272.7000000476837,"fetchStart":272.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":272.7000000476837,"responseEnd":2307.600000143051,"responseStart":2307.600000143051,"secureConnectionStart":272.7000000476837},{"duration":273.2999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":954.1000001430511,"connectEnd":954.1000001430511,"connectStart":954.1000001430511,"domainLookupEnd":954.1000001430511,"domainLookupStart":954.1000001430511,"fetchStart":954.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":954.1000001430511,"responseEnd":1227.4000000953674,"responseStart":1227.4000000953674,"secureConnectionStart":954.1000001430511},{"duration":1093.1000001430511,"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,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1232,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2325.100000143051,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":80,"responseStart":254,"responseEnd":271,"domLoading":258,"domInteractive":2334,"domContentLoadedEventStart":2334,"domContentLoadedEventEnd":2377,"domComplete":3119,"loadEventStart":3119,"loadEventEnd":3119,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2309.600000143051},{"name":"bigPipe.sidebar-id.end","time":2310.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":2310.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":2311.600000143051},{"name":"activityTabFullyLoaded","time":2392.7999999523163}],"measures":[],"correlationId":"18079c17b24470","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":108,"dbReadsTimeInMs":15,"dbConnsTimeInMs":24,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}