Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5.25-galera
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Linux 32-bit
Description
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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.