Bandana table is being accessed before its created. See stack trace below:

      2006-09-07 14:31:08,904 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: relation "bandana" does not exist
      2006-09-07 14:31:08,904 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: relation "bandana" does not exist
      2006-09-07 14:31:08,904 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: relation "bandana" does not exist
      2006-09-07 14:31:08,904 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: relation "bandana" does not exist
      2006-09-07 14:31:08,935 ERROR [atlassian.confluence.event.ConfluenceEventManager] publishEvent An exception was encountered while processing the event: com.atlassian.confluence.event.events.admin.ConfluenceReadyEvent[source=com.atlassian.confluence.setup.DefaultBootstrapManager@118958e]
      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is org.postgresql.util.PSQLException: ERROR: relation "bandana" does not exist
      org.postgresql.util.PSQLException: ERROR: relation "bandana" does not exist
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
      at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
      at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
      at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
      at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
      at net.sf.hibernate.loader.Loader.list(Loader.java:1048)
      at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
      at com.atlassian.confluence.setup.bandana.persistence.dao.hibernate.HibernateConfluenceBandanaRecordDao$2.doInHibernate(HibernateConfluenceBandanaRecordDao.java:92)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:289)
      at com.atlassian.confluence.setup.bandana.persistence.dao.hibernate.HibernateConfluenceBandanaRecordDao.findForContext(HibernateConfluenceBandanaRecordDao.java:84)
      at com.atlassian.confluence.setup.bandana.ConfluenceDaoBandanaPersister.retrieve(ConfluenceDaoBandanaPersister.java:50)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy4.retrieve(Unknown Source)
      at com.atlassian.confluence.setup.bandana.ConfluenceCachingBandanaPersister.retrieve(ConfluenceCachingBandanaPersister.java:60)
      at com.atlassian.confluence.setup.bandana.ConfluenceCachingBandanaPersister.retrieve(ConfluenceCachingBandanaPersister.java:42)
      at com.atlassian.bandana.DefaultBandanaManager.getValue(DefaultBandanaManager.java:41)
      at com.atlassian.bandana.DefaultBandanaManager.getValue(DefaultBandanaManager.java:33)
      at com.atlassian.confluence.plugin.BandanaPluginStateStore.loadPluginState(BandanaPluginStateStore.java:28)
      at com.atlassian.plugin.DefaultPluginManager.getState(DefaultPluginManager.java:126)
      at com.atlassian.plugin.DefaultPluginManager.isPluginEnabled(DefaultPluginManager.java:514)
      at com.atlassian.plugin.DefaultPluginManager.isPluginModuleEnabled(DefaultPluginManager.java:509)
      at com.atlassian.plugin.DefaultPluginManager.addPlugin(DefaultPluginManager.java:170)
      at com.atlassian.confluence.plugin.ConfluencePluginManager.addPlugin(ConfluencePluginManager.java:222)
      at com.atlassian.plugin.DefaultPluginManager.init(DefaultPluginManager.java:50)
      at com.atlassian.confluence.plugin.ConfluencePluginManager.init(ConfluencePluginManager.java:56)
      at com.atlassian.confluence.plugin.ConfluencePluginManager.onApplicationEvent(ConfluencePluginManager.java:90)
      at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:68)
      at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:218)
      at com.atlassian.event.DefaultEventManager.publishEvent(DefaultEventManager.java:44)
      at com.atlassian.confluence.event.ConfluenceEventManager.publishEvent(ConfluenceEventManager.java:19)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:284)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      at $Proxy0.publishEvent(Unknown Source)
      at com.atlassian.confluence.setup.DefaultBootstrapManager.onApplicationEvent(DefaultBootstrapManager.java:61)
      at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:68)
      at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:218)
      at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:220)
      at com.atlassian.spring.container.SpringContainerContext.contextReloaded(SpringContainerContext.java:178)
      at com.atlassian.spring.container.ContainerContextLoaderListener.contextInitialized(ContainerContextLoaderListener.java:40)
      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3727)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4162)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
      at org.apache.catalina.core.StandardService.start(StandardService.java:450)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
      create table BANDANA (BANDANAID int8 not null, BANDANACONTEXT varchar(255), BANDANAKEY varchar(100), BANDANAVALUE text, primary key (BANDANAID))
      create table DECORATOR (DECORATORID int8 not null, SPACEKEY varchar(255), DECORATORNAME varchar(255), BODY text, LASTMODDATE timestamp, primary key (DECORATORID))
      2006-09-07 14:31:11,342 INFO [atlassian.confluence.upgrade.HiLoIdRepairUpgradeTask] doUpgrade Beginning upgrade: HiLoIdRepairUpgradeTask
      2006-09-07 14:31:11,576 INFO [atlassian.confluence.upgrade.HiLoIdRepairUpgradeTask] doUpgrade Setting new next_hi to 305
      2006-09-07 14:31:11,592 INFO [atlassian.confluence.upgrade.HiLoIdRepairUpgradeTask] doUpgrade Completed database update: HiLoIdRepairUpgradeTask

            [CONFSERVER-7015] Bandana table not found on upgrade to Confluence 2.3-dev

            No work has yet been logged on this issue.

              Unassigned Unassigned
              dave@atlassian.com dave (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: