-
Type:
Bug
-
Status: Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: NXP-5.9
-
Component/s: Continuous Integration
-
Tags:
-
Backlog priority:600
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
