Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.4(EOL) , 10.5 , 10.6 , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL) , 11.1(EOL) , 11.2(EOL) , 11.3(EOL)
CREATE TABLE t (c INT ,c2 POINT NOT NULL ,SPATIAL INDEX (c2)) ENGINE=Aria;
INSERT INTO t VALUES (7,POINT(7,7));
INSERT INTO t SELECT * FROM t;
UPDATE t SET c=0;
When executed in a standard master/slave setup will, sporadically, crash with this stack on the slave only:
11.3.0 7ba9c7fb84b5f28e4736656b57d9508b70ca6369 (Debug)
Core was generated by `/test/MD020923-mariadb-11.3.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --gti'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x000055c1d099f084 in maria_rtree_get_next (
info=info@entry=0x152614022f38, keynr=keynr@entry=0,
key_length=<optimized out>)
at /test/git-bisect/11.3_dbg/storage/maria/ma_rt_index.c:492
[Current thread is 1 (Thread 0x15276537d640 (LWP 1273835))]
(gdb) bt
#0 0x000055c1d099f084 in maria_rtree_get_next (info=info@entry=0x152614022f38, keynr=keynr@entry=0, key_length=<optimized out>) at /test/git-bisect/11.3_dbg/storage/maria/ma_rt_index.c:492
#1 0x000055c1d0964309 in maria_rnext (info=0x152614022f38, buf=0x15261401a5f8 "\376", inx=0) at /test/git-bisect/11.3_dbg/storage/maria/ma_rnext.c:91
#2 0x000055c1d09319a6 in ha_maria::index_next (this=0x15261401aa10, buf=0x15261401a5f8 "\376") at /test/git-bisect/11.3_dbg/storage/maria/ha_maria.cc:2566
#3 0x000055c1d0733139 in handler::ha_index_next (this=0x15261401aa10, buf=0x15261401a5f8 "\376") at /test/git-bisect/11.3_dbg/sql/handler.cc:3716
#4 0x000055c1d08ac756 in Rows_log_event::find_row (this=this@entry=0x152718066438, rgi=rgi@entry=0x152718064ca0) at /test/git-bisect/11.3_dbg/sql/log_event_server.cc:7629
#5 0x000055c1d08ad060 in Update_rows_log_event::do_exec_row (this=0x152718066438, rgi=0x152718064ca0) at /test/git-bisect/11.3_dbg/sql/log_event_server.cc:7936
#6 0x000055c1d08a022b in Rows_log_event::do_apply_event (this=0x152718066438, rgi=0x152718064ca0) at /test/git-bisect/11.3_dbg/sql/log_event_server.cc:5129
#7 0x000055c1d089793e in Log_event::apply_event (this=this@entry=0x152718066438, rgi=rgi@entry=0x152718064ca0) at /test/git-bisect/11.3_dbg/sql/log_event.cc:3875
#8 0x000055c1d03707fa in apply_event_and_update_pos_apply (ev=ev@entry=0x152718066438, thd=thd@entry=0x15261c000f98, rgi=rgi@entry=0x152718064ca0, reason=reason@entry=0) at /test/git-bisect/11.3_dbg/sql/slave.cc:3877
#9 0x000055c1d037ac37 in apply_event_and_update_pos_for_parallel (ev=ev@entry=0x152718066438, thd=thd@entry=0x15261c000f98, rgi=rgi@entry=0x152718064ca0) at /test/git-bisect/11.3_dbg/sql/slave.cc:4074
#10 0x000055c1d06343e4 in rpt_handle_event (qev=qev@entry=0x1527180665a8, rpt=rpt@entry=0x152718026ac0) at /test/git-bisect/11.3_dbg/sql/rpl_parallel.cc:61
#11 0x000055c1d0638dd7 in handle_rpl_parallel_thread (arg=<optimized out>) at /test/git-bisect/11.3_dbg/sql/rpl_parallel.cc:1429
#12 0x00001527b0e94b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#13 0x00001527b0f26a00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
Issue confirmed/at least present in:
11.3.0 7ba9c7fb84b5f28e4736656b57d9508b70ca6369 (Debug)
11.2.0 e81fa345020ec6a067583db6a7019d6404b26f93 (Optimized)
10.10.6 b1b47264d2ef1fa80b90f308e81c49d9a1011d56 (Optimized)
10.9.8 941af1fa581a799e59ddc3afcae965852aeceb00 (Debug)
10.6.15 d794d3484b2cbd069d68dc8d017a6f18e9a3090e (Debug)
10.5.22 4235c133ae7dfe57c627699b3e4ea2513ff48979 (Optimized)
10.4.31 ab10a675acb8198d4c772b807b81b50f97480d28 (Optimized)
Assumed present in 10.4-11.3 (and possibly before) in all dbg+opt builds.
It is unclear if the main issue is Replication, Aria, or GIS. However as the first frame is maria_rtree_get_next it seems to be most likely Aria. Assigning as such. Feel free to reassign as needed.
There are no comments yet on this issue.
{"report":{"fcp":1434.9000000059605,"ttfb":604.1000000089407,"pageVisibility":"visible","entityId":124939,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"bec9a9fb-ea6c-4871-b97d-3403b4ba9379","navigationType":0,"readyForUser":1535.300000011921,"redirectCount":0,"resourceLoadedEnd":1141.5,"resourceLoadedStart":614.6000000089407,"resourceTiming":[{"duration":156,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":614.6000000089407,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":614.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":770.6000000089407,"responseStart":0,"secureConnectionStart":0},{"duration":156.40000000596046,"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":614.9000000059605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":614.9000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":771.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":385.09999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":615.1000000089407,"connectEnd":774.4000000059605,"connectStart":774.4000000059605,"domainLookupEnd":774.4000000059605,"domainLookupStart":774.4000000059605,"fetchStart":615.1000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":776.9000000059605,"responseEnd":1000.2000000029802,"responseStart":796.3000000119209,"secureConnectionStart":774.4000000059605},{"duration":526.1999999880791,"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":615.3000000119209,"connectEnd":615.3000000119209,"connectStart":615.3000000119209,"domainLookupEnd":615.3000000119209,"domainLookupStart":615.3000000119209,"fetchStart":615.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":777,"responseEnd":1141.5,"responseStart":798.5,"secureConnectionStart":615.3000000119209},{"duration":191.5,"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":615.5,"connectEnd":615.5,"connectStart":615.5,"domainLookupEnd":615.5,"domainLookupStart":615.5,"fetchStart":615.5,"redirectEnd":0,"redirectStart":0,"requestStart":777.7000000029802,"responseEnd":807,"responseStart":803.5,"secureConnectionStart":615.5},{"duration":189.70000000298023,"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":615.7000000029802,"connectEnd":615.7000000029802,"connectStart":615.7000000029802,"domainLookupEnd":615.7000000029802,"domainLookupStart":615.7000000029802,"fetchStart":615.7000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":777.9000000059605,"responseEnd":805.4000000059605,"responseStart":802.9000000059605,"secureConnectionStart":615.7000000029802},{"duration":189.29999999701977,"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":615.9000000059605,"connectEnd":615.9000000059605,"connectStart":615.9000000059605,"domainLookupEnd":615.9000000059605,"domainLookupStart":615.9000000059605,"fetchStart":615.9000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":778.4000000059605,"responseEnd":805.2000000029802,"responseStart":801.9000000059605,"secureConnectionStart":615.9000000059605},{"duration":160.80000001192093,"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":616,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":616,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":776.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":197.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":616.3000000119209,"connectEnd":616.3000000119209,"connectStart":616.3000000119209,"domainLookupEnd":616.3000000119209,"domainLookupStart":616.3000000119209,"fetchStart":616.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":782.4000000059605,"responseEnd":814,"responseStart":810.7000000029802,"secureConnectionStart":616.3000000119209},{"duration":161.70000000298023,"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":616.4000000059605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":616.4000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":778.1000000089407,"responseStart":0,"secureConnectionStart":0},{"duration":212.40000000596046,"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":616.7000000029802,"connectEnd":616.7000000029802,"connectStart":616.7000000029802,"domainLookupEnd":616.7000000029802,"domainLookupStart":616.7000000029802,"fetchStart":616.7000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":782.6000000089407,"responseEnd":829.1000000089407,"responseStart":812.3000000119209,"secureConnectionStart":616.7000000029802},{"duration":471,"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":619.6000000089407,"connectEnd":619.6000000089407,"connectStart":619.6000000089407,"domainLookupEnd":619.6000000089407,"domainLookupStart":619.6000000089407,"fetchStart":619.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":942.9000000059605,"responseEnd":1090.6000000089407,"responseStart":1085.6000000089407,"secureConnectionStart":619.6000000089407},{"duration":477,"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":619.7000000029802,"connectEnd":619.7000000029802,"connectStart":619.7000000029802,"domainLookupEnd":619.7000000029802,"domainLookupStart":619.7000000029802,"fetchStart":619.7000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":1083.5,"responseEnd":1096.7000000029802,"responseStart":1095.800000011921,"secureConnectionStart":619.7000000029802},{"duration":191,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1129.300000011921,"connectEnd":1129.300000011921,"connectStart":1129.300000011921,"domainLookupEnd":1129.300000011921,"domainLookupStart":1129.300000011921,"fetchStart":1129.300000011921,"redirectEnd":0,"redirectStart":0,"requestStart":1280,"responseEnd":1320.300000011921,"responseStart":1317.800000011921,"secureConnectionStart":1129.300000011921}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":419,"responseStart":604,"responseEnd":615,"domLoading":609,"domInteractive":1631,"domContentLoadedEventStart":1631,"domContentLoadedEventEnd":1678,"domComplete":2400,"loadEventStart":2400,"loadEventEnd":2400,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1614.6000000089407},{"name":"bigPipe.sidebar-id.end","time":1615.4000000059605},{"name":"bigPipe.activity-panel-pipe-id.start","time":1615.6000000089407},{"name":"bigPipe.activity-panel-pipe-id.end","time":1616.1000000089407},{"name":"activityTabFullyLoaded","time":1689.9000000059605}],"measures":[],"correlationId":"7f428ba0263591","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":109,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}