Upgrading to Confluence 2.7.4 Fails with invalid column names
Symptoms
When upgrading to Confluence 2.7.4, some database tables/columns fail to become created
The following error is shown in the logs:
2011-07-26 00:41:30,602 ERROR [main] [com.atlassian.upgrade.AbstractUpgradeManager] doUpgrade Upgrade failed: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
.....
.....
2011-07-26 00:41:19,722 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 2.7.4 (build #1117)
2011-07-26 00:41:22,741 WARN [main] [sf.hibernate.cache.EhCacheProvider] buildCache Could not find configuration [com.atlassian.confluence.security.persistence.dao.hibernate.HibernateKey]; using defaults.
2011-07-26 00:41:30,417 INFO [main] [atlassian.confluence.upgrade.OSUserToAtlassianUserMigrationUpgradeTask] doUpgrade Detected standard user configuration, migrating user management.
2011-07-26 00:41:30,481 INFO [main] [atlassian.confluence.upgrade.OSUserToAtlassianUserMigrationUpgradeTask] userMigrationStarted Starting user migration. 56 users to migrate.
2011-07-26 00:41:30,602 ERROR [main] [com.atlassian.upgrade.AbstractUpgradeManager] doUpgrade Upgrade failed: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
Caused by: java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:594)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:537)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:587)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:624)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:667)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:705)
at com.atlassian.user.util.migration.OSUEntityMigrator.migratePropertySet(OSUEntityMigrator.java:245)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrateUsers(OSUEntityMigrator.java:167)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrate(OSUEntityMigrator.java:127)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy34.migrate(Unknown Source)
at com.atlassian.confluence.upgrade.OSUserToAtlassianUserMigrationUpgradeTask.doUpgrade(OSUserToAtlassianUserMigrationUpgradeTask.java:80)
at com.atlassian.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:106)
at com.atlassian.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:52)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:71)
at com.atlassian.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
caused by:
java.sql.SQLException: Invalid column name 'ENTITY_ID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:594)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:537)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:587)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:624)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:667)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:705)
at com.atlassian.user.util.migration.OSUEntityMigrator.migratePropertySet(OSUEntityMigrator.java:245)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrateUsers(OSUEntityMigrator.java:167)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrate(OSUEntityMigrator.java:127)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy34.migrate(Unknown Source)
at com.atlassian.confluence.upgrade.OSUserToAtlassianUserMigrationUpgradeTask.doUpgrade(OSUserToAtlassianUserMigrationUpgradeTask.java:80)
at com.atlassian.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:106)
at com.atlassian.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:52)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:71)
at com.atlassian.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
2011-07-26 00:41:30,607 FATAL [main] [com.atlassian.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
com.atlassian.upgrade.UpgradeException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
at com.atlassian.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:135)
at com.atlassian.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:52)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:71)
at com.atlassian.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:230)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:553)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:587)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:624)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:667)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:705)
at com.atlassian.user.util.migration.OSUEntityMigrator.migratePropertySet(OSUEntityMigrator.java:245)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrateUsers(OSUEntityMigrator.java:167)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrate(OSUEntityMigrator.java:127)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy34.migrate(Unknown Source)
at com.atlassian.confluence.upgrade.OSUserToAtlassianUserMigrationUpgradeTask.doUpgrade(OSUserToAtlassianUserMigrationUpgradeTask.java:80)
at com.atlassian.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:106)
... 18 more
Caused by: java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:594)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:537)
... 40 more
caused by:
java.sql.SQLException: Invalid column name 'ENTITY_ID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:594)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:537)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:587)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:624)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:667)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:705)
at com.atlassian.user.util.migration.OSUEntityMigrator.migratePropertySet(OSUEntityMigrator.java:245)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrateUsers(OSUEntityMigrator.java:167)
at com.atlassian.user.util.migration.OSUEntityMigrator.migrate(OSUEntityMigrator.java:127)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy34.migrate(Unknown Source)
at com.atlassian.confluence.upgrade.OSUserToAtlassianUserMigrationUpgradeTask.doUpgrade(OSUserToAtlassianUserMigrationUpgradeTask.java:80)
at com.atlassian.upgrade.AbstractUpgradeManager.doUpgrade(AbstractUpgradeManager.java:106)
at com.atlassian.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:52)
at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:71)
at com.atlassian.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
2011-07-26 00:41:30,610 ERROR [main] [com.atlassian.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade:
2011-07-26 00:41:30,610 ERROR [main] [com.atlassian.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: PreparedStatementCallback; bad SQL grammar [SELECT count\(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?|SELECT count(*) FROM OS_PROPERTYENTRY WHERE ENTITY_NAME=? AND ENTITY_ID=?]; nested exception is java.sql.SQLException: Invalid column name 'ENTITY_NAME'.
Cause
The exact cause is unknown, however the schema update process (hbm2dll) most likely failed to run (or run to completion) upon the upgrade.
Workarounds
There are three options:
Upgrade to Confluence 2.8.3 to force a schema update
Add
-Datlassian.forceSchemaUpdate=trueIn the setenv.bat file after the %JAVA_OPTS% variable. This file can be located at Confluence Installation\bin\.
After the upgrade is done remove the -Datlassian.forceSchemaUpdate=true line from the setenv.bat file.- If you are using MS SQL as your database server use below query:
ALTER DATABASE <database_name> COLLATE SQL_Latin1_General_CP1_CI_ASThat will change make your database case insensitive. After the upgrade is done shutdown your confluence and return your database to case sensitive with below query:
ALTER DATABASE <database_name> COLLATE SQL_Latin1_General_CP1_CS_AS
Last modified on Feb 26, 2016
Powered by Confluence and Scroll Viewport.