Type:
Bug
Resolution:
Fixed
Affects Version/s:
None
Fix Version/s:
None
Component/s:
None
Assertion:
mysqld: spatial.cc:2085: virtual uint Gis_geometry_collection::init_from_opresult(String*, const char*, uint32): Assertion `(0)' failed.
backtrace:
#8 0x00399d98 in __assert_fail () from /lib/libc.so.6
#9 0x08485ed7 in Gis_geometry_collection::init_from_opresult (this=0xae99ec4c, bin=0xae99f060, opres=0xae605128 "\003", n_shapes=3) at spatial.cc:2085
#10 0x08481c6d in Geometry::create_from_opresult (g_buf=0xae99ec4c, res=0xae99f060, rr=...) at spatial.cc:278
#11 0x0825bfc8 in Item_func_spatial_operation::val_str (this=0xae6132e8, str_value=0xae99f060) at item_geofunc.cc:1038
#12 0x081db831 in Item::send (this=0xae6132e8, protocol=0xaf6ac0c, buffer=0xae99f060) at item.cc:5905
#13 0x08288ef0 in select_send::send_data (this=0xae613680, items=...) at sql_class.cc:1919
#14 0x08325d40 in JOIN::exec (this=0xae620a60) at sql_select.cc:2069
#15 0x0832875c in mysql_select (thd=0xaf6a8e0, rref_pointer_array=0xaf6c3f8, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0,
having=0x0, proc_param=0x0, select_options=2147764736, result=0xae613680, unit=0xaf6bffc, select_lex=0xaf6c2d8) at sql_select.cc:2885
#16 0x08320627 in handle_select (thd=0xaf6a8e0, lex=0xaf6bfa0, result=0xae613680, setup_tables_done_option=0) at sql_select.cc:283
#17 0x082bbd57 in execute_sqlcom_select (thd=0xaf6a8e0, all_tables=0x0) at sql_parse.cc:5082
#18 0x082b2b5b in mysql_execute_command (thd=0xaf6a8e0) at sql_parse.cc:2227
#19 0x082be393 in mysql_parse (thd=0xaf6a8e0,
rawbuf=0xae6125e0 "SELECT ST_UNION (\nPolyFromText( ' POLYGON( ( 2 2 , 3 2 , 2 7 , 2 2 ) , ( 0 0 , 8 2 , 1 9 , 0 0 ) ) ' ) , \nExteriorRing( Envelope( MultiLineStringFromText( ' MULTILINESTRING( ( 3 4 , 5 3 ) , ( 3 0 , 0 "..., length=216, found_semicolon=0xae9a0228) at sql_parse.cc:6083
#20 0x082b07f7 in dispatch_command (command=COM_QUERY, thd=0xaf6a8e0, packet=0xafc53e9 "", packet_length=216) at sql_parse.cc:1206
#21 0x082afc7d in do_command (thd=0xaf6a8e0) at sql_parse.cc:904
#22 0x082accf8 in handle_one_connection (arg=0xaf6a8e0) at sql_connect.cc:1177
#23 0x00821919 in start_thread () from /lib/libpthread.so.0
#24 0x00453cce in clone () from /lib/libc.so.6
test case:
SELECT ST_UNION (
PolyFromText( ' POLYGON( ( 2 2 , 3 2 , 2 7 , 2 2 ) , ( 0 0 , 8 2 , 1 9 , 0 0 ) ) ' ) ,
ExteriorRing( Envelope( MultiLineStringFromText( ' MULTILINESTRING( ( 3 4 , 5 3 ) , ( 3 0 , 0 5 ) ) ' ) ) )
);
bzr version-info
revision-id: <email address hidden>
date: 2011-06-20 00:21:41 +0500
build-date: 2011-06-23 19:44:53 +0300
revno: 2982
branch-nick: maria-5.3-gis
Rasmus Johansson (Inactive)
made changes -
2012-10-04 11:22
Field
Original Value
New Value
Resolution
Fixed
[ 1
]
Status
Closed
[ 6
]
Reopened
[ 4
]
Rasmus Johansson (Inactive)
made changes -
2012-10-04 13:19
Key
IMT-7245
MDEV-1357
Project
ImportTest
[ 10200
]
MariaDB Development
[ 10000
]
Workflow
jira
[ 20894
]
defaullt
[ 22201
]
Rasmus Johansson (Inactive)
made changes -
2012-10-04 13:22
Key
IMT-7245
MDEV-2491
Project
ImportTest
[ 10200
]
MariaDB Development
[ 10000
]
Workflow
jira
[ 20894
]
defaullt
[ 23335
]
Sergei Golubchik
made changes -
2014-06-13 15:06
Workflow
defaullt
[ 24137
]
MariaDB v2
[ 45465
]
Sergei Golubchik
made changes -
2015-02-02 21:55
Labels
Launchpad MariaDB_5.3
Launchpad
Sergei Golubchik
made changes -
2021-12-06 21:37
Workflow
MariaDB v3
[ 63913
]
MariaDB v4
[ 145658
]
{"report":{"fcp":958.8000000715256,"ttfb":269,"pageVisibility":"visible","entityId":20793,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"fa43d232-c4e3-4418-a18d-2b4c55d699ad","navigationType":0,"readyForUser":1030.7000000476837,"redirectCount":0,"resourceLoadedEnd":660.5,"resourceLoadedStart":277.2000000476837,"resourceTiming":[{"duration":91.60000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":277.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":277.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":368.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":91.5,"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":277.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":277.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":369.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":269.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":277.7000000476837,"connectEnd":277.7000000476837,"connectStart":277.7000000476837,"domainLookupEnd":277.7000000476837,"domainLookupStart":277.7000000476837,"fetchStart":277.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":371,"responseEnd":547.6000000238419,"responseStart":394.5,"secureConnectionStart":277.7000000476837},{"duration":382.1999999284744,"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":278.3000000715256,"connectEnd":278.3000000715256,"connectStart":278.3000000715256,"domainLookupEnd":278.3000000715256,"domainLookupStart":278.3000000715256,"fetchStart":278.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":371.7000000476837,"responseEnd":660.5,"responseStart":409,"secureConnectionStart":278.3000000715256},{"duration":120.39999997615814,"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":278.5,"connectEnd":278.5,"connectStart":278.5,"domainLookupEnd":278.5,"domainLookupStart":278.5,"fetchStart":278.5,"redirectEnd":0,"redirectStart":0,"requestStart":375.5,"responseEnd":398.89999997615814,"responseStart":397.89999997615814,"secureConnectionStart":278.5},{"duration":124.60000002384186,"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":278.7000000476837,"connectEnd":278.7000000476837,"connectStart":278.7000000476837,"domainLookupEnd":278.7000000476837,"domainLookupStart":278.7000000476837,"fetchStart":278.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":378.39999997615814,"responseEnd":403.3000000715256,"responseStart":400.10000002384186,"secureConnectionStart":278.7000000476837},{"duration":124.70000004768372,"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":278.89999997615814,"connectEnd":278.89999997615814,"connectStart":278.89999997615814,"domainLookupEnd":278.89999997615814,"domainLookupStart":278.89999997615814,"fetchStart":278.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":381.89999997615814,"responseEnd":403.60000002384186,"responseStart":400.8000000715256,"secureConnectionStart":278.89999997615814},{"duration":98.89999997615814,"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":279,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":279,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":377.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":99.89999997615814,"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":279.3000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":279.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":379.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":124.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":279.3000000715256,"connectEnd":279.3000000715256,"connectStart":279.3000000715256,"domainLookupEnd":279.3000000715256,"domainLookupStart":279.3000000715256,"fetchStart":279.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":382.39999997615814,"responseEnd":403.8000000715256,"responseStart":401.5,"secureConnectionStart":279.3000000715256},{"duration":126.90000009536743,"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":279.39999997615814,"connectEnd":279.39999997615814,"connectStart":279.39999997615814,"domainLookupEnd":279.39999997615814,"domainLookupStart":279.39999997615814,"fetchStart":279.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":384.10000002384186,"responseEnd":406.3000000715256,"responseStart":404,"secureConnectionStart":279.39999997615814},{"duration":360.6999999284744,"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":284.2000000476837,"connectEnd":284.2000000476837,"connectStart":284.2000000476837,"domainLookupEnd":284.2000000476837,"domainLookupStart":284.2000000476837,"fetchStart":284.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":432.2000000476837,"responseEnd":644.8999999761581,"responseStart":638.2000000476837,"secureConnectionStart":284.2000000476837},{"duration":356.2000000476837,"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":290,"connectEnd":290,"connectStart":290,"domainLookupEnd":290,"domainLookupStart":290,"fetchStart":290,"redirectEnd":0,"redirectStart":0,"requestStart":476,"responseEnd":646.2000000476837,"responseStart":642.8000000715256,"secureConnectionStart":290},{"duration":162.69999992847443,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":696.7000000476837,"connectEnd":696.7000000476837,"connectStart":696.7000000476837,"domainLookupEnd":696.7000000476837,"domainLookupStart":696.7000000476837,"fetchStart":696.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":828.2000000476837,"responseEnd":859.3999999761581,"responseStart":858.7000000476837,"secureConnectionStart":696.7000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":57,"responseStart":269,"responseEnd":289,"domLoading":272,"domInteractive":1153,"domContentLoadedEventStart":1153,"domContentLoadedEventEnd":1210,"domComplete":1742,"loadEventStart":1742,"loadEventEnd":1742,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1117.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1118.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":1118.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1122.6000000238419},{"name":"activityTabFullyLoaded","time":1231}],"measures":[],"correlationId":"940f8dc8351585","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":151,"dbReadsTimeInMs":29,"dbConnsTimeInMs":40,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Re: Assertion `(0)' failed in Gis_geometry_collection::init_from_opresult in maria-5.3-gis
Reproducible without Envelope. Reproducible without ExteriorRing . Seems to require ST_UNION