db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From T K <sanokist...@yahoo.com>
Subject Can someone explain this deadlock?
Date Fri, 04 Sep 2009 20:20:33 GMT
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



      
Mime
View raw message