I delete files with dql failed , who can help me ? why deadlock come?
Hello ,
You may have to work on DB level to have some more info. Tick "Show the SQL" and execute it with your favorite DB client.
DQL delete can't be presented as single sql statement
The ERROR Message hasn't nothing to do with the DQL Statement, but RDMS.
Deadlock means that DB Process is waiting another DB process to release the lock.
Run a select count(*) with your qualification to check how many documents will be affected by your delete statement. If it's more than a few thousand, you should break it up in several chunks. Try to delete 1000 documents at a time for example.
Just to add to the above points you may try to put some additinal condition in your delete statement . Like checking if the r_lock_owner is null for a document which you want to delete .
