Upgrade fails if the value of repositoryid is bigger than the maximum value of int

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.10 EE GA1, 6.2.X EE, 7.0.0 M4
• Fix Version/s: 6.2.4 CE GA5, 6.2.X EE, 7.0.0 M5
• Component/s: DM > Upgrade, Documents & Media
• Labels:
  • liferay-fixpack-portal-46-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 42
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/25077

1. Import the provided database dump from r2d2/ftp/ntnu81 to 6.1.20
2. Upgrade to 6.2

Actual behavior: the upgrade fails

Expected behavior: the upgrade shouldn't fail

This happens because the repositoryid in the Repository table is bigger than the max value of int.

In com.liferay.portal.kernel.upgrade.v6_2_0.BaseUpgradeAttachments there are two occurrences where a long field is fetched as an int, so if it is bigger than MAX_INT it fails with java.sql.SQLException: Number Overflow