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

This widget could not be displayed.

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 widget could not be displayed.

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.

This widget could not be displayed.

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

This widget could not be displayed.

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
Community showcase
Published Aug 21, 2018 in Bitbucket

Branch Management with Bitbucket

As a project manager, I have discovered that different developers want to bring their previous branching method with them when they join the team. Some developers are used to performing individual wo...

1,316 views 8 11
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