Gentoo Archives: gentoo-user

From: "Sergey A. Kobzar" <serge.kobzar@×××××.com>
To: Daevid Vincent <daevid@××××××.com>
Cc: gentoo-user@l.g.o
Subject: Re[2]: [gentoo-user] strange MySQL issue
Date: Fri, 22 Jun 2007 07:06:51
Message-Id: 523205683.20070622095629@gmail.com
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