Mysql wont start after update, psmon: Failed to spaw (SOLVED

[bob83]

Jul 6 15:22:20 vps yum: Updated: glibc-common-2.5-49.el5_5.2.x86_64
Jul 6 15:22:30 vps yum: Updated: glibc-2.5-49.el5_5.2.i686
Jul 6 15:22:35 vps init: Trying to re-exec init
Jul 6 15:22:35 vps init: no more processes left in this runlevel
Jul 6 15:22:41 vps yum: Updated: glibc-2.5-49.el5_5.2.x86_64
Jul 6 15:22:41 vps xinetd[32169]: START: smtp pid=11695 from=203.215.56.202
Jul 6 15:22:49 vps yum: Updated: 4:perl-5.8.8-32.el5_5.1.x86_64
Jul 6 15:22:49 vps xinetd[32169]: START: smtp pid=11731 from=119.93.29.20
Jul 6 15:22:50 vps yum: Updated: 1:cups-libs-1.3.7-18.el5_5.4.x86_64
Jul 6 15:22:50 vps yum: Installed: mysqlclient15-5.0.90-1.el5.art.x86_64
Jul 6 15:22:50 vps xinetd[32169]: EXIT: smtp status=0 pid=11731 duration=1(sec)
Jul 6 15:22:51 vps yum: Updated: mysql-libs-5.1.48-1.el5.art.x86_64
Jul 6 15:22:52 vps xinetd[32169]: START: smtp pid=11739 from=119.93.29.20
Jul 6 15:22:52 vps xinetd[32169]: EXIT: smtp status=0 pid=11739 duration=0(sec)
Jul 6 15:22:54 vps yum: Updated: mysql-5.1.48-1.el5.art.x86_64
Jul 6 15:22:55 vps yum: Updated: libsmbclient-3.0.33-3.29.el5_5.x86_64
Jul 6 15:22:57 vps yum: Updated: samba-common-3.0.33-3.29.el5_5.x86_64
Jul 6 15:23:03 vps yum: Updated: samba-3.0.33-3.29.el5_5.x86_64
Jul 6 15:23:04 vps yum: Updated: sudo-1.7.2p1-7.el5_5.x86_64
Jul 6 15:23:05 vps yum: Updated: mysql-server-5.1.48-1.el5.art.x86_64
Jul 6 15:23:08 vps yum: Updated: nscd-2.5-49.el5_5.2.x86_64
Jul 6 15:23:08 vps yum: Updated: samba-client-3.0.33-3.29.el5_5.x86_64
Jul 6 15:23:13 vps xinetd[32169]: EXIT: smtp status=0 pid=11695 duration=32(sec)
Jul 6 15:23:16 vps yum: Updated: samba-swat-3.0.33-3.29.el5_5.x86_64
Jul 6 15:25:10 vps psmon[3988]: Failed to spawn 'mysqld' with '/sbin/service mysqld restart'

Mysqld.log:
100706 15:41:57 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
100706 15:41:57 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100706 15:41:57 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100706 15:41:57 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
100706 15:41:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100706 15:41:57 InnoDB: Started; log sequence number 0 3509164840
100706 15:41:57 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
100706 15:41:57 [ERROR] Aborting

100706 15:41:57 InnoDB: Starting shutdown...
100706 15:42:03 InnoDB: Shutdown completed; log sequence number 0 3509164840
100706 15:42:03 [Note] /usr/libexec/mysqld: Shutdown complete

100706 15:42:03 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@vps log]#


[root@vps log]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
[root@vps log]#



All helps verry welcome.. any idea to fix this?

UPDATE: Problem solved, solution:

Use my.cnf.rpmnew as my.cnf and mysqld will start OK

This are the optional needed lines for virtuozzo vps:

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

[Highland]

Your problem was the skip-bdb command in my.cnf. I would suggest looking at the wiki page.

http://www.atomicorp.com/wiki/index.php/Mysql

[breun]

[root@vps log]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

You'll need to provide credentials to connect to MySQL and have mysql_upgrade do its work:

Code: Select all

mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

If you haven't run this yet, you'll probably want to do it now.