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

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.4.3.7 CE GA7, 7.4.13 DXP U3, 7.4.3.22 CE GA22, 7.4.3.23 CE GA23, Master
• Component/s: Database Upgrade Framework
• Labels:
  • ee-ts
  • liferay-update-dxp-3-7413
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/111762

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.