[slurm-dev] GID and UID restriction in SLURM DBD

[Robert LeBlanc]

We ran into a problem where our UIDs and GIDs were too big for slurm dbd. Luckily it was a matter of changing the field types in job_table to INT rather than SMALLINT. Can this be fixed for future releases?

Thanks,

Robert LeBlanc
Life Sciences & Undergraduate Education Computer Support
Brigham Young University

[Danny Auble]

Hey Robert, this was actually fixed just last week. Here is a complete patch, it is probably very similar to what you already did. This will be in 2.0.8+.

Danny

Index: src/plugins/accounting_storage/mysql/accounting_storage_mysql.c
===================================================================
--- src/plugins/accounting_storage/mysql/accounting_storage_mysql.c (revision 18920)
+++ src/plugins/accounting_storage/mysql/accounting_storage_mysql.c (working copy)
@@ -2938,8 +2938,8 @@
{ "associd", "int unsigned not null" },
{ "wckey", "tinytext not null default ''" },
{ "wckeyid", "int unsigned not null" },
- { "uid", "smallint unsigned not null" },
- { "gid", "smallint unsigned not null" },
+ { "uid", "int unsigned not null" },
+ { "gid", "int unsigned not null" },
{ "cluster", "tinytext not null" },
{ "partition", "tinytext not null" },
{ "blockid", "tinytext" },
@@ -2960,7 +2960,7 @@
{ "alloc_nodes", "int unsigned not null" },
{ "nodelist", "text" },
{ "node_inx", "text" },
- { "kill_requid", "smallint default -1 not null" },
+ { "kill_requid", "int default -1 not null" },
{ "qos", "smallint default 0" },
{ "resvid", "int unsigned not null" },
{ NULL, NULL}
@@ -3026,7 +3026,7 @@
{ "nodelist", "text not null" },
{ "node_inx", "text" },
{ "state", "smallint not null" },
- { "kill_requid", "smallint default -1 not null" },
+ { "kill_requid", "int default -1 not null" },
{ "comp_code", "int default 0 not null" },
{ "nodes", "int unsigned not null" },
{ "cpus", "int unsigned not null" },

[Robert LeBlanc]

Thanks, we didn't get all the places, so thanks for the patch.

Robert LeBlanc
Life Sciences & Undergraduate Education Computer Support
Brigham Young University