From owner-freebsd-questions@freebsd.org Wed Jul 17 04:06:55 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 E3354A2BD0 for ; Wed, 17 Jul 2019 04:06:55 +0000 (UTC) (envelope-from tech-lists@zyxst.net) Received: from out5-smtp.messagingengine.com (out5-smtp.messagingengine.com [66.111.4.29]) (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 41C8B8C3C8 for ; Wed, 17 Jul 2019 04:06:54 +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 7C7BA223CE for ; Wed, 17 Jul 2019 00:06:53 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 17 Jul 2019 00:06:53 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zyxst.net; h= date:from:to:subject:message-id:mime-version:content-type; s= fm3; bh=/x+IFeT5e/vi22arFLcvE7EkqyPXJLXtl9RhfpUZv4s=; b=QE/KDZPw 26A7DsG3mHa2H6kJ/Xx+2ftQXpAWCLbx9obx9lsxHzM0xzMDB/jXFSozh8qSoW9P zz9OzNrqONOMdsg6GZNQ6ib8rgoK1hgWOap3zqH9a9Q7jh+ZZ6MCI8fRodH2UFO2 UgRuIkDbMfY0hNGFpCTz4FtK0eu0pGStn4ZfXC93rkBHf7t67LVVW37CFvuSqZ7H F9nz77/c3qy9I76PSh94IwGNcup4iZLN6a6PmhLaquWCpRjZrzXdAZfwncixQ+fJ 4DzL+vAXfLDqdiZcfot/PE/N++sNWAeoYnUqI0Is3ZAPBS73aO2Wkz3mcrWV56yz Bm4RRH5GF11Ymg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:message-id :mime-version:subject:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=/x+IFeT5e/vi22arFLcvE7EkqyPXJ LXtl9RhfpUZv4s=; b=iXU1JPsWoqhd+2Bz7fjCaXR/SXGxJDCBrUW93fzCoMgnj 9TPCO8vUmw20FISJyxVF/Nam3VjZzNNYyOxM+vH4RUS++rI9KoZiJ05ipKPG+Nax 9Kipy3nX1EMDwFwv5vFwh/y0WFIidv0SG6npJ7iuQGDBZfCU89TrlFB00SsrgYjN xFdTTzcc10UrRaNmMI61Y7XlTFtAAHMlaCVNiGFzociS45ojp3LpBmzm8Tm+72EC FgrMe1FTX/zD1I4wTzjSM0dupQ+cTkxfkPqjAZ1kS9DYO1QWoruxnUpDhOJ+5VL3 yi35W5ldRfpO4Abl8n+upq1mw0udR24aH3uu73npw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddriedugdekudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepfffhvffukfggtggufgesghdtreertd ervdenucfhrhhomhepthgvtghhqdhlihhsthhsuceothgvtghhqdhlihhsthhsseiihiig shhtrdhnvghtqeenucfkphepkedvrdejtddrledurdelleenucfrrghrrghmpehmrghilh hfrhhomhepthgvtghhqdhlihhsthhsseiihiigshhtrdhnvghtnecuvehluhhsthgvrhfu ihiivgeptd X-ME-Proxy: Received: from mon.zyxst.net (mon.zyxst.net [82.70.91.99]) by mail.messagingengine.com (Postfix) with ESMTPA id AB2ED380083 for ; Wed, 17 Jul 2019 00:06:52 -0400 (EDT) Date: Wed, 17 Jul 2019 05:06:50 +0100 From: tech-lists To: freebsd-questions@freebsd.org Subject: how to upgrade mysql56-server to mysql57-server? Message-ID: <20190717040650.GA55947@mon.zyxst.net> Mail-Followup-To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="sdtB3X0nJg68CQEu" Content-Disposition: inline User-Agent: Mutt/1.12.1 (2019-06-15) X-Rspamd-Queue-Id: 41C8B8C3C8 X-Spamd-Bar: -------- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=zyxst.net header.s=fm3 header.b=QE/KDZPw; dkim=pass header.d=messagingengine.com header.s=fm3 header.b=iXU1JPsW; spf=pass (mx1.freebsd.org: domain of tech-lists@zyxst.net designates 66.111.4.29 as permitted sender) smtp.mailfrom=tech-lists@zyxst.net X-Spamd-Result: default: False [-8.18 / 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.29]; 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]; DKIM_TRACE(0.00)[zyxst.net:+,messagingengine.com:+]; MX_GOOD(-0.01)[in2-smtp.messagingengine.com,in1-smtp.messagingengine.com,in2-smtp.messagingengine.com,in1-smtp.messagingengine.com,in2-smtp.messagingengine.com,in1-smtp.messagingengine.com,in2-smtp.messagingengine.com,in1-smtp.messagingengine.com]; NEURAL_HAM_SHORT(-0.94)[-0.944,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.53)[ip: (-9.81), ipnet: 66.111.4.0/24(-4.78), asn: 11403(-2.99), country: US(-0.06)]; RCVD_IN_DNSWL_LOW(-0.10)[29.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 04:06:55 -0000 --sdtB3X0nJg68CQEu Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi, The default version of mysql/mysqld changed from 5.6 to 5.7 on 20190701.=20 The problem now is that if "pkg upgrade" is run, mysql-client is=20 upgraded and the existing mysql(56)-server is *removed*. mysql57-server is not installed. If mysql57-server is then manually installed with pkg install, when=20 "service mysql-server start" is run, it starts up then exits.=20 This error happens: [ERROR] InnoDB: The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 4864 pages (rounded down to MB) than specified in the .cnf file: initial 4992 pages, max 0 (relevant if non-zero) pages! [1] This happens despite following the instructions in /usr/ports/UPDATING entry dated 20190701 for pkg. Basically, if you have a FAMP system and keep up-to-date with pkg, and you were using mysql56-server, just running pkg upgrade will leave you without any mysql server installed. It seems the only way of keeping mysqld at version 5.6 is to compile ports, which I didn't want to do (don't know if I can do) on this space-limited instance [2] [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:=20 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. [2] unless there is an exclude pattern that can be applied to pkg upgrade --=20 J. --sdtB3X0nJg68CQEu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEE8n3tWhxW11Ccvv9/s8o7QhFzNAUFAl0untEACgkQs8o7QhFz NAWAXg//XU5mX6rPIb2DGlFn0/mGzEWNusO96E8xC4SBi0iSZ9b8AVUUpgBFmV5z 2wpxsH3vlbs/n0j8a/HbP6hdIR8lKqOWikkU27w/2cQAG6jr4rfK3icJth4BLV46 evH0YRiD/aWzjxsoipAeJeuYxvw0illQj53TYGk6wMRJaZr9Js/Bv82tICaL0Y50 ZtApbl+nv8DwEAYaPmHCyfwuXjjmxQJ8aortz7Y3rg3l4THULJOv3alcg8DMh6So Du3rnipguAI6EmcALfj8RjhoewJtKn8OeqRZgDKYwLxkTsLeemJPHRzvonB410J8 k68wFi8Sbe8/cwEUJL62uDwW5AfbXPBGR18+EzTjyg0cDsc5Cz1UOL0GpowfwF4J 8fMVXKrLSdLMQv3Hj6VEucroYeAfSBIpG53xuvzjPnrP34CXOZPQFM9tiLLeYqWs e+6UDDcI4iacGMzKygSqgmsvsSd3/pQFKItiBO7e6vB54m2O1A/mbUckriDx6Tjh yTRnIHujg9QYfDHDxY83cRq5xIpL+9pBuNapDKkDJbXlNb6SOjJHW3dOLeSz9wsG bdhciCeIE4Mpcd7wCdwF2mQcpTXuXL51KebDUEQeFb6M34oTZHskXg69tAGw6BqI V7CLkMhO6RsoPZqbQPshmD00OnVrpXT2+liDRuqCyr5sVWjOuS0= =MBxV -----END PGP SIGNATURE----- --sdtB3X0nJg68CQEu--