Interesting error using osm2pgsql for planet.osm

Hi All-

I’m attempting to populate my PostGIS/postgresql database with osm2pgsql with planet-090429.osm.bz2. All seems fine and dandy towards the end. I checked out the latest SVN code and compiled osm2pgsql without issue (osm2pgsql SVN version 0.65-14928). This is the error I’m getting:

./osm2pgsql -m -d gis -U gis /vol/planet-090429.osm.bz2
osm2pgsql SVN version 0.65-14928

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Mid: Ram, scale=100

Reading in file: /vol/planet-090429.osm.bz2
Processing: Node(342861k) Way(18101k) Relation(0k)planet_osm_line - bad result during COPY, data LINESTRING (-321563.0200000000186265 6779934.6299999998882413, -321649.0000000000000000 6779753.0999999996274710, -321687.2299999999813735 6779638.4400000004097819, -321668.1199999999953434 6779504.6699999999254942, -321649.0000000000000000 6779380.4599999999627471, -321649.0000000000000000 6779294.4699999997392297, -321658.5700000000069849 6779198.9299999997019768, -321706.3300000000162981 6779093.8200000002980232, -321735.0000000000000000 6779017.3899999996647239, -321744.5499999999883585 6778893.1699999999254942, -321744.5499999999883585 6778749.8600000003352761, -321715.8800000000046566 6778587.4299999997019768, -321668.1199999999953434 6778396.3300000000745058, -321668.1199999999953434 6778300.7999999998137355, -321687.2299999999813735 6778167.0300000002607703, -321763.6599999999743886 6777899.4900000002235174, -321954.7500000000000000 6777517.3200000002980232, -322155.4099999999743886 6777221.1100000003352761, -322289.1699999999837019 6776982.2500000000000000, -322332.5499999999883585 6776892.0999999996274710, -322375.1599999999743886 6776772.0400000000372529, -322394.2600000000093132 6776523.6200000001117587, -322461.1500000000232831 6776208.3300000000745058)
Error occurred, cleaning up

I’ve loaded OSM data from CloudMade with much smaller areas without issue using osm2pgsql into a different database and it works fine. Not sure where I’m going wrong.

I’ve also double-checked the MD5 and the file I’ve downloaded seems to be fine:

cat planet-090429.osm.bz2.md5
a37a88c75deaa66268a6846111f43ddc  planet-090429.osm.bz2
md5sum -b planet-090429.osm.bz2 
a37a88c75deaa66268a6846111f43ddc *planet-090429.osm.bz2

Other info, I’m using CentOS 5.3 x86_64 along with PostgreSQL 8.3.7 x86_64 & PostGIS 1.3.5 from the official RPM/yum repository from PostgreSQL.

Since other OSM files loaded fine, I’m assuming the length of the LL’s might be causing an issue? It looks like “Node” and “Way” went fine and got hung-up on “Relation”. Any help greatly appreciated in advance. Thank you!


You need to bring this up on the developer mailing list…

The only thing I can ask you is if you are sure you have enough space for postgres?