Skip to content

Instantly share code, notes, and snippets.

@serjs
Created August 5, 2016 18:18
Show Gist options
  • Save serjs/1acbec997c4d2c40ace8f6519e9fd131 to your computer and use it in GitHub Desktop.
Save serjs/1acbec997c4d2c40ace8f6519e9fd131 to your computer and use it in GitHub Desktop.
gestalt_errors
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obcffd - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.019s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.004s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obcnhp - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.028s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.005s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obd5j3 - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.017s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.005s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obddkb - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.021s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.005s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obdln8 - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.021s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.005s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obe3ok - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.020s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.008s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obec1o - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.035s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.009s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - did not find credentials in request Authorization header
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obek7c - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.018s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.005s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
[info]: application - found Basic credentials; will validate against gestalt-security
ResourceFactory.findByPropertyValue(23ba3299-b04e-4c5c-9b3d-64939b22944e, fqon, root)
[error]: s.StatementExecutor$$anon$1 - SQL execution failed (Reason: ERROR: relation "resource_instance" does not exist
Position: 22):
SELECT * FROM resource_instance WHERE properties -> 'fqon' = 'root' AND resource_type_id = 23ba3299-b04e-4c5c-9b3d-64939b22944e::UUID
[error]: play - Cannot invoke the action, eventually got an error: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
[error]: application -
! @711obf2n9 - Internal server error, for (GET) [/root] ->
play.api.Application$$anon$1: Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3$$anonfun$applyOrElse$4.apply(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.Option.map(Option.scala:146) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:320) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$3.applyOrElse(PlayDefaultUpstreamHandler.scala:316) [com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:346) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$recoverWith$1.apply(Future.scala:345) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) [com.typesafe.play.play-iteratees_2.11-2.3.10.jar:2.3.10]
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:40) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:248) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Promise$class.complete(Promise.scala:55) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:153) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$map$1.apply(Future.scala:237) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.processBatch$1(BatchingExecutor.scala:67) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:82) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.BatchingExecutor$Batch$$anonfun$run$1.apply(BatchingExecutor.scala:59) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72) [org.scala-lang.scala-library-2.11.8.jar:na]
at akka.dispatch.BatchingExecutor$Batch.run(BatchingExecutor.scala:58) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) [com.typesafe.akka.akka-actor_2.11-2.3.4.jar:na]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) [org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) [org.scala-lang.scala-library-2.11.8.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[org.postgresql.postgresql-9.3-1102-jdbc4.jar:na]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp.commons-dbcp-1.4.jar:1.4]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anonfun$executeQuery$1.apply(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$NakedExecutor.apply(StatementExecutor.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLAndTiming$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLAndTiming$class.apply(StatementExecutor.scala:250) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.scalikejdbc$StatementExecutor$LoggingSQLIfFailed$$super$apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$LoggingSQLIfFailed$class.apply(StatementExecutor.scala:283) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor$$anon$1.apply(StatementExecutor.scala:306) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.StatementExecutor.executeQuery(StatementExecutor.scala:322) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:205) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:204) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.scalikejdbc$DBSession$$super$using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.using(DBSession.scala:30) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.using(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBSession$class.single(DBSession.scala:203) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.ActiveSession.single(DBSession.scala:548) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOption$class.result(SQL.scala:688) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.result(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$$anonfun$9.apply(SQL.scala:542) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DBConnection$class.readOnly(DBConnection.scala:191) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB.readOnly(DB.scala:60) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:173) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$$anonfun$readOnly$1.apply(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.LoanPattern$class.using(LoanPattern.scala:18) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.using(DB.scala:138) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.DB$.readOnly(DB.scala:172) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToResult$class.apply(SQL.scala:545) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:703) ~[org.scalikejdbc.scalikejdbc-core_2.11-2.2.6.jar:2.2.6]
at com.galacticfog.gestalt.data.ResourceFactory$.findByPropertyValue(ResourceFactory.scala:396) ~[com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.orgFqon(MetaController.scala:170) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.orgFqon(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.util.MetaController$class.fqid(MetaController.scala:427) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$.fqid(ResourceController.scala:60) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:134) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at controllers.ResourceController$$anonfun$getOrgFqon$1.apply(ResourceController.scala:133) ~[com.galacticfog.gestalt-meta-0.3.3-SNAPSHOT.jar:0.3.3-SNAPSHOT]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:433) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at play.api.mvc.ActionBuilder$$anonfun$apply$16.apply(Action.scala:432) ~[com.typesafe.play.play_2.11-2.3.10.jar:2.3.10]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:31) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at com.galacticfog.gestalt.security.play.silhouette.GestaltFrameworkSecuredController$GestaltFrameworkAuthActionBuilder$$anonfun$invokeBlock$2.apply(GestaltFrameworkSecuredController.scala:30) ~[com.galacticfog.gestalt-security-play_2.11-2.2.4-SNAPSHOT.jar:2.2.4-SNAPSHOT]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253) ~[org.scala-lang.scala-library-2.11.8.jar:na]
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251) ~[org.scala-lang.scala-library-2.11.8.jar:na]
... 13 common frames omitted
[error]: application - Execution exception[[PSQLException: ERROR: relation "resource_instance" does not exist
Position: 22]]
[info]: application - found Basic credentials; will validate against gestalt-security
[info]: application - Using Environment Database Info.
[info]: application -
EnvConfig(
database = jdbc:postgresql://192.168.65.200:5432/gestalt-meta?user=express42&password=*****,
apigateway = http://192.168.65.200:6473,
lambda = http://192.168.65.200:1111,
security = http://192.168.65.200:9455,
events = {
"url" : "amqp://192.168.65.200:5672",
"exchange" : "policy-exchange",
"route" : "policy"
})
[info]: o.f.c.i.dbsupport.DbSupportFactory - Database: jdbc:postgresql://192.168.65.200:5432/gestalt-meta (PostgreSQL 9.4)
[info]: o.f.c.i.c.SqlScriptFlywayCallback - Executing SQL callback: beforeClean
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "hstore" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "pgcrypto" does not exist, skipping
[info]: o.f.c.i.dbsupport.JdbcTemplate - DB: extension "uuid-ossp" does not exist, skipping
[info]: o.f.core.internal.command.DbClean - Successfully cleaned schema "public" (execution time 00:00.021s)
[info]: o.f.c.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.010s)
[info]: o.f.c.i.m.MetaDataTableImpl - Creating Metadata table: "public"."schema_version"
[info]: o.f.core.internal.command.DbMigrate - Current version of schema "public": << Empty Schema >>
[info]: o.f.core.internal.command.DbMigrate - Migrating schema "public" to version 1 - create reference
[error]: o.f.core.internal.command.DbMigrate - Migration of schema "public" to version 1 - create reference failed! Changes successfully rolled back.
[error]: controllers.BootstrapController$ - Could not rebuild Meta DB:
Migration V1__create_reference.sql failed
-----------------------------------------
SQL State : 42704
Error Code : 0
Message : ERROR: role "gestaltdev" does not exist
Location : db/migration/V1__create_reference.sql (/opt/docker/file:/opt/docker/lib/com.galacticfog.gestalt-meta-repository_2.11-0.3.3-SNAPSHOT.jar!/db/migration/V1__create_reference.sql)
Line : 34
Statement : ALTER TABLE data_type OWNER TO gestaltdev
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment