Prisma1: The node-advanced template don't finishes installation

Created on 25 Feb 2018  ·  12Comments  ·  Source: prisma/prisma1

Bug Report

Current behavior
The node-advanced template don't finishes installation

Reproduction

mkdir test
cd test
prisma init .
# ❯ GraphQL server/fullstack boilerplate (recommended)
# ❯ node-advanced           GraphQL server (incl. database & authentication)
# ❯ local           Local cluster (requires Docker)

Afte picking local I get the error

ERROR: Whoops. Looks like an internal server error. Search your cluster logs for request ID: cluster:cluster:cje3dp1gt00030102w3xcd98n

{
  "data": {
    "addProject": null
  },
  "errors": [
    {
      "message": "Whoops. Looks like an internal server error. Search your cluster logs for request ID: cluster:cluster:cje3dp1gt00030102w3xcd98n",
      "path": [
        "addProject"
      ],
      "locations": [
        {
          "line": 2,
          "column": 9
        }
      ],
      "requestId": "cluster:cluster:cje3dp1gt00030102w3xcd98n"
    }
  ],
  "status": 200
}

Expected behavior?
The installation of the template finish and I can start using prisma.

bu2-confirmed
Source
picture ellipticaldoor
👍1

All 12 comments

how does your prisma.yml file look like?

marktani picture marktani on 26 Feb 2018

Like this

# the name for the service (will be part of the service's HTTP endpoint)
service: test

# the cluster and stage the service is deployed to
stage: ${env:PRISMA_STAGE}

# to disable authentication:
# disableAuth: true
secret: ${env:PRISMA_SECRET}

# the file path pointing to your data model
datamodel: datamodel.graphql

# seed your service with initial data based on seed.graphql
seed:
  import: seed.graphql

cluster: ${env:PRISMA_CLUSTER}
ellipticaldoor picture ellipticaldoor on 26 Feb 2018

I'm getting the same error for TypeScript boilerplate as well.

bermanboris picture bermanboris on 28 Feb 2018
👍1

I am having the same error as well. (Typescript advanced), has anyone figured out a workaround? I would really like to get started with Prisma, I can update with more info this evening.

vlutton picture vlutton on 28 Feb 2018

Hey @ellipticaldoor, @bermanboris, @vlutton, this is not happening to me. Can you help me reproduce this?

marktani picture marktani on 1 Mar 2018

Sure thing @marktani! Just tell us what information you need.

bermanboris picture bermanboris on 1 Mar 2018

Thanks! Here are a couple of question as a start:

  • Are you all deploying to the local cluster?
  • What is your prisma version?
  • What is your prisma cluster list?
  • If deploying locally, what is prisma cluster logs?

  • Upgrade all your versions to the latest:

    npm install -g prisma graphql-cli
prisma local upgrade

    Can you still reproduce the issue then?

marktani picture marktani on 1 Mar 2018

Ran the commands to upgrade everything to latest. Still getting the error.

  • Yes, I am deploying to local cluster, when I tried deploying to cloud, it completed, but did not generate any schema.
  • My prisma version is: prisma/1.3.2 (darwin-x64) node-v8.9.4
  • prisma cluster list output is:
name        version  endpoint
──────────  ───────  ─────────────────────────────
local       1.3.2    http://localhost:4466/cluster
prisma-eu1  1.3.2    https://eu1.prisma.sh/cluster
prisma-us1  1.3.2    https://us1.prisma.sh/cluster
  • Here are the logs (wall of text):
 ➜ prisma cluster logs
Loading logs from docker ✔
Attaching to prisma-db, local_prisma-database_1
prisma-database_1  | Listening for transport dt_socket at address: 8000
prisma-database_1  | Obtaining exclusive agent lock...
prisma-database_1  | Obtaining exclusive agent lock... Successful.
prisma-database_1  | Deployment worker initialization complete.
prisma-database_1  | Initializing workers...
prisma-database_1  | Successfully started 1 workers.
prisma-database_1  | Server running on :4466
prisma-database_1  | Version is up to date.
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:38.547+00:00","@version":1,"message":"{\"key\":\"request/new\",\"requestId\":\"cluster:cluster:cje8gbobe00000116d9dqgj9a\"}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-19","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | [Metrics] Warning: no metrics will be recorded.
prisma-database_1  | MemoryAllocationMetrics are enabled: true
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:39.659+00:00","@version":1,"message":"{\"key\":\"request/complete\",\"requestId\":\"cluster:cluster:cje8gbobe00000116d9dqgj9a\",\"payload\":{\"request_duration\":\"1135\"}}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-30","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:39.697+00:00","@version":1,"message":"{\"key\":\"request/new\",\"requestId\":\"cluster:cluster:cje8gbp8100010116n8ylbpdk\"}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-19","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:39.719+00:00","@version":1,"message":"{\"key\":\"request/complete\",\"requestId\":\"cluster:cluster:cje8gbp8100010116n8ylbpdk\",\"payload\":{\"request_duration\":\"22\"}}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-30","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:39.739+00:00","@version":1,"message":"{\"key\":\"request/new\",\"requestId\":\"cluster:cluster:cje8gbp96000201161jyl3g7q\"}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-30","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"key":"error/unhandled","requestId":"cluster:cluster:cje8gbp96000201161jyl3g7q","payload":{"exception":"java.sql.SQLSyntaxErrorException: (conn=15) Unknown column 'x2.ownerId' in 'field list'","query":"\n      query($name: String! $stage: String!) {\n        project(name: $name stage: $stage) {\n          name\n          stage\n        }\n      }\n    ","variables":"{\"name\":\"prisma-server\",\"stage\":\"dev\"}","code":"0","stack_trace":"org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:163)\\n org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)\\n org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)\\n org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)\\n org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)\\n com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)\\n com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)\\n slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)\\n slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)\\n slick.jdbc.Invoker.foreach(Invoker.scala:48)\\n slick.jdbc.Invoker.foreach$(Invoker.scala:47)\\n slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)\\n slick.jdbc.Invoker.firstOption(Invoker.scala:24)\\n slick.jdbc.Invoker.firstOption$(Invoker.scala:22)\\n slick.jdbc.StatementInvoker.firstOption(StatementInvoker.scala:16)\\n slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:57)\\n slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:56)\\n slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)\\n slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)\\n java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\\n java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\\n java.lang.Thread.run(Thread.java:748)","message":"(conn=15) Unknown column 'x2.ownerId' in 'field list'"}}
prisma-database_1  | java.sql.SQLSyntaxErrorException: (conn=15) Unknown column 'x2.ownerId' in 'field list'
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:163)
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
prisma-database_1  |    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
prisma-database_1  |    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
prisma-database_1  |    at slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)
prisma-database_1  |    at slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
prisma-database_1  |    at slick.jdbc.Invoker.foreach(Invoker.scala:48)
prisma-database_1  |    at slick.jdbc.Invoker.foreach$(Invoker.scala:47)
prisma-database_1  |    at slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption(Invoker.scala:24)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption$(Invoker.scala:22)
prisma-database_1  |    at slick.jdbc.StatementInvoker.firstOption(StatementInvoker.scala:16)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:57)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:56)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
prisma-db          | 2018-03-01T11:50:59.084522Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
prisma-db          | 2018-03-01T11:50:59.085916Z 0 [Note] mysqld (mysqld 5.7.21) starting as process 1 ...
prisma-database_1  |    at java.lang.Thread.run(Thread.java:748)
prisma-db          | 2018-03-01T11:50:59.089388Z 0 [Note] InnoDB: PUNCH HOLE support available
prisma-database_1  | Caused by: java.sql.SQLException: Unknown column 'x2.ownerId' in 'field list'
prisma-db          | 2018-03-01T11:50:59.089427Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
prisma-database_1  | Query is: select x2.`id`, x2.`webhookUrl`, x2.`ownerId`, x2.`secrets`, x2.`allowQueries`, x2.`allowMutations`, x2.`functions`, x3.`projectId`, x3.`revision`, x3.`schema`, x3.`functions`, x3.`status`, x3.`applied`, x3.`rolledBack`, x3.`steps`, x3.`errors`, x3.`startedAt`, x3.`finishedAt` from `Project` x2, `Migration` x3 where ((x3.`projectId` = 'prisma-server@dev') and (x2.`id` = 'prisma-server@dev')) and (x3.`status` = 'SUCCESS') order by x3.`revision` desc limit 1
prisma-db          | 2018-03-01T11:50:59.089435Z 0 [Note] InnoDB: Uses event mutexes
prisma-database_1  |    at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
prisma-db          | 2018-03-01T11:50:59.089441Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
prisma-database_1  |    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
prisma-db          | 2018-03-01T11:50:59.089448Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
prisma-db          | 2018-03-01T11:50:59.089453Z 0 [Note] InnoDB: Using Linux native AIO
prisma-database_1  |    ... 18 more
prisma-db          | 2018-03-01T11:50:59.089903Z 0 [Note] InnoDB: Number of pools: 1
prisma-database_1  | java.sql.SQLSyntaxErrorException: (conn=15) Unknown column 'x2.ownerId' in 'field list'
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:163)
prisma-db          | 2018-03-01T11:50:59.090016Z 0 [Note] InnoDB: Using CPU crc32 instructions
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)
prisma-db          | 2018-03-01T11:50:59.091589Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
prisma-database_1  |    at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
prisma-db          | 2018-03-01T11:50:59.098166Z 0 [Note] InnoDB: Completed initialization of buffer pool
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
prisma-db          | 2018-03-01T11:50:59.100181Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
prisma-db          | 2018-03-01T11:50:59.117863Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
prisma-database_1  | [Bugsnag - local / testing] Error report: com.bugsnag.Report@18bf5977
prisma-db          | 2018-03-01T11:50:59.160350Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
prisma-database_1  |    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
prisma-db          | 2018-03-01T11:50:59.160436Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
prisma-db          | 2018-03-01T11:50:59.199153Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
prisma-database_1  |    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
prisma-db          | 2018-03-01T11:50:59.200113Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
prisma-db          | 2018-03-01T11:50:59.200156Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
prisma-database_1  |    at slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)
prisma-db          | 2018-03-01T11:50:59.201139Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 15018237
prisma-db          | 2018-03-01T11:50:59.201488Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
prisma-db          | 2018-03-01T11:50:59.201643Z 0 [Note] Plugin 'FEDERATED' is disabled.
prisma-db          | 2018-03-01T11:50:59.207685Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
prisma-database_1  |    at slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
prisma-db          | 2018-03-01T11:50:59.207970Z 0 [Warning] CA certificate ca.pem is self signed.
prisma-db          | 2018-03-01T11:50:59.215497Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
prisma-db          | 2018-03-01T11:50:59.215643Z 0 [Note] IPv6 is available.
prisma-database_1  |    at slick.jdbc.Invoker.foreach(Invoker.scala:48)
prisma-db          | 2018-03-01T11:50:59.215670Z 0 [Note]   - '::' resolves to '::';
prisma-db          | 2018-03-01T11:50:59.215686Z 0 [Note] Server socket created on IP: '::'.
prisma-db          | 2018-03-01T11:50:59.220512Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180301 11:50:59
prisma-db          | 2018-03-01T11:50:59.220977Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
prisma-db          | 2018-03-01T11:50:59.221018Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
prisma-db          | 2018-03-01T11:50:59.221027Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
prisma-db          | 2018-03-01T11:50:59.221053Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
prisma-database_1  |    at slick.jdbc.Invoker.foreach$(Invoker.scala:47)
prisma-db          | 2018-03-01T11:50:59.221067Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
prisma-db          | 2018-03-01T11:50:59.221205Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
prisma-database_1  |    at slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
prisma-db          | 2018-03-01T11:50:59.228491Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
prisma-db          | 2018-03-01T11:50:59.228526Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
prisma-db          | 2018-03-01T11:50:59.234218Z 0 [Note] Event Scheduler: Loaded 0 events
prisma-db          | 2018-03-01T11:50:59.234691Z 0 [Note] mysqld: ready for connections.
prisma-db          | Version: '5.7.21'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption(Invoker.scala:24)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption$(Invoker.scala:22)
prisma-database_1  |    at slick.jdbc.StatementInvoker.firstOption(StatementInvoker.scala:16)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:57)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:56)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
prisma-database_1  |    at java.lang.Thread.run(Thread.java:748)
prisma-database_1  | Caused by: java.sql.SQLException: Unknown column 'x2.ownerId' in 'field list'
prisma-database_1  | Query is: select x2.`id`, x2.`webhookUrl`, x2.`ownerId`, x2.`secrets`, x2.`allowQueries`, x2.`allowMutations`, x2.`functions`, x3.`projectId`, x3.`revision`, x3.`schema`, x3.`functions`, x3.`status`, x3.`applied`, x3.`rolledBack`, x3.`steps`, x3.`errors`, x3.`startedAt`, x3.`finishedAt` from `Project` x2, `Migration` x3 where ((x3.`projectId` = 'prisma-server@dev') and (x2.`id` = 'prisma-server@dev')) and (x3.`status` = 'SUCCESS') order by x3.`revision` desc limit 1
prisma-database_1  |    at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
prisma-database_1  |    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
prisma-database_1  |    ... 18 more
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:40.468+00:00","@version":1,"message":"{\"key\":\"request/complete\",\"requestId\":\"cluster:cluster:cje8gbp96000201161jyl3g7q\",\"payload\":{\"request_duration\":\"729\"}}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-30","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:40.498+00:00","@version":1,"message":"{\"key\":\"request/new\",\"requestId\":\"cluster:cluster:cje8gbpu9000301167c742fij\"}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-19","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"key":"error/unhandled","requestId":"cluster:cluster:cje8gbpu9000301167c742fij","payload":{"exception":"java.sql.SQLSyntaxErrorException: (conn=15) Unknown column 'x2.ownerId' in 'field list'","query":"      mutation addProject($name: String! $stage: String! $secrets: [String!]) {\n        addProject(input: {\n          name: $name,\n          stage: $stage\n          secrets: $secrets\n        }) {\n          project {\n            name\n          }\n        }\n      }\n      ","variables":"{\"name\":\"prisma-server\",\"stage\":\"dev\",\"secrets\":[\"mysecret123\"]}","code":"0","stack_trace":"org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:163)\\n org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)\\n org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)\\n org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)\\n org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)\\n com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)\\n com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)\\n slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)\\n slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)\\n slick.jdbc.Invoker.foreach(Invoker.scala:48)\\n slick.jdbc.Invoker.foreach$(Invoker.scala:47)\\n slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)\\n slick.jdbc.Invoker.firstOption(Invoker.scala:24)\\n slick.jdbc.Invoker.firstOption$(Invoker.scala:22)\\n slick.jdbc.StatementInvoker.firstOption(StatementInvoker.scala:16)\\n slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:57)\\n slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:56)\\n slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)\\n slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)\\n java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\\n java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\\n java.lang.Thread.run(Thread.java:748)","message":"(conn=15) Unknown column 'x2.ownerId' in 'field list'"}}
prisma-database_1  | java.sql.SQLSyntaxErrorException: (conn=15) Unknown column 'x2.ownerId' in 'field list'
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:163)
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
prisma-database_1  |    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
prisma-database_1  |    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
prisma-database_1  |    at slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)
prisma-database_1  |    at slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
prisma-database_1  |    at slick.jdbc.Invoker.foreach(Invoker.scala:48)
prisma-database_1  |    at slick.jdbc.Invoker.foreach$(Invoker.scala:47)
prisma-database_1  |    at slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption(Invoker.scala:24)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption$(Invoker.scala:22)
prisma-database_1  |    at slick.jdbc.StatementInvoker.firstOption(StatementInvoker.scala:16)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:57)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:56)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
prisma-database_1  |    at java.lang.Thread.run(Thread.java:748)
prisma-database_1  | Caused by: java.sql.SQLException: Unknown column 'x2.ownerId' in 'field list'
prisma-database_1  | Query is: select x2.`id`, x2.`webhookUrl`, x2.`ownerId`, x2.`secrets`, x2.`allowQueries`, x2.`allowMutations`, x2.`functions`, x3.`projectId`, x3.`revision`, x3.`schema`, x3.`functions`, x3.`status`, x3.`applied`, x3.`rolledBack`, x3.`steps`, x3.`errors`, x3.`startedAt`, x3.`finishedAt` from `Project` x2, `Migration` x3 where ((x3.`projectId` = 'prisma-server@dev') and (x2.`id` = 'prisma-server@dev')) and (x3.`status` = 'SUCCESS') order by x3.`revision` desc limit 1
prisma-database_1  |    at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
prisma-database_1  |    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
prisma-database_1  |    ... 18 more
prisma-database_1  | [Bugsnag - local / testing] Error report: com.bugsnag.Report@3b7999a3
prisma-database_1  | java.sql.SQLSyntaxErrorException: (conn=15) Unknown column 'x2.ownerId' in 'field list'
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:163)
prisma-database_1  |    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
prisma-database_1  |    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
prisma-database_1  |    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
prisma-database_1  |    at slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)
prisma-database_1  |    at slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
prisma-database_1  |    at slick.jdbc.Invoker.foreach(Invoker.scala:48)
prisma-database_1  |    at slick.jdbc.Invoker.foreach$(Invoker.scala:47)
prisma-database_1  |    at slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption(Invoker.scala:24)
prisma-database_1  |    at slick.jdbc.Invoker.firstOption$(Invoker.scala:22)
prisma-database_1  |    at slick.jdbc.StatementInvoker.firstOption(StatementInvoker.scala:16)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:57)
prisma-database_1  |    at slick.jdbc.StreamingInvokerAction$HeadOptionAction.run(StreamingInvokerAction.scala:56)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
prisma-database_1  |    at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
prisma-database_1  |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
prisma-database_1  |    at java.lang.Thread.run(Thread.java:748)
prisma-database_1  | Caused by: java.sql.SQLException: Unknown column 'x2.ownerId' in 'field list'
prisma-database_1  | Query is: select x2.`id`, x2.`webhookUrl`, x2.`ownerId`, x2.`secrets`, x2.`allowQueries`, x2.`allowMutations`, x2.`functions`, x3.`projectId`, x3.`revision`, x3.`schema`, x3.`functions`, x3.`status`, x3.`applied`, x3.`rolledBack`, x3.`steps`, x3.`errors`, x3.`startedAt`, x3.`finishedAt` from `Project` x2, `Migration` x3 where ((x3.`projectId` = 'prisma-server@dev') and (x2.`id` = 'prisma-server@dev')) and (x3.`status` = 'SUCCESS') order by x3.`revision` desc limit 1
prisma-database_1  |    at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
prisma-database_1  |    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
prisma-database_1  |    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
prisma-database_1  |    ... 18 more
prisma-database_1  | {"@timestamp":"2018-03-01T11:53:40.802+00:00","@version":1,"message":"{\"key\":\"request/complete\",\"requestId\":\"cluster:cluster:cje8gbpu9000301167c742fij\",\"payload\":{\"request_duration\":\"304\"}}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-19","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:55:01.042+00:00","@version":1,"message":"{\"key\":\"request/new\",\"requestId\":\"cluster:cluster:cje8gdfzl00040116bz3tcyjg\"}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-16","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:55:01.053+00:00","@version":1,"message":"{\"key\":\"request/complete\",\"requestId\":\"cluster:cluster:cje8gdfzl00040116bz3tcyjg\",\"payload\":{\"request_duration\":\"10\"}}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-31","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:55:43.351+00:00","@version":1,"message":"{\"key\":\"request/new\",\"requestId\":\"cluster:cluster:cje8gecmu00050116jdarhorm\"}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-30","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}
prisma-database_1  | {"@timestamp":"2018-03-01T11:55:43.363+00:00","@version":1,"message":"{\"key\":\"request/complete\",\"requestId\":\"cluster:cluster:cje8gecmu00050116jdarhorm\",\"payload\":{\"request_duration\":\"12\"}}","logger_name":"com.prisma.deploy.server.ClusterServer","thread_name":"single-server-akka.actor.default-dispatcher-2","level":"INFO","level_value":20000,"HOSTNAME":"82d473ccb712"}

Also, getting this error when first running prisma init test-server:

config HOME /Users/vlutton +2ms
  config TypeError: Path must be a string. Received null
  config     at assertPath (path.js:28:11)
  config     at Object.resolve (path.js:1181:7)
  config     at Object.findGraphQLConfigFile (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/graphql-config/lib/findGraphQLConfigFile.js:13:23)
  config     at Object.getGraphQLConfig (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/graphql-config/lib/getGraphQLConfig.js:8:46)
  config     at Config.getDefinitionPathByGraphQLConfig (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/prisma-cli-engine/src/Config.ts:179:22)
  config     at Config.setDefinitionPaths (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/prisma-cli-engine/src/Config.ts:161:34)
  config     at new Config (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/prisma-cli-engine/src/Config.ts:73:10)
  config     at new CLI (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/prisma-cli-engine/src/CLI.ts:83:19)
  config     at /Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/prisma-cli-engine/src/CLI.ts:275:17
  config     at bound (domain.js:303:14)
  config     at runBound (domain.js:314:12)
  config     at Raven.context (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/raven/lib/client.js:390:33)
  config     at Object.run (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/node_modules/prisma-cli-engine/src/CLI.ts:274:9)
  config     at Object.<anonymous> (/Users/vlutton/.nvm/versions/node/v8.9.4/lib/node_modules/prisma/src/index.ts:21:1)
  config     at Module._compile (module.js:643:30)
  config     at Object.Module._extensions..js (module.js:654:10)
  config     at Module.load (module.js:556:32)
  config     at tryModuleLoad (module.js:499:12)
  config     at Function.Module._load (module.js:491:3)
  config     at Function.Module.runMain (module.js:684:10)
  config     at startup (bootstrap_node.js:187:16)
  config     at bootstrap_node.js:608:3 +1ms
  config definitionDir /Users/vlutton/test/timecapsule +7ms
  config definitionPath null +0ms
  • docker ps output:
CONTAINER ID        IMAGE                      COMMAND                  CREATED             STATUS              PORTS                    NAMES
1a74e5768df8        prismagraphql/prisma:1.3   "/app/bin/prisma-loc…"   10 minutes ago      Up 10 minutes       0.0.0.0:4466->4466/tcp   local_prisma-database_1
1fd84508bae9        mysql:5.7                  "docker-entrypoint.s…"   26 minutes ago      Up 12 minutes       0.0.0.0:3307->3306/tcp   prisma-db

Thank you! I have been really impressed with graphcool framework, but it looks like prisma will be closer to what I need, I am hoping I can get it working soon. I will continue troubleshooting from my side to see if I can figure out why this issue is happening.

vlutton picture vlutton on 1 Mar 2018

Thanks @vlutton! I'm certain we'll get you there soon 🙂
Looks like you are encountering a similar problem as described here.

You can run prisma local nuke to wipe your internal database and all local data.
This provides a quick way of getting back in a consistent state when in development.

If you need to preserve your data, you can also compare the schema in the Prisma database to the actual database structure and patch that up manually. We'll provide tooling soon that helps with getting visibility into such issues, and getting back into a consistent state more easily.

@ellipticaldoor, @bermanboris, curious to hear if that's the same issue you are encountering, and if the solution above solves it for you 🙂

marktani picture marktani on 1 Mar 2018

@marktani That worked for me! I appreciate it!

vlutton picture vlutton on 1 Mar 2018
👍1

@marktani works fine now :)

ellipticaldoor picture ellipticaldoor on 10 Mar 2018

Woop woop!

marktani picture marktani on 10 Mar 2018
Was this page helpful?
0 / 5 - 0 ratings

Related issues

schickling picture schickling  ·  3Comments
schickling picture schickling  ·  3Comments
MitkoTschimev picture MitkoTschimev  ·  3Comments
Fi1osof picture Fi1osof  ·  3Comments
AlessandroAnnini picture AlessandroAnnini  ·  3Comments