Dear Slurm-Dev Admin, In Ubuntu 16.04LTS, Slurmdbd (v15.08.7) [1] will not run when running mysql-client (v5.7.13) [2] (both packages are from the Ubuntu repo). This is because MySQL v5.7.13 does not support the "IGNORE" clause when it is used with "ALTER" [3], and Slurmdbd attempts to ALTER tables using the "IGNORE" clause.
The error I get from running slurmdbd is in [4]. Installing Slurmdbd v16.05.4 from [5] works fine with MySQL v5.7.13. And I guess installing MySQL < v5.6.4 should work with the Slurmdbd v15.08.7 from the Ubuntu repo. I am not sure if there is any other alternative solution. Regards, Sunil Sandhu [1] http://packages.ubuntu.com/xenial/slurm-llnl-slurmdbd [2] http://packages.ubuntu.com/xenial/mysql-client [3] http://dev.mysql.com/doc/refman/5.7/en/alter-table.html Particularly: "IGNORE is a MySQL extension to standard SQL. It controls how ALTER TABLE <http://dev.mysql.com/doc/refman/5.7/en/alter-table.html> works if there are duplicates on unique keys in the new table or if warnings occur when strict mode is enabled. If IGNORE is not specified, the copy is aborted and rolled back if duplicate-key errors occur. If IGNORE is specified, only one row is used of rows with duplicates on a unique key. The other conflicting rows are deleted. Incorrect values are truncated to the closest matching acceptable value. As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE <http://dev.mysql.com/doc/refman/5.7/en/alter-table.html> is removed and its use produces an error." [4] error: mysql_query failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \ 'ignore table cluster_table modify `creation_time` int unsigned not null, modify ' at line 1 alter ignore table cluster_table modify `creation_time` int unsigned not null, modify `mod_time` int unsigned default 0 not null, modify `deleted` tinyint default 0, modify `name` tinytext not\ null, modify `control_host` tinytext not null default '', modify `control_port` int unsigned not null default 0, modify `last_port` int unsigned not null default 0, modify `rpc_version` small\ int unsigned not null default 0, modify `classification` smallint unsigned default 0, modify `dimensions` smallint unsigned default 1, modify `plugin_id_select` smallint unsigned default 0, mo\ dify `flags` int unsigned default 0, drop primary key, add primary key (name(20)); [5] http://slurm.schedmd.com/download.html
