Table User_ doesn't exist error when creating a virtual instance and having DB Partition and cluster enable

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.4.0 CE GA1, Master
• Fix Version/s: 7.3.7 CE GA8, 7.3.10 DXP FP2, 7.3.X, 7.4.1 CE GA2, 7.4.13 DXP GA1, Master
• Component/s: Database Partitioning
• Labels:
  • liferay-fixpack-dxp-2-7310
• Branch Version/s:
  7.3.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/101200

Steps to reproduce it:

1. Startup a cluster with DB Partition enabled (database.partition.enabled=true) in both nodes
2. Add a virtual instance

Expected:
The company (virtual instance) is created with no errors

Current results:
The company (virtual instance) is created but the following error is thrown:

Apr 27 15:38:11.293 build-10 [liferay-5db5b66cc6-dgbpd] [dxp] ERROR [default-3363][JDBCExceptionReporter:234] Table 'lpartition_48828.User_' doesn't exist
Apr 27 15:38:11.364 build-10 [liferay-5db5b66cc6-dgbpd] [dxp] ERROR [default-3363][CompanyThreadLocal:117] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
Apr 27 15:38:11.364 build-10 [liferay-5db5b66cc6-dgbpd] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
	at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:605) ~[portal-kernel.jar:?]
	at com.liferay.portal.service.persistence.impl.UserPersistenceImpl.fetchByC_DU(UserPersistenceImpl.java:4662) ~[portal-impl.jar:?]
	at com.liferay.portal.service.persistence.impl.UserPersistenceImpl.fetchByC_DU(UserPersistenceImpl.java:4563) ~[portal-impl.jar:?]
	at com.liferay.portal.service.impl.UserLocalServiceImpl.fetchDefaultUser(UserLocalServiceImpl.java:2194) ~[portal-impl.jar:?]
	at sun.reflect.GeneratedMethodAccessor183.invoke(Unknown Source) ~[?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_282]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_282]
	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66) ~[portal-kernel.jar:?]
	at com.sun.proxy.$Proxy1039.fetchDefaultUser(Unknown Source) ~[?:?]
	at com.liferay.portal.kernel.service.UserLocalServiceWrapper.fetchDefaultUser(UserLocalServiceWrapper.java:1198) ~[portal-kernel.jar:?]
	at sun.reflect.GeneratedMethodAccessor183.invoke(Unknown Source) ~[?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_282]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_282]
	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66) ~[portal-kernel.jar:?]
	at com.sun.proxy.$Proxy1040.fetchDefaultUser(Unknown Source) ~[?:?]
	at sun.reflect.GeneratedMethodAccessor183.invoke(Unknown Source) ~[?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_282]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_282]
	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
	at com.sun.proxy.$Proxy55.fetchDefaultUser(Unknown Source) ~[?:?]
	at com.liferay.portal.kernel.service.UserLocalServiceUtil.fetchDefaultUser(UserLocalServiceUtil.java:1109) ~[portal-kernel.jar:?]
	at com.liferay.portal.kernel.security.auth.CompanyThreadLocal._setCompanyId(CompanyThreadLocal.java:100) [portal-kernel.jar:?]
	at com.liferay.portal.kernel.security.auth.CompanyThreadLocal.setCompanyId(CompanyThreadLocal.java:51) [portal-kernel.jar:?]
	at com.liferay.portal.messaging.internal.DefaultMessageBus.sendMessage(DefaultMessageBus.java:250) [bundleFile:?]
	at com.liferay.portal.cluster.multiple.internal.ClusterLinkImpl.sendLocalMessage(ClusterLinkImpl.java:229) [bundleFile:?]
	at com.liferay.portal.cluster.multiple.internal.ClusterForwardReceiver.doReceive(ClusterForwardReceiver.java:45) [bundleFile:?]
	at com.liferay.portal.cluster.multiple.internal.BaseClusterReceiver$ReceiveRunnable.run(BaseClusterReceiver.java:252) [bundleFile:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_282]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_282]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_282]