Using slurm 15.08.7.(1) Debian package has a compatibility problem with the MySQL 14.14 Distribution 5.6.25 supplied with the same distribution. The supplied version of MySQL no longer supports the 'IGNORE' keyword while using the 'ALTER' statement. This causes issues with 'sacctmgr' and hence 'sview' in that MySQL statements in : src/database/mysql_common.c fail return results. Lines 267 and 268 respectively read: query = xstrdup_printf("alter ignore table %s", table_name); correct_query = xstrdup_printf("alter ignore table %s", table_name); These are the only occurrences of the 'IGNORE' keyword being used in the complete slurm code base. Should the package managers for this linux distribution be altered?
As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error. Please check your version
The code was tested by: Editing and removing the 'ignore' keyword from those SQL statements and recompiling. 'sacctmgr', 'sview', and all other dependent utilities compile fine and function normally with MySQL version 14.14 distribution 5.6.25. The slurm source: src/database/mysql_common.c was edited and compiled from the same code version provided provided with the Debian distribution by creating a working directory and using: /> apt-get source slurm-llnl to retrieve the installed version. The source was configured to install to an alternate path to isolate the generated executables and libraries from those on the system. Execution of problematic utilities proved the following; 1.) slurm was able to connect to the existing MySQL accounting database 2.) MySQL errors reported from utilities have ceased
