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

WSRP hook fails to deploy due to UpgradeException

    Details

    • Type: Regression Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 7.0.0 Alpha 1
    • Fix Version/s: 7.0.0 Alpha 2
    • Component/s: WSRP
    • Labels:
      None

      Description

      Upgradexception occurs when deploying the WSRP hook. Unable to access the WSRP portlets in the Control Panel.

      20:34:50,489 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][AutoDeployDir:203] Processing wsrp-portlet-7.0.0.1.war
      20:34:50,490 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][PortletAutoDeployListener:79] Copying portlets for L:\git\public_2\master-bundles\deploy\wsrp-portlet-7.0.0.1.war
      20:34:50,590 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][BaseDeployer:878] Deploying wsrp-portlet-7.0.0.1.war
      20:34:50,616 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][BaseDeployer:983] Updating WSRP from version 7.0.0.1 to version 7.0.0.1
        Expanding: L:\git\public_2\master-bundles\deploy\wsrp-portlet-7.0.0.1.war into L:\git\public_2\master-bundles\tomcat-7.0.62\temp\20150914203450617
        Copying 1 file to L:\git\public_2\master-bundles\tomcat-7.0.62\temp\20150914203450617\WEB-INF
        Copying 1 file to L:\git\public_2\master-bundles\tomcat-7.0.62\temp\20150914203450617\WEB-INF\classes
        Copying 1 file to L:\git\public_2\master-bundles\tomcat-7.0.62\temp\20150914203450617\WEB-INF\classes
        Copying 1 file to L:\git\public_2\master-bundles\tomcat-7.0.62\temp\20150914203450617\WEB-INF\jsp
      20:34:51,956 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][BaseDeployer:2392] Modifying Servlet 2.4 L:\git\public_2\master-bundles\tomcat-7.0.62\temp\20150914203450617\WEB-INF\web.xml
        Copying 410 files to L:\git\public_2\master-bundles\tomcat-7.0.62\webapps\wsrp-portlet
        Copying 1 file to L:\git\public_2\master-bundles\tomcat-7.0.62\webapps\wsrp-portlet
        Deleting directory L:\git\public_2\master-bundles\tomcat-7.0.62\temp\20150914203450617
      20:34:53,026 INFO  [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][PortletAutoDeployListener:91] Portlets for L:\git\public_2\master-bundles\deploy\wsrp-portlet-7.0.0.1.war copied successfully. Deployment will start in a few seconds.
      Sep 14, 2015 8:35:05 PM org.apache.catalina.startup.HostConfig reload
      INFO: Reloading context [/wsrp-portlet]
      Sep 14, 2015 8:35:05 PM org.apache.catalina.core.StandardContext reload
      INFO: Reloading Context with name [/wsrp-portlet] has started
      Sep 14, 2015 8:35:06 PM org.apache.catalina.startup.TldConfig execute
      INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
      20:35:06,514 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][HotDeployImpl:222] Deploying wsrp-portlet from queue
      20:35:06,515 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][PluginPackageUtil:1007] Reading plugin package for wsrp-portlet
      20:35:06,539 INFO  [elasticsearch[Benny Beckley][clusterService#updateTask][T#1]][metadata:314] [Benny Beckley] [0] update_mapping [LiferayDocumentType] (dynamic)
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/portlet.properties
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/service.properties
      20:35:06,604 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][ServiceComponentLocalServiceImpl:323] Running WSRP SQL scripts
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/portlet.properties
      Sep 14, 2015 8:35:06 PM org.apache.catalina.core.ApplicationContext log
      INFO: Initializing Spring root WebApplicationContext
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/service.properties
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/service.properties
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/service.properties
      20:35:07,229 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][HookHotDeployListener:474] Registering hook for wsrp-portlet
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/portal.properties
      20:35:07,242 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.UpgradeProcess_1_0_0
      20:35:07,243 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.v1_0_0.UpgradeWSRPConsumer
      20:35:07,253 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.v1_0_0.UpgradeWSRPConsumer in 10ms
      20:35:07,254 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.v1_0_0.UpgradeWSRPConsumerPortlet
      20:35:07,269 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.v1_0_0.UpgradeWSRPConsumerPortlet in 15ms
      20:35:07,271 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.v1_0_0.UpgradeWSRPProducer
      20:35:07,278 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.v1_0_0.UpgradeWSRPProducer in 7ms
      20:35:07,278 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.UpgradeProcess_1_0_0 in 36ms
      20:35:07,279 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.UpgradeProcess_1_1_0
      20:35:07,281 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.v1_1_0.UpgradeUuid
      20:35:07,281 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.v1_1_0.UpgradeUuid in 0ms
      20:35:07,282 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.UpgradeProcess_1_1_0 in 3ms
      20:35:07,282 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.UpgradeProcess_1_2_0
      20:35:07,284 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:163] Upgrading com.liferay.wsrp.hook.upgrade.v1_2_0.UpgradeLastPublishDate
      20:35:07,285 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.v1_2_0.UpgradeLastPublishDate in 1ms
      20:35:07,286 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][UpgradeProcess:173] Completed upgrade process com.liferay.wsrp.hook.upgrade.UpgradeProcess_1_2_0 in 4ms
      20:35:07,287 ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]][HotDeployImpl:236] com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for wsrp-portlet
      com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for wsrp-portlet
              at com.liferay.portal.kernel.deploy.hot.BaseHotDeployListener.throwHotDeployException(BaseHotDeployListener.java:46)
              at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:275)
              at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:233)
              at com.liferay.portal.deploy.hot.HotDeployImpl.fireDeployEvent(HotDeployImpl.java:102)
              at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:28)
              at com.liferay.portal.kernel.servlet.PluginContextListener.fireDeployEvent(PluginContextListener.java:169)
              at com.liferay.portal.kernel.servlet.PluginContextListener.doPortalInit(PluginContextListener.java:159)
              at com.liferay.portal.kernel.util.BasePortalLifecycle.portalInit(BasePortalLifecycle.java:44)
              at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:74)
              at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:58)
              at com.liferay.portal.kernel.util.BasePortalLifecycle.registerPortalLifecycle(BasePortalLifecycle.java:54)
              at com.liferay.portal.kernel.servlet.PluginContextListener.contextInitialized(PluginContextListener.java:121)
              at com.liferay.portal.kernel.servlet.SecurePluginContextListener.contextInitialized(SecurePluginContextListener.java:151)
              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
              at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528)
              at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
              at org.apache.catalina.core.StandardContext.reload(StandardContext.java:4033)
              at org.apache.catalina.startup.HostConfig.reload(HostConfig.java:1524)
              at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1497)
              at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1695)
              at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:333)
              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
              at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
              at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1374)
              at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1546)
              at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1556)
              at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1524)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.wsrpconsumerportlet' doesn't exist
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:169)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:179)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:151)
              at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.updateRelease(ReleaseLocalServiceImpl.java:304)
              at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.updateRelease(ReleaseLocalServiceImpl.java:329)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:149)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:93)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:38)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:173)
              at com.sun.proxy.$Proxy282.updateRelease(Unknown Source)
              at com.liferay.portal.service.ReleaseLocalServiceUtil.updateRelease(ReleaseLocalServiceUtil.java:307)
              at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1822)
              at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1373)
              at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:485)
              at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:272)
              ... 26 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.wsrpconsumerportlet' doesn't exist
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:169)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:191)
              at com.liferay.wsrp.hook.upgrade.UpgradeProcess_1_2_0.doUpgrade(UpgradeProcess_1_2_0.java:32)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:166)
              ... 65 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.wsrpconsumerportlet' doesn't exist
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.Util.getInstance(Util.java:386)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
              at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
              at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119)
              at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:270)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:292)
              at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
              at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:36)
              at com.liferay.wsrp.hook.upgrade.v1_2_0.UpgradeLastPublishDate.doUpgrade(UpgradeLastPublishDate.java:26)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:166)
              ... 68 more
      20:35:07,300 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][PortletHotDeployListener:261] Registering portlets for wsrp-portlet
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/portlet.properties
      Loading file:/L:/git/public_2/master-bundles/tomcat-7.0.62/webapps/wsrp-portlet/WEB-INF/classes/portlet.properties
      20:35:07,917 INFO  [ContainerBackgroundProcessor[StandardEngine[Catalina]]][PortletHotDeployListener:408] 2 portlets for wsrp-portlet are available for use
      Sep 14, 2015 8:35:08 PM org.apache.catalina.core.StandardContext reload
      

        Attachments

          Activity

            People

            • Assignee:
              albert.lee Albert Lee
              Reporter:
              albert.lee Albert Lee
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 45 weeks, 2 days ago

                Packages

                Version Package
                7.0.0 Alpha 2