Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-7015

Bandana table not found on upgrade to Confluence 2.3-dev

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            dave@atlassian.com dave (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: