Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
bzr version-info
revision-id: igor@askmonty.org-20130829175612-acvqr7uadpa7kylp
revno: 3686
branch-nick: 5.3
Also reproducible on current 5.5 revno 3864. It looks like both already have the fix for MDEV-4944 .
#3 <signal handler called>
#4 0x00000000005de5c2 in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field (this=0x7f3bc8546120) at item_cmpfunc.h:1857
#5 0x00000000005d9e20 in Item_equal::contains (this=0x7f3bbc03a298, field=0x7f3bbc02e1f0) at item_cmpfunc.cc:5566
#6 0x00000000005884df in Item_field::find_item_equal (this=0x7f3bbc019da0, cond_equal=0x7f3bbc01a950) at item.cc:4882
#7 0x00000000007246c5 in eliminate_item_equal (cond=0x0, upper_levels=0x7f3bbc01a950, item_equal=0x7f3bbc03a4a0) at sql_select.cc:11865
#8 0x0000000000725039 in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f3bbc03a4a0, cond_equal=0x7f3bbc01a950, table_join_idx=0x7f3bbc03acd8) at sql_select.cc:12156
#9 0x0000000000724d20 in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f3bbc01a3c8, cond_equal=0x7f3bbc01ad68, table_join_idx=0x7f3bbc03acd8) at sql_select.cc:12083
#10 0x0000000000724d20 in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f3bbc01ac78, cond_equal=0x7f3bbc01ad68, table_join_idx=0x7f3bbc03acd8) at sql_select.cc:12083
#11 0x0000000000708a4e in JOIN::optimize (this=0x7f3bbc038f90) at sql_select.cc:1246
#12 0x000000000070ef27 in mysql_select (thd=0x39378c8, rref_pointer_array=0x393a5b8, tables=0x7f3bbc0191b8, wild_num=1, fields=..., conds=0x7f3bbc01ac78, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x7f3bbc01ae50, unit=0x3939e58, select_lex=0x393a360) at sql_select.cc:2985
#13 0x00000000007059d9 in handle_select (thd=0x39378c8, lex=0x3939db8, result=0x7f3bbc01ae50, setup_tables_done_option=0) at sql_select.cc:288
#14 0x0000000000691cb2 in execute_sqlcom_select (thd=0x39378c8, all_tables=0x7f3bbc0191b8) at sql_parse.cc:5172
#15 0x0000000000688a7a in mysql_execute_command (thd=0x39378c8) at sql_parse.cc:2305
#16 0x000000000069473c in mysql_parse (thd=0x39378c8, rawbuf=0x7f3bbc018f40 "SELECT * FROM t1, t2 WHERE a1 = pk2 AND ( ( b1 = 6 OR a2 > 4 ) AND pk2 = a2 OR pk1 IS NULL )", length=92, found_semicolon=0x7f3bc85477e0) at sql_parse.cc:6173
#17 0x0000000000686197 in dispatch_command (command=COM_QUERY, thd=0x39378c8, packet=0x39b1b29 "SELECT * FROM t1, t2 WHERE a1 = pk2 AND ( ( b1 = 6 OR a2 > 4 ) AND pk2 = a2 OR pk1 IS NULL )", packet_length=92) at sql_parse.cc:1243
#18 0x0000000000685408 in do_command (thd=0x39378c8) at sql_parse.cc:923
#19 0x00000000006822a2 in handle_one_connection (arg=0x39378c8) at sql_connect.cc:1231
#20 0x00007f3bd5d6fe9a in start_thread (arg=0x7f3bc8548700) at pthread_create.c:308
#21 0x00007f3bd5298cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
CREATE TABLE t1 (pk1 INT , a1 INT , b1 INT , PRIMARY KEY (pk1)) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1,10,100), (2,20,200) ;
CREATE TABLE t2 (pk2 INT , a2 INT , PRIMARY KEY (pk2)) ENGINE=MyISAM;
INSERT INTO t2 VALUES (1,1);
SELECT * FROM t1, t2 WHERE a1 = pk2 AND ( ( b1 = 6 OR a2 > 4 ) AND pk2 = a2 OR pk1 IS NULL );
relates to
MDEV-16727
Server crashes in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field
Closed
{"report":{"fcp":834,"ttfb":155.80000007152557,"pageVisibility":"visible","entityId":25426,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d1c58bef-2bf8-4a78-8f5a-6c97e600d95f","navigationType":0,"readyForUser":913.8999999761581,"redirectCount":0,"resourceLoadedEnd":741.3000000715256,"resourceLoadedStart":160.80000007152557,"resourceTiming":[{"duration":6.599999904632568,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":160.80000007152557,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":160.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":167.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":6.799999952316284,"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":161.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":167.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":59.699999928474426,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":161.20000004768372,"connectEnd":161.20000004768372,"connectStart":161.20000004768372,"domainLookupEnd":161.20000004768372,"domainLookupStart":161.20000004768372,"fetchStart":161.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":161.20000004768372,"responseEnd":220.89999997615814,"responseStart":220.89999997615814,"secureConnectionStart":161.20000004768372},{"duration":312.2999999523163,"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":161.30000007152557,"connectEnd":161.30000007152557,"connectStart":161.30000007152557,"domainLookupEnd":161.30000007152557,"domainLookupStart":161.30000007152557,"fetchStart":161.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":161.30000007152557,"responseEnd":473.60000002384186,"responseStart":473.60000002384186,"secureConnectionStart":161.30000007152557},{"duration":315.7000000476837,"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":161.39999997615814,"connectEnd":161.39999997615814,"connectStart":161.39999997615814,"domainLookupEnd":161.39999997615814,"domainLookupStart":161.39999997615814,"fetchStart":161.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":161.39999997615814,"responseEnd":477.10000002384186,"responseStart":477.10000002384186,"secureConnectionStart":161.39999997615814},{"duration":316,"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":161.5,"connectEnd":161.5,"connectStart":161.5,"domainLookupEnd":161.5,"domainLookupStart":161.5,"fetchStart":161.5,"redirectEnd":0,"redirectStart":0,"requestStart":161.5,"responseEnd":477.5,"responseStart":477.5,"secureConnectionStart":161.5},{"duration":316.2999999523163,"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":161.60000002384186,"connectEnd":161.60000002384186,"connectStart":161.60000002384186,"domainLookupEnd":161.60000002384186,"domainLookupStart":161.60000002384186,"fetchStart":161.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":161.60000002384186,"responseEnd":477.89999997615814,"responseStart":477.89999997615814,"secureConnectionStart":161.60000002384186},{"duration":316.6999999284744,"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":161.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":478.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":316.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":161.80000007152557,"connectEnd":161.80000007152557,"connectStart":161.80000007152557,"domainLookupEnd":161.80000007152557,"domainLookupStart":161.80000007152557,"fetchStart":161.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":161.80000007152557,"responseEnd":478.3000000715256,"responseStart":478.3000000715256,"secureConnectionStart":161.80000007152557},{"duration":316.8000000715256,"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":161.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":478.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":316.7000000476837,"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":162.10000002384186,"connectEnd":162.10000002384186,"connectStart":162.10000002384186,"domainLookupEnd":162.10000002384186,"domainLookupStart":162.10000002384186,"fetchStart":162.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":162.10000002384186,"responseEnd":478.8000000715256,"responseStart":478.8000000715256,"secureConnectionStart":162.10000002384186},{"duration":543,"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":167.60000002384186,"connectEnd":167.60000002384186,"connectStart":167.60000002384186,"domainLookupEnd":167.60000002384186,"domainLookupStart":167.60000002384186,"fetchStart":167.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":167.60000002384186,"responseEnd":710.6000000238419,"responseStart":710.6000000238419,"secureConnectionStart":167.60000002384186},{"duration":569.3999999761581,"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":167.80000007152557,"connectEnd":167.80000007152557,"connectStart":167.80000007152557,"domainLookupEnd":167.80000007152557,"domainLookupStart":167.80000007152557,"fetchStart":167.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":167.80000007152557,"responseEnd":737.2000000476837,"responseStart":737.1000000238419,"secureConnectionStart":167.80000007152557},{"duration":337.2000000476837,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":373,"connectEnd":373,"connectStart":373,"domainLookupEnd":373,"domainLookupStart":373,"fetchStart":373,"redirectEnd":0,"redirectStart":0,"requestStart":373,"responseEnd":710.2000000476837,"responseStart":710.2000000476837,"secureConnectionStart":373},{"duration":3.4000000953674316,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":737.8999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":737.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":741.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":246.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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","startTime":738.6000000238419,"connectEnd":738.6000000238419,"connectStart":738.6000000238419,"domainLookupEnd":738.6000000238419,"domainLookupStart":738.6000000238419,"fetchStart":738.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":738.6000000238419,"responseEnd":984.8999999761581,"responseStart":984.8999999761581,"secureConnectionStart":738.6000000238419},{"duration":252.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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","startTime":739,"connectEnd":739,"connectStart":739,"domainLookupEnd":739,"domainLookupStart":739,"fetchStart":739,"redirectEnd":0,"redirectStart":0,"requestStart":739,"responseEnd":991.3999999761581,"responseStart":991.3999999761581,"secureConnectionStart":739},{"duration":165.30000007152557,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":827.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":827.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":992.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":154.39999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":850,"connectEnd":850,"connectStart":850,"domainLookupEnd":850,"domainLookupStart":850,"fetchStart":850,"redirectEnd":0,"redirectStart":0,"requestStart":850,"responseEnd":1004.3999999761581,"responseStart":1004.3999999761581,"secureConnectionStart":850}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":14,"responseStart":156,"responseEnd":167,"domLoading":159,"domInteractive":965,"domContentLoadedEventStart":965,"domContentLoadedEventEnd":1012,"domComplete":1164,"loadEventStart":1164,"loadEventEnd":1164,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":948.5},{"name":"bigPipe.sidebar-id.end","time":949.3000000715256},{"name":"bigPipe.activity-panel-pipe-id.start","time":949.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":950.3000000715256},{"name":"activityTabFullyLoaded","time":1026.1000000238419}],"measures":[],"correlationId":"692b5b2b21c336","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":83,"dbReadsTimeInMs":13,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
The fix was pushed into the 5.3 tree and merged into the 5.5 tree.