[Talk-GB] Sync problem with british-isles.osm.pbf

Lester Caine lester at lsces.co.uk
Wed Nov 11 22:38:07 UTC 2015


I've got a copy of british-isles.osm.pbf which was updating fine until
the 1st November when it got stuck at
start import from seq-nr 896702

The osm2pgsql stage is failing with ...

> Osm2pgsql failed due to ERROR: insert_way failed: ERROR:  null value in column "pending" violates not-null constraint
> DETAIL:  Failing row contains (4254992, {17947723,17947722,17947721,2891767946,2891767954,2891767909,289..., {highway,secondary,ref,302}, null).
> (7)
> Arguments were: 4254992, {17947723,17947722,17947721,2891767946,2891767954,2891767909,2891767947,2891767919,2891767905,17947720,2891767938,17947719,2891767929,17947718,17947716,2891767907,2891767922,17947715,2891767944,17947714,2891767959,17947717,2891767953,17947713,2891767939,2891767910,17947712,2891767942,2891767943,17947711,2891767933,2891767937,2891767952,2891767928,17947710,2891767906,2891767936,2891767932,2891767913,2891767958,2891767924,17947709,2891767925,2891767918,2891767920,2892714782,2891767940,17947708,2892714719,2891767948,2891767950,2891767917,2892713977,17947707,2891767955,2891767926,2891767927,2891767908,17947706,2891767916,2891767957,2892712501,2891767956,17947705,2891767935,2892710491,17947704,2891797509,2891767930,2891767923,17947703,2891767911,17947702,2891767934,17947701,2891767931,2891767921,17947700,2891797521,2891767945,2891769852,2891767912,2891767915,2891767941,2891790382,17947699,2891767914,2891767949,2891767951,17947698,17947697,2891721239,17947695,1794
7694,17947693,17947692,17947691,17947689,309822592,17947688,17947687,17947686,17947685,17947684,17947683,17947682,17947681,17947680,17947679,17947678,17947677,17947676,2218967592,17947675,1851431147,17947674,17947673,17947672,17947671,17947670,17947668,17947667,17947666,17947665,17947664,17947663,17947662,1851431102,2890090823,17947661,17947660,17947659,17947658,17947657,17947656,17947655,17947654,1861986735,1861986730,17947653}, {"highway","secondary","ref","302"}, 

And now I'm stuck as to how to get it past the problem?
Is it a case of wiping the existing copy and downloading a clean copy,
or is there something to fix the update stream?

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk



More information about the Talk-GB mailing list