javax.jdo.JDODataStoreException: [SQL=UPDATE USERX SET ZIPX='94619', STATEX='CA', REVOKEDX=0, COUNTRYX='US', EMAILX='sue@jacobs.com ', VALIDATEDX=1, SCREENNAMEX='Sue', LOGINNAMEX='sue', LASTACCESSEDX={ts '2002-05-31 06:06:59.718'}, STATUSX=1,FIRSTNAMEX='Sue', ADDRESS1X='49 Broadway Terrace', EXPIRATION DATEX={ts '2002-05-29 16:57:07.0'}, EXPIRESX=NULL, ACCESSCOUNTERX=3, LASTNAMEX='Jacobs', ADDRESS2X='', CREATEDX={ts '2002-05-29 16:57:07.0'}, JDOLOCKX=4, LOGINNAMEUCX='SUE', CREDITCARDNUMBERX='4222222222222', CITYX='Oakland', PASSWORDX='sue', CVV2CODEX='445' WHERE (JDOIDX = 30 AND JDOLOCKX = 3)] General error: Deadlock found when trying to get lock; Try restarting transaction

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Deadlock Exception

    Oracle Community | 1 decade ago | 3004
    javax.jdo.JDODataStoreException: [SQL=UPDATE USERX SET ZIPX='94619', STATEX='CA', REVOKEDX=0, COUNTRYX='US', EMAILX='sue@jacobs.com ', VALIDATEDX=1, SCREENNAMEX='Sue', LOGINNAMEX='sue', LASTACCESSEDX={ts '2002-05-31 06:06:59.718'}, STATUSX=1,FIRSTNAMEX='Sue', ADDRESS1X='49 Broadway Terrace', EXPIRATION DATEX={ts '2002-05-29 16:57:07.0'}, EXPIRESX=NULL, ACCESSCOUNTERX=3, LASTNAMEX='Jacobs', ADDRESS2X='', CREATEDX={ts '2002-05-29 16:57:07.0'}, JDOLOCKX=4, LOGINNAMEUCX='SUE', CREDITCARDNUMBERX='4222222222222', CITYX='Oakland', PASSWORDX='sue', CVV2CODEX='445' WHERE (JDOIDX = 30 AND JDOLOCKX = 3)] General error: Deadlock found when trying to get lock; Try restarting transaction

    Root Cause Analysis

    1. javax.jdo.JDODataStoreException

      [SQL=UPDATE USERX SET ZIPX='94619', STATEX='CA', REVOKEDX=0, COUNTRYX='US', EMAILX='sue@jacobs.com ', VALIDATEDX=1, SCREENNAMEX='Sue', LOGINNAMEX='sue', LASTACCESSEDX={ts '2002-05-31 06:06:59.718'}, STATUSX=1,FIRSTNAMEX='Sue', ADDRESS1X='49 Broadway Terrace', EXPIRATION DATEX={ts '2002-05-29 16:57:07.0'}, EXPIRESX=NULL, ACCESSCOUNTERX=3, LASTNAMEX='Jacobs', ADDRESS2X='', CREATEDX={ts '2002-05-29 16:57:07.0'}, JDOLOCKX=4, LOGINNAMEUCX='SUE', CREDITCARDNUMBERX='4222222222222', CITYX='Oakland', PASSWORDX='sue', CVV2CODEX='445' WHERE (JDOIDX = 30 AND JDOLOCKX = 3)] General error: Deadlock found when trying to get lock; Try restarting transaction

      at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.update()
    2. com.solarmetric.kodo
      PersistenceManagerImpl.commit
      1. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.update(JDBCStoreManager.java:352)
      2. com.solarmetric.kodo.runtime.StateManagerImpl.storeFields(StateManagerImpl.java:1808)
      3. com.solarmetric.kodo.runtime.PDirtyState.flush(PDirtyState.java:37)
      4. com.solarmetric.kodo.runtime.StateManagerImpl.flush(StateManagerImpl.java:480)
      5. com.solarmetric.kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:539)
      6. com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:393)
      6 frames
    3. net.nearlythere.business
      BaseBusiness.finalize
      1. net.nearlythere.business.BaseBusiness.end(BaseBusiness.java:247)
      2. net.nearlythere.business.BaseBusiness.finalize(BaseBusiness.java:259)
      2 frames
    4. net.nearlythere.frontend
      ChatAPI.doPost
      1. net.nearlythere.frontend.servlets.ChatAPI.memberEndSession(ChatAPI.java:345)
      2. net.nearlythere.frontend.servlets.ChatAPI.doPost(ChatAPI.java:125)
      2 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      1 frame