Question

Deadlock error

1

Can anyone please tell me what this means and what I do to avoid it? I suspect I'm trying to delete an object which has been created but not yet committed; is that allowed? It seems to be accompanied with a whole lot of warnings about not being able to retrieve certain objects. 2009-09-28 22:40:56.471 ERROR - CONNECTIONBUS_RETRIEVE: JDBCDataStore::execRetrieveQuery failed with SQLState: 40001 Message: Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

asked 2009-09-28

Martin Bucknall

1 answers

Johan den Haan · Answer 1 · 2009-09-29

It is allowed to delete an object which is created but not committed.

The error you get is probably due to the fact that you are retrieving and editing the same type of objects from two different transactions. This can lead to a deadlock in the database.