Bamboo backup failed with error : Transaction rolled back because it has been marked as rollback-onl Edited

Our weekly backups failed 6 times in a row with same message : 

[ScheduledBackupJob] org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only

I don't see much detail in the log. Where is the problem?

There is any way to manually trigger a backup? like in Confluence?



1 answer

This widget could not be displayed.

Hi Gabriel,

I see you put in a ticket with support and they were able to isolate the issue and resolve it for you.  They described the problem as such:

  • While exporting data, Bamboo looks for comments on the basis of the comment_id column of the table user_comment.
  • On the basis of this comment_id Bamboo then gets the content (the Comment itself) to export in the xml file
  • But, in your case the content itself is null(same can be seen in the file select_cmd1.txt) which is causing the issue.

The resolution was to update the table with some dummy comment.
For example:

update user_comment set content='Dummy Comment' where content is null;

What was unclear was how the comments were null and whether you are using any plugin for populating the comments. 

Please update the Support advisor working on the case so they can close that out and once you're done if there is anything else to add to the resolution let the community know!



Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 12 hours ago in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

39 views 1 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you