<div dir="ltr">Thank you!<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Dec 17, 2019 at 12:51 PM Sarah Hoffmann <<a href="mailto:lonvia@denofr.de">lonvia@denofr.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">This has already been reported:<br>
<br>
<a href="https://github.com/openstreetmap/Nominatim/issues/1606" rel="noreferrer" target="_blank">https://github.com/openstreetmap/Nominatim/issues/1606</a><br>
<br>
Please follow the ticket for updates.<br>
<br>
Sarah<br>
<br>
On Tue, Dec 17, 2019 at 11:51:42AM -0300, Jorge Hequera wrote:<br>
> Hi there, I have an issue when I try to get updates from de cmdline:<br>
> <br>
> ./utils/update.php --import-osmosis-all<br>
> <br>
> (...)<br>
> Done 330099 in 2463 @ 134.023148 per second - Rank 30 ETA (seconds):<br>
> 1.417666<br>
> Done 330221 in 2464 @ 134.018265 per second - Rank 30 ETA (seconds):<br>
> 0.507394<br>
> Done 330383 in 2465 @ 134.029617 per second - Rank 30 ETA (seconds):<br>
> -0.701338<br>
> Done 330449 in 2466 @ 134.002029 per second - ETA (seconds): -1.194012<br>
> Done 331163 in 2466 @ 134.291565 per second - ETA (seconds): -6.508227<br>
> Done 331163 in 2466 @ 134.291565 per second - FINISHED<br>
> <br>
> string(187) "INSERT INTO import_osmosis_log(batchend, batchseq, batchsize,<br>
> starttime, endtime, event) values ('2019-11-01<br>
> 23:58:59+00:00',2607,NULL,'2019-12-17 04:08:12','2019-12-17<br>
> 05:39:44','index')"<br>
> 2019-12-17 05:39:44 Completed index step for 2019-11-01 23:58:59+00:00 in<br>
> 91.53 minutes<br>
> 2019-12-17 05:39:44 Completed all for 2019-11-01 23:58:59+00:00 in 114.78<br>
> minutes<br>
> Currently at sequence 2607 (01/11/2019 23:58:59) - 1 indexed<br>
> /srv/nominatim/.local/bin/pyosmium-get-changes --server<br>
> <a href="https://planet.openstreetmap.org/replication/day" rel="noreferrer" target="_blank">https://planet.openstreetmap.org/replication/day</a> -o<br>
> /srv/nominatim/Nominatim-3.4.0/build/osmosischange.osc -s 30 -I 2607<br>
> /srv/nominatim/Nominatim-3.4.0/build/osm2pgsql/osm2pgsql -klas<br>
> --number-processes 1 -C 2000 -O gazetteer -S<br>
> /srv/nominatim/Nominatim-3.4.0/settings/import-full.style -d nominatim -P<br>
> 5432 --flat-nodes /srv/nominatim/Nominatim-3.4.0/data/planet.bin<br>
> /srv/nominatim/Nominatim-3.4.0/build/osmosischange.osc<br>
> osm2pgsql version 1.2.0 (64 bit id space)<br>
> <br>
> Allocating memory for dense node cache<br>
> Allocating dense node cache in one big chunk<br>
> Allocating memory for sparse node cache<br>
> Sharing dense sparse<br>
> Node-cache: cache=2000MB, maxblocks=32000*65536, allocation method=11<br>
> Mid: loading persistent node cache from<br>
> /srv/nominatim/Nominatim-3.4.0/data/planet.bin<br>
> Mid: pgsql, cache=2000<br>
> Parsing gazetteer style file<br>
> '/srv/nominatim/Nominatim-3.4.0/settings/import-full.style'.<br>
> Using projection SRS 4326 (Latlong)<br>
> <br>
> Reading in file: /srv/nominatim/Nominatim-3.4.0/build/osmosischange.osc<br>
> Using XML parser.<br>
> Processing: Node(1916k 10.3k/s) Way(346k 2.44k/s) Relation(9420 24.47/s)<br>
> parse time: 713s<br>
> Node stats: total(1916176), max(6940299180) in 186s<br>
> Way stats: total(346274), max(741344763) in 142s<br>
> Relation stats: total(9471), max(10250591) in 385s<br>
> result COPY END for place failed: ERROR: value too long for type character<br>
> varying(2)<br>
> CONTEXT: SQL statement "INSERT INTO import_polygon_error (osm_type,<br>
> osm_id, class, type, name, country_code, updated, errormessage,<br>
> prevgeometry, newgeometry)<br>
> VALUES (NEW.osm_type, NEW.osm_id, NEW.class, NEW.type, NEW.name,<br>
> NEW.address->'country', now(),<br>
> 'Area reduced from '||st_area(existing.geometry)||' to<br>
> '||st_area(NEW.geometry), existing.geometry, NEW.geometry)"<br>
> PL/pgSQL function place_insert() line 107 at SQL statement<br>
> COPY place, line 19: "1943188 R boundary administrative<br>
> "alt_name:ar"=>"جامو وكشمير","name"=>"Jammu and Kashmir"..."<br>
> <br>
> DB writer thread failed due to ERROR: Ending COPY mode<br>
> Error executing osm2pgsql: 2<br>
> <br>
> Before this execution of the update process, I try to get updates several<br>
> times, but some preexistent bugs (fixed) interrupt the process.<br>
> <br>
> For further reference of the commented issues:<br>
> <br>
> <a href="https://github.com/openstreetmap/Nominatim/issues/1600" rel="noreferrer" target="_blank">https://github.com/openstreetmap/Nominatim/issues/1600</a><br>
> <a href="https://github.com/openstreetmap/Nominatim/issues/1550" rel="noreferrer" target="_blank">https://github.com/openstreetmap/Nominatim/issues/1550</a><br>
> <a href="https://github.com/openstreetmap/Nominatim/issues/1598" rel="noreferrer" target="_blank">https://github.com/openstreetmap/Nominatim/issues/1598</a><br>
> <a href="https://github.com/openstreetmap/Nominatim/issues/1594" rel="noreferrer" target="_blank">https://github.com/openstreetmap/Nominatim/issues/1594</a><br>
> <br>
> Actually I see a error on the copy (INSERT) step:<br>
> <br>
> *result COPY END for place failed: ERROR: value too long for type<br>
> character varying(2)*<br>
> <br>
> But I don't know how if I need to fix that statement manually or if there's<br>
> a policy to report this error to the mantainer or the person who does the<br>
> commit into the <a href="https://planet.openstreetmap.org/replication/day" rel="noreferrer" target="_blank">https://planet.openstreetmap.org/replication/day</a> repo.<br>
> <br>
> Thanks in advance!<br>
<br>
> _______________________________________________<br>
> Geocoding mailing list<br>
> <a href="mailto:Geocoding@openstreetmap.org" target="_blank">Geocoding@openstreetmap.org</a><br>
> <a href="https://lists.openstreetmap.org/listinfo/geocoding" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/geocoding</a><br>
<br>
</blockquote></div>