Created attachment 204859 [details] Patch MySQL 5.6 is too old and misses many useful features. MySQL 8.0 is too young and may create incompatibily issues. MySQL 5.7 should be a straightforward update.
New failure logs on 12.0 amd64: http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/amarok-2.9.0.277_4.log http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/apq-mysql-3.2.0_2.log http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/ateam_mysql_ldap_auth-1.0_1.log http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mroonga-9.01.log http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysac-1.1.2.log http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysql-connector-odbc-unixodbc-mysql57-5.3.4_1.log http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysql57-q4m-0.9.14_4.log http://package18.nyi.freebsd.org/data/120amd64-default-PR238277/2019-06-09_05h44m14s/logs/mysqlbigram-1.0.1_1.log
New failure logs on 11.2 i386: http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/amarok-2.9.0.277_4.log http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/apq-mysql-3.2.0_2.log http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/ateam_mysql_ldap_auth-1.0_1.log http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mroonga-9.01.log http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysac-1.1.2.log http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysql-connector-odbc-unixodbc-mysql57-5.3.4_1.log http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysql57-q4m-0.9.14_4.log http://package23.nyi.freebsd.org/data/112i386-default-PR238277/2019-06-09_05h45m47s/logs/mysqlbigram-1.0.1_1.log
Created attachment 205056 [details] Updated patch As expected, most failures are from abandonware software designed for MySQL 5.1. I've added the correct IGNORE lines for them, and fixed amarok and mysql-connector-odbc.
Exp-run looks fine.
A commit references this bug: Author: ale Date: Mon Jul 1 07:43:36 UTC 2019 New revision: 505549 URL: https://svnweb.freebsd.org/changeset/ports/505549 Log: Update default MySQL version to 5.7. PR: 238365 Submitted by: ale Exp-run by: antoine Approved by: portmgr (antoine) Changes: head/Mk/Uses/mysql.mk head/Mk/bsd.default-versions.mk head/UPDATING head/audio/amarok/Makefile head/audio/amarok/files/patch-cmake_modules_FindMySQL.cmake head/databases/apq-mysql/Makefile head/databases/ateam_mysql_ldap_auth/Makefile head/databases/mroonga/Makefile head/databases/mysac/Makefile head/databases/mysql-connector-odbc/Makefile head/databases/mysql-connector-odbc/distinfo head/databases/mysql-connector-odbc/files/patch-CMakeLists.txt head/databases/mysql-connector-odbc/files/patch-driver_catalog_no_i_s.c head/databases/mysql-connector-odbc/files/patch-driver_desc.c head/databases/mysql-connector-odbc/files/patch-driver_handle.c head/databases/mysql-connector-odbc/files/patch-driver_parse.c head/databases/mysql-connector-odbc/files/patch-util_odbcinstw.c head/databases/mysql-q4m/Makefile head/databases/mysqlbigram/Makefile