can't save update to method config

Post author
Laura Gauthier

I made changes to the method in the Broad methods repo and now that I'm trying to update the config, it times out with the following error:

 

{ "causes": [], "exceptionClass": "com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException", "message": "Lock wait timeout exceeded; try restarting transaction", "source": "rawls", "stackTrace": [ { "className": "jdk.internal.reflect.GeneratedConstructorAccessor680", "fileName": null, "lineNumber": -1, "methodName": "newInstance" }, { "className": "jdk.internal.reflect.DelegatingConstructorAccessorImpl", "fileName": null, "lineNumber": -1, "methodName": "newInstance" }, { "className": "java.lang.reflect.Constructor", "fileName": null, "lineNumber": -1, "methodName": "newInstance" }, { "className": "com.mysql.jdbc.Util", "fileName": "Util.java", "lineNumber": 425, "methodName": "handleNewInstance" }, { "className": "com.mysql.jdbc.Util", "fileName": "Util.java", "lineNumber": 408, "methodName": "getInstance" }, { "className": "com.mysql.jdbc.SQLError", "fileName": "SQLError.java", "lineNumber": 951, "methodName": "createSQLException" }, { "className": "com.mysql.jdbc.MysqlIO", "fileName": "MysqlIO.java", "lineNumber": 3973, "methodName": "checkErrorPacket" }, { "className": "com.mysql.jdbc.MysqlIO", "fileName": "MysqlIO.java", "lineNumber": 3909, "methodName": "checkErrorPacket" }, { "className": "com.mysql.jdbc.MysqlIO", "fileName": "MysqlIO.java", "lineNumber": 2527, "methodName": "sendCommand" }, { "className": "com.mysql.jdbc.MysqlIO", "fileName": "MysqlIO.java", "lineNumber": 2680, "methodName": "sqlQueryDirect" }, { "className": "com.mysql.jdbc.ConnectionImpl", "fileName": "ConnectionImpl.java", "lineNumber": 2490, "methodName": "execSQL" }, { "className": "com.mysql.jdbc.PreparedStatement", "fileName": "PreparedStatement.java", "lineNumber": 1858, "methodName": "executeInternal" }, { "className": "com.mysql.jdbc.PreparedStatement", "fileName": "PreparedStatement.java", "lineNumber": 2079, "methodName": "executeUpdateInternal" }, { "className": "com.mysql.jdbc.PreparedStatement", "fileName": "PreparedStatement.java", "lineNumber": 2013, "methodName": "executeUpdateInternal" }, { "className": "com.mysql.jdbc.PreparedStatement", "fileName": "PreparedStatement.java", "lineNumber": 5104, "methodName": "executeLargeUpdate" }, { "className": "com.mysql.jdbc.PreparedStatement", "fileName": "PreparedStatement.java", "lineNumber": 1998, "methodName": "executeUpdate" }, { "className": "com.zaxxer.hikari.pool.ProxyPreparedStatement", "fileName": "ProxyPreparedStatement.java", "lineNumber": 61, "methodName": "executeUpdate" }, { "className": "com.zaxxer.hikari.pool.HikariProxyPreparedStatement", "fileName": "HikariProxyPreparedStatement.java", "lineNumber": -1, "methodName": "executeUpdate" }, { "className": "slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10", "fileName": "JdbcActionComponent.scala", "lineNumber": 333, "methodName": "$anonfun$run$14" }, { "className": "slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10", "fileName": "JdbcActionComponent.scala", "lineNumber": 329, "methodName": "$anonfun$run$14$adapted" }, { "className": "slick.jdbc.JdbcBackend$SessionDef", "fileName": "JdbcBackend.scala", "lineNumber": 425, "methodName": "withPreparedStatement" }, { "className": "slick.jdbc.JdbcBackend$SessionDef", "fileName": "JdbcBackend.scala", "lineNumber": 420, "methodName": "withPreparedStatement$" }, { "className": "slick.jdbc.JdbcBackend$BaseSession", "fileName": "JdbcBackend.scala", "lineNumber": 489, "methodName": "withPreparedStatement" }, { "className": "slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10", "fileName": "JdbcActionComponent.scala", "lineNumber": 329, "methodName": "run" }, { "className": "slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10", "fileName": "JdbcActionComponent.scala", "lineNumber": 328, "methodName": "run" }, { "className": "slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction", "fileName": "JdbcActionComponent.scala", "lineNumber": 28, "methodName": "run" }, { "className": "slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction", "fileName": "JdbcActionComponent.scala", "lineNumber": 25, "methodName": "run" }, { "className": "slick.dbio.SynchronousDatabaseAction$FusedAndThenAction", "fileName": "DBIOAction.scala", "lineNumber": 533, "methodName": "$anonfun$run$4" }, { "className": "slick.dbio.SynchronousDatabaseAction$FusedAndThenAction", "fileName": "DBIOAction.scala", "lineNumber": 533, "methodName": "$anonfun$run$4$adapted" }, { "className": "scala.collection.Iterator", "fileName": "Iterator.scala", "lineNumber": 943, "methodName": "foreach" }, { "className": "scala.collection.Iterator", "fileName": "Iterator.scala", "lineNumber": 943, "methodName": "foreach$" }, { "className": "scala.collection.AbstractIterator", "fileName": "Iterator.scala", "lineNumber": 1431, "methodName": "foreach" }, { "className": "scala.collection.IterableLike", "fileName": "IterableLike.scala", "lineNumber": 74, "methodName": "foreach" }, { "className": "scala.collection.IterableLike", "fileName": "IterableLike.scala", "lineNumber": 73, "methodName": "foreach$" }, { "className": "scala.collection.AbstractIterable", "fileName": "Iterable.scala", "lineNumber": 56, "methodName": "foreach" }, { "className": "slick.dbio.SynchronousDatabaseAction$FusedAndThenAction", "fileName": "DBIOAction.scala", "lineNumber": 533, "methodName": "run" }, { "className": "slick.basic.BasicBackend$DatabaseDef$$anon$3", "fileName": "BasicBackend.scala", "lineNumber": 276, "methodName": "liftedTree1$1" }, { "className": "slick.basic.BasicBackend$DatabaseDef$$anon$3", "fileName": "BasicBackend.scala", "lineNumber": 276, "methodName": "run" }, { "className": "java.util.concurrent.ThreadPoolExecutor", "fileName": null, "lineNumber": -1, "methodName": "runWorker" }, { "className": "java.util.concurrent.ThreadPoolExecutor$Worker", "fileName": null, "lineNumber": -1, "methodName": "run" }, { "className": "java.lang.Thread", "fileName": null, "lineNumber": -1, "methodName": "run" } ] }

Comments

3 comments

  • Comment author
    Samantha (she/her)

    Hi Laura Gauthier,

     

    Thanks for reaching out. There is a process running in Terra right now that is causing database locks. You may be experiencing lock wait timeout exceeded errors when creating or modifying workspaces. We expect this issue to self-resolve shortly.

     

    Best,

    Samantha

    0
  • Comment author
    Samantha (she/her)

    Hi Laura Gauthier,

     

    This issue should now be resolved. Can you confirm whether you are still receiving errors?

     

    Best,

    Samantha

    0
  • Comment author
    Laura Gauthier

    Save success!  I guess my timing was just unlucky today.  Thanks!

    0

Please sign in to leave a comment.