Getting an exception while running Confluence for the first time

[Serhat Mese]

Hi,

i am a beginner trying to develop a confluence plugin. First i am trying to run the confluence with the atlas-run command. The server starts but getting exceptions about the hsqldb schema update. So that when i open confluence home page i see a warning as follows...

"Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade"

The exception is as follows :

[INFO] [talledLocalContainer] alter table users add column id bigint

[INFO] [talledLocalContainer] 2011-07-11 15:55:58,872 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsucce

ssful: alter table users add column id bigint

[INFO] [talledLocalContainer] 2011-07-11 15:55:58,873 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute object

name already exists in statement [alter table users add column id bigint]

[INFO] [talledLocalContainer] 2011-07-11 15:55:58,875 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could n

ot complete schema update

[INFO] [talledLocalContainer] java.sql.SQLException: object name already exists in statement [alter table users add colu

mn id bigint]

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.Util.sqlException(Util.java:215)

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1826)

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(JDBCStatement.java:207)

[INFO] [talledLocalContainer] at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)

[INFO] [talledLocalContainer] at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167)

[INFO] [talledLocalContainer] at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelp

er.java:161)

[INFO] [talledLocalContainer] at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelp

er.java:134)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgrade

Manager.java:231)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManage

r.java:87)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeMan

ager.java:139)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitial

ized(UpgradeLauncherServletContextListener.java:28)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)

[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)

[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardService.start(StandardService.java:516)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

[INFO] [talledLocalContainer] at org.apache.catalina.startup.Catalina.start(Catalina.java:583)

[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

[INFO] [talledLocalContainer] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

[INFO] [talledLocalContainer] at java.lang.reflect.Method.invoke(Method.java:597)

[INFO] [talledLocalContainer] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)

[INFO] [talledLocalContainer] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

[INFO] [talledLocalContainer] Caused by: org.hsqldb.HsqlException: object name already exists

[INFO] [talledLocalContainer] at org.hsqldb.error.Error.error(Error.java:131)

[INFO] [talledLocalContainer] at org.hsqldb.error.Error.error(Error.java:101)

[INFO] [talledLocalContainer] at org.hsqldb.TableWorks.checkAddColumn(TableWorks.java:261)

[INFO] [talledLocalContainer] at org.hsqldb.TableWorks.addColumn(TableWorks.java:289)

[INFO] [talledLocalContainer] at org.hsqldb.StatementSchema.getResult(StatementSchema.java:496)

[INFO] [talledLocalContainer] at org.hsqldb.StatementSchema.execute(StatementSchema.java:266)

[INFO] [talledLocalContainer] at org.hsqldb.Session.executeCompiledStatement(Session.java:1300)

[INFO] [talledLocalContainer] at org.hsqldb.Session.executeDirectStatement(Session.java:1190)

[INFO] [talledLocalContainer] at org.hsqldb.Session.execute(Session.java:976)

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1818)

[INFO] [talledLocalContainer] ... 24 more

[INFO] [talledLocalContainer] 2011-07-11 15:55:58,939 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletC

ontextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationExcepti

on: Cannot update schema

[INFO] [talledLocalContainer] com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationExcep

tion: Cannot update schema

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManage

r.java:109)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeMan

ager.java:139)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitial

ized(UpgradeLauncherServletContextListener.java:28)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)

[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)

[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardService.start(StandardService.java:516)

[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

[INFO] [talledLocalContainer] at org.apache.catalina.startup.Catalina.start(Catalina.java:583)

[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

[INFO] [talledLocalContainer] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

[INFO] [talledLocalContainer] at java.lang.reflect.Method.invoke(Method.java:597)

[INFO] [talledLocalContainer] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)

[INFO] [talledLocalContainer] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

[INFO] [talledLocalContainer] Caused by: com.atlassian.config.ConfigurationException: Cannot update schema

[INFO] [talledLocalContainer] at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelp

er.java:165)

[INFO] [talledLocalContainer] at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelp

er.java:134)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgrade

Manager.java:231)

[INFO] [talledLocalContainer] at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManage

r.java:87)

[INFO] [talledLocalContainer] ... 17 more

[INFO] [talledLocalContainer] Caused by: java.sql.SQLException: object name already exists in statement [alter table use

rs add column id bigint]

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.Util.sqlException(Util.java:215)

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1826)

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(JDBCStatement.java:207)

[INFO] [talledLocalContainer] at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)

[INFO] [talledLocalContainer] at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167)

[INFO] [talledLocalContainer] at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelp

er.java:161)

[INFO] [talledLocalContainer] ... 20 more

[INFO] [talledLocalContainer] Caused by: org.hsqldb.HsqlException: object name already exists

[INFO] [talledLocalContainer] at org.hsqldb.error.Error.error(Error.java:131)

[INFO] [talledLocalContainer] at org.hsqldb.error.Error.error(Error.java:101)

[INFO] [talledLocalContainer] at org.hsqldb.TableWorks.checkAddColumn(TableWorks.java:261)

[INFO] [talledLocalContainer] at org.hsqldb.TableWorks.addColumn(TableWorks.java:289)

[INFO] [talledLocalContainer] at org.hsqldb.StatementSchema.getResult(StatementSchema.java:496)

[INFO] [talledLocalContainer] at org.hsqldb.StatementSchema.execute(StatementSchema.java:266)

[INFO] [talledLocalContainer] at org.hsqldb.Session.executeCompiledStatement(Session.java:1300)

[INFO] [talledLocalContainer] at org.hsqldb.Session.executeDirectStatement(Session.java:1190)

[INFO] [talledLocalContainer] at org.hsqldb.Session.execute(Session.java:976)

[INFO] [talledLocalContainer] at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1818)

[INFO] [talledLocalContainer] ... 24 more

Anyone getting the same exception or has any idea about the solution?

Thanks in advance...

[Huseyin Arda Nural · Accepted solution]

Hi Serhat,

I just switched back to Linux instead of windows and the problem is gone. must be some hibernate and hsqldb issue in windows.

[Serhat Mese]

Hi Arda,

i tried the same steps in another computer and didn't get the exception. i guess the problem is about the java version in my computer. i had java 1.5 and java 1.6. i defined the java_home as java 6 but it didn't help. the computer now i am using has only java 1.6. now i don't have such a problem.

if you have such a situaition try to have only one java version that is java 1.6..

[Huseyin Arda Nural]

i have exactly the same problem. Any help would be greatly appreciated.

[Serhat Mese]

thanks but it didn't help..any other suggestion?

[Serhat Mese]

hi,

i downloaded the Atlassian Plugin SDK 3.3.4. And the confluence versions are as follows stated in the pom.xml.

<confluence.version>3.5.2</confluence.version>

<confluence.data.version>3.5</confluence.data.version>

These are the defaut values, i didn't change anything in the pom or anywhere else...

thanks...

[David at David Simpson Apps]

Hmm. That looks just fine. I'm not sure what to suggest.

At this point, I'd perform an atlas-clean, then try it again.

Maven can be temperamental sometimes.

[David at David Simpson Apps]

It looks like Confluence is trying to upgrade on startup. Which version of the SDK are you using?

What's the Confluence version & data version as specified in the pom.xml? If you've copied these from an previous version, you may need to update them. What version of Confluence are you trying to develop against?