[OSM-dev] osm2pgsql - error loading planet

Simon Poole simon at poole.ch
Mon Mar 16 13:09:07 UTC 2015


Do you have enough disk space?

I believe we have seen similar errors due to running out of space (the
COPY command is essentially bulk loading data in to tables and seems to
not give particularly helpful messages when things go wrong).

Have you tried something really small, say Luxembourg or so?

Simon



Am 16.03.2015 um 10:28 schrieb angelo de angelis:
> Dear members,
> 
> it's many weeks that i'm trying to import the latest versione of the
> planet-latest.osm.pbf into postgresql/postgis using osm2pgsql without
> success.
> After many many attempts i tried to import a smaller version of the
> dataset (europe-latest.osm.pbf), same bad result.
> 
> Just some details on my configuration:
> 
> Hardware: PC 64-bit 8-core 32 gb ram
> OS: Ubuntu 14.04.2 LTS
> postgresql:  PostgreSQL 9.3.6 on x86_64-unknown-linux-gnu, compiled by
> gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit
> postgis: POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel.
> 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26"
> LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER
> osm2pgsql SVN version 0.85.0 (64bit id space)
> 
>  My last command was:
> 
> osm2pgsql --create -s -v -C 28000 --cache-strategy sparse
> --number-processes 6 -I --flat-nodes ./nodes.cache
> --disable-parallel-indexing -l -d gio_reference -U gio -W -H localhost
> -P 5432 /Data/europe-latest.osm.pbf
> 
> Here is the error:
> 
> Processing: Node(1432818k 1007.6k/s) Way(65018k 27.54k/s) Relation(0
> 0.00/s)pgsql_ways_set - bad result during COPY, data 139191086    
> {1525470973,1525469649,1525469626,1525469616,1525469608,1525469597,1525469594,1525469591,1525469590,1525469586,1525469583,1525469571,1525469573,1525469588,1525469593,1525469596,1525469613,1525469617,1525469618,1525469629,1525469634,1525470940,1525469638,1525469639,678216143}
> {"z_order","0","highway","track"}       f
> 
> Error occurred, cleaning up
> 
> I think it's a bug but found no informations neither solutions on forums.
> 
> Does anybody experienced a similar issue? Does anybody solved it? Please
> let me know.
> 
> Thanks, Angelo.
> 
> 
> 
> 
> 
> -- 
> al mondo ci sono solo 10 tipi di persone: quelle che capiscono il
> binario e quelle che non lo capiscono
> 
> 
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/dev
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: OpenPGP digital signature
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20150316/12b704c1/attachment.sig>


More information about the dev mailing list