Release : 21.2.8
Component : SPCINS - SPECTRUM INSTALLATION
Rerunning the install causes this error. Renaming the myspectrumlogin.cnf in /Spectrum/mysql/data before running the install again, does not fix the problem and we get the same error and failed install.
the problem happens when we reinstall so if this is a virtual machine and a pre-upgrade snapshot prior is available, you can restore to the previous versions and install again.
If no snapshot is available, the following resolution needs to be done after the first un successful install before attempting to reinstall.
1. Install the spectrum 21.2.8 latest build
2. Connect to mysql using root user
$SPECROOT/mysql/bin/mysql --defaults-file=$SPECROOT/mysql/my-spectrum.cnf -uroot -pMySqlR00t
3. Update the "root" File_priv.
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' , File_priv='Y' WHERE User='root';
4. Verify the "root" user File_priv update to "Y" or not
select user, Host, File_priv from mysql.user;
5. Re install the spectrum.
This has been scheduled to be fixed in the 21.2.10 release.