[Tile-serving] [osm2pgsql] null value in column "pending" violates not-null constraint (#293)

Thu Feb 19 16:52:15 UTC 2015

Hi, I'm trying to update my maps using the following command...

```
osmosis --read-replication-interval workingDirectory=$WORKDIR_OSM --simplify-change --write-xml-change - |
$HOME/osm2pgsql/bin/osm2pgsql -d osm -H c3sldatabase.c3sl.ufpr.br -U osm --append --slim -
```

and I'm getting the following error:
```
Processing: Node(13900k 0.3k/s) Way(0k 0.00k/s) Relation(0 0.00/s)node cache: stored: 12818966(100.00%), storage efficiency: 82.16% (dense blocks: 11657, sparse nodes: 1832493), hit rate: -nan%
Osm2pgsql failed due to ERROR: insert_way failed: ERROR:  null value in column "pending" violates not-null constraint
DETAIL:  Registro que falhou contém (462, {206998,1250191631,206999,2001849072,1250191914,207000,207001}, {source:maxspeed,survey,ref,A38,oneway,yes,note,"gritting additi..., null).
(7)
Arguments were: 462, {206998,1250191631,206999,2001849072,1250191914,207000,207001}, {"source:maxspeed","survey","ref","A38","oneway","yes","note","gritting addition Oct 2010","name","Sutton Coldfield Bypass","maxspeed","70 mph","maintenance","gritting","lit","yes","junction","roundabout","highway","trunk","gritting_route_revision","201110","gritting_route_ref","1","gritting_operator","Warwickshire County Council","gritting_depot","Coleshill Heath Road","gritting","priority_1"},
15/02/2015 11:34:54 org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline complete.
15/02/2015 11:34:54 org.openstreetmap.osmosis.core.Osmosis run
INFO: Total execution time: 41747996 milliseconds.
```

Couldn't find anything similar on the internet. I haven't changed anything on the database that could be related to the "pending" column, just trying to update the osm maps for the first time.

```
INFO: Osmosis Version 0.40.1
osm2pgsql SVN version 0.87.1 (64bit id space)
```

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/293
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150219/17f3e691/attachment.html>