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

[Gabriel Mustata]

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!

[Branden McElveen]

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