Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Concecutive API calls generate random Internal Server Error 500 org.springframework.transaction

We get the following errors while calling the detailed Confluence Cloud API endpoints in batch (tens of calls).
  • The calls are made consecutively (errors occurs whatever the delay between 200ms and 5000ms between each call).
  • The errors are intermittent: about 50-70% of calls end up with one or the other of the errors.
  • The errors occur unevenly, and don't seem to have any logic regarding what call works or not. For instance, in a process deleting all the children Pages of a parent Page, about half of the calls will fail on first execution (deleting about half of the Pages), then about 50% on the remaining pages on the 2nd second call, and so on until all the remaining pages are dseleted.
  • On the POST endpoint below, about 75% of the calls fail.
Error 1:
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
Error 2:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.JDBCException: Unable to acquire JDBC Connection
REST API calls generating a random mix of these errors:
axios.default.delete(`[our domain]/wiki/rest/api/content/${childPage.id}`,
   {
    headers: {
      "Authorization": `Basic ${TOKEN}`,
      "Accept": 'application/json',
      "Content-Type": 'application/json'
    }
  });
axios.default.post('[our domain]/wiki/rest/api/content',
  reqBodyData,
  {
    headers: {
      "Authorization": `Basic ${TOKEN}`,
      "Accept": 'application/json',
      "Content-Type": 'application/json'
    }
  });
Please can you advise what triggers those errors and how to run these APIs, at least consecutively, in an efficient manner (i.e. without too much delay between each call), without getting these errors?

1 answer

0 votes
Fabian Lim Community Leader Jan 04, 2022

Hi @sebastien_gillet

Check if you are using any specific plugins in the pages that causes issues: https://community.atlassian.com/t5/Confluence-questions/Error-Transaction-rolled-back-because-it-has-been-marked-as/qaq-p/1181849

Also, create a ticket with atlassian support and ask them to analyze the logs. 

Regards

Thank you @Fabian Lim 
We have reported the issue to Atlassian Support and investigating.
We will post back here when a solution is found.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

42,641 views 29 133
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you