1

CiviHosting has sent a notice to all their customers that they are upgrading all their servers to MySQL 5.7, despite their acknowledgement that CiviCRM prior to version 4.7.7 "may fail". They plan on performing this upgrade in one week, August 17.

For those customers that are not able to upgrade to a compatible CiviCRM version at this time (due to various customizations), what are the various issues that can be expected?

I know of the lock name length issue (When upgrading from 4.7.7 to 4.7.8 I get error "Specified key was too long") which appears to be an upgrade process issue. (Does this problem extend back to prior to 4.7?)

What else is there to be concerned with, particularly with versions 4.4.x, 4.5.x, and 4.6,x?

1
  • NB: the linked "key too long" question was observed on OSX. Aug 11 '16 at 19:14
1

IMO the only way to answer this with confidence is empirically: request a trial upgrade in the proposed new hosting environment (or equivalent), and test whether the system upgrades then functions as expected. Most effectively done when you have some tests that you can run on your newly upgraded site to ensure things function.

Fuzion host on MySQL 5.5 and 5.6, so I can't speak to what you should expect on MySQL 5.7. (This is not because we don't approve of 5.7, we just have had no reason as of today to move there.)

You might also see variation between Percona / MariaDB / MySQL, or between various OS or distribution packages ... Your best bet is to try it and see! Just not in production ;)

3
  • So, Chris, are you inferring that CiviCRM has not been vetted against MySQL 5.7 at all, and we don't know what is going to happen? Scary then that CiviHosting is doing this for all (production) sites. Aug 11 '16 at 19:58
  • I want to be clear I'm not saying that! Sorry if it was unclear. I can only speak for Fuzion (and other sites I've explored). We (Fuzion) have not run it on MySQL 5.7, and even if we had, our MySQL 5.7 might not be yours. Hopefully someone who has tested on 5.7 can answer, but even then their MySQL 5.7 might not match yours either, which is why I recommend testing what will actually happen in order to be assured of outcomes. This applies to many things :) Aug 11 '16 at 20:04
  • NB: Looks like CiviCRM's testing may be running a node on Ubuntu Xenial (16.04) which could be using MySQL 5.7 (based on civi-download-tools + launchpad entry for mysql-server on Xenial. I am not certain if that node is working though. Aug 11 '16 at 20:10
1

I'm aware of 2 issues.

There is a lock length issue, but it is a different one: https://issues.civicrm.org/jira/browse/CRM-17846. You may need to backport that patch.

Additionally there is https://issues.civicrm.org/jira/browse/CRM-18439. While it is patched for core 4.7.10, self-developed queries might violate that restriction. You do get away with disabling the default SQL mode only_full_group_by.

0

CiviHosting has posted this message on their website:

CiviCRM Bug With MySQL 5.7

As you can read in MySQL's site:

MySQL 5.7.5 and later enforces a maximum length on lock names of 64 characters. Previously, no limit was enforced.

The problem is that CiviCRM sometimes generates "lock names" longer than 64 characters. When that happens, CiviCRM will not work at all with MySQL 5.7.

The fix is here:

https://issues.civicrm.org/jira/browse/CRM-17846

and so CiviCRM 4.7.7 and later versions and also CiviCRM 4.6.16 and later "LTS" versions have this fix.

(Please note that this issue https://issues.civicrm.org/jira/browse/CRM-18439 is not relevant at all--our servers do not have this problem of sql_mode=only_full_group_by".)

0

All affected CiviCRM installs on CiviHosting's servers were patched following the MySQL upgrade. Sometimes there are conflicts between server-side software security and functionality of old CiviCRM versions and a judgment call must be made to determine what is most important.

CiviHosting's policy is to put security first, always.

CiviCRM users are always encouraged to keep their installs up to date.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.