Spectrum OneClick mysql server cannot be restarted
book
Article ID: 145337
calendar_today
Updated On:
Products
CA Spectrum
DX NetOps
Show More
Show Less
Issue/Introduction
mysql server on oneclick server is not starting up
$ service processd start
Starting SPECTRUM Process daemon.
starting "SPECTRUM Process Daemon" daemon: pid 8803
$ ps -eaf | grep mysqld
root 9108 8651 0 17:27 pts/0 00:00:00 grep --color=auto mysqld
$ ps -eaf | grep mysql
root 9120 8651 0 17:27 pts/0 00:00:00 grep --color=auto mysqld
Environment
Release : 10.2
Component : ACTIVATOR VM
Cause
To analyze why the mysql process do not start on a linux box, you need to review the $SPECROOT/mysql/bin/MYSQL.OUT file Next is an extract of a MYSQL.OUT where the mysqld process do not start:200214 2:00:28 InnoDB: 5.5.57 started; log sequence number 1595685 200214 2:00:28 [ERROR] /opt/ca/spectrum/mysql/bin//mysqld: unknown option '--SELECT SLEEP(31)' 200214 2:00:28 [ERROR] Aborting 200214 2:00:28 InnoDB: Starting shutdown... 200214 2:00:29 InnoDB: Shutdown completed; log sequence number 1595685 200214 2:00:29 [Note] /opt/ca/spectrum/mysql/bin//mysqld: Shutdown complete As per the bold line, the problem seems to be an unknown option --SELECT SLEEP(31)
Resolution
For this particular case, as the problem seems to be caused by an option, the next step is to review the $SPECROOT/mysql/my-spectrum.cnf file, because in there, is where the mysql options are defined. The content of this file showed that particular problematic option was added: ... log-slow-queries long_query_time = 30SELECT SLEEP(31) default-storage-engine=MyISAM ... After removing the bold line from the file and save the changes, the next time the processd was started, the mysqld process started ok.
Feedback
thumb_up
Yes
thumb_down
No