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

Upgrading a DB Partitioning DB from 7.4.1 to Master generates an Exception during the Upgrade

    Details

    • Fix Priority:
      4

      Description

      Description
      When upgrading a Database Partitioning DB from CE 7.4.1 GA2 to Master, an error is thrown in the Upgrade Logs. This then causes a bunch of errors to follow when you start the bundle. There does not seem to be any functional issues with the upgraded data dump, but the mass exceptions thrown in the console are alarming

      Steps to Reproduce

      1. Import attached data dump (should contain lportal, lpartiton_#####, lpartiton_#####)
      2. Make sure portal-upgrade-ext.properties has database.partition.enabled=true
      3. Upgrade database
      4. Start Portal

      Starting Error

      2021-09-22 21:47:07.868 ERROR [Portal Dependency Manager Component Executor--1][JDBCExceptionReporter:234] Table 'lpartition_39371.ObjectDefinition' doesn't exist
      2021-09-22 21:47:07.882 ERROR [Portal Dependency Manager Component Executor--1][SystemObjectDefinitionMetadataPortalInstanceLifecycleListener:93] bundle com.liferay.object.service:1.0.0 (662)[com.liferay.object.internal.instance.lifecycle.SystemObjectDefinitionMetadataPortalInstanceLifecycleListener(2825)] : The activate method has thrown an exception 
      com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      

      Gist
      https://gist.github.com/kyle-miho/71b1b718b585367e2592c72964a14db6

      Expected Result
      No Exceptions in upgrade console or startup

      Actual Result
      Exceptions in both upgrade console or startup

      Tested on Tomcat 9.0.43 + MySQL 5.7
      Portal master GIT ID: 60c178b91f14b75e9bd4b56cf43cf152c1dbb824

        Attachments

        1. mysql.sql
          6.47 MB
        2. mysql.sql
          6.47 MB

          Issue Links

            Activity

              People

              Assignee:
              kyle.miho Kyle Miho
              Reporter:
              kyle.miho Kyle Miho
              Participants of an Issue:
              Recent user:
              Maria Muriel
              Engineering Assignee:
              Kevin Lee
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                3 weeks, 1 day ago

                  Packages

                  Version Package
                  Master