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

Module fails to upgrade due to DB2 SQL Error: SQLCODE=-668, SQLSTATE=57007

    Details

      Description

      When upgrading Liferay DXP connected DB2, there's often the need to reorganize tables before being able to alter them. Liferay takes into account alter table and alter column type statements to consider the need to reorganize affected tables, but this is seemingly not enough. Many statements performed during upgrade may imply the need for table reorganization, but as not all SQL statements go through DB2DB class, that need may be unsatisfied until a SQL statement goes through DB2DB again, which may be too late.

      The fix proposed here uses a more aggressive strategy, verifying the need to reorganize the tables before delete from statements as well.

        Attachments

          Activity

            People

            Assignee:
            summer.zhang Summer Zhang
            Reporter:
            cleydyr.albuquerque Cleydyr Albuquerque (Inactive)
            Participants of an Issue:
            Recent user:
            Felipe Lins
            Engineering Assignee:
            Cleydyr Albuquerque (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              4 weeks, 4 days ago

                Packages

                Version Package
                7.4.3.7 CE GA7
                7.4.13 DXP U3
                7.4.3.22 CE GA22
                7.4.3.23 CE GA23
                Master