Created attachment 239763 [details] Patch for default MySQL to 8.0 MySQL support has already been ended in 2019. In the middle of this year MySQL 5.6 will be deleted from the ports. At the end of 2023, MySQL 5.7 will also be deleted from the ports. It would be time to change the default version of MySQL to 8.0.
Could MySQL 8.0 be fixed before this exp-run? databases/mysql80-client: is marked as broken on i386: --yplg_out: protoc-gen-yplg: Plugin killed by signal 11.
Sounds really like it's time to upgrade. Looking forward to see a newer version soon.
(In reply to Antoine Brodin from comment #1) thanks for the pointer, Antoine. I had tried to solve the problem in the past. But had no success. I will try again. Once the port is ok on i386 too, we can start the exp-run.
Some new failures logs: https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/emboss-6.6.0_6.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/libgda5-mysql-5.2.10_2.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/lua54-luadbi-0.7.2.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/lua51-luadbi-0.7.2.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/lua52-luadbi-0.7.2.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/lua53-luadbi-0.7.2.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/mysql-connector-c++-1.1.13_3.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/mysql-connector-odbc-unixodbc-mysql80-5.3.13_1.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/mysql-udf-0.3_3.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/mysqltcl-3.052.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/ocaml-mysql-1.2.4.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/rubygem-mysql-2.9.1.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/quickfix-1.15.1_2.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/ldmud-3.3.720_5,1.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/jabberd-2.7.0_5.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/super_mediator-1.6.0_2.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/webfwlog-1.1.1.log https://pkg-status.freebsd.org/package22/data/131amd64-default-foo/2023-01-28_22h34m15s/logs/kannel-1.4.4_11,1.log
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=6db7a8c38ed1459761006281e6d861901fe8e228 commit 6db7a8c38ed1459761006281e6d861901fe8e228 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 10:38:50 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 10:39:38 +0000 biology/emboss: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run biology/emboss/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=df042080582344e032e7e10ce7424d544aec4cd1 commit df042080582344e032e7e10ce7424d544aec4cd1 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 10:52:06 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 10:52:06 +0000 databases/libgda5-mysql: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run databases/libgda5/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=d1207aa8bb174f0ecdfa319137a26b32d6ecd986 commit d1207aa8bb174f0ecdfa319137a26b32d6ecd986 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 10:58:42 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 10:58:42 +0000 databases/luadbi: Ignore with mysql 8.l0 PR: 269203 Reported by: exp-run Approved by: portmgr (just-fix-it) databases/luadbi/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=9f0e6c8fd2864e7794d78ed48296343046c2f88d commit 9f0e6c8fd2864e7794d78ed48296343046c2f88d Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 12:04:39 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:23 +0000 security/webfwlog: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run security/webfwlog/Makefile | 2 ++ 1 file changed, 2 insertions(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=761babb06ef31d5be02f7ac254fd11a9951e4269 commit 761babb06ef31d5be02f7ac254fd11a9951e4269 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:44:33 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:22 +0000 games/ldmud: Ignore with mysql 8.0 - Pet portclippy - Use options framework PR: 269203 Reported by: exp-run games/ldmud/Makefile | 38 +++++++++++++++++++------------------- 1 file changed, 19 insertions(+), 19 deletions(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=7c2377dbfc4a9fa96ce25150797d19d1880c8f83 commit 7c2377dbfc4a9fa96ce25150797d19d1880c8f83 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 12:06:24 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:24 +0000 www/kannel: Ignore with mysl 8.0 PR: 269203 Reported by: exp-run Approved by: portmgr (just-fix-it) www/kannel/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=dbe37f74ca13e4a5d4a2d4cd81a4231d85d975b7 commit dbe37f74ca13e4a5d4a2d4cd81a4231d85d975b7 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:31:55 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:21 +0000 finance/quickfix: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run Approved by: portmgr (just-fix-it) finance/quickfix/Makefile | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=6e95a7c8512c00539eca57f8ab7d869016f8b9fe commit 6e95a7c8512c00539eca57f8ab7d869016f8b9fe Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:01:43 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:19 +0000 databases/mysql-connector-c++: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run databases/mysql-connector-c++/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=a3381e2416389dbfd7276bc129e52842a519182b commit a3381e2416389dbfd7276bc129e52842a519182b Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:26:21 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:20 +0000 databases/mysqltcl: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run databases/mysqltcl/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=c2e38ab7402cb3b7fde664b43a7b34df779494a6 commit c2e38ab7402cb3b7fde664b43a7b34df779494a6 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:29:05 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:21 +0000 databases/rubygem-mysql: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run databases/rubygem-mysql/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=9676344ce6d2ab502cd70cde77be4c6b671b7181 commit 9676344ce6d2ab502cd70cde77be4c6b671b7181 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:23:27 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:20 +0000 databases/mysql-udf: Mark DEPRECATED - Upstream mentions about using MySQL 4.0 and has not been updated since 2007 - Set EXPIRATION_DATE on 2023-12-31 along with MySQL 5.7 - Add LICENSE=BSD2CLAUSE as mentioned in their homepage - Mark to ignore with mysql 8.0 [1] PR: 269203 [1] Reported by: exp-run [1] databases/mysql-udf/Makefile | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=ad5a0a8bfb621b1163fd707ec87ed3807d68ec19 commit ad5a0a8bfb621b1163fd707ec87ed3807d68ec19 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:04:01 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:19 +0000 databases/mysql-connector-odbc: Ignore with mysql 8.0 - Take MAINTAINERSHIP PR: 269203 Reported by: exp-run databases/mysql-connector-odbc/Makefile | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=d757d5292b7e413356381c09ce0abb09f402e184 commit d757d5292b7e413356381c09ce0abb09f402e184 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-01 11:48:28 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-01 12:07:22 +0000 net-mgmt/super_mediator: Ignore with mysql 8.0 - Pet portclippy PR: 269203 Reported by: exp-run Approved by: portmgr (just-fix-it) net-mgmt/super_mediator/Makefile | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-)
(In reply to Antoine Brodin from comment #1) Hi Antoine .. Stupid question somewhat related to this. By the time mysql57-* phases out so does 12-stable. So there will be no more Tier-1 consumer for i386 ARCH. But despite that how important is build status for i386 ARCH? This is not only for this specific instance but for other i386 only ports too.
(In reply to Muhammad Moinur Rahman from comment #18) mysql client has been working for decades on i386, I don't see why it would stop working... i386 is a reference for 32bit builds and it allows to complete exp-runs faster than other archs with the current cluster hardware.
(In reply to Antoine Brodin from comment #19) By the by just to make sure mysql80-client builds fine in i386; it's mysql80-server that is failing to build.
(In reply to Jochen Neumeister from comment #3) This and some other tweaks should fix the build on i386: sed -i '' -e '/libprotobuf/d; s/DWITH_PROTOBUF=system/DWITH_PROTOBUF=bundled/g' databases/mysql80-server/Makefile
(In reply to Muhammad Moinur Rahman from comment #21) If you have a way to fix the problem for i386 it's ok for me if you commit it :-)
(In reply to Jochen Neumeister from comment #22) I will look into it during or after FOSDEM. :)
(In reply to Jochen Neumeister from comment #22) Not too much relevant to this bug but as I was working on it can you confirm this: https://dev.mysql.com/blog-archive/mysql-8-0-retiring-support-for-libmysqld/ This will require some changes in our Mk/Uses/mysql.mk.
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=6498bc6381cc493b38ff7d1ab6087a66f0ec238f commit 6498bc6381cc493b38ff7d1ab6087a66f0ec238f Author: Jochen Neumeister <joneum@FreeBSD.org> AuthorDate: 2023-02-06 17:47:48 +0000 Commit: Jochen Neumeister <joneum@FreeBSD.org> CommitDate: 2023-02-06 17:51:15 +0000 databases/mysql80-*: Unbreak on i386 Fix a issue with i386: --yplg_out: protoc-gen-yplg: Plugin killed by signal 11. *** Error code 1 PR: 269203 Sponsored by: Netzkommmune GmbH databases/mysql80-client/pkg-plist | 2 ++ databases/mysql80-server/Makefile | 4 +--- databases/mysql80-server/pkg-plist | 3 +++ 3 files changed, 6 insertions(+), 3 deletions(-)
Some new failure logs: https://pkg-status.freebsd.org/pb2/data/123i386-default-foo/2023-02-10_08h27m05s/logs/amarok-2.9.71_5.log https://pkg-status.freebsd.org/pb2/data/123i386-default-foo/2023-02-10_08h27m05s/logs/jabberd-2.7.0_5.log https://pkg-status.freebsd.org/pb2/data/123i386-default-foo/2023-02-10_08h27m05s/logs/kannel-1.4.4_11,1.log https://pkg-status.freebsd.org/pb2/data/123i386-default-foo/2023-02-10_08h27m05s/logs/ocaml-mysql-1.2.4.log
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=3e496ad8458edea6f7568aa11a6f084ab5e5ff65 commit 3e496ad8458edea6f7568aa11a6f084ab5e5ff65 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-13 13:03:51 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-13 13:04:33 +0000 databases/ocaml-mysql: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run databases/ocaml-mysql/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=499ef93129228ebc674639b82779a532d508b7b6 commit 499ef93129228ebc674639b82779a532d508b7b6 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-13 12:46:06 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-13 13:04:31 +0000 audio/amarok: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run audio/amarok/Makefile | 1 + 1 file changed, 1 insertion(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=4142b2662596940661ad75f2c0a38e2e54b797fd commit 4142b2662596940661ad75f2c0a38e2e54b797fd Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-13 12:59:46 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-13 13:04:32 +0000 www/kannel: Fix MYSQL_VARS During my previous commit I mistakenly inserted a TAB which is not the correct way of doing this. PR: 269203 Reported by: exp-run www/kannel/Makefile | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=c379da0002a9cd45fc5d05f930ed54423f549281 commit c379da0002a9cd45fc5d05f930ed54423f549281 Author: Muhammad Moinur Rahman <bofh@FreeBSD.org> AuthorDate: 2023-02-13 12:49:19 +0000 Commit: Muhammad Moinur Rahman <bofh@FreeBSD.org> CommitDate: 2023-02-13 13:04:32 +0000 net-im/jabberd: Ignore with mysql 8.0 PR: 269203 Reported by: exp-run net-im/jabberd/Makefile | 1 + 1 file changed, 1 insertion(+)
(In reply to Antoine Brodin from comment #26) Hello Antoine, have you found any other errors? If not, I would prepare the version change now. Greetings Jochen
Exp-run looks fine
(In reply to Antoine Brodin from comment #32) Thx for you're work, Antoine :-)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=7a2b905dba5c286c0a4555747da5e3fd528fecee commit 7a2b905dba5c286c0a4555747da5e3fd528fecee Author: Jochen Neumeister <joneum@FreeBSD.org> AuthorDate: 2023-02-18 11:28:04 +0000 Commit: Jochen Neumeister <joneum@FreeBSD.org> CommitDate: 2023-02-18 11:31:36 +0000 Mk/bsd.default-version.mk: Update default MySQL version to 8.0 Change the default version of MySQL to 8.0 PR: 269203 Exp-run-by: antoine Sponsored by: Netzkommune GmbH Mk/Uses/mysql.mk | 2 +- Mk/bsd.default-versions.mk | 2 +- UPDATING | 22 ++++++++++++++++++++++ 3 files changed, 24 insertions(+), 2 deletions(-)
Maybe make default 10.6m? BTW, don't see 10.6m in list: -# Possible values: 5.6, 5.7, 8.0, 10.3m, 10.4m, 10.5m, 5.7p, 5.7w +# Possible values: 5.6, 5.7, 8.0, 10.3m, 10.4m, 10.5m, 10.6m, 5.7p, 5.7w