Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-11365

Upgrade Liferay 5.2.3 -> 6.0.3 fails for UpgradePermission

    Details

      Description

      After removing the Document Library content (http://issues.liferay.com/browse/LPS-11363) i continued with the upgrade.

      Loading jar:file:/C:/ontwikkel/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
      Loading jar:file:/C:/ontwikkel/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
      Loading file:/C:/ontwikkel/liferay-portal-6.0.3/portal-ext.properties
      Loading file:/C:/ontwikkel/liferay-portal-6.0.3/portal-ide.properties
      Loading file:/C:/ontwikkel/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/classes/portal-developer.properties
      10:51:09,442 INFO [DialectDetector:69] Determining dialect for MySQL 5
      10:51:09,697 INFO [DialectDetector:49] Using dialect org.hibernate.dialect.MySQLDialect
      10:51:17,995 INFO [PortalImpl:277] Global lib directory /C:/ontwikkel/liferay-portal-6.0.3/tomcat-6.0.26/lib/ext/
      10:51:17,998 INFO [PortalImpl:297] Portal lib directory /C:/ontwikkel/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/
      Starting Liferay Portal Community Edition 6.0.3 CE (Bunyan / Build 6003 / July 15, 2010)
      10:51:44,300 ERROR [JDBCExceptionReporter:101] Table 'lportal6.lock_' doesn't exist
      10:51:45,256 INFO [BaseDB:393] Database does not support case sensitive queries
      10:51:45,275 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
      10:51:45,277 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
      10:53:44,532 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
      10:58:30,596 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
      10:58:41,395 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
      10:58:41,440 INFO [Table:371] Starting backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279537121439
      10:58:43,690 INFO [Table:407] Finished backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279537121439 in 2250 ms
      10:58:54,529 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
      10:58:54,558 INFO [Table:371] Starting backup of DLFileEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileEntry-1279537134557
      10:58:54,563 INFO [Table:407] Finished backup of DLFileEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileEntry-1279537134557 in 5 ms
      10:58:54,834 INFO [Table:371] Starting backup of DLFileRank to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileRank-1279537134834
      10:58:54,841 INFO [Table:407] Finished backup of DLFileRank to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileRank-1279537134834 in 7 ms
      10:58:55,014 INFO [Table:371] Starting backup of DLFileShortcut to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileShortcut-1279537135014
      10:58:55,019 INFO [Table:407] Finished backup of DLFileShortcut to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileShortcut-1279537135014 in 5 ms
      10:58:55,175 INFO [Table:371] Starting backup of DLFileVersion to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileVersion-1279537135175
      10:58:55,180 INFO [Table:407] Finished backup of DLFileVersion to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-DLFileVersion-1279537135175 in 5 ms
      10:58:55,509 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeExpando
      10:58:57,626 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeGroup
      10:59:04,849 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeJournal
      10:59:08,416 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradePolls
      10:59:09,203 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradePortletId
      10:59:11,023 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeResourceAction
      10:59:11,284 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeShopping
      10:59:12,202 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSocial
      10:59:14,387 INFO [Table:371] Starting backup of SocialActivity to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-SocialActivity-1279537154387
      10:59:14,923 INFO [Table:407] Finished backup of SocialActivity to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-SocialActivity-1279537154387 in 536 ms
      11:03:10,783 INFO [Table:371] Starting backup of SocialRelation to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-SocialRelation-1279537390782
      11:03:10,808 INFO [Table:407] Finished backup of SocialRelation to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-SocialRelation-1279537390782 in 25 ms
      11:03:23,274 INFO [Table:371] Starting backup of SocialRequest to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-SocialRequest-1279537403274
      11:03:23,304 INFO [Table:407] Finished backup of SocialRequest to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-SocialRequest-1279537403274 in 30 ms
      11:03:30,758 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeWiki
      11:03:56,070 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_1
      11:03:56,072 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_1.UpgradeSchema
      11:03:56,477 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_1.UpgradeDocumentLibrary
      11:03:57,011 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_2
      11:03:57,013 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeSchema
      11:04:03,579 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeExpando
      11:04:03,603 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeNestedPortlets
      11:04:03,726 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_3
      11:04:03,730 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeSchema
      11:04:11,178 WARN [BaseDB:366] Duplicate column name 'minSymbols': alter table PasswordPolicy add minSymbols INTEGER;
      11:04:12,197 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAsset
      11:10:06,183 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAssetPublisher
      11:10:11,711 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeDocumentLibrary
      11:10:11,715 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeLookAndFeel
      11:10:11,953 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradePermission
      11:10:12,140 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: No value specified for parameter 2
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: No value specified for parameter 2
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
      at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1159)
      at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
      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:4187)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
      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:443)
      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:592)
      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: No value specified for parameter 2
      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: No value specified for parameter 2
      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_3.doUpgrade(UpgradeProcess_6_0_3.java:43)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 36 more
      Caused by: java.sql.SQLException: No value specified for parameter 2
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
      at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1718)
      at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1666)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1377)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.assignSingleApproverWorkflowRoles(UpgradePermission.java:195)
      at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.updatePermissions_5(UpgradePermission.java:313)
      at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.doUpgrade(UpgradePermission.java:247)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 39 more
      Stopping the server due to unexpected startup errors

      Probably

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 28 weeks ago

                Packages

                Version Package
                6.0.4 GA
                6.0.5 GA