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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jun 12, 2018 in Bitbucket

Do you use any Atlassian products for your personal projects?

After spinning my wheels trying to get organized enough to write a book for National Novel Writing Month (NaNoWriMo) I took my affinity for Atlassian products from my work life and decided to tr...

22,230 views 26 11
Join discussion

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