Uploaded image for project: 'Nuxeo ECM Build/Test Environment'
  1. Nuxeo ECM Build/Test Environment
  2. NXBT-525

Failed to execute async event default on listener createSocialDocumentListener

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: NXP-5.9
    • Component/s: Continuous Integration

      Description

      http://qa.nuxeo.org/jenkins/job/FT-nuxeo-master-selenium-social-collaboration-tomcat is failing and one of the reason is this error

      ERROR [org.nuxeo.ecm.core.event.impl.AsyncEventExecutor] Failed to execute async event default on listener createSocialDocumentListener
      org.nuxeo.ecm.core.api.ClientException: org.nuxeo.ecm.core.api.DocumentException: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "SOCIAL_DOCUMENT" ("ID", "ISPUBLIC") VALUES (?, ?)
      	at org.nuxeo.ecm.core.api.AbstractSession.publishDocument(AbstractSession.java:3075)
      	at org.nuxeo.ecm.core.api.AbstractSession.publishDocument(AbstractSession.java:3000)
      	at org.nuxeo.ecm.social.workspace.adapters.SocialDocumentAdapter.restrictToMembers(SocialDocumentAdapter.java:128)
      	at org.nuxeo.ecm.social.workspace.listeners.VisibilitySocialDocumentListener.updateSocialDocumentVisibility(VisibilitySocialDocumentListener.java:97)
      	at org.nuxeo.ecm.social.workspace.listeners.VisibilitySocialDocumentListener.handleEvent(VisibilitySocialDocumentListener.java:88)
      	at org.nuxeo.ecm.social.workspace.listeners.VisibilitySocialDocumentListener.handleEvent(VisibilitySocialDocumentListener.java:57)
      	at org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$ListenerWork.work(AsyncEventExecutor.java:164)
      	at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:162)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      	at java.lang.Thread.run(Thread.java:662)
      Caused by: org.nuxeo.ecm.core.api.DocumentException: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "SOCIAL_DOCUMENT" ("ID", "ISPUBLIC") VALUES (?, ?)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.checkIn(SQLSession.java:852)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLDocumentLive.checkIn(SQLDocumentLive.java:389)
      	at org.nuxeo.ecm.core.versioning.StandardVersioningService.doCheckIn(StandardVersioningService.java:321)
      	at org.nuxeo.ecm.core.versioning.VersioningComponent.doCheckIn(VersioningComponent.java:231)
      	at org.nuxeo.ecm.core.api.AbstractSession.publishDocument(AbstractSession.java:3041)
      	... 10 more
      Caused by: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "SOCIAL_DOCUMENT" ("ID", "ISPUBLIC") VALUES (?, ?)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:597)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:494)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:464)
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:466)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:342)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:318)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.checkIn(SessionImpl.java:1007)
      	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.checkIn(ConnectionImpl.java:280)
      	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.checkIn(SQLSession.java:849)
      	... 14 more
      Caused by: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: PRIMARY_KEY_2E ON PUBLIC.SOCIAL_DOCUMENT(ID); SQL statement:
      INSERT INTO "SOCIAL_DOCUMENT" ("ID", "ISPUBLIC") VALUES (?, ?) [23001-114]
      	at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1067)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:582)
      	... 22 more
      Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: PRIMARY_KEY_2E ON PUBLIC.SOCIAL_DOCUMENT(ID); SQL statement:
      INSERT INTO "SOCIAL_DOCUMENT" ("ID", "ISPUBLIC") VALUES (?, ?) [23001-114]
      	at org.h2.message.Message.getSQLException(Message.java:105)
      	at org.h2.message.Message.getSQLException(Message.java:116)
      	at org.h2.message.Message.getSQLException(Message.java:75)
      	at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:154)
      	at org.h2.index.BtreeLeaf.add(BtreeLeaf.java:67)
      	at org.h2.index.BtreeIndex.add(BtreeIndex.java:228)
      	at org.h2.table.TableData.addRow(TableData.java:121)
      	at org.h2.command.dml.Insert.update(Insert.java:101)
      	at org.h2.command.CommandContainer.update(CommandContainer.java:72)
      	at org.h2.command.Command.executeUpdate(Command.java:208)
      	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
      	at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1050)
      	... 23 more
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.