Details

      Description

      Setting the property to jdbc.default.maximumPoolSize a lower number (20 is what we set on CI testing) than the default (100) will cause the upgrade to hang when updating company id and running the upgrade tool on a 6.1 or 6.2 database:

           [java] 17:22:23,550 WARN  [main][UpgradeProcess:443] Attempting to upgrade table AssetEntry by recreating the table due to: DB2 SQL Error: SQLCODE=-190, SQLSTATE=42837, SQLERRMC=ROOT.ASSETENTRY;DESCRIPTION, DRIVER=4.16.53
           [java] 17:22:23,550 INFO  [main][LoggingTimer:73] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#AssetEntry
           [java] 17:22:23,550 INFO  [main][Table:168] Starting backup of AssetEntry to /tmp/temp-db-AssetEntry-26362483655823568.tmp
           [java] 17:22:23,557 INFO  [main][Table:204] Finished backup of AssetEntry to /tmp/temp-db-AssetEntry-26362483655823568.tmp in 6 ms
           [java] 17:22:24,207 INFO  [main][LoggingTimer:39] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#AssetEntry in 657 ms
           [java] 17:22:24,208 WARN  [main][UpgradeProcess:462] Successfully recreated and upgraded table AssetEntry
           [java] 17:22:24,208 INFO  [main][LoggingTimer:39] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 677 ms
           [java] 17:22:24,208 INFO  [main][LoggingTimer:73] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeAsset#deleteOrphanedAssetEntries
           [java] 17:22:24,213 INFO  [main][LoggingTimer:39] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeAsset#deleteOrphanedAssetEntries in 5 ms
           [java] 17:22:24,214 INFO  [main][LoggingTimer:73] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeAsset#updateAssetEntries
           [java] 17:22:24,219 INFO  [main][LoggingTimer:39] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeAsset#updateAssetEntries in 5 ms
           [java] 17:22:24,220 INFO  [main][LoggingTimer:73] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeAsset#updateAssetVocabularies
           [java] 17:22:24,225 INFO  [main][LoggingTimer:39] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeAsset#updateAssetVocabularies in 5 ms
           [java] 17:22:24,225 INFO  [main][UpgradeProcess:103] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeAsset in 695ms
           [java] 17:22:24,225 INFO  [main][UpgradeProcess:86] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeAssetTagsResourcePermission
           [java] 17:22:24,225 INFO  [main][LoggingTimer:73] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeAssetTagsResourcePermission#deleteResourcePermissions
           [java] 17:22:24,227 INFO  [main][LoggingTimer:39] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeAssetTagsResourcePermission#deleteResourcePermissions in 2 ms
           [java] 17:22:24,227 INFO  [main][UpgradeProcess:103] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeAssetTagsResourcePermission in 2ms
           [java] 17:22:24,227 INFO  [main][UpgradeProcess:86] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId
           [java] 17:22:24,655 INFO  [pool-2-thread-1][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AnnouncementsFlag
           [java] 17:22:24,655 INFO  [pool-2-thread-4][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AssetTagStats
           [java] 17:22:24,655 INFO  [pool-2-thread-3][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AssetEntries_AssetTags
           [java] 17:22:24,655 INFO  [pool-2-thread-2][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AssetEntries_AssetCategories
           [java] 17:22:24,656 INFO  [pool-2-thread-2][UpgradeCompanyId:105] Adding column companyId to table AssetEntries_AssetCategories
           [java] 17:22:24,656 INFO  [pool-2-thread-11][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Groups_UserGroups
           [java] 17:22:24,657 INFO  [pool-2-thread-11][UpgradeCompanyId:105] Adding column companyId to table Groups_UserGroups
           [java] 17:22:24,656 INFO  [pool-2-thread-3][UpgradeCompanyId:105] Adding column companyId to table AssetEntries_AssetTags
           [java] 17:22:24,657 INFO  [pool-2-thread-12][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Image
           [java] 17:22:24,656 INFO  [pool-2-thread-10][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Groups_Roles
           [java] 17:22:24,656 INFO  [pool-2-thread-4][UpgradeCompanyId:105] Adding column companyId to table AssetTagStats
           [java] 17:22:24,656 INFO  [pool-2-thread-9][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Groups_Orgs
           [java] 17:22:24,656 INFO  [pool-2-thread-8][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#DLSyncEvent
           [java] 17:22:24,655 INFO  [pool-2-thread-1][UpgradeCompanyId:105] Adding column companyId to table AnnouncementsFlag
           [java] 17:22:24,655 INFO  [pool-2-thread-7][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#DLFileEntryTypes_DLFolders
           [java] 17:22:24,664 INFO  [pool-2-thread-31][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserTrackerPath
           [java] 17:22:24,655 INFO  [pool-2-thread-6][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#DLFileEntryMetadata
           [java] 17:22:24,665 INFO  [pool-2-thread-6][UpgradeCompanyId:105] Adding column companyId to table DLFileEntryMetadata
           [java] 17:22:24,655 INFO  [pool-2-thread-5][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#BrowserTracker
           [java] 17:22:24,664 INFO  [pool-2-thread-31][UpgradeCompanyId:105] Adding column companyId to table UserTrackerPath
           [java] 17:22:24,664 INFO  [pool-2-thread-7][UpgradeCompanyId:105] Adding column companyId to table DLFileEntryTypes_DLFolders
           [java] 17:22:24,664 INFO  [pool-2-thread-30][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_UserGroups
           [java] 17:22:24,666 INFO  [pool-2-thread-30][UpgradeCompanyId:105] Adding column companyId to table Users_UserGroups
           [java] 17:22:24,664 INFO  [pool-2-thread-8][UpgradeCompanyId:105] Adding column companyId to table DLSyncEvent
           [java] 17:22:24,663 INFO  [pool-2-thread-29][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Teams
           [java] 17:22:24,663 INFO  [pool-2-thread-9][UpgradeCompanyId:105] Adding column companyId to table Groups_Orgs
           [java] 17:22:24,663 INFO  [pool-2-thread-28][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Roles
           [java] 17:22:24,666 INFO  [pool-2-thread-28][UpgradeCompanyId:105] Adding column companyId to table Users_Roles
           [java] 17:22:24,663 INFO  [pool-2-thread-27][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Orgs
           [java] 17:22:24,666 INFO  [pool-2-thread-27][UpgradeCompanyId:105] Adding column companyId to table Users_Orgs
           [java] 17:22:24,663 INFO  [pool-2-thread-26][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Groups
           [java] 17:22:24,667 INFO  [pool-2-thread-26][UpgradeCompanyId:105] Adding column companyId to table Users_Groups
           [java] 17:22:24,663 INFO  [pool-2-thread-25][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserIdMapper
           [java] 17:22:24,663 INFO  [pool-2-thread-24][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserGroups_Teams
           [java] 17:22:24,667 INFO  [pool-2-thread-24][UpgradeCompanyId:105] Adding column companyId to table UserGroups_Teams
           [java] 17:22:24,662 INFO  [pool-2-thread-23][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserGroupRole
           [java] 17:22:24,662 INFO  [pool-2-thread-22][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserGroupGroupRole
           [java] 17:22:24,662 INFO  [pool-2-thread-10][UpgradeCompanyId:105] Adding column companyId to table Groups_Roles
           [java] 17:22:24,662 INFO  [pool-2-thread-20][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#ResourceBlockPermission
           [java] 17:22:24,668 INFO  [pool-2-thread-20][UpgradeCompanyId:105] Adding column companyId to table ResourceBlockPermission
           [java] 17:22:24,662 INFO  [pool-2-thread-21][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#TrashVersion
           [java] 17:22:24,662 INFO  [pool-2-thread-19][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#RatingsStats
           [java] 17:22:24,668 INFO  [pool-2-thread-19][UpgradeCompanyId:105] Adding column companyId to table RatingsStats
           [java] 17:22:24,662 INFO  [pool-2-thread-18][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#PortletPreferences
           [java] 17:22:24,668 INFO  [pool-2-thread-18][UpgradeCompanyId:105] Adding column companyId to table PortletPreferences
           [java] 17:22:24,661 INFO  [pool-2-thread-17][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#PasswordTracker
           [java] 17:22:24,668 INFO  [pool-2-thread-17][UpgradeCompanyId:105] Adding column companyId to table PasswordTracker
           [java] 17:22:24,661 INFO  [pool-2-thread-16][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#PasswordPolicyRel
           [java] 17:22:24,668 INFO  [pool-2-thread-16][UpgradeCompanyId:105] Adding column companyId to table PasswordPolicyRel
           [java] 17:22:24,661 INFO  [pool-2-thread-15][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#OrgLabor
           [java] 17:22:24,668 INFO  [pool-2-thread-15][UpgradeCompanyId:105] Adding column companyId to table OrgLabor
           [java] 17:22:24,661 INFO  [pool-2-thread-12][UpgradeCompanyId:105] Adding column companyId to table Image
           [java] 17:22:24,657 INFO  [pool-2-thread-14][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#OrgGroupRole
           [java] 17:22:24,656 INFO  [pool-2-thread-13][LoggingTimer:73] Starting com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#MBStatsUser
           [java] 17:22:24,673 INFO  [pool-2-thread-13][UpgradeCompanyId:105] Adding column companyId to table MBStatsUser
           [java] 17:22:24,673 INFO  [pool-2-thread-14][UpgradeCompanyId:105] Adding column companyId to table OrgGroupRole
           [java] 17:22:24,668 INFO  [pool-2-thread-21][UpgradeCompanyId:105] Adding column companyId to table TrashVersion
           [java] 17:22:24,668 INFO  [pool-2-thread-22][UpgradeCompanyId:105] Adding column companyId to table UserGroupGroupRole
           [java] 17:22:24,667 INFO  [pool-2-thread-23][UpgradeCompanyId:105] Adding column companyId to table UserGroupRole
           [java] 17:22:24,667 INFO  [pool-2-thread-25][UpgradeCompanyId:105] Adding column companyId to table UserIdMapper
           [java] 17:22:24,666 INFO  [pool-2-thread-29][UpgradeCompanyId:105] Adding column companyId to table Users_Teams
           [java] 17:22:24,665 INFO  [pool-2-thread-5][UpgradeCompanyId:105] Adding column companyId to table BrowserTracker
           [java] 17:32:24,669 INFO  [pool-2-thread-17][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#PasswordTracker in 600008 ms
           [java] 17:32:24,669 INFO  [pool-2-thread-12][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Image in 600012 ms
           [java] 17:32:24,669 INFO  [pool-2-thread-15][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#OrgLabor in 600008 ms
           [java] 17:32:24,669 INFO  [pool-2-thread-16][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#PasswordPolicyRel in 600008 ms
           [java] 17:32:24,669 INFO  [pool-2-thread-2][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AssetEntries_AssetCategories in 600014 ms
           [java] 17:32:24,673 INFO  [pool-2-thread-14][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#OrgGroupRole in 600016 ms
           [java] 17:32:24,673 INFO  [pool-2-thread-22][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserGroupGroupRole in 600011 ms
           [java] 17:32:24,673 INFO  [pool-2-thread-21][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#TrashVersion in 600011 ms
           [java] 17:32:24,673 INFO  [pool-2-thread-25][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserIdMapper in 600010 ms
           [java] 17:32:24,673 INFO  [pool-2-thread-29][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Teams in 600010 ms
           [java] 17:32:24,673 INFO  [pool-2-thread-23][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserGroupRole in 600011 ms
           [java] 17:32:24,673 INFO  [pool-2-thread-5][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#BrowserTracker in 600018 ms
           [java] 17:32:24,676 INFO  [pool-2-thread-11][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Groups_UserGroups in 600020 ms
           [java] 17:32:24,691 INFO  [pool-2-thread-30][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_UserGroups in 600027 ms
           [java] 17:32:24,691 INFO  [pool-2-thread-1][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AnnouncementsFlag in 600036 ms
           [java] 17:32:24,692 INFO  [pool-2-thread-28][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Roles in 600029 ms
           [java] 17:32:24,700 INFO  [pool-2-thread-31][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserTrackerPath in 600036 ms
           [java] 17:32:24,700 INFO  [pool-2-thread-27][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Orgs in 600037 ms
           [java] 17:32:24,700 INFO  [pool-2-thread-4][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AssetTagStats in 600045 ms
           [java] 17:32:24,700 INFO  [pool-2-thread-26][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Users_Groups in 600037 ms
           [java] 17:32:24,700 INFO  [pool-2-thread-6][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#DLFileEntryMetadata in 600045 ms
           [java] 17:32:24,702 INFO  [pool-2-thread-10][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Groups_Roles in 600046 ms
           [java] 17:32:24,702 INFO  [pool-2-thread-9][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#Groups_Orgs in 600046 ms
           [java] 17:32:24,704 INFO  [pool-2-thread-20][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#ResourceBlockPermission in 600042 ms
           [java] 17:32:24,700 INFO  [pool-2-thread-7][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#DLFileEntryTypes_DLFolders in 600045 ms
           [java] 17:32:24,701 INFO  [pool-2-thread-3][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#AssetEntries_AssetTags in 600046 ms
           [java] 17:32:24,704 INFO  [pool-2-thread-8][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#DLSyncEvent in 600048 ms
           [java] 17:32:24,704 INFO  [pool-2-thread-24][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#UserGroups_Teams in 600041 ms
           [java] 17:32:24,711 INFO  [pool-2-thread-18][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#PortletPreferences in 600049 ms
           [java] 17:32:24,711 INFO  [pool-2-thread-13][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#MBStatsUser in 600055 ms
           [java] 17:32:24,758 INFO  [pool-2-thread-19][LoggingTimer:39] Completed com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater#call#RatingsStats in 600096 ms
           [java] 17:32:24,758 INFO  [main][UpgradeProcess:103] Failed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId in 600531ms
           [java] 17:32:24,758 INFO  [main][UpgradeProcess:103] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 607914ms
           [java] com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.util.concurrent.ExecutionException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 600000ms.
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:97)
           [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
           [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
           [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
           [java] 	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:149)
           [java] 	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:85)
           [java] 	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:167)
           [java] 	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:104)
           [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           [java] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [java] 	at java.lang.reflect.Method.invoke(Method.java:498)
           [java] 	at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
           [java] Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.util.concurrent.ExecutionException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 600000ms.
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:97)
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:138)
           [java] 	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:85)
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
           [java] 	... 12 more
           [java] Caused by: java.util.concurrent.ExecutionException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 600000ms.
           [java] 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
           [java] 	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
           [java] 	at com.liferay.portal.upgrade.util.UpgradeCompanyId.doUpgrade(UpgradeCompanyId.java:65)
           [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:92)
           [java] 	... 15 more
           [java] Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 600000ms.
           [java] 	at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:601)
           [java] 	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:194)
           [java] 	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:144)
           [java] 	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
           [java] 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:403)
           [java] 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
           [java] 	at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source)
           [java] 	at com.liferay.portal.dao.db.DB2DB.isRequiresReorgTable(DB2DB.java:163)
           [java] 	at com.liferay.portal.dao.db.DB2DB.reorgTable(DB2DB.java:185)
           [java] 	at com.liferay.portal.dao.db.DB2DB.reorgTables(DB2DB.java:229)
           [java] 	at com.liferay.portal.dao.db.DB2DB.runSQL(DB2DB.java:83)
           [java] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
           [java] 	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:41)
           [java] 	at com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater.call(UpgradeCompanyId.java:109)
           [java] 	at com.liferay.portal.upgrade.util.UpgradeCompanyId$TableUpdater.call(UpgradeCompanyId.java:75)
           [java] 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
           [java] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
           [java] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
           [java] 	at java.lang.Thread.run(Thread.java:745)
         [delete] Deleting: /opt/dev/projects/github/liferay-portal-7.1.x-private/null322979926.properties
      

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 19 weeks, 1 day ago

                Packages

                Version Package
                7.0.0 DXP FP57
                7.0.0 DXP SP9
                7.0.X
                7.1.X
                7.2.X
                Master