-----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
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(a)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(a)lists.vpsfree.cz
http://lists.vpsfree.cz/listinfo/community-list
_______________________________________________ Community-list
mailing list Community-list(a)lists.vpsfree.cz
http://lists.vpsfree.cz/listinfo/community-list
_______________________________________________ Community-list
mailing list Community-list(a)lists.vpsfree.cz
-----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-----