osm2pgsql problem
Geschrieben von dieterdreist (Gast) am 05. November 2020 10:34:01: [flux]
Ich frage mal hier, weil da doch einige mit Fachwissen präsent sind. Habe gestern versucht, einen Planet-Extrakt in eine Postgres/Postgis zu importieren, und gegen Ende gab es einen Fehler. Hier die Ausgabe:
%␣osm2pgsql␣--slim␣--username␣abc␣-k␣--database␣osm␣20201103_italy.osm.pbf osm2pgsql␣version␣1.3.0
Allocating␣memory␣for␣dense␣node␣cache Allocating␣dense␣node␣cache␣in␣one␣big␣chunk Allocating␣memory␣for␣sparse␣node␣cache Sharing␣dense␣sparse Node-cache:␣cache=800MB,␣maxblocks=12800*65536,␣allocation␣method=11 Mid:␣pgsql,␣cache=800 Setting␣up␣table:␣planet_osm_nodes Setting␣up␣table:␣planet_osm_ways Setting␣up␣table:␣planet_osm_rels Using␣built-in␣tag␣processing␣pipeline Using␣projection␣SRS␣3857␣(Spherical␣Mercator) Setting␣up␣table:␣planet_osm_point Setting␣up␣table:␣planet_osm_line Setting␣up␣table:␣planet_osm_polygon Setting␣up␣table:␣planet_osm_roads
Reading␣in␣file:␣20201103_italy.osm.pbf Using␣PBF␣parser. Processing:␣Node(198737k␣143.4k/s)␣Way(21651k␣5.23k/s)␣Relation(347397␣410.6/s)␣␣parse␣time:␣6373s Node␣stats:␣total(198737307),␣max(8079203523)␣in␣1386s Way␣stats:␣total(21651717),␣max(866788581)␣in␣4141s Relation␣stats:␣total(347397),␣max(11832253)␣in␣846s Sorting␣data␣and␣creating␣indexes␣for␣planet_osm_point Sorting␣data␣and␣creating␣indexes␣for␣planet_osm_line Sorting␣data␣and␣creating␣indexes␣for␣planet_osm_roads Sorting␣data␣and␣creating␣indexes␣for␣planet_osm_polygon Using␣native␣order␣for␣clustering Using␣native␣order␣for␣clustering Using␣native␣order␣for␣clustering Using␣native␣order␣for␣clustering Copying␣planet_osm_roads␣to␣cluster␣by␣geometry␣finished Creating␣geometry␣index␣on␣planet_osm_roads Creating␣osm_id␣index␣on␣planet_osm_roads Creating␣indexes␣on␣planet_osm_roads␣finished All␣indexes␣on␣planet_osm_roads␣created␣in␣194s Completed␣planet_osm_roads Stopping␣table:␣planet_osm_nodes Stopped␣table:␣planet_osm_nodes␣in␣1s Stopping␣table:␣planet_osm_ways Building␣index␣on␣table:␣planet_osm_ways Copying␣planet_osm_point␣to␣cluster␣by␣geometry␣finished Creating␣geometry␣index␣on␣planet_osm_point Creating␣osm_id␣index␣on␣planet_osm_point Creating␣indexes␣on␣planet_osm_point␣finished All␣indexes␣on␣planet_osm_point␣created␣in␣878s Completed␣planet_osm_point Stopping␣table:␣planet_osm_rels Building␣index␣on␣table:␣planet_osm_rels Stopped␣table:␣planet_osm_rels␣in␣68s Copying␣planet_osm_line␣to␣cluster␣by␣geometry␣finished Creating␣geometry␣index␣on␣planet_osm_line Creating␣osm_id␣index␣on␣planet_osm_line Creating␣indexes␣on␣planet_osm_line␣finished All␣indexes␣on␣planet_osm_line␣created␣in␣1873s Completed␣planet_osm_line SQL␣command␣failed:␣ERROR:␣␣could␣not␣seek␣to␣block␣4742566397934611732␣of␣temporary␣file
Full␣query:␣CREATE␣TABLE␣planet_osm_polygon_tmp␣␣AS␣SELECT␣*␣FROM␣planet_osm_polygon␣WHERE␣ST_IsValid(way)␣ORDER␣BY␣way Stopped␣table:␣planet_osm_ways␣in␣5448s node␣cache:␣stored:␣58377947(29.37%),␣storage␣efficiency:␣55.67%␣(dense␣blocks:␣1820,␣sparse␣nodes:␣44974081),␣hit␣rate:␣32.50% Osm2pgsql␣failed␣due␣to␣ERROR:␣Executing␣SQL
Das Problem scheint hier zu liegen: "SQL command failed: ERROR: could not seek to block 4742566397934611732 of temporary file". Ist das ein Festplattenfehler? Die Blocknummer ist ja viel zu hoch. Oder könnte das auch von osm2pgsql kommen?
Antworten:
- Re: osm2pgsql problem · Wulf4096 (Gast) · 05.11.2020 10:54 [flux]
- Re: osm2pgsql problem · dieterdreist (Gast) · 05.11.2020 11:02 [flux]
- Re: osm2pgsql problem · Jochen Topf (Gast) · 05.11.2020 14:35 [flux]