Created
May 17, 2018 13:51
-
-
Save somadeaki/17c9b8e96d4782e68559ee830f4843d4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"key":"error/unhandled","requestId":"local:api:cjhaepfw702050760ixahj7mr","clientId":"****@dev","payload":{"exception":"java.sql.SQLTransactionRollbackException: (conn=682) Deadlock found when trying to get lock; try restarting transaction","query":"mutation ($_data: KeywordUpdateInput!, $_where: KeywordWhereUniqueInput!) {\n updateKeyword(data: $_data, where: $_where) {\n id\n }\n}\n","variables":"{\"_data\":{\"site\":{\"connect\":{\"id\":\"cjh9a2hre000b0760m0yq4mys\"}}},\"_where\":{\"key\":\"df974e160d9847d316c4fb748b903ba7e18a589ff119ceb779ff43831d915d4a\"}}","code":"0","stack_trace":"org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:165)\\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.first(Invoker.scala:31)\\n slick.jdbc.Invoker.first$(Invoker.scala:30)\\n slick.jdbc.StatementInvoker.first(StatementInvoker.scala:16)\\n slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:52)\\n slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:51)\\n slick.dbio.DBIOAction$$anon$4.$anonfun$run$3(DBIOAction.scala:240)\\n scala.collection.Iterator.foreach(Iterator.scala:929)\\n scala.collection.Iterator.foreach$(Iterator.scala:929)\\n scala.collection.AbstractIterator.foreach(Iterator.scala:1417)\\n scala.collection.IterableLike.foreach(IterableLike.scala:71)\\n scala.collection.IterableLike.foreach$(IterableLike.scala:70)\\n scala.collection.AbstractIterable.foreach(Iterable.scala:54)\\n slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:240)\\n slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:238)\\n slick.dbio.DBIOAction$$anon$4.$anonfun$run$3(DBIOAction.scala:240)\\n scala.collection.Iterator.foreach(Iterator.scala:929)\\n scala.collection.Iterator.foreach$(Iterator.scala:929)\\n scala.collection.AbstractIterator.foreach(Iterator.scala:1417)\\n scala.collection.IterableLike.foreach(IterableLike.scala:71)\\n scala.collection.IterableLike.foreach$(IterableLike.scala:70)\\n scala.collection.AbstractIterable.foreach(Iterable.scala:54)\\n slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:240)\\n slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:238)\\n slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.$anonfun$run$4(DBIOAction.scala:534)\\n slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.$anonfun$run$4$adapted(DBIOAction.scala:534)\\n scala.collection.Iterator.foreach(Iterator.scala:929)\\n scala.collection.Iterator.foreach$(Iterator.scala:929)\\n scala.collection.AbstractIterator.foreach(Iterator.scala:1417)\\n scala.collection.IterableLike.foreach(IterableLike.scala:71)\\n scala.collection.IterableLike.foreach$(IterableLike.scala:70)\\n scala.collection.AbstractIterable.foreach(Iterable.scala:54)\\n slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.run(DBIOAction.scala:534)\\n slick.dbio.SynchronousDatabaseAction$$anon$11.run(DBIOAction.scala:571)\\n slick.dbio.SynchronousDatabaseAction$$anon$6.run(DBIOAction.scala:470)\\n slick.dbio.SynchronousDatabaseAction$$anon$10.run(DBIOAction.scala:562)\\n slick.dbio.SynchronousDatabaseAction$$anon$7.run(DBIOAction.scala:487)\\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=682) Deadlock found when trying to get lock; try restarting transaction"}} | |
| [Bugsnag - local / testing] Error report: com.bugsnag.Report@13b4f2dc | |
| java.sql.SQLTransactionRollbackException: (conn=682) Deadlock found when trying to get lock; try restarting transaction | |
| at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:165) | |
| at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106) | |
| at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235) | |
| at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224) | |
| at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159) | |
| at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) | |
| at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) | |
| at slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39) | |
| at slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22) | |
| at slick.jdbc.Invoker.first(Invoker.scala:31) | |
| at slick.jdbc.Invoker.first$(Invoker.scala:30) | |
| at slick.jdbc.StatementInvoker.first(StatementInvoker.scala:16) | |
| at slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:52) | |
| at slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:51) | |
| at slick.dbio.DBIOAction$$anon$4.$anonfun$run$3(DBIOAction.scala:240) | |
| at scala.collection.Iterator.foreach(Iterator.scala:929) | |
| at scala.collection.Iterator.foreach$(Iterator.scala:929) | |
| at scala.collection.AbstractIterator.foreach(Iterator.scala:1417) | |
| at scala.collection.IterableLike.foreach(IterableLike.scala:71) | |
| at scala.collection.IterableLike.foreach$(IterableLike.scala:70) | |
| at scala.collection.AbstractIterable.foreach(Iterable.scala:54) | |
| at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:240) | |
| at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:238) | |
| at slick.dbio.DBIOAction$$anon$4.$anonfun$run$3(DBIOAction.scala:240) | |
| at scala.collection.Iterator.foreach(Iterator.scala:929) | |
| at scala.collection.Iterator.foreach$(Iterator.scala:929) | |
| at scala.collection.AbstractIterator.foreach(Iterator.scala:1417) | |
| at scala.collection.IterableLike.foreach(IterableLike.scala:71) | |
| at scala.collection.IterableLike.foreach$(IterableLike.scala:70) | |
| at scala.collection.AbstractIterable.foreach(Iterable.scala:54) | |
| at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:240) | |
| at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:238) | |
| at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.$anonfun$run$4(DBIOAction.scala:534) | |
| at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.$anonfun$run$4$adapted(DBIOAction.scala:534) | |
| at scala.collection.Iterator.foreach(Iterator.scala:929) | |
| at scala.collection.Iterator.foreach$(Iterator.scala:929) | |
| at scala.collection.AbstractIterator.foreach(Iterator.scala:1417) | |
| at scala.collection.IterableLike.foreach(IterableLike.scala:71) | |
| at scala.collection.IterableLike.foreach$(IterableLike.scala:70) | |
| at scala.collection.AbstractIterable.foreach(Iterable.scala:54) | |
| at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.run(DBIOAction.scala:534) | |
| at slick.dbio.SynchronousDatabaseAction$$anon$11.run(DBIOAction.scala:571) | |
| at slick.dbio.SynchronousDatabaseAction$$anon$6.run(DBIOAction.scala:470) | |
| at slick.dbio.SynchronousDatabaseAction$$anon$10.run(DBIOAction.scala:562) | |
| at slick.dbio.SynchronousDatabaseAction$$anon$7.run(DBIOAction.scala:487) | |
| at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240) | |
| at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240) | |
| at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) | |
| at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) | |
| at java.lang.Thread.run(Thread.java:748) | |
| Caused by: java.sql.SQLException: Deadlock found when trying to get lock; try restarting transaction | |
| Query is: insert into `marketmuse-gql@dev`.`_KeywordToSite` (`id`, `A`, `B`) Select 'cjhaepfwe02070760isac19hj', (SELECT `id` FROM (SELECT * FROM `marketmuse-gql@dev`.`Keyword`) IDFROMWHERE WHERE `key` = ?) , `id` FROM `marketmuse-gql@dev`.`Site` where `id` = ? on duplicate key update `marketmuse-gql@dev`.`_KeywordToSite`.id = `marketmuse-gql@dev`.`_KeywordToSite`.id, parameters ['df974e160d9847d316c4fb748b903ba7e18a589ff119ceb779ff43831d915d4a','cjh9a2hre000b0760m0yq4mys'] | |
| at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146) | |
| at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217) | |
| at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218) | |
| ... 46 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment