NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

duplicate key value violates unique constraint "planet_osm_nodes_pkey"

0

I'm building an OSM server using osm2pgsql and mapnik. I began the PostGIS import a couple of days ago, and it was chugging along just fine until sometime overnight, when I got this error:

Processing: Node(1312851k 68.0k/s) Way(119415k 0.75k/s) Relation(1230921 11.96/s)  parse time: 281588s

Reading in file: /dev/stdin
Unknown node type 8
insert_node failed: ERROR:  duplicate key value violates unique constraint "planet_osm_nodes_pkey"
DETAIL:  Key (id)=(1) already exists.
(7)
Arguments were: 1, 666549596, 104993388, (null),
Error occurred, cleaning up

Any suggestions?

asked 09 Jan '12, 20:52

Roger%20Weeks's gravatar image

Roger Weeks
11●1●1●2
accept rate: 0%

edited 09 Jan '12, 21:40

Gnonthgol's gravatar image

Gnonthgol ♦
13.8k●16●103●198

I recently ran into the same error - anyone have any suggestions?

(28 May '14, 19:19) aug_aug
One Answer:
active answersoldest answersnewest answerspopular answers
0

Is this the same issue? https://github.com/openstreetmap/osm2pgsql/issues/16

permanent link

answered 03 Apr '15, 22:55

iqqmuT's gravatar image

iqqmuT
11●1
accept rate: 0%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×341
×263
×134
×25

question asked: 09 Jan '12, 20:52

question was seen: 9,823 times

last updated: 03 Apr '15, 22:55

Related questions

Setting PostGIS as a datasource

Restarting osm2pqsql full planet import because of too low --cache setting? (import runs for 6 days already)

Best way to get all cities of a specific area?

Mapnik error: column "generator:source" does not exist

How to setup Localised maps

Why is my import of planet-latest.osm KILLED?

OSM – PostGIS – Mapnik problem!

How to configure postgresql for mapnik hourly updates?

Rendering images/maps from Postgresql/PostGIS Database

column "int_tc_type" does not exist

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum