Fresh Spectrum 21.2.4 installation fails while running mysql.cus script
search cancel

Fresh Spectrum 21.2.4 installation fails while running mysql.cus script


Article ID: 229354


Updated On:


CA Spectrum DX NetOps


Fresh Spectrum 21.2.4 installation fails while running mysql.cus script.

mysql.log file:


******* Begin Installation of the Distributed Data Manager *******



******* Begin Configuration of mysql ********


Installing e:/win32app/Spectrum/mysql/my.cnf with basedir = e:/win32app/Spectrum/mysql ...

Enabling Slow Query Log...

Enabling InnoDB...

Configuring InnoDB...

InnoDB is configured.

InnoDB has been enabled.

Starting mysql service ...

intializing the database for fresh MySQL installation.

**^G Error during ./bin/mysqld --defaults-file=e:/win32app/Spectrum/mysql/my-spectrum.cnf --initialize-insecure --user=root


ddm.log file:

******* Begin Installation DDM *******


mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to MySQL server on 'localhost' (10061)'

Check that mysqld is running on localhost and that the port is 3306.

You can check this by doing 'telnet localhost 3306'

**^G Error during ./bin/mysqladmin --defaults-file=my-spectrum.cnf -u$spec_user -p$spec_user create ddmdb


Release : 21.2

Component : SpectroSERVER


It looks mysqld is failing in database initialization phase.

If the log is from running mysqld given in spectrum-ss-01.err, then the file system is not allowing the ‘aio write’ operations.

2021-11-29T19:56:20.298396Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.

2021-11-29T19:56:20.302857Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation

2021-11-29T19:56:20.307225Z 0 [ERROR] InnoDB: Cannot continue operation.


The same issue we can see in the below mysql  reference:


Please run the below command from the command line and check all errors it shows.

./bin/mysqld --defaults-file=e:/win32app/Spectrum/mysql/my-spectrum.cnf --initialize-insecure --user=root


Truenas has a driver issue with Qlogic 10g cards. This was causing the iSCSI share < d drive> to periodically lose connectivity.  After adding another drive to the SpectroSERVER via NFS and Spectrum installed just fine, <Slower but fine>.