GIScience / GIScience/osmgpxfilter

java.sql.BatchUpdateException

Open
#1 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
2
Forks
2
PR merge metrics
No merged PRs in 30d

Description

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?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.