db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Van Couvering <da...@vancouvering.com>
Subject Deadlock XID with no SQL?
Date Wed, 22 Sep 2010 21:21:41 GMT
I am getting the following deadlock?  One of the locks does not have a user
or SQL associated with it.  What should I be looking for when a lock is
described in this way?

Lock : ROW, FILTERS_FOR_DELIVERY, (3,1960)
  Waiting XID : {271243, X} , VONTU, DELETE FROM FILTERS_FOR_DELIVERY WHERE
ITEMSET_ID = ? AND FILTER_INDEX = ? AND SERVER_ID = ?
  Granted XID : {271250, X}
Lock : ROW, FILTERS_FOR_DELIVERY, (3,1990)
  Waiting XID : {271250, X} , VONTU, DELETE FROM FILTERS_FOR_DELIVERY WHERE
ITEMSET_ID = ? AND FILTER_INDEX = ? AND SERVER_ID = ?
  Granted XID : {271243, X}
. The selected victim is XID : 271243.

Thanks,

David

-- 
David W. Van Couvering

http://www.linkedin.com/in/davidvc
http://davidvancouvering.blogspot.com
http://twitter.com/dcouvering

Mime
View raw message