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-config.properties:

jdbc.url=jdbc:mysql://localhost:3306/stashdb?useUnicode=true&characterEncoding=utf8&sessionVariables=storage_engine=InnoDB

jdbc.user=

jdbc.password=

jdbc.driver=com.mysql.jdbc.Driver

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

4 answers

1 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:
https://jira.atlassian.com/browse/STASH-2703

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Piotr Plewa
Published Dec 27, 2017 in Bitbucket

Recipe: Deploying AWS Lambda functions with Bitbucket Pipelines

Bitbucket Pipelines helps me manage and automate a number of serverless deployments to AWS Lambda and this is how I do it. I'm building Node.js Lambda functions using node-lambda&nbsp...

1,764 views 1 5
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