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

org.hibernate.exception.ConstraintViolationException error is thrown when importing a LAR file when duplicated names exists in recycle bin

    Details

      Description

      org.hibernate.exception.ConstraintViolationException error is thrown when importing a LAR file with a JournalFolder/DLFolder/DLFileEntry that was sent to Recycle Bin and a new object with same name was created.

      Steps to Reproduce with JournalFolder

      1. Create a clean site
      2. Create a JournalFolder called Test
      3. Create a JournalArticle inside created folder
      4. Export to a LAR file both JournalFolder and JournalArticle
      5. Send JournalFolder to recycle bin
      6. Create a new JournalFolder with same name, called Test
      7. Import previous LAR file
        • Wrong behavior: LAR file is not imported and following exception is thrown:
          An unexpected error occurred with the publication process. Please check your portal and publishing configuration.
          com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        • Expected behavior: LAR file is imported and no exception is thrown

      Steps to Reproduce with DLFolder/DLFileEntry

      1. Create a clean site
      2. Create a DLFolder/DLFileEntry called Test
      3. Export to a LAR file with DLFolder/DLFileEntry
      4. Send DLFolder/DLFileEntry to recycle bin
      5. Create a new DLFolder/DLFileEntry with same name, called Test
      6. Import previous LAR file
        • Wrong behavior: LAR file is not imported and following exception is thrown:
          An unexpected error occurred with the publication process. Please check your portal and publishing configuration.
          com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        • Expected behavior: LAR file is imported and no exception is thrown

      Error messages in log files
      Following exceptions are displayed in log files:

      1. JournalFolder
        16:14:32,070 ERROR [liferay/background_task-1][BackgroundTaskMessageListener:165] Unable to execute background task
        com.liferay.exportimport.kernel.lar.PortletDataException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.restoreStagedModel(BaseStagedModelDataHandler.java:442)
                at com.liferay.exportimport.lar.BaseStagedModelDataHandler.restoreStagedModel(BaseStagedModelDataHandler.java:119)
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:366)
                at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:369)
                at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:355)
        [...]
                at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
                at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
                at java.lang.Thread.run(Thread.java:745)
        Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.doFindF_A_ByG_F(JournalFolderFinderImpl.java:279)
                at com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.findF_A_ByG_F(JournalFolderFinderImpl.java:90)
                at com.liferay.journal.service.impl.JournalFolderLocalServiceImpl.getFoldersAndArticles(JournalFolderLocalServiceImpl.java:387)
        [...]
                at com.liferay.journal.trash.JournalFolderTrashHandler.restoreTrashEntry(JournalFolderTrashHandler.java:225)
                at com.liferay.journal.exportimport.data.handler.JournalFolderStagedModelDataHandler.doRestoreStagedModel(JournalFolderStagedModelDataHandler.java:197)
                at com.liferay.journal.exportimport.data.handler.JournalFolderStagedModelDataHandler.doRestoreStagedModel(JournalFolderStagedModelDataHandler.java:49)
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.restoreStagedModel(BaseStagedModelDataHandler.java:435)
                ... 41 more
        Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:33)
                at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:194)
                at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:173)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:59)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:51)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.iterate(QueryUtil.java:45)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.iterate(QueryUtil.java:38)
                at com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.doFindF_A_ByG_F(JournalFolderFinderImpl.java:250)
                ... 112 more
        Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
                at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
                at com.liferay.portal.dao.orm.hibernate.event.NestableAutoFlushEventListener.onAutoFlush(NestableAutoFlushEventListener.java:69)
                at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
                at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1837)
                at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
                at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
                at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:182)
                ... 118 more
        Caused by: java.sql.BatchUpdateException: Batch entry 0 update JournalFolder set uuid_='df76d82a-5016-0098-566a-7fc7a2723009', groupId=72910, companyId=20116, userId=20164, userName='Test Test', createDate='2017-11-07 16:12:51.460000+00', modifiedDate='2017-11-07 16:14:31.886000+00', parentFolderId=0, treePath='/72960/', name='Prueba', description=NULL, restrictionType=0, lastPublishDate=NULL, status=0, statusByUserId=20164, statusByUserName='Test Test', statusDate='2017-11-07 16:14:31.954000+00' where folderId=72960 was aborted: ERROR: llave duplicada viola restricción de unicidad «ix_65026705»_  Detail: Ya existe la llave (groupid, parentfolderid, name)=(72910, 0, Prueba).  Call getNextException to see other errors in the batch. [Sanitized]
                at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2126)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:469)
                at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:791)
                at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1547)
                at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
                at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
                at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
                ... 127 more
        Caused by: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ix_65026705»_  Detail: Ya existe la llave (groupid, parentfolderid, name)=(72910, 0, Prueba). [Sanitized]
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
                ... 134 more
        
      2. DLFolder
        16:14:32,070 ERROR [liferay/background_task-1][BackgroundTaskMessageListener:165] Unable to execute background task
        com.liferay.exportimport.kernel.lar.PortletDataException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.restoreStagedModel(BaseStagedModelDataHandler.java:442)
                at com.liferay.exportimport.lar.BaseStagedModelDataHandler.restoreStagedModel(BaseStagedModelDataHandler.java:119)
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:366)
                at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:369)
                at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:355)
        [...]
                at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
                at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
                at java.lang.Thread.run(Thread.java:745)
        Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.doFindF_A_ByG_F(JournalFolderFinderImpl.java:279)
                at com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.findF_A_ByG_F(JournalFolderFinderImpl.java:90)
                at com.liferay.journal.service.impl.JournalFolderLocalServiceImpl.getFoldersAndArticles(JournalFolderLocalServiceImpl.java:387)
        [...]
                at com.liferay.journal.trash.JournalFolderTrashHandler.restoreTrashEntry(JournalFolderTrashHandler.java:225)
                at com.liferay.journal.exportimport.data.handler.JournalFolderStagedModelDataHandler.doRestoreStagedModel(JournalFolderStagedModelDataHandler.java:197)
                at com.liferay.journal.exportimport.data.handler.JournalFolderStagedModelDataHandler.doRestoreStagedModel(JournalFolderStagedModelDataHandler.java:49)
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.restoreStagedModel(BaseStagedModelDataHandler.java:435)
                ... 41 more
        Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:33)
                at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:194)
                at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:173)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:59)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:51)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.iterate(QueryUtil.java:45)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.iterate(QueryUtil.java:38)
                at com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.doFindF_A_ByG_F(JournalFolderFinderImpl.java:250)
                ... 112 more
        Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
                at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
                at com.liferay.portal.dao.orm.hibernate.event.NestableAutoFlushEventListener.onAutoFlush(NestableAutoFlushEventListener.java:69)
                at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
                at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1837)
                at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
                at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
                at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:182)
                ... 118 more
        Caused by: java.sql.BatchUpdateException: Batch entry 0 update JournalFolder set uuid_='df76d82a-5016-0098-566a-7fc7a2723009', groupId=72910, companyId=20116, userId=20164, userName='Test Test', createDate='2017-11-07 16:12:51.460000+00', modifiedDate='2017-11-07 16:14:31.886000+00', parentFolderId=0, treePath='/72960/', name='Prueba', description=NULL, restrictionType=0, lastPublishDate=NULL, status=0, statusByUserId=20164, statusByUserName='Test Test', statusDate='2017-11-07 16:14:31.954000+00' where folderId=72960 was aborted: ERROR: llave duplicada viola restricción de unicidad «ix_65026705»_  Detail: Ya existe la llave (groupid, parentfolderid, name)=(72910, 0, Prueba).  Call getNextException to see other errors in the batch. [Sanitized]
                at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2126)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:469)
                at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:791)
                at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1547)
                at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
                at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
                at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
                ... 127 more
        Caused by: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ix_65026705»_  Detail: Ya existe la llave (groupid, parentfolderid, name)=(72910, 0, Prueba). [Sanitized]
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
                ... 134 more
        
      3. DLFileEntry
        16:56:37,455 ERROR [liferay/background_task-1][BackgroundTaskMessageListener:165] Unable to execute background task
        com.liferay.exportimport.kernel.lar.PortletDataException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:424)
                at com.liferay.document.library.internal.exportimport.data.handler.FileEntryStagedModelDataHandler.importStagedModel(FileEntryStagedModelDataHandler.java:182)
                at com.liferay.document.library.internal.exportimport.data.handler.FileEntryStagedModelDataHandler.importStagedModel(FileEntryStagedModelDataHandler.java:97)
                at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:369)
                at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:355)
        [...]
                at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
                at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
                at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
                at java.lang.Thread.run(Thread.java:745)
        Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:264)
                at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileVersionPersistenceImpl.findByFileEntryId(DLFileVersionPersistenceImpl.java:2180)
                at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileVersionPersistenceImpl.findByFileEntryId(DLFileVersionPersistenceImpl.java:2069)
        [...]
                at com.liferay.portal.repository.liferayrepository.model.LiferayFileEntry.getLatestFileVersion(LiferayFileEntry.java:272)
                at com.liferay.document.library.internal.exportimport.data.handler.FileEntryStagedModelDataHandler.doImportStagedModel(FileEntryStagedModelDataHandler.java:461)
                at com.liferay.document.library.internal.exportimport.data.handler.FileEntryStagedModelDataHandler.doImportStagedModel(FileEntryStagedModelDataHandler.java:97)
                at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:373)
                ... 41 more
        Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                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:109)
                at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:59)
                at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileVersionPersistenceImpl.findByFileEntryId(DLFileVersionPersistenceImpl.java:2161)
                ... 63 more
        Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
                at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
                at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
                at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
                at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2542)
                at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2495)
                at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2822)
                at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113)
                at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
                at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
                at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
                at com.liferay.portal.dao.orm.hibernate.event.NestableAutoFlushEventListener.onAutoFlush(NestableAutoFlushEventListener.java:69)
                at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
                at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
                at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
                at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:118)
                ... 66 more
        Caused by: java.sql.BatchUpdateException: Batch entry 0 update DLFileEntry set uuid_='6e2e0249-52d3-26cc-5138-6a78023dc594', groupId=72910, companyId=20116, userId=20164, userName='Test Test', createDate='2017-11-07 16:53:54.216000+00', modifiedDate='2017-11-07 16:53:54.231000+00', classNameId=0, classPK=0, repositoryId=72910, folderId=0, treePath='/', name='7309', fileName='Prueba', extension=NULL, mimeType='application/octet-stream', title='Prueba', description=NULL, extraSettings='', fileEntryTypeId=0, version='1.0', size_=0, readCount=0, smallImageId=0, largeImageId=0, custom1ImageId=0, custom2ImageId=0, manualCheckInRequired='FALSE', lastPublishDate=NULL where fileEntryId=73010 was aborted: ERROR: llave duplicada viola restricción de unicidad «ix_ed5ca615»_  Detail: Ya existe la llave (groupid, folderid, title)=(72910, 0, Prueba).  Call getNextException to see other errors in the batch. [Sanitized]
                at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2126)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:469)
                at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:791)
                at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1547)
                at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
                at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
                at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
                at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
                ... 82 more
        Caused by: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ix_ed5ca615»_  Detail: Ya existe la llave (groupid, folderid, title)=(72910, 0, Prueba). [Sanitized]
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
                ... 89 more
        

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lu.liu Lu Liu
              Reporter:
              jorge.diaz Jorge Diaz
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 14 weeks, 6 days ago

                  Packages

                  Version Package
                  7.1.10 DXP FP1
                  7.1.1 CE GA2
                  7.1.10.1 SP1
                  7.1.X
                  Master