1- Shutdown Bitbucket Server

2- Open your <BITBUCKET_HOME>/data/db.script and look for a string like:

INSERT INTO DATABASECHANGELOGLOCK VALUES(1,TRUE,'2012-06-12 14:08:00.982000','fe80:0:0:0:a00:27ff:fe6a:c787%2 (fe80:0:0:0:a00:27ff:fe6a:c787%2)')

And substitute it by the one below:

INSERT INTO DATABASECHANGELOGLOCK VALUES(1,FALSE, NULL,NULL )

3- Restart Bitbucket Server

1. Stop Bitbucket Server
2. Login to the server as the user that runs Bitbucket Server

3. Run the following command which will open a console connection to the database:

   You'll want to update the path below to reflect where Bitbucket Server is installed and select the h2 jar. By default it is stored in:

   /opt/atlassian/bitbucket/<Release_Number>

   java -cp <BITBUCKET_INSTALL>/atlassian-bitbucket/WEB-INF/lib/h2-1.3.176.jar org.h2.tools.Shell

4. When prompted for the URL enter:

   You'll want to verify that the path below points your DB. By default it is stored in:

   /var/atlassian/application-data

   jdbc:h2:file://<$BITBUCKET_HOME>/bitbucket/shared/data/db;DB_CLOSE_ON_EXIT=TRUE

5. Press enter when asked which driver to use
6. Enter sa for the user
7. Press enter twice when prompted for the password (no password is required)

This should leave you with a sql> prompted and you can run the update query below:

UPDATE databasechangeloglock SET LOCKED=false, LOCKGRANTED=null, LOCKEDBY=null where ID=1;