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:
The following problem occurred, which prevents Atlassian Bitbucket from starting:
Currently using MariaDB 10.1 as the database driver. I have logs available but I don't really see an attachment option sadly.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.