joshfischer1108 opened a new issue, #618:
URL: https://github.com/apache/incubator-baremaps/issues/618
I'm trying to run the ip to location example for `0.7.1-incubating` and ran
into some issues.
Steps to reproduce are below:
## set up postgres (I'm using a M1)
```
$ docker run \
--name baremaps \
--publish 5432:5432 \
-e POSTGRES_DB=baremaps \
-e POSTGRES_USER=baremaps \
-e POSTGRES_PASSWORD=baremaps \
-d ghcr.io/baosystems/postgis:latest
```
## execute the workflow
```
$ baremaps workflow execute --file examples/geocoding/workflow.js
```
## serve the data
```
$ baremaps iploc serve --database iploc.db --port 9000
```
## perform a search in the UI at at `localhost:9000` to cause the error
```
baremaps iploc serve --database iploc.db --port 9000
[INFO ] 2023-04-06 20:46:08.896 [main] HikariDataSource - HikariPool-1 -
Starting...
[INFO ] 2023-04-06 20:46:09.140 [main] HikariPool - HikariPool-1 - Added
connection org.sqlite.jdbc4.JDBC4Connection@3212a8d7
[INFO ] 2023-04-06 20:46:09.142 [main] HikariDataSource - HikariPool-1 -
Start completed.
[INFO ] 2023-04-06 20:46:10.185 [main] Serve - Listening on
/[0:0:0:0:0:0:0:0%0]:9000
[ERROR] 2023-04-06 20:46:36.055 [servicetalk-global-executor-1-1]
InetnumLocationDaoSqliteImpl - Unable to select inetnum locations
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no
such table: inetnum_locations)
at org.sqlite.core.DB.newSQLException(DB.java:1135)
~[sqlite-jdbc-3.39.3.0.jar:?]
at org.sqlite.core.DB.newSQLException(DB.java:1146)
~[sqlite-jdbc-3.39.3.0.jar:?]
at org.sqlite.core.DB.throwex(DB.java:1106)
~[sqlite-jdbc-3.39.3.0.jar:?]
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
~[sqlite-jdbc-3.39.3.0.jar:?]
at org.sqlite.core.NativeDB.prepare(NativeDB.java:122)
~[sqlite-jdbc-3.39.3.0.jar:?]
at org.sqlite.core.DB.prepare(DB.java:264) ~[sqlite-jdbc-3.39.3.0.jar:?]
at
org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:46)
~[sqlite-jdbc-3.39.3.0.jar:?]
at
org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:31)
~[sqlite-jdbc-3.39.3.0.jar:?]
at
org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:25)
~[sqlite-jdbc-3.39.3.0.jar:?]
at
org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:34)
~[sqlite-jdbc-3.39.3.0.jar:?]
at
org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226)
~[sqlite-jdbc-3.39.3.0.jar:?]
at
org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:206)
~[sqlite-jdbc-3.39.3.0.jar:?]
at
com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:327)
~[HikariCP-5.0.1.jar:?]
at
com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
~[HikariCP-5.0.1.jar:?]
at
org.apache.baremaps.iploc.database.InetnumLocationDaoSqliteImpl.findByIp(InetnumLocationDaoSqliteImpl.java:133)
~[baremaps-core-0.7.1.jar:?]
at
org.apache.baremaps.server.IplocResources.getIpToLocation(IplocResources.java:49)
~[baremaps-server-0.7.1.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) ~[?:?]
```
--
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]
