Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
N/A
Component/s:
None
--delimiter |
BEGIN NOT ATOMIC SELECT @@sql_mode; END |
--delimiter ;
#3 <signal handler called>
#4 __strlen_sse2 () at ../sysdeps/x86_64/multiarch/../strlen.S:32
#5 0x00007fb006f20c02 in String::append (this=0x7fb0069a0ce0, s=0x0) at sql/sql_string.cc:479
#6 0x00007fb006f58123 in set_to_string (thd=0x7fafff7ec070, result=0x7fb0069a0cd0, set=2779096485, lib=0x7fb007f2e7e0) at sql/strfunc.cc:362
#7 0x00007fb006fcdc2a in Sys_var_set::session_value_ptr (this=0x7fb00810ab20, thd=0x7fafff7ec070, base=0x7faffc4e8158) at sql/sys_vars.h:1290
#8 0x00007fb006dd6a22 in sys_var::value_ptr (this=0x7fb00810ab20, thd=0x7fafff7ec070, type=OPT_DEFAULT, base=0x7faffc4e8158) at sql/set_var.cc:250
#9 0x00007fb0070ef4f5 in Item_func_get_system_var::fix_length_and_dec (this=0x7faffc4e8088) at sql/item_func.cc:5854
#10 0x00007fb0070dc6c4 in Item_func::fix_fields (this=0x7faffc4e8088, thd=0x7fafff7ec070, ref=0x7faffc4e81b8) at sql/item_func.cc:229
#11 0x00007fb006e23dda in setup_fields (thd=0x7fafff7ec070, ref_pointer_array=0x7faffc4e82b8, fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7faffc4eb4e0, allow_sum_func=true) at sql/sql_base.cc:7790
#12 0x00007fb006eb1494 in JOIN::prepare (this=0x7faffc4eb1a8, rref_pointer_array=0x7faffc45c660, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7faffc45c3e8, unit_arg=0x7faffc45bd00) at sql/sql_select.cc:785
#13 0x00007fb006eba747 in mysql_select (thd=0x7fafff7ec070, rref_pointer_array=0x7faffc45c660, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x7faffc4eb188, unit=0x7faffc45bd00, select_lex=0x7faffc45c3e8) at sql/sql_select.cc:3298
#14 0x00007fb006eb076e in handle_select (thd=0x7fafff7ec070, lex=0x7faffc45bc38, result=0x7faffc4eb188, setup_tables_done_option=0) at sql/sql_select.cc:372
#15 0x00007fb006e835b1 in execute_sqlcom_select (thd=0x7fafff7ec070, all_tables=0x0) at sql/sql_parse.cc:5313
#16 0x00007fb006e7b55b in mysql_execute_command (thd=0x7fafff7ec070) at sql/sql_parse.cc:2599
#17 0x00007fb0071c3f78 in sp_instr_stmt::exec_core (this=0x7faffc4e81e0, thd=0x7fafff7ec070, nextp=0x7fb0069a25c0) at sql/sp_head.cc:3193
#18 0x00007fb0071c36d1 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7faffc4e8220, thd=0x7fafff7ec070, nextp=0x7fb0069a25c0, open_tables=false, instr=0x7faffc4e81e0) at sql/sp_head.cc:2963
#19 0x00007fb0071c3c8a in sp_instr_stmt::execute (this=0x7faffc4e81e0, thd=0x7fafff7ec070, nextp=0x7fb0069a25c0) at sql/sp_head.cc:3112
#20 0x00007fb0071bf764 in sp_head::execute (this=0x7faffc45b088, thd=0x7fafff7ec070, merge_da_on_success=true) at sql/sp_head.cc:1364
#21 0x00007fb0071c162a in sp_head::execute_procedure (this=0x7faffc45b088, thd=0x7fafff7ec070, args=0x7fafff7f0a28) at sql/sp_head.cc:2153
#22 0x00007fb006e7a992 in do_execute_sp (thd=0x7fafff7ec070, sp=0x7faffc45b088) at sql/sql_parse.cc:2213
#23 0x00007fb006e818ba in mysql_execute_command (thd=0x7fafff7ec070) at sql/sql_parse.cc:4740
#24 0x00007fb006e85ec6 in mysql_parse (thd=0x7fafff7ec070, rawbuf=0x7faffc456088 "BEGIN NOT ATOMIC SELECT @@sql_mode; END", length=39, parser_state=0x7fb0069a35e0) at sql/sql_parse.cc:6466
#25 0x00007fb006e7857b in dispatch_command (command=COM_QUERY, thd=0x7fafff7ec070, packet=0x7fb0003f9071 "BEGIN NOT ATOMIC SELECT @@sql_mode; END ", packet_length=40) at sql/sql_parse.cc:1310
#26 0x00007fb006e778c0 in do_command (thd=0x7fafff7ec070) at sql/sql_parse.cc:1007
#27 0x00007fb006fa083d in do_handle_one_connection (thd_arg=0x7fafff7ec070) at sql/sql_connect.cc:1379
#28 0x00007fb006fa0590 in handle_one_connection (arg=0x7fafff7ec070) at sql/sql_connect.cc:1293
#29 0x00007fb007504ba6 in pfs_spawn_thread (arg=0x7faffdaae970) at storage/perfschema/pfs.cc:1860
#30 0x00007fb00658fb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
#31 0x00007fb00486720d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
Stack trace from:
commit 6502f42f679e605fcdbd6c8b49d2813f553001b0
Author: Sergei Golubchik <serg@mariadb.org>
Date: Mon Aug 18 14:28:48 2014 +0200
relates to
MDEV-5317
Compound statement / anonymous blocks
Closed
{"report":{"fcp":861.5999999046326,"ttfb":300.19999980926514,"pageVisibility":"visible","entityId":43511,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":1,"journeyId":"05f288c2-f11b-4e9b-b8b6-09391c2dfbf0","navigationType":0,"readyForUser":956.8000001907349,"redirectCount":0,"resourceLoadedEnd":793,"resourceLoadedStart":314.40000009536743,"resourceTiming":[{"duration":37.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":314.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":352.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":37.59999990463257,"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":314.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":352.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":81.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":315.5,"connectEnd":315.5,"connectStart":315.5,"domainLookupEnd":315.5,"domainLookupStart":315.5,"fetchStart":315.5,"redirectEnd":0,"redirectStart":0,"requestStart":355.5,"responseEnd":397.19999980926514,"responseStart":370.40000009536743,"secureConnectionStart":315.5},{"duration":107.90000009536743,"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":316.40000009536743,"connectEnd":316.40000009536743,"connectStart":316.40000009536743,"domainLookupEnd":316.40000009536743,"domainLookupStart":316.40000009536743,"fetchStart":316.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":356.09999990463257,"responseEnd":424.30000019073486,"responseStart":373,"secureConnectionStart":316.40000009536743},{"duration":54.80000019073486,"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":318.09999990463257,"connectEnd":318.09999990463257,"connectStart":318.09999990463257,"domainLookupEnd":318.09999990463257,"domainLookupStart":318.09999990463257,"fetchStart":318.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":356.40000009536743,"responseEnd":372.90000009536743,"responseStart":372.30000019073486,"secureConnectionStart":318.09999990463257},{"duration":56.09999990463257,"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":318.30000019073486,"connectEnd":318.30000019073486,"connectStart":318.30000019073486,"domainLookupEnd":318.30000019073486,"domainLookupStart":318.30000019073486,"fetchStart":318.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":356.40000009536743,"responseEnd":374.40000009536743,"responseStart":373.80000019073486,"secureConnectionStart":318.30000019073486},{"duration":51.90000009536743,"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":318.40000009536743,"connectEnd":318.40000009536743,"connectStart":318.40000009536743,"domainLookupEnd":318.40000009536743,"domainLookupStart":318.40000009536743,"fetchStart":318.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":356.5,"responseEnd":370.30000019073486,"responseStart":369.69999980926514,"secureConnectionStart":318.40000009536743},{"duration":36,"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":318.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":318.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":354.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":58.39999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":318.80000019073486,"connectEnd":363.40000009536743,"connectStart":363.40000009536743,"domainLookupEnd":363.40000009536743,"domainLookupStart":363.40000009536743,"fetchStart":318.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":365.30000019073486,"responseEnd":377.19999980926514,"responseStart":375.80000019073486,"secureConnectionStart":363.40000009536743},{"duration":44.30000019073486,"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":319,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":319,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":363.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":61.30000019073486,"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":319.09999990463257,"connectEnd":319.09999990463257,"connectStart":319.09999990463257,"domainLookupEnd":319.09999990463257,"domainLookupStart":319.09999990463257,"fetchStart":319.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":365.59999990463257,"responseEnd":380.40000009536743,"responseStart":377.5,"secureConnectionStart":319.09999990463257},{"duration":461.2999997138977,"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":326.30000019073486,"connectEnd":326.30000019073486,"connectStart":326.30000019073486,"domainLookupEnd":326.30000019073486,"domainLookupStart":326.30000019073486,"fetchStart":326.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":455.90000009536743,"responseEnd":787.5999999046326,"responseStart":780.5999999046326,"secureConnectionStart":326.30000019073486},{"duration":466.5,"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":326.5,"connectEnd":326.5,"connectStart":326.5,"domainLookupEnd":326.5,"domainLookupStart":326.5,"fetchStart":326.5,"redirectEnd":0,"redirectStart":0,"requestStart":664.6999998092651,"responseEnd":793,"responseStart":789.5999999046326,"secureConnectionStart":326.5},{"duration":233.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":605,"connectEnd":605,"connectStart":605,"domainLookupEnd":605,"domainLookupStart":605,"fetchStart":605,"redirectEnd":0,"redirectStart":0,"requestStart":804.8000001907349,"responseEnd":838.3000001907349,"responseStart":836.5999999046326,"secureConnectionStart":605},{"duration":205.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":851.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":851.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1056.5999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":76,"domainLookupEnd":124,"connectStart":124,"connectEnd":142,"secureConnectionStart":132,"requestStart":143,"responseStart":300,"responseEnd":326,"domLoading":304,"domInteractive":1015,"domContentLoadedEventStart":1015,"domContentLoadedEventEnd":1053,"domComplete":1813,"loadEventStart":1813,"loadEventEnd":1813,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":994.6999998092651},{"name":"bigPipe.sidebar-id.end","time":995.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":995.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":996.5999999046326},{"name":"activityTabFullyLoaded","time":1071.8000001907349}],"measures":[],"correlationId":"b5455e030559b1","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Same happens with SHOW VARIABLES instead of SELECT ...