eXo JCR is throwing "Duplicate entry" and "(update) Property not found xxx. Probably was deleted by another session" errors in Portal

Solution Verified - Updated -

Issue

We are seeing errors like this in our Portal server:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'collaboration0' for key 'JCR_IDX_SVALUE_PROPERTY'

and

Caused by: org.exoplatform.services.jcr.impl.storage.JCRInvalidItemStateException: (update) Property not found []:1[]sites content:1[]live:1[]foo:1[]bar:1. Probably was deleted by another session 
at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCStorageConnection.update(CQJDBCStorageConnection.java:490)

and

Caused by: javax.jcr.RepositoryException: [collaboration] EDIT PROPERTY. Item already exists. But update errors. []:1[]sites content:1[]live:1[]foo:1[]bar:1 
Cause >>>> Lock wait timeout exceeded; try restarting transaction: Lock wait timeout exceeded; try restarting transaction

Environment

  • JBoss Enterprise Portal Platform (EPP)
    • 5.2
  • JBoss Portal Platform (JPP)
    • 6.0
  • eXo JCR 1.14 (and higher)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.