Bitbucket Server - Fails to Start After Upgrade

[koncepp]

After upgrading from 5.2.0 to 5.2.1 this morning, Bitbucket is no longer loading and only presents the unavailable page with the following message:

A fatal error has occurred

The following problem occurred, which prevents Atlassian Bitbucket from starting:

• The database schema could not be updated. Details about the change that failed can be found in the logs.
  
  It may be necessary to create a ticket to resolve the error. When creating a ticket, please include the exception details from the logs, as well as the database type.

Currently using MariaDB 10.1 as the database driver. I have logs available but I don't really see an attachment option sadly.

[masterin]

Found a hotfix, go into your DB and manually set the defualt value for 'updated_timestamp' in `bb_comment_thread` to NULL.  Restart the service - it should migrate without issues then.

That's basicly what logs should tell you is wrong btw.

Cheers!

[koncepp]

Log file: https://pastebin.com/YguzPJX3

[Christian Glockner]

Thanks Bobby!

Looking at that file the error that occurs is

liquibase.exception.DatabaseException: Field 'updated_timestamp' doesn't have a default value 

This shouldn't be happening. We've seen some issues with the upgrade to 5.2 relating to this specific area (comment migration), but I haven't been able to find this specific one.

It looks like you may have a comment in your database that may be missing a value in the original table we're trying to migrate from. This could be perfectly normal and it may simply be a case our migration didn't take into account.

Either way, do you have access to support? In other words, are you able to create a ticket with us and could you provide a dump of your pre-upgrade database so we can investigate this?

Cheers,

Christian

Premier Support Engineert

Atlassian

[koncepp]

That's a negative. Starter license. The only copy of the database I would have is in its current form, which I assume would still be in a pre-upgrade state due to the table migration not working.

[Christian Glockner]

Hi Bobby,

Alright, let's do this a different way then - we should definitely take a look at this to see if there is a bug or not - if you're able to share a dump of your database as it is right now, drop me an e-mail at cglockner@atlassian.com and mention the e-mail address of your Atlassian ID, then I'll open a ticket on your behalf and we'll take it from there.

Cheers,

Christian

Premier Support Engineer

Atlassian

[koncepp]

Sure thing. I'll do that right now.

[Christian Glockner]

Hi Bobby,

There's no way to attach files here - the relevant log entries should be towards the end of the atlassian-bitbucket.log files - maybe you can post them here?

Cheers,

Christian

Premier Support Engineer

Atlassian