BitBucket 7.1.0 Database Upgrade issue from 6.10.1

[Jared Yach]

Hello,

We recently have tried moving our Offline BitBucket Server from 6.1.1 to 7.1.0.  Along the way it appears to install fine, but once it goes to start, it looks like there is a database upgrade that starts running and has issues and fails.  We are using the H2 database.

I also found this post https://community.atlassian.com/t5/Bitbucket-questions/Error-after-upgrading-from-6-10-1-to-7-0-1-bb-comment-null/qaq-p/1322191  that was having a similar issue, but our "bb_comment" had entries so the work around found in there did not work.  Looking for help as to how to get it running.  Thanks!

=========================================

Log output error from startup:

[spring-startup] c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /var/atlassian/application-data/bitbucket/shared

[spring-startup] com.hazelcast.instance.Node [<ip>]:5701 [atlbitbucket] [3.12.6] No join method is enabled!  Starting standalone.

[spring-startup] liqibase.changelog.ChangeSet Change Set liqibase/r7_0/upgrade.xml::BBSDEV-19009-1::fdoherty failed. Error: Refferential integrity constraint violation: "FK_BB_COM_PAR_COMMENT_ID: PUBLIC.BB_COMMENT_PARENT FOREIGN KEY(COMMENT_ID) REFERENCES PUBLIC.BBB.COMMENT(ID) (323)"; SQL statement:

insert into bbb_comment_parent (

comment_id,

parent_id

)

(select (select next_val + t.id from id_sequence where sequence_name = 'bb_comment'),

t.anchor_id

from sta_task t) [23506-176] [Failed SQL: 

insert into bbb_comment_parent (

comment_id,

parent_id

)

(select (select next_val + t.id from id_sequence where sequence_name = 'bb_comment'),

t.anchor_id

from sta_task t)]

Then some error messages about creating beans crowdAliasDao and liqibase.  then the erros keep repeating.

[Jared Yach · Accepted solution]

Fixed in release 7.2.1