[gentoo-user] strange MySQL issue

[gentoo-user] strange MySQL issue

[Sergey A. Kobzar]

Hi guys,

I have a strange issue - MySQL startup script reports about error
during system startup:

* Starting mysql ...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0)

There is no errors in /var/log/mysql/mysqld.err:

070621 16:10:43 [Warning] No argument was provided to --log-bin, and
--log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
070621 16:10:47  InnoDB: Started; log sequence number 0 43675
070621 16:10:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.42-log'  socket: '/var/run/mysqld/mysqld.sock'  port:
3306  Gentoo Linux mysql-5.0.42

MySQL process exists:

# ps ax | grep mysql
 4208 ?        Ssl    0:00 /usr/sbin/mysqld
 --defaults-file=/etc/mysql/my.cnf --basedir=/usr
 --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
 --socket=/var/run/mysqld/mysqld.sock

# netstat -nlp | grep mysql
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      4208/mysqld
unix  2      [ ACC ]     STREAM     LISTENING     9546   4208/mysqld         /var/run/mysqld/mysqld.sock


Any ideas what it may be? I've checked mysql rc script and found this
message may appears when it can't create mysql socket.

Thanks for any help.


P.S. # uname -rsm
Linux 2.6.20-gentoo-r8 i686

# ls -alh /etc/ | grep make.profile
lrwxrwxrwx  1 root root   48 May  9 13:04 make.profile -> ../usr/portage/profiles/default-linux/x86/2007.0


-- 
Sergey

-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] strange MySQL issue

[Sergey A. Kobzar]

Hi guys,

I have a strange issue - MySQL startup script reports about error
during system startup:

* Starting mysql ...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0)

There is no errors in /var/log/mysql/mysqld.err:

070621 16:10:43 [Warning] No argument was provided to --log-bin, and
--log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
070621 16:10:47  InnoDB: Started; log sequence number 0 43675
070621 16:10:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.42-log'  socket: '/var/run/mysqld/mysqld.sock'  port:
3306  Gentoo Linux mysql-5.0.42

MySQL process exists:

# ps ax | grep mysql
 4208 ?        Ssl    0:00 /usr/sbin/mysqld
 --defaults-file=/etc/mysql/my.cnf --basedir=/usr
 --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
 --socket=/var/run/mysqld/mysqld.sock

# netstat -nlp | grep mysql
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      4208/mysqld
unix  2      [ ACC ]     STREAM     LISTENING     9546   4208/mysqld         /var/run/mysqld/mysqld.sock


Any ideas what it may be? I've checked mysql rc script and found this
message may appears when it can't create mysql socket.

Thanks for any help.


P.S. # uname -rsm
Linux 2.6.20-gentoo-r8 i686

# ls -alh /etc/ | grep make.profile
lrwxrwxrwx  1 root root   48 May  9 13:04 make.profile -> ../usr/portage/profiles/default-linux/x86/2007.0


-- 
Sergey

-- 
gentoo-user@gentoo.org mailing list

Re[2]: [gentoo-user] strange MySQL issue

[Sergey A. Kobzar]

Hi Daevid,

Friday, June 22, 2007, 12:36:05 AM, you wrote:

> Just to verify that you're not insane, I too have seen this many times,
> but like you said, since mySQL is running, I left it alone as there are
> a million other things in Linux to fight with. ;-)

:)

The main problem is MySQL does not finish correctly after such start.
Looks like rc script checks if service was not started and does not
send command to finish it.

> I figured eventually a new ebuild would come out and "fix" itself...

I see this problem more then 2 months. New versions of MySQL were
released, but the problem was not fixed...


> But yeah, I'd love to know if you come up with a solution. 

Hack rc script? Good idea ;) Maybe someone has other (ready) solution?



>> -----Original Message-----
>> From: Sergey A. Kobzar [mailto:serge.kobzar@gmail.com] 
>> Sent: Thursday, June 21, 2007 1:07 PM
>> To: gentoo-user@lists.gentoo.org
>> Subject: [gentoo-user] strange MySQL issue
>> 
>> Hi guys,
>> 
>> I have a strange issue - MySQL startup script reports about error
>> during system startup:
>> 
>> * Starting mysql ...
>> * Starting mysql (/etc/mysql/my.cnf)
>> * MySQL NOT started (0)
>> 
>> There is no errors in /var/log/mysql/mysqld.err:
>> 
>> 070621 16:10:43 [Warning] No argument was provided to --log-bin, and
>> --log-bin-index was not used; so replication may break when this MySQL
>> server acts as a master and has his hostname changed!! Please use
>> '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
>> 070621 16:10:47  InnoDB: Started; log sequence number 0 43675
>> 070621 16:10:50 [Note] /usr/sbin/mysqld: ready for connections.
>> Version: '5.0.42-log'  socket: '/var/run/mysqld/mysqld.sock'  port:
>> 3306  Gentoo Linux mysql-5.0.42
>> 
>> MySQL process exists:
>> 
>> # ps ax | grep mysql
>>  4208 ?        Ssl    0:00 /usr/sbin/mysqld
>>  --defaults-file=/etc/mysql/my.cnf --basedir=/usr
>>  --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid
>>  --socket=/var/run/mysqld/mysqld.sock
>> 
>> # netstat -nlp | grep mysql
>> tcp        0      0 127.0.0.1:3306          0.0.0.0:*         
>>       LISTEN      4208/mysqld
>> unix  2      [ ACC ]     STREAM     LISTENING     9546   
>> 4208/mysqld         /var/run/mysqld/mysqld.sock
>> 
>> 
>> Any ideas what it may be? I've checked mysql rc script and found this
>> message may appears when it can't create mysql socket.
>> 
>> Thanks for any help.
>> 
>> 
>> P.S. # uname -rsm
>> Linux 2.6.20-gentoo-r8 i686
>> 
>> # ls -alh /etc/ | grep make.profile
>> lrwxrwxrwx  1 root root   48 May  9 13:04 make.profile -> 
>> ../usr/portage/profiles/default-linux/x86/2007.0
>> 
>> 
>> -- 
>> Sergey
>> 
>> -- 
>> gentoo-user@gentoo.org mailing list


-- 
Sergey

-- 
gentoo-user@gentoo.org mailing list