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?

 

Thanks!

1 answer

0 votes

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!

Cheers,

Branden

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Monday in Jira Ops

Jira Ops Early Access Program Update #1: Announcing our next feature and a new integration

Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...

412 views 0 8
Read article

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