[slurm-users] GrpTRES value changes on upgrade from 17.02.1 to 17.11.2

[Yair Yarom]

Hi,

We have a license, limited using the GrpTRES of an association (this is
a "license/interactive" for https://github.com/irush-cs/slurm-plugins/).

On upgrade to 17.11.2, I've noticed that all our "license/interactive"
GrpTRES where changed to "billing". Judging by the current tres_table
and our pre-upgrade mysql dump, it appears the type/name was changed but
not all (or any of) the associations using it, so they were still using
TRES id 5, i.e. "billing".

I'm not sure there's currently anything to do (I've simply updated all
our associations), but maybe other upgraders should take notice.

BR,
    Yair.

Current sql:
mysql> select * from tres_table;
+---------------+---------+------+----------------+-------------+
| creation_time | deleted | id   | type           | name        |
+---------------+---------+------+----------------+-------------+
|    1452081576 |       0 |    1 | cpu            |             |
|    1452081576 |       0 |    2 | mem            |             |
|    1452081576 |       0 |    3 | energy         |             |
|    1452081576 |       0 |    4 | node           |             |
|    1517148948 |       0 |    5 | billing        |             |
|    1517148948 |       1 | 1000 | dynamic_offset |             |
|    1478703602 |       0 | 1001 | license        | interactive |
|    1481124460 |       0 | 1002 | gres           | gpu         |
+---------------+---------+------+----------------+-------------+
8 rows in set (0.00 sec)

>From the dump:

LOCK TABLES `tres_table` WRITE;
/*!40000 ALTER TABLE `tres_table` DISABLE KEYS */;
INSERT INTO `tres_table` VALUES (1452081576,0,1,'cpu',''),(1452081576,0,2,'mem',''),(1452081576,0,3,'energy',''),(1452081576,0,4,'node',''),(1478703602,0,5,'license','interactive'),(1481124460,0,6,'gres','gpu');
/*!40000 ALTER TABLE `tres_table` ENABLE KEYS */;
UNLOCK TABLES;