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

Cannot upgrade to 7.0 if Calendar tables are not present

    Details

    • Fix Priority:
      5
    • Sprint:
      Sprint 08: Jan, 04 - Jan, 15

      Description

      Reproduced on:
      6.2 GA5 Portal
      Portal master GIT ID: b47ed6e9efe85dd078ac208bf9a31fe511376867.
      MySQL 5.6.25

      Steps to Reproduce:

      1. Unzip fresh 6.2 portal bundle
      2. Set database connection to mysql in portal-ext.properties
      3. Remove calendar (liferay-portal-6.2-ce-ga5/tomcat-7.0.42/webapps/calendar-portlet)
      4. Start bundle
      5. Go to localhost:8080
      6. On setup wizard click "Finish Configuration"
      7. Login
      8. Shut down bundle
      9. Go to db-upgrade tool (SOURCE/tools/db-upgrade)
        1. Configure portal-ext with properties
          index.read.only=true
          upgrade.processes.6204=${upgrade.processes.master}
          
        2. Modify build.xml
          <path id="lib.classpath">
          	<fileset dir="$TOMCAT_DIR/lib" includes="**/*.jar" />
          	<fileset dir="$TOMCAT_DIR/webapps/ROOT/WEB-INF/lib" includes="*.jar" />
          </path>
          
      10. Run ant upgrade

      Expected Result:
      Upgrade can be executed even if the calendar plugin was never used on 6.2.

      Actual Result:
      Upgrade fails due to missing calendar table:

      com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.calendarbooking' doesn't exist
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
           [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:184)
           [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:152)
           [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:134)
           [java] 	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
           [java] 	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
           [java] 	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:145)
           [java] 	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:67)
           [java] Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.calendarbooking' doesn't exist
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:83)
           [java] 	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:71)
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
           [java] 	... 7 more
           [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.calendarbooking' doesn't exist
           [java] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
           [java] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
           [java] 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
           [java] 	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
           [java] 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
           [java] 	at com.mysql.jdbc.Util.getInstance(Util.java:386)
           [java] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
           [java] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
           [java] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
           [java] 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
           [java] 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
           [java] 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788)
           [java] 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
           [java] 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
           [java] 	at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
           [java] 	at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
           [java] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:281)
           [java] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:251)
           [java] 	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:59)
           [java] 	at com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater.update(UpgradeCompanyId.java:87)
           [java] 	at com.liferay.portal.upgrade.util.UpgradeCompanyId.doUpgrade(UpgradeCompanyId.java:52)
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
           [java] 	... 10 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                victor.ware Victor Ware
                Reporter:
                victor.ware Victor Ware
                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, 36 weeks, 1 day ago

                  Packages

                  Version Package
                  7.0.0 Beta 3