Re: [gentoo-server] mysql start fails / but there are processes after start

[mRyOuNg]

  
  


Hi there,

I had a problem at boot with mysql starts. As you, it fails, but when
the system was booted up, i checked what was wrong about mysql,
everything was up, and running perfecly.
In fact, for me, the problem was related to the nss_ldap update. As
mysqld was started before slapd, it fails for an strange reason. To
correct it, i have added to /etc/init.d/mysql a service dependency with
slapd.

--
after slapd (which ask mysql to start after slapd)
--

And now, everything works nicely.

Hope this will help.

byebye!

 

   body {
        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 12px;
        color: #000000;
        background-color: #FFFFFF;
        text-decoration: none;
   }
  
. mRyOuNg . [ SoundBomb . Syn[Rj] ] .

mail: mryoung@×××××××××.net
web : mryoung.soundbomb.net
 


Michael Decker wrote:

  Hi,

perhaps somebody coul help me by this problem.

I start mysql with "/etc/init.d/mysql start", this failed, but there are
active mysqld processes after this.

The problem is, that this problem starts after a reboot. Before was all
right (I'm installing that machine now) and I had tested with some
daemon restart commands. So I don't understand, what is happend.

	--- SNIP ---
# /etc/init.d/mysql start
 *  ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)

# cat /var/log/mysql/mysqld.err
060719 19:31:20  InnoDB: Started; log sequence number 0 43655
060719 19:31:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.22-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 0
Gentoo Linux mysql-5.0.22
060719 19:34:11 [Note] /usr/sbin/mysqld: Normal shutdown

060719 19:34:11  InnoDB: Starting shutdown...
060719 19:34:19  InnoDB: Shutdown completed; log sequence number 0 43655
060719 19:34:19 [Note] /usr/sbin/mysqld: Shutdown complete

060719 19:34:54  InnoDB: Started; log sequence number 0 43655
060719 19:34:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.22-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 0
Gentoo Linux mysql-5.0.22

# ps -Al | grep mysql
4 S    60 10819     1  0  77   0 - 26428 -      ?        00:00:00 mysqld
1 S    60 10822 10819  0  76   0 - 26428 -      ?        00:00:00 mysqld
1 S    60 10823 10822  0  80   0 - 26428 rt_sig ?        00:00:00 mysqld
1 S    60 10824 10822  0  76   0 - 26428 rt_sig ?        00:00:00 mysqld
1 S    60 10825 10822  0  76   0 - 26428 rt_sig ?        00:00:00 mysqld
1 S    60 10826 10822  0  80   0 - 26428 rt_sig ?        00:00:00 mysqld
1 S    60 10879 10822  0  76   0 - 26428 -      ?        00:00:00 mysqld
1 S    60 10880 10822  0  76   0 - 26428 -      ?        00:00:00 mysqld
1 S    60 10881 10822  0  76   0 - 26428 rt_sig ?        00:00:00 mysqld
1 S    60 10882 10822  0  78   0 - 26428 rt_sig ?        00:00:00 mysqld
1 S    60 10883 10822  0  80   0 - 26428 rt_sig ?        00:00:00 mysqld

# cat /etc/mysql/my.cnf
[client]
port                                            = 3306
socket                  = /var/run/mysqld/mysqld.sock
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
[mysqld_safe]
err-log                     = /var/log/mysql/mysql.err
[mysqld]
character-set-server            = utf8
default-character-set           = utf8
user                                            = mysql
port                                            = 3306
socket                                          =
/var/run/mysqld/mysqld.sock
pid-file                                        = /var/run/mysqld/mysqld.pid
log-error                                       = /var/log/mysql/mysqld.err
basedir                                         = /usr
datadir                                         = /var/lib/mysql
skip-locking
key_buffer                                      = 16M
max_allowed_packet                      = 1M
table_cache                             = 64
sort_buffer_size                        = 512K
net_buffer_length                       = 8K
read_buffer_size                        = 256K
read_rnd_buffer_size            = 512K
myisam_sort_buffer_size         = 8M
language                                        = /usr/share/mysql/english
skip-networking
bind-address                            = 127.0.0.1
set-variable=local-infile=0
log-bin = gentoo-04-bin
server-id                                       = 1
tmpdir                                          = /tmp/
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
set-variable = innodb_log_files_in_group=2
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet                      = 16M
[mysql]
[isamchk]
key_buffer                                      = 20M
sort_buffer_size                        = 20M
read_buffer                             = 2M
write_buffer                            = 2M
[myisamchk]
key_buffer                                      = 20M
sort_buffer_size                        = 20M
read_buffer                             = 2M
write_buffer                            = 2M
[mysqlhotcopy]
interactive-timeout
	--- SNAP ---

Thanks a lot,
	Michael Decker
  



-- 
gentoo-server@g.o mailing list