message ERROR: relation "devboxtoken" does not exist
ruscoder opened this issue · 1 comments
ruscoder commented
Sometimes I'm getting the error: message ERROR: relation "devboxtoken" does not exist.
Log:
devbox-db_1 | postgres & 0
devbox-db_1 | 2019-02-06 05:23:39.906 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
devbox-db_1 | 2019-02-06 05:23:39.907 UTC [1] LOG: listening on IPv6 address "::", port 5432
devbox-db_1 | 2019-02-06 05:23:39.911 UTC [1] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
devbox-db_1 | 2019-02-06 05:23:40.036 UTC [70] LOG: database system was shut down at 2019-02-06 05:23:38 UTC
devbox-db_1 | 2019-02-06 05:23:40.068 UTC [1] LOG: database system is ready to accept connections
devbox-db_1 | 2019-02-06 05:23:40.768 UTC [77] LOG: incomplete startup packet
devbox_1 | wait-for-it.sh: database:5432 is available after 20 seconds
devbox_1 | 05:23:56.422 [main] DEBUG com.zaxxer.hikari.HikariConfig - HikariPool-1 - configuration:
devbox_1 | 05:23:56.436 [main] DEBUG com.zaxxer.hikari.HikariConfig - allowPoolSuspension.............false
devbox_1 | 05:23:56.437 [main] DEBUG com.zaxxer.hikari.HikariConfig - autoCommit......................true
devbox_1 | 05:23:56.438 [main] DEBUG com.zaxxer.hikari.HikariConfig - catalog.........................null
devbox_1 | 05:23:56.439 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionInitSql..............."select 1"
devbox_1 | 05:23:56.440 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTestQuery.............null
devbox_1 | 05:23:56.441 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTimeout...............30000
devbox_1 | 05:23:56.441 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSource......................null
devbox_1 | 05:23:56.441 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceClassName............."org.postgresql.ds.PGSimpleDataSource"
devbox_1 | 05:23:56.442 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceJNDI..................null
devbox_1 | 05:23:56.451 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceProperties............{password=<masked>, url=jdbc:postgresql://database:5432/devbox?user=postgres&password=postgres&stringtype=unspecified}
devbox_1 | 05:23:56.452 [main] DEBUG com.zaxxer.hikari.HikariConfig - driverClassName.................null
devbox_1 | 05:23:56.453 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckProperties...........{}
devbox_1 | 05:23:56.454 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckRegistry.............null
devbox_1 | 05:23:56.454 [main] DEBUG com.zaxxer.hikari.HikariConfig - idleTimeout.....................10000
devbox_1 | 05:23:56.455 [main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailFast..........true
devbox_1 | 05:23:56.456 [main] DEBUG com.zaxxer.hikari.HikariConfig - isolateInternalQueries..........false
devbox_1 | 05:23:56.457 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbc4ConnectionTest.............false
devbox_1 | 05:23:56.459 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbcUrl.........................null
devbox_1 | 05:23:56.460 [main] DEBUG com.zaxxer.hikari.HikariConfig - leakDetectionThreshold..........0
devbox_1 | 05:23:56.460 [main] DEBUG com.zaxxer.hikari.HikariConfig - maxLifetime.....................1800000
devbox_1 | 05:23:56.462 [main] DEBUG com.zaxxer.hikari.HikariConfig - maximumPoolSize.................10
devbox_1 | 05:23:56.463 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricRegistry..................null
devbox_1 | 05:23:56.464 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricsTrackerFactory...........null
devbox_1 | 05:23:56.465 [main] DEBUG com.zaxxer.hikari.HikariConfig - minimumIdle.....................0
devbox_1 | 05:23:56.467 [main] DEBUG com.zaxxer.hikari.HikariConfig - password........................<masked>
devbox_1 | 05:23:56.470 [main] DEBUG com.zaxxer.hikari.HikariConfig - poolName........................"HikariPool-1"
devbox_1 | 05:23:56.473 [main] DEBUG com.zaxxer.hikari.HikariConfig - readOnly........................false
devbox_1 | 05:23:56.474 [main] DEBUG com.zaxxer.hikari.HikariConfig - registerMbeans..................false
devbox_1 | 05:23:56.475 [main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutorService........null
devbox_1 | 05:23:56.475 [main] DEBUG com.zaxxer.hikari.HikariConfig - threadFactory...................null
devbox_1 | 05:23:56.476 [main] DEBUG com.zaxxer.hikari.HikariConfig - transactionIsolation............null
devbox_1 | 05:23:56.478 [main] DEBUG com.zaxxer.hikari.HikariConfig - username........................null
devbox_1 | 05:23:56.479 [main] DEBUG com.zaxxer.hikari.HikariConfig - validationTimeout...............5000
devbox_1 | 05:23:56.485 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started.
devbox_1 | 05:23:56.816 [main] INFO com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Driver does not support get/set network timeout for connections. (Method org.postgresql.jdbc.PgConnection.getNetworkTimeout() is not yet implemented.)
devbox_1 | 05:23:56.881 [main] DEBUG clj-pg.honey - SELECT 1
devbox_1 | 05:23:56.935 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@6ca8bd14
devbox_1 | 05:23:57.040 [main] INFO clj-pg.honey - [151.0ms] [SELECT 1]
devbox_1 | 05:23:57.042 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=1, active=0, idle=1, waiting=0)
devbox_1 | 05:24:17.329 [main] DEBUG clj-pg.honey - select * from devboxtoken
devbox-db_1 | 2019-02-06 05:24:17.335 UTC [79] ERROR: relation "devboxtoken" does not exist at character 15
devbox-db_1 | 2019-02-06 05:24:17.335 UTC [79] STATEMENT: select * from devboxtoken
devbox_1 | 05:24:17.340 [main] ERROR clj-pg.honey - [11.0ms] [select * from devboxtoken]
devbox_1 | 05:24:17.365 [main] ERROR clj-pg.honey - #error {
devbox_1 | :cause ERROR: relation "devboxtoken" does not exist
devbox_1 | Position: 15
devbox_1 | :via
devbox_1 | [{:type org.postgresql.util.PSQLException
devbox_1 | :message ERROR: relation "devboxtoken" does not exist
devbox_1 | Position: 15
devbox_1 | :at [org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse QueryExecutorImpl.java 2458]}]
devbox_1 | :trace
devbox_1 | [[org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse QueryExecutorImpl.java 2458]
devbox_1 | [org.postgresql.core.v3.QueryExecutorImpl processResults QueryExecutorImpl.java 2158]
devbox_1 | [org.postgresql.core.v3.QueryExecutorImpl execute QueryExecutorImpl.java 291]
devbox_1 | [org.postgresql.jdbc.PgStatement executeInternal PgStatement.java 432]
devbox_1 | [org.postgresql.jdbc.PgStatement execute PgStatement.java 358]
devbox_1 | [org.postgresql.jdbc.PgPreparedStatement executeWithFlags PgPreparedStatement.java 171]
devbox_1 | [org.postgresql.jdbc.PgPreparedStatement executeQuery PgPreparedStatement.java 119]
devbox_1 | [com.zaxxer.hikari.pool.ProxyPreparedStatement executeQuery ProxyPreparedStatement.java 52]
devbox_1 | [com.zaxxer.hikari.pool.HikariProxyPreparedStatement executeQuery HikariProxyPreparedStatement.java -1]
devbox_1 | [clojure.java.jdbc$db_query_with_resultset$run_query_with_params__6712 invoke jdbc.clj 831]
devbox_1 | [clojure.java.jdbc$db_query_with_resultset invokeStatic jdbc.clj 850]
devbox_1 | [clojure.java.jdbc$db_query_with_resultset invoke jdbc.clj 818]
devbox_1 | [clojure.java.jdbc$query invokeStatic jdbc.clj 874]
devbox_1 | [clojure.java.jdbc$query invoke jdbc.clj 854]
devbox_1 | [clojure.java.jdbc$query invokeStatic jdbc.clj 867]
devbox_1 | [clojure.java.jdbc$query invoke jdbc.clj 854]
devbox_1 | [clj_pg.honey$query invokeStatic honey.clj 118]
devbox_1 | [clj_pg.honey$query invoke honey.clj 110]
devbox_1 | [clojure.lang.AFn applyToHelper AFn.java 156]
devbox_1 | [clojure.lang.RestFn applyTo RestFn.java 132]
devbox_1 | [clojure.core$apply invokeStatic core.clj 659]
devbox_1 | [clojure.core$apply invoke core.clj 652]
devbox_1 | [clj_pg.honey$query_first invokeStatic honey.clj 145]
devbox_1 | [clj_pg.honey$query_first doInvoke honey.clj 143]
devbox_1 | [clojure.lang.RestFn invoke RestFn.java 423]
devbox_1 | [license.client$restore_token invokeStatic client.clj 49]
devbox_1 | [license.client$restore_token invoke client.clj 48]
devbox_1 | [license.client$fn__26809 invokeStatic client.clj 105]
devbox_1 | [license.client$fn__26809 invoke client.clj 66]
devbox_1 | [clojure.lang.MultiFn invoke MultiFn.java 229]
devbox_1 | [unifn.core$_STAR_apply_impl$fn__4189 invoke core.clj 53]
devbox_1 | [unifn.core$_STAR_apply_impl invokeStatic core.clj 53]
devbox_1 | [unifn.core$_STAR_apply_impl invoke core.clj 35]
devbox_1 | [unifn.core$_STAR_apply invokeStatic core.clj 79]
devbox_1 | [unifn.core$_STAR_apply invoke core.clj 75]
devbox_1 | [unifn.core$_STAR_apply invokeStatic core.clj 84]
devbox_1 | [unifn.core$_STAR_apply invoke core.clj 75]
devbox_1 | [unifn.rest$dynamic_server invokeStatic rest.clj 99]
devbox_1 | [unifn.rest$dynamic_server invoke rest.clj 95]
devbox_1 | [devbox.core$restart invokeStatic core.clj 263]
devbox_1 | [devbox.core$restart doInvoke core.clj 261]
devbox_1 | [clojure.lang.RestFn invoke RestFn.java 397]
devbox_1 | [devbox.core$_main invokeStatic core.clj 269]
devbox_1 | [devbox.core$_main doInvoke core.clj 268]
devbox_1 | [clojure.lang.RestFn invoke RestFn.java 397]
devbox_1 | [clojure.lang.AFn applyToHelper AFn.java 152]
devbox_1 | [clojure.lang.RestFn applyTo RestFn.java 132]
devbox_1 | [devbox.core main nil -1]]}
devbox_1 | 05:24:17.386 [main] ERROR unifn.rest - Cannot start webserver: org.postgresql.util.PSQLException: ERROR: relation "devboxtoken" does not exist
devbox_1 | Position: 15
devbox_1 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:2458)
devbox_1 | org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java:2158)
devbox_1 | org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java:291)
devbox_1 | org.postgresql.jdbc.PgStatement.executeInternal (PgStatement.java:432)
devbox_1 | org.postgresql.jdbc.PgStatement.execute (PgStatement.java:358)
devbox_1 | org.postgresql.jdbc.PgPreparedStatement.executeWithFlags (PgPreparedStatement.java:171)
devbox_1 | org.postgresql.jdbc.PgPreparedStatement.executeQuery (PgPreparedStatement.java:119)
devbox_1 | com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery (ProxyPreparedStatement.java:52)
devbox_1 | com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery (HikariProxyPreparedStatement.java:-1)
devbox_1 | clojure.java.jdbc$db_query_with_resultset$run_query_with_params__6712.invoke (jdbc.clj:831)
devbox_1 | clojure.java.jdbc$db_query_with_resultset.invokeStatic (jdbc.clj:850)
devbox_1 | clojure.java.jdbc$db_query_with_resultset.invoke (jdbc.clj:818)
devbox_1 | clojure.java.jdbc$query.invokeStatic (jdbc.clj:874)
devbox_1 | clojure.java.jdbc$query.invoke (jdbc.clj:854)
devbox_1 | clojure.java.jdbc$query.invokeStatic (jdbc.clj:867)
devbox_1 | clojure.java.jdbc$query.invoke (jdbc.clj:854)
devbox_1 | clj_pg.honey$query.invokeStatic (honey.clj:118)
devbox_1 | clj_pg.honey$query.invoke (honey.clj:110)
devbox_1 | clojure.lang.AFn.applyToHelper (AFn.java:156)
devbox_1 | clojure.lang.RestFn.applyTo (RestFn.java:132)
devbox_1 | clojure.core$apply.invokeStatic (core.clj:659)
devbox_1 | clojure.core$apply.invoke (core.clj:652)
devbox_1 | clj_pg.honey$query_first.invokeStatic (honey.clj:145)
devbox_1 | clj_pg.honey$query_first.doInvoke (honey.clj:143)
devbox_1 | clojure.lang.RestFn.invoke (RestFn.java:423)
devbox_1 | license.client$restore_token.invokeStatic (client.clj:49)
devbox_1 | license.client$restore_token.invoke (client.clj:48)
devbox_1 | license.client$fn__26809.invokeStatic (client.clj:105)
devbox_1 | license.client/fn (client.clj:66)
devbox_1 | clojure.lang.MultiFn.invoke (MultiFn.java:229)
devbox_1 | unifn.core$_STAR_apply_impl$fn__4189.invoke (core.clj:53)
devbox_1 | unifn.core$_STAR_apply_impl.invokeStatic (core.clj:53)
devbox_1 | unifn.core$_STAR_apply_impl.invoke (core.clj:35)
devbox_1 | unifn.core$_STAR_apply.invokeStatic (core.clj:79)
devbox_1 | unifn.core$_STAR_apply.invoke (core.clj:75)
devbox_1 | unifn.core$_STAR_apply.invokeStatic (core.clj:84)
devbox_1 | unifn.core$_STAR_apply.invoke (core.clj:75)
devbox_1 | unifn.rest$dynamic_server.invokeStatic (rest.clj:99)
devbox_1 | unifn.rest$dynamic_server.invoke (rest.clj:95)
devbox_1 | devbox.core$restart.invokeStatic (core.clj:263)
devbox_1 | devbox.core$restart.doInvoke (core.clj:261)
devbox_1 | clojure.lang.RestFn.invoke (RestFn.java:397)
devbox_1 | devbox.core$_main.invokeStatic (core.clj:269)
devbox_1 | devbox.core$_main.doInvoke (core.clj:268)
devbox_1 | clojure.lang.RestFn.invoke (RestFn.java:397)
devbox_1 | clojure.lang.AFn.applyToHelper (AFn.java:152)
devbox_1 | clojure.lang.RestFn.applyTo (RestFn.java:132)
devbox_1 | devbox.core.main (:-1)
devbox_1 | nil
devbox_1 exited with code 0
znatty22 commented
@ruscoder I got this message when my Aidbox couldn't connect to the license server. I'm not sure about previous versions, but I know the latest release includes a message about this which is how I knew the devboxtoken does not exist error was related to that. This issue could probably be closed now?