Re: [gentoo-user] mysql

[Stéphane Guedon]

Le dimanche 11 juillet 2010 20:07:11, roundyz@×××××××.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 root@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 root@einstein:~ # ps -A|grep mys
> >>
> >>  2333 ?        00:00:00 mysqld
> >>
> >> 18:15:56 root@einstein:~ # killall mysqld
> >> 18:17:37 root@einstein:~ # rc-service mysql zap
> >> mysql             | * Manually resetting mysql to stopped state
> >> 18:17:44 root@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 root@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 root@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 root@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