[vpsFree.cz: community-list] mysql problem

Sun Aug 5 21:02:08 CEST 2012

Diky ...
zatim jsem tedy pokrocil takto:

1/ myisam tabulky vypadaji ok, tam repair, check, optimize proslo ok
2/ inndodb tabulky konci errorem:

mysqlcheck: Got error: 2013: Lost connection to MySQL server during 
query when executing 'OPTIMIZE TABLE ... '

zatim to tedy vypada ze budu muset udelat neco takoveho:

http://www.mysqlperformanceblog.com/2008/07/04/recovering-innodb-table-corruption/

pokud tedy nemate nikdo nejaky jiny napad.

Diky.

Dusan

On 08/05/2012 04:25 PM, Pavel Snajdr wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Prinejhorsim ti experimentalne zpristupnim zalohu a budes si moct
> vytahnout drivejsi snapshoty mysql dat, doufam ze aspon jeden z nich
> bude konzistentni.
>
> S pozdravem
>
> Pavel Snajdr
>
> +421 948 816 186  | +420 720 107 791          | 110-010-956
> CTO of Relbit     | Predseda vpsFree.cz, o.s. | RHCE
> http://relbit.com | http://vpsfree.cz         | https://www.redhat.com
>
> On 08/05/2012 03:50 PM, Dusan Simek wrote:
>> Nezkousel, zkusim, o ty poskozeny intergite jsem taky premyslel.
>>
>> V priloze by mel byt my.cnf, jestli to projde.
>>
>> Dusan
>>
>> On 08/05/2012 03:45 PM, Tomas Srnka wrote:
>>> http://www.cafewebmaster.com/repair-all-mysql-databases-tables-php
>>> -> take nieco si skusal? Mozes mat poskodenu integritu
>>> niektorych tabuliek. Idealne si napis skript, co zbehne  CHECK a
>>> REPAIR na vsetky tabulky vo vsetkych DB.
>>>
>>> On Aug 5, 2012, at 3:38 PM, Dusan Simek <pixelfields at gmail.com>
>>> wrote:
>>>
>>>> Ahoj chlapci, ten patecni vypadek/presun vps mi nejak rozbil
>>>> mysql. Chtel bych poprosit o info, jak to opravit, pokud s tim
>>>> mate nekdo nejakou zkusenost. Situace je nasledujici:
>>>>
>>>> Pri nekterych requestech (je to nahodne, 10 requestu ok, 11
>>>> zfailuje) dojde ke bude k chybe pri pripojeni, nebo ke ztrate
>>>> spojeni. V logu vidim nasledujici:
>>>>
>>>> bud:
>>>>
>>>> OperationalError: (2013, "Lost connection to MySQL server at
>>>> 'reading initial communication packet', system error: 104")
>>>>
>>>> nebo:
>>>>
>>>> OperationalError: (2003, "Can't connect to MySQL server on
>>>> '83.167.228.14' (111)")
>>>>
>>>> nebo:
>>>>
>>>> OperationalError: (2002, "Can't connect to local MySQL server
>>>> through socket '/var/run/mysqld/mysqld.sock' (2)")
>>>>
>>>> mysql vypada, ze bezi normalne:
>>>>
>>>> netstat -tupan | grep mysql tcp        0      0 0.0.0.0:3306
>>>> 0.0.0.0:* LISTEN 26693/mysqld
>>>>
>>>> ps ax | grep mysql 12488 ?        S      0:04 /bin/sh
>>>> /usr/bin/mysqld_safe 26869 ?        Sl     0:02
>>>> /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql
>>>> --user=mysql --log-error=/var/lib/mysql/msa.err
>>>> --pid-file=/var/lib/mysql/msa.pid
>>>> --socket=/var/run/mysqld/mysqld.sock --port=3306
>>>>
>>>> socket vypada ok:
>>>>
>>>> ls -la /var/run/mysqld/ total 8 drwxr-xr-x  2 mysql mysql 4096
>>>> Aug  5 15:32 . drwxr-xr-x 20 root  root  4096 Aug  5 10:46 ..
>>>> srwxrwxrwx  1 mysql mysql    0 Aug  5 15:32 mysqld.sock
>>>>
>>>>
>>>> Kdyz zkusim mysql restartovat, dostanu nasledujici:
>>>>
>>>> /etc/init.d/mysql restart Stopping MySQL database server:
>>>> mysqld. Starting MySQL database server: mysqld. Checking for
>>>> corrupt, not cleanly closed and upgrade needing tables..
>>>> msa:.../home/dsimek > ERROR 2013 (HY000) at line 1: Lost
>>>> connection to MySQL server during query ERROR 2002 (HY000):
>>>> Can't connect to local MySQL server through socket
>>>> '/var/run/mysqld/mysqld.sock' (111) ERROR 2002 (HY000): Can't
>>>> connect to local MySQL server through socket
>>>> '/var/run/mysqld/mysqld.sock' (2) ....
>>>>
>>>> v logu pri startu vidim toto:
>>>>
>>>> Aug  5 10:26:33 msa /etc/mysql/debian-start[30658]: Upgrading
>>>> MySQL tables if necessary. Aug  5 10:26:33 msa
>>>> /etc/mysql/debian-start[30664]: /usr/bin/mysql_upgrade: the
>>>> '--basedir' option is always ignored Aug  5 10:26:33 msa
>>>> /etc/mysql/debian-start[30664]: Looking for 'mysql' as:
>>>> /usr/bin/mysql Aug  5 10:26:33 msa
>>>> /etc/mysql/debian-start[30664]: Looking for 'mysqlcheck' as:
>>>> /usr/bin/mysqlcheck Aug  5 10:26:33 msa
>>>> /etc/mysql/debian-start[30664]: This installation of MySQL is
>>>> already upgraded to 5.1.63, use --force if you still need to
>>>> run mysql_upgrade Aug  5 10:26:33 msa
>>>> /etc/mysql/debian-start[30672]: Checking for insecure root
>>>> accounts. Aug  5 10:26:33 msa /etc/mysql/debian-start[30677]:
>>>> Triggering myisam-recover for all MyISAM tables
>>>>
>>>> Diky za jakykoliv tip.
>>>>
>>>> Dusan _______________________________________________
>>>> Community-list mailing list Community-list at lists.vpsfree.cz
>>>> http://lists.vpsfree.cz/listinfo/community-list
>>>
>>> _______________________________________________ Community-list
>>> mailing list Community-list at lists.vpsfree.cz
>>> http://lists.vpsfree.cz/listinfo/community-list
>>>
>>
>>
>> _______________________________________________ Community-list
>> mailing list Community-list at lists.vpsfree.cz
>> http://lists.vpsfree.cz/listinfo/community-list
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.12 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iF4EAREIAAYFAlAeglAACgkQdh+64ds5DaacSwD/eG8sDfT9ycREamDJW5D6Iny3
> 1Vy3XCg3RahKLAqrfjAA/R7jp3yPam63I5dtv/dbFTXw27WfyfUtAaXQT3UdxljG
> =Fpgl
> -----END PGP SIGNATURE-----
> _______________________________________________
> Community-list mailing list
> Community-list at lists.vpsfree.cz
> http://lists.vpsfree.cz/listinfo/community-list
>