Uploaded image for project: 'InsightEdge Platform'
  1. GS-13224

Improve log message to include table name when initial load fails due to wrong column name

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 12.3
    • Labels:
      None
    • Platform:
      All
    • Acceptance Test:
      org.openspaces.test.persistency.hibernate.DefaultListQueryDataIteratorTests
    • Sprint:
    • Edition:
      Open Source

      Description

      current exception is with out table name/ pojo name:
      017-03-30 12:20:43,011 [pool-11-thread-14] WARN spi.SqlExceptionHelper - SQL Error: 207, SQLState: ZZZZZ
      2017-03-30 12:20:43,011 [pool-11-thread-14] ERROR spi.SqlExceptionHelper - Invalid column name 'Version_Id'.

      2017-03-30 12:20:43,066 SEVERE [com.gigaspaces.space.engine.fortune-space.1] - Failed to init [fortune-space] space.; Caused by: com.j_spaces.core.sadapter.SAException: org.hibernate.exception.GenericJDBCException: Invalid column name 'Version_Id'.

      at com.j_spaces.core.cache.CacheManager.initCache(CacheManager.java:661)
      at com.gigaspaces.internal.server.space.SpaceEngine.init(SpaceEngine.java:668)
      at com.gigaspaces.internal.server.space.SpaceImpl.initAndRecoverFromDataStorage(SpaceImpl.java:1471)
      at com.gigaspaces.internal.server.space.recovery.strategy.NonPrimaryBackupSpaceRecovery.recoverFromDB(NonPrimaryBackupSpaceRecovery.java:73)
      at com.gigaspaces.internal.server.space.recovery.strategy.NonPrimaryBackupSpaceRecovery.recover(NonPrimaryBackupSpaceRecovery.java:65)
      at com.gigaspaces.internal.server.space.SpaceImpl.initAndStartRegularSpace(SpaceImpl.java:1445)
      at com.gigaspaces.internal.server.space.SpaceImpl.recover(SpaceImpl.java:3016)
      at com.gigaspaces.internal.server.space.SpaceImpl.startInternal(SpaceImpl.java:2947)
      at com.gigaspaces.internal.server.space.SpaceImpl.<init>(SpaceImpl.java:403)
      at com.j_spaces.core.JSpaceContainerImpl.createSpaceImpl(JSpaceContainerImpl.java:1536)
      at com.j_spaces.core.JSpaceContainerImpl.loadSpace(JSpaceContainerImpl.java:1507)
      at com.j_spaces.core.JSpaceContainerImpl.xmlInit(JSpaceContainerImpl.java:609)
      at com.j_spaces.core.JSpaceContainerImpl.initContainer(JSpaceContainerImpl.java:457)
      at com.j_spaces.core.JSpaceContainerImpl.<init>(JSpaceContainerImpl.java:366)
      at com.j_spaces.core.client.SpaceFinder.createEmbeddedSpace(SpaceFinder.java:556)
      at com.j_spaces.core.client.SpaceFinder.findEmbeddedSpace(SpaceFinder.java:588)
      at com.j_spaces.core.client.SpaceFinder.findService(SpaceFinder.java:469)
      at com.j_spaces.core.client.SpaceFinder.findService(SpaceFinder.java:431)
      at com.j_spaces.core.client.SpaceFinder.find(SpaceFinder.java:336)
      at com.gigaspaces.client.SpaceProxyFactory.createSpaceProxy(SpaceProxyFactory.java:96)
      at org.openspaces.core.space.InternalSpaceFactory.create(InternalSpaceFactory.java:113)
      at org.openspaces.core.space.UrlSpaceFactoryBean.doCreateSpace(UrlSpaceFactoryBean.java:102)
      at org.openspaces.core.space.AbstractSpaceFactoryBean.afterPropertiesSet(AbstractSpaceFactoryBean.java:189)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1627)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1564)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:540)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
      at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302)
      at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229)
      at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298)
      at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
      at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:706)
      at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
      at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
      at org.openspaces.pu.container.integrated.IntegratedProcessingUnitContainerProvider.createContainer(IntegratedProcessingUnitContainerProvider.java:244)
      at org.openspaces.pu.container.integrated.IntegratedProcessingUnitContainer.createContainer(IntegratedProcessingUnitContainer.java:188)
      at org.openspaces.pu.container.integrated.IntegratedProcessingUnitContainer.main(IntegratedProcessingUnitContainer.java:124)
      Caused by: org.hibernate.exception.GenericJDBCException: Invalid column name 'Version_Id'.

      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
      at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
      at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
      at com.sun.proxy.$Proxy65.executeQuery(Unknown Source)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
      at org.hibernate.loader.Loader.doQuery(Loader.java:899)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
      at org.hibernate.loader.Loader.doList(Loader.java:2516)
      at org.hibernate.loader.Loader.doList(Loader.java:2502)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)
      at org.hibernate.loader.Loader.list(Loader.java:2327)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)
      at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
      at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
      at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1247)
      at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
      at org.openspaces.persistency.hibernate.iterator.DefaultListQueryDataIterator.createIterator(DefaultListQueryDataIterator.java:153)
      at org.openspaces.persistency.hibernate.iterator.DefaultListQueryDataIterator.hasNext(DefaultListQueryDataIterator.java:107)
      at org.openspaces.persistency.support.ConcurrentMultiDataIterator$DataIteratorRunnable.run(ConcurrentMultiDataIterator.java:156)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      at java.lang.Thread.run(Thread.java:745)
      Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'Version_Id'.

      at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131)
      at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247)
      at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
      at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
      at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
      at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2643)
      at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2629)
      at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:279)
      at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
      at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
      at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
      ... 22 more

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: