Hi,

the process upgrade from LR 5.2.3 CE to 6.1.0 CE( Last version from SVN Repository today ) for me failure with this exception :

-----------------------------------------------------------------
Starting Liferay Portal Community Edition 6.0.10 CE (Paton / Build 6100 / October 14, 2010)
12:32:03,080 ERROR [JDBCExceptionReporter:234] Table 'lportal.Lock_' doesn't exist
12:32:03,736 INFO [BaseDB:401] Database does not support case sensitive queries
12:32:03,751 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
12:32:03,753 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
12:32:15,668 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
12:32:24,983 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
12:32:24,990 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
12:32:25,012 INFO [Table:395] Starting backup of BlogsEntry to /opt/portal/liferay/tomcat/temp/temp-db-BlogsEntry-1289993545011
12:32:25,015 INFO [Table:431] Finished backup of BlogsEntry to /opt/portal/liferay/tomcat/temp/temp-db-BlogsEntry-1289993545011 in 3 ms
12:32:25,017 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
12:37:04,731 INFO [Table:395] Starting backup of DLFileEntry to /opt/portal/liferay/tomcat/temp/temp-db-DLFileEntry-1289993824731
12:37:05,191 INFO [Table:431] Finished backup of DLFileEntry to /opt/portal/liferay/tomcat/temp/temp-db-DLFileEntry-1289993824731 in 460 ms
12:37:06,596 INFO [Table:395] Starting backup of DLFileRank to /opt/portal/liferay/tomcat/temp/temp-db-DLFileRank-1289993826596
12:37:06,616 INFO [Table:431] Finished backup of DLFileRank to /opt/portal/liferay/tomcat/temp/temp-db-DLFileRank-1289993826596 in 20 ms
12:37:06,935 INFO [Table:395] Starting backup of DLFileShortcut to /opt/portal/liferay/tomcat/temp/temp-db-DLFileShortcut-1289993826935
12:37:06,937 INFO [Table:431] Finished backup of DLFileShortcut to /opt/portal/liferay/tomcat/temp/temp-db-DLFileShortcut-1289993826935 in 2 ms
12:37:06,996 INFO [Table:395] Starting backup of DLFileVersion to /opt/portal/liferay/tomcat/temp/temp-db-DLFileVersion-1289993826996
12:37:07,551 INFO [Table:431] Finished backup of DLFileVersion to /opt/portal/liferay/tomcat/temp/temp-db-DLFileVersion-1289993826996 in 555 ms
12:37:08,462 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeExpando
12:37:08,636 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeGroup
12:37:08,755 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeJournal
12:37:11,253 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradePolls
12:37:11,548 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradePortletId
12:37:11,799 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeResourceAction
12:37:11,863 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeShopping
12:37:12,110 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSocial
12:37:12,168 INFO [Table:395] Starting backup of SocialActivity to /opt/portal/liferay/tomcat/temp/temp-db-SocialActivity-1289993832168
12:37:12,206 INFO [Table:431] Finished backup of SocialActivity to /opt/portal/liferay/tomcat/temp/temp-db-SocialActivity-1289993832168 in 38 ms
12:37:12,942 INFO [Table:395] Starting backup of SocialRelation to /opt/portal/liferay/tomcat/temp/temp-db-SocialRelation-1289993832942
12:37:12,950 INFO [Table:431] Finished backup of SocialRelation to /opt/portal/liferay/tomcat/temp/temp-db-SocialRelation-1289993832942 in 8 ms
12:37:13,084 INFO [Table:395] Starting backup of SocialRequest to /opt/portal/liferay/tomcat/temp/temp-db-SocialRequest-1289993833084
12:37:13,086 INFO [Table:431] Finished backup of SocialRequest to /opt/portal/liferay/tomcat/temp/temp-db-SocialRequest-1289993833084 in 2 ms
12:37:13,177 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeWiki
12:37:13,340 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_1
12:37:13,347 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_1.UpgradeSchema
12:37:13,446 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_1.UpgradeDocumentLibrary
12:37:13,532 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_2
12:37:13,538 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeSchema
12:37:15,819 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeExpando
12:37:15,828 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeNestedPortlets
12:37:15,831 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_3
12:37:15,833 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeSchema
12:37:17,977 WARN [BaseDB:374] Duplicate column name 'minSymbols': alter table PasswordPolicy add minSymbols INTEGER;
12:37:18,494 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAsset
12:37:46,412 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAssetPublisher
12:37:46,420 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeDocumentLibrary
12:38:08,603 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeLookAndFeel
12:38:08,983 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradePermission
12:38:09,395 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeScopes
12:38:10,632 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeSitemap
12:38:10,648 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_5
12:38:10,649 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_5.UpgradeSchema
12:38:10,996 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_5.UpgradeJournal
12:38:11,409 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_5.UpgradeLayout
12:38:11,671 ERROR [MainServlet:214] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Illegal operation on empty result set.
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Illegal operation on empty result set.
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1190)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:211)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Illegal operation on empty result set.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Illegal operation on empty result set.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_5.doUpgrade(UpgradeProcess_6_0_5.java:35)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 36 more
Caused by: java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:841)
at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5656)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5576)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
at com.liferay.portal.upgrade.v6_0_5.UpgradeLayout.updateUUID(UpgradeLayout.java:126)
at com.liferay.portal.upgrade.v6_0_5.UpgradeLayout.updateUUID(UpgradeLayout.java:80)
at com.liferay.portal.upgrade.v6_0_5.UpgradeLayout.doUpgrade(UpgradeLayout.java:48)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 39 more
Stopping the server due to unexpected startup errors
-----------------------------------------------------------------

This is my technical configuration:

Database used :
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.0.67 SUSE MySQL RPM ( Connector 5.1.13 )

Server used: Apache Tomcat/6.0.29

Properties used to connect :

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&autoReconnect=true
jdbc.default.username=USERLR
jdbc.default.password=PASSLR
jdbc.default.maxIdleTime=3600


Thanks a lot.
Best regards.

Hi,

I solved thit my patch but I don't know if it is correct :

Post :
http://www.liferay.com/community/forums/-/message_boards/message/6560074

Hi,

I have just verified that this is a bug. It only happens when you are migrating form 5.2.x to 6.0.5 and you have a community using staging in which you have not published all the pages. If you publish all your pages before upgrading there shouldn't be any problem.

However, we have fixed the issue for next releases. You can see the changes here: LPS-14068


Cheers!

I want to upgrade my portal from 5.2.3 to 6.1.
Here we have discussed about problem facing during up-gradation process but not the actual up-gradation steps.
If anyone has done upgrade from 5.2.3 to 6.1 then please share the steps.