Fresh Spectrum 21.2.4 installation fails while running mysql.cus script.
******* 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...
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
******* 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>.