Bamboo not starting after upgrage

2017-08-29 14:23:13fatalbootstrapBamboo bootstrap failed: Failed to run pre-bootstrap upgrade tasks. Please contact Atlassian Support at https://support.atlassian.com

I tried updating license key in cfg.xml - this didn't work.

The log seems to indicate an issue with removing constraints

 

 

2017-08-29 14:17:57,786 INFO [localhost-startStop-1] [AbstractUpgradeManager] -----------------------------------------------------------
2017-08-29 14:17:57,786 INFO [localhost-startStop-1] [AbstractUpgradeManager] 51605 : Remove foreign keys from renamed tables (bootstrap)
2017-08-29 14:17:57,786 INFO [localhost-startStop-1] [AbstractUpgradeManager] -----------------------------------------------------------
2017-08-29 14:17:57,786 DEBUG [localhost-startStop-1] [JdbcUtils] Executing: [select object_schema_name(object_id('PROJECT'))]
2017-08-29 14:17:57,786 TRACE [localhost-startStop-1] [JdbcUtils] Executing: [select object_schema_name(object_id('PROJECT'))] took 957.9 ?s
2017-08-29 14:17:57,786 INFO [localhost-startStop-1] [AbstractDbmsBean] Detected schema: dbo
2017-08-29 14:17:57,801 DEBUG [localhost-startStop-1] [JdbcUtils] Executing: [select dc.NAME as CONSTRAINT_NAME, c.NAME as COLUMN_NAME, 'CHECK' as CONSTRAINT_TYPE from sys.tables t inner join sys.default_constraints dc on t.OBJECT_ID = dc.PARENT_OBJECT_ID inner join sys.columns c on dc.PARENT_OBJECT_ID = c.OBJECT_ID AND c.COLUMN_ID = dc.PARENT_COLUMN_ID inner join sys.schemas sc on sc.SCHEMA_ID = t.SCHEMA_ID where lower(t.NAME) = 'external_members' and sc.NAME = 'dbo']
2017-08-29 14:17:57,801 TRACE [localhost-startStop-1] [JdbcUtils] Executing: [select dc.NAME as CONSTRAINT_NAME, c.NAME as COLUMN_NAME, 'CHECK' as CONSTRAINT_TYPE from sys.tables t inner join sys.default_constraints dc on t.OBJECT_ID = dc.PARENT_OBJECT_ID inner join sys.columns c on dc.PARENT_OBJECT_ID = c.OBJECT_ID AND c.COLUMN_ID = dc.PARENT_COLUMN_ID inner join sys.schemas sc on sc.SCHEMA_ID = t.SCHEMA_ID where lower(t.NAME) = 'external_members' and sc.NAME = 'dbo'] took 1.344 ms
2017-08-29 14:17:57,801 DEBUG [localhost-startStop-1] [JdbcUtils] Executing: [select obj.NAME as CONSTRAINT_NAME, col1.NAME as COLUMN_NAME, 'FOREIGN KEY' as CONSTRAINT_TYPE from sys.foreign_key_columns fkc inner join sys.objects obj on obj.OBJECT_ID = fkc.CONSTRAINT_OBJECT_ID inner join sys.tables t on t.OBJECT_ID = fkc.PARENT_OBJECT_ID inner join sys.columns col1 on col1.COLUMN_ID = fkc.PARENT_COLUMN_ID and col1.OBJECT_ID = t.OBJECT_ID inner join sys.schemas sc on sc.SCHEMA_ID = t.SCHEMA_ID where lower(t.NAME) = 'external_members' and sc.NAME = 'dbo']
2017-08-29 14:17:57,801 TRACE [localhost-startStop-1] [JdbcUtils] Executing: [select obj.NAME as CONSTRAINT_NAME, col1.NAME as COLUMN_NAME, 'FOREIGN KEY' as CONSTRAINT_TYPE from sys.foreign_key_columns fkc inner join sys.objects obj on obj.OBJECT_ID = fkc.CONSTRAINT_OBJECT_ID inner join sys.tables t on t.OBJECT_ID = fkc.PARENT_OBJECT_ID inner join sys.columns col1 on col1.COLUMN_ID = fkc.PARENT_COLUMN_ID and col1.OBJECT_ID = t.OBJECT_ID inner join sys.schemas sc on sc.SCHEMA_ID = t.SCHEMA_ID where lower(t.NAME) = 'external_members' and sc.NAME = 'dbo'] took 1.761 ms
2017-08-29 14:17:57,801 DEBUG [localhost-startStop-1] [JdbcUtils] Executing: [select kc.NAME as CONSTRAINT_NAME, c.NAME AS COLUMN_NAME,(case kc.type_desc when 'PRIMARY_KEY_CONSTRAINT' then 'PRIMARY KEY' when 'UNIQUE_CONSTRAINT' then 'UNIQUE' end) as CONSTRAINT_TYPE from sys.key_constraints kc inner join sys.tables t on t.OBJECT_ID = kc.PARENT_OBJECT_ID inner join sys.index_columns ic on ic.OBJECT_ID = t.OBJECT_ID and ic.index_id = kc.UNIQUE_INDEX_ID inner join sys.columns c on c.OBJECT_ID = t.OBJECT_ID and c.COLUMN_ID = ic.COLUMN_ID inner join sys.schemas sc on sc.SCHEMA_ID = t.SCHEMA_ID where lower(t.NAME) = 'external_members' and sc.NAME = 'dbo']
2017-08-29 14:17:57,801 TRACE [localhost-startStop-1] [JdbcUtils] Executing: [select kc.NAME as CONSTRAINT_NAME, c.NAME AS COLUMN_NAME,(case kc.type_desc when 'PRIMARY_KEY_CONSTRAINT' then 'PRIMARY KEY' when 'UNIQUE_CONSTRAINT' then 'UNIQUE' end) as CONSTRAINT_TYPE from sys.key_constraints kc inner join sys.tables t on t.OBJECT_ID = kc.PARENT_OBJECT_ID inner join sys.index_columns ic on ic.OBJECT_ID = t.OBJECT_ID and ic.index_id = kc.UNIQUE_INDEX_ID inner join sys.columns c on c.OBJECT_ID = t.OBJECT_ID and c.COLUMN_ID = ic.COLUMN_ID inner join sys.schemas sc on sc.SCHEMA_ID = t.SCHEMA_ID where lower(t.NAME) = 'external_members' and sc.NAME = 'dbo'] took 4.089 ms
2017-08-29 14:17:57,817 DEBUG [localhost-startStop-1] [JdbcUtils] Executing: [alter table EXTERNAL_MEMBERS drop constraint FK_O35Y9WAFG8GXRHFEDX6P840A9]
2017-08-29 14:17:57,817 TRACE [localhost-startStop-1] [JdbcUtils] Executing: [alter table EXTERNAL_MEMBERS drop constraint FK_O35Y9WAFG8GXRHFEDX6P840A9] took 9.783 ms
2017-08-29 14:17:57,817 ERROR [localhost-startStop-1] [AbstractUpgradeManager] java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: 'FK_O35Y9WAFG8GXRHFEDX6P840A9' is not a constraint.
java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: 'FK_O35Y9WAFG8GXRHFEDX6P840A9' is not a constraint.

 

2 answers

0 vote

Hi Earl,

You may be running into BAM-18471.  Can you please run the following and then restart Bamboo and let us know the results:

ALTER TABLE EXTERNAL_MEMBERS DROP CONSTRAINT FK_O35Y9WAFG8GXRHFEDX6P840A9;

Cheers,

Branden

No go...

Effectively the same error:

Msg 3728, Level 16, State 1, Line 2
'FK_O35Y9WAFG8GXRHFEDX6P840A9' is not a constraint.
Msg 3727, Level 16, State 0, Line 2
Could not drop constraint. See previous errors.

bamboo-constraint.PNG

in the DB there is nothing in 'Constraints' the FK_... object is in 'keys'

Im thinking of creating the contraint so it can be deleted.

RESOLVED:

Case Sensitive.

Recreated constraints with uppercase names, deleted the lowercase names.

 

Process:

Start service

check log

stop service

fix constraint

start service

check log

stop service

fix constraint.... repeat until no more errors.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Renan Battaglin
Published May 18, 2017 in Bamboo

FAQ: How to Upgrade Bamboo Server

Bamboo 5.9 will no longer be supported after June 12, 2017. What does this mean? As part of our End of Life policy, Atlassian supports major versions for two years after the first major iteratio...

1,321 views 0 5
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