Provided by: slurmdbd_23.02.3-2ubuntu1_amd64 bug

NAME

       slurmdbd.conf - Slurm Database Daemon (SlurmDBD) configuration file

DESCRIPTION

       slurmdbd.conf   is  an  ASCII  file  which  describes  Slurm  Database  Daemon  (SlurmDBD)
       configuration information.  The file will always be located in the same directory  as  the
       slurm.conf.

       The contents of the file are case insensitive except for the names of nodes and files. Any
       text following a "#" in the configuration file is treated as a comment through the end  of
       that  line.   Changes  to  the  configuration file take effect upon restart of SlurmDBD or
       daemon receipt of the SIGHUP signal unless otherwise noted.

       This file should be only on the computer  where  SlurmDBD  executes  and  should  only  be
       readable  by  the  user which executes SlurmDBD (e.g. "slurm").  If the slurmdbd daemon is
       started as user root and changes to another user ID, the configuration file will initially
       be  read  as  user  root,  but  will  be read as the other user ID in response to a SIGHUP
       signal.  This file should be protected  from  unauthorized  access  since  it  contains  a
       database password.  The overall configuration parameters available include:

       AllResourcesAbsolute
              When adding a resource (license) treat allocated/allowed counts as absolute numbers
              instead of percentage numbers. Boolean, yes to turn on, no  (default)  to  use  the
              numbers as percentages instead.

       AllowNoDefAcct
              Remove  requirement  for users to have a default account.  Boolean, yes to turn on,
              no (default) to enforce default accounts.

       ArchiveDir
              If ArchiveScript is not set the slurmdbd will generate a file that can be  read  in
              anytime  with  sacctmgr  load  filename.   This directory is where the file will be
              placed after a purge event has happened and archive for  that  element  is  set  to
              true.  Default is /tmp.  The format for this files name is
              $ArchiveDir/$ClusterName_$ArchiveObject_archive_$BeginTimeStamp_$endTimeStamp    We
              limit  archive  files  to  50000 records per file. If more than 50000 records exist
              during that time period, they will be written to a new  file.   Subsequent  archive
              files  during  the same time period will have ".<number>" appended to the file, for
              example .2, with the number increasing by one  for  each  file  in  the  same  time
              period.

       ArchiveEvents
              When  purging  events  also  archive  them.  Boolean, yes to archive event data, no
              otherwise.  Default is no.

       ArchiveJobs
              When purging jobs also  archive  them.   Boolean,  yes  to  archive  job  data,  no
              otherwise.  Default is no.

       ArchiveResvs
              When  purging  reservations also archive them.  Boolean, yes to archive reservation
              data, no otherwise.  Default is no.

       ArchiveScript
              This script can be executed every time  a  rollup  happens  (every  hour,  day  and
              month),  depending  on  the  Purge*After  options.  This script is used to transfer
              accounting records out of the database into an archive.  It is used in place of the
              internal  process  used  to  archive  objects.   The  script  is  executed  with no
              arguments, and the following environment variables are set.

              SLURM_ARCHIVE_EVENTS
                     1 for archive events 0 otherwise.

              SLURM_ARCHIVE_LAST_EVENT
                     Time of last event start to archive.

              SLURM_ARCHIVE_JOBS
                     1 for archive jobs 0 otherwise.

              SLURM_ARCHIVE_LAST_JOB
                     Time of last job submit to archive.

              SLURM_ARCHIVE_STEPS
                     1 for archive steps 0 otherwise.

              SLURM_ARCHIVE_LAST_STEP
                     Time of last step start to archive.

              SLURM_ARCHIVE_SUSPEND
                     1 for archive suspend data 0 otherwise.

              SLURM_ARCHIVE_TXN
                     1 for archive transaction data 0 otherwise.

              SLURM_ARCHIVE_USAGE
                     1 for archive usage data 0 otherwise.

              SLURM_ARCHIVE_LAST_SUSPEND
                     Time of last suspend start to archive.

       ArchiveSteps
              When purging steps also archive them.   Boolean,  yes  to  archive  step  data,  no
              otherwise.  Default is no.

       ArchiveSuspend
              When  purging  suspend data also archive it.  Boolean, yes to archive suspend data,
              no otherwise.  Default is no.

       ArchiveTXN
              When purging transaction data also archive it.  Boolean, yes to archive transaction
              data, no otherwise.  Default is no.

       ArchiveUsage
              When purging usage data (Cluster, Association and WCKey) also archive it.  Boolean,
              yes to archive transaction data, no otherwise.  Default is no.

       AuthInfo
              Additional information to be used for authentication  of  communications  with  the
              Slurm  control  daemon  (slurmctld)  on  each  cluster.  The interpretation of this
              option is specific to the configured AuthType.  In the case of auth/munge, this can
              be   configured   to   use  a  Munge  daemon  specifically  configured  to  provide
              authentication  between  clusters  while  the   default   Munge   daemon   provides
              authentication  within  a cluster.  In that case, this will specify the pathname of
              the socket to use. Per default this value is left unspecified, which results in the
              default authentication mechanism being used.

       AuthAltTypes
              Command separated list of alternative authentication plugins that the slurmdbd will
              permit for communication.

       AuthAltParameters
              Used to define alternative authentication plugins options. Multiple options may  be
              comma separated.

              jwks=  Absolute  path  to  JWKS file. Only RS256 keys are supported, although other
                     key types may be listed in the file. If set, no HS256 key will be loaded  by
                     default (and token generation is disabled), although the jwt_key setting may
                     be used to explicitly re-enable HS256 key use (and token generation).

              jwt_key=
                     Absolute path to JWT key file.  Key  must  be  HS256,  and  should  only  be
                     accessible by SlurmUser.

       AuthType
              Define  the  authentication  method  for  communications  between Slurm components.
              Acceptable  values  at  present  include  "auth/munge",  which  is   the   default.
              "auth/munge"  indicates  that  LLNL's  MUNGE  system  is  to  be  used (this is the
              supported authentication mechanism for  Slurm;  see  "https://dun.github.io/munge/"
              for  more information).  SlurmDBD must be terminated prior to changing the value of
              AuthType and later restarted.

       CommitDelay
              How many seconds between commits on a connection from a Slurmctld.  This speeds  up
              inserts  into the database dramatically.  If you are running a very high throughput
              of jobs you should consider setting  this.   In  testing,  1  second  improves  the
              slurmdbd   performance  dramatically  and  reduces  overhead.   There  is  a  small
              probability of data loss though since  this  creates  a  window  in  which  if  the
              slurmdbd  exits  abnormally  for  any  reason the data not committed could be lost.
              While this situation should be very rare, it does present an extremely small  risk,
              but  may  be  the only way to run in extremely heavy environments.  In all honesty,
              the risk is quite low, but still present.

       CommunicationParameters
              Comma separated options identifying communication options.

              DisableIPv4    Disable IPv4 only operation for the slurmdbd. This  should  also  be
                             set in your slurm.conf file.

              EnableIPv6     Enable  using  IPv6 addresses for the slurmdbd. When using both IPv4
                             and  IPv6,  address  family  preferences  will  be  based  on   your
                             /etc/gai.conf file. This should also be set in your slurm.conf file.

              keepaliveinterval=#
                             Specifies  the  interval  between  keepalive  probes  on  the socket
                             communications between the backup and primary slurmdbd.  The default
                             value is 30 seconds.

              keepaliveprobes=#
                             Specifies  the  number  of  keepalive  probes  sent  on  the  socket
                             communications between the backup and primary slurmdbd.  The default
                             value is 3.

              keepalivetime=#
                             Specifies  how  long to wait before sending keepalive probes between
                             the primary and backup slurmdbd processes.  The default value is  30
                             seconds.

       DbdBackupHost
              The  short,  or long, name of the machine where the backup Slurm Database Daemon is
              executed (i.e. the name returned by the command "hostname  -s").   This  host  must
              have  access  to  the  same  underlying database specified by the 'Storage' options
              mentioned below.

       DbdAddr
              Name that DbdHost should be referred to in establishing a communications path. This
              name  will be used as an argument to the getaddrinfo() function for identification.
              For example, "elx0000" might be used to designate the  Ethernet  address  for  node
              "lx0000".  By default the DbdAddr will be identical in value to DbdHost.

       DbdHost
              The short, or long, name of the machine where the Slurm Database Daemon is executed
              (i.e. the name returned  by  the  command  "hostname  -s").   This  value  must  be
              specified.

       DbdPort
              The  port number that the Slurm Database Daemon (slurmdbd) listens to for work. The
              default value is SLURMDBD_PORT as established at system build time. If no value  is
              explicitly  specified,  it  will  be  set to 6819.  This value must be equal to the
              AccountingStoragePort parameter in the slurm.conf file.

       DebugFlags
              Defines specific subsystems which  should  provide  more  detailed  event  logging.
              Multiple  subsystems  can be specified with comma separators.  Most DebugFlags will
              result  in  verbose  logging  for  the  identified  subsystems  and  could   impact
              performance.  Valid subsystems available today (with more to come) include:

              DB_ARCHIVE
                     SQL statements/queries when dealing with archiving and purging the database.

              DB_ASSOC
                     SQL statements/queries when dealing with associations in the database.

              DB_EVENT
                     SQL statements/queries when dealing with (node) events in the database.

              DB_JOB SQL statements/queries when dealing with jobs in the database.

              DB_QOS SQL statements/queries when dealing with QOS in the database.

              DB_QUERY
                     SQL  statements/queries  when  dealing  with  transactions  and  such in the
                     database.

              DB_RESERVATION
                     SQL statements/queries when dealing with reservations in the database.

              DB_RESOURCE
                     SQL statements/queries when dealing with  resources  like  licenses  in  the
                     database.

              DB_STEP
                     SQL statements/queries when dealing with steps in the database.

              DB_TRES
                     SQL   statements/queries  when  dealing  with  trackable  resources  in  the
                     database.

              DB_USAGE
                     SQL statements/queries when dealing with usage queries and  inserts  in  the
                     database.

              DB_WCKEY
                     SQL statements/queries when dealing with wckeys in the database.

              FEDERATION
                     SQL statements/queries when dealing with federations in the database.

       DebugLevel
              The level of detail to provide the Slurm Database Daemon's logs.  The default value
              is info.

              quiet     Log nothing

              fatal     Log only fatal errors

              error     Log only errors

              info      Log errors and general informational messages

              verbose   Log errors and verbose informational messages

              debug     Log errors and verbose informational messages and debugging messages

              debug2    Log errors and verbose informational messages and more debugging messages

              debug3    Log errors and verbose informational messages  and  even  more  debugging
                        messages

              debug4    Log  errors  and  verbose  informational messages and even more debugging
                        messages

              debug5    Log errors and verbose informational messages  and  even  more  debugging
                        messages

       DebugLevelSyslog
              The  slurmdbd  daemon  will log events to the syslog file at the specified level of
              detail. If not set, the slurmdbd daemon will log to syslog at level  fatal,  unless
              there  is no LogFile and it is running in the background, in which case it will log
              to syslog at the  level  specified  by  DebugLevel  (at  fatal  in  the  case  that
              DebugLevel  is set to quiet) or it is run in the foreground, when it will be set to
              quiet.

              quiet     Log nothing

              fatal     Log only fatal errors

              error     Log only errors

              info      Log errors and general informational messages

              verbose   Log errors and verbose informational messages

              debug     Log errors and verbose informational messages and debugging messages

              debug2    Log errors and verbose informational messages and more debugging messages

              debug3    Log errors and verbose informational messages  and  even  more  debugging
                        messages

              debug4    Log  errors  and  verbose  informational messages and even more debugging
                        messages

              debug5    Log errors and verbose informational messages  and  even  more  debugging
                        messages

              NOTE:  By  default,  Slurm's  systemd service files start daemons in the foreground
              with the -D option. This means that systemd will capture stdout/stderr  output  and
              print  that to syslog, independent of Slurm printing to syslog directly. To prevent
              systemd from doing this, add "StandardOutput=null" and "StandardError=null" to  the
              respective service files or override files.

       DefaultQOS
              When  adding  a  new  cluster  this  will be used as the qos for the cluster unless
              something is explicitly set by the admin with the create.

       LogFile
              Fully qualified pathname of a file into which the Slurm Database Daemon's logs  are
              written.  The default value is none (performs logging via syslog).
              See the section LOGGING in the slurm.conf man page if a pathname is specified.

       LogTimeFormat
              Format  of  the  timestamp  in  slurmdbd  log files. Accepted values are "iso8601",
              "iso8601_ms", "rfc5424", "rfc5424_ms", "rfc3339", "clock", and "short". The  values
              ending  in  "_ms"  differ  from  the  ones  without in that fractional seconds with
              millisecond precision are printed. The default value is "iso8601_ms". The "rfc5424"
              formats  are  the  same  as the "iso8601" formats except that the timezone value is
              also shown. The "clock" format shows a timestamp in microseconds retrieved with the
              C  standard  clock()  function. The "short" format is a short date and time format.
              The "thread_id" format shows the timestamp in the C standard ctime() function  form
              without  the  year  but including the microseconds, the daemon's process ID and the
              current thread ID.

       MaxQueryTimeRange
              Return an error if a query is  against  too  large  of  a  time  span,  to  prevent
              ill-formed  queries  from  causing  performance  problems within SlurmDBD.  Default
              value is INFINITE which allows any queries to proceed.  Accepted time  formats  are
              the same as the MaxTime option in slurm.conf.  Operator and higher privileged users
              are exempt from this restriction.  Note that queries which attempt to  return  over
              3GB of data will still fail to complete with ESLURM_RESULT_TOO_LARGE.

       MessageTimeout
              Time permitted for a round-trip communication to complete in seconds. Default value
              is 10 seconds.

       Parameters
              Contains arbitrary comma separated parameters used to alter  the  behavior  of  the
              slurmdbd.

              PreserveCaseUser
                     When defining users do not force lower case which is the default behavior.

       PidFile
              Fully  qualified  pathname of a file into which the Slurm Database Daemon may write
              its process ID. This may be used for  automated  signal  processing.   The  default
              value is "/var/run/slurmdbd.pid".

       PluginDir
              Identifies   the   places   in  which  to  look  for  Slurm  plugins.   This  is  a
              colon-separated list of directories,  like  the  PATH  environment  variable.   The
              default value is the prefix given at configure time + "/lib/slurm".

       PrivateData
              This  controls  what type of information is hidden from regular users.  By default,
              all information is visible to all users.  User  SlurmUser,  root,  and  users  with
              AdminLevel=Admin can always view all information.  Multiple values may be specified
              with a comma separator.  Acceptable values include:

              accounts
                     prevents  users  from  viewing  any  account  definitions  unless  they  are
                     coordinators of them.

              events prevents  users  from  viewing  event  information unless they have operator
                     status or above.

              jobs   prevents users from viewing job records belonging to other users unless they
                     are coordinators of the account running the job when using sacct.

              reservations
                     restricts  getting reservation information to users with operator status and
                     above.

              usage  prevents users from viewing usage  of  any  other  user.   This  applies  to
                     sreport.

              users  prevents  users  from viewing information of any user other than themselves,
                     this also makes it so users  can  only  see  associations  they  deal  with.
                     Coordinators  can  see  associations  of  all  users in the account they are
                     coordinator of, but can only see themselves when listing users.

       PurgeEventAfter
              Events are purged from the database after this amount of time has passed since they
              ended.  This includes node down times and such.  The time is a numeric value and is
              a number of months.  If you want to purge more often you can  include  "hours",  or
              "days"  behind the numeric value to get those more frequent purges (i.e. a value of
              "12hours" would purge everything older than 12 hours).  The purge  takes  place  at
              the  start of the each purge interval.  For example, if the purge time is 2 months,
              the purge would happen at the beginning of each month.  If not set (default),  then
              event records are never purged.

       PurgeJobAfter
              Individual  job  records are purged from the database after this amount of time has
              passed  since  they  ended.   Aggregated   information   will   be   preserved   to
              "PurgeUsageAfter".   The time is a numeric value and is a number of months.  If you
              want to purge more often you can include "hours",  or  "days"  behind  the  numeric
              value  to  get  those  more  frequent purges (i.e. a value of "12hours" would purge
              everything older than 12 hours).  The purge takes place at the start  of  the  each
              purge interval.  For example, if the purge time is 2 months, the purge would happen
              at the beginning of each month.  If not set (default), then job records  are  never
              purged.

       PurgeResvAfter
              Individual  reservation  records  are purged from the database after this amount of
              time has passed since they ended.  Aggregated  information  will  be  preserved  to
              "PurgeUsageAfter".   The time is a numeric value and is a number of months.  If you
              want to purge more often you can include "hours",  or  "days"  behind  the  numeric
              value  to  get  those  more  frequent purges (i.e. a value of "12hours" would purge
              everything older than 12 hours).  The purge takes place at the start  of  the  each
              purge interval.  For example, if the purge time is 2 months, the purge would happen
              at the beginning of each month.  If not set (default), then reservation records are
              never purged.

       PurgeStepAfter
              Individual  job step records are purged from the database after this amount of time
              has  passed  since  they  ended.   Aggregated  information  will  be  preserved  to
              "PurgeUsageAfter".   The time is a numeric value and is a number of months.  If you
              want to purge more often you can include "hours",  or  "days"  behind  the  numeric
              value  to  get  those  more  frequent purges (i.e. a value of "12hours" would purge
              everything older than 12 hours).  The purge takes place at the start  of  the  each
              purge interval.  For example, if the purge time is 2 months, the purge would happen
              at the beginning of each month.  If not set (default), then job  step  records  are
              never purged.

       PurgeSuspendAfter
              Individual  job  suspend  records are purged from the database after this amount of
              time has passed since they ended.  Aggregated  information  will  be  preserved  to
              "PurgeUsageAfter".   The time is a numeric value and is a number of months.  If you
              want to purge more often you can include "hours",  or  "days"  behind  the  numeric
              value  to  get  those  more  frequent purges (i.e. a value of "12hours" would purge
              everything older than 12 hours).  The purge takes place at the start  of  the  each
              purge interval.  For example, if the purge time is 2 months, the purge would happen
              at the beginning of each month.  If not set (default),  then  suspend  records  are
              never purged.

       PurgeTXNAfter
              Individual  transaction  records  are purged from the database after this amount of
              time has passed since they occurred.  The time is a numeric value and is  a  number
              of  months.   If  you  want  to purge more often you can include "hours", or "days"
              behind the numeric value to get  those  more  frequent  purges  (i.e.  a  value  of
              "12hours"  would  purge  everything older than 12 hours).  The purge takes place at
              the start of the each purge interval.  For example, if the purge time is 2  months,
              the  purge would happen at the beginning of each month.  If not set (default), then
              transaction records are never purged.

       PurgeUsageAfter
              Usage records (Cluster, Association and WCKey) are purged from the  database  after
              this  amount of time has passed since they were created or last modified.  The time
              is a numeric value and is a number of months.  If you want to purge more often  you
              can  include "hours", or "days" behind the numeric value to get those more frequent
              purges (i.e. a value of "12hours" would purge everything older than 12 hours).  The
              purge  takes  place  at  the start of the each purge interval.  For example, if the
              purge time is 2 months, the purge would happen at the beginning of each month.   If
              not set (default), then usage records are never purged.

       SlurmUser
              The  name of the user that the slurmdbd daemon executes as.  This user should match
              the SlurmUser used for all instances of slurmctld that report to slurmdbd. It  must
              exist  on  the machine executing the Slurm Database Daemon and have the same UID as
              the hosts on which slurmctld executes.  For security purposes, a  user  other  than
              "root" is recommended.  The default value is "root".

              NOTE: If the SlurmUser for slurmctld is root you can still use a non-root SlurmUser
              for slurmdbd (in any other  case,  both  SlurmUsers  should  match)  by  explicitly
              setting  the  user's AdminLevel to Admin. After adding a user in this way, you must
              restart slurmctld.

       StorageHost
              Define the name of the host the database is running where we are going to store the
              data.  Ideally this should be the host on which slurmdbd executes.

       StorageBackupHost
              Define  the  name  of the backup host the database is running where we are going to
              store the data.  This can be viewed as a backup solution when  the  StorageHost  is
              not  responding.   It  is up to the backup solution to enforce the coherency of the
              accounting information between the two hosts.  With  clustered  database  solutions
              (active/passive HA), you would not need to use this feature.  Default is none.

       StorageLoc
              Specify  the  name  of  the  database  as the location where accounting records are
              written. Defaults to "slurm_acct_db".

       StorageParameters
              Comma separated list of  key-value  pair  parameters.  Currently  supported  values
              include options to establish a secure connection to the database:

              SSL_CERT
                The path name of the client public key certificate file.

              SSL_CA
                The path name of the Certificate Authority (CA) certificate file.

              SSL_CAPATH
                The path name of the directory that contains trusted SSL CA certificate files.

              SSL_KEY
                The path name of the client private key file.

              SSL_CIPHER
                The list of permissible ciphers for SSL encryption.

       StoragePass
              Define the password used to gain access to the database to store the job accounting
              data. The '#' character is not permitted in a password.

       StoragePort
              The port number that the Slurm Database Daemon  (slurmdbd)  communicates  with  the
              database. Default is 3306.

       StorageType
              Define the accounting storage mechanism type.  Acceptable values at present include
              "accounting_storage/mysql".  The value  "accounting_storage/mysql"  indicates  that
              accounting  records  should  be written to a MySQL or MariaDB database specified by
              the StorageLoc parameter.  This value must be specified.

       StorageUser
              Define the name of the user we are going to connect to the database with  to  store
              the job accounting data.

       TCPTimeout
              Time permitted for TCP connection to be established. Default value is 2 seconds.

       TrackSlurmctldDown
              Boolean yes or no.  If set the slurmdbd will mark all idle resources on the cluster
              as down when a slurmctld disconnects or is no longer reachable.  The default is no.

       TrackWCKey
              Boolean yes or no.  Used to set display and track of the Workload  Characterization
              Key.  Must  be  set  to  track wckey usage.  This must be set to generate rolled up
              usage tables from WCKeys.  NOTE: If TrackWCKey is set here and not in your  various
              slurm.conf files all jobs will be attributed to their default WCKey.

EXAMPLE

       #
       # Sample /etc/slurmdbd.conf
       #
       ArchiveEvents=yes
       ArchiveJobs=yes
       ArchiveResvs=yes
       ArchiveSteps=no
       ArchiveSuspend=no
       ArchiveTXN=no
       ArchiveUsage=no
       #ArchiveScript=/usr/sbin/slurm.dbd.archive
       AuthInfo=/var/run/munge/munge.socket.2
       AuthType=auth/munge
       DbdHost=db_host
       DebugLevel=info
       PurgeEventAfter=1month
       PurgeJobAfter=12month
       PurgeResvAfter=1month
       PurgeStepAfter=1month
       PurgeSuspendAfter=1month
       PurgeTXNAfter=12month
       PurgeUsageAfter=24month
       LogFile=/var/log/slurmdbd.log
       PidFile=/var/run/slurmdbd.pid
       SlurmUser=slurm_mgr
       StoragePass=password_to_database
       StorageType=accounting_storage/mysql
       StorageUser=database_mgr

COPYING

       Copyright  (C)  2008-2010  Lawrence  Livermore  National  Security.   Produced at Lawrence
       Livermore National Laboratory (cf, DISCLAIMER).
       Copyright (C) 2010-2022 SchedMD LLC.

       This  file  is  part  of  Slurm,  a  resource  management  program.   For   details,   see
       <https://slurm.schedmd.com/>.

       Slurm  is  free  software; you can redistribute it and/or modify it under the terms of the
       GNU General Public License as published by the Free Software Foundation; either version  2
       of the License, or (at your option) any later version.

       Slurm is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without
       even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
       GNU General Public License for more details.

FILES

       /etc/slurmdbd.conf

SEE ALSO

       slurm.conf(5), slurmctld(8), slurmdbd(8) syslog (2)