From nobody Sun Apr 16 09:15:41 2023 X-Original-To: freebsd-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 4Pzl0J5hbSz44ydV for ; Sun, 16 Apr 2023 09:15:44 +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 4Pzl0J15qyz3M8B for ; Sun, 16 Apr 2023 09:15:44 +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="P0+/MThe"; 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:References:In-Reply-To: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:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=qT9aa56j7dw9YblSFMGW6RQqMuf1VBohx0K1V8gISQA=; b=P0+/MTheJ+3MpGrauI6MXC1HQk yjDNXCzSpcOPnPGY06OubSNmyObBvX4aNS9eKLx16f0wtkYwivvjixhvmgks1z/gRJAjWN9dWY+md s5KHK/EhaYt2CI/kEISNPUI+pXMRima8+nIzDetWEpLbvtlGymdqIvXvHzFW89+D2K+J1cI1jG5DZ LbdXd5vU0cNz6z0zwGU9O2LJ8hxkl36jxxoSeyAIA1aaXeJn/j96pK8fcOjOohsQaUc/U4+NSd9Gr IseoYBGkvzNnMDICYntwbMAmsg2/3NBZsfMcIMUV8ApS8JXRTrt8b5vgtBJpUMVxQXBBTexkCI5tM /6Cscpew==; Received: from [149.86.189.206] (port=51148 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 1pnyU1-001fC1-1D for freebsd-questions@freebsd.org; Sun, 16 Apr 2023 10:15:41 +0100 Received: from [127.0.0.1] (helo=curlew.localnet) by curlew.milibyte.co.uk with esmtp (Exim 4.95) (envelope-from ) id 1pnyU1-0000oo-7t for freebsd-questions@freebsd.org; Sun, 16 Apr 2023 10:15:41 +0100 From: Mike Clarke To: freebsd-questions@freebsd.org Subject: Re: MySQL server silently fails to start after upgrading from 5.7.40 to 8.0.32 Date: Sun, 16 Apr 2023 10:15:41 +0100 Message-ID: <6162686.O1aUxXEVJ6@curlew> In-Reply-To: References: <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="nextPart2338452.bDOn7JOVgO" 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: 1pnyU1-001fC1-1D 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.50 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-1.00)[-0.996]; 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:c]; 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)[freebsd-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: 4Pzl0J15qyz3M8B X-Spamd-Bar: -- X-ThisMailContainsUnwantedMimeParts: N This is a multi-part message in MIME format. --nextPart2338452.bDOn7JOVgO Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" On Saturday, 15 April 2023 17:48:40 BST Daniel Dowse wrote: > I was facing similar problems when upgrading MySQL 5.7.x to MySQL 8.x > stalling with no error message from the mysql daemon or system. I fixed it > by upgrading my VM to 8GB System RAM. I had this issue first with Hetzer= =E2=80=99s > Cloud Infra and later I could reproduce the issue in my local environment > with (bhyve,VirtualBox) VMs with less then 8GB RAM using FreeBSD 12.x, > FreeBSD 13.x with MySQL 8.x from packages. >=20 > So I would suggest to upgrade the RAM of your Server/VM and repeat the > upgrade procedure of MySQL. Thanks for the suggestion but I have 16GB here and not running in a VM so s= houldn't=20 be the cause of the problem. =2D-=20 Mike Clarke --nextPart2338452.bDOn7JOVgO Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="UTF-8"

On Saturday, 15 April 2023 17:48:40 BST Daniel Dowse wrote:

>= ; I was facing similar problems when upgrading MySQL 5.7.x to MySQL 8.x

>= ; stalling with no error message from the mysql daemon or system. I fixed i= t

>= ; by upgrading my VM to 8GB System RAM. I had this issue first with Hetzer= =E2=80=99s

>= ; Cloud Infra and later I could reproduce the issue in my local environment=

>= ; with (bhyve,VirtualBox) VMs with less then 8GB RAM using FreeBSD 12.x,

>= ; FreeBSD 13.x with MySQL 8.x from packages.

>= ;

>= ; So I would suggest to upgrade the RAM of your Server/VM and repeat the

>= ; upgrade procedure of MySQL.


Thanks for the suggestion but I have 16GB here and not running in a VM s= o shouldn't be the cause of the problem.


--

Mik= e Clarke

--nextPart2338452.bDOn7JOVgO--