Le dimanche 11 juillet 2010 20:07:11, roun...@hotmail.ru a écrit : > St??phane Guedon wrote: > >> Hello > >> > >> Could someone help me concerning mysql. > >> > >> My servers (both laptop hosted mysql and server hosted) are buggy. Every > >> time I restart them through the init script, it crash ! : > >> > >> 18:15:06 r...@einstein:~ # rc-service mysql restart > >> pdns | * Stopping PowerDNS (default) ... > >> mediatomb | * Stopping MediaTomb ... > >> [ ok ] mysql | * Stopping ... > >> mysql | * Stopping mysqld (0) > >> [ ok ] mysql | * Starting ... > >> mysql | * Starting (/etc/mysql/my.cnf) > >> mysql | * MySQL NOT started (0) > >> [ !! ] mysql | * ERROR: mysql failed to start > >> 18:15:44 r...@einstein:~ # ps -A|grep mys > >> > >> 2333 ? 00:00:00 mysqld > >> > >> 18:15:56 r...@einstein:~ # killall mysqld > >> 18:17:37 r...@einstein:~ # rc-service mysql zap > >> mysql | * Manually resetting mysql to stopped state > >> 18:17:44 r...@einstein:~ # rc-service mysql start > >> mysql | * Starting ... > >> mysql | * Starting (/etc/mysql/my.cnf) > >> mysql | * MySQL NOT started (0) > >> [ !! ] mysql | * ERROR: mysql failed to start > >> 18:17:53 r...@einstein:~ # ps -A|grep mys > >> > >> 2628 ? 00:00:00 mysqld > >> > >> Of course, it crashs also on boot process, whereas at least two services > >> (pdns and mediatomb) need it ! > >> > >> ========================== > >> > >> Here is the end of emerge --info mysql for the server hosted, which is > >> the most problematic : > >> > >> dev-db/mysql-5.1.46 was built with the following: > >> USE="community debug latin1 (multilib) perl -big-tables -cluster > >> -embedded -extraengine -max-idx-128 - minimal -pbxt -profiling > >> (-selinux) -ssl -static -test -xtradb" CFLAGS="-march=native -O3 -pipe > >> -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing" > >> CXXFLAGS="-march=native -O3 -pipe -fomit-frame-pointer > >> -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions - fno-strict-aliasing > >> -felide-constructors -fno-rtti -fno-implicit-templates > >> -fno-strict-aliasing" > >> > >> ========================== > >> > >> I think I have read carefully the doc concerning mysql : > >> http://www.gentoo.org/doc/fr/mysql-howto.xml. > >> > >> What can I do ? > >> > >> Thanks > > Hello, > > What do the logs in /var/log/mysql/ read? Thats where I'd look for the > clue. Also check your config file.
19:12:09 r...@einstein:/var/log/mysql # ls -l total 36 -rw-rw---- 1 mysql mysql 0 Jul 11 15:05 mysql.err -rw-rw---- 1 mysql mysql 0 Jul 11 15:05 mysql.log -rw-rw---- 1 mysql mysql 36816 Apr 21 10:52 mysqld.err 19:14:11 r...@einstein:/var/log/mysql # tail mysqld.err 100323 8:30:20 [Note] Event Scheduler: Loaded 0 events 100323 8:30:20 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.44-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-5.1.44-r1 100421 10:52:15 [Note] /usr/sbin/mysqld: Normal shutdown 100421 10:52:17 [Note] Event Scheduler: Purging the queue. 0 events 100421 10:52:20 InnoDB: Starting shutdown... 100421 10:52:39 InnoDB: Shutdown completed; log sequence number 0 8395213 100421 10:52:40 [Note] /usr/sbin/mysqld: Shutdown complete This file is like this since DAYS ! I don't know why ! I use the usual config file given by the emerge process... > > Ragards, > > Matt -- Stéphane Guedon page web : http://www.22decembre.eu/ carte de visite : http://www.22decembre.eu/downloads/Stephane-Guedon.vcf clé publique gpg : http://www.22decembre.eu/downloads/Stephane-Guedon.asc
signature.asc
Description: This is a digitally signed message part.