tyrauber opened a new issue, #573:
URL: https://github.com/apache/incubator-baremaps/issues/573
Hello, Using the baremaps postgis docker container and importing the
openstreet map example workflow, I am getting the following error from the tile
server when running serving tiles.
```
[ERROR] 2023-01-28 20:29:21.942 [servicetalk-global-executor-1-6]
DevResources - Tile error
org.apache.baremaps.database.tile.TileStoreException:
org.postgresql.util.PSQLException: ERROR: syntax error at end of input
Position: 7
at
org.apache.baremaps.database.tile.PostgresTileStore.read(PostgresTileStore.java:122)
~[baremaps-core-0.7.1-SNAPSHOT.jar:?]
at
org.apache.baremaps.server.DevResources.getTile(DevResources.java:137)
~[baremaps-server-0.7.1-SNAPSHOT.jar:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
~[jersey-server-2.35.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
~[jersey-common-2.35.jar:?]
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
~[jersey-common-2.35.jar:?]
at
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)
~[jersey-server-2.35.jar:?]
at
io.servicetalk.http.router.jersey.DefaultJerseyStreamingHttpRouter.handle0(DefaultJerseyStreamingHttpRouter.java:273)
~[servicetalk-http-router-jersey-0.42.18.jar:0.42.18]
at
io.servicetalk.http.router.jersey.DefaultJerseyStreamingHttpRouter.access$100(DefaultJerseyStreamingHttpRouter.java:79)
~[servicetalk-http-router-jersey-0.42.18.jar:0.42.18]
at
io.servicetalk.http.router.jersey.DefaultJerseyStreamingHttpRouter$3.handleSubscribe(DefaultJerseyStreamingHttpRouter.java:204)
~[servicetalk-http-router-jersey-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.handleSubscribe(Single.java:2649)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.delegateSubscribe(Single.java:2620)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SingleFlatMapCompletable.handleSubscribe(SingleFlatMapCompletable.java:43)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.lambda$subscribeWithContext$5(Completable.java:2242)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.ContextPreservingRunnable.run(ContextPreservingRunnable.java:46)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.subscribeWithContext(Completable.java:2242)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.subscribeInternal(Completable.java:1732)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SourceToFuture$CompletableToFuture.createAndSubscribe(SourceToFuture.java:162)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.toFuture(Completable.java:1705)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.http.api.StreamingHttpServiceToBlockingStreamingHttpService.handle(StreamingHttpServiceToBlockingStreamingHttpService.java:57)
~[servicetalk-http-api-0.42.18.jar:0.42.18]
at
io.servicetalk.http.api.BlockingStreamingToStreamingService$1.handleSubscribe(BlockingStreamingToStreamingService.java:130)
~[servicetalk-http-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.handleSubscribe(Single.java:2649)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SingleShareContextOnSubscribe.handleSubscribe(SingleShareContextOnSubscribe.java:38)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.subscribeWithContext(Single.java:2629)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.subscribeAndReturnContext(Single.java:2607)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.subscribeInternal(Single.java:1816)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SingleFlatMapSingle$SubscriberImpl.onSuccess(SingleFlatMapSingle.java:80)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.ContextPreservingSingleSubscriber.onSuccess(ContextPreservingSingleSubscriber.java:77)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.AbstractSubmitSingle.lambda$handleSubscribe$0(AbstractSubmitSingle.java:49)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.ContextPreservingRunnable.run(ContextPreservingRunnable.java:46)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
~[?:?]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
~[?:?]
at java.lang.Thread.run(Thread.java:833) ~[?:?]
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at end of
input
Position: 7
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
~[postgresql-42.5.0.jar:42.5.0]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295)
~[postgresql-42.5.0.jar:42.5.0]
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:244)
~[postgresql-42.5.0.jar:42.5.0]
at
com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110)
~[HikariCP-5.0.1.jar:?]
at
com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
~[HikariCP-5.0.1.jar:?]
at
org.apache.baremaps.database.tile.PostgresTileStore.read(PostgresTileStore.java:108)
~[baremaps-core-0.7.1-SNAPSHOT.jar:?]
... 50 more
[ERROR] 2023-01-28 20:29:21.942 [servicetalk-global-executor-1-5]
DevResources - Tile error
org.apache.baremaps.database.tile.TileStoreException:
org.postgresql.util.PSQLException: ERROR: syntax error at end of input
Position: 7
at
org.apache.baremaps.database.tile.PostgresTileStore.read(PostgresTileStore.java:122)
~[baremaps-core-0.7.1-SNAPSHOT.jar:?]
at
org.apache.baremaps.server.DevResources.getTile(DevResources.java:137)
~[baremaps-server-0.7.1-SNAPSHOT.jar:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
~[jersey-server-2.35.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
~[jersey-common-2.35.jar:?]
at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
~[jersey-common-2.35.jar:?]
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
~[jersey-common-2.35.jar:?]
at
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
~[jersey-server-2.35.jar:?]
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)
~[jersey-server-2.35.jar:?]
at
io.servicetalk.http.router.jersey.DefaultJerseyStreamingHttpRouter.handle0(DefaultJerseyStreamingHttpRouter.java:273)
~[servicetalk-http-router-jersey-0.42.18.jar:0.42.18]
at
io.servicetalk.http.router.jersey.DefaultJerseyStreamingHttpRouter.access$100(DefaultJerseyStreamingHttpRouter.java:79)
~[servicetalk-http-router-jersey-0.42.18.jar:0.42.18]
at
io.servicetalk.http.router.jersey.DefaultJerseyStreamingHttpRouter$3.handleSubscribe(DefaultJerseyStreamingHttpRouter.java:204)
~[servicetalk-http-router-jersey-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.handleSubscribe(Single.java:2649)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.delegateSubscribe(Single.java:2620)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SingleFlatMapCompletable.handleSubscribe(SingleFlatMapCompletable.java:43)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.lambda$subscribeWithContext$5(Completable.java:2242)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.ContextPreservingRunnable.run(ContextPreservingRunnable.java:46)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.subscribeWithContext(Completable.java:2242)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.subscribeInternal(Completable.java:1732)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SourceToFuture$CompletableToFuture.createAndSubscribe(SourceToFuture.java:162)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Completable.toFuture(Completable.java:1705)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.http.api.StreamingHttpServiceToBlockingStreamingHttpService.handle(StreamingHttpServiceToBlockingStreamingHttpService.java:57)
~[servicetalk-http-api-0.42.18.jar:0.42.18]
at
io.servicetalk.http.api.BlockingStreamingToStreamingService$1.handleSubscribe(BlockingStreamingToStreamingService.java:130)
~[servicetalk-http-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.handleSubscribe(Single.java:2649)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SingleShareContextOnSubscribe.handleSubscribe(SingleShareContextOnSubscribe.java:38)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.subscribeWithContext(Single.java:2629)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.subscribeAndReturnContext(Single.java:2607)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.Single.subscribeInternal(Single.java:1816)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.SingleFlatMapSingle$SubscriberImpl.onSuccess(SingleFlatMapSingle.java:80)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.ContextPreservingSingleSubscriber.onSuccess(ContextPreservingSingleSubscriber.java:77)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.AbstractSubmitSingle.lambda$handleSubscribe$0(AbstractSubmitSingle.java:49)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
io.servicetalk.concurrent.api.ContextPreservingRunnable.run(ContextPreservingRunnable.java:46)
~[servicetalk-concurrent-api-0.42.18.jar:0.42.18]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
~[?:?]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
~[?:?]
at java.lang.Thread.run(Thread.java:833) ~[?:?]
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at end of
input
Position: 7
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
~[postgresql-42.5.0.jar:42.5.0]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319)
~[postgresql-42.5.0.jar:42.5.0]
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295)
~[postgresql-42.5.0.jar:42.5.0]
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:244)
~[postgresql-42.5.0.jar:42.5.0]
at
com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110)
~[HikariCP-5.0.1.jar:?]
at
com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
~[HikariCP-5.0.1.jar:?]
at
org.apache.baremaps.database.tile.PostgresTileStore.read(PostgresTileStore.java:108)
~[baremaps-core-0.7.1-SNAPSHOT.jar:?]
... 50 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]
