-
Bug
-
Resolution: Fixed
-
Medium
-
2.3-DR2
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
Hi Sergey,
I've created a ticket for you in support.atlassian.com, our support system, and you should get an email with the details soon. A Support Engineer will be in touch to help you resolve these issues.
Kind regards,
Denise
Atlassian Support - Sydney
Sergey Romanov
added a comment - Hello ppl,
Can i ask you for a little help?
Our company using JIRA+Confluence.
And i need to upgrade them from 4.1.1 + 3.2.1 to latest.
Confl. using jira-s user database.
During update i need to move from MySQL to PGSQL.
But, when i'm trying to attach Confl. to Jira I've got error , that you described here .
Maybe i need to manually create this table? How can I do this?
Sergey Romanov
added a comment - Hello ppl,
Can i ask you for a little help?
Our company using JIRA+Confluence.
And i need to upgrade them from 4.1.1 + 3.2.1 to latest.
Confl. using jira-s user database.
During update i need to move from MySQL to PGSQL.
But, when i'm trying to attach Confl. to Jira I've got error , that you described here .
Maybe i need to manually create this table? How can I do this? 
Neil Crow
added a comment - OK Fixed, created function _pg_keypositions() as per this link http://forum.hibernate.org/viewtopic.php?t=957909&view=next
Neil Crow
added a comment - OK Fixed, created function _pg_keypositions() as per this link http://forum.hibernate.org/viewtopic.php?t=957909&view=next Neil Crow
added a comment - I am still getting this error while trying to upgrade from 2.2.7 to 2.7.3, running on CentOS linux, using postgres-8 remote db-server.
Neil Crow
added a comment - I am still getting this error while trying to upgrade from 2.2.7 to 2.7.3, running on CentOS linux, using postgres-8 remote db-server. 
Christopher Owen [Atlassian]
added a comment - This caused a lot of problems when making the upgradeManager a plugin, so we had to revert it.
Christopher Owen [Atlassian]
added a comment - This caused a lot of problems when making the upgradeManager a plugin, so we had to revert it.
Dear guys,
I have the same issue above using docker image latest version
Confluence image: atlassian/docker-atlassian-confluence-server
Postgres image: gcr.io/cloud-marketplace-containers/google/postgresql9:9.5
psql -U postgres create user confluence-db-user with password 'your-password'; create database confluencedb; grant all privileges on database confluencedb to confluence-db-user;}}