Hello I have an app in production that occasionally suffers from what seems to be a deadlock or timout when doing a simple update inside a transaction
here is the stacktrace - can anyone shed any light on things?? TIA Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; Try restarting transaction" at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(Unknown Source) at org.apache.ojb.broker.core.MtoNBroker.deleteMtoNImplementor(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkMtoN(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at com.buyacar.dtofactory.OJBTransactionImpl.save(OJBTransactionImpl.java:54) at com.buyacar.dtofactory.UserFactory.saveUser(UserFactory.java:28)