com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] null: Deadlock found when trying to get lock; Try restarting transaction

Oracle Community | 3004 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Deadlock found...

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] null: Deadlock found when trying to get lock; Try restarting transaction

    Root Cause Analysis

    1. com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper

      [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] null: Deadlock found when trying to get lock; Try restarting transaction

      at com.solarmetric.kodo.impl.jdbc.runtime.SQLExceptions.throwDataStore()
    2. com.solarmetric.kodo
      StateManagerImpl.isLoaded
      1. com.solarmetric.kodo.impl.jdbc.runtime.SQLExceptions.throwDataStore(SQLExceptions.java:23)
      2. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.load(JDBCStoreManager.java:348)
      3. com.solarmetric.kodo.runtime.datacache.DataCacheStoreManager.load(DataCacheStoreManager.java:253)
      4. com.solarmetric.kodo.runtime.StateManagerImpl.loadField(StateManagerImpl.java:1890)
      5. com.solarmetric.kodo.runtime.StateManagerImpl.isLoaded(StateManagerImpl.java:663)
      5 frames
    3. net.nearlythere.business
      CoreSiteBuilder.getLiveShows
      1. net.nearlythere.business.data.Site.jdoGetuser(Site.java)
      2. net.nearlythere.business.data.Site.getUsers(Site.java:168)
      3. net.nearlythere.business.CoreSiteBuilder.getPerformers(CoreSiteBuilder.java:883)
      4. net.nearlythere.business.CoreSiteBuilder.getShows(CoreSiteBuilder.java:1041)
      5. net.nearlythere.business.CoreSiteBuilder.getLiveShows(CoreSiteBuilder.java:3101)
      6. net.nearlythere.business.CoreSiteBuilder.getLiveShows(CoreSiteBuilder.java:3077)
      6 frames
    4. net.nearlythere.frontend
      CoreTool.getRandomLiveShow
      1. net.nearlythere.frontend.utils.CoreTool.getLiveShows(CoreTool.java:157)
      2. net.nearlythere.frontend.utils.CoreTool.getRandomLiveShow(CoreTool.java:102)
      2 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:324)
      3 frames
    6. Apache Velocity
      VelocityServlet.doGet
      1. org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:259)
      2. org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:207)
      3. org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:357)
      4. org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:135)
      5. org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:271)
      6. org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:215)
      7. org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:153)
      8. org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:271)
      9. org.apache.velocity.runtime.directive.Parse.render(Parse.java:232)
      10. org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:153)
      11. org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:271)
      12. org.apache.velocity.Template.merge(Template.java:296)
      13. org.apache.velocity.servlet.VelocityServlet.mergeTemplate(VelocityServlet.java:448)
      14. org.apache.velocity.servlet.VelocityServlet.doRequest(VelocityServlet.java:387)
      15. org.apache.velocity.servlet.VelocityServlet.doGet(VelocityServlet.java:333)
      15 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    8. Glassfish Core
      ApplicationDispatcher.forward
      1. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:683)
      2. org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:431)
      3. org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:355)
      3 frames
    9. org.infohazard.maverick
      Dispatcher.service
      1. org.infohazard.maverick.transform.DocumentTransform$Step.go(DocumentTransform.java:90)
      2. org.infohazard.maverick.transform.StringTransformStep.done(StringTransformStep.java:70)
      3. org.infohazard.maverick.view.DispatchedViewFactory$DispatchedView.go(DispatchedViewFactory.java:106)
      4. org.infohazard.maverick.view.DocumentView.go(DocumentView.java:52)
      5. org.infohazard.maverick.flow.ViewWithTransforms.go(ViewWithTransforms.java:39)
      6. org.infohazard.maverick.flow.CommandBase.go(CommandBase.java:51)
      7. org.infohazard.maverick.Dispatcher.service(Dispatcher.java:179)
      7 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      1 frame
    11. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
      4. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
      6. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
      8. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
      9. org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      10. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
      11. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
      12. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
      13. org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
      14. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      15. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
      16. org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
      17. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
      18. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
      19. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
      20. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
      21. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
      22. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
      23. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
      24. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      25. org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
      26. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
      27. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
      27 frames
    12. org.apache.ajp
      Ajp13Processor.run
      1. org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458)
      2. org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551)
      2 frames
    13. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:536)
      1 frame