[
https://jira.nuxeo.com/browse/NXP-7956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=106595#comment-106595
]
Olivier Grisel commented on NXP-7956:
-------------------------------------
16:16:09,833 ERROR [AsyncEventExecutor$Job] Failed to execute async event test
on listener sql-storage-binary-text
org.nuxeo.ecm.core.api.ClientException: Failed to save session
at
org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1860)
at
org.nuxeo.ecm.core.storage.sql.coremodel.BinaryTextListener.handleEvent(BinaryTextListener.java:170)
at
org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$Job.run(AsyncEventExecutor.java:159)
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.WrappedException: Exception:
org.nuxeo.ecm.core.api.DocumentException. message:
org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO
"HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE",
"MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION",
"ISVERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:146)
at
org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1856)
... 5 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Could not insert: INSERT
INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE",
"MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION",
"ISVERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:571)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:475)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:445)
at
org.nuxeo.ecm.core.storage.sql.CachingRowMapper.write(CachingRowMapper.java:368)
at
org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:292)
at
org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:282)
at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:268)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:144)
... 6 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.h2.jdbc.JdbcBatchUpdateException. message: Referential integrity constraint
violation: HIERARCHY_PARENTID_HIERARCHY_FK: PUBLIC.HIERARCHY FOREIGN
KEY(PARENTID) REFERENCES PUBLIC.HIERARCHY(ID); SQL statement:
INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY",
"PRIMARYTYPE", "MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION",
"MINORVERSION", "ISVERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[23002-114]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1067)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:563)
... 13 more
> Random crash in async event listeners on CoreFeature annotated tests with a
> repository init
> -------------------------------------------------------------------------------------------
>
> Key: NXP-7956
> URL: https://jira.nuxeo.com/browse/NXP-7956
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.4.2-SNAPSHOT
> Reporter: Olivier Grisel
> Assignee: Olivier Grisel
> Fix For: 5.5
>
>
> It seems that the H2 database does not handle concurrent writes on the
> fulltext table correctly and that can cause referential integrity related
> crashes when running the tests.
> I attach the typical stacktrace as first comment to this issue.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
