1 |
Hi Daevid, |
2 |
|
3 |
Friday, June 22, 2007, 12:36:05 AM, you wrote: |
4 |
|
5 |
> Just to verify that you're not insane, I too have seen this many times, |
6 |
> but like you said, since mySQL is running, I left it alone as there are |
7 |
> a million other things in Linux to fight with. ;-) |
8 |
|
9 |
:) |
10 |
|
11 |
The main problem is MySQL does not finish correctly after such start. |
12 |
Looks like rc script checks if service was not started and does not |
13 |
send command to finish it. |
14 |
|
15 |
> I figured eventually a new ebuild would come out and "fix" itself... |
16 |
|
17 |
I see this problem more then 2 months. New versions of MySQL were |
18 |
released, but the problem was not fixed... |
19 |
|
20 |
|
21 |
> But yeah, I'd love to know if you come up with a solution. |
22 |
|
23 |
Hack rc script? Good idea ;) Maybe someone has other (ready) solution? |
24 |
|
25 |
|
26 |
|
27 |
>> -----Original Message----- |
28 |
>> From: Sergey A. Kobzar [mailto:serge.kobzar@×××××.com] |
29 |
>> Sent: Thursday, June 21, 2007 1:07 PM |
30 |
>> To: gentoo-user@l.g.o |
31 |
>> Subject: [gentoo-user] strange MySQL issue |
32 |
>> |
33 |
>> Hi guys, |
34 |
>> |
35 |
>> I have a strange issue - MySQL startup script reports about error |
36 |
>> during system startup: |
37 |
>> |
38 |
>> * Starting mysql ... |
39 |
>> * Starting mysql (/etc/mysql/my.cnf) |
40 |
>> * MySQL NOT started (0) |
41 |
>> |
42 |
>> There is no errors in /var/log/mysql/mysqld.err: |
43 |
>> |
44 |
>> 070621 16:10:43 [Warning] No argument was provided to --log-bin, and |
45 |
>> --log-bin-index was not used; so replication may break when this MySQL |
46 |
>> server acts as a master and has his hostname changed!! Please use |
47 |
>> '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem. |
48 |
>> 070621 16:10:47 InnoDB: Started; log sequence number 0 43675 |
49 |
>> 070621 16:10:50 [Note] /usr/sbin/mysqld: ready for connections. |
50 |
>> Version: '5.0.42-log' socket: '/var/run/mysqld/mysqld.sock' port: |
51 |
>> 3306 Gentoo Linux mysql-5.0.42 |
52 |
>> |
53 |
>> MySQL process exists: |
54 |
>> |
55 |
>> # ps ax | grep mysql |
56 |
>> 4208 ? Ssl 0:00 /usr/sbin/mysqld |
57 |
>> --defaults-file=/etc/mysql/my.cnf --basedir=/usr |
58 |
>> --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid |
59 |
>> --socket=/var/run/mysqld/mysqld.sock |
60 |
>> |
61 |
>> # netstat -nlp | grep mysql |
62 |
>> tcp 0 0 127.0.0.1:3306 0.0.0.0:* |
63 |
>> LISTEN 4208/mysqld |
64 |
>> unix 2 [ ACC ] STREAM LISTENING 9546 |
65 |
>> 4208/mysqld /var/run/mysqld/mysqld.sock |
66 |
>> |
67 |
>> |
68 |
>> Any ideas what it may be? I've checked mysql rc script and found this |
69 |
>> message may appears when it can't create mysql socket. |
70 |
>> |
71 |
>> Thanks for any help. |
72 |
>> |
73 |
>> |
74 |
>> P.S. # uname -rsm |
75 |
>> Linux 2.6.20-gentoo-r8 i686 |
76 |
>> |
77 |
>> # ls -alh /etc/ | grep make.profile |
78 |
>> lrwxrwxrwx 1 root root 48 May 9 13:04 make.profile -> |
79 |
>> ../usr/portage/profiles/default-linux/x86/2007.0 |
80 |
>> |
81 |
>> |
82 |
>> -- |
83 |
>> Sergey |
84 |
>> |
85 |
>> -- |
86 |
>> gentoo-user@g.o mailing list |
87 |
|
88 |
|
89 |
-- |
90 |
Sergey |
91 |
|
92 |
-- |
93 |
gentoo-user@g.o mailing list |