From nobody Sat Apr 15 16:25:17 2023 X-Original-To: questions@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 4PzJZZ6ZvYz45bnf for ; Sat, 15 Apr 2023 16:25:26 +0000 (UTC) (envelope-from jmc-freebsd2@milibyte.co.uk) Received: from cp160176.hpdns.net (cp160176.hpdns.net [91.238.160.176]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4PzJZY5tYhz4Zn0 for ; Sat, 15 Apr 2023 16:25:25 +0000 (UTC) (envelope-from jmc-freebsd2@milibyte.co.uk) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=milibyte.co.uk header.s=default header.b=IAeI8mmM; spf=pass (mx1.freebsd.org: domain of jmc-freebsd2@milibyte.co.uk designates 91.238.160.176 as permitted sender) smtp.mailfrom=jmc-freebsd2@milibyte.co.uk; dmarc=none DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=milibyte.co.uk; s=default; h=Content-Transfer-Encoding:Content-Type: MIME-Version:Message-ID:Date:Subject:To:From:Sender:Reply-To:Cc:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=B6NKyv66qMZSZOGceCg9WN/rVJpZMpEKNhxCDgibyqs=; b=IAeI8mmMYUd5ya/VMH0mSeC3pT oEbDqF/3k6DmqbirepU6YHGhC2vQreiVdGwbgxd7W4QtoW/KPPagbuunG4Ewh3KMjqIBclubQxpKD NVpWRHkUz4lkuw9bId5G1/1gxaXT40n+0vv/KNQasRPffcbIisK2tNo+SKZ07HFHatyjP8jyzjdYz tmo6FG5oXGDKAHhrNAhkkywxYj9574eoFQIE6yeLg0aa3DL8DBXY6KYWBk0Smygae3/KVuIkzMiyf hegOFrf/a5jiDXf2SAO7htM/ZDd0lVZ2jUFb8Tm/KrZHtEzQkLt/jh6qJJfg0BbnFKGh/ISpCrmRz iAltiMqQ==; Received: from [149.86.189.206] (port=16589 helo=curlew.milibyte.co.uk) by cp160176.hpdns.net with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1pniiH-0006l2-00 for questions@freebsd.org; Sat, 15 Apr 2023 17:25:17 +0100 Received: from [127.0.0.1] (helo=curlew.localnet) by curlew.milibyte.co.uk with esmtp (Exim 4.95) (envelope-from ) id 1pniiD-0000pQ-QO for questions@freebsd.org; Sat, 15 Apr 2023 17:25:17 +0100 From: Mike Clarke To: questions@freebsd.org Subject: MySQL server silently fails to start after upgrading from 5.7.40 to 8.0.32 Date: Sat, 15 Apr 2023 17:25:17 +0100 Message-ID: <4381878.Iv3B0QcHgC@curlew> List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="nextPart2164183.PLFibm3KWW" Content-Transfer-Encoding: 7Bit X-SA-Exim-Connect-IP: 127.0.0.1 X-SA-Exim-Mail-From: jmc-freebsd2@milibyte.co.uk X-SA-Exim-Scanned: No (on curlew.milibyte.co.uk); SAEximRunCond expanded to false X-YourOrg-MailScanner-Information: Please contact the ISP for more information X-YourOrg-MailScanner-ID: 1pniiH-0006l2-00 X-YourOrg-MailScanner: Found to be clean X-YourOrg-MailScanner-SpamCheck: X-YourOrg-MailScanner-From: jmc-freebsd2@milibyte.co.uk X-Spam-Status: No X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - cp160176.hpdns.net X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - milibyte.co.uk X-Get-Message-Sender-Via: cp160176.hpdns.net: authenticated_id: mailpool@milibyte.co.uk X-Authenticated-Sender: cp160176.hpdns.net: mailpool@milibyte.co.uk X-Source: X-Source-Args: X-Source-Dir: X-Spamd-Result: default: False [-2.32 / 15.00]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.82)[-0.824]; CTE_CASE(0.50)[]; MID_RHS_NOT_FQDN(0.50)[]; R_DKIM_ALLOW(-0.20)[milibyte.co.uk:s=default]; R_SPF_ALLOW(-0.20)[+a]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; DMARC_NA(0.00)[milibyte.co.uk]; FROM_HAS_DN(0.00)[]; HAS_X_GMSV(0.00)[mailpool@milibyte.co.uk]; TO_MATCH_ENVRCPT_ALL(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; ARC_NA(0.00)[]; RCVD_TLS_LAST(0.00)[]; MLMMJ_DEST(0.00)[questions@freebsd.org]; RCVD_COUNT_THREE(0.00)[3]; TO_DN_NONE(0.00)[]; HAS_X_SOURCE(0.00)[]; HAS_X_AS(0.00)[mailpool@milibyte.co.uk]; DKIM_TRACE(0.00)[milibyte.co.uk:+]; FROM_EQ_ENVFROM(0.00)[]; HAS_X_ANTIABUSE(0.00)[]; ASN(0.00)[asn:52148, ipnet:91.238.160.0/22, country:GB]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_VIA_SMTP_AUTH(0.00)[] X-Rspamd-Queue-Id: 4PzJZY5tYhz4Zn0 X-Spamd-Bar: -- X-ThisMailContainsUnwantedMimeParts: N This is a multi-part message in MIME format. --nextPart2164183.PLFibm3KWW Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="UTF-8" After upgrading packages to the the new quarterly release mysql was upgraded to 8.0.32 and it fails to start and does not produce any failure message on the console and I couldn't find any relevant failure message anywhere in /var/logs. I have updated my.cnf by copying the entire file from my.cnf.sample. I've reverted back to the earlier BE with my working mysql5 and here's the diff between / usr/local/etc/mysql/my.cnf and /tmp/my.cnf which was copied from the BE containing mysql8 --- /usr/local/etc/mysql/my.cnf 2019-07-16 14:41:30.000000000 +0100 +++ /tmp/my.cnf 2023-04-15 17:10:55.395944000 +0100 @@ -1,2 +0,0 @@ -# $FreeBSD: head/databases/mysql57-server/files/my.cnf.sample.in 414707 2016-05-06 14:39:59Z riggs $ - @@ -19 +17 @@ -slave-load-tmpdir = /var/db/mysql_tmpdir +replica-load-tmpdir = /var/db/mysql_tmpdir @@ -23,2 +20,0 @@ -master-info-repository = TABLE -relay-log-info-repository = TABLE @@ -31 +27 @@ -expire_logs_days = 30 +binlog_expire_logs_seconds = 2592000 @@ -45,2 +40,0 @@ -query_cache_type = 0 -query_cache_size = 0 @@ -51 +45 @@ -innodb_data_file_path = ibdata1:82M:autoextend +innodb_data_file_path = ibdata1:128M:autoextend @@ -54 +48 @@ -innodb_log_file_size = 256M +innodb_redo_log_capacity = 512M @@ -59 +52,0 @@ -skip-symbolic-links -- Mike Clarke --nextPart2164183.PLFibm3KWW Content-Transfer-Encoding: 7Bit Content-Type: text/html; charset="UTF-8"

After upgrading packages to the the new quarterly release mysql was upgraded to 8.0.32 and it fails to start and does not produce any failure message on the console and I couldn't find any relevant failure message anywhere in /var/logs.


I have updated my.cnf by copying the entire file from my.cnf.sample.


I've reverted back to the earlier BE with my working mysql5 and here's the diff between /usr/local/etc/mysql/my.cnf and /tmp/my.cnf which was copied from the BE containing mysql8


--- /usr/local/etc/mysql/my.cnf 2019-07-16 14:41:30.000000000 +0100

+++ /tmp/my.cnf 2023-04-15 17:10:55.395944000 +0100

@@ -1,2 +0,0 @@

-# $FreeBSD: head/databases/mysql57-server/files/my.cnf.sample.in 414707 2016-05-06 14:39:59Z riggs $

-

@@ -19 +17 @@

-slave-load-tmpdir               = /var/db/mysql_tmpdir

+replica-load-tmpdir             = /var/db/mysql_tmpdir

@@ -23,2 +20,0 @@

-master-info-repository          = TABLE

-relay-log-info-repository       = TABLE

@@ -31 +27 @@

-expire_logs_days                = 30

+binlog_expire_logs_seconds      = 2592000

@@ -45,2 +40,0 @@

-query_cache_type                = 0

-query_cache_size                = 0

@@ -51 +45 @@

-innodb_data_file_path           = ibdata1:82M:autoextend

+innodb_data_file_path           = ibdata1:128M:autoextend

@@ -54 +48 @@

-innodb_log_file_size            = 256M

+innodb_redo_log_capacity        = 512M

@@ -59 +52,0 @@

-skip-symbolic-links


--

Mike Clarke

--nextPart2164183.PLFibm3KWW--