[gentoo-server] mysql

[gentoo-server] mysql

[Stéphane Guedon]

[-- Attachment #1: Type: Text/Plain, Size: 2604 bytes --]

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

-- 
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

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-server] mysql

[Brandon Adams]

[-- Attachment #1: Type: text/plain, Size: 2700 bytes --]

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 <stephane@22decembre.eu>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
>
> --
> 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
>

[-- Attachment #2: Type: text/html, Size: 3527 bytes --]

Re: [gentoo-server] mysql

[Bishop Bettini]

If the mysql log (per Brandon's suggestion) doesn't show anything  
useful, you can always try strace on the mysqld executable directly.   
Something along the lines of:

sudo -i

# stop mysql clean, figure out how your system starts it up
/etc/init.d/mysql stop
mysql_flags=$(/etc/init.d/mysql --debug start 2>&1 | grep 'starting  
mysqld with' | cut -f 2- -d:)
/etc/init.d/mysql stop

# manually run mysql, through strace to see what's going on
emerge -av strace
strace /usr/sbin/mysqld $mysql_flags 2>&1 | tee /tmp/strace.mysql.out

exit


Then the log file /tmp/strace.mysql.out might show a SEGV or some  
other bad bad problem.

bishop

-- 
Bishop Bettini
ideacode, Inc.
(main) +1 919 341 5170 / (fax) +1 919 521 4100

CELEBRATING 10 YEARS OF GREAT SOFTWARE!