MySQL 5.6 required

[detri...@gmail.com]

I notice 5.5 that the MySQL version requirement has changed. It's now 5.6, which is higher than the default repo version available to RHEL/CentOS users (like me). I couldn't easily spot anything on the website/release notes this has changed,

2016.05.03 12:02:40 ERROR web[o.a.c.c.C.[.[.[/]] Exception sending context initialized event to listener instance of class org.sonar.server.platform.PlatformServletContextListener
org.sonar.api.utils.MessageException: Unsupported mysql version: 5.5. Minimal supported version is 5.6.

What has changed that has forced this requirement? What is SonarQube using that MySQL 5.5 does not offer?

[tom...@gmail.com]

Just upgraded sonar and I am also hitting this issue...

Can anyone comment?

Op dinsdag 3 mei 2016 13:23:51 UTC+2 schreef detri...@gmail.com:

[Petr Vilčinský]

We have the same problem.
We are using Mysql 5.1

Dne úterý 3. května 2016 13:23:51 UTC+2 detri...@gmail.com napsal(a):

[Simon Brandhof]

Hi guys,

The upgrade guide does not mention this point. It was forgotten and it's going to be fixed. Thanks for the feedback.

There are multiple reasons why we don't support versions lower than MySQL 5.6:

• Mysql  stopped the "premier support" for v5.5, extended support is still active but this version begins to reach its end of live.
  

• we experimented bad performances with v5.5

• v5.6 resolves a lot of 5.5 bugs

• we support only the databases and versions that are covered by our automated tests. It allows to deliver to our community of users the most stable product as possible. Please believe me, it requires a lot of effort and during dark days I dream to fully drop support of mysql :-) Moreover as the matrix of compatibility in our tests becomes huge, support of new versions, for example Oracle 12c or mysql 5.7, usually comes with the removal of old versions.

• @Petr, well, I'm quite surprised that mysql 5.1 was supported for such a long time !! :-) I would not recommend it in production.
  

Regards

--
You received this message because you are subscribed to the Google Groups "SonarQube" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sonarqube+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/fbae48c0-d111-4726-9d96-ac56659a6dbd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Simon BRANDHOF | SonarSource
Tech Lead & Co-Founder
http://twitter.com/SimonBrandhof

[tom...@gmail.com]

Thanks for the background info Simon!

It sounds like moving to the latest mysql version just might be a sensible idea ;-). Hoping for a smooth transition...

Keep up the good work!

Tom

Op vrijdag 13 mei 2016 15:21:22 UTC+2 schreef Simon Brandhof:

[guillaume...@gmail.com]

Hi,

Thanks for this information. I did not see why my server did'nt start at the first place...

could you update the upgrade notes http://docs.sonarqube.org/display/SONAR/Release+5.5+Upgrade+Notes

and put just below   " SonarQube 5.5 is the last version that can run with a 1.7 JVM."

a note about mysql version (I am on a old centos 6, and mysql is 5.1, even on centos 7 it is mariadb 5.5)

I will install mysql from their repo or move to old postgresql on my centos (8.4... )

[G. Ann Campbell]

Thanks for the suggestion. Done.

Ann