store | blogs | forums | twitter | facebook | wiki | mailing lists | downloads | support portal
Atomic Secure Linux
It is currently Sat May 25, 2013 9:29 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic Share/Bookmark  [ 3 posts ] 
Author Message
 Post subject: Mysql wont start after update, psmon: Failed to spaw (SOLVED
Unread postPosted: Tue Jul 06, 2010 9:46 am 
Offline
Forum User
Forum User

Joined: Wed Oct 28, 2009 8:42 pm
Posts: 28
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"


Top
 Profile  
 
 Post subject: Re: Mysql wont start after update, psmon: Failed to spaw (SO
Unread postPosted: Tue Jul 06, 2010 11:32 am 
Offline
Forum Regular
Forum Regular

Joined: Mon Apr 10, 2006 12:55 pm
Posts: 656
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

_________________
"Its not a mac. I run linux... I'm actually cool." - scott


Top
 Profile  
 
 Post subject: Re: Mysql wont start after update, psmon: Failed to spaw (SO
Unread postPosted: Wed Jul 07, 2010 2:17 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Sat Aug 20, 2005 9:30 am
Posts: 2812
Location: The Netherlands
bob83 wrote:
[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:
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`


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

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic Share/Bookmark  [ 3 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: Google [Bot], MSN [Bot] and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group