Have you checked in /var/log/mysql/mysqld.log to see what is making the service crash?
[ Brandon Adams ] bmadams at gmail dot com On Sun, Jul 11, 2010 at 12:29 PM, Stéphane Guedon <[email protected]>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 > > -- > 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 >
