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
  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
  2. 0

    Problem with same field as PK and FK

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT t0.COBRAND_ID, t0.FEATURE_ID, t0.CONFIGID_CONFIGOFCONFIGIDX, t0.FEATUREID_FEATURESWITCHOFFEATX, t0.STATE FROM COB_FEATURE t0 WHERE t0.COBRAND_ID = 1] ORA-00904: invalid column name
  3. 0

    Schematool not creating all tables?

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO MANAGEDENTITYVALUEIMPLX(JDOCLASSX, USERLABELX, LOCATIONNAMEX, IPADDRESSX, INVENTORYSTATEX, LASTMODIFIEDONSERVERX, JDOIDX, SYSTEMLEVELVERSIONX, JDOLOCKX) VALUES ('ossj.inventory.infomodel.resource.impl.ManagedElementValueImpl', NULL, NULL, '42', 0, NULL, 150, NULL, 0)] Table not found: MANAGEDENTITYVALUEIMPLX
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    bug in Kodo 2.2.1 for metadata?

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT DISTINCT JDO _SCHEMA_METADATAX.CLASSNAMEX FROM JDO_SCHEMA_METADATAX] ORA-00942: table or view does not exist
  6. 0

    Insert failing

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO COB_SESSIONS (COBRAND_ID, SESSION_DATA, ID, DB_SESSION_ID, LAST_ACCESS, LENGTH, COBRAND_ID, CREATE_DATE, COBRAND_ID, A_SESSION, SOURCE) VALUES (4, NULL, 'id 6', NULL, NULL, NULL, 150, NULL, NULL, NULL, NULL)] ORA-00957: duplicate column name

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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