Stash startup logs sql errors post upgrade

Startup post upgrade of stash from 1.1.0 -> 1.2.2 posts many sql errors resulting in the following when browsing the web app:

A fatal error has occurred

The following problem occurred which prevents Atlassian Stash from starting correctly:

The Spring WebApplicationContext could not be started

Tried one of the sql statements with the root account, so doesn't appear to be a permissions issue:

mysql> SQL ALTER TABLE `stashdb`.`cs_repo_membership` DROP FOREIGN KEY `fk_cs_repo_membership_changeset`;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL ALTER TABLE `stashdb`.`cs_repo_membership` DROP FOREIGN KEY `fk_cs_repo_memb' at line 1

MySQL version: mysql Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (x86_64) using readline 6.2

Mysql Client: mysql-connector-java-5.1.21-bin.jar





Stash 1.1.0 still working, rolled back and can retry upgrade.

4 answers

1 accepted

0 votes
Answer accepted

The solution to this is now available in the form of Stash release 1.2.3.

  1. Install upgrade as per the normal upgrade process.
  2. Create a new MySQL database as per the doco (with a different name to the current one).
  3. Migrate the database using the database migration tool (under Administratrion).

It worked a treat.

This will probably require some debugging work, best done with our support team. Please contact our support team via our Support Portal. If you have never used our support services before, you'll have to sign up. Let us know the resolution here, if you decide to go that route.

Thank you Simon, I should have added that I have done so. Will share the resolution when we have one.

It would appear that although I managed to get Stash working with MySQL, it technically wasn't supported prior to version 1.2.

Support have opened an issue for it:

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Thursday in Bitbucket Pipelines

Building a Bitbucket Pipe as a casual coder :  #!/bin/bash source "$(dirname "$0")/" enable_debug extra_args="" if [[ "${DEBUG}" == "true" ]]; then extra_args="--verbose" fi # mandatory variables ROLLBAR_ACCESS_TOKEN...

186 views 0 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you