From nobody Sun Aug 11 21:56:41 2024 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 4Whs1f6SSSz5SJH3 for ; Sun, 11 Aug 2024 21:56:54 +0000 (UTC) (envelope-from boyvalue@gmail.com) Received: from mail-qk1-x732.google.com (mail-qk1-x732.google.com [IPv6:2607:f8b0:4864:20::732]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "WR4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Whs1f1Pzbz3xCl for ; Sun, 11 Aug 2024 21:56:54 +0000 (UTC) (envelope-from boyvalue@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20230601 header.b=MIRUoPC8; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of boyvalue@gmail.com designates 2607:f8b0:4864:20::732 as permitted sender) smtp.mailfrom=boyvalue@gmail.com Received: by mail-qk1-x732.google.com with SMTP id af79cd13be357-7a1d42da3baso252693285a.1 for ; Sun, 11 Aug 2024 14:56:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723413412; x=1724018212; darn=freebsd.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=cUcEpmfQIMLVY5GV7xLkcoJtgvvLXtIY9foLu1Nce5Q=; b=MIRUoPC8JShTb/3CLvygNVmrw4zKBwQOpYlHiSIRk5uG+mX63WTxRXrBGrvkVWYRb4 NdJHiFmJH7N/Yqeq5rHLT6QdXjbKC/5D8b/ixbMbVH007dbIKRXdXfZJZWXDnzxEaBZF iZtqBAMbAaq7gPYgRipYGRdGB2E9SUKwMYORcQinlcb/2rVuWCZXrcqc1JuOzwrs3a0X OXWq5oSav6C6wVrhdt3HE+UzHkYKvfsCJ4LlUCBZ2HV8tkWNFuZ347Ru5CcDV1RwrbA4 dV1ebsjlVbyO5SS4hyioBs/VgJGO4NwX01kZIh6Dqit8GKtgeSaen4Il8S5URunfIOmF XuMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723413412; x=1724018212; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=cUcEpmfQIMLVY5GV7xLkcoJtgvvLXtIY9foLu1Nce5Q=; b=i3TCfa7LPiXof67XiUhLwjXsac/K3VUhKB03VqpotTKg96oG3+M63MzjlCfKP+dMkg OHG1VGijrp8/Egr2svonztap41H5HvLNqntyDxjtojjKPLlU29mFbmqcvERm2T5gr6h2 wC8wyg1LhsmLkppQXLXz9jqJ9teUpT5jWvq/+Ktqd1jmIuo1lUPbw87IOXCRuBXblR5o BXffkmDFjdVImCthpAgv9aEq3ypui3arriszQFyb5VFJ0YvqM5p9dw8vMnvvzW4JXUfM ze8HszaghQRx50VodJ3+VI9SDm9pzeQfnrwEX6OtGRrQe2HaOD3xI+Ia+G8fQj3WIl7P wwbw== X-Gm-Message-State: AOJu0YxTLwx83BzvIw89BBdh+flhqV5DZL4TN70W6rAcU4WhX7Olxokv nzQdJc4wNIG7QsyT0U7qvweSxIV/ZAzCTfJsdDc6xdBjavOG3MvJI1ewZyliIzq22Df8guee6vr nCuZFTOTHX4wCrLWzd7gXy9w7i57J9Sc= X-Google-Smtp-Source: AGHT+IHNr004V3HXNWmzs8NrR6dXW2J70idJeRTu0hlRhBLSCwc+94pohWLq6la5tyIq28VJ/tnaTDAcGbipH4M3Q24= X-Received: by 2002:a05:620a:4456:b0:79d:a265:cc95 with SMTP id af79cd13be357-7a4c1864ba8mr1018090985a.65.1723413411888; Sun, 11 Aug 2024 14:56:51 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@FreeBSD.org MIME-Version: 1.0 From: Pamela Ballantyne Date: Sun, 11 Aug 2024 15:56:41 -0600 Message-ID: Subject: Problems upgrading to mysql 8.4 from 5.7 To: FreeBSD Content-Type: multipart/alternative; boundary="000000000000378568061f6f7476" X-Spamd-Bar: --- X-Spamd-Result: default: False [-4.00 / 15.00]; NEURAL_HAM_SHORT(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_LONG(-1.00)[-0.998]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20230601]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; TO_DN_ALL(0.00)[]; RCVD_TLS_LAST(0.00)[]; ARC_NA(0.00)[]; FROM_HAS_DN(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCPT_COUNT_ONE(0.00)[1]; FREEMAIL_ENVFROM(0.00)[gmail.com]; FREEMAIL_FROM(0.00)[gmail.com]; TO_MATCH_ENVRCPT_ALL(0.00)[]; MISSING_XM_UA(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; FROM_EQ_ENVFROM(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; MID_RHS_MATCH_FROMTLD(0.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; RCVD_COUNT_ONE(0.00)[1]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::732:from] X-Rspamd-Queue-Id: 4Whs1f1Pzbz3xCl --000000000000378568061f6f7476 Content-Type: text/plain; charset="UTF-8" I've just upgraded from the latest patch level of FreeBSD 12 to 13.3-p5. The only problem so far has been the MySQL upgrade. I didn't find any detailed instructions, I did vet the existing 5.7 db files as instructed on the MySQL site. Some instructions said to do a binary upgrade and start the MySQL server, which would upgrade the DB files. That's not happening. The upgrade process deleted 5.7. I used pkg to get mysql84. service mysql-server start The error log leaves a message about not being able to open mysql.ibd, which doesn't exist and I guess never has. Any help most urgently requested. Thanks! Pam Here's the logfile: 2024-08-11T21:44:30.6NZ mysqld_safe Logging to '/var/db/mysql/ns.ssr.com.err'. 2024-08-11T21:44:30.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2024-08-11T21:44:30.688377Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2024-08-11T21:44:30.899150Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-08-11T21:44:30.899204Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.4.0) starting as process 7738 2024-08-11T21:44:30.944078Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-08-11T21:44:31.708765Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2024-08-11T21:44:31.708803Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2024-08-11T21:44:31.708823Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: 'mysql.ibd' OS error: 71 mysqld: Can't open file: 'mysql.ibd' (errno: 0 - ) 2024-08-11T21:44:31.764666Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-08-11T21:44:31.764879Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-08-11T21:44:31.764911Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-08-11T21:44:31.766104Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.4.0) Source distribution. 2024-08-11T21:44:31.766134Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2024-08-11T21:44:31.6NZ mysqld_safe mysqld from pid file /var/db/mysql/ns.ssr.com.pid ended --000000000000378568061f6f7476 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I've just upgraded from the latest patch level of Free= BSD 12 to 13.3-p5.=C2=A0
The only problem so far has been the MySQL upg= rade.=C2=A0 I didn't find any
detailed instructions, I did ve= t the existing 5.7 db files as instructed on the
MySQL site. Some= instructions said to do a binary upgrade and start
the MySQL ser= ver, which would upgrade the DB files.

That's = not happening.

The upgrade process deleted 5.7. I = used pkg to get mysql84.

service mysql-server star= t

The error log leaves a message about not being a= ble to open mysql.ibd, which doesn't exist
and I guess never = has.

Any help most urgently requested.
T= hanks!
Pam

Here's the logfile:
=

2024-08-11T21:44:30.6NZ mysqld_safe Logging to '/va= r/db/mysql/ns.ssr.com.err'.
2024-08-11T21:44:30.6NZ mysqld_safe Star= ting mysqld daemon with databases from /var/db/mysql
2024-08-11T21:44:30= .688377Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-08-1= 1T21:44:30.899150Z 0 [Warning] [MY-010097] [Server] Insecure configuration = for --secure-file-priv: Current value does not restrict location of generat= ed files. Consider setting it to a valid, non-empty path.
2024-08-11T21:= 44:30.899204Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (my= sqld 8.4.0) starting as process 7738
2024-08-11T21:44:30.944078Z 1 [Syst= em] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-11T2= 1:44:31.708765Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error numbe= r 2 in a file operation.
2024-08-11T21:44:31.708803Z 1 [ERROR] [MY-01259= 3] [InnoDB] The error means the system cannot find the path specified.
2= 024-08-11T21:44:31.708823Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open dataf= ile for read-only: 'mysql.ibd' OS error: 71
mysqld: Can't op= en file: 'mysql.ibd' (errno: 0 - )
2024-08-11T21:44:31.764666Z 1= [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
202= 4-08-11T21:44:31.764879Z 0 [ERROR] [MY-010020] [Server] Data Dictionary ini= tialization failed.
2024-08-11T21:44:31.764911Z 0 [ERROR] [MY-010119] [S= erver] Aborting
2024-08-11T21:44:31.766104Z 0 [System] [MY-010910] [Serv= er] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.4.0) =C2=A0Sourc= e distribution.
2024-08-11T21:44:31.766134Z 0 [System] [MY-015016] [Serv= er] MySQL Server - end.
2024-08-11T21:44:31.6NZ mysqld_safe mysqld from = pid file /var/db/mysql/ns.ssr.com.pid ended
--000000000000378568061f6f7476--