[NXP-30436] Fix JSF UI WebDriver test log errors - Nuxeo Issue Tracker

XML

Word

Printable

Details

Type: Bug
Status: Resolved
Priority: Minor
Resolution: Cannot Reproduce
Affects Version/s: None
Fix Version/s: None
Component/s: CI/CD, Tests

Tags:
- ci/cd
- nxplatform
Team:
PLATFORM
Story Points:
3

Description

https://jenkins.platform.dev.nuxeo.com/job/nuxeo/job/11.x/job/nuxeo-jsf-ui/job/master/ is regularly failing at the Run "dev" functional tests stage with:

[2021-05-25T23:11:56.265Z] [Text Finder] Searching for pattern '.*ERROR.*' in file set 'ftests/**/log/server.log'...

[2021-05-25T23:11:56.954Z] /home/jenkins/workspace/nuxeo_11.x_nuxeo-jsf-ui_master/ftests/nuxeo-jsf-ui-webdriver-tests/target/tomcat/log/server.log:

[2021-05-25T23:11:56.956Z] 2021-05-25T23:00:01,760 ERROR [Nuxeo-Work-updateThumbListener-3:1486243246598787.1058931776] [org.nuxeo.ecm.core.work.AbstractWork] Exception during work: ListenerWork(Listener updateThumbListener [scheduleThumbnailUpdate/a2d7c4d9-2782-477f-8a71-f1280cb1962a], Progress(?%, ?/0), null)

[2021-05-25T23:11:56.973Z] 2021-05-25T23:00:01,762 ERROR [Nuxeo-Work-updateThumbListener-3:1486243246598787.1058931776] [org.nuxeo.ecm.core.event.impl.AsyncEventExecutor] Failed to execute async event default on listener updateThumbListener

Server logs below:

2021-05-25T23:00:01,758 WARN  [Nuxeo-Work-updateThumbListener-3:1486243246598787.1058931776] [Transaction] Unexpected exception from beforeCompletion; transaction will roll back
org.nuxeo.ecm.core.api.ConcurrentUpdateException: Concurrent update
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.checkConcurrentUpdate(JDBCConnection.java:172) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:543) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:454) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:431) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:364) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:274) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:246) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1256) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.end(SQLSession.java:870) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.beforeCompletion(RepositoryService.java:338) ~[nuxeo-core-11.5.120.jar:?]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:527) [geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:511) [geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:413) [geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:262) [geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) [geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) [nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) [nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.newTransaction(UpdateThumbnailListener.java:104) [nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.processDoc(UpdateThumbnailListener.java:98) [nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.handleEvent(UpdateThumbnailListener.java:156) [nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$ListenerWork.work(AsyncEventExecutor.java:209) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransaction(AbstractWork.java:533) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:385) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.WorkHolder.run(WorkHolder.java:57) [nuxeo-core-event-11.5.120.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "HIERARCHY_PARENTID_HIERARCHY_FK: PUBLIC.HIERARCHY FOREIGN KEY(PARENTID) REFERENCES PUBLIC.HIERARCHY(ID) ('a2d7c4d9-2782-477f-8a71-f1280cb1962a')"; SQL statement:
INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION", "ISVERSION", "ISRECORD", "RETAINUNTIL", "HASLEGALHOLD", "ISRETENTIONACTIVE", "ISTRASHED", "SYSTEMCHANGETOKEN", "CHANGETOKEN") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23506-200]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:459) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:319) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:261) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.table.Table.fireConstraints(Table.java:1057) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.table.Table.fireAfterRow(Table.java:1075) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.dml.Insert.insertRows(Insert.java:211) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.dml.Insert.update(Insert.java:151) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.CommandContainer.update(CommandContainer.java:198) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.Command.executeUpdate(Command.java:251) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:240) ~[h2-1.4.200.jar:1.4.200]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) ~[commons-dbcp2-2.8.0.jar:2.8.0]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) ~[commons-dbcp2-2.8.0.jar:2.8.0]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:531) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	... 25 more
2021-05-25T23:00:01,760 ERROR [Nuxeo-Work-updateThumbListener-3:1486243246598787.1058931776] [org.nuxeo.ecm.core.work.AbstractWork] Exception during work: ListenerWork(Listener updateThumbListener [scheduleThumbnailUpdate/a2d7c4d9-2782-477f-8a71-f1280cb1962a], Progress(?%, ?/0), null)
org.nuxeo.runtime.transaction.TransactionRuntimeException: Unable to commit: transaction marked for rollback
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:429) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.newTransaction(UpdateThumbnailListener.java:104) ~[nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.processDoc(UpdateThumbnailListener.java:98) ~[nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.handleEvent(UpdateThumbnailListener.java:156) ~[nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$ListenerWork.work(AsyncEventExecutor.java:209) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransaction(AbstractWork.java:533) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:385) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.WorkHolder.run(WorkHolder.java:57) [nuxeo-core-event-11.5.120.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: javax.transaction.RollbackException: Unable to commit: transaction marked for rollback
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more
Caused by: org.apache.geronimo.transaction.manager.SetRollbackOnlyException: setRollbackOnly() called.  See stacktrace for origin
	at org.apache.geronimo.transaction.manager.TransactionImpl.setRollbackOnly(TransactionImpl.java:126) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:243) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.setRollbackOnly(NuxeoContainer.java:358) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.setTransactionRollbackOnly(TransactionHelper.java:523) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1258) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.end(SQLSession.java:870) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.beforeCompletion(RepositoryService.java:338) ~[nuxeo-core-11.5.120.jar:?]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:527) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:511) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:413) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:262) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more
Caused by: org.nuxeo.ecm.core.api.ConcurrentUpdateException: Concurrent update
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.checkConcurrentUpdate(JDBCConnection.java:172) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:543) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:454) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:431) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:364) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:274) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:246) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1256) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.end(SQLSession.java:870) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.beforeCompletion(RepositoryService.java:338) ~[nuxeo-core-11.5.120.jar:?]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:527) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:511) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:413) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:262) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "HIERARCHY_PARENTID_HIERARCHY_FK: PUBLIC.HIERARCHY FOREIGN KEY(PARENTID) REFERENCES PUBLIC.HIERARCHY(ID) ('a2d7c4d9-2782-477f-8a71-f1280cb1962a')"; SQL statement:
INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION", "ISVERSION", "ISRECORD", "RETAINUNTIL", "HASLEGALHOLD", "ISRETENTIONACTIVE", "ISTRASHED", "SYSTEMCHANGETOKEN", "CHANGETOKEN") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23506-200]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:459) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:319) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:261) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.table.Table.fireConstraints(Table.java:1057) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.table.Table.fireAfterRow(Table.java:1075) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.dml.Insert.insertRows(Insert.java:211) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.dml.Insert.update(Insert.java:151) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.CommandContainer.update(CommandContainer.java:198) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.Command.executeUpdate(Command.java:251) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:240) ~[h2-1.4.200.jar:1.4.200]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) ~[commons-dbcp2-2.8.0.jar:2.8.0]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) ~[commons-dbcp2-2.8.0.jar:2.8.0]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:531) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:454) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:431) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:364) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:274) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:246) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1256) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.end(SQLSession.java:870) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.beforeCompletion(RepositoryService.java:338) ~[nuxeo-core-11.5.120.jar:?]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:527) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:511) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:413) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:262) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more
2021-05-25T23:00:01,762 ERROR [Nuxeo-Work-updateThumbListener-3:1486243246598787.1058931776] [org.nuxeo.ecm.core.event.impl.AsyncEventExecutor] Failed to execute async event default on listener updateThumbListener
org.nuxeo.runtime.transaction.TransactionRuntimeException: Unable to commit: transaction marked for rollback
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:429) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.newTransaction(UpdateThumbnailListener.java:104) ~[nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.processDoc(UpdateThumbnailListener.java:98) ~[nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.platform.thumbnail.listener.UpdateThumbnailListener.handleEvent(UpdateThumbnailListener.java:156) ~[nuxeo-thumbnail-11.5.120.jar:?]
	at org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$ListenerWork.work(AsyncEventExecutor.java:209) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransaction(AbstractWork.java:533) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:385) [nuxeo-core-event-11.5.120.jar:?]
	at org.nuxeo.ecm.core.work.WorkHolder.run(WorkHolder.java:57) [nuxeo-core-event-11.5.120.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: javax.transaction.RollbackException: Unable to commit: transaction marked for rollback
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more
Caused by: org.apache.geronimo.transaction.manager.SetRollbackOnlyException: setRollbackOnly() called.  See stacktrace for origin
	at org.apache.geronimo.transaction.manager.TransactionImpl.setRollbackOnly(TransactionImpl.java:126) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:243) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.setRollbackOnly(NuxeoContainer.java:358) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.setTransactionRollbackOnly(TransactionHelper.java:523) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1258) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.end(SQLSession.java:870) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.beforeCompletion(RepositoryService.java:338) ~[nuxeo-core-11.5.120.jar:?]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:527) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:511) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:413) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:262) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more
Caused by: org.nuxeo.ecm.core.api.ConcurrentUpdateException: Concurrent update
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.checkConcurrentUpdate(JDBCConnection.java:172) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:543) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:454) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:431) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:364) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:274) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:246) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1256) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.end(SQLSession.java:870) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.beforeCompletion(RepositoryService.java:338) ~[nuxeo-core-11.5.120.jar:?]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:527) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:511) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:413) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:262) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "HIERARCHY_PARENTID_HIERARCHY_FK: PUBLIC.HIERARCHY FOREIGN KEY(PARENTID) REFERENCES PUBLIC.HIERARCHY(ID) ('a2d7c4d9-2782-477f-8a71-f1280cb1962a')"; SQL statement:
INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION", "ISVERSION", "ISRECORD", "RETAINUNTIL", "HASLEGALHOLD", "ISRETENTIONACTIVE", "ISTRASHED", "SYSTEMCHANGETOKEN", "CHANGETOKEN") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23506-200]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:459) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:319) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:261) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.table.Table.fireConstraints(Table.java:1057) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.table.Table.fireAfterRow(Table.java:1075) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.dml.Insert.insertRows(Insert.java:211) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.dml.Insert.update(Insert.java:151) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.CommandContainer.update(CommandContainer.java:198) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.command.Command.executeUpdate(Command.java:251) ~[h2-1.4.200.jar:1.4.200]
	at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:240) ~[h2-1.4.200.jar:1.4.200]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) ~[commons-dbcp2-2.8.0.jar:2.8.0]
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) ~[commons-dbcp2-2.8.0.jar:2.8.0]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:531) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:454) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:431) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:364) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:274) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:246) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1256) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.end(SQLSession.java:870) ~[nuxeo-core-storage-sql-11.5.120.jar:?]
	at org.nuxeo.ecm.core.repository.RepositoryService$SessionSynchronization.beforeCompletion(RepositoryService.java:338) ~[nuxeo-core-11.5.120.jar:?]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:527) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.java:511) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:413) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:262) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) ~[geronimo-transaction-3.1.4.jar:3.1.4]
	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:418) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:414) ~[nuxeo-runtime-jtajca-11.5.120.jar:?]
	... 10 more

Maybe using MongoDB or PostgreSQL instead of H2 would help.

Attachments

Activity

People

Assignee:

Unassigned

Reporter:

Antoine Taillefer

Participants:

Antoine Taillefer, Kevin Leturc

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Created:

2021-05-26 08:25

Updated:

2023-06-20 11:41

Resolved:

2023-06-20 11:41