-
Type:
Bug
-
Status: Resolved
-
Resolution: Fixed
-
Affects Version/s: 7.4.13 DXP GA1, Master
-
Fix Version/s: 7.4.3.6 CE GA6, 7.4.13 DXP U2, Master
-
Component/s: Database Partitioning
-
Labels:
-
Fix Priority:3
-
Git Pull Request:
Steps to Reproduce:
- Enable database partitioning by adding property "database.partition.enabled=true" into portal-ext.properties.
- Connect to an empty MySQL schema.
- Start up portal.
Expected Results:
Portal start up without any WARN.
Actual Results:
Many WARN thrown in liferay console:
2021-12-16 07:01:33.695 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_923BD178 on Address (companyId, classNameId, classPK, mailing); 2021-12-16 07:01:33.696 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_9226DBB4 on Address (companyId, classNameId, classPK, primary_); 2021-12-16 07:01:33.696 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_58D4EA4C on Address (companyId, classNameId, classPK, typeId); 2021-12-16 07:01:33.698 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_CBAD282F on Address (companyId, externalReferenceCode); 2021-12-16 07:01:33.698 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_5A2093E7 on Address (countryId); 2021-12-16 07:01:33.699 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_C8E3E87D on Address (regionId); 2021-12-16 07:01:33.700 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_5BC8B0D4 on Address (userId); 2021-12-16 07:01:33.701 WARN [main][BaseDB:531] Unable to check if the table Address is a control table: create index IX_8FCB620E on Address (uuid_, companyId);
Reproduced on:
Tomcat 9.0.53 + MySQL 5.7. Portal master DXP GIT ID: 9acd4c5a650cc3682c3d6ab39feee286e0b7cbea.
Tomcat 9.0.53 + MySQL 5.7. Portal 7.4.13 GA1.
- causes
-
LPS-144609 Cannot execute upgrade with DB partitioning enabled due to "java.sql.SQLException: Connection is closed" error
- Resolved