Fresh Spectrum 21.2.4 installation fails while running mysql.cus script

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

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

Environment

Release : 21.2

Component : SpectroSERVER

Cause

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:

https://bugs.mysql.com/bug.php?id=28913

 

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

Resolution

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>.