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

Database Patitioning - WARN Unable to check if the table xxx is a control table thrown in console during start up

    Details

      Description

      Steps to Reproduce:

      1. Enable database partitioning by adding property "database.partition.enabled=true" into portal-ext.properties.
      2. Connect to an empty MySQL schema.
      3. 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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lily.chi Lily Chi
              Reporter:
              summer.zhang Summer Zhang
              Participants of an Issue:
              Recent user:
              Clarissa Velazquez
              Engineering Assignee:
              Lily Chi
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  7.4.3.6 CE GA6
                  7.4.13 DXP U2
                  Master