PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-32793

Unable to complete an upgrade using sharding because it tries to upgrade the Quartz tables in all the shards

    Details

    • Fix Priority:
      4
    • Similar Issues:
      Show 5 results 

      Description

      This is only reproducible if you try an upgrade from 6.0.11 (or below) to 6.0.12 (or above)

      Steps to reproduce it:
      1- Startup Liferay portal 6.0 SP1 using sharding
      2- Create at least 2 virtual host
      3- Upgrade to 6.1GA2 using the changes of the issue LPS-31817 (it didn't caused the problem, it just brought it to light)

      The following exception is thrown:
      16:04:29,314 INFO [pool-2-thread-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeScheduler
      16:04:29,406 ERROR [pool-2-thread-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: java.sql.SQLSyntaxErrorException: ORA-00904: "STATE_": invalid identifier

      com.liferay.portal.kernel.events.ActionException: java.sql.SQLSyntaxErrorException: ORA-00904: "STATE_": invalid identifier

      The problem is that the portal is trying to upgrade the Quartz tables in all the shards but it's only necessary in the shard by default.

      Workaround:
      Execute the following query in all the shards except for the shard by default before performing the upgrade:
      CREATE TABLE quartz_job_details (
      JOB_NAME varchar(200) NOT NULL,
      JOB_GROUP varchar(200) NOT NULL,
      JOB_DATA longblob
      )

      (Mysql syntax, adapt it to yours)

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Days since last comment:
              2 years, 8 weeks, 2 days ago

              Development

                Structure Helper Panel