can't save update to method config
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
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
Hi Laura Gauthier,
This issue should now be resolved. Can you confirm whether you are still receiving errors?
Best,
Samantha
Save success! I guess my timing was just unlucky today. Thanks!
Please sign in to leave a comment.