Backup failing with all-delete-orphan

Question

Hello,

We are facing an issue when trying to make an Export backup of our Confluence instance.

Running 6.2.3.

It fails after a minute with the following error:

javax.servlet.error.exception: org.springframework.orm.hibernate.HibernateSystemException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: com.atlassian.confluence.core.ContentEntityObject.contentProperties; nested exception is net.sf.hibernate.HibernateException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: com.atlassian.confluence.core.ContentEntityObject.contentProperties

This comes along with:

org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.atlassian.confluence.core.ContentEntityObject#8880792]

Thanks in advance, swimming in the dark here :(

Regards,

Jonathan

IT MayaHTT · Answer

Hi Ibrahim,

If I remember correctly, I ended up taking a full MySQL database backup, drop it, create a new one and restoring the backup.

Also, I migrated to latest Confuence version which has some useful requirements on MySQL database configuration.

Regards,

Jonathan

Ibrahim Farhan_f5udmq · Answer

Hello Jonathan,

I am facing the same problem.

is this problem solved?

Best regards,

Ibrahim

IT MayaHTT · Answer

Hi Boris, Thank you for your reply. I just tried disabling all plugins and it keeps failing with the same error. We use a mysql database. If it can help here is the property used in confluence.cfg.xml: jdbc:mysql://localhost/confluence?sessionVariables=storage_engine%3DInnoDB Regards, Jonathan