Can someone explain this deadlock?

Fri, 04 Sep 2009 13:21:06 -0700 

Derby 10.3

Caused by: java.sql.SQLTransactionRollbackException: A lock could not be 
obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, SOMETABLE, (217,6)
  Waiting XID : {216333, S} , SOMESCHEMA, select something from SOMETABLE where 
somethingElse = ?
  Granted XID : {216146, X} 
Lock : ROW, SOMETABLE, (4,1)
  Waiting XID : {216146, S} , SOMESCHEMA, update SOMETABLE  set something = ? 
where somethingElse = ?
  Granted XID : {216190, S} , {216333, S} 
. The selected victim is XID : 216333.

Thanks

Reply via email to