From: Reindl Harald
Date: November 6 2011 10:35am
Subject: Re: InnoDB =?UTF-8?B?4oCcbG9nIHNlcXVlbmNlIGluIHRoZSBmdXR1cmUh4oCd?=
 =?UTF-8?B?IGNyYXNoaW5nLCB3b24ndCBzdGFydA==?=
List-Archive: http://lists.mysql.com/mysql/226254
Message-Id: <4EB662E8.7010106@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig7BB4D9DCF9AFC1D37B265D17"

--------------enig7BB4D9DCF9AFC1D37B265D17
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable



Am 06.11.2011 06:05, schrieb Kevin Wang:
> I stopped mysql only to find that it wouldn't come back up, /etc/init.d=
/mysql
> start only outputs . . . . . . failed. I've narrowed it down to an issu=
e
> with InnoDB. The database starts when innodb_force_recovery =3D 5 and n=
othing
> lower. When I "check table" for my MyISAM tables, they check fine, but =
the
> connection is dropped when I attempt to do so for my InnoDB tables with=

> force_recovery set. mysql.err and mysql.log are empty.  Here are the
> relevant logs from syslog when I attempt to start with
> innodb_force_recovery set to zero: http://pastebin.com/jzhEuWFu
>=20
> and here's my my.cnf file: http://pastebin.com/qn6huZ09

why do you care about starting mysql as long the systme is whining
the whole time over a dying harddisk?

What did you think "Unrecovered read error" and "Medium error"
try to tell you? this are kernel messages saying: hopefully you
have a backup and if not now is learning lesson for the future


--------------enig7BB4D9DCF9AFC1D37B265D17
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk62YukACgkQhmBjz394AnltdwCggyspYdJ6wp2OaQ0kyanfugVi
sYwAoIO4f1iFBrt7CtzlLORRtcUraGBO
=JkGv
-----END PGP SIGNATURE-----

--------------enig7BB4D9DCF9AFC1D37B265D17--