dumb crash

Hydro Quebec just f***ed my server just as I was booting up three
machines; XP is ok, FreeBSD 7.1 is the one with mysql problem, FreeBSD
4.10 - don't know, but boots ok. Result: can't access database. One
table seems to abort mysqld. PhpMyAdmin connects to all databases except
one.

mysql> CHECK TABLE producer;
ERROR 2006 (HY000): Mysql server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: theproblem-one
Error 2006 (HY000: Mysql server has gone away
ERROR 2002 (HY000): Can't connect to local lMySQL server through socket
'/tmp/mysql.sock' (61)
ERROR: Can't connect to the server
mysql>

ps shows mysqls is running in safe mode

Can't find anything on googie
I've tried SELECT .... INTO OUTFILE - same errors...
WEBMIN shows all dbs except the fro producer and phpMyAdmin resets to
login page when trying to access producer table.

Any suggestions or bad experiences solved?


--
Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
------------------------------------------------------------ -
Phil Jourdan --- pj@ptahhotep.com
http://www.ptahhotep.com
http://www.chiccantine.com/andypantry.php


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: dumb crash

--00151750eed09e0425046c05dc78
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable

Hi,

any message on the error log? Have you tried restarting the mysql server?

On Tue, May 26, 2009 at 7:24 PM, PJ wrote:

> Hydro Quebec just f***ed my server just as I was booting up three
> machines; XP is ok, FreeBSD 7.1 is the one with mysql problem, FreeBSD
> 4.10 - don't know, but boots ok. Result: can't access database. One
> table seems to abort mysqld. PhpMyAdmin connects to all databases except
> one.
>
> mysql> CHECK TABLE producer;
> ERROR 2006 (HY000): Mysql server has gone away
> No connection. Trying to reconnect...
> Connection id: 1
> Current database: theproblem-one
> Error 2006 (HY000: Mysql server has gone away
> ERROR 2002 (HY000): Can't connect to local lMySQL server through socket
> '/tmp/mysql.sock' (61)
> ERROR: Can't connect to the server
> mysql>
>
> ps shows mysqls is running in safe mode
>
> Can't find anything on googie
> I've tried SELECT .... INTO OUTFILE - same errors...
> WEBMIN shows all dbs except the fro producer and phpMyAdmin resets to
> login page when trying to access producer table.
>
> Any suggestions or bad experiences solved?
>
>
> --
> Herv=E9 Kempf: "Pour sauver la plan=E8te, sortez du capitalisme."
> ------------------------------------------------------------ -
> Phil Jourdan --- pj@ptahhotep.com
> http://www.ptahhotep.com
> http://www.chiccantine.com/andypantry.php
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Disart.montane@gmail.com
>
>

--00151750eed09e0425046c05dc78--

Re: dumb crash

Hi PJ,

Try adding "innodb_force_recovery =3D 4" to the mysqld section of your
config file before restarting the server.If you can dump your tables
using "4" then only some data on corrupt individual pages is lost. If
you have to use innodb_force_recovery =3D 6, that means your db pages
are left in an obsolete state and your B-trees structures may also be
corrupt.

2009/6/10 Isart Montane :
> Hi,
>
> any message on the error log? Have you tried restarting the mysql server?
>
> On Tue, May 26, 2009 at 7:24 PM, PJ wrote:
>
>> Hydro Quebec just f***ed my server just as I was booting up three
>> machines; XP is ok, FreeBSD 7.1 is the one with mysql problem, FreeBSD
>> 4.10 - don't know, but boots ok. Result: can't access database. One
>> table seems to abort mysqld. PhpMyAdmin connects to all databases except
>> one.
>>
>> mysql> CHECK TABLE producer;
>> ERROR 2006 (HY000): Mysql server has gone away
>> No connection. Trying to reconnect...
>> Connection id: =A0 =A0 1
>> Current database: theproblem-one
>> Error 2006 (HY000: Mysql server has gone away
>> ERROR 2002 (HY000): Can't connect to local lMySQL server through socket
>> '/tmp/mysql.sock' =A0 (61)
>> ERROR: Can't connect to the server
>> mysql>
>>
>> ps shows mysqls is running in safe mode
>>
>> Can't find anything on googie
>> I've tried SELECT .... INTO OUTFILE - same errors...
>> WEBMIN shows all dbs except the fro producer and phpMyAdmin resets to
>> login page when trying to access producer table.
>>
>> Any suggestions or bad experiences solved?
>>
>>
>> --
>> Herv=E9 Kempf: "Pour sauver la plan=E8te, sortez du capitalisme."
>> ------------------------------------------------------------ -
>> Phil Jourdan --- pj@ptahhotep.com
>> =A0 http://www.ptahhotep.com
>> =A0 http://www.chiccantine.com/andypantry.php
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=3Disart.montane@gmail.com
>>
>>
>



--=20
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the biggest scourge on plain text email discussions?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg