Stash Fails to Startup with MySQL 5.6.x

Troubleshooting Databases

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

The following exception is reported when starting up Stash:

"Migration failed for change set liquibase/r1_3/m01.xml::STASHDEV-1023-10::bturner:

    Reason: liquibase.exception.DatabaseException: Error executing SQL 
CREATE INDEX 'idx_sta_diff_comment_anchors' ON 
'stashdb'.'stash_diff_comment_anchor'('to_hash', 'file_path', 
'from_hash'): Specified key was too long; max key length is 767 bytes:"

Cause

This has been identified as a new MySQL 5.6.x bug. Atlassian is tracking this bug here. Feel free to watch it for all related updates.

Resolution

Due to the new bug identified, development is unfortunately not in a position to support this particular version of MySQL. Please consider using MySQL 5.5 or any other supported databases. You may continue using embedded HSQLDB, if using Stash for evaluation purposes.
Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.