From nobody Fri May 5 11:10:40 2023 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4QCSf90LPbz49BZr for ; Fri, 5 May 2023 11:10:41 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4QCSf85LFmz4c5w for ; Fri, 5 May 2023 11:10:40 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1683285040; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=CjRClOuSBPqcA5NjWn2uv2Qu3k13KpE+lEe+Z3+Pfok=; b=t+vUiPeYzY7So2/P1HqnSM2E6QT+GTIOqCX7tXr+raNtSkPGIc1KExRCskgoLdDidvCVhI ZUCKnx4B0RfC6ZAlQP/QlvLul/DFEYaCF2ZtWkm/7LaBUt+8DF/VR81Ag5xWVaqrqiR7qT X3kms1L2Rj7TDpLGZcYuGZrUZzyWE0zXPTVakExuhjuCwZK38/DVDaaP/LKvMCCST9Gpza J1dUA+lgS2TrTmTW81fxxGL7aLvYRZeiL+WDKBCVGdVSYqm/lcFO8hg1Naryp3jZfNRWqh +yhru+jHGEdHrKnXcrSb8Ff55HexkDzpfRm2ceZogkAP+bpWV1w0562V9PxNNw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1683285040; a=rsa-sha256; cv=none; b=l/urE66gAyVmP59jSx6uvxhDuMHIikxbEALHbOkgXmzUx4hdutTlJxazG1kzorNpGuzjEp Bg4NvgMQQzT9y36pV+xcO5BEssp2eHNOfgMTNHb648EeIRCGRzIsNNKI4R4xd3vUxjVvf+ 1Udli4nRZA0wFE5afj/OQTN5K1Vy7wpDXLZv5fnpT1guUFLFU0nqXrADw9qo9pLeSvtvF4 Cmwy7OSshg4WPQOMVojr1u1OIjBPAcWXZs1DKq7tu9NRPmKqToEIqs0L64EW0BUQwoa67/ 7VXbN3b7dDuTsC/bW86mmb5a6nm40vqpjKg2vieRSmPlnu7h1ste8R4x4uwbRQ== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4QCSf84PmHzs4X for ; Fri, 5 May 2023 11:10:40 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 345BAe36019887 for ; Fri, 5 May 2023 11:10:40 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 345BAeHY019886 for ports-bugs@FreeBSD.org; Fri, 5 May 2023 11:10:40 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 271258] dns/powerdns: MySQL 8.0 client change removes wsrep (Galera) MySQL 5.7 cluster due to pkg conflict Date: Fri, 05 May 2023 11:10:40 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: geoffrey.ongley@training247.com.au X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter cc flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D271258 Bug ID: 271258 Summary: dns/powerdns: MySQL 8.0 client change removes wsrep (Galera) MySQL 5.7 cluster due to pkg conflict Product: Ports & Packages Version: Latest Hardware: amd64 OS: Any Status: New Severity: Affects Some People Priority: --- Component: Individual Port(s) Assignee: ports-bugs@FreeBSD.org Reporter: geoffrey.ongley@training247.com.au CC: tremere@cainites.net CC: tremere@cainites.net Flags: maintainer-feedback?(tremere@cainites.net) When upgrading from FreeBSD 13.1 to 13.2, I performed a pkg upgrade but bum= ped into some troubles with the PowerDNS binary package. This change upgraded the PowerDNS package from 4.7.3 to 4.7.3_1 (which would seemingly be an innocuous change, at least based on the version numbers). However, it turns out this introduced a dependency change from the MySQL 5.7 client to MySQL 8 client:=20 ###################### Not yet upgraded host -=20 root@ns3:~ # pkg info -dx powerdns powerdns-4.7.3: lua54-5.4.4 curl-7.87.0 boost-libs-1.80.0_1 sqlite3-3.40.1,1 postgresql13-client-13.9 mysql57-client-5.7.40 <<<<--- MySQL 5.7 lmdb-0.9.29_1,1 powerdns-recursor-4.8.1: lua54-5.4.4 boost-libs-1.80.0_1 ----- Upgraded host -=20 root@ns4:~ # pkg info -dx powerdns powerdns-4.7.3_1: lua54-5.4.4 curl-8.0.1 boost-libs-1.81.0 sqlite3-3.41.2,1 postgresql13-client-13.10 mysql80-client-8.0.32 <<<<--- MySQL 8.0 lmdb-0.9.29_1,1 powerdns-recursor-4.8.4: lua54-5.4.4 boost-libs-1.81.0 ###################### This change, in our case, therefore removes the MySQL 5.7 wsrep / Galera cluster database I have setup across my PowerDNS nodes due to the MySQL 8 client. This cluster has been used to date to replicate the zones instantly= - but out it goes on upgrade: ###################### Installed packages to be REMOVED: mysql57-client: 5.7.40 mysqlwsrep57-server: 5.7.39 ####################### AFAICT, MySQL 8 does not (yet?) have a wsrep patched version in the binary package tree or ports, so from what I understand it's not just a simple cas= e of upgrading all nodes to MySQL 8 from the package tree, as there then will no longer be a working Galera (replicated) cluster. Nevertheless, hoping for the best - I tried anyway to see if wsrep was pres= ent in the MySQL 8 server package after finding I was forced to MySQL 8 unexpectedly by the change in dependencies of this port due to the MySQL 8 client dependency. It appears to me the wsrep patch for MySQL is not present here in the mysql80-server package: 2023-05-05T10:45:33.056505Z 0 [ERROR] [MY-000067] [Server] unknown variable 'wsrep_on=3DON'. 2023-05-05T10:45:33.056544Z 0 [ERROR] [MY-010119] [Server] Aborting And it looks like only 5.6 and 5.7 has the needed wsrep patch at this time: root@ns4:~ # pkg search wsrep mysqlwsrep56-server-5.6.51_1 MySQL database enhanced with Galera replicat= ion (server package) mysqlwsrep57-server-5.7.39 MySQL database enhanced with Galera replicat= ion (server package) As such, for those using a Galera cluster (previously 5.7, as supported by = the previous version, 4.7.3 (instead of 4.7.3_1) - we're seemingly toast by this minor update. I could be wrong - but if I'm not, could we consider if this MySQL 8 client dependency change could be reverted to MySQL 5.7? At least until there's a wsrep patched MySQL in the pkg repo. I'm guessing this change was not expected to have much, if any impact - but with a galera cluster in place, it does impact seemingly. I'm guessing rolling back is not necessarily straight forward as folks may = have already rolled forward, causing a bit of a conundrum. Maybe an alternate solution is to not depend on a specific MySQL client, (I don't know if ther= e is a way to say 'any will do' - but I am not sure if this is possible, or a gr= eat idea).=20 The better approach I gather would be to push forward and work toward getti= ng a wsrep patched MySQL 8 server in the FreeBSD 13.2 binary package tree - but I assume this is not there for a good reason (could be due to this: https://github.com/codership/mysql-wsrep/issues/382). Any advice/thoughts on how to handle this? I am not sure if there could be = at minimum a warning to folks performing this upgrade that it will break your Galera cluster at this time if you're using ports/packages to supply MySQL = 5.7 with Galera. Not sure.=20 Anyway, I wanted to log this issue, so you're at least aware of it, and see= if there's anything we could do to improve the situation to help others avoid = the problem I just stumbled over with this update. --=20 You are receiving this mail because: You are the assignee for the bug.=