Transaction : Write operations are not allowed in read-only mode

I’ve implemented the Extractor2 and from there I’m adding and removing outgoing links to pages. I’m using a TransactionTemplate as described in the first code block [here].(Hibernate sessions and transaction management guidelines).

Some customers have reported errors coming from such transactions though I was not able to repeat it. Customer is using Confluence DC 6.15.4.

Error is :

org.springframework.dao.InvalidDataAccessApiUsageException: Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode.COMMIT/AUTO or remove ‘readOnly’ marker from transaction definition. … at

[confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions: ->[null]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #600073409) Showing 10 last transactions at this level out of 20 in total: [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1045429045) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1380275581) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #2145306457) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #134397841) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1164519608) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1539868696) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1980512971) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #305437232) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1111260812) [com.atlassian.confluence.internal.index.attachment.DefaultAttachmentStatusManager.getAttachmentStatus]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT,readOnly (Session #1762050800)

Is there a workaround for this?

1 Like

Hi @boris.jockov,
Have you found a solution to this issue? Our customer reported the same issue.

Hi @boris.jockov - Did you find a solution for this error? I faced this issue in our test environment and Confluence went down.