Mysql deadlock found upgrade#

In the administration area, click Database (under 'Settings').Migration: migrate your instance data over to PostgreSQL as described on Connecting Stash to an external database.Preparation: configure a PostgreSQL db (it can be any other supported databases) as described on Connecting Stash to PostgreSQL.The good news is that Stash makes it really easy for you to migrate databases. (.)the following error more and more frequently when trying to merge a PR from the Stash UI (happening on multiple repos): 'New changes were pushed to master in project/repo while the merge was being performed. Leaving as-is will cause you performance issues as well as Pull Requests misbehaviour while merging.

Mysql deadlock found upgrade#

Therefore, if you can move to an alternative database (for example, PostgreSQL) in case you don't want to upgrade now, that'd also solve this issue for you. WorkaroundĮxactly because of this issue and STASH-4701, we recommend that customers with larger instances (you can consider that 500+ licenses) move off MySQL (you can see the warning we placed on Connecting Stash to MySQL). It is 100% MySQL-specific, and should not affect customers using any other database. This issue affects all versions of Stash from 2.5.0 through the just released 2.12.0. : could not execute statementĪt $1.convert(MySQLDialect.java:411) ~Īt .nvert(StandardSQLExceptionConverter.java:49) ~Īt .(SqlExceptionHelper.java:125) ~Īt .(SqlExceptionHelper.java:110) ~Īt .(ResultSetReturnImpl.java:136) ~Īt .TableBasedDeleteHandlerImpl.execute(TableBasedDeleteHandlerImpl.java:163) ~Īt .(MultiTableDeleteExecutor.java:63) ~Īt .(QueryTranslatorImpl.java:414) ~Īt .(HQLQueryPlan.java:282) ~Īt .executeUpdate(SessionImpl.java:1290) ~Īt .executeUpdate(QueryImpl.java:116) ~Īt .leteById(AbstractHibernateDao.java:53) ~Īt .leteById(AbstractHibernateDao.java:22) ~Īt .$leteById(Unknown Source) ~Īt .$3.doInTransactionWithoutResult(DefaultRescopeProcessor.java:139) ~Īt .TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) ~Īt .TransactionTemplate.execute(TransactionTemplate.java:131) ~Īt .(DefaultRescopeProcessor.java:130) Īt .(DefaultRescopeProcessor.java:100) Īt .(DefaultRescopeProcessor.java:77) Īt .$n(DefaultRescopeProcessor.java:219) ~Īt .concurrent.StateTransferringExecutor$n(StateTransferringExecutor.java:69) ~Īt $RunnableAdapter.call(Executors.java:471) ~Īt $Sync.innerRun(FutureTask.java:334) ~Īt .run(FutureTask.java:166) ~Īt .runWorker(ThreadPoolExecutor.java:1145) ~Īt (Thread.java:724) ~Ĭaused by: .jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock try restarting transactionĪt 0(Native Method) ~Īt .handleNewInstance(Util.java:411) ~Īt .getInstance(Util.java:386) ~Īt .createSQLException(SQLError.java:1065) ~Īt .checkErrorPacket(MysqlIO.java:4096) ~Īt .checkErrorPacket(MysqlIO.java:4028) ~Īt .sendCommand(MysqlIO.java:2490) ~Īt .sqlQueryDirect(MysqlIO.java:2651) ~Īt .execSQL(ConnectionImpl.java:2734) ~Īt .executeInternal(PreparedStatement.java:2155) ~Īt .executeUpdate(PreparedStatement.java:2458) ~Īt .executeUpdate(PreparedStatement.java:2375) ~Īt .executeUpdate(PreparedStatement.java:2359) ~Īt .executeUpdate(PreparedStatementHandle.java:203) ~Īt .(ResultSetReturnImpl.java:133) ~