Stash startup logs sql errors post upgrade

[Leon Wright]

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.

[Leon Wright · Accepted solution]

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.

[Leon Wright]

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

[Leon Wright]

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

[SimonS]

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.