sjohn1
commented
7 years ago Hi,
I'm not sure what caused the error while executing the create table statement and need more information.
Can you please post the relevant content of the database logging file?
Which Version of PostGIS is installed on your machine?
Regards, Steffen
Am 07.11.2016 um 19:41 schrieb xmd5a:
I'm using Linux Mint 18, PostgreSQL 9.5. GPX data: http://zverik.osm.rambler.ru/gps/files/extracts/ex-ussr/moldova.tar.xz
|java -jar target/osmgpxfilter-0.1.jar -e -i /home/xmd5a/Загрузки/moldova.tar.xz -ds dump -wpg db=test_database user=test_user password=qwerty host=localhost port=5432 geometry=linestring [main] INFO osmgpxtool.filter.GpxFilter - Filter set with following Arguments: [main] INFO osmgpxtool.filter.GpxFilter
- Bounding box parameter not set. All data will be imported [main] INFO osmgpxtool.filter.GpxFilter - Only GPS-Tracks with elevation attribute (
) will be exported [main] INFO osmgpxtool.filter.writer.PGSqlMultilineWriter - connect to database: test_database, localhost:5432 with user: test_user [main] INFO osmgpxtool.filter.writer.PGSqlMultilineWriter - Connection successful! java.sql.BatchUpdateException: Batch entry 1 CREATE TABLE gpx_data_line("gpx_id" int, "trk_id" int ,"tags" text[],"points" integer,"uid" integer,"user" text,"visibility" text,"description" text,"geom" geometry(MultiLineStringZ,4326),CONSTRAINT gpx_data_line_pk PRIMARY KEY (gpx_id, trk_id)) was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737) at osmgpxtool.filter.writer.PGSqlMultilineWriter.createTable(PGSqlMultilineWriter.java:103) at osmgpxtool.filter.writer.PGSqlMultilineWriter.init(PGSqlMultilineWriter.java:79) at osmgpxtool.filter.Main.main(Main.java:84) [main] INFO osmgpxtool.filter.reader.OsmGpxDumpReader - Parsing 3613 metadata entries... [main] INFO osmgpxtool.filter.reader.OsmGpxDumpReader - Metadata successfully parsed. Total number of Gpx-Files in gpx archive: 3613 [main] INFO osmgpxtool.filter.reader.OsmGpxDumpReader - Start processing 3613 gpx files... [main] INFO osmgpxtool.filter.reader.OsmGpxDumpReader - step=1/3613 (0%) time for current step=1 00:00:00.071, current time=07.11.2016-21:23:58.771 elapsed time=1 00:00:00.071, processed steps=1, average time per step=1 00:00:00.071 remaining time=1 00:04:16.452, remaining steps=3612 org.postgresql.util.PSQLException: ERROR: relation "gpx_data_line" does not exist Позиция: 13 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) at osmgpxtool.filter.writer.PGSqlMultilineWriter.write(PGSqlMultilineWriter.java:171) at osmgpxtool.filter.reader.OsmGpxDumpReader.read(OsmGpxDumpReader.java:90) at osmgpxtool.filter.Main.main(Main.java:89) | What is the cause of error?
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/GIScience/osmgpxfilter/issues/1, or mute the thread https://github.com/notifications/unsubscribe-auth/AJwgDzwb_c1gXUNgh5AxFp1ZZ_KcggI7ks5q73DFgaJpZM4KrkHR.
Steffen John B. Eng Geoinformation (cand.) M.Sc. Geodesy and Geoinformation Science
Hauptstraße 76, 69117 Heidelberg Tel: 0176/34185826
I'm using Linux Mint 18, PostgreSQL 9.5. GPX data: http://zverik.osm.rambler.ru/gps/files/extracts/ex-ussr/moldova.tar.xz
What is the cause of error?