Need support page updated with information for Bamboo version 3.4.4

Our bamboo instance has corruption like that described on the linked support page| .

While testing the sql queries suggested there, I encountered some errors that indicate we are using different schema. It seems likely that the queries on that page were developed for a different version of Bamboo. We are running Bamboo 3.4.4.

I'll show below the queries we had trouble with and the errors that resulted. Note that these queries were modified to show the bad rows rather than delete them. (Please note also that, in contrast to the support page, our mysql database requires the table names be specified in UPPERCASE):


bq. ERROR 1054 (42S22) at line 1: Unknown column 'BUILDRESULTSUMMARY_ID' in 'IN/ALL/ANY subquery'


bq. ERROR 1054 (42S22) at line 1: Unknown column 'BUILDRESULTSUMMARY_ID' in 'IN/ALL/ANY subquery'

The problem is apparently that our USER_COMMIT table is different from what is shown on the figure on the support page:


mysql> describe USER_COMMIT;

|| Field || Type || Null|| Key|| Default|| Extra||

| COMMIT_ID | bigint(20) | NO | PRI | 0 | |

| AUTHOR_ID | bigint(20) | YES | MUL | NULL | |

| COMMIT_DATE | datetime | YES | | NULL | |

| COMMIT_COMMENT_CLOB | longtext | YES | | NULL | |


| COMMIT_REVISION | varchar(4000) | YES | MUL | NULL | |

6 rows in set (0.00 sec)


As you can see, it doesn't have a BUILDRESULTSUMMARY_ID field.

Please advise what sql queries we should run to ensure everything is cleaned up as it should be. Should we just skip the deletions corresponding to these two queries, or are alternate queries needed?

Thank you,

Ed Segall

2 answers

1 accepted


I corrected this page. As I said, it's really hard to keep up with different Bamboo versions as the DB schema gets changed all the time. I am sorry for all the confusion related with Bamboo versions. One thing to pay attention is that RELEVANT_CHANGESETS and REPOSITORY_CHANGESET tables didn't exist in the 3.2 version, but they exist in the 3.4.x, and the corresponding SQL queries should be different. By the way, the same type of corruption might involve one table or a list of tables, and in that KB article not all possible tables are listed.

Thanks a lot for helping us to improve our stuff. Please let me know if you have any further questions or concerns.


Thank you for this update.

I knew I had seen your name recently, but I didn't remember that it was on the page we were discussing until just now. Sorry for the oversight.

Yes, I thought about trying to come up with the changes myself, and concluded that I might not have enough information and even if I did, it would probably be best to just ask for help.

I'm all set, thank you.

Hi Ed,

I am sorry to see taht you are facing this problem. It is really hard to create very generic page to satisfy all Bamboo version databases. The Bamboo version on your mentioned article is for older than 3.4.4 instances. I would recommend the follwing options:

  1. You can downnload a tool like DBVisualizer and hook up to your Bamboo DB. A tool like that will allow you to have a better visibility to your DB connections seeing the changes like in the attached screenshot. Next, you can try to manually find the corruptions and clean.
  2. We've done a lot of improvements related to Bamboo DB corruptions, and you can try to upgrade to the latest version of Bamboo to see if the upgrade tasks can automatically handle the corruption.
  3. If the upgrade doesn't help, and if you are not comfortable finding the corruptions and cleaning them, please raise a new Bamboo ticketon on, and we will do our best to assist you.




Thank you for your response. I appreciate your suggestions (esp. DBVisualizer, which looks like a very useful tool). However:

- I did create a support ticket.

- As a result of that ticket, the original page was updated for Bamboo 3.4.4 on 12/6.

- As part of that conversation, I was told that the Bamboo version targeted on the original version of the page I referenced was newer, not older, than 3.4.4.


Suggest an answer

Log in or Join to answer
Community showcase
Louis De Jaeger
Posted yesterday in Off-topic

Friday fun: your best joke

Hi all Lets make this Friday fun really fun and post one (or more) of your best jokes! The joke can be about an Atlassian product, or just a really fun joke you want to share! I’m not the best j...

157 views 12 3
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot