From owner-freebsd-questions@freebsd.org Wed Jul 17 13:07:34 2019 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 60855AC656 for ; Wed, 17 Jul 2019 13:07:34 +0000 (UTC) (envelope-from tech-lists@zyxst.net) Received: from out1-smtp.messagingengine.com (out1-smtp.messagingengine.com [66.111.4.25]) (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 7FB4680A1B for ; Wed, 17 Jul 2019 13:07:33 +0000 (UTC) (envelope-from tech-lists@zyxst.net) Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 59228220CF for ; Wed, 17 Jul 2019 09:07:27 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Wed, 17 Jul 2019 09:07:27 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zyxst.net; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=4kXOySJKYISZ0pCdN7MTo8v1AhC t35O0ohcxewHik3s=; b=goTHwy7XYo0fGDLcOc0ibVfNVjquSY3j2F57xYnElEa Ge+rU+dl1V9INA5qEiyxMoOt41aWuHvxEf/wlbWsursxKJTJWqCajYNTXL6UhMSE 2jB/Qjj3YO/P2Tpk9JQXAVjEDFvlT9I+krNQ4MgYo8j4gJy6OXcJitZKBkLQBD/S LCugp6YqLSEaHMjG6uGv+ml60CgLKmIkBJcynTlmXrYuaFwSx+rCvkEwk7B+cXly GQ5i0enIxbnv+dJh9jKcKD3eoUwWYXoY1ku09+Itox+QpBXHHARS6HjjQ3Yv20Bz QCteeT3sJHKaayCtXyx8QRSuEiKV/IU6imJBjp/HgCQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=4kXOyS JKYISZ0pCdN7MTo8v1AhCt35O0ohcxewHik3s=; b=b8T8ei+wDA1VLHHd5Gp9ls AduOWYsQAGGKpk865pXu0VI3XkHT6xjZkUYYQCVXB8G4PHWTeVL/pfT98F5W+xsf ehr1o8OCT/GZrAwbA+UdxCSEeG0xfx9+Ut8mJeYDKVJRSlMHyRp0OmV66oGZNNWX leBHFDpS2srwokVDbWZsWuEM06YKgO8xk5kRG0s3bz2bHGHCyZYVPDY/T54xbtaV h5urLM1Ez1B+u7h7zXpve4Ft4z4LEX7BATuZOvF+a1FuUHCCsQnoy0LmhhHqcFNm jX4zyi4DPrtJu159zka6UJvHFTgZzF7ZInI4ppvajhxiFCId3a1YzvRe0MMROzfQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddrieefgdefjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepfffhvffukfhfgggtuggjfgesghdtre ertdervdenucfhrhhomhepthgvtghhqdhlihhsthhsuceothgvtghhqdhlihhsthhsseii hiigshhtrdhnvghtqeenucfkphepkedvrdejtddrledurdelleenucfrrghrrghmpehmrg hilhhfrhhomhepthgvtghhqdhlihhsthhsseiihiigshhtrdhnvghtnecuvehluhhsthgv rhfuihiivgeptd X-ME-Proxy: Received: from mon.zyxst.net (mon.zyxst.net [82.70.91.99]) by mail.messagingengine.com (Postfix) with ESMTPA id 83D6280059 for ; Wed, 17 Jul 2019 09:07:26 -0400 (EDT) Date: Wed, 17 Jul 2019 14:07:24 +0100 From: tech-lists To: freebsd-questions@freebsd.org Subject: Re: how to upgrade mysql56-server to mysql57-server? Message-ID: <20190717130724.GA56923@mon.zyxst.net> Mail-Followup-To: freebsd-questions@freebsd.org References: <20190717040650.GA55947@mon.zyxst.net> <1569215.MsCH1bHPGx@curlew> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="CE+1k2dSO48ffgeK" Content-Disposition: inline In-Reply-To: <1569215.MsCH1bHPGx@curlew> User-Agent: Mutt/1.12.1 (2019-06-15) X-Rspamd-Queue-Id: 7FB4680A1B X-Spamd-Bar: -------- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=zyxst.net header.s=fm3 header.b=goTHwy7X; dkim=pass header.d=messagingengine.com header.s=fm3 header.b=b8T8ei+w; spf=pass (mx1.freebsd.org: domain of tech-lists@zyxst.net designates 66.111.4.25 as permitted sender) smtp.mailfrom=tech-lists@zyxst.net X-Spamd-Result: default: False [-8.17 / 15.00]; ARC_NA(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; R_DKIM_ALLOW(-0.20)[zyxst.net:s=fm3,messagingengine.com:s=fm3]; NEURAL_HAM_MEDIUM(-1.00)[-1.000,0]; FROM_HAS_DN(0.00)[]; R_SPF_ALLOW(-0.20)[+ip4:66.111.4.25]; TO_MATCH_ENVRCPT_ALL(0.00)[]; MIME_GOOD(-0.20)[multipart/signed,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; TO_DN_NONE(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; NEURAL_HAM_LONG(-1.00)[-1.000,0]; RCVD_COUNT_THREE(0.00)[4]; DMARC_NA(0.00)[zyxst.net]; MX_GOOD(-0.01)[cached: in2-smtp.messagingengine.com]; DKIM_TRACE(0.00)[zyxst.net:+,messagingengine.com:+]; NEURAL_HAM_SHORT(-0.99)[-0.990,0]; SIGNED_PGP(-2.00)[]; FROM_EQ_ENVFROM(0.00)[]; SUBJECT_ENDS_QUESTION(1.00)[]; MIME_TRACE(0.00)[0:+,1:+]; ASN(0.00)[asn:11403, ipnet:66.111.4.0/24, country:US]; RCVD_TLS_LAST(0.00)[]; IP_SCORE(-3.47)[ip: (-9.52), ipnet: 66.111.4.0/24(-4.78), asn: 11403(-2.98), country: US(-0.05)]; RCVD_IN_DNSWL_LOW(-0.10)[25.4.111.66.list.dnswl.org : 127.0.5.1] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 17 Jul 2019 13:07:34 -0000 --CE+1k2dSO48ffgeK Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jul 17, 2019 at 10:06:04AM +0100, Mike Clarke wrote: >On Wednesday, 17 July 2019 05:06:50 BST tech-lists wrote: > >> [1] this was partially fixed by doing ls -lh on /var/db/mysql/ibdata1 >> (my file was 78MB) and then looking for the innodb_data_file_path =3D >> setting in /usr/local/etc/mysql/my.cnf and setting it like this: >> ibdata1:76M:autoextend at least then it would start. However, running >> mysql_check reported errors when it got to the databases. Some innodb >> tables aren't being read, and I don't know how to fix these. > >You need to run mysql_upgrade and then restart the mysql server Sorry, I meant mysql_upgrade. Like this: # mysql_upgrade root@localhost -p Enter password:=20 Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK [...] lots of this, ends here: mysql.user OK Upgrading the sys schema. Checking databases. Error occurred: Error during call to mysql_check. This still happens even if the process is repeated. The only difference in output: mysql.user OK The sys schema is already up to date (version 1.5.1). Checking databases. Error occurred: Error during call to mysql_check. [...] So it seems mysql_upgrade invokes mysql_check. Nothing usable in the error log; I can't see which tables are malfunctioning. The way I can tell is indirectly, when the=20 mysqld-enabled site loads, there is missing information. --=20 J. --CE+1k2dSO48ffgeK Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEE8n3tWhxW11Ccvv9/s8o7QhFzNAUFAl0vHYIACgkQs8o7QhFz NAUpYQ//TelZlrL+cQB5cUJyMiSB2b00rm/S5PqoksZTi6D537BJZjA7mr9HhBrX pqi/enxmhaf94NCtIeyjtFaWQxrtlwzxL8igq5fggeOOW7VTL8sNyUgCoIcZcsba PBchz+mqRCAegHTWtngHZl8sbau0jQUGl/4LJUauiRkfoLT4zSNo2SSe60ZualTs zp1vf3uKKBo6k/Z4SceuW3ZcPyO+Fwb9LT9EALKw5hnVEPiiIY+3kAnQHQhRW1JB csaCeEdZ860qozg389iHwft3zC/KHqKpjaMUOhanGQCJZdZ2h/ds5m5ej5ZRuAHP uykdgAb9WB2p6UctToK7/oH5Ppt2c+BDUfu7TSnZYKHha69Z2TtQjMhZeJo/ZDe6 tuWP4GSSp7oqoTgvV704CSLma4cE2ScgG71f2VD81Vde/BBFwbaYLOfSFaFys3Hh aQ1aGWZ60p3eahgIRhn9+jTx8uBvG9TelGwvB/cBFSwWtJXox8iwBzORWJzHw6/H VhYg4BqoGzIzEKwalejZnWPZKdu2Y0312UBRI9kb3fZmcvFdHDxSO+ihzjCKH9F0 7Kw/vvVUbFN9XLbFG2rwkzkxzEQ7QczxeJkspO5nMK0LChmqZBjFYYTM109sp9N1 TeOWmDv0eTI589FjdDaG+X3+5M+78qI8jfaEn1zWuI3Exf5Jnow= =He/j -----END PGP SIGNATURE----- --CE+1k2dSO48ffgeK--