|
List Info
Thread: mysql start fails / but there are processes after start
|
|
| mysql start fails / but there are
processes after start |
|
2006-07-19 15:44:33 |
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
--
Michael Decker Michael.Decker tesis.de
TESIS SYSware GmbH http://www.tesis.de
Baierbrunnerstr. 15 * 81379 Muenchen * Tel. +49 89 747377-0
--
gentoo-servergentoo.org mailing list
|
|
| mysql start fails / but there are
processes after start |
|
2006-07-19 16:09:32 |
|
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!
Michael Decker wrote:
tesis.de" type="cite">
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
|
| mysql start fails / but there are
processes after start |
|
2006-07-20 06:55:33 |
Hi,
> 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)
> --
Thanks a lot...
That didn't solve my problem...
But uncommenting this line in /etc/mysql/my.conf was the
solution:
--- SNIP ---
skip-innodb
--- SNAP ---
But I don't understand why
Thanks a lot,
Michael Decker
--
Michael Decker Michael.Deckertesis.de
TESIS SYSware GmbH http://www.tesis.de
Baierbrunnerstr. 15 * 81379 Muenchen * Tel. +49 89 747377-0
--
gentoo-servergentoo.org mailing list
|
|
| mysql start fails / but there are
processes after start |
|
2006-09-16 19:29:11 |
Thanks I had the same problem, your solution (skip-innodb)
works
for me too. And I do not understand why too 
Michael Decker wrote:
> Hi,
>
>> 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)
>> --
>
> Thanks a lot...
> That didn't solve my problem...
>
> But uncommenting this line in /etc/mysql/my.conf was
the solution:
> --- SNIP ---
> skip-innodb
> --- SNAP ---
>
> But I don't understand why
>
> Thanks a lot,
> Michael Decker
>
--
gentoo-servergentoo.org mailing list
|
|
| mysql start fails / but there are
processes after start |
|
2006-09-16 19:52:04 |
|
You are missing a setting in your mysql configuration. Since you have compiled in support for InnoDB, you must either completely configure it, or turn it off. If you do not wish/need to use it, then skip-innodb is the correct choice.
If you wish to use InnoDB, you must set a default path for it (even when specifying file per table, which you aren't). The default path is set via the innodb_data_file_path variable, something similar to the following would suffice:
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
For more information on InnoDB, please see the MySQL manual:
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
|
[1-5]
|
|
|
about | contact Other archives ( Real Estate discussion Medical topics )
|