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

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

    Details

      Description

      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]
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              summer.zhang Summer Zhang
              Reporter:
              alberto.chaparro Alberto Chaparro
              Participants of an Issue:
              Recent user:
              Clarissa Velazquez
              Engineering Assignee:
              Alberto Chaparro
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                20 weeks, 1 day ago

                  Packages

                  Version Package
                  7.3.7 CE GA8
                  7.3.10 DXP FP2
                  7.3.X
                  7.4.1 CE GA2 DXP 7,4
                  Master