java.sql.SQLException: Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )]

Atlassian JIRA | Don Willis [Atlassian] | 10 years ago
  1. 0

    I attempted an upgrade from Confluence 2.2.9 to 2.3.3 (approximately). The licence used in my 2.2.9 instance had expired when 2.3.3 was released. I got the following feedback 2007-02-22 15:59:50,890 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence @VERSION@ (build #702) 2007-02-22 16:11:54,265 DEBUG [main] [net.sf.hibernate.SQL] log select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? ) 2007-02-22 16:11:54,359 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,359 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,375 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,375 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,375 ERROR [main] [atlassian.confluence.event.ConfluenceEventManager] publishEvent An exception was encountered while processing the event: com.atlassian.confluence.event.events.admin.ConfluenceReadyEvent[source=com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager@554210] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] java.sql.SQLException: Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190) ... at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:58) at com.atlassian.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) ... Apparently not being allowed to upgrade is not considered an exceptional condition, so the upgrade manager tries to tell us that Confluence is ready. That triggers something to look in bandana for something, which fails due to the skipped upgrade, triggering the stacktrace. Using the browser to connect to Confluence gives an Oops message with no stacktrace.

    Atlassian JIRA | 10 years ago | Don Willis [Atlassian]
    java.sql.SQLException: Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )]
  2. 0

    I attempted an upgrade from Confluence 2.2.9 to 2.3.3 (approximately). The licence used in my 2.2.9 instance had expired when 2.3.3 was released. I got the following feedback 2007-02-22 15:59:50,890 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence @VERSION@ (build #702) 2007-02-22 16:11:54,265 DEBUG [main] [net.sf.hibernate.SQL] log select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? ) 2007-02-22 16:11:54,359 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,359 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,375 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,375 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] 2007-02-22 16:11:54,375 ERROR [main] [atlassian.confluence.event.ConfluenceEventManager] publishEvent An exception was encountered while processing the event: com.atlassian.confluence.event.events.admin.ConfluenceReadyEvent[source=com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager@554210] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] java.sql.SQLException: Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190) ... at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:58) at com.atlassian.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) ... Apparently not being allowed to upgrade is not considered an exceptional condition, so the upgrade manager tries to tell us that Confluence is ready. That triggers something to look in bandana for something, which fails due to the skipped upgrade, triggering the stacktrace. Using the browser to connect to Confluence gives an Oops message with no stacktrace.

    Atlassian JIRA | 10 years ago | Don Willis [Atlassian]
    java.sql.SQLException: Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )]
  3. 0

    Play 1.1 Beta 2 Unexpected token: CROSS in statement

    Google Groups | 6 years ago | chungonn
    org.hibernate.exception.SQLGrammarException: could not execute query at
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issues with Writes with MySQL read-write split.

    GitHub | 3 years ago | zhurandy
    com.liferay.portal.kernel.exception.SystemException: java.sql.SQLException: Table not found in statement [select currentId from Counter where name = ?]
  6. 0

    Going from 1.0 rc1, tried going to latest and going to 1.0 rc2, get a bad sql grammar error, won't upgrade/copy my previous project data. error is: INFO | jvm 1 | 2007/06/28 10:44:36 | org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLException: Table not found in statement [select instantmes0_.IMSERVER_ID as IMSERVER1_, instantmes0_.TITLE as TITLE, instantmes0_.HOST as HOST, instantmes0_.PORT as PORT, instantmes0_.USERNAME as USERNAME, instantmes0_.PASSWORD as PASSWORD, instantmes0_.SSL as SSL from IMSERVER instantmes0_] INFO | jvm 1 | 2007/06/28 10:44:36 | java.sql.SQLException: Table not found in statement [select instantmes0_.IMSERVER_ID as IMSERVER1_, instantmes0_.TITLE as TITLE, instantmes0_.HOST as HOST, instantmes0_.PORT as PORT, instantmes0_.USERNAME as USERNAME, instantmes0_.PASSWORD as PASSWORD, instantmes0_.SSL as SSL from IMSERVER instantmes0_] INFO | jvm 1 | 2007/06/28 10:44:36 | at org.hsqldb.jdbc.Util.throwError(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.loader.Loader.list(Loader.java:1048) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) INFO | jvm 1 | 2007/06/28 10:44:36 | at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.hibernate.HibernateObjectDao$2.doInHibernate(HibernateObjectDao.java:97) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:364) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:337) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.hibernate.HibernateObjectDao.findAllSorted(HibernateObjectDao.java:90) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.hibernate.HibernateObjectDao.findAll(HibernateObjectDao.java:78) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.instantmessagingserver.InstantMessagingServerManagerImpl.getAllInstantMessagingServers(InstantMessagingServerManagerImpl.java:29) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at java.lang.reflect.Method.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) INFO | jvm 1 | 2007/06/28 10:44:36 | at $Proxy11.getAllInstantMessagingServers(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.xmpp.BambooSmackClient.getMessagingServerDefinition(BambooSmackClient.java:99) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.xmpp.BambooSmackClient.connect(BambooSmackClient.java:45) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.xmpp.BambooSmackClient.init(BambooSmackClient.java:35) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at java.lang.reflect.Method.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1133) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1095) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:396) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:283) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.config.spring.BootstrappedContainerContext.refresh(BootstrappedContainerContext.java:22) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.setup.DefaultHibernateConfigurator.refreshSpringContextAndCreateDatabase(DefaultHibernateConfigurator.java:119) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.setup.DefaultHibernateConfigurator.configureDatabase(DefaultHibernateConfigurator.java:63) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.bootstrapDatabase(DefaultAtlassianBootstrapManager.java:254) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.setup.DefaultBootstrapManager.bootstrapDatabase(DefaultBootstrapManager.java:75) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.actions.setup.SetupEmbeddedDatabaseAction.execute(SetupEmbeddedDatabaseAction.java:36) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at java.lang.reflect.Method.invoke(Unknown Source) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:365) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:217) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:191) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:137) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.BambooWorkflowInterceptor.doIntercept(BambooWorkflowInterceptor.java:33) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.BambooValidationInterceptor.doIntercept(BambooValidationInterceptor.java:33) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.BasePermissionCheckInterceptor.intercept(BasePermissionCheckInterceptor.java:38) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.PaginationAwareInterceptor.intercept(PaginationAwareInterceptor.java:68) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.StatisticsAwareInterceptor.intercept(StatisticsAwareInterceptor.java:42) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.ResultsListAwareInterceptor.intercept(ResultsListAwareInterceptor.java:43) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.TestCaseAwareInterceptor.intercept(TestCaseAwareInterceptor.java:43) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.BuildAwareInterceptor.intercept(BuildAwareInterceptor.java:40) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:100) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.ww2.interceptors.SetupCheckInterceptor.intercept(SetupCheckInterceptor.java:29) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:198) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:78) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.filter.BambooAcegiProxyFilter.doFilter(BambooAcegiProxyFilter.java:21) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.filter.LicenseFilter.doFilter(LicenseFilter.java:71) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:83) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:91) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:26) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.filter.CompressingFilter.doFilter(CompressingFilter.java:69) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.filter.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:26) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at com.atlassian.bamboo.filter.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:26) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.jetty.plus.PlusWebAppContext.handle(PlusWebAppContext.java:158) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.http.HttpServer.service(HttpServer.java:954) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) INFO | jvm 1 | 2007/06/28 10:44:36 | at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Comes up with a clean installation. using zipped windows release Haven't hacked or changed previous 1.0 release Renamed previous bamboo folder to bamboo1.0, created new bamboo folder copied devbamboo folder from previous release to new release (don't think it uses it though) rc1 doesn't have service entries, no services exist for this any more error occurs if i try both install/start service or using console error occurs on both upgrades. haven't tried re-installing rc1 again from clean, will do shortly concerned my other 2 build boxes will be lost if i upgrade as well, so not upgrading further at present. will attempt to use auto-installer in a sec and see if the same thing happens. wil attach log file shortly

    Atlassian JIRA | 9 years ago | Riaz Khanmohamed
    java.sql.SQLException: Table not found in statement [select instantmes0_.IMSERVER_ID as IMSERVER1_, instantmes0_.TITLE as TITLE, instantmes0_.HOST as HOST, instantmes0_.PORT as PORT, instantmes0_.USERNAME as USERNAME, instantmes0_.PASSWORD as PASSWORD, instantmes0_.SSL as SSL from IMSERVER instantmes0_]

    8 unregistered visitors
    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. java.sql.SQLException

      Table not found in statement [select confluence0_.BANDANAID as BANDANAID, confluence0_.BANDANACONTEXT as BANDANAC2_, confluence0_.BANDANAKEY as BANDANAKEY, confluence0_.BANDANAVALUE as BANDANAV4_ from BANDANA confluence0_ where (confluence0_.BANDANACONTEXT=? )]

      at org.hsqldb.jdbc.Util.throwError()
    2. HSQLDB
      jdbcConnection.prepareStatement
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      3. org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      3 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyConnection.prepareStatement
      1. com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
      1 frame