From nobody Sat Apr 15 16:48:40 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 4PzK5h3fG6z45f4f for ; Sat, 15 Apr 2023 16:48:56 +0000 (UTC) (envelope-from freebsd-ml@daemonbytes.net) Received: from mxout01.bytecamp.net (mxout01.bytecamp.net [212.204.60.217]) (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 4PzK5f56V2z3vcT for ; Sat, 15 Apr 2023 16:48:54 +0000 (UTC) (envelope-from freebsd-ml@daemonbytes.net) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=daemonbytes.net header.s=20140709 header.b=ixBkNEgU; spf=pass (mx1.freebsd.org: domain of freebsd-ml@daemonbytes.net designates 212.204.60.217 as permitted sender) smtp.mailfrom=freebsd-ml@daemonbytes.net; dmarc=none Received: by mxout01.bytecamp.net (Postfix, from userid 1001) id A50AB29971; Sat, 15 Apr 2023 18:48:51 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=daemonbytes.net; h=from:content-type:content-transfer-encoding:mime-version:subject:date:references:to:in-reply-to:message-id; s=20140709; bh=ZWOnlXA1tOp/A80/fO/q9i0voug=; b=ixBkNEgUipNcRfW8Fn0bnZfMtadS8u9PK3lbkDN7SLGvAGR7ozJIelVTSCNG/CCNtcxGVoUYZ5ZjonoRHUJgsS7SlSuV+aKaLJr7aUDfB1DjOqz/wTeFGls4cmkdwIpL2hnwycDjPuPQnaUdhR9bPbDIhveuv5v5keo2tKYDOoM= Received: from mail.bytecamp.net (mail.bytecamp.net [212.204.60.9]) by mxout01.bytecamp.net (Postfix) with ESMTP id 693902996E for ; Sat, 15 Apr 2023 18:48:51 +0200 (CEST) Received: (qmail 81358 invoked from network); 15 Apr 2023 18:48:51 +0200 Received: from unknown (HELO smtpclient.apple) (request@daemonbytes.net@178.27.123.10) by mail.bytecamp.net with ESMTPS (AES256-GCM-SHA384 encrypted); 15 Apr 2023 18:48:51 +0200 From: Daniel Dowse Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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 (Mac OS X Mail 16.0 \(3731.500.231\)) Subject: Re: MySQL server silently fails to start after upgrading from 5.7.40 to 8.0.32 Date: Sat, 15 Apr 2023 18:48:40 +0200 References: <4381878.Iv3B0QcHgC@curlew> To: questions@freebsd.org In-Reply-To: <4381878.Iv3B0QcHgC@curlew> Message-Id: X-Mailer: Apple Mail (2.3731.500.231) X-Spamd-Result: default: False [-3.20 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-1.00)[-0.999]; MV_CASE(0.50)[]; RCVD_IN_DNSWL_LOW(-0.20)[212.204.60.217:from,212.204.60.9:received]; R_SPF_ALLOW(-0.20)[+ip4:212.204.60.0/24]; R_DKIM_ALLOW(-0.20)[daemonbytes.net:s=20140709]; MIME_GOOD(-0.10)[text/plain]; ASN(0.00)[asn:12693, ipnet:212.204.32.0/19, country:DE]; RCVD_TLS_LAST(0.00)[]; MLMMJ_DEST(0.00)[questions@freebsd.org]; MIME_TRACE(0.00)[0:+]; FROM_EQ_ENVFROM(0.00)[]; DKIM_TRACE(0.00)[daemonbytes.net:+]; RCVD_COUNT_THREE(0.00)[4]; MID_RHS_MATCH_FROM(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; FROM_HAS_DN(0.00)[]; DMARC_NA(0.00)[daemonbytes.net]; PREVIOUSLY_DELIVERED(0.00)[questions@freebsd.org]; RCPT_COUNT_ONE(0.00)[1]; TO_DN_NONE(0.00)[]; ARC_NA(0.00)[] X-Rspamd-Queue-Id: 4PzK5f56V2z3vcT X-Spamd-Bar: --- X-ThisMailContainsUnwantedMimeParts: N > Am 15.04.2023 um 18:25 schrieb Mike Clarke = : >=20 >=20 > 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. >=20 Hi Mike, 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. Best regards and success Daniel