Enhancement
Support MySQL 5.7
Issue description
Supporting MySQL 5.7 is not straight forward.
Developer comments
When running tests, the stores could not be restored like usual. The PHP cli process terminated with an uncaught DBException: MySQL Error Nummer 1067: invalid date in default value.
The reason for this error is that the dumped MySQL database of the store contains a deprecated syntax for setting the default value of the %creation_ts% column that appears in many tables.
Lots of research and many dead ends later, the only quick fix for this is to change the MySQL configuration file %/etc/mysql/my.cnf%:
[%[mysqld]
sql-mode = "ALLOW_INVALID_DATES"%]
For this to take effect the MySQL service needs to be restarted.
Dead ends were:
* Setting the sql mode at runtime, just before the restore. The restore worked, but the tests failed later at an %ALTER TABLE% statement
* Setting the sql-mode in my.cnf to "". Forgot where that failed.
* Setting the sql-mode in my.cnf to "TRADITIONAL,ALLOW\_INVALID\_DATES". This did not set the sql mode to a strange value.
Running all tests takes now 1 hour instead of 25 minutes. Might be related to [http://superuser.com/questions/1084498/horrendous-decrease-in-mysql-performance-after-upgrade-to-ubuntu-16-04-mysql-5-7, this].
|
Work sessions
Start |
2016-08-08T10:33:19
|
End |
2016-08-08T17:33:28
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.