Provided by: ovn-common_22.03.3-0ubuntu0.22.04.5_amd64 bug

NAME

       ovn-sbctl - Open Virtual Network southbound db management utility

SYNOPSIS

       ovn-sbctl [options] command [arg...]

DESCRIPTION

       The  ovn-sbctl  program configures the OVN_Southbound database by providing a high-level interface to its
       configuration database. See ovn-sb(5) for comprehensive documentation of the database schema.

       ovn-sbctl connects to an ovsdb-server process that maintains an  OVN_Southbound  configuration  database.
       Using this connection, it queries and possibly applies changes to the database, depending on the supplied
       commands.

       ovn-sbctl  can perform any number of commands in a single run, implemented as a single atomic transaction
       against the database.

       The ovn-sbctl command line begins with global options (see OPTIONS below for details). The global options
       are followed by one or more commands. Each command should begin with  --  by  itself  as  a  command-line
       argument,  to separate it from the following commands. (The -- before the first command is optional.) The
       command itself starts with command-specific options, if  any,  followed  by  the  command  name  and  any
       arguments.

DAEMON MODE

       When  it  is  invoked  in  the  most  ordinary  way, ovn-sbctl connects to an OVSDB server that hosts the
       southbound database, retrieves a partial copy of the database that is complete enough  to  do  its  work,
       sends  a  transaction  request  to  the  server, and receives and processes the server’s reply. In common
       interactive use, this is fine, but if the database is large, the step  in  which  ovn-sbctl  retrieves  a
       partial copy of the database can take a long time, which yields poor performance overall.

       To  improve  performance in such a case, ovn-sbctl offers a "daemon mode," in which the user first starts
       ovn-sbctl running in the background and afterward uses the daemon to  execute  operations.  Over  several
       ovn-sbctl  command  invocations, this performs better overall because it retrieves a copy of the database
       only once at the beginning, not once per program run.

       Use the --detach option to start an ovn-sbctl daemon. With this option, ovn-sbctl prints the  name  of  a
       control  socket  to stdout. The client should save this name in environment variable OVN_SB_DAEMON. Under
       the Bourne shell this might be done like this:

             export OVN_SB_DAEMON=$(ovn-sbctl --pidfile --detach)

       When OVN_SB_DAEMON is set, ovn-sbctl automatically and transparently  uses  the  daemon  to  execute  its
       commands.

       When the daemon is no longer needed, kill it and unset the environment variable, e.g.:

             kill $(cat $OVN_RUNDIR/ovn-sbctl.pid)
             unset OVN_SB_DAEMON

       When using daemon mode, an alternative to the OVN_SB_DAEMON environment variable is to specify a path for
       the  Unix  socket.  When  starting  the  ovn-sbctl  daemon, specify the -u option with a full path to the
       location of the socket file. Here is an exmple:

             ovn-sbctl --detach -u /tmp/mysock.ctl

       Then to connect to the running daemon, use the -u option with the full path to the  socket  created  when
       the daemon was started:

             ovn-sbctl -u /tmp/mysock.ctl show

     Daemon Commands

       Daemon  mode  is  internally  implemented  using  the same mechanism used by ovn-appctl. One may also use
       ovn-appctl directly with the following commands:

              run [options] command [arg...] [-- [options] command [arg...] ...]
                     Instructs the daemon process to run one or more  ovn-sbctl  commands  described  above  and
                     reply with the results of running these commands. Accepts the --no-wait, --wait, --timeout,
                     --dry-run,  --oneline, and the options described under Table Formatting Options in addition
                     to the the command-specific options.

              exit   Causes ovn-sbctl to gracefully terminate.

OPTIONS

       The options listed below affect the behavior of ovn-sbctl as  a  whole.  Some  individual  commands  also
       accept  their  own  options,  which  are  given just before the command name. If the first command on the
       command line has options, then those options must be separated from the global options by --.

       ovn-sbctl also accepts options from the OVN_SBCTL_OPTIONS environment variable, in the same format as  on
       the command line. Options from the command line override those in the environment.

              --db database
                     The  OVSDB  database  remote  to contact. If the OVN_SB_DB environment variable is set, its
                     value is used as the default. Otherwise,  the  default  is  unix:/ovnsb_db.sock,  but  this
                     default is unlikely to be useful outside of single-machine OVN test environments.

              --leader-only
              --no-leader-only
                   By  default,  or  with  --leader-only,  when  the  database  server  is a clustered database,
                   ovn-sbctl will avoid servers other than the cluster leader. This ensures that any  data  that
                   ovn-sbctl  reads  and  reports  is  up-to-date. With --no-leader-only, ovn-sbctl will use any
                   server in the cluster, which means that for read-only transactions it can report and  act  on
                   stale   data  (transactions  that  modify  the  database  are  always  serialized  even  with
                   --no-leader-only).  Refer  to  Understanding  Cluster  Consistency  in  ovsdb(7)   for   more
                   information.

              --shuffle-remotes
              --no-shuffle-remotes
                   By default, or with --shuffle-remotes, when there are multiple remotes specified in the OVSDB
                   connection  string  specified by --db or the OVN_SB_DB environment variable, the order of the
                   remotes will be shuffled before the client tries to connect. The  remotes  will  be  shuffled
                   only  once to a new order before the first connection attempt. The following retries, if any,
                   will follow the same new order. The default behavior is to make sure clients of  a  clustered
                   database  can  distribute  evenly to all memembers of the cluster. With --no-shuffle-remotes,
                   ovn-sbctl will use the original order specified in the connection  string  to  connect.  This
                   allows user to specify the preferred order, which is particularly useful for testing.

              --no-syslog
                   By  default, ovn-sbctl logs its arguments and the details of any changes that it makes to the
                   system log. This option disables this logging.

                   This option is equivalent to --verbose=sbctl:syslog:warn.

              --oneline
                   Modifies the output format so that the output for each command is printed on a  single  line.
                   New-line  characters  that  would  otherwise separate lines are printed as \fB\\n\fR, and any
                   instances of \fB\\\fR that would otherwise appear in the output are doubled. Prints  a  blank
                   line  for  each  command  that  has  no output. This option does not affect the formatting of
                   output from the list or find commands; see Table Formatting Options below.

              --dry-run
                   Prevents ovn-sbctl from actually modifying the database.

              -t secs
              --timeout=secs
                   By default, or with a secs of 0, ovn-sbctl waits forever for a response  from  the  database.
                   This  option  limits runtime to approximately secs seconds. If the timeout expires, ovn-sbctl
                   will exit with a SIGALRM signal. (A timeout would normally happen only if the database cannot
                   be contacted, or if the system is overloaded.)

   Daemon Options
       --pidfile[=pidfile]
              Causes a file (by default, program.pid) to be created indicating the PID of the  running  process.
              If the pidfile argument is not specified, or if it does not begin with /, then it is created in .

              If --pidfile is not specified, no pidfile is created.

       --overwrite-pidfile
              By  default, when --pidfile is specified and the specified pidfile already exists and is locked by
              a running process, the daemon refuses to start. Specify --overwrite-pidfile to cause it to instead
              overwrite the pidfile.

              When --pidfile is not specified, this option has no effect.

       --detach
              Runs this program as a background process. The process forks, and in the child  it  starts  a  new
              session,  closes  the standard file descriptors (which has the side effect of disabling logging to
              the console), and changes its current directory to the  root  (unless  --no-chdir  is  specified).
              After the child completes its initialization, the parent exits.

       --monitor
              Creates an additional process to monitor this program. If it dies due to a signal that indicates a
              programming  error  (SIGABRT,  SIGALRM,  SIGBUS,  SIGFPE,  SIGILL,  SIGPIPE,  SIGSEGV, SIGXCPU, or
              SIGXFSZ) then the monitor process starts a new copy of it. If the daemon dies or exits for another
              reason, the monitor process exits.

              This option is normally used with --detach, but it also functions without it.

       --no-chdir
              By default, when --detach is specified, the daemon changes its current working  directory  to  the
              root  directory  after  it  detaches.  Otherwise,  invoking  the  daemon  from a carelessly chosen
              directory would prevent the  administrator  from  unmounting  the  file  system  that  holds  that
              directory.

              Specifying  --no-chdir  suppresses  this behavior, preventing the daemon from changing its current
              working directory. This may be useful for collecting core files, since it is  common  behavior  to
              write core dumps into the current working directory and the root directory is not a good directory
              to use.

              This option has no effect when --detach is not specified.

       --no-self-confinement
              By  default  this  daemon  will  try  to  self-confine  itself to work with files under well-known
              directories determined at build time. It is better to stick with this default behavior and not  to
              use this flag unless some other Access Control is used to confine daemon. Note that in contrast to
              other  access  control  implementations that are typically enforced from kernel-space (e.g. DAC or
              MAC), self-confinement is imposed from the user-space  daemon  itself  and  hence  should  not  be
              considered  as a full confinement strategy, but instead should be viewed as an additional layer of
              security.

       --user=user:group
              Causes this program to run as a different user specified in user:group, thus dropping most of  the
              root privileges. Short forms user and :group are also allowed, with current user or group assumed,
              respectively. Only daemons started by the root user accepts this argument.

              On  Linux,  daemons  will  be  granted CAP_IPC_LOCK and CAP_NET_BIND_SERVICES before dropping root
              privileges. Daemons that interact with a datapath, such as ovs-vswitchd,  will  be  granted  three
              additional  capabilities,  namely CAP_NET_ADMIN, CAP_NET_BROADCAST and CAP_NET_RAW. The capability
              change will apply even if the new user is root.

              On Windows, this option is not currently supported. For security reasons, specifying  this  option
              will cause the daemon process not to start.

   Logging options
       -v[spec]
       --verbose=[spec]
            Sets  logging  levels. Without any spec, sets the log level for every module and destination to dbg.
            Otherwise, spec is a list of words separated by spaces or commas or colons,  up  to  one  from  each
            category below:

            •      A  valid  module name, as displayed by the vlog/list command on ovs-appctl(8), limits the log
                   level change to the specified module.

            •      syslog, console, or file, to limit the log level change to only to the  system  log,  to  the
                   console,  or  to  a  file,  respectively.  (If  --detach  is specified, the daemon closes its
                   standard file descriptors, so logging to the console will have no effect.)

                   On Windows platform, syslog is accepted  as  a  word  and  is  only  useful  along  with  the
                   --syslog-target option (the word has no effect otherwise).

            •      off,  emer, err, warn, info, or dbg, to control the log level. Messages of the given severity
                   or higher will be logged, and messages of lower severity will be filtered  out.  off  filters
                   out all messages. See ovs-appctl(8) for a definition of each log level.

            Case is not significant within spec.

            Regardless  of  the log levels set for file, logging to a file will not take place unless --log-file
            is also specified (see below).

            For compatibility with older versions of OVS, any is accepted as a word but has no effect.

       -v
       --verbose
            Sets the maximum logging verbosity level, equivalent to --verbose=dbg.

       -vPATTERN:destination:pattern
       --verbose=PATTERN:destination:pattern
            Sets the log pattern for destination to pattern. Refer to ovs-appctl(8) for  a  description  of  the
            valid syntax for pattern.

       -vFACILITY:facility
       --verbose=FACILITY:facility
            Sets the RFC5424 facility of the log message. facility can be one of kern, user, mail, daemon, auth,
            syslog,  lpr,  news,  uucp,  clock,  ftp, ntp, audit, alert, clock2, local0, local1, local2, local3,
            local4, local5, local6 or local7. If this option is not specified, daemon is used as the default for
            the local system syslog and local0 is used while sending a message to the target  provided  via  the
            --syslog-target option.

       --log-file[=file]
            Enables logging to a file. If file is specified, then it is used as the exact name for the log file.
            The default log file name used if file is omitted is /var/log/ovn/program.log.

       --syslog-target=host:port
            Send  syslog  messages  to  UDP  port  on host, in addition to the system syslog. The host must be a
            numerical IP address, not a hostname.

       --syslog-method=method
            Specify method as how syslog messages should be sent to  syslog  daemon.  The  following  forms  are
            supported:

            •      libc,  to  use  the  libc syslog() function. Downside of using this options is that libc adds
                   fixed prefix to every message before it is actually sent to the syslog daemon  over  /dev/log
                   UNIX domain socket.

            •      unix:file,  to use a UNIX domain socket directly. It is possible to specify arbitrary message
                   format with this option. However, rsyslogd 8.9 and  older  versions  use  hard  coded  parser
                   function  anyway  that  limits  UNIX  domain socket use. If you want to use arbitrary message
                   format with older rsyslogd versions, then use UDP socket to localhost IP address instead.

            •      udp:ip:port, to use a UDP socket. With this method it is possible to  use  arbitrary  message
                   format  also  with  older  rsyslogd.  When  sending  syslog  messages  over  UDP socket extra
                   precaution needs to be taken into account, for example, syslog daemon needs to be  configured
                   to  listen  on  the  specified  UDP port, accidental iptables rules could be interfering with
                   local syslog traffic and there are some security considerations that apply  to  UDP  sockets,
                   but do not apply to UNIX domain sockets.

            •      null, to discard all messages logged to syslog.

            The default is taken from the OVS_SYSLOG_METHOD environment variable; if it is unset, the default is
            libc.

   Table Formatting Options
       These options control the format of output from the list and find commands.

              -f format
              --format=format
                   Sets the type of table formatting. The following types of format are available:

                   table  2-D text tables with aligned columns.

                   list (default)
                          A list with one column per line and rows separated by a blank line.

                   html   HTML tables.

                   csv    Comma-separated values as defined in RFC 4180.

                   json   JSON  format as defined in RFC 4627. The output is a sequence of JSON objects, each of
                          which corresponds to one table. Each JSON object has the following  members  with  the
                          noted values:

                          caption
                                 The table’s caption. This member is omitted if the table has no caption.

                          headings
                                 An  array  with  one  element  per table column. Each array element is a string
                                 giving the corresponding column’s heading.

                          data   An array with one element per table row. Each element is also an array with one
                                 element per table column. The elements of this second-level array are the cells
                                 that constitute the table. Cells that represent OVSDB data or  data  types  are
                                 expressed  in  the format described in the OVSDB specification; other cells are
                                 simply expressed as text strings.

              -d format
              --data=format
                   Sets the formatting for cells within output tables unless the table format is set to json, in
                   which case json formatting is always used when  formatting  cells.  The  following  types  of
                   format are available:

                   string (default)
                          The simple format described in the Database Values section of ovs-vsctl(8).

                   bare   The  simple  format  with punctuation stripped off: [] and {} are omitted around sets,
                          maps, and empty columns, items within sets and maps are space-separated,  and  strings
                          are never quoted. This format may be easier for scripts to parse.

                   json   The RFC 4627 JSON format as described above.

              --no-headings
                   This  option  suppresses  the  heading  row  that otherwise appears in the first row of table
                   output.

              --pretty
                   By default, JSON in output is printed as compactly as possible. This option  causes  JSON  in
                   output  to  be  printed in a more readable fashion. Members of objects and elements of arrays
                   are printed one per line, with indentation.

                   This option does not affect JSON in tables, which is always printed compactly.

              --bare
                   Equivalent to --format=list --data=bare --no-headings.

   PKI Options
       PKI configuration is required to use SSL for the connection to the database.

              -p privkey.pem
              --private-key=privkey.pem
                   Specifies a  PEM  file  containing  the  private  key  used  as  identity  for  outgoing  SSL
                   connections.

              -c cert.pem
              --certificate=cert.pem
                   Specifies  a PEM file containing a certificate that certifies the private key specified on -p
                   or --private-key to be trustworthy.  The  certificate  must  be  signed  by  the  certificate
                   authority (CA) that the peer in SSL connections will use to verify it.

              -C cacert.pem
              --ca-cert=cacert.pem
                   Specifies  a  PEM  file containing the CA certificate for verifying certificates presented to
                   this program by SSL peers. (This may be the same certificate that SSL peers use to verify the
                   certificate specified on -c or --certificate, or it may be a different one, depending on  the
                   PKI design in use.)

              -C none
              --ca-cert=none
                   Disables  verification  of  certificates  presented  by SSL peers. This introduces a security
                   risk, because it means that certificates cannot be verified to  be  those  of  known  trusted
                   hosts.

              --bootstrap-ca-cert=cacert.pem
                     When  cacert.pem exists, this option has the same effect as -C or --ca-cert. If it does not
                     exist, then the executable will attempt to obtain the CA certificate from the SSL  peer  on
                     its  first  SSL  connection and save it to the named PEM file. If it is successful, it will
                     immediately drop the connection and reconnect, and from then on all SSL connections must be
                     authenticated by a certificate signed by the CA certificate thus obtained.

                     This option exposes the SSL connection to a man-in-the-middle attack obtaining the  initial
                     CA certificate, but it may be useful for bootstrapping.

                     This  option  is  only  useful  if the SSL peer sends its CA certificate as part of the SSL
                     certificate chain. The SSL protocol does not require the server to send the CA certificate.

                     This option is mutually exclusive with -C and --ca-cert.

   Other Options
       -h
       --help
            Prints a brief help message to the console.

       -V
       --version
            Prints version information to the console.

COMMANDS

       The following sections describe the commands that ovn-sbctl supports.

   OVN_Southbound Commands
       These commands work with an OVN_Southbound database as a whole.

              init   Initializes the database, if it is empty. If the database  has  already  been  initialized,
                     this command has no effect.

              show   Prints a brief overview of the database contents.

   Chassis Commands
       These commands manipulate OVN_Southbound chassis.

              [--may-exist] chassis-add chassis encap-type encap-ip
                     Creates  a new chassis named chassis. encap-type is a comma-separated list of tunnel types.
                     The chassis will have one encap entry for each specified tunnel type with encap-ip  as  the
                     destination IP for each.

                     Without  --may-exist,  attempting  to  create  a  chassis  that  exists  is  an error. With
                     --may-exist, this command does nothing if chassis already exists.

              [--if-exists] chassis-del chassis
                     Deletes chassis and its encaps and gateway_ports.

                     Without --if-exists, attempting to delete a chassis that does not exist is an  error.  With
                     --if-exists attempting to delete a chassis that does not exist has no effect.

   Port Binding Commands
       These commands manipulate OVN_Southbound port bindings.

              [--may-exist] lsp-bind logical-port chassis
                     Binds the logical port named logical-port to chassis.

                     Without  --may-exist,  attempting  to bind a logical port that has already been bound is an
                     error. With --may-exist, this command does nothing if logical-port has already  been  bound
                     to a chassis.

              [--if-exists] lsp-unbind logical-port
                     Removes the binding of logical-port.

                     Without  --if-exists,  attempting  to  unbind a logical port that is not bound is an error.
                     With --if-exists, attempting to unbind logical port that is not bound has no effect.

   Logical Flow Commands
       [--uuid] [--ovs[=remote]] [--stats] [--vflows] lflow-list [logical-datapath] [lflow...]
              List logical flows. If logical-datapath is specified, only list flows for that  logical  datapath.
              The  logical-datapath may be given as a UUID or as a datapath name (reporting an error if multiple
              datapaths have the same name).

              If at least one lflow is given, only matching logical flows, if any, are listed. Each lflow may be
              specified as a UUID or the first few characters of a UUID, optionally  prefixed  by  0x.  (Because
              ovn-controller sets OpenFlow flow cookies to the first 32 bits of the corresponding logical flow’s
              UUID, this makes it easy to look up the logical flow that generated a particular OpenFlow flow.)

              If  --uuid  is  specified, the output includes the first 32 bits of each logical flow’s UUID. This
              makes it easier to find the OpenFlow flows that correspond to a given logical flow.

              If --ovs is included, ovn-sbctl attempts to obtain and display the OpenFlow flows that  correspond
              to  each  OVN logical flow. To do so, ovn-sbctl connects to remote (by default, unix:/br-int.mgmt)
              over OpenFlow and retrieves the flows. If remote is specified,  it  must  be  an  active  OpenFlow
              connection  method described in ovsdb(7). Please see the discussion of the similar --ovs option in
              ovn-trace(8) for more information about the OpenFlow flow output.

              By default, OpenFlow flow output includes only match and  actions.  Add  --stats  to  include  all
              OpenFlow information, such as packet and byte counters, duration, and timeouts.

              If  --vflows  is included, other southbound database records directly used for generating OpenFlow
              flows are also listed. This includes: port-bindings, mac-bindings, multicast-groups, chassis.  The
              --ovs and --stats can also be used in conjunction with --vflows.

       [--uuid] dump-flows [logical-datapath]
              Alias for lflow-list.

       count-flows [logical-datapath]
              prints numbers of logical flows per table and per datapath.

   Remote Connectivity Commands
       These commands manipulate the connections column in the SB_Global table and rows in the Connection table.
       When  ovsdb-server  is  configured  to  use the connections column for OVSDB connections, this allows the
       administrator to use \fBovn\-sbctl\fR to configure database connections.

              get-connection
                     Prints the configured connection(s).

              del-connection
                     Deletes the configured connection(s).

              [--inactivity-probe=msecs] set-connection target...
                     Sets the configured manager target or targets. Use --inactivity-probe=msecs to override the
                     default idle connection inactivity probe time. Use 0 to disable inactivity probes.

   SSL Configuration Commands
       When ovsdb-server is configured to connect using SSL, the following parameters are required:

              private-key
                     Specifies a PEM file containing the private key used for SSL connections.

              certificate
                     Specifies a PEM file containing a certificate, signed by  the  certificate  authority  (CA)
                     used  by  the  connection  peers, that certifies the private key, identifying a trustworthy
                     peer.

              ca-cert
                     Specifies a PEM file containing the CA certificate used to verify that the connection peers
                     are trustworthy.

       These SSL settings apply to all SSL connections made by the southbound database server.

              get-ssl
                     Prints the SSL configuration.

              del-ssl
                     Deletes the current SSL configuration.

              [--bootstrap] set-ssl private-key certificate ca-cert [ssl-protocol-list [ssl-cipher-list]]
                     Sets the SSL configuration.

   Database Commands
       These commands query and modify the contents of ovsdb tables. They are a slight abstraction of the  ovsdb
       interface and as such they operate at a lower level than other ovn-sbctl commands.

       Identifying Tables, Records, and Columns

       Each  of  these commands has a table parameter to identify a table within the database. Many of them also
       take a record parameter that identifies a particular record within a table. The record parameter  may  be
       the  UUID  for a record, which may be abbreviated to its first 4 (or more) hex digits, as long as that is
       unique. Many tables offer additional ways to identify records. Some commands also take column  parameters
       that identify a particular field within the records in a table.

       For a list of tables and their columns, see ovn-sb(5) or see the table listing from the --help option.

       Record  names  must  be  specified  in  full  and  with  correct capitalization, except that UUIDs may be
       abbreviated to their first 4 (or more) hex digits, as long as that is unique within the table.  Names  of
       tables  and columns are not case-sensitive, and - and _ are treated interchangeably. Unique abbreviations
       of table and column names are acceptable, e.g. d or dhcp  is  sufficient  to  identify  the  DHCP_Options
       table.

       Database Values

       Each  column  in  the database accepts a fixed type of data. The currently defined basic types, and their
       representations, are:

              integer
                     A decimal integer in the range -2**63 to 2**63-1, inclusive.

              real   A floating-point number.

              Boolean
                     True or false, written true or false, respectively.

              string An arbitrary Unicode string, except that null bytes are not allowed.  Quotes  are  optional
                     for  most  strings  that  begin  with  an  English letter or underscore and consist only of
                     letters, underscores, hyphens, and periods. However, true and false and strings that  match
                     the  syntax of UUIDs (see below) must be enclosed in double quotes to distinguish them from
                     other basic types. When double quotes are used, the syntax is that of strings in JSON, e.g.
                     backslashes may be used to escape special characters. The empty string must be  represented
                     as a pair of double quotes ("").

              UUID   Either   a   universally   unique   identifier   in   the   style   of   RFC   4122,   e.g.
                     f81d4fae-7dec-11d0-a765-00a0c91e6bf6, or an @name defined by a get or create command within
                     the same ovs-vsctl invocation.

       Multiple values in a single column may be separated by spaces or a single comma. When multiple values are
       present, duplicates are not allowed, and order is not important. Conversely, some  database  columns  can
       have  an  empty  set  of values, represented as [], and square brackets may optionally enclose other non-
       empty sets or single values as well.

       A few database columns are ``maps’’ of key-value pairs, where the key and the value are each  some  fixed
       database  type.  These are specified in the form key=value, where key and value follow the syntax for the
       column’s key type and value type, respectively. When multiple pairs are present (separated by spaces or a
       comma), duplicate keys are not allowed, and again the  order  is  not  important.  Duplicate  values  are
       allowed.  An  empty  map is represented as {}. Curly braces may optionally enclose non-empty maps as well
       (but use quotes  to  prevent  the  shell  from  expanding  other-config={0=x,1=y}  into  other-config=0=x
       other-config=1=y, which may not have the desired effect).

       Database Command Syntax

              [--if-exists] [--columns=column[,column]...] list table [record]...
                     Lists the data in each specified record. If no records are specified, lists all the records
                     in table.

                     If  --columns  is specified, only the requested columns are listed, in the specified order.
                     Otherwise, all columns are listed, in alphabetical order by column name.

                     Without --if-exists, it  is  an  error  if  any  specified  record  does  not  exist.  With
                     --if-exists,  the  command  ignores  any  record that does not exist, without producing any
                     output.

              [--columns=column[,column]...] find table [column[:key]=value]...
                     Lists the data in each record in table whose column equals value or, if key  is  specified,
                     whose  column  contains a key with the specified value. The following operators may be used
                     where = is written in the syntax summary:

                     = != < > <= >=
                            Selects records in which column[:key] equals, does  not  equal,  is  less  than,  is
                            greater  than,  is  less  than  or  equal  to, or is greater than or equal to value,
                            respectively.

                            Consider column[:key] and value as sets of elements. Identical sets  are  considered
                            equal.  Otherwise, if the sets have different numbers of elements, then the set with
                            more elements is considered to be larger. Otherwise, consider a  element  from  each
                            set  pairwise,  in  increasing  order  within  each set. The first pair that differs
                            determines the result. (For a column that contains key-value pairs,  first  all  the
                            keys  are compared, and values are considered only if the two sets contain identical
                            keys.)

                     {=} {!=}
                            Test for set equality or inequality, respectively.

                     {<=}   Selects  records  in  which  column[:key]  is  a  subset  of  value.  For   example,
                            flood-vlans{<=}1,2  selects records in which the flood-vlans column is the empty set
                            or contains 1 or 2 or both.

                     {<}    Selects records in which column[:key] is a proper  subset  of  value.  For  example,
                            flood-vlans{<}1,2  selects  records in which the flood-vlans column is the empty set
                            or contains 1 or 2 but not both.

                     {>=} {>}
                            Same as {<=} and {<}, respectively, except that the relationship  is  reversed.  For
                            example, flood-vlans{>=}1,2 selects records in which the flood-vlans column contains
                            both 1 and 2.

                     The following operators are available only in Open vSwitch 2.16 and later:

                     {in}   Selects  records  in  which every element in column[:key] is also in value. (This is
                            the same as {<=}.)

                     {not-in}
                            Selects records in which every element in column[:key] is not in value.

                     For arithmetic operators (= != < > <= >=), when key is specified but a particular  record’s
                     column  does  not  contain  key,  the  record is always omitted from the results. Thus, the
                     condition other-config:mtu!=1500 matches records that have a mtu key  whose  value  is  not
                     1500, but not those that lack an mtu key.

                     For  the  set  operators,  when  key is specified but a particular record’s column does not
                     contain  key,  the  comparison  is  done  against  an  empty  set.  Thus,   the   condition
                     other-config:mtu{!=}1500  matches  records  that have a mtu key whose value is not 1500 and
                     those that lack an mtu key.

                     Don’t forget to escape < or > from interpretation by the shell.

                     If --columns is specified, only the requested columns are listed, in the  specified  order.
                     Otherwise all columns are listed, in alphabetical order by column name.

                     The UUIDs shown for rows created in the same ovs-vsctl invocation will be wrong.

              [--if-exists] [--id=@name] get table record [column[:key]]...
                     Prints  the value of each specified column in the given record in table. For map columns, a
                     key may optionally be specified, in which case the value associated with key in the  column
                     is printed, instead of the entire map.

                     Without  --if-exists,  it  is an error if record does not exist or key is specified, if key
                     does not exist in record. With --if-exists, a missing record yields no output and a missing
                     key prints a blank line.

                     If @name is specified, then the UUID for record may be referred to by that  name  later  in
                     the same ovs-vsctl invocation in contexts where a UUID is expected.

                     Both  --id  and  the  column  arguments are optional, but usually at least one or the other
                     should be specified. If both are omitted, then get has no  effect  except  to  verify  that
                     record exists in table.

                     --id and --if-exists cannot be used together.

              [--if-exists] set table record column[:key]=value...
                     Sets  the  value  of  each  specified column in the given record in table to value. For map
                     columns, a key may optionally be specified, in which case the value associated with key  in
                     that column is changed (or added, if none exists), instead of the entire map.

                     Without  --if-exists,  it  is  an  error  if  record does not exist. With --if-exists, this
                     command does nothing if record does not exist.

              [--if-exists] add table record column [key=]value...
                     Adds the specified value or key-value pair to column in record in table.  If  column  is  a
                     map,  then  key  is  required,  otherwise  it is prohibited. If key already exists in a map
                     column, then the current value is not replaced (use the set command to replace an  existing
                     value).

                     Without  --if-exists,  it  is  an  error  if  record does not exist. With --if-exists, this
                     command does nothing if record does not exist.

              [--if-exists] remove table record column value...

                     [--if-exists] remove table record column key...

                     [--if-exists] remove table record column key=value...  Removes the specified values or key-
                     value pairs from column in record in table. The first form applies to columns that are  not
                     maps:  each specified value is removed from the column. The second and third forms apply to
                     map columns: if only a key is specified, then any key-value pair  with  the  given  key  is
                     removed,  regardless  of its value; if a value is given then a pair is removed only if both
                     key and value match.

                     It is not an error if the column does not contain the specified key or value or pair.

                     Without --if-exists, it is an error if  record  does  not  exist.  With  --if-exists,  this
                     command does nothing if record does not exist.

              [--if-exists] clear table record column...
                     Sets  each  column  in  record in table to the empty set or empty map, as appropriate. This
                     command applies only to columns that are allowed to be empty.

                     Without --if-exists, it is an error if  record  does  not  exist.  With  --if-exists,  this
                     command does nothing if record does not exist.

              [--id=@name] create table column[:key]=value...
                     Creates  a  new  record  in  table  and sets the initial values of each column. Columns not
                     explicitly set will receive their default values. Outputs the UUID of the new row.

                     If @name is specified, then the UUID for the new row  may  be  referred  to  by  that  name
                     elsewhere  in  the  same  \*(PN  invocation  in  contexts  where  a  UUID is expected. Such
                     references may precede or follow the create command.

                     Caution (ovs-vsctl as example)
                            Records in the Open vSwitch database are significant only when they can  be  reached
                            directly or indirectly from the Open_vSwitch table. Except for records in the QoS or
                            Queue  tables,  records  that  are  not  reachable  from  the Open_vSwitch table are
                            automatically deleted from the database. This deletion happens immediately,  without
                            waiting for additional ovs-vsctl commands or other database activity. Thus, a create
                            command  must  generally  be  accompanied  by  additional  commands  within the same
                            ovs-vsctl invocation to add a chain of references to the newly created  record  from
                            the  top-level  Open_vSwitch  record.  The EXAMPLES section gives some examples that
                            show how to do this.

              [--if-exists] destroy table record...
                     Deletes each specified record from table. Unless --if-exists  is  specified,  each  records
                     must exist.

              --all destroy table
                     Deletes all records from the table.

                     Caution (ovs-vsctl as example)
                            The  destroy  command is only useful for records in the QoS or Queue tables. Records
                            in other tables are  automatically  deleted  from  the  database  when  they  become
                            unreachable from the Open_vSwitch table. This means that deleting the last reference
                            to  a  record  is  sufficient  for  deleting the record itself. For records in these
                            tables, destroy is silently  ignored.  See  the  EXAMPLES  section  below  for  more
                            information.

              wait-until table record [column[:key]=value]...
                     Waits  until  table  contains a record named record whose column equals value or, if key is
                     specified, whose column contains a key with the specified value. This command supports  the
                     same operators and semantics described for the find command above.

                     If  no column[:key]=value arguments are given, this command waits only until record exists.
                     If more than one such argument is given, the command waits until all of them are satisfied.

                     Caution (ovs-vsctl as example)
                            Usually wait-until should be placed at the beginning of a set of ovs-vsctl commands.
                            For example, wait-until bridge br0 -- get  bridge  br0  datapath_id  waits  until  a
                            bridge  named br0 is created, then prints its datapath_id column, whereas get bridge
                            br0 datapath_id -- wait-until bridge br0 will abort if no bridge  named  br0  exists
                            when ovs-vsctl initially connects to the database.

                     Consider  specifying  --timeout=0  along  with  --wait-until,  to  prevent  ovs-vsctl  from
                     terminating after waiting only at most 5 seconds.

              comment [arg]...
                     This command has no effect on behavior, but any database log record created by the  command
                     will include the command and its arguments.

ENVIRONMENT

       OVN_SB_DAEMON
              If  set, this should name the Unix domain socket for an ovn-sbctl server process. See Daemon Mode,
              above, for more information.

       OVN_SBCTL_OPTIONS
              If set, a set of options for ovn-sbctl to apply automatically, in the same form as on the  command
              line.

       OVN_SB_DB
              If set, the default database to contact when the --db option is not used.

EXIT STATUS

       0      Successful program execution.

       1      Usage, syntax, or network error.

SEE ALSO

       ovn-sb(5), ovn-appctl(8).

OVN 22.03.3                                         ovn-sbctl                                       ovn-sbctl(8)