Comment 3 for bug 2059131

There are lots of instances of this issue. After fixing the one above it breaks in a different place

root@autopkgtest-lxd-bqwqyd:~# slurmdbd -D
slurmdbd: accounting_storage/as_mysql: _check_mysql_concat_is_sane: MySQL server version is: 5.5.5-10.11.7-MariaDB-2ubuntu1
slurmdbd: error: Database settings not recommended values: innodb_buffer_pool_size innodb_lock_wait_timeout
slurmdbd: error: mysql_query failed: 167 Out of range value for column 'id' at row 3
insert into tres_table (creation_time, id, deleted, type) values (1711475131, 0, 0, 'cpu'), (1, -140242792, 0, 'mem'), (1711475131, 0, 0, 'energy'), (2, 0, 0, 'node'), (1711475131, 0, 0, 'billing'), (3, 0, 0, 'vmem'), (1711475131, 0, 0, 'pages'), (4, 0, 1, 'dynamic_offset') on duplicate key update deleted=VALUES(deleted), type=VALUES(type), id=VALUES(id);
slurmdbd: fatal: problem adding static tres