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
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)
Release : 10.2
Component : ACTIVATOR VM
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:
long_query_time = 30
After removing the bold line from the file and save the changes, the next time the processd was started, the mysqld process started ok.