[OSM-dev] osm2pgSQL: bad result during COPY

[Paul Norman]

On 2014-06-16 7:33 AM, Nourdine Ahamada wrote:
> ./osm2pgsql -l -x -v  --number-processes 4  --cache-strategy sparse -p 
> carto_ne  --style default.style -d carto -s -H <host>  -U <User> 
> download/netherlands-latest.osm.pbf
It shouldn't be related, but you probably don't want to specify a sparse 
strategy, but leave it at the default. You might also need to up the ram 
cache with --cache, the default is 800MB. Again, not the issue here.

> Reading in file: download/netherlands-latest.osm.pbf
> Processing: Node(94050k 26.1k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
> carto_ne_line - bad result during COPY, data 4009112  \N      \N     
>  \N      \N      \N      \N      \N      \N      \N      \N      \N   
>    \N      \N      \N     \N \N      \N      \N      \N      \N     
>  \N      \N      yes     \N      \N      footway \N      \N      \N   
>    \N  \N      \N      \N      \N      \N     \N       \N 
>  Lijnpadstraat   \N      \N      \N      \N      \N      \N      \N   
>    \N      \N      \N      \N      \N      \N  \N      \N      \N     
>  \N     \N       \N      \N      \N      \N      \N      \N      \N   
>    \N      \N      0 \N      \N      \N      \N      \N      3       
> \N  SRID=4326;LINESTRING (5.1221357000000003 52.0801506999999972, 
> 5.1218190000000003 52.0802778999999987)
>
> Error occurred, cleaning up
I'm not sure how many nodes there are in the netherlands extract, but my 
guess is this was the first way.

> I checked the MD5, ok. When I tried again, it is now stuck on
> NOTICE:  table "carto_ne_line_tmp" does not exist, skipping
Dropping the database, recreating it, and re-installing postgis on it 
should fix this and get you back to where you were.
> The only thing Google told me about that error is to check the 
> encoding (UTF8, wich is OK), so I'm looking for a little help.
> I'm running on CentOS 6.4, and PostGres 9.0.6 for the database.
The encoding is almost certainly unrelated, as all the characters in 
this way's tags are ascii.

If you get the same error after dropping the DB and recreating it, can 
you open an issue on https://github.com/openstreetmap/osm2pgsql? Please 
include the output of SELECT PostGIS_Full_Version()