Hi Thomas,
I'm also trying to upgrade from 5.2.3 to 6.0.5 on MySQL and I'm facing severe errors during the transition. Well, to be honest, the transition completely fails due to the following error:
1Starting Liferay Portal Community Edition 6.0.5 CE (Bunyan / Build 6005 / August 16, 2010)
213:10:00,865 ERROR [JDBCExceptionReporter:101] Table 'tpliferay6.lock_' doesn't exist
313:10:01,974 INFO [BaseDB:399] Database does not support case sensitive queries
413:10:01,982 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
513:10:01,983 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
613:10:03,500 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
713:10:04,044 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
8com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
9 at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
10 at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
11 at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
12 at javax.servlet.GenericServlet.init(GenericServlet.java:212)
13 at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
14 at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
15 at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
16 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
17 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
18 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
19 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
20 at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
21 at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
22 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
23 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
24 at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
25 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
26 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
27 at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
28 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
29 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
30 at org.apache.catalina.core.StandardService.start(StandardService.java:519)
31 at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
32 at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
33 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
34 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
35 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
36 at java.lang.reflect.Method.invoke(Method.java:597)
37 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
38 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Tomcat stops after that. If I restart tomcat I get a duplicate key error on the table "dlfileentry".
Did you run into similar errors or does that scenario not sound familiar at all to you?
Any help is greatly appreciated.
/Dennis