Ticket 9941

Summary:	slurmdbd: Unknown column 'inf' in 'field list'
Product:	Slurm	Reporter:	Nate Rini <nate>
Component:	slurmdbd	Assignee:	Nate Rini <nate>
Status:	RESOLVED INVALID	QA Contact:
Severity:	5 - Enhancement
Priority:	---
Version:	20.11.x
Hardware:	Linux
OS:	Linux
See Also:	https://bugs.schedmd.com/show_bug.cgi?id=9674
Site:	SchedMD	Slinky Site:	---
Alineos Sites:	---	Atos/Eviden Sites:	---
Confidential Site:	---	Coreweave sites:	---
Cray Sites:	---	DS9 clusters:	---
Google sites:	---	HPCnow Sites:	---
HPE Sites:	---	IBM Sites:	---
NOAA SIte:	---	NoveTech Sites:	---
Nvidia HWinf-CS Sites:	---	OCF Sites:	---
Recursion Pharma Sites:	---	SFW Sites:	---
SNIC sites:	---	Tzag Elita Sites:	---
Linux Distro:	---	Machine Name:
CLE Version:		Version Fixed:
Target Release:	---	DevPrio:	---
Emory-Cloud Sites:	---

Description Nate Rini 2020-10-06 15:01:05 MDT

slurmdbd: error: mysql_query failed: 1054 Unknown column 'inf' in 'field list'
insert into qos_table (creation_time, mod_time, name, description, flags, grace_time, grp_jobs, grp_jobs_accrue, grp_submit_jobs, grp_wall, max_jobs_pa, max_jobs_per_user, max_jobs_accrue_pa, max_jobs_accrue_pu, min_prio_thresh, max_submit_jobs_pa, max_submit_jobs_per_user, max_wall_duration_per_job, preempt_exempt_time, preempt_mode, priority, usage_factor, usage_thres) values (1602018004, 1602018004, 'normal-2', 'Normal QOS default', '0', 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 1.000000, inf) on duplicate key update deleted=0, id=LAST_INSERT_ID(id), mod_time=1602018004, description='Normal QOS default', flags=0, grace_time=0, grp_jobs=NULL, grp_jobs_accrue=NULL, grp_submit_jobs=0, grp_wall=NULL, max_jobs_pa=NULL, max_jobs_per_user=NULL, max_jobs_accrue_pa=NULL, max_jobs_accrue_pu=NULL, min_prio_thresh=NULL, max_submit_jobs_pa=0, max_submit_jobs_per_user=0, max_wall_duration_per_job=NULL, preempt_exempt_time=NULL, preempt_mode=0, priority=0, usage_factor=1.000000, usage_thres=inf;