-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: Master
-
Fix Version/s: 7.0.0 DXP FP102, 7.0.10.16 DXP SP17, 7.0.X, 7.1.10 DXP FP25, 7.1.X, 7.2.10 DXP FP15, 7.2.X, 7.3.10.3 DXP SP3, 7.3.X, 7.4.2 CE GA3, 7.4.13 DXP GA1, Master
-
Component/s: Database Partitioning
-
Branch Version/s:7.3.x, 7.2.x, 7.1.x, 7.0.x
-
Backported to Branch:Committed
-
Fix Priority:5
-
Git Pull Request:
Steps to Reproduce:
- Start 7.4 DXP EP2 bundle connected to MySQL with "database.partition.enabled=true"
- Create 2 virtual instances
- Login to both instances
- Shutdown DXP
- Execute upgrade to master
Expected Result:
Upgrade can be completed on partitioned database.
Actual Result:
Upgrade fails to complete
INFO [main][VerifyProcess:91] Completed verification process com.liferay.portal.verify.VerifyResourcePermissions in 17 ms com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.NoSuchRoleException: No Role exists with the key {companyId=41169, name=Owner} at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:85) at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:191) at com.liferay.portal.tools.DBUpgrader._upgradePortal(DBUpgrader.java:433) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:170) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:162) at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:136) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:54) Caused by: com.liferay.portal.kernel.exception.NoSuchRoleException: No Role exists with the key {companyId=41169, name=Owner} at com.liferay.portal.service.persistence.impl.RolePersistenceImpl.findByC_N(RolePersistenceImpl.java:5767) at com.liferay.portal.service.impl.RoleLocalServiceImpl.getRole(RoleLocalServiceImpl.java:889) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) at com.sun.proxy.$Proxy189.getRole(Unknown Source) at com.liferay.portal.kernel.service.RoleLocalServiceUtil.getRole(RoleLocalServiceUtil.java:587) at com.liferay.portal.verify.VerifyResourcePermissions.verify(VerifyResourcePermissions.java:59) at com.liferay.portal.verify.VerifyResourcePermissions.doVerify(VerifyResourcePermissions.java:90) at com.liferay.portal.verify.VerifyProcess.lambda$verify$0(VerifyProcess.java:81) at com.liferay.portal.db.partition.DBPartitionUtil.forEachCompanyId(DBPartitionUtil.java:119) at com.liferay.portal.dao.db.BaseDB.process(BaseDB.java:307) at com.liferay.portal.kernel.dao.db.BaseDBProcess.process(BaseDBProcess.java:228) at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:68) ... 10 more
SQL dumps attached for each schema from 7.4 DXP EP2
- causes
-
LPS-135976 Random IllegalStateException on startup with DB partition enabled
- Closed