Upgrading Bitbucket

devittward June 14, 2018

Greetings,

I am in the process of upgrading to a new set of Bitbucket (all Centos7) servers. I am starting off by recreating the old server setup in the new one and then upgrading the version (4.13 > 5.9 or higher). I am using Postgres 9.2.23 right now and the plan is to move to 10+.

I have already moved the data from the old server to the new one and it starts up just fine.

I am trying to move the db into the new server with a .sql backup file and I am having no luck in completing this effort. 

Since this isn't working I'm considering the following:

  • Getting a .dump backup file created and trying to restore that into the new db instead of the .sql file.
  • Doing a db migration on the new server from the old db to the new db. I have concerns about this though. Will the old server have an interruption of service (how much)? Will the old server continue to operate after this migration?

I am really liking the migration option but I cannot simply change the service over permenantly until i have upgraded and tested everything on the new set up.

3 comments

Shankar Asam {Appfire}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 15, 2018

If you want to migrate the databases for bitbucket, you need to do the following;

 

  • shutdown the bitbucket instance
  • take the db (.sql) backup / dump from current db server
  • go to the new db server and restore .sql / dump file
  • go to bitbucket application server and bitbucket.properties file and change the database related info (DB host name, db name , user / password etc)
  • start the bitbucket instance - it will start with new db
devittward June 15, 2018

thanks

Caterina Curti
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 17, 2018

Hi @devittward,

What @Shankar Asam {Appfire} suggested is a valid starting point (Thanks!).

However, we always recommend to restore both the home directory and the database from a backup taken at the same time. This is to make sure that the data are 100% consistent.

The change of the jdbc url in the bitbucket.properties is still required and you want to always double check that this is done to avoid to upgrade the database of the current server by mistake.

 

We also have a guide that covers How to Migrate Bitbucket Server to another server, this contains various links to the necessary checks and prerequisites (e.g. Supported Platforms).

 

An alternative could be to backup the data from the current instance and restore them in the target one (see Data recovery and backups for options).

 

Cheers,

Caterina - Atlassian

devittward June 29, 2018

This issue has been resolved. 

I installed Postgresql-9.5, then moved a restored a .dump version to the new server.

The bitbucket upgrades of a higher version did not workon start up. The error was that the table names were wrong, or that the configured database was not compatible. My solution was to incrementally upgrade starting with 5.0.5> 5.3.6 >5.5.5 > 5.8.3> 5.10.1 and 5.11.1. Sure this might be overkill but it was tired of the database errors.

The root cause was that the table names were not the same in the pre 5.x.x versions and threw an error each time I attempted to upgrade.

Perhaps once I upgraded to 5.0.5 I could have made a bigger jump but oh well. It is finished.

Caterina Curti
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 29, 2018

Hey @devittward,

An upgrade directly to the latest version is, in general, always possible. I'm not sure what happened exactly, but I'm glad it's all working now!

 

Caterina

voyager8jlh July 17, 2018

Thanks, I am getting ready to upgrade our version from V4.13 to V5.10.1 and was wondering if there would be any issues.  This answered my questions.

Caterina Curti
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 17, 2018

Sure, no problem @voyager8jlh!

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events