incubator-baremaps: OpenStreetMap example produces `syntax error`

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
About this issue

Original URL
State: closed
Created a year ago
Comments: 20 (12 by maintainers)
Most upvoted comments

I’ve tried to reproduce this with no success. I’d be happy to get on a call with someone to learn more about how it’s being recreated, how to solve it, etc.
joshfischer1108 on Mar 10, 2023
Ah, that’s definitely it! Let me see if I can chase this down. Seems like a good first issue.
tyrauber on Jan 29, 2023
Happy to help. It’s a really nice project. Very clean code and project structure, wide variety of functionality, and the documentation and examples are very simple to follow. If there is anything I can do to assist, please don’t hesitate to drop a note.
tyrauber on Jan 29, 2023