1 |
On Sunday 11 July 2010 20:33:17 Stéphane Guedon wrote: |
2 |
> Le dimanche 11 juillet 2010 20:00:16, Alan McKinnon a écrit : |
3 |
> > On Sunday 11 July 2010 19:58:43 Stéphane Guedon wrote: |
4 |
> > > Le dimanche 11 juillet 2010 19:37:34, walt a écrit : |
5 |
> > > > On 07/11/2010 09:29 AM, Stéphane Guedon wrote: |
6 |
> > > > > Hello |
7 |
> > > > > |
8 |
> > > > > Could someone help me concerning mysql. |
9 |
> > > > > |
10 |
> > > > > My servers (both laptop hosted mysql and server hosted) are buggy. |
11 |
> > > > > Every time I restart them through the init script, it crash ! : |
12 |
> > > > > |
13 |
> > > > > 18:15:06 root@einstein:~ # rc-service mysql restart |
14 |
> > > > > pdns | * Stopping PowerDNS (default) ... |
15 |
> > > > > mediatomb | * Stopping MediaTomb ... |
16 |
> > > > > |
17 |
> > > > > [ ok ] mysql | * Stopping ... |
18 |
> > > > > |
19 |
> > > > > mysql | * Stopping mysqld (0) |
20 |
> > > > > |
21 |
> > > > > [ ok ] mysql | * Starting ... |
22 |
> > > > > |
23 |
> > > > > mysql | * Starting (/etc/mysql/my.cnf) |
24 |
> > > > > mysql | * MySQL NOT started (0) |
25 |
> > > > > |
26 |
> > > > > [ !! ] |
27 |
> > > > |
28 |
> > > > I'm not familiar with running rc-service directly. If you add the |
29 |
> > > > --debug flag like this: |
30 |
> > > > |
31 |
> > > > #/etc/init.d/mysql start --debug |
32 |
> > > > |
33 |
> > > > maybe it will give you better error messages. |
34 |
> > > |
35 |
> > > I have just done three (3) rc-service mysql restart --verbose, and |
36 |
> > > everything goes right, nothing bug... strange ! |
37 |
> > |
38 |
> > Did you notice that according to your logs, mysql did in fact start and |
39 |
> > shut itself done 2 hour 23 minutes later? |
40 |
> |
41 |
> That's really strange, but I have said this log haven't change since days ! |
42 |
> |
43 |
> I think logs are not correctly configured. But according to |
44 |
> /etc/mysql/my.cnf, there's only mysqld.err. |
45 |
> |
46 |
> Should I change something ? |
47 |
|
48 |
|
49 |
I mean to point out that according to your logs, mysql did in fact appear to |
50 |
start. Then it stopped. Ignoring the hour in the timestamps in case it's |
51 |
timezone differences, this means that according to your logs mysql ran for |
52 |
something like 23 minutes. |
53 |
|
54 |
This does not mean it does not start as you claim. |
55 |
It means something is killing it. |
56 |
You need to go find what that is. I can't help you with that, you are the only |
57 |
one in front of your computer. |
58 |
|
59 |
|
60 |
-- |
61 |
alan dot mckinnon at gmail dot com |