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

Lock acquisition exception on adding dl sync event causes dl app to fail adding file

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Won't Fix
    • Affects Version/s: Master
    • Fix Version/s: None
    • Component/s: Sync Connector
    • Labels:
      None

      Description

      Unable to add file 1
      com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.LockAcquisitionException: could not execute query
      	at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:264)
      	at com.liferay.document.library.sync.service.persistence.impl.DLSyncEventPersistenceImpl.fetchByTypePK(DLSyncEventPersistenceImpl.java:704)
      	at com.liferay.document.library.sync.service.persistence.impl.DLSyncEventPersistenceImpl.fetchByTypePK(DLSyncEventPersistenceImpl.java:633)
      	at com.liferay.document.library.sync.service.impl.DLSyncEventLocalServiceImpl.addDLSyncEvent(DLSyncEventLocalServiceImpl.java:36)
      	at sun.reflect.GeneratedMethodAccessor1724.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
      	at com.sun.proxy.$Proxy481.addDLSyncEvent(Unknown Source)
      	at com.liferay.document.library.internal.repository.capabilities.LiferaySyncCapability.registerDLSyncEventCallback(LiferaySyncCapability.java:153)
      	at com.liferay.document.library.internal.repository.capabilities.LiferaySyncCapability.registerDLSyncEventCallback(LiferaySyncCapability.java:135)
      	at com.liferay.document.library.internal.repository.capabilities.LiferaySyncCapability$SyncFileEntryRepositoryEventListener.execute(LiferaySyncCapability.java:257)
      	at com.liferay.document.library.internal.repository.capabilities.LiferaySyncCapability$SyncFileEntryRepositoryEventListener.execute(LiferaySyncCapability.java:247)
      	at com.liferay.portal.repository.registry.DefaultRepositoryEventRegistry.trigger(DefaultRepositoryEventRegistry.java:85)
      	at com.liferay.document.library.internal.repository.capabilities.LiferayRepositoryEventTriggerCapability.trigger(LiferayRepositoryEventTriggerCapability.java:39)
      	at com.liferay.portlet.documentlibrary.service.impl.DLAppHelperLocalServiceImpl.triggerRepositoryEvent(DLAppHelperLocalServiceImpl.java:1849)
      	at com.liferay.portlet.documentlibrary.service.impl.DLAppHelperLocalServiceImpl.updateStatus(DLAppHelperLocalServiceImpl.java:1115)
      	at sun.reflect.GeneratedMethodAccessor1979.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:67)
      	at com.sun.proxy.$Proxy410.updateStatus(Unknown Source)
      	at com.liferay.document.library.kernel.service.DLAppHelperLocalServiceWrapper.updateStatus(DLAppHelperLocalServiceWrapper.java:344)
      	at com.liferay.document.library.internal.service.ExternalRepositoryDLAppHelperLocalServiceWrapper.updateStatus(ExternalRepositoryDLAppHelperLocalServiceWrapper.java:119)
      	at sun.reflect.GeneratedMethodAccessor1979.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:67)
      	at com.sun.proxy.$Proxy411.updateStatus(Unknown Source)
      	at com.liferay.document.library.kernel.service.DLAppHelperLocalServiceWrapper.updateStatus(DLAppHelperLocalServiceWrapper.java:344)
      	at sun.reflect.GeneratedMethodAccessor1979.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:67)
      	at com.sun.proxy.$Proxy411.updateStatus(Unknown Source)
      	at com.liferay.document.library.kernel.service.DLAppHelperLocalServiceWrapper.updateStatus(DLAppHelperLocalServiceWrapper.java:344)
      	at com.liferay.document.library.internal.service.SubscriptionDLAppHelperLocalServiceWrapper.updateStatus(SubscriptionDLAppHelperLocalServiceWrapper.java:112)
      	at sun.reflect.GeneratedMethodAccessor1979.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:67)
      	at com.sun.proxy.$Proxy411.updateStatus(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor1979.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:51)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
      	at com.sun.proxy.$Proxy124.updateStatus(Unknown Source)
      	at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.updateStatus(DLFileEntryLocalServiceImpl.java:2122)
      	at sun.reflect.GeneratedMethodAccessor2126.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:51)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
      	at com.sun.proxy.$Proxy114.updateStatus(Unknown Source)
      	at com.liferay.document.library.internal.workflow.DLFileEntryWorkflowHandler.updateStatus(DLFileEntryWorkflowHandler.java:153)
      	at com.liferay.document.library.internal.workflow.DLFileEntryWorkflowHandler.updateStatus(DLFileEntryWorkflowHandler.java:51)
      	at com.liferay.portal.kernel.workflow.WorkflowHandlerRegistryUtil.startWorkflowInstance(WorkflowHandlerRegistryUtil.java:174)
      	at com.liferay.portlet.documentlibrary.util.DLImpl.startWorkflowInstance(DLImpl.java:1104)
      	at com.liferay.document.library.kernel.util.DLUtil.startWorkflowInstance(DLUtil.java:391)
      	at com.liferay.document.library.internal.repository.capabilities.LiferayWorkflowCapability.addFileEntry(LiferayWorkflowCapability.java:67)
      	at com.liferay.portal.repository.liferayrepository.LiferayWorkflowRepositoryWrapper.addFileEntry(LiferayWorkflowRepositoryWrapper.java:58)
      	at com.liferay.portal.repository.capabilities.CapabilityRepository.addFileEntry(CapabilityRepository.java:65)
      	at com.liferay.portlet.documentlibrary.service.impl.DLAppServiceImpl.addFileEntry(DLAppServiceImpl.java:212)
      	at com.liferay.portlet.documentlibrary.service.impl.DLAppServiceImpl.addFileEntry(DLAppServiceImpl.java:153)
      	at sun.reflect.GeneratedMethodAccessor2145.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:51)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
      	at com.sun.proxy.$Proxy123.addFileEntry(Unknown Source)
      	at com.liferay.document.library.kernel.service.DLAppServiceUtil.addFileEntry(DLAppServiceUtil.java:81)
      	at com.liferay.document.library.service.test.DLAppServiceTest.addFileEntry(DLAppServiceTest.java:1830)
      	at com.liferay.document.library.service.test.DLAppServiceTest.addFileEntry(DLAppServiceTest.java:1817)
      	at com.liferay.document.library.service.test.DLAppServiceTest$WhenAddingAFileEntry$AddFileEntryThread.doRun(DLAppServiceTest.java:442)
      	at com.liferay.portal.security.permission.DoAsUserThread.run(DoAsUserThread.java:61)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.LockAcquisitionException: could not execute query
      	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:33)
      	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:130)
      	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:103)
      	at com.liferay.document.library.sync.service.persistence.impl.DLSyncEventPersistenceImpl.fetchByTypePK(DLSyncEventPersistenceImpl.java:682)
      	... 105 more
      Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:107)
      	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      	at org.hibernate.loader.Loader.doList(Loader.java:2545)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      	at org.hibernate.loader.Loader.list(Loader.java:2271)
      	at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940)
      	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
      	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
      	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:118)
      	... 107 more
      Caused by: java.sql.SQLTransactionRollbackException: transaction rollback: serialization failure
      	at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:403)
      	at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:247)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4655)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(JDBCPreparedStatement.java:284)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
      	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      	at org.hibernate.loader.Loader.doList(Loader.java:2542)
      	... 114 more
      Caused by: org.hsqldb.HsqlException: transaction rollback: serialization failure
      	at org.hsqldb.error.Error.error(Error.java:136)
      	at org.hsqldb.error.Error.error(Error.java:106)
      	at org.hsqldb.Session.executeCompiledStatement(Session.java:1354)
      	at org.hsqldb.Session.execute(Session.java:1001)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4647)
      	... 122 more
      

        Attachments

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            shinn.lok Shinn Lok
            Participants of an Issue:
            Recent user:
            Michael Saechang
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              3 years, 18 weeks, 2 days ago

                Packages

                Version Package