The import of a large land polygon from OpenStreetMap (http://openstreetmapdata.com/data/land-polygons ) into MariaDB fails (or takes too long, I stopped after 12 hrs).
For comparison: import into PostGIS via ogr2ogr for all polygons takes around 10 minutes.
Server version: 5.5.28-MariaDB-debug-log Source distribution
How to repeat:
Gunzip the attachment and run
mysql -uusername test < test.sql
made changes -
2012-11-14 12:13
Field
Original Value
New Value
Assignee
Elena Stepanova
[ elenst
]
made changes -
2012-11-16 13:23
Assignee
Elena Stepanova
[ elenst
]
Alexey Botchkov
[ holyfoot
]
made changes -
2013-10-09 16:48
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
2013-10-09 16:50
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
made changes -
2014-06-13 15:06
Workflow
defaullt
[ 25205
]
MariaDB v2
[ 42413
]
made changes -
2021-12-06 21:38
Workflow
MariaDB v3
[ 61359
]
MariaDB v4
[ 146202
]
{"report":{"fcp":1389.2000007629395,"ttfb":453.30000019073486,"pageVisibility":"visible","entityId":21905,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"fa299eb4-993e-492b-a1c6-244d541a3932","navigationType":0,"readyForUser":1487.2000007629395,"redirectCount":0,"resourceLoadedEnd":1074,"resourceLoadedStart":462.30000019073486,"resourceTiming":[{"duration":184.4000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":462.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":462.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":646.7000007629395,"responseStart":0,"secureConnectionStart":0},{"duration":184.69999980926514,"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":462.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":462.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":647.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":449,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":462.80000019073486,"connectEnd":462.80000019073486,"connectStart":462.80000019073486,"domainLookupEnd":462.80000019073486,"domainLookupStart":462.80000019073486,"fetchStart":462.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":651.1000003814697,"responseEnd":911.8000001907349,"responseStart":671.8000001907349,"secureConnectionStart":462.80000019073486},{"duration":610.3999996185303,"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":463.6000003814697,"connectEnd":463.6000003814697,"connectStart":463.6000003814697,"domainLookupEnd":463.6000003814697,"domainLookupStart":463.6000003814697,"fetchStart":463.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":650.7000007629395,"responseEnd":1074,"responseStart":668.8000001907349,"secureConnectionStart":463.6000003814697},{"duration":213,"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":463.70000076293945,"connectEnd":463.70000076293945,"connectStart":463.70000076293945,"domainLookupEnd":463.70000076293945,"domainLookupStart":463.70000076293945,"fetchStart":463.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":652.4000005722046,"responseEnd":676.7000007629395,"responseStart":675,"secureConnectionStart":463.70000076293945},{"duration":219.10000038146973,"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":464,"connectEnd":464,"connectStart":464,"domainLookupEnd":464,"domainLookupStart":464,"fetchStart":464,"redirectEnd":0,"redirectStart":0,"requestStart":654.9000005722046,"responseEnd":683.1000003814697,"responseStart":677,"secureConnectionStart":464},{"duration":220,"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":464.20000076293945,"connectEnd":464.20000076293945,"connectStart":464.20000076293945,"domainLookupEnd":464.20000076293945,"domainLookupStart":464.20000076293945,"fetchStart":464.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":655.8000001907349,"responseEnd":684.2000007629395,"responseStart":678.5,"secureConnectionStart":464.20000076293945},{"duration":188.10000038146973,"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":464.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":464.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":652.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":220.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":464.4000005722046,"connectEnd":464.4000005722046,"connectStart":464.4000005722046,"domainLookupEnd":464.4000005722046,"domainLookupStart":464.4000005722046,"fetchStart":464.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":657.5,"responseEnd":684.6000003814697,"responseStart":679.4000005722046,"secureConnectionStart":464.4000005722046},{"duration":190.19999980926514,"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":464.70000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":464.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":654.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":221.89999961853027,"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":464.70000076293945,"connectEnd":464.70000076293945,"connectStart":464.70000076293945,"domainLookupEnd":464.70000076293945,"domainLookupStart":464.70000076293945,"fetchStart":464.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":663.9000005722046,"responseEnd":686.6000003814697,"responseStart":685,"secureConnectionStart":464.70000076293945},{"duration":594.5999994277954,"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":466.70000076293945,"connectEnd":466.70000076293945,"connectStart":466.70000076293945,"domainLookupEnd":466.70000076293945,"domainLookupStart":466.70000076293945,"fetchStart":466.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":804,"responseEnd":1061.3000001907349,"responseStart":1056.9000005722046,"secureConnectionStart":466.70000076293945},{"duration":603.8000001907349,"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":466.80000019073486,"connectEnd":466.80000019073486,"connectStart":466.80000019073486,"domainLookupEnd":466.80000019073486,"domainLookupStart":466.80000019073486,"fetchStart":466.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":1010.9000005722046,"responseEnd":1070.6000003814697,"responseStart":1065.4000005722046,"secureConnectionStart":466.80000019073486},{"duration":239.60000038146973,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1058.8000001907349,"connectEnd":1058.8000001907349,"connectStart":1058.8000001907349,"domainLookupEnd":1058.8000001907349,"domainLookupStart":1058.8000001907349,"fetchStart":1058.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1261.3000001907349,"responseEnd":1298.4000005722046,"responseStart":1297.4000005722046,"secureConnectionStart":1058.8000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":262,"responseStart":453,"responseEnd":465,"domLoading":457,"domInteractive":1605,"domContentLoadedEventStart":1605,"domContentLoadedEventEnd":1667,"domComplete":3005,"loadEventStart":3005,"loadEventEnd":3006,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1524.4000005722046},{"name":"bigPipe.sidebar-id.end","time":1525.2000007629395},{"name":"bigPipe.activity-panel-pipe-id.start","time":1525.4000005722046},{"name":"bigPipe.activity-panel-pipe-id.end","time":1528},{"name":"activityTabFullyLoaded","time":1684.5}],"measures":[],"correlationId":"35597a014c22f4","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":117,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
The problem only affects a debug build (it didn't hang or take 12 hours, but was long enough); release servers finish the job in no time (tried 5.5.25 and 5.5.28, linux x86_64).
Alexey,
Could you please check whether it's the expected behavior of a debug build?
Please note that when you execute the attached test.sql for the first time, it sets the global max_allowed_packet, but not the session one, so execution ends with "server gone away". Just run it once again.