Spectrum OneClick mysql server cannot be restarted

Products

• CA Spectrum
• DX NetOps

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 = 30
SELECT 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.