1 |
Have you checked in /var/log/mysql/mysqld.log to see what is making the |
2 |
service crash? |
3 |
|
4 |
[ Brandon Adams ] |
5 |
bmadams at gmail dot com |
6 |
|
7 |
|
8 |
On Sun, Jul 11, 2010 at 12:29 PM, Stéphane Guedon <stephane@××××××××××.eu>wrote: |
9 |
|
10 |
> Hello |
11 |
> |
12 |
> Could someone help me concerning mysql. |
13 |
> |
14 |
> My servers (both laptop hosted mysql and server hosted) are buggy. Every |
15 |
> time I restart them through the |
16 |
> init script, it crash ! : |
17 |
> |
18 |
> 18:15:06 root@einstein:~ # rc-service mysql restart |
19 |
> pdns | * Stopping PowerDNS (default) ... |
20 |
> mediatomb | * Stopping MediaTomb ... |
21 |
> [ ok ] |
22 |
> mysql | * Stopping ... |
23 |
> mysql | * Stopping mysqld (0) |
24 |
> [ ok ] |
25 |
> mysql | * Starting ... |
26 |
> mysql | * Starting (/etc/mysql/my.cnf) |
27 |
> mysql | * MySQL NOT started (0) |
28 |
> [ !! ] |
29 |
> mysql | * ERROR: mysql failed to start |
30 |
> 18:15:44 root@einstein:~ # ps -A|grep mys |
31 |
> 2333 ? 00:00:00 mysqld |
32 |
> 18:15:56 root@einstein:~ # killall mysqld |
33 |
> 18:17:37 root@einstein:~ # rc-service mysql zap |
34 |
> mysql | * Manually resetting mysql to stopped state |
35 |
> 18:17:44 root@einstein:~ # rc-service mysql start |
36 |
> mysql | * Starting ... |
37 |
> mysql | * Starting (/etc/mysql/my.cnf) |
38 |
> mysql | * MySQL NOT started (0) |
39 |
> [ !! ] |
40 |
> mysql | * ERROR: mysql failed to start |
41 |
> 18:17:53 root@einstein:~ # ps -A|grep mys |
42 |
> 2628 ? 00:00:00 mysqld |
43 |
> |
44 |
> Of course, it crashs also on boot process, whereas at least two services |
45 |
> (pdns and mediatomb) need it ! |
46 |
> |
47 |
> ========================== |
48 |
> |
49 |
> Here is the end of emerge --info mysql for the server hosted, which is the |
50 |
> most problematic : |
51 |
> |
52 |
> dev-db/mysql-5.1.46 was built with the following: |
53 |
> USE="community debug latin1 (multilib) perl -big-tables -cluster -embedded |
54 |
> -extraengine -max-idx-128 - |
55 |
> minimal -pbxt -profiling (-selinux) -ssl -static -test -xtradb" |
56 |
> CFLAGS="-march=native -O3 -pipe -fomit-frame-pointer |
57 |
> -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing" |
58 |
> CXXFLAGS="-march=native -O3 -pipe -fomit-frame-pointer |
59 |
> -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions - |
60 |
> fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates |
61 |
> -fno-strict-aliasing" |
62 |
> |
63 |
> ========================== |
64 |
> |
65 |
> I think I have read carefully the doc concerning mysql : |
66 |
> http://www.gentoo.org/doc/fr/mysql-howto.xml. |
67 |
> |
68 |
> What can I do ? |
69 |
> |
70 |
> Thanks |
71 |
> |
72 |
> -- |
73 |
> Stéphane Guedon |
74 |
> page web : http://www.22decembre.eu/ |
75 |
> carte de visite : http://www.22decembre.eu/downloads/Stephane-Guedon.vcf |
76 |
> clé publique gpg : http://www.22decembre.eu/downloads/Stephane-Guedon.asc |
77 |
> |