• We collect Bitbucket feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      MySQL 5.6.10 represents the first GA release of 5.6. However, it cannot be used with Stash due to a serious issue with its query optimizer.

      This issue has 2 deliverables:

      • Monitor the MySQL bug for a fix version and validate it
      • Deploy an image with the fixed version to the build farm and add it to the DAO matrix tests to validate 5.6 support going forward

      Until a version including a fix for that issue is specified, 5.6 cannot be used by Stash, and will not be supported if deployed at customer sites. Stash 2.2 includes changes, made under STASH-3133, which will block attempts to start Stash when connected to MySQL 5.6, as well as to block attempts to migrate from HSQL to MySQL 5.6 or setup MySQL 5.6 as the external database.

      Customers interested in using MySQL 5.6 with Stash may track this issue for status, as well as the referenced MySQL bug.

      Note: This bug also precludes the use of Amazon Aurora, which as of 2017-03-31 is based on MySQL 5.6.10a

            [BSERV-3164] Add MySQL 5.6 to test matrix

            Ross,

            Take a look at BSERV-8145. I wrote that 5.7 would remain unsupported in February of 2014. It remained unsupported at that time because the only releases available then were prereleases, not GA. After 5.7 went GA, it was added to backlog for support, which ships in 4.10.

            Best regards,
            Bryan Turner
            Atlassian Bitbucket

            Bryan Turner (Inactive) added a comment - Ross, Take a look at BSERV-8145 . I wrote that 5.7 would remain unsupported in February of 2014. It remained unsupported at that time because the only releases available then were prereleases, not GA. After 5.7 went GA, it was added to backlog for support, which ships in 4.10. Best regards, Bryan Turner Atlassian Bitbucket

            I'm looking for more information on why 5.7 will remain unsupported. The comments above do not make this clear.

            Ross Golder added a comment - I'm looking for more information on why 5.7 will remain unsupported. The comments above do not make this clear.

            Good news, everyone! /farnsworth

            MySQL 5.6.16 is now available for download, and finally passes Stash's database test suite. Stash 2.11 will be the first version to add support for MySQL 5.6.16+. Note that 5.7 (all current versions) will remain unsupported.

            Best regards,
            Bryan Turner
            Atlassian Stash

            Bryan Turner (Inactive) added a comment - Good news, everyone! /farnsworth MySQL 5.6.16 is now available for download, and finally passes Stash's database test suite. Stash 2.11 will be the first version to add support for MySQL 5.6.16+. Note that 5.7 (all current versions) will remain unsupported. Best regards, Bryan Turner Atlassian Stash

            Patrick,

            The property has not been removed or modified for 2.10.1, and my testing shows it still works as intended (I'm able to start 2.10.1 on MySQL 5.6.15 with the flag set). The flag only allows you to start on an unsupported database. Migrating to one, or selecting one during initial setup, is still not possible. You must manually configure unsupported databases.

            Do you see this in your logs?

            2014-01-23 08:27:23,400 WARN  [localhost-startStop-1]  c.a.s.i.db.DefaultDatabaseSupplier Not checking database support level; the check has been disabled
            

            If you continue to have issues, please open a ticket at support.atlassian.com and our support engineers will help address it.

            Best regards,
            Bryan Turner
            Atlassian Stash

            Bryan Turner (Inactive) added a comment - Patrick, The property has not been removed or modified for 2.10.1, and my testing shows it still works as intended (I'm able to start 2.10.1 on MySQL 5.6.15 with the flag set). The flag only allows you to start on an unsupported database. Migrating to one, or selecting one during initial setup, is still not possible. You must manually configure unsupported databases. Do you see this in your logs? 2014-01-23 08:27:23,400 WARN [localhost-startStop-1] c.a.s.i.db.DefaultDatabaseSupplier Not checking database support level; the check has been disabled If you continue to have issues, please open a ticket at support.atlassian.com and our support engineers will help address it. Best regards, Bryan Turner Atlassian Stash

            Seems like jdbc.ignoreunsupported=true doesn't bypass the database support check in Atlassian Stash v2.10.1. If the functionality of this flag was removed, should it be removed from the Stash documentation (https://confluence.atlassian.com/display/STASH/Stash+config+properties)? Or perhaps that is just a bug?

            Patrick Seymour added a comment - Seems like jdbc.ignoreunsupported=true doesn't bypass the database support check in Atlassian Stash v2.10.1. If the functionality of this flag was removed, should it be removed from the Stash documentation ( https://confluence.atlassian.com/display/STASH/Stash+config+properties)? Or perhaps that is just a bug?

            All,

            The utf8_bin collation bug was marked fixed in 5.6.15 but is not fixed. I have reopened the issue and hopefully someone from MySQL will respond soon. Stash's test suite continues to fail on MySQL 5.6.15, so it will remain an unsupported platform.

            Sorry all,
            Bryan Turner
            Atlassian Stash

            Bryan Turner (Inactive) added a comment - All, The utf8_bin collation bug was marked fixed in 5.6.15 but is not fixed . I have reopened the issue and hopefully someone from MySQL will respond soon. Stash's test suite continues to fail on MySQL 5.6.15, so it will remain an unsupported platform. Sorry all, Bryan Turner Atlassian Stash

            Bryan Turner (Inactive) added a comment - - edited

            Stefan.

            Fortunately, that flag is already available; I introduced it at the same time I added the hard check. You can add the following to stash-config.properties:

            jdbc.ignoreunsupported=true
            

            Best regards,
            Bryan Turner
            Atlassian Stash

            Edit: Note We will not provide database-related support for any issues encountered while this is set and an unsupported database is being used. This flag exists purely for the situation where there is no possible alternative other than an unsupported database.

            Bryan Turner (Inactive) added a comment - - edited Stefan. Fortunately, that flag is already available; I introduced it at the same time I added the hard check. You can add the following to stash-config.properties : jdbc.ignoreunsupported= true Best regards, Bryan Turner Atlassian Stash Edit: Note We will not provide database-related support for any issues encountered while this is set and an unsupported database is being used. This flag exists purely for the situation where there is no possible alternative other than an unsupported database.

            StefanS added a comment -

            Hi
            could you please add a command line switch (or config file switch) to allow stash on "unsupported" mysql versions (instead of the compiled "abort")? (similar to "allow openjdk" on earlier bamboo/jira/confluence versions).
            Unfortunately, our DBA upgraded all our databases to mysql 5.6, and now i can not run stash anymore.
            Apart from a "ordering" problem, stash should be running fine with mysql 5.6.14. Having only one project in stash, the order of projects does not matter at all

            As nobody knows how long it may take until mysql 5.6.15 is available for download, having this command line option in stash would help a lot.

            Regards,
            Stefan

            StefanS added a comment - Hi could you please add a command line switch (or config file switch) to allow stash on "unsupported" mysql versions (instead of the compiled "abort")? (similar to "allow openjdk" on earlier bamboo/jira/confluence versions). Unfortunately, our DBA upgraded all our databases to mysql 5.6, and now i can not run stash anymore. Apart from a "ordering" problem, stash should be running fine with mysql 5.6.14. Having only one project in stash, the order of projects does not matter at all As nobody knows how long it may take until mysql 5.6.15 is available for download, having this command line option in stash would help a lot. Regards, Stefan

            All,

            The utf8_bin collation bug has been marked as fixed/verified for MySQL 5.6.15. As soon as I can download that and run our test suite against it (while the issue is marked fixed, the download site is still showing 5.6.14 as the latest release), assuming our test suite confirms the fix, I will mark 5.6.15+ as supported for Stash. If I can verify it soon enough, MySQL 5.6 support may ship with Stash 2.9.

            Note that all existing releases of 5.7 will remain unsupported. We won't support any builds of that prior to an official GA.

            Best regards,
            Bryan Turner
            Atlassian Stash

            Bryan Turner (Inactive) added a comment - All, The utf8_bin collation bug has been marked as fixed/verified for MySQL 5.6.15. As soon as I can download that and run our test suite against it (while the issue is marked fixed, the download site is still showing 5.6.14 as the latest release), assuming our test suite confirms the fix, I will mark 5.6.15+ as supported for Stash. If I can verify it soon enough, MySQL 5.6 support may ship with Stash 2.9. Note that all existing releases of 5.7 will remain unsupported. We won't support any builds of that prior to an official GA. Best regards, Bryan Turner Atlassian Stash

            Nathan,

            Unfortunately, I have run our matrix against MySQL 5.6.14 and the ordering bug remains unfixed. Per the latest comments, the "utf8_bin" collation remains broken. Stash requires that collation, so still no joy on MySQL 5.6 support.

            Bryan Turner (Inactive) added a comment - Nathan, Unfortunately, I have run our matrix against MySQL 5.6.14 and the ordering bug remains unfixed. Per the latest comments , the "utf8_bin" collation remains broken. Stash requires that collation, so still no joy on MySQL 5.6 support.

              bturner Bryan Turner (Inactive)
              bturner Bryan Turner (Inactive)
              Votes:
              16 Vote for this issue
              Watchers:
              45 Start watching this issue

                Created:
                Updated:
                Resolved: