test.sql.gz
[MDEV-3856] Import of a large polygon fails/hangs Created: 2012-11-14 Updated: 2013-10-09 Resolved: 2013-10-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.5.25-galera |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Georg Richter | Assignee: | Alexey Botchkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Linux 32-bit |
||
| Attachments: |
test.sql.gz
|
| 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 |
| Comments |
| Comment by Elena Stepanova [ 2012-11-16 ] |
|
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, 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. |
| Comment by Alexey Botchkov [ 2013-10-09 ] |
|
http://lists.askmonty.org/pipermail/commits/2013-October/005507.html |