Weltstaat commented on issue #538:
URL:
https://github.com/apache/incubator-baremaps/issues/538#issuecomment-1318711622
I started with v0.7.0 and gave it a second try now. It's the same problem.
If you're interested in the full error message - here it is:
```
[INFO ] 2022-11-17 15:18:56.878 [main] ExportVectorTiles - Exporting vector
tiles from jdbc:postgresql://winhost:5432/planet?user=sde&password=zzjhlsq to
/home/weltstaat/baremaps/tiles
[DEBUG] 2022-11-17 15:18:56.885 [main] HikariConfig - HikariPool-1 -
configuration:
[DEBUG] 2022-11-17 15:18:56.890 [main] HikariConfig -
allowPoolSuspension.............false
[DEBUG] 2022-11-17 15:18:56.890 [main] HikariConfig -
autoCommit......................true
[DEBUG] 2022-11-17 15:18:56.891 [main] HikariConfig -
catalog.........................none
[DEBUG] 2022-11-17 15:18:56.891 [main] HikariConfig -
connectionInitSql...............none
[DEBUG] 2022-11-17 15:18:56.891 [main] HikariConfig -
connectionTestQuery.............none
[DEBUG] 2022-11-17 15:18:56.891 [main] HikariConfig -
connectionTimeout...............30000
[DEBUG] 2022-11-17 15:18:56.892 [main] HikariConfig -
dataSource......................none
[DEBUG] 2022-11-17 15:18:56.892 [main] HikariConfig -
dataSourceClassName.............none
[DEBUG] 2022-11-17 15:18:56.892 [main] HikariConfig -
dataSourceJNDI..................none
[DEBUG] 2022-11-17 15:18:56.893 [main] HikariConfig -
dataSourceProperties............{password=<masked>}
[DEBUG] 2022-11-17 15:18:56.893 [main] HikariConfig -
driverClassName.................none
[DEBUG] 2022-11-17 15:18:56.894 [main] HikariConfig -
exceptionOverrideClassName......none
[DEBUG] 2022-11-17 15:18:56.894 [main] HikariConfig -
healthCheckProperties...........{}
[DEBUG] 2022-11-17 15:18:56.894 [main] HikariConfig -
healthCheckRegistry.............none
[DEBUG] 2022-11-17 15:18:56.894 [main] HikariConfig -
idleTimeout.....................600000
[DEBUG] 2022-11-17 15:18:56.894 [main] HikariConfig -
initializationFailTimeout.......1
[DEBUG] 2022-11-17 15:18:56.895 [main] HikariConfig -
isolateInternalQueries..........false
[DEBUG] 2022-11-17 15:18:56.895 [main] HikariConfig -
jdbcUrl.........................jdbc:postgresql://winhost:5432/planet?user=sde&password=<masked>
[DEBUG] 2022-11-17 15:18:56.895 [main] HikariConfig -
keepaliveTime...................0
[DEBUG] 2022-11-17 15:18:56.895 [main] HikariConfig -
leakDetectionThreshold..........0
[DEBUG] 2022-11-17 15:18:56.895 [main] HikariConfig -
maxLifetime.....................1800000
[DEBUG] 2022-11-17 15:18:56.895 [main] HikariConfig -
maximumPoolSize.................8
[DEBUG] 2022-11-17 15:18:56.896 [main] HikariConfig -
metricRegistry..................none
[DEBUG] 2022-11-17 15:18:56.896 [main] HikariConfig -
metricsTrackerFactory...........none
[DEBUG] 2022-11-17 15:18:56.896 [main] HikariConfig -
minimumIdle.....................8
[DEBUG] 2022-11-17 15:18:56.896 [main] HikariConfig -
password........................<masked>
[DEBUG] 2022-11-17 15:18:56.897 [main] HikariConfig -
poolName........................"HikariPool-1"
[DEBUG] 2022-11-17 15:18:56.897 [main] HikariConfig -
readOnly........................false
[DEBUG] 2022-11-17 15:18:56.897 [main] HikariConfig -
registerMbeans..................false
[DEBUG] 2022-11-17 15:18:56.897 [main] HikariConfig -
scheduledExecutor...............none
[DEBUG] 2022-11-17 15:18:56.897 [main] HikariConfig -
schema..........................none
[DEBUG] 2022-11-17 15:18:56.897 [main] HikariConfig -
threadFactory...................internal
[DEBUG] 2022-11-17 15:18:56.897 [main] HikariConfig -
transactionIsolation............default
[DEBUG] 2022-11-17 15:18:56.898 [main] HikariConfig -
username........................none
[DEBUG] 2022-11-17 15:18:56.898 [main] HikariConfig -
validationTimeout...............5000
[INFO ] 2022-11-17 15:18:56.899 [main] HikariDataSource - HikariPool-1 -
Starting...
[DEBUG] 2022-11-17 15:18:56.916 [main] DriverDataSource - Loaded driver with
class name org.postgresql.Driver for
jdbcUrl=jdbc:postgresql://winhost:5432/planet?user=sde&password=<masked>
[INFO ] 2022-11-17 15:18:57.111 [main] HikariPool - HikariPool-1 - Added
connection org.postgresql.jdbc.PgConnection@306851c7
[INFO ] 2022-11-17 15:18:57.113 [main] HikariDataSource - HikariPool-1 -
Start completed.
[DEBUG] 2022-11-17 15:18:57.213 [HikariPool-1 housekeeper] HikariPool -
HikariPool-1 - Pool stats (total=1, active=0, idle=1, waiting=0)
[DEBUG] 2022-11-17 15:18:57.263 [HikariPool-1 connection adder] HikariPool -
HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@2392c6c
[DEBUG] 2022-11-17 15:18:57.316 [HikariPool-1 connection adder] HikariPool -
HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@4dc3c860
[DEBUG] 2022-11-17 15:18:57.367 [HikariPool-1 connection adder] HikariPool -
HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@7e3f6040
[DEBUG] 2022-11-17 15:18:57.393 [ForkJoinPool.commonPool-worker-2]
PostgresTileStore - Executing query: with
[DEBUG] 2022-11-17 15:18:57.394 [ForkJoinPool.commonPool-worker-3]
PostgresTileStore - Executing query: with
[DEBUG] 2022-11-17 15:18:57.415 [ForkJoinPool.commonPool-worker-4]
PostgresTileStore - Executing query: with
[DEBUG] 2022-11-17 15:18:57.416 [ForkJoinPool.commonPool-worker-5]
PostgresTileStore - Executing query: with
[DEBUG] 2022-11-17 15:18:57.418 [ForkJoinPool.commonPool-worker-7]
PostgresTileStore - Executing query: with
[DEBUG] 2022-11-17 15:18:57.418 [ForkJoinPool.commonPool-worker-6]
PostgresTileStore - Executing query: with
[DEBUG] 2022-11-17 15:18:57.436 [HikariPool-1 connection adder] HikariPool -
HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@2dec372f
[DEBUG] 2022-11-17 15:18:57.453 [ForkJoinPool.commonPool-worker-1]
PostgresTileStore - Executing query: with h1b3f00ed as (select * from
planet.sde.Z8_roads_l where ((true)) and st_intersects(shape::geometry,
st_tileenvelope(8, 137, 105))) select st_asmvt(target, 'roads', 4096, 'geom',
'id') from (select objectid::int as id, (roadcode::jsonb ||
jsonb_build_object('geometry', lower(replace(st_geometrytype(shape::geometry),
'ST_', '')))) as tags, st_asmvtgeom(shape::geometry, st_tileenvelope(8, 137,
105), 4096, 256, true) as geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.460 [main] PostgresTileStore - Executing query:
with h1b3f00ed as (select * from planet.sde.Z8_roads_l where ((true)) and
st_intersects(shape::geometry, st_tileenvelope(8, 137, 107))) select
st_asmvt(target, 'roads', 4096, 'geom', 'id') from (select objectid::int as id,
(roadcode::jsonb || jsonb_build_object('geometry',
lower(replace(st_geometrytype(shape::geometry), 'ST_', '')))) as tags,
st_asmvtgeom(shape::geometry, st_tileenvelope(8, 137, 107), 4096, 256, true) as
geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.484 [main] PostgresTileStore - Executing query:
with h1b3f00ed as (select * from planet.sde.Z8_roads_l where ((true)) and
st_intersects(shape::geometry, st_tileenvelope(8, 138, 107))) select
st_asmvt(target, 'roads', 4096, 'geom', 'id') from (select objectid::int as id,
(roadcode::jsonb || jsonb_build_object('geometry',
lower(replace(st_geometrytype(shape::geometry), 'ST_', '')))) as tags,
st_asmvtgeom(shape::geometry, st_tileenvelope(8, 138, 107), 4096, 256, true) as
geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.484 [ForkJoinPool.commonPool-worker-1]
PostgresTileStore - Executing query: with h1b3f00ed as (select * from
planet.sde.Z8_roads_l where ((true)) and st_intersects(shape::geometry,
st_tileenvelope(8, 138, 105))) select st_asmvt(target, 'roads', 4096, 'geom',
'id') from (select objectid::int as id, (roadcode::jsonb ||
jsonb_build_object('geometry', lower(replace(st_geometrytype(shape::geometry),
'ST_', '')))) as tags, st_asmvtgeom(shape::geometry, st_tileenvelope(8, 138,
105), 4096, 256, true) as geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.492 [main] PostgresTileStore - Executing query:
with h1b3f00ed as (select * from planet.sde.Z8_roads_l where ((true)) and
st_intersects(shape::geometry, st_tileenvelope(8, 139, 107))) select
st_asmvt(target, 'roads', 4096, 'geom', 'id') from (select objectid::int as id,
(roadcode::jsonb || jsonb_build_object('geometry',
lower(replace(st_geometrytype(shape::geometry), 'ST_', '')))) as tags,
st_asmvtgeom(shape::geometry, st_tileenvelope(8, 139, 107), 4096, 256, true) as
geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.492 [ForkJoinPool.commonPool-worker-1]
PostgresTileStore - Executing query: with h1b3f00ed as (select * from
planet.sde.Z8_roads_l where ((true)) and st_intersects(shape::geometry,
st_tileenvelope(8, 139, 105))) select st_asmvt(target, 'roads', 4096, 'geom',
'id') from (select objectid::int as id, (roadcode::jsonb ||
jsonb_build_object('geometry', lower(replace(st_geometrytype(shape::geometry),
'ST_', '')))) as tags, st_asmvtgeom(shape::geometry, st_tileenvelope(8, 139,
105), 4096, 256, true) as geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.496 [HikariPool-1 connection adder] HikariPool -
HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@3d11587d
[DEBUG] 2022-11-17 15:18:57.500 [ForkJoinPool.commonPool-worker-1]
PostgresTileStore - Executing query: with h1b3f00ed as (select * from
planet.sde.Z8_roads_l where ((true)) and st_intersects(shape::geometry,
st_tileenvelope(8, 140, 105))) select st_asmvt(target, 'roads', 4096, 'geom',
'id') from (select objectid::int as id, (roadcode::jsonb ||
jsonb_build_object('geometry', lower(replace(st_geometrytype(shape::geometry),
'ST_', '')))) as tags, st_asmvtgeom(shape::geometry, st_tileenvelope(8, 140,
105), 4096, 256, true) as geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.500 [main] PostgresTileStore - Executing query:
with h1b3f00ed as (select * from planet.sde.Z8_roads_l where ((true)) and
st_intersects(shape::geometry, st_tileenvelope(8, 140, 107))) select
st_asmvt(target, 'roads', 4096, 'geom', 'id') from (select objectid::int as id,
(roadcode::jsonb || jsonb_build_object('geometry',
lower(replace(st_geometrytype(shape::geometry), 'ST_', '')))) as tags,
st_asmvtgeom(shape::geometry, st_tileenvelope(8, 140, 107), 4096, 256, true) as
geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.507 [main] PostgresTileStore - Executing query:
with h1b3f00ed as (select * from planet.sde.Z8_roads_l where ((true)) and
st_intersects(shape::geometry, st_tileenvelope(8, 141, 107))) select
st_asmvt(target, 'roads', 4096, 'geom', 'id') from (select objectid::int as id,
(roadcode::jsonb || jsonb_build_object('geometry',
lower(replace(st_geometrytype(shape::geometry), 'ST_', '')))) as tags,
st_asmvtgeom(shape::geometry, st_tileenvelope(8, 141, 107), 4096, 256, true) as
geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.507 [ForkJoinPool.commonPool-worker-1]
PostgresTileStore - Executing query: with h1b3f00ed as (select * from
planet.sde.Z8_roads_l where ((true)) and st_intersects(shape::geometry,
st_tileenvelope(8, 141, 105))) select st_asmvt(target, 'roads', 4096, 'geom',
'id') from (select objectid::int as id, (roadcode::jsonb ||
jsonb_build_object('geometry', lower(replace(st_geometrytype(shape::geometry),
'ST_', '')))) as tags, st_asmvtgeom(shape::geometry, st_tileenvelope(8, 141,
105), 4096, 256, true) as geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.513 [main] PostgresTileStore - Executing query:
with
[DEBUG] 2022-11-17 15:18:57.515 [ForkJoinPool.commonPool-worker-1]
PostgresTileStore - Executing query: with h1b3f00ed as (select * from
planet.sde.Z8_roads_l where ((true)) and st_intersects(shape::geometry,
st_tileenvelope(8, 137, 106))) select st_asmvt(target, 'roads', 4096, 'geom',
'id') from (select objectid::int as id, (roadcode::jsonb ||
jsonb_build_object('geometry', lower(replace(st_geometrytype(shape::geometry),
'ST_', '')))) as tags, st_asmvtgeom(shape::geometry, st_tileenvelope(8, 137,
106), 4096, 256, true) as geom from h1b3f00ed ) as target
[INFO ] 2022-11-17 15:18:57.520 [main] HikariDataSource - HikariPool-1 -
Shutdown initiated...
[DEBUG] 2022-11-17 15:18:57.520 [main] HikariPool - HikariPool-1 - Before
shutdown stats (total=6, active=1, idle=5, waiting=0)
[DEBUG] 2022-11-17 15:18:57.523 [HikariPool-1 connection closer] PoolBase -
HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@306851c7:
(connection evicted)
[DEBUG] 2022-11-17 15:18:57.523 [HikariPool-1 connection closer] PoolBase -
HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@4dc3c860:
(connection evicted)
[DEBUG] 2022-11-17 15:18:57.523 [HikariPool-1 connection closer] PoolBase -
HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@7e3f6040:
(connection evicted)
[DEBUG] 2022-11-17 15:18:57.524 [HikariPool-1 connection closer] PoolBase -
HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@2dec372f:
(connection evicted)
[DEBUG] 2022-11-17 15:18:57.524 [HikariPool-1 connection closer] PoolBase -
HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@3d11587d:
(connection evicted)
[DEBUG] 2022-11-17 15:18:57.532 [ForkJoinPool.commonPool-worker-1]
PostgresTileStore - Executing query: with h1b3f00ed as (select * from
planet.sde.Z8_roads_l where ((true)) and st_intersects(shape::geometry,
st_tileenvelope(8, 138, 106))) select st_asmvt(target, 'roads', 4096, 'geom',
'id') from (select objectid::int as id, (roadcode::jsonb ||
jsonb_build_object('geometry', lower(replace(st_geometrytype(shape::geometry),
'ST_', '')))) as tags, st_asmvtgeom(shape::geometry, st_tileenvelope(8, 138,
106), 4096, 256, true) as geom from h1b3f00ed ) as target
[DEBUG] 2022-11-17 15:18:57.545 [HikariPool-1 connection adder] HikariPool -
HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@6003a985
[DEBUG] 2022-11-17 15:18:57.555 [HikariPool-1 connection adder] HikariPool -
HikariPool-1 - After adding stats (total=2, active=0, idle=2, waiting=0)
[DEBUG] 2022-11-17 15:18:57.557 [HikariPool-1 connection closer] PoolBase -
HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@2392c6c:
(connection evicted)
[DEBUG] 2022-11-17 15:18:57.558 [HikariPool-1 connection closer] PoolBase -
HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@6003a985:
(connection evicted)
[DEBUG] 2022-11-17 15:18:57.558 [main] HikariPool - HikariPool-1 - After
shutdown stats (total=0, active=0, idle=0, waiting=0)
[INFO ] 2022-11-17 15:18:57.558 [main] HikariDataSource - HikariPool-1 -
Shutdown completed.
[ERROR] 2022-11-17 15:18:57.558 [main] ExportVectorTiles - Failed exporting
vector tiles from
jdbc:postgresql://winhost:5432/planet?user=sde&password=zzjhlsq to
/home/weltstaat/baremaps/tiles
com.baremaps.workflow.WorkflowException: java.lang.RuntimeException:
java.lang.RuntimeException: An error occurred while creating the tiles
at
com.baremaps.workflow.tasks.ExportVectorTiles.run(ExportVectorTiles.java:94)
at com.baremaps.cli.map.Export.call(Export.java:88)
at com.baremaps.cli.map.Export.call(Export.java:26)
at picocli.CommandLine.executeUserObject(CommandLine.java:1953)
at picocli.CommandLine.access$1300(CommandLine.java:145)
at
picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2358)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2352)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2314)
at
picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)
at picocli.CommandLine$RunLast.execute(CommandLine.java:2316)
at picocli.CommandLine.execute(CommandLine.java:2078)
at com.baremaps.cli.Baremaps.main(Baremaps.java:95)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: An error
occurred while creating the tiles
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
at
java.base/java.util.concurrent.ForkJoinTask.getThrowableException(ForkJoinTask.java:562)
at
java.base/java.util.concurrent.ForkJoinTask.reportException(ForkJoinTask.java:591)
at
java.base/java.util.concurrent.ForkJoinTask.invoke(ForkJoinTask.java:689)
at
java.base/java.util.stream.ForEachOps$ForEachOp.evaluateParallel(ForEachOps.java:159)
at
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateParallel(ForEachOps.java:173)
at
java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:233)
at
java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
at
java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:765)
at
com.baremaps.workflow.tasks.ExportVectorTiles.run(ExportVectorTiles.java:89)
... 11 more
Caused by: java.lang.RuntimeException: An error occurred while creating the
tiles
at com.baremaps.database.tile.TileChannel.accept(TileChannel.java:61)
at com.baremaps.database.tile.TileChannel.accept(TileChannel.java:19)
at
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
at
java.base/java.util.ArrayList$Itr.forEachRemaining(ArrayList.java:1003)
at
java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1845)
at
java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at
java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290)
at
java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754)
at
java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373)
at
java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182)
at
java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655)
at
java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622)
at
java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165)
Caused by: com.baremaps.database.tile.TileStoreException:
org.postgresql.util.PSQLException: FEHLER: Syntaxfehler am Ende der Eingabe
Position: 7
at
com.baremaps.database.tile.PostgresTileStore.read(PostgresTileStore.java:116)
at com.baremaps.database.tile.TileChannel.accept(TileChannel.java:54)
... 12 more
Caused by: org.postgresql.util.PSQLException: FEHLER: Syntaxfehler am Ende
der Eingabe
Position: 7
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:244)
at
com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110)
at
com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
at
com.baremaps.database.tile.PostgresTileStore.read(PostgresTileStore.java:101)
... 13 more
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
