From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id 715B61387CA for ; Wed, 15 Oct 2014 12:05:49 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id B6476E08D5; Wed, 15 Oct 2014 12:05:43 +0000 (UTC) Received: from mail-wi0-f173.google.com (mail-wi0-f173.google.com [209.85.212.173]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 7A2C3E076B for ; Wed, 15 Oct 2014 12:05:42 +0000 (UTC) Received: by mail-wi0-f173.google.com with SMTP id fb4so12765766wid.0 for ; Wed, 15 Oct 2014 05:05:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:reply-to:to:subject:date:user-agent:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; bh=LUWduUrGa/WamC9Xp01XVB5Q1gtYMmc2j6sFooKQsZc=; b=jN3R3BwYW5GA/IgHCcyx5hN1RPVhCbk0rfVrehn6uFnztTZIi5U6/3FGEhXBDgN4V2 b4BrRYN025Rjph0kLGbGbQ6fHcG8+9pj9Fcedx367mMDqQ4Y4HiIBimUwkY+mM/xKc8M LXGIN5InBjzx5zt9i9nJgP9cGCa425by6HhqfpkAogMMKXVNwy1axZodIa0UuuEFTmh0 rC52+6JmahheyunMzka9Y3IGRvQp3Hg31OwWZ2IwK1xJz0e5hW11utG26JWqyUNj5yfl X6VKanvm9URYKupskL/usBdxfuBYFAImp7ra2uqOn26NAXQGJxcWlzlsI/eDIdf8qoZP uhwQ== X-Received: by 10.194.184.40 with SMTP id er8mr2279090wjc.124.1413374740357; Wed, 15 Oct 2014 05:05:40 -0700 (PDT) Received: from dell_xps.localnet (230.3.169.217.in-addr.arpa. [217.169.3.230]) by mx.google.com with ESMTPSA id om1sm23656308wjc.42.2014.10.15.05.05.38 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 15 Oct 2014 05:05:39 -0700 (PDT) From: Mick To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] [slightly O/T] mysql problems Date: Wed, 15 Oct 2014 13:05:07 +0100 User-Agent: KMail/1.13.7 (Linux/3.14.14-gentoo; KDE/4.12.5; x86_64; ; ) References: <201410141955.04196.michaelkintzios@gmail.com> <201410142325.35604.michaelkintzios@gmail.com> <543DCA7D.6030603@fastmail.co.uk> In-Reply-To: <543DCA7D.6030603@fastmail.co.uk> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart6639674.1BPmphlYmM"; protocol="application/pgp-signature"; micalg=pgp-sha256 Content-Transfer-Encoding: 7bit Message-Id: <201410151305.18439.michaelkintzios@gmail.com> X-Archives-Salt: 4f306954-b737-4779-94a0-64524065c2bf X-Archives-Hash: 086a6fe187b53e54e2e6472793698f4c --nextPart6639674.1BPmphlYmM Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable On Wednesday 15 Oct 2014 02:14:37 Kerin Millar wrote: > On 14/10/2014 23:25, Mick wrote: > > On Tuesday 14 Oct 2014 21:15:48 Kerin Millar wrote: > >> * Have you upgraded MySQL recently without going through the > >> documented upgrade procedure? [1] > >=20 > > I'm still on mysql-5.5.39 >=20 > OK. If it has always been running MySQL 5.5, there's nothing to be > concerned about. No, sorry I wasn't clear. I have been upgrading mysql on this machine for= =20 some years now, always running stable versions. After each update I run: mysql_upgrade -h localhost -u root -p > >> * Have you otherwise removed or modified files in the data > >> directory? > >=20 > > Not as far as I know. I have suspicions of fs corruption though (it's > > been running out of space lately and I haven't yet found out why). >=20 > Not good. Which filesystem, if I may ask? XFS is preferable, due to its > very good performance with O_DIRECT, which ext4 coming in second. Other > filesystems may be problematic. In particular, ZFS does not support > asynchronous I/O. ext4 > In any case, go into /var/lib/mysql and check whether the file that it > mentions exists. If it does not exist, try running: >=20 > DROP TABLE `website1@002dnew`.`webform_validation_rule_components` >=20 > If that does not work then try again, using DISCARD TABLESPACE as > opposed to DROP TABLE. Note that the backtick quoting is necessary > because of the presence of the @ symbol in the database name, which > would otherwise be misinterpreted. Hmm ... I'm probably not doing this right. =46irst of all, there is no local database /var/lib/mysql/website1, because= this=20 is the live website name, on the shared server. I only have=20 /var/lib/mysql/website_test on the local dev machine. Then although I can see, e.g. =2Drw-rw---- 1 mysql mysql 8939 Oct 14 19:25 actions.frm =2Drw-rw---- 1 mysql mysql 98304 Oct 14 19:25 actions.ibd in /var/lib/mysql/website_test, if I try to run DROP TABlE, logged in as=20 (mysql) root, I get an unknown table, error 1051. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D mysql> USE website_test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> DROP TABLE `website1@002dnew`.`actions`; = =20 ERROR 1051 (42S02): Unknown table 'actions' mysql> DISCARD TABLESPACE `website1@002dnew`.`actions`; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual= =20 that corresponds to your MySQL server version for the right syntax to use n= ear=20 'DISCARD TABLESPACE `website1@002dnew`.`actions`' at line 1 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D I think in mysql-5.5 I should be using DROP TABLESPACE instead? PS. This is the only database I have problems with. There are another doze= n=20 or so which I have imported in a similar fashion and there are no errors in= =20 the logs about them. =2D-=20 Regards, Mick --nextPart6639674.1BPmphlYmM Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAABCAAGBQJUPmL+AAoJELAdA+zwE4Yeg2MIAK+hsG6mRiHAtZjr6lM5bUmd 9IP85oAmZSf1vN2c2+vXSlS0kh/miZ8lfvagGT6QpFmJ6dDPYEYSFsSroWlycwXf 91tVb5r9Y/R8uGhX4fLmqPJ67KKfKJnXRmKHLdx2wlQ5QcYx4SBSY3o3JANPMz+v JQDW/n/V0WrE3APMrdWGs3ytu8ixMaUfKBrN4Jo+soQ8Z54qvGLCNISaNw1/iewI BTk+xoRRG3JCzJpFqTl47APCIjdAty09l5CWxVZjOBzCX7pch3CJAbK2sFB30TDD pNFtivnsXVUQpOniveUItPkEQGDrjG68WI1DHt4YOWmx94nplqV5uR0FThHeePE= =B8vR -----END PGP SIGNATURE----- --nextPart6639674.1BPmphlYmM--