Max level shown: TRCE DEBG INFO WARN ERRO FATA

1			I241018 22:57:44.197086 720 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2024/10/18 22:57:44
2			I241018 22:57:44.197097 720 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01JAGTTY86NRSTE9KFWXBEB43R›
3			I241018 22:57:44.197105 720 util/log/file_sync_buffer.go:238 ⋮ [config] binary: CockroachDB OSS v22.1.9-dirty (x86_64-pc-solaris2.11, built 2022/10/26 21:17:46, go1.17.13)
4			I241018 22:57:44.197111 720 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/crdb-base-build/.tmp2oPyin,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpiosHas/listen-url›]
5			I241018 22:57:44.197123 720 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2
6			I241018 22:57:44.197127 720 util/log/file_sync_buffer.go:238 ⋮ [config] line format: [IWEF]yymmdd hh:mm:ss.uuuuuu goid [chan@]file:line redactionmark \[tags\] [counter] msg
7			I241018 22:57:44.196747 720 5@util/log/event_log.go:32 ⋮ [n1,intExec=‹create-default-DB›] 1 ={"Timestamp":1729292264189368840,"EventType":"create_database","Statement":"CREATE DATABASE IF NOT EXISTS ‹defaultdb›","Tag":"CREATE DATABASE","User":"root","DescriptorID":100,"ApplicationName":"$ internal-create-default-DB","DatabaseName":"‹defaultdb›"}
8			I241018 22:57:44.205922 696 5@util/log/event_log.go:32 ⋮ [n1,intExec=‹create-default-DB›] 2 ={"Timestamp":1729292264197318110,"EventType":"create_database","Statement":"CREATE DATABASE IF NOT EXISTS ‹postgres›","Tag":"CREATE DATABASE","User":"root","DescriptorID":102,"ApplicationName":"$ internal-create-default-DB","DatabaseName":"‹postgres›"}
9			I241018 22:57:45.435852 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 3 ={"Timestamp":1729292264415881370,"EventType":"create_database","Statement":"CREATE DATABASE IF NOT EXISTS ‹omicron›","Tag":"CREATE DATABASE","User":"root","DescriptorID":104,"DatabaseName":"‹omicron›"}
10			I241018 22:57:45.436273 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 4 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹clickhouse_mode› AS ENUM ('single_node_only', 'cluster_only', 'both')","Tag":"CREATE TYPE","User":"root","DescriptorID":106,"TypeName":"‹omicron.public.clickhouse_mode›"}
11			I241018 22:57:45.436282 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 5 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹clickhouse_policy› (‹version› INT8 PRIMARY KEY, ‹clickhouse_mode› omicron.public.clickhouse_mode NOT NULL, ‹clickhouse_cluster_target_servers› INT2 NOT NULL, ‹clickhouse_cluster_target_keepers› INT2 NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":108,"TableName":"‹omicron.public.clickhouse_policy›"}
12			I241018 22:57:45.436292 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 6 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹rack› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹initialized› BOOL NOT NULL, ‹tuf_base_url› STRING(512), ‹rack_subnet› INET)","Tag":"CREATE TABLE","User":"root","DescriptorID":109,"TableName":"‹omicron.public.rack›"}
13			I241018 22:57:45.436301 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 7 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹sled_policy› AS ENUM ('in_service', 'no_provision', 'expunged')","Tag":"CREATE TYPE","User":"root","DescriptorID":110,"TypeName":"‹omicron.public.sled_policy›"}
14			I241018 22:57:45.436309 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 8 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹sled_state› AS ENUM ('active', 'decommissioned')","Tag":"CREATE TYPE","User":"root","DescriptorID":112,"TypeName":"‹omicron.public.sled_state›"}
15			I241018 22:57:45.436323 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 9 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹sled› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹rack_id› UUID NOT NULL, ‹is_scrimlet› BOOL NOT NULL, ‹serial_number› STRING(63) NOT NULL, ‹part_number› STRING(63) NOT NULL, ‹revision› INT8 NOT NULL, ‹usable_hardware_threads› INT8 NOT NULL, ‹usable_physical_ram› INT8 NOT NULL, ‹reservoir_size› INT8 NOT NULL, ‹ip› INET NOT NULL, ‹port› INT4 NOT NULL, ‹last_used_address› INET NOT NULL, ‹sled_policy› omicron.public.sled_policy NOT NULL, ‹sled_state› omicron.public.sled_state NOT NULL, ‹sled_agent_gen› INT8 NOT NULL DEFAULT ‹1›, CHECK (‹usable_hardware_threads› BETWEEN ‹0› AND ‹4294967295›), CHECK (‹reservoir_size› < ‹usable_physical_ram›), CHECK (‹port› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":114,"TableName":"‹omicron.public.sled›"}
16			I241018 22:57:45.436335 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 10 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹commissioned_sled_uniqueness› ON ‹omicron›.public.‹sled› (‹serial_number›, ‹part_number›) WHERE ‹sled_state› != ‹'decommissioned'›","Tag":"CREATE INDEX","User":"root","DescriptorID":114,"TableName":"‹omicron.public.sled›","IndexName":"‹commissioned_sled_uniqueness›"}
17			I241018 22:57:45.436347 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 11 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_sled_by_rack› ON ‹omicron›.public.‹sled› (‹rack_id›, ‹id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":114,"TableName":"‹omicron.public.sled›","IndexName":"‹lookup_sled_by_rack›"}
18			I241018 22:57:45.436356 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 12 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_sled_by_policy_and_state› ON ‹omicron›.public.‹sled› (‹sled_policy›, ‹sled_state›)","Tag":"CREATE INDEX","User":"root","DescriptorID":114,"TableName":"‹omicron.public.sled›","IndexName":"‹lookup_sled_by_policy_and_state›"}
19			I241018 22:57:45.436365 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 13 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹sled_resource_kind› AS ENUM ('instance')","Tag":"CREATE TYPE","User":"root","DescriptorID":115,"TypeName":"‹omicron.public.sled_resource_kind›"}
20			I241018 22:57:45.436372 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 14 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹sled_resource› (‹id› UUID PRIMARY KEY, ‹sled_id› UUID NOT NULL, ‹hardware_threads› INT8 NOT NULL, ‹rss_ram› INT8 NOT NULL, ‹reservoir_ram› INT8 NOT NULL, ‹kind› omicron.public.sled_resource_kind NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":117,"TableName":"‹omicron.public.sled_resource›"}
21			I241018 22:57:45.436380 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 15 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_resource_by_sled› ON ‹omicron›.public.‹sled_resource› (‹sled_id›, ‹id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":117,"TableName":"‹omicron.public.sled_resource›","IndexName":"‹lookup_resource_by_sled›"}
22			I241018 22:57:45.436387 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 16 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹sled_underlay_subnet_allocation› (‹hw_baseboard_id› UUID, ‹rack_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹subnet_octet› INT2 NOT NULL UNIQUE, PRIMARY KEY (‹hw_baseboard_id›, ‹sled_id›), CHECK (‹subnet_octet› BETWEEN ‹33› AND ‹255›))","Tag":"CREATE TABLE","User":"root","DescriptorID":118,"TableName":"‹omicron.public.sled_underlay_subnet_allocation›"}
23			I241018 22:57:45.436397 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 17 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_subnet_allocation_by_rack_and_sled› ON ‹omicron›.public.‹sled_underlay_subnet_allocation› (‹rack_id›, ‹sled_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":118,"TableName":"‹omicron.public.sled_underlay_subnet_allocation›","IndexName":"‹lookup_subnet_allocation_by_rack_and_sled›"}
24			I241018 22:57:45.436406 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 18 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹rack_id› UUID NOT NULL, ‹serial_number› STRING(63) NOT NULL, ‹part_number› STRING(63) NOT NULL, ‹revision› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":119,"TableName":"‹omicron.public.switch›"}
25			I241018 22:57:45.436417 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 19 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_switch_by_rack› ON ‹omicron›.public.‹switch› (‹rack_id›, ‹id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":119,"TableName":"‹omicron.public.switch›","IndexName":"‹lookup_switch_by_rack›"}
26			I241018 22:57:45.436425 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 20 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹service_kind› AS ENUM ('clickhouse', 'clickhouse_keeper', 'clickhouse_server', 'cockroach', 'crucible', 'crucible_pantry', 'dendrite', 'external_dns', 'internal_dns', 'nexus', 'ntp', 'oximeter', 'tfport', 'mgd')","Tag":"CREATE TYPE","User":"root","DescriptorID":120,"TypeName":"‹omicron.public.service_kind›"}
27			I241018 22:57:45.436432 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 21 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹physical_disk_kind› AS ENUM ('m2', 'u2')","Tag":"CREATE TYPE","User":"root","DescriptorID":122,"TypeName":"‹omicron.public.physical_disk_kind›"}
28			I241018 22:57:45.436438 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 22 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹physical_disk_policy› AS ENUM ('in_service', 'expunged')","Tag":"CREATE TYPE","User":"root","DescriptorID":124,"TypeName":"‹omicron.public.physical_disk_policy›"}
29			I241018 22:57:45.436445 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 23 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹physical_disk_state› AS ENUM ('active', 'decommissioned')","Tag":"CREATE TYPE","User":"root","DescriptorID":126,"TypeName":"‹omicron.public.physical_disk_state›"}
30			I241018 22:57:45.436452 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 24 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹physical_disk› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹vendor› STRING(63) NOT NULL, ‹serial› STRING(63) NOT NULL, ‹model› STRING(63) NOT NULL, ‹variant› omicron.public.physical_disk_kind NOT NULL, ‹sled_id› UUID NOT NULL, ‹disk_policy› omicron.public.physical_disk_policy NOT NULL, ‹disk_state› omicron.public.physical_disk_state NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":128,"TableName":"‹omicron.public.physical_disk›"}
31			I241018 22:57:45.436460 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 25 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹vendor_serial_model_unique› ON ‹omicron›.public.‹physical_disk› (‹vendor›, ‹serial›, ‹model›) WHERE (‹time_deleted› IS NULL) AND (‹disk_state› != ‹'decommissioned'›)","Tag":"CREATE INDEX","User":"root","DescriptorID":128,"TableName":"‹omicron.public.physical_disk›","IndexName":"‹vendor_serial_model_unique›"}
32			I241018 22:57:45.436469 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 26 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_physical_disk_by_variant› ON ‹omicron›.public.‹physical_disk› (‹variant›, ‹id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":128,"TableName":"‹omicron.public.physical_disk›","IndexName":"‹lookup_physical_disk_by_variant›"}
33			I241018 22:57:45.436479 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 27 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_physical_disk_by_sled› ON ‹omicron›.public.‹physical_disk› (‹sled_id›, ‹id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":128,"TableName":"‹omicron.public.physical_disk›","IndexName":"‹lookup_physical_disk_by_sled›"}
34			I241018 22:57:45.436487 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 28 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹certificate› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹silo_id› UUID NOT NULL, ‹service› omicron.public.service_kind NOT NULL, ‹cert› BYTES NOT NULL, ‹key› BYTES NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":129,"TableName":"‹omicron.public.certificate›"}
35			I241018 22:57:45.436498 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 29 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_certificate_by_service› ON ‹omicron›.public.‹certificate› (‹service›, ‹id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":129,"TableName":"‹omicron.public.certificate›","IndexName":"‹lookup_certificate_by_service›"}
36			I241018 22:57:45.436507 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 30 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_certificate_by_silo› ON ‹omicron›.public.‹certificate› (‹silo_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":129,"TableName":"‹omicron.public.certificate›","IndexName":"‹lookup_certificate_by_silo›"}
37			I241018 22:57:45.436515 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 31 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹virtual_provisioning_collection› (‹id› UUID PRIMARY KEY, ‹time_modified› TIMESTAMPTZ NOT NULL DEFAULT now(), ‹collection_type› STRING(63) NOT NULL, ‹virtual_disk_bytes_provisioned› INT8 NOT NULL, ‹cpus_provisioned› INT8 NOT NULL, ‹ram_provisioned› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":130,"TableName":"‹omicron.public.virtual_provisioning_collection›"}
38			I241018 22:57:45.436524 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 32 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹virtual_provisioning_resource› (‹id› UUID PRIMARY KEY, ‹time_modified› TIMESTAMPTZ NOT NULL DEFAULT now(), ‹resource_type› STRING(63) NOT NULL, ‹virtual_disk_bytes_provisioned› INT8 NOT NULL, ‹cpus_provisioned› INT8 NOT NULL, ‹ram_provisioned› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":131,"TableName":"‹omicron.public.virtual_provisioning_resource›"}
39			I241018 22:57:45.436531 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 33 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹zpool› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹sled_id› UUID NOT NULL, ‹physical_disk_id› UUID NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":132,"TableName":"‹omicron.public.zpool›"}
40			I241018 22:57:45.436540 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 34 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_zpool_by_disk› ON ‹omicron›.public.‹zpool› (‹physical_disk_id›, ‹id›) WHERE (‹physical_disk_id› IS NOT NULL) AND (‹time_deleted› IS NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":132,"TableName":"‹omicron.public.zpool›","IndexName":"‹lookup_zpool_by_disk›"}
41			I241018 22:57:45.436549 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 35 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹dataset_kind› AS ENUM ('crucible', 'cockroach', 'clickhouse', 'clickhouse_keeper', 'clickhouse_server', 'external_dns', 'internal_dns', 'zone_root', 'zone', 'debug', 'update')","Tag":"CREATE TYPE","User":"root","DescriptorID":133,"TypeName":"‹omicron.public.dataset_kind›"}
42			I241018 22:57:45.436556 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 36 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹dataset› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹pool_id› UUID NOT NULL, ‹ip› INET, ‹port› INT4, ‹kind› omicron.public.dataset_kind NOT NULL, ‹size_used› INT8, ‹zone_name› STRING, CONSTRAINT ‹size_used_column_set_for_crucible› CHECK ((‹kind› != ‹'crucible'›) OR ((‹kind› = ‹'crucible'›) AND (‹size_used› IS NOT NULL))), CONSTRAINT ‹ip_and_port_set_for_crucible› CHECK ((‹kind› != ‹'crucible'›) OR (((‹kind› = ‹'crucible'›) AND (‹ip› IS NOT NULL)) AND (‹port› IS NOT NULL))), CONSTRAINT ‹zone_name_for_zone_kind› CHECK ((‹kind› != ‹'zone'›) OR ((‹kind› = ‹'zone'›) AND (‹zone_name› IS NOT NULL))), CHECK (‹port› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":135,"TableName":"‹omicron.public.dataset›"}
43			I241018 22:57:45.436566 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 37 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_dataset_by_size_used_crucible› ON ‹omicron›.public.‹dataset› (‹size_used›) WHERE ((‹size_used› IS NOT NULL) AND (‹time_deleted› IS NULL)) AND (‹kind› = ‹'crucible'›)","Tag":"CREATE INDEX","User":"root","DescriptorID":135,"TableName":"‹omicron.public.dataset›","IndexName":"‹lookup_dataset_by_size_used_crucible›"}
44			I241018 22:57:45.436574 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 38 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_dataset_by_size_used› ON ‹omicron›.public.‹dataset› (‹size_used›) WHERE (‹size_used› IS NOT NULL) AND (‹time_deleted› IS NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":135,"TableName":"‹omicron.public.dataset›","IndexName":"‹lookup_dataset_by_size_used›"}
45			I241018 22:57:45.436581 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 39 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_dataset_by_zpool› ON ‹omicron›.public.‹dataset› (‹pool_id›, ‹id›) WHERE (‹pool_id› IS NOT NULL) AND (‹time_deleted› IS NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":135,"TableName":"‹omicron.public.dataset›","IndexName":"‹lookup_dataset_by_zpool›"}
46			I241018 22:57:45.436588 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 40 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹region› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹dataset_id› UUID NOT NULL, ‹volume_id› UUID NOT NULL, ‹block_size› INT8 NOT NULL, ‹blocks_per_extent› INT8 NOT NULL, ‹extent_count› INT8 NOT NULL, ‹port› INT4, ‹read_only› BOOL NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":136,"TableName":"‹omicron.public.region›"}
47			I241018 22:57:45.436597 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 41 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_region_by_volume› ON ‹omicron›.public.‹region› (‹volume_id›, ‹id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":136,"TableName":"‹omicron.public.region›","IndexName":"‹lookup_region_by_volume›"}
48			I241018 22:57:45.436615 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 42 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_region_by_dataset› ON ‹omicron›.public.‹region› (‹dataset_id›, ‹id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":136,"TableName":"‹omicron.public.region›","IndexName":"‹lookup_region_by_dataset›"}
49			I241018 22:57:45.436622 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 43 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_regions_missing_ports› ON ‹omicron›.public.‹region› (‹id›) WHERE ‹port› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":136,"TableName":"‹omicron.public.region›","IndexName":"‹lookup_regions_missing_ports›"}
50			I241018 22:57:45.436630 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 44 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹region_snapshot› (‹dataset_id› UUID NOT NULL, ‹region_id› UUID NOT NULL, ‹snapshot_id› UUID NOT NULL, ‹snapshot_addr› STRING NOT NULL, ‹volume_references› INT8 NOT NULL, ‹deleting› BOOL NOT NULL, PRIMARY KEY (‹dataset_id›, ‹region_id›, ‹snapshot_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":137,"TableName":"‹omicron.public.region_snapshot›"}
51			I241018 22:57:45.436637 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 45 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_by_dataset› ON ‹omicron›.public.‹region_snapshot› (‹dataset_id›, ‹region_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":137,"TableName":"‹omicron.public.region_snapshot›","IndexName":"‹lookup_region_by_dataset›"}
52			I241018 22:57:45.436644 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 46 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_snapshot_by_region_id› ON ‹omicron›.public.‹region_snapshot› (‹region_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":137,"TableName":"‹omicron.public.region_snapshot›","IndexName":"‹lookup_region_snapshot_by_region_id›"}
53			I241018 22:57:45.436653 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 47 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_snapshot_by_volume_reference› ON ‹omicron›.public.‹region_snapshot› (‹volume_references›)","Tag":"CREATE INDEX","User":"root","DescriptorID":137,"TableName":"‹omicron.public.region_snapshot›","IndexName":"‹lookup_region_snapshot_by_volume_reference›"}
54			I241018 22:57:45.436660 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 48 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_snapshot_by_snapshot_addr› ON ‹omicron›.public.‹region_snapshot› (‹snapshot_addr›)","Tag":"CREATE INDEX","User":"root","DescriptorID":137,"TableName":"‹omicron.public.region_snapshot›","IndexName":"‹lookup_region_snapshot_by_snapshot_addr›"}
55			I241018 22:57:45.436670 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 49 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹volume› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹data› STRING NOT NULL, ‹resources_to_clean_up› STRING)","Tag":"CREATE TABLE","User":"root","DescriptorID":138,"TableName":"‹omicron.public.volume›"}
56			I241018 22:57:45.436678 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 50 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_volume_by_deleted› ON ‹omicron›.public.‹volume› (‹time_deleted›)","Tag":"CREATE INDEX","User":"root","DescriptorID":138,"TableName":"‹omicron.public.volume›","IndexName":"‹lookup_volume_by_deleted›"}
57			I241018 22:57:45.436685 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 51 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹authentication_mode› AS ENUM ('local', 'saml')","Tag":"CREATE TYPE","User":"root","DescriptorID":139,"TypeName":"‹omicron.public.authentication_mode›"}
58			I241018 22:57:45.436692 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 52 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹user_provision_type› AS ENUM ('api_only', 'jit')","Tag":"CREATE TYPE","User":"root","DescriptorID":141,"TypeName":"‹omicron.public.user_provision_type›"}
59			I241018 22:57:45.436698 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 53 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹silo› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹discoverable› BOOL NOT NULL, ‹authentication_mode› omicron.public.authentication_mode NOT NULL, ‹user_provision_type› omicron.public.user_provision_type NOT NULL, ‹mapped_fleet_roles› JSONB NOT NULL, ‹rcgen› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":143,"TableName":"‹omicron.public.silo›"}
60			I241018 22:57:45.436707 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 54 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_silo_by_name› ON ‹omicron›.public.‹silo› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":143,"TableName":"‹omicron.public.silo›","IndexName":"‹lookup_silo_by_name›"}
61			I241018 22:57:45.436715 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 55 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹silo_user› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹silo_id› UUID NOT NULL, ‹external_id› STRING NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":144,"TableName":"‹omicron.public.silo_user›"}
62			I241018 22:57:45.436722 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 56 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_silo_user_by_silo› ON ‹omicron›.public.‹silo_user› (‹silo_id›, ‹external_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":144,"TableName":"‹omicron.public.silo_user›","IndexName":"‹lookup_silo_user_by_silo›"}
63			I241018 22:57:45.436732 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 57 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹silo_user_password_hash› (‹silo_user_id› UUID NOT NULL, ‹hash› STRING NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, PRIMARY KEY (‹silo_user_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":145,"TableName":"‹omicron.public.silo_user_password_hash›"}
64			I241018 22:57:45.436740 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 58 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹silo_group› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹silo_id› UUID NOT NULL, ‹external_id› STRING NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":146,"TableName":"‹omicron.public.silo_group›"}
65			I241018 22:57:45.436747 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 59 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_silo_group_by_silo› ON ‹omicron›.public.‹silo_group› (‹silo_id›, ‹external_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":146,"TableName":"‹omicron.public.silo_group›","IndexName":"‹lookup_silo_group_by_silo›"}
66			I241018 22:57:45.436754 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 60 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹silo_group_membership› (‹silo_group_id› UUID NOT NULL, ‹silo_user_id› UUID NOT NULL, PRIMARY KEY (‹silo_group_id›, ‹silo_user_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":147,"TableName":"‹omicron.public.silo_group_membership›"}
67			I241018 22:57:45.436761 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 61 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_silo_group_by_user› ON ‹omicron›.public.‹silo_group_membership› (‹silo_user_id›, ‹silo_group_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":147,"TableName":"‹omicron.public.silo_group_membership›","IndexName":"‹lookup_silo_group_by_user›"}
68			I241018 22:57:45.436770 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 62 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹provider_type› AS ENUM ('saml')","Tag":"CREATE TYPE","User":"root","DescriptorID":148,"TypeName":"‹omicron.public.provider_type›"}
69			I241018 22:57:45.436776 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 63 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹identity_provider› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹silo_id› UUID NOT NULL, ‹provider_type› omicron.public.provider_type NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":150,"TableName":"‹omicron.public.identity_provider›"}
70			I241018 22:57:45.436783 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 64 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_idp_by_silo_id› ON ‹omicron›.public.‹identity_provider› (‹silo_id›, ‹id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":150,"TableName":"‹omicron.public.identity_provider›","IndexName":"‹lookup_idp_by_silo_id›"}
71			I241018 22:57:45.436792 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 65 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_idp_by_silo_name› ON ‹omicron›.public.‹identity_provider› (‹silo_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":150,"TableName":"‹omicron.public.identity_provider›","IndexName":"‹lookup_idp_by_silo_name›"}
72			I241018 22:57:45.436801 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 66 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹saml_identity_provider› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹silo_id› UUID NOT NULL, ‹idp_metadata_document_string› STRING NOT NULL, ‹idp_entity_id› STRING NOT NULL, ‹sp_client_id› STRING NOT NULL, ‹acs_url› STRING NOT NULL, ‹slo_url› STRING NOT NULL, ‹technical_contact_email› STRING NOT NULL, ‹public_cert› STRING, ‹private_key› STRING, ‹group_attribute_name› STRING)","Tag":"CREATE TABLE","User":"root","DescriptorID":151,"TableName":"‹omicron.public.saml_identity_provider›"}
73			I241018 22:57:45.436811 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 67 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_saml_idp_by_silo_id› ON ‹omicron›.public.‹saml_identity_provider› (‹silo_id›, ‹id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":151,"TableName":"‹omicron.public.saml_identity_provider›","IndexName":"‹lookup_saml_idp_by_silo_id›"}
74			I241018 22:57:45.436819 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 68 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_saml_idp_by_silo_name› ON ‹omicron›.public.‹saml_identity_provider› (‹silo_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":151,"TableName":"‹omicron.public.saml_identity_provider›","IndexName":"‹lookup_saml_idp_by_silo_name›"}
75			I241018 22:57:45.436827 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 69 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹ssh_key› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹silo_user_id› UUID NOT NULL, ‹public_key› STRING(1023) NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":152,"TableName":"‹omicron.public.ssh_key›"}
76			I241018 22:57:45.436835 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 70 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_ssh_key_by_silo_user› ON ‹omicron›.public.‹ssh_key› (‹silo_user_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":152,"TableName":"‹omicron.public.ssh_key›","IndexName":"‹lookup_ssh_key_by_silo_user›"}
77			I241018 22:57:45.436843 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 71 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹instance_ssh_key› (‹instance_id› UUID NOT NULL, ‹ssh_key_id› UUID NOT NULL, PRIMARY KEY (‹instance_id›, ‹ssh_key_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":153,"TableName":"‹omicron.public.instance_ssh_key›"}
78			I241018 22:57:45.436849 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 72 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹silo_quotas› (‹silo_id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹cpus› INT8 NOT NULL, ‹memory_bytes› INT8 NOT NULL, ‹storage_bytes› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":154,"TableName":"‹omicron.public.silo_quotas›"}
79			I241018 22:57:45.436858 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 73 ={"Timestamp":1729292264415881370,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹silo_utilization› AS SELECT ‹c›.‹id› AS ‹silo_id›, ‹s›.‹name› AS ‹silo_name›, ‹c›.‹cpus_provisioned› AS ‹cpus_provisioned›, ‹c›.‹ram_provisioned› AS ‹memory_provisioned›, ‹c›.‹virtual_disk_bytes_provisioned› AS ‹storage_provisioned›, ‹q›.‹cpus› AS ‹cpus_allocated›, ‹q›.‹memory_bytes› AS ‹memory_allocated›, ‹q›.‹storage_bytes› AS ‹storage_allocated›, ‹s›.‹discoverable› AS ‹silo_discoverable› FROM ‹omicron›.public.‹virtual_provisioning_collection› AS ‹c› RIGHT JOIN ‹omicron›.public.‹silo_quotas› AS ‹q› ON ‹c›.‹id› = ‹q›.‹silo_id› INNER JOIN ‹omicron›.public.‹silo› AS ‹s› ON ‹c›.‹id› = ‹s›.‹id› WHERE (‹c›.‹collection_type› = ‹'Silo'›) AND (‹s›.‹time_deleted› IS NULL)","Tag":"CREATE VIEW","User":"root","DescriptorID":155,"ViewName":"‹omicron.public.silo_utilization›","ViewQuery":"‹SELECT c.id AS silo_id, s.name AS silo_name, c.cpus_provisioned AS cpus_provisioned, c.ram_provisioned AS memory_provisioned, c.virtual_disk_bytes_provisioned AS storage_provisioned, q.cpus AS cpus_allocated, q.memory_bytes AS memory_allocated, q.storage_bytes AS storage_allocated, s.discoverable AS silo_discoverable FROM omicron.public.virtual_provisioning_collection AS c RIGHT JOIN omicron.public.silo_quotas AS q ON c.id = q.silo_id INNER JOIN omicron.public.silo AS s ON c.id = s.id WHERE (c.collection_type = 'Silo') AND (s.time_deleted IS NULL)›"}
80			I241018 22:57:45.436882 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 74 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹project› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹silo_id› UUID NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":156,"TableName":"‹omicron.public.project›"}
81			I241018 22:57:45.436889 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 75 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_project_by_silo› ON ‹omicron›.public.‹project› (‹silo_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":156,"TableName":"‹omicron.public.project›","IndexName":"‹lookup_project_by_silo›"}
82			I241018 22:57:45.436897 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 76 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹instance_state_v2› AS ENUM ('creating', 'no_vmm', 'vmm', 'failed', 'destroyed')","Tag":"CREATE TYPE","User":"root","DescriptorID":157,"TypeName":"‹omicron.public.instance_state_v2›"}
83			I241018 22:57:45.436904 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 77 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹vmm_state› AS ENUM ('creating', 'starting', 'running', 'stopping', 'stopped', 'rebooting', 'migrating', 'failed', 'destroyed', 'saga_unwound')","Tag":"CREATE TYPE","User":"root","DescriptorID":159,"TypeName":"‹omicron.public.vmm_state›"}
84			I241018 22:57:45.436912 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 78 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹instance_auto_restart› AS ENUM ('never', 'best_effort')","Tag":"CREATE TYPE","User":"root","DescriptorID":161,"TypeName":"‹omicron.public.instance_auto_restart›"}
85			I241018 22:57:45.436919 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 79 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹instance› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹project_id› UUID NOT NULL, ‹user_data› BYTES NOT NULL, ‹time_state_updated› TIMESTAMPTZ NOT NULL, ‹state_generation› INT8 NOT NULL, ‹active_propolis_id› UUID, ‹target_propolis_id› UUID, ‹migration_id› UUID, ‹ncpus› INT8 NOT NULL, ‹memory› INT8 NOT NULL, ‹hostname› STRING(63) NOT NULL, ‹updater_id› UUID, ‹updater_gen› INT8 NOT NULL DEFAULT ‹0›, ‹state› omicron.public.instance_state_v2 NOT NULL, ‹time_last_auto_restarted› TIMESTAMPTZ, ‹auto_restart_policy› omicron.public.instance_auto_restart, ‹auto_restart_cooldown› INTERVAL, ‹boot_disk_id› UUID, CONSTRAINT ‹vmm_iff_active_propolis› CHECK (((‹state› = ‹'vmm'›) AND (‹active_propolis_id› IS NOT NULL)) OR ((‹state› != ‹'vmm'›) AND (‹active_propolis_id› IS NULL))))","Tag":"CREATE TABLE","User":"root","DescriptorID":163,"TableName":"‹omicron.public.instance›"}
86			I241018 22:57:45.436930 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 80 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_instance_by_project› ON ‹omicron›.public.‹instance› (‹project_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":163,"TableName":"‹omicron.public.instance›","IndexName":"‹lookup_instance_by_project›"}
87			I241018 22:57:45.436937 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 81 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_instance_by_state› ON ‹omicron›.public.‹instance› (‹state›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":163,"TableName":"‹omicron.public.instance›","IndexName":"‹lookup_instance_by_state›"}
88			I241018 22:57:45.436945 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 82 ={"Timestamp":1729292264415881370,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹sled_instance› AS SELECT ‹instance›.‹id› FROM ‹omicron›.public.‹instance› AS ‹instance› WHERE ‹instance›.‹time_deleted› IS NULL","Tag":"CREATE VIEW","User":"root","DescriptorID":164,"ViewName":"‹omicron.public.sled_instance›","ViewQuery":"‹SELECT instance.id FROM omicron.public.instance AS instance WHERE instance.time_deleted IS NULL›"}
89			I241018 22:57:45.436954 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 83 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹block_size› AS ENUM ('512', '2048', '4096')","Tag":"CREATE TYPE","User":"root","DescriptorID":165,"TypeName":"‹omicron.public.block_size›"}
90			I241018 22:57:45.436961 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 84 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹disk› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL, ‹project_id› UUID NOT NULL, ‹volume_id› UUID NOT NULL, ‹disk_state› STRING(32) NOT NULL, ‹attach_instance_id› UUID, ‹state_generation› INT8 NOT NULL, ‹slot› INT2, ‹time_state_updated› TIMESTAMPTZ NOT NULL, ‹size_bytes› INT8 NOT NULL, ‹block_size› omicron.public.block_size NOT NULL, ‹origin_snapshot› UUID, ‹origin_image› UUID, ‹pantry_address› STRING, CHECK ((‹slot› >= ‹0›) AND (‹slot› < ‹8›)))","Tag":"CREATE TABLE","User":"root","DescriptorID":167,"TableName":"‹omicron.public.disk›"}
91			I241018 22:57:45.436972 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 85 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_disk_by_project› ON ‹omicron›.public.‹disk› (‹project_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":167,"TableName":"‹omicron.public.disk›","IndexName":"‹lookup_disk_by_project›"}
92			I241018 22:57:45.436981 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 86 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_disk_by_instance› ON ‹omicron›.public.‹disk› (‹attach_instance_id›, ‹id›) WHERE (‹time_deleted› IS NULL) AND (‹attach_instance_id› IS NOT NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":167,"TableName":"‹omicron.public.disk›","IndexName":"‹lookup_disk_by_instance›"}
93			I241018 22:57:45.436988 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 87 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_deleted_disk› ON ‹omicron›.public.‹disk› (‹id›) WHERE ‹time_deleted› IS NOT NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":167,"TableName":"‹omicron.public.disk›","IndexName":"‹lookup_deleted_disk›"}
94			I241018 22:57:45.436995 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 88 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_disk_by_volume_id› ON ‹omicron›.public.‹disk› (‹volume_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":167,"TableName":"‹omicron.public.disk›","IndexName":"‹lookup_disk_by_volume_id›"}
95			I241018 22:57:45.437016 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 89 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹image› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹silo_id› UUID NOT NULL, ‹project_id› UUID, ‹volume_id› UUID NOT NULL, ‹url› STRING(8192), ‹os› STRING(64) NOT NULL, ‹version› STRING(64) NOT NULL, ‹digest› STRING, ‹block_size› omicron.public.block_size NOT NULL, ‹size_bytes› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":168,"TableName":"‹omicron.public.image›"}
96			I241018 22:57:45.437027 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 90 ={"Timestamp":1729292264415881370,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹project_image› AS SELECT ‹id›, ‹name›, ‹description›, ‹time_created›, ‹time_modified›, ‹time_deleted›, ‹silo_id›, ‹project_id›, ‹volume_id›, ‹url›, ‹os›, ‹version›, ‹digest›, ‹block_size›, ‹size_bytes› FROM ‹omicron›.public.‹image› WHERE ‹project_id› IS NOT NULL","Tag":"CREATE VIEW","User":"root","DescriptorID":169,"ViewName":"‹omicron.public.project_image›","ViewQuery":"‹SELECT id, name, description, time_created, time_modified, time_deleted, silo_id, project_id, volume_id, url, os, version, digest, block_size, size_bytes FROM omicron.public.image WHERE project_id IS NOT NULL›"}
97			I241018 22:57:45.437042 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 91 ={"Timestamp":1729292264415881370,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹silo_image› AS SELECT ‹id›, ‹name›, ‹description›, ‹time_created›, ‹time_modified›, ‹time_deleted›, ‹silo_id›, ‹volume_id›, ‹url›, ‹os›, ‹version›, ‹digest›, ‹block_size›, ‹size_bytes› FROM ‹omicron›.public.‹image› WHERE ‹project_id› IS NULL","Tag":"CREATE VIEW","User":"root","DescriptorID":170,"ViewName":"‹omicron.public.silo_image›","ViewQuery":"‹SELECT id, name, description, time_created, time_modified, time_deleted, silo_id, volume_id, url, os, version, digest, block_size, size_bytes FROM omicron.public.image WHERE project_id IS NULL›"}
98			I241018 22:57:45.437054 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 92 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_image_by_silo› ON ‹omicron›.public.‹image› (‹silo_id›, ‹name›) WHERE (‹time_deleted› IS NULL) AND (‹project_id› IS NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":168,"TableName":"‹omicron.public.image›","IndexName":"‹lookup_image_by_silo›"}
99			I241018 22:57:45.437062 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 93 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_image_by_silo_and_project› ON ‹omicron›.public.‹image› (‹silo_id›, ‹project_id›, ‹name›) WHERE (‹time_deleted› IS NULL) AND (‹project_id› IS NOT NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":168,"TableName":"‹omicron.public.image›","IndexName":"‹lookup_image_by_silo_and_project›"}
100			I241018 22:57:45.437069 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 94 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹snapshot_state› AS ENUM ('creating', 'ready', 'faulted', 'destroyed')","Tag":"CREATE TYPE","User":"root","DescriptorID":171,"TypeName":"‹omicron.public.snapshot_state›"}
101			I241018 22:57:45.437076 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 95 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹snapshot› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹project_id› UUID NOT NULL, ‹disk_id› UUID NOT NULL, ‹volume_id› UUID NOT NULL, ‹destination_volume_id› UUID NOT NULL, ‹gen› INT8 NOT NULL, ‹state› omicron.public.snapshot_state NOT NULL, ‹block_size› omicron.public.block_size NOT NULL, ‹size_bytes› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":173,"TableName":"‹omicron.public.snapshot›"}
102			I241018 22:57:45.437085 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 96 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_snapshot_by_project› ON ‹omicron›.public.‹snapshot› (‹project_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":173,"TableName":"‹omicron.public.snapshot›","IndexName":"‹lookup_snapshot_by_project›"}
103			I241018 22:57:45.437092 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 97 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹oximeter› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹ip› INET NOT NULL, ‹port› INT4 NOT NULL, ‹time_expunged› TIMESTAMPTZ, CHECK (‹port› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":174,"TableName":"‹omicron.public.oximeter›"}
104			I241018 22:57:45.437103 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 98 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹list_non_expunged_oximeter› ON ‹omicron›.public.‹oximeter› (‹id›) WHERE ‹time_expunged› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":174,"TableName":"‹omicron.public.oximeter›","IndexName":"‹list_non_expunged_oximeter›"}
105			I241018 22:57:45.437111 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 99 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹producer_kind› AS ENUM ('sled_agent', 'service', 'instance', 'management_gateway')","Tag":"CREATE TYPE","User":"root","DescriptorID":175,"TypeName":"‹omicron.public.producer_kind›"}
106			I241018 22:57:45.437117 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 100 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹metric_producer› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹kind› omicron.public.producer_kind NOT NULL, ‹ip› INET NOT NULL, ‹port› INT4 NOT NULL, ‹\"interval\"› FLOAT8 NOT NULL, ‹oximeter_id› UUID NOT NULL, CHECK (‹port› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":177,"TableName":"‹omicron.public.metric_producer›"}
107			I241018 22:57:45.437125 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 101 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_producer_by_oximeter› ON ‹omicron›.public.‹metric_producer› (‹oximeter_id›, ‹id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":177,"TableName":"‹omicron.public.metric_producer›","IndexName":"‹lookup_producer_by_oximeter›"}
108			I241018 22:57:45.437134 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 102 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_producer_by_time_modified› ON ‹omicron›.public.‹metric_producer› (‹time_modified›)","Tag":"CREATE INDEX","User":"root","DescriptorID":177,"TableName":"‹omicron.public.metric_producer›","IndexName":"‹lookup_producer_by_time_modified›"}
109			I241018 22:57:45.437141 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 103 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹vpc› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹project_id› UUID NOT NULL, ‹system_router_id› UUID NOT NULL, ‹dns_name› STRING(63) NOT NULL, ‹vni› INT4 NOT NULL, ‹ipv6_prefix› INET NOT NULL, ‹firewall_gen› INT8 NOT NULL, ‹subnet_gen› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":178,"TableName":"‹omicron.public.vpc›"}
110			I241018 22:57:45.437149 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 104 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_vpc_by_project› ON ‹omicron›.public.‹vpc› (‹project_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":178,"TableName":"‹omicron.public.vpc›","IndexName":"‹lookup_vpc_by_project›"}
111			I241018 22:57:45.437158 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 105 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_vpc_by_vni› ON ‹omicron›.public.‹vpc› (‹vni›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":178,"TableName":"‹omicron.public.vpc›","IndexName":"‹lookup_vpc_by_vni›"}
112			I241018 22:57:45.437167 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 106 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹vpc_subnet› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹vpc_id› UUID NOT NULL, ‹rcgen› INT8 NOT NULL, ‹ipv4_block› INET NOT NULL, ‹ipv6_block› INET NOT NULL, ‹custom_router_id› UUID)","Tag":"CREATE TABLE","User":"root","DescriptorID":179,"TableName":"‹omicron.public.vpc_subnet›"}
113			I241018 22:57:45.437176 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 107 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹vpc_subnet_vpc_id_name_key› ON ‹omicron›.public.‹vpc_subnet› (‹vpc_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":179,"TableName":"‹omicron.public.vpc_subnet›","IndexName":"‹vpc_subnet_vpc_id_name_key›"}
114			I241018 22:57:45.437183 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 108 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹network_interface_kind› AS ENUM ('instance', 'service', 'probe')","Tag":"CREATE TYPE","User":"root","DescriptorID":180,"TypeName":"‹omicron.public.network_interface_kind›"}
115			I241018 22:57:45.437189 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 109 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹network_interface› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹kind› omicron.public.network_interface_kind NOT NULL, ‹parent_id› UUID NOT NULL, ‹vpc_id› UUID NOT NULL, ‹subnet_id› UUID NOT NULL, ‹mac› INT8 NOT NULL, ‹ip› INET NOT NULL, ‹slot› INT2 NOT NULL, ‹is_primary› BOOL NOT NULL, ‹transit_ips› INET[] NOT NULL DEFAULT ARRAY[], CHECK ((‹slot› >= ‹0›) AND (‹slot› < ‹8›)))","Tag":"CREATE TABLE","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›"}
116			I241018 22:57:45.437197 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 110 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹instance_network_interface_mac› ON ‹omicron›.public.‹network_interface› (‹mac›) STORING (‹time_deleted›)","Tag":"CREATE INDEX","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›","IndexName":"‹instance_network_interface_mac›"}
117			I241018 22:57:45.437206 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 111 ={"Timestamp":1729292264415881370,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹instance_network_interface› AS SELECT ‹id›, ‹name›, ‹description›, ‹time_created›, ‹time_modified›, ‹time_deleted›, ‹parent_id› AS ‹instance_id›, ‹vpc_id›, ‹subnet_id›, ‹mac›, ‹ip›, ‹slot›, ‹is_primary›, ‹transit_ips› FROM ‹omicron›.public.‹network_interface› WHERE ‹kind› = ‹'instance'›","Tag":"CREATE VIEW","User":"root","DescriptorID":183,"ViewName":"‹omicron.public.instance_network_interface›","ViewQuery":"‹SELECT id, name, description, time_created, time_modified, time_deleted, parent_id AS instance_id, vpc_id, subnet_id, mac, ip, slot, is_primary, transit_ips FROM omicron.public.network_interface WHERE kind = 'instance'›"}
118			I241018 22:57:45.437221 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 112 ={"Timestamp":1729292264415881370,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹service_network_interface› AS SELECT ‹id›, ‹name›, ‹description›, ‹time_created›, ‹time_modified›, ‹time_deleted›, ‹parent_id› AS ‹service_id›, ‹vpc_id›, ‹subnet_id›, ‹mac›, ‹ip›, ‹slot›, ‹is_primary› FROM ‹omicron›.public.‹network_interface› WHERE ‹kind› = ‹'service'›","Tag":"CREATE VIEW","User":"root","DescriptorID":184,"ViewName":"‹omicron.public.service_network_interface›","ViewQuery":"‹SELECT id, name, description, time_created, time_modified, time_deleted, parent_id AS service_id, vpc_id, subnet_id, mac, ip, slot, is_primary FROM omicron.public.network_interface WHERE kind = 'service'›"}
119			I241018 22:57:45.437233 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 113 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹network_interface_subnet_id_ip_key› ON ‹omicron›.public.‹network_interface› (‹subnet_id›, ‹ip›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›","IndexName":"‹network_interface_subnet_id_ip_key›"}
120			I241018 22:57:45.437241 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 114 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹network_interface_vpc_id_mac_key› ON ‹omicron›.public.‹network_interface› (‹vpc_id›, ‹mac›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›","IndexName":"‹network_interface_vpc_id_mac_key›"}
121			I241018 22:57:45.437249 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 115 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹network_interface_parent_id_name_kind_key› ON ‹omicron›.public.‹network_interface› (‹parent_id›, ‹name›, ‹kind›) STORING (‹vpc_id›, ‹subnet_id›, ‹is_primary›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›","IndexName":"‹network_interface_parent_id_name_kind_key›"}
122			I241018 22:57:45.437257 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 116 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹network_interface_parent_id_slot_key› ON ‹omicron›.public.‹network_interface› (‹parent_id›, ‹slot›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›","IndexName":"‹network_interface_parent_id_slot_key›"}
123			I241018 22:57:45.437265 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 117 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹vpc_firewall_rule_status› AS ENUM ('disabled', 'enabled')","Tag":"CREATE TYPE","User":"root","DescriptorID":185,"TypeName":"‹omicron.public.vpc_firewall_rule_status›"}
124			I241018 22:57:45.437271 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 118 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹vpc_firewall_rule_direction› AS ENUM ('inbound', 'outbound')","Tag":"CREATE TYPE","User":"root","DescriptorID":187,"TypeName":"‹omicron.public.vpc_firewall_rule_direction›"}
125			I241018 22:57:45.437282 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 119 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹vpc_firewall_rule_action› AS ENUM ('allow', 'deny')","Tag":"CREATE TYPE","User":"root","DescriptorID":189,"TypeName":"‹omicron.public.vpc_firewall_rule_action›"}
126			I241018 22:57:45.437289 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 120 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹vpc_firewall_rule_protocol› AS ENUM ('TCP', 'UDP', 'ICMP')","Tag":"CREATE TYPE","User":"root","DescriptorID":191,"TypeName":"‹omicron.public.vpc_firewall_rule_protocol›"}
127			I241018 22:57:45.437295 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 121 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹vpc_firewall_rule› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹vpc_id› UUID NOT NULL, ‹status› omicron.public.vpc_firewall_rule_status NOT NULL, ‹direction› omicron.public.vpc_firewall_rule_direction NOT NULL, ‹targets› STRING(128)[] NOT NULL, ‹filter_hosts› STRING(128)[], ‹filter_ports› STRING(11)[], ‹filter_protocols› omicron.public.vpc_firewall_rule_protocol[], ‹action› omicron.public.vpc_firewall_rule_action NOT NULL, ‹priority› INT4 NOT NULL, CHECK (‹priority› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":193,"TableName":"‹omicron.public.vpc_firewall_rule›"}
128			I241018 22:57:45.437305 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 122 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_firewall_by_vpc› ON ‹omicron›.public.‹vpc_firewall_rule› (‹vpc_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":193,"TableName":"‹omicron.public.vpc_firewall_rule›","IndexName":"‹lookup_firewall_by_vpc›"}
129			I241018 22:57:45.437313 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 123 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹vpc_router_kind› AS ENUM ('system', 'custom')","Tag":"CREATE TYPE","User":"root","DescriptorID":194,"TypeName":"‹omicron.public.vpc_router_kind›"}
130			I241018 22:57:45.437320 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 124 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹vpc_router› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹kind› omicron.public.vpc_router_kind NOT NULL, ‹vpc_id› UUID NOT NULL, ‹rcgen› INT8 NOT NULL, ‹resolved_version› INT8 NOT NULL DEFAULT ‹0›)","Tag":"CREATE TABLE","User":"root","DescriptorID":196,"TableName":"‹omicron.public.vpc_router›"}
131			I241018 22:57:45.437328 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 125 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_router_by_vpc› ON ‹omicron›.public.‹vpc_router› (‹vpc_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":196,"TableName":"‹omicron.public.vpc_router›","IndexName":"‹lookup_router_by_vpc›"}
132			I241018 22:57:45.437335 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 126 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_routers_in_vpc› ON ‹omicron›.public.‹vpc_router› (‹vpc_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":196,"TableName":"‹omicron.public.vpc_router›","IndexName":"‹lookup_routers_in_vpc›"}
133			I241018 22:57:45.437344 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 127 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹router_route_kind› AS ENUM ('default', 'vpc_subnet', 'vpc_peering', 'custom')","Tag":"CREATE TYPE","User":"root","DescriptorID":197,"TypeName":"‹omicron.public.router_route_kind›"}
134			I241018 22:57:45.437351 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 128 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹router_route› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹vpc_router_id› UUID NOT NULL, ‹kind› omicron.public.router_route_kind NOT NULL, ‹target› STRING(128) NOT NULL, ‹destination› STRING(128) NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":199,"TableName":"‹omicron.public.router_route›"}
135			I241018 22:57:45.437359 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 129 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_route_by_router› ON ‹omicron›.public.‹router_route› (‹vpc_router_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":199,"TableName":"‹omicron.public.router_route›","IndexName":"‹lookup_route_by_router›"}
136			I241018 22:57:45.437366 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 130 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹internet_gateway› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹vpc_id› UUID NOT NULL, ‹rcgen› INT8 NOT NULL, ‹resolved_version› INT8 NOT NULL DEFAULT ‹0›)","Tag":"CREATE TABLE","User":"root","DescriptorID":200,"TableName":"‹omicron.public.internet_gateway›"}
137			I241018 22:57:45.437373 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 131 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_internet_gateway_by_vpc› ON ‹omicron›.public.‹internet_gateway› (‹vpc_id›, ‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":200,"TableName":"‹omicron.public.internet_gateway›","IndexName":"‹lookup_internet_gateway_by_vpc›"}
138			I241018 22:57:45.437380 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 132 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹internet_gateway_ip_pool› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹internet_gateway_id› UUID, ‹ip_pool_id› UUID)","Tag":"CREATE TABLE","User":"root","DescriptorID":201,"TableName":"‹omicron.public.internet_gateway_ip_pool›"}
139			I241018 22:57:45.437390 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 133 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_internet_gateway_ip_pool_by_igw_id› ON ‹omicron›.public.‹internet_gateway_ip_pool› (‹internet_gateway_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":201,"TableName":"‹omicron.public.internet_gateway_ip_pool›","IndexName":"‹lookup_internet_gateway_ip_pool_by_igw_id›"}
140			I241018 22:57:45.437399 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 134 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹internet_gateway_ip_address› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹internet_gateway_id› UUID, ‹address› INET)","Tag":"CREATE TABLE","User":"root","DescriptorID":202,"TableName":"‹omicron.public.internet_gateway_ip_address›"}
141			I241018 22:57:45.437409 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 135 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_internet_gateway_ip_address_by_igw_id› ON ‹omicron›.public.‹internet_gateway_ip_address› (‹internet_gateway_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":202,"TableName":"‹omicron.public.internet_gateway_ip_address›","IndexName":"‹lookup_internet_gateway_ip_address_by_igw_id›"}
142			I241018 22:57:45.437418 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 136 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹ip_pool› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹rcgen› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":203,"TableName":"‹omicron.public.ip_pool›"}
143			I241018 22:57:45.437425 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 137 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_pool_by_name› ON ‹omicron›.public.‹ip_pool› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":203,"TableName":"‹omicron.public.ip_pool›","IndexName":"‹lookup_pool_by_name›"}
144			I241018 22:57:45.437432 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 138 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹ip_pool_resource_type› AS ENUM ('silo')","Tag":"CREATE TYPE","User":"root","DescriptorID":204,"TypeName":"‹omicron.public.ip_pool_resource_type›"}
145			I241018 22:57:45.437438 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 139 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹ip_pool_resource› (‹ip_pool_id› UUID NOT NULL, ‹resource_type› omicron.public.ip_pool_resource_type NOT NULL, ‹resource_id› UUID NOT NULL, ‹is_default› BOOL NOT NULL, PRIMARY KEY (‹ip_pool_id›, ‹resource_type›, ‹resource_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":206,"TableName":"‹omicron.public.ip_pool_resource›"}
146			I241018 22:57:45.437446 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 140 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹one_default_ip_pool_per_resource› ON ‹omicron›.public.‹ip_pool_resource› (‹resource_id›) WHERE ‹is_default› = ‹true›","Tag":"CREATE INDEX","User":"root","DescriptorID":206,"TableName":"‹omicron.public.ip_pool_resource›","IndexName":"‹one_default_ip_pool_per_resource›"}
147			I241018 22:57:45.437453 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 141 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹ip_pool_resource_id› ON ‹omicron›.public.‹ip_pool_resource› (‹resource_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":206,"TableName":"‹omicron.public.ip_pool_resource›","IndexName":"‹ip_pool_resource_id›"}
148			I241018 22:57:45.437463 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 142 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹ip_pool_resource_ip_pool_id› ON ‹omicron›.public.‹ip_pool_resource› (‹ip_pool_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":206,"TableName":"‹omicron.public.ip_pool_resource›","IndexName":"‹ip_pool_resource_ip_pool_id›"}
149			I241018 22:57:45.437470 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 143 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹ip_pool_range› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹first_address› INET NOT NULL, ‹last_address› INET NOT NULL, ‹ip_pool_id› UUID NOT NULL, ‹rcgen› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":207,"TableName":"‹omicron.public.ip_pool_range›"}
150			I241018 22:57:45.437478 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 144 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_pool_range_by_first_address› ON ‹omicron›.public.‹ip_pool_range› (‹first_address›) STORING (‹last_address›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":207,"TableName":"‹omicron.public.ip_pool_range›","IndexName":"‹lookup_pool_range_by_first_address›"}
151			I241018 22:57:45.437486 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 145 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_pool_range_by_last_address› ON ‹omicron›.public.‹ip_pool_range› (‹last_address›) STORING (‹first_address›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":207,"TableName":"‹omicron.public.ip_pool_range›","IndexName":"‹lookup_pool_range_by_last_address›"}
152			I241018 22:57:45.437493 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 146 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹ip_kind› AS ENUM ('snat', 'ephemeral', 'floating')","Tag":"CREATE TYPE","User":"root","DescriptorID":208,"TypeName":"‹omicron.public.ip_kind›"}
153			I241018 22:57:45.437500 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 147 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹ip_attach_state› AS ENUM ('detached', 'attached', 'detaching', 'attaching')","Tag":"CREATE TYPE","User":"root","DescriptorID":210,"TypeName":"‹omicron.public.ip_attach_state›"}
154			I241018 22:57:45.437507 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 148 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹external_ip› (‹id› UUID PRIMARY KEY, ‹name› STRING(63), ‹description› STRING(512), ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹ip_pool_id› UUID NOT NULL, ‹ip_pool_range_id› UUID NOT NULL, ‹is_service› BOOL NOT NULL, ‹parent_id› UUID, ‹kind› omicron.public.ip_kind NOT NULL, ‹ip› INET NOT NULL, ‹first_port› INT4 NOT NULL, ‹last_port› INT4 NOT NULL, ‹project_id› UUID, ‹state› omicron.public.ip_attach_state NOT NULL, ‹is_probe› BOOL NOT NULL DEFAULT ‹false›, CONSTRAINT ‹null_fip_name› CHECK (((‹kind› != ‹'floating'›) AND (‹name› IS NULL)) OR ((‹kind› = ‹'floating'›) AND (‹name› IS NOT NULL))), CONSTRAINT ‹null_fip_description› CHECK (((‹kind› != ‹'floating'›) AND (‹description› IS NULL)) OR ((‹kind› = ‹'floating'›) AND (‹description› IS NOT NULL))), CONSTRAINT ‹null_project_id› CHECK ((((‹kind› = ‹'floating'›) AND (‹is_service› = ‹false›)) AND (‹project_id› IS NOT NULL)) OR (((‹kind› != ‹'floating'›) OR (‹is_service› = ‹true›)) AND (‹project_id› IS NULL))), CONSTRAINT ‹null_snat_parent_id› CHECK ((‹kind› != ‹'snat'›) OR (‹parent_id› IS NOT NULL)), CONSTRAINT ‹ephemeral_kind_service› CHECK (((‹kind› = ‹'ephemeral'›) AND (‹is_service› = ‹false›)) OR (‹kind› != ‹'ephemeral'›)), CONSTRAINT ‹detached_null_parent_id› CHECK ((‹state› = ‹'detached'›) OR (‹parent_id› IS NOT NULL)))","Tag":"CREATE TABLE","User":"root","DescriptorID":212,"TableName":"‹omicron.public.external_ip›"}
155			I241018 22:57:45.437525 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 149 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹external_ip_by_pool› ON ‹omicron›.public.‹external_ip› (‹ip_pool_id›, ‹ip_pool_range_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":212,"TableName":"‹omicron.public.external_ip›","IndexName":"‹external_ip_by_pool›"}
156			I241018 22:57:45.437533 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 150 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹external_ip_unique› ON ‹omicron›.public.‹external_ip› (‹ip›, ‹first_port›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":212,"TableName":"‹omicron.public.external_ip›","IndexName":"‹external_ip_unique›"}
157			I241018 22:57:45.437540 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 151 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_external_ip_by_parent› ON ‹omicron›.public.‹external_ip› (‹parent_id›, ‹id›) WHERE (‹parent_id› IS NOT NULL) AND (‹time_deleted› IS NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":212,"TableName":"‹omicron.public.external_ip›","IndexName":"‹lookup_external_ip_by_parent›"}
158			I241018 22:57:45.437548 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 152 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹one_ephemeral_ip_per_instance› ON ‹omicron›.public.‹external_ip› (‹parent_id›) WHERE ((‹kind› = ‹'ephemeral'›) AND (‹parent_id› IS NOT NULL)) AND (‹time_deleted› IS NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":212,"TableName":"‹omicron.public.external_ip›","IndexName":"‹one_ephemeral_ip_per_instance›"}
159			I241018 22:57:45.437555 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 153 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_floating_ip_by_name› ON ‹omicron›.public.‹external_ip› (‹name›) WHERE ((‹kind› = ‹'floating'›) AND (‹time_deleted› IS NULL)) AND (‹project_id› IS NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":212,"TableName":"‹omicron.public.external_ip›","IndexName":"‹lookup_floating_ip_by_name›"}
160			I241018 22:57:45.437563 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 154 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_floating_ip_by_name_and_project› ON ‹omicron›.public.‹external_ip› (‹project_id›, ‹name›) WHERE ((‹kind› = ‹'floating'›) AND (‹time_deleted› IS NULL)) AND (‹project_id› IS NOT NULL)","Tag":"CREATE INDEX","User":"root","DescriptorID":212,"TableName":"‹omicron.public.external_ip›","IndexName":"‹lookup_floating_ip_by_name_and_project›"}
161			I241018 22:57:45.437574 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 155 ={"Timestamp":1729292264415881370,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹floating_ip› AS SELECT ‹id›, ‹name›, ‹description›, ‹time_created›, ‹time_modified›, ‹time_deleted›, ‹ip_pool_id›, ‹ip_pool_range_id›, ‹is_service›, ‹parent_id›, ‹ip›, ‹project_id› FROM ‹omicron›.public.‹external_ip› WHERE (‹omicron›.‹public›.‹external_ip›.‹kind› = ‹'floating'›) AND (‹project_id› IS NOT NULL)","Tag":"CREATE VIEW","User":"root","DescriptorID":213,"ViewName":"‹omicron.public.floating_ip›","ViewQuery":"‹SELECT id, name, description, time_created, time_modified, time_deleted, ip_pool_id, ip_pool_range_id, is_service, parent_id, ip, project_id FROM omicron.public.external_ip WHERE (omicron.public.external_ip.kind = 'floating') AND (project_id IS NOT NULL)›"}
162			I241018 22:57:45.437588 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 156 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹saga_state› AS ENUM ('running', 'unwinding', 'done')","Tag":"CREATE TYPE","User":"root","DescriptorID":214,"TypeName":"‹omicron.public.saga_state›"}
163			I241018 22:57:45.437595 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 157 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹saga› (‹id› UUID PRIMARY KEY, ‹creator› UUID NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹name› STRING(128) NOT NULL, ‹saga_dag› JSONB NOT NULL, ‹saga_state› omicron.public.saga_state NOT NULL, ‹current_sec› UUID, ‹adopt_generation› INT8 NOT NULL, ‹adopt_time› TIMESTAMPTZ NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":216,"TableName":"‹omicron.public.saga›"}
164			I241018 22:57:45.437602 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 158 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_saga_by_sec› ON ‹omicron›.public.‹saga› (‹current_sec›, ‹id›) WHERE ‹saga_state› != ‹'done'›","Tag":"CREATE INDEX","User":"root","DescriptorID":216,"TableName":"‹omicron.public.saga›","IndexName":"‹lookup_saga_by_sec›"}
165			I241018 22:57:45.437610 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 159 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹saga_node_event› (‹saga_id› UUID NOT NULL, ‹node_id› INT8 NOT NULL, ‹event_type› STRING(31) NOT NULL, ‹data› JSONB, ‹event_time› TIMESTAMPTZ NOT NULL, ‹creator› UUID NOT NULL, PRIMARY KEY (‹saga_id›, ‹node_id›, ‹event_type›))","Tag":"CREATE TABLE","User":"root","DescriptorID":217,"TableName":"‹omicron.public.saga_node_event›"}
166			I241018 22:57:45.437617 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 160 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹console_session› (‹token› STRING(40) PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_last_used› TIMESTAMPTZ NOT NULL, ‹silo_user_id› UUID NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":218,"TableName":"‹omicron.public.console_session›"}
167			I241018 22:57:45.437624 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 161 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_console_by_creation› ON ‹omicron›.public.‹console_session› (‹time_created›)","Tag":"CREATE INDEX","User":"root","DescriptorID":218,"TableName":"‹omicron.public.console_session›","IndexName":"‹lookup_console_by_creation›"}
168			I241018 22:57:45.437631 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 162 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_console_by_silo_user› ON ‹omicron›.public.‹console_session› (‹silo_user_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":218,"TableName":"‹omicron.public.console_session›","IndexName":"‹lookup_console_by_silo_user›"}
169			I241018 22:57:45.437640 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 163 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹tuf_repo› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹sha256› STRING(64) NOT NULL, ‹targets_role_version› INT8 NOT NULL, ‹valid_until› TIMESTAMPTZ NOT NULL, ‹system_version› STRING(64) NOT NULL, ‹file_name› STRING NOT NULL, CONSTRAINT ‹unique_checksum› UNIQUE (‹sha256›), CONSTRAINT ‹unique_system_version› UNIQUE (‹system_version›))","Tag":"CREATE TABLE","User":"root","DescriptorID":219,"TableName":"‹omicron.public.tuf_repo›"}
170			I241018 22:57:45.437649 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 164 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹tuf_artifact› (‹name› STRING(63) NOT NULL, ‹version› STRING(63) NOT NULL, ‹kind› STRING(63) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹sha256› STRING(64) NOT NULL, ‹artifact_size› INT8 NOT NULL, PRIMARY KEY (‹name›, ‹version›, ‹kind›))","Tag":"CREATE TABLE","User":"root","DescriptorID":220,"TableName":"‹omicron.public.tuf_artifact›"}
171			I241018 22:57:45.437656 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 165 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹tuf_repo_artifact› (‹tuf_repo_id› UUID NOT NULL, ‹tuf_artifact_name› STRING(63) NOT NULL, ‹tuf_artifact_version› STRING(63) NOT NULL, ‹tuf_artifact_kind› STRING(63) NOT NULL, PRIMARY KEY (‹tuf_repo_id›, ‹tuf_artifact_name›, ‹tuf_artifact_version›, ‹tuf_artifact_kind›))","Tag":"CREATE TABLE","User":"root","DescriptorID":221,"TableName":"‹omicron.public.tuf_repo_artifact›"}
172			I241018 22:57:45.437664 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 166 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹dns_group› AS ENUM ('internal', 'external')","Tag":"CREATE TYPE","User":"root","DescriptorID":222,"TypeName":"‹omicron.public.dns_group›"}
173			I241018 22:57:45.437670 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 167 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹dns_zone› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹dns_group› omicron.public.dns_group NOT NULL, ‹zone_name› STRING NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":224,"TableName":"‹omicron.public.dns_zone›"}
174			I241018 22:57:45.437677 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 168 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_dns_zone_by_group› ON ‹omicron›.public.‹dns_zone› (‹dns_group›, ‹zone_name›)","Tag":"CREATE INDEX","User":"root","DescriptorID":224,"TableName":"‹omicron.public.dns_zone›","IndexName":"‹lookup_dns_zone_by_group›"}
175			I241018 22:57:45.437684 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 169 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹dns_version› (‹dns_group› omicron.public.dns_group NOT NULL, ‹version› INT8 NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹creator› STRING NOT NULL, ‹comment› STRING NOT NULL, PRIMARY KEY (‹dns_group›, ‹version›))","Tag":"CREATE TABLE","User":"root","DescriptorID":225,"TableName":"‹omicron.public.dns_version›"}
176			I241018 22:57:45.437694 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 170 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹dns_name› (‹dns_zone_id› UUID NOT NULL, ‹version_added› INT8 NOT NULL, ‹version_removed› INT8, ‹name› STRING NOT NULL, ‹dns_record_data› JSONB NOT NULL, PRIMARY KEY (‹dns_zone_id›, ‹name›, ‹version_added›))","Tag":"CREATE TABLE","User":"root","DescriptorID":226,"TableName":"‹omicron.public.dns_name›"}
177			I241018 22:57:45.437702 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 171 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_dns_name_by_zone› ON ‹omicron›.public.‹dns_name› (‹dns_zone_id›, ‹name›) WHERE ‹version_removed› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":226,"TableName":"‹omicron.public.dns_name›","IndexName":"‹lookup_dns_name_by_zone›"}
178			I241018 22:57:45.437711 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 172 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹user_builtin› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":227,"TableName":"‹omicron.public.user_builtin›"}
179			I241018 22:57:45.437718 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 173 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_user_builtin_by_name› ON ‹omicron›.public.‹user_builtin› (‹name›)","Tag":"CREATE INDEX","User":"root","DescriptorID":227,"TableName":"‹omicron.public.user_builtin›","IndexName":"‹lookup_user_builtin_by_name›"}
180			I241018 22:57:45.437726 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 174 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹device_auth_request› (‹user_code› STRING(20) PRIMARY KEY, ‹client_id› UUID NOT NULL, ‹device_code› STRING(40) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_expires› TIMESTAMPTZ NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":228,"TableName":"‹omicron.public.device_auth_request›"}
181			I241018 22:57:45.437735 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 175 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹device_access_token› (‹token› STRING(40) PRIMARY KEY, ‹client_id› UUID NOT NULL, ‹device_code› STRING(40) NOT NULL, ‹silo_user_id› UUID NOT NULL, ‹time_requested› TIMESTAMPTZ NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_expires› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":229,"TableName":"‹omicron.public.device_access_token›"}
182			I241018 22:57:45.437742 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 176 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_device_access_token_by_client› ON ‹omicron›.public.‹device_access_token› (‹client_id›, ‹device_code›)","Tag":"CREATE INDEX","User":"root","DescriptorID":229,"TableName":"‹omicron.public.device_access_token›","IndexName":"‹lookup_device_access_token_by_client›"}
183			I241018 22:57:45.437750 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 177 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_device_access_token_by_silo_user› ON ‹omicron›.public.‹device_access_token› (‹silo_user_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":229,"TableName":"‹omicron.public.device_access_token›","IndexName":"‹lookup_device_access_token_by_silo_user›"}
184			I241018 22:57:45.437761 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 178 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹role_builtin› (‹resource_type› STRING(63), ‹role_name› STRING(63), ‹description› STRING(512), PRIMARY KEY (‹resource_type›, ‹role_name›))","Tag":"CREATE TABLE","User":"root","DescriptorID":230,"TableName":"‹omicron.public.role_builtin›"}
185			I241018 22:57:45.437768 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 179 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹identity_type› AS ENUM ('user_builtin', 'silo_user', 'silo_group')","Tag":"CREATE TYPE","User":"root","DescriptorID":231,"TypeName":"‹omicron.public.identity_type›"}
186			I241018 22:57:45.437774 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 180 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹role_assignment› (‹resource_type› STRING(63) NOT NULL, ‹role_name› STRING(63) NOT NULL, ‹resource_id› UUID NOT NULL, ‹identity_id› UUID NOT NULL, ‹identity_type› omicron.public.identity_type NOT NULL, PRIMARY KEY (‹resource_id›, ‹resource_type›, ‹role_name›, ‹identity_id›, ‹identity_type›))","Tag":"CREATE TABLE","User":"root","DescriptorID":233,"TableName":"‹omicron.public.role_assignment›"}
187			I241018 22:57:45.437783 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 181 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹address_lot_kind› AS ENUM ('infra', 'pool')","Tag":"CREATE TYPE","User":"root","DescriptorID":234,"TypeName":"‹omicron.public.address_lot_kind›"}
188			I241018 22:57:45.437789 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 182 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹address_lot› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹kind› omicron.public.address_lot_kind NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":236,"TableName":"‹omicron.public.address_lot›"}
189			I241018 22:57:45.437796 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 183 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_address_lot_by_name› ON ‹omicron›.public.‹address_lot› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":236,"TableName":"‹omicron.public.address_lot›","IndexName":"‹lookup_address_lot_by_name›"}
190			I241018 22:57:45.437803 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 184 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹address_lot_block› (‹id› UUID PRIMARY KEY, ‹address_lot_id› UUID NOT NULL, ‹first_address› INET NOT NULL, ‹last_address› INET NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":237,"TableName":"‹omicron.public.address_lot_block›"}
191			I241018 22:57:45.437810 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 185 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_address_lot_block_by_lot› ON ‹omicron›.public.‹address_lot_block› (‹address_lot_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":237,"TableName":"‹omicron.public.address_lot_block›","IndexName":"‹lookup_address_lot_block_by_lot›"}
192			I241018 22:57:45.437819 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 186 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹address_lot_rsvd_block› (‹id› UUID PRIMARY KEY, ‹address_lot_id› UUID NOT NULL, ‹first_address› INET NOT NULL, ‹last_address› INET NOT NULL, ‹anycast› BOOL NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":238,"TableName":"‹omicron.public.address_lot_rsvd_block›"}
193			I241018 22:57:45.437826 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 187 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_address_lot_rsvd_block_by_lot› ON ‹omicron›.public.‹address_lot_rsvd_block› (‹address_lot_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":238,"TableName":"‹omicron.public.address_lot_rsvd_block›","IndexName":"‹lookup_address_lot_rsvd_block_by_lot›"}
194			I241018 22:57:45.437834 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 188 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_address_lot_rsvd_block_by_anycast› ON ‹omicron›.public.‹address_lot_rsvd_block› (‹anycast›)","Tag":"CREATE INDEX","User":"root","DescriptorID":238,"TableName":"‹omicron.public.address_lot_rsvd_block›","IndexName":"‹lookup_address_lot_rsvd_block_by_anycast›"}
195			I241018 22:57:45.437842 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 189 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹loopback_address› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹address_lot_block_id› UUID NOT NULL, ‹rsvd_address_lot_block_id› UUID NOT NULL, ‹rack_id› UUID NOT NULL, ‹switch_location› STRING NOT NULL, ‹address› INET NOT NULL, ‹anycast› BOOL NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":239,"TableName":"‹omicron.public.loopback_address›"}
196			I241018 22:57:45.437852 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 190 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_loopback_address› ON ‹omicron›.public.‹loopback_address› (‹address›, ‹rack_id›, ‹switch_location›)","Tag":"CREATE INDEX","User":"root","DescriptorID":239,"TableName":"‹omicron.public.loopback_address›","IndexName":"‹lookup_loopback_address›"}
197			I241018 22:57:45.437860 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 191 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port› (‹id› UUID PRIMARY KEY, ‹rack_id› UUID, ‹switch_location› STRING, ‹port_name› STRING, ‹port_settings_id› UUID, CONSTRAINT ‹switch_port_rack_locaction_name_unique› UNIQUE (‹rack_id›, ‹switch_location›, ‹port_name›))","Tag":"CREATE TABLE","User":"root","DescriptorID":240,"TableName":"‹omicron.public.switch_port›"}
198			I241018 22:57:45.437867 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 192 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_switch_port_by_port_settings› ON ‹omicron›.public.‹switch_port› (‹port_settings_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":240,"TableName":"‹omicron.public.switch_port›","IndexName":"‹lookup_switch_port_by_port_settings›"}
199			I241018 22:57:45.437876 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 193 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_groups› (‹port_settings_id› UUID, ‹port_settings_group_id› UUID, PRIMARY KEY (‹port_settings_id›, ‹port_settings_group_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":241,"TableName":"‹omicron.public.switch_port_settings_groups›"}
200			I241018 22:57:45.437885 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 194 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_group› (‹id› UUID PRIMARY KEY, ‹port_settings_id› UUID NOT NULL, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":242,"TableName":"‹omicron.public.switch_port_settings_group›"}
201			I241018 22:57:45.437892 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 195 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_switch_port_settings_group_by_name› ON ‹omicron›.public.‹switch_port_settings_group› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":242,"TableName":"‹omicron.public.switch_port_settings_group›","IndexName":"‹lookup_switch_port_settings_group_by_name›"}
202			I241018 22:57:45.437899 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 196 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":243,"TableName":"‹omicron.public.switch_port_settings›"}
203			I241018 22:57:45.437908 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 197 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹switch_port_settings_by_name› ON ‹omicron›.public.‹switch_port_settings› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":243,"TableName":"‹omicron.public.switch_port_settings›","IndexName":"‹switch_port_settings_by_name›"}
204			I241018 22:57:45.437915 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 198 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹switch_port_geometry› AS ENUM ('Qsfp28x1', 'Qsfp28x2', 'Sfp28x4')","Tag":"CREATE TYPE","User":"root","DescriptorID":244,"TypeName":"‹omicron.public.switch_port_geometry›"}
205			I241018 22:57:45.437922 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 199 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_port_config› (‹port_settings_id› UUID PRIMARY KEY, ‹\"geometry\"› omicron.public.switch_port_geometry)","Tag":"CREATE TABLE","User":"root","DescriptorID":246,"TableName":"‹omicron.public.switch_port_settings_port_config›"}
206			I241018 22:57:45.437928 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 200 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹switch_link_fec› AS ENUM ('Firecode', 'None', 'Rs')","Tag":"CREATE TYPE","User":"root","DescriptorID":247,"TypeName":"‹omicron.public.switch_link_fec›"}
207			I241018 22:57:45.437937 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 201 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹switch_link_speed› AS ENUM ('0G', '1G', '10G', '25G', '40G', '50G', '100G', '200G', '400G')","Tag":"CREATE TYPE","User":"root","DescriptorID":249,"TypeName":"‹omicron.public.switch_link_speed›"}
208			I241018 22:57:45.437946 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 202 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_link_config› (‹port_settings_id› UUID, ‹link_name› STRING, ‹mtu› INT4, ‹fec› omicron.public.switch_link_fec, ‹speed› omicron.public.switch_link_speed, ‹autoneg› BOOL NOT NULL DEFAULT ‹false›, ‹lldp_link_config_id› UUID, PRIMARY KEY (‹port_settings_id›, ‹link_name›))","Tag":"CREATE TABLE","User":"root","DescriptorID":251,"TableName":"‹omicron.public.switch_port_settings_link_config›"}
209			I241018 22:57:45.437955 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 203 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹lldp_link_config› (‹id› UUID PRIMARY KEY, ‹enabled› BOOL NOT NULL, ‹link_name› STRING(63), ‹link_description› STRING(512), ‹chassis_id› STRING(63), ‹system_name› STRING(63), ‹system_description› STRING(612), ‹management_ip› STRING, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":252,"TableName":"‹omicron.public.lldp_link_config›"}
210			I241018 22:57:45.437963 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 204 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹switch_interface_kind› AS ENUM ('primary', 'vlan', 'loopback')","Tag":"CREATE TYPE","User":"root","DescriptorID":253,"TypeName":"‹omicron.public.switch_interface_kind›"}
211			I241018 22:57:45.437970 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 205 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_interface_config› (‹port_settings_id› UUID, ‹id› UUID PRIMARY KEY, ‹interface_name› STRING NOT NULL, ‹v6_enabled› BOOL NOT NULL, ‹kind› omicron.public.switch_interface_kind)","Tag":"CREATE TABLE","User":"root","DescriptorID":255,"TableName":"‹omicron.public.switch_port_settings_interface_config›"}
212			I241018 22:57:45.437979 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 206 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹switch_port_settings_interface_config_by_id› ON ‹omicron›.public.‹switch_port_settings_interface_config› (‹port_settings_id›, ‹interface_name›)","Tag":"CREATE INDEX","User":"root","DescriptorID":255,"TableName":"‹omicron.public.switch_port_settings_interface_config›","IndexName":"‹switch_port_settings_interface_config_by_id›"}
213			I241018 22:57:45.437987 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 207 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_vlan_interface_config› (‹interface_config_id› UUID, ‹vid› INT4, PRIMARY KEY (‹interface_config_id›, ‹vid›))","Tag":"CREATE TABLE","User":"root","DescriptorID":256,"TableName":"‹omicron.public.switch_vlan_interface_config›"}
214			I241018 22:57:45.437994 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 208 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_route_config› (‹port_settings_id› UUID, ‹interface_name› STRING, ‹dst› INET, ‹gw› INET, ‹vid› INT4, ‹local_pref› INT8, PRIMARY KEY (‹port_settings_id›, ‹interface_name›, ‹dst›, ‹gw›))","Tag":"CREATE TABLE","User":"root","DescriptorID":257,"TableName":"‹omicron.public.switch_port_settings_route_config›"}
215			I241018 22:57:45.438027 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 209 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_bgp_peer_config› (‹port_settings_id› UUID, ‹bgp_config_id› UUID NOT NULL, ‹interface_name› STRING, ‹addr› INET, ‹hold_time› INT8, ‹idle_hold_time› INT8, ‹delay_open› INT8, ‹connect_retry› INT8, ‹keepalive› INT8, ‹remote_asn› INT8, ‹min_ttl› INT2, ‹md5_auth_key› STRING, ‹multi_exit_discriminator› INT8, ‹local_pref› INT8, ‹enforce_first_as› BOOL NOT NULL DEFAULT ‹false›, ‹allow_import_list_active› BOOL NOT NULL DEFAULT ‹false›, ‹allow_export_list_active› BOOL NOT NULL DEFAULT ‹false›, ‹vlan_id› INT4, PRIMARY KEY (‹port_settings_id›, ‹interface_name›, ‹addr›))","Tag":"CREATE TABLE","User":"root","DescriptorID":258,"TableName":"‹omicron.public.switch_port_settings_bgp_peer_config›"}
216			I241018 22:57:45.438981 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 210 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_sps_bgp_peer_config_by_bgp_config_id› ON ‹omicron›.public.‹switch_port_settings_bgp_peer_config› (‹bgp_config_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":258,"TableName":"‹omicron.public.switch_port_settings_bgp_peer_config›","IndexName":"‹lookup_sps_bgp_peer_config_by_bgp_config_id›"}
217			I241018 22:57:45.438993 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 211 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_bgp_peer_config_communities› (‹port_settings_id› UUID NOT NULL, ‹interface_name› STRING NOT NULL, ‹addr› INET NOT NULL, ‹community› INT8 NOT NULL, PRIMARY KEY (‹port_settings_id›, ‹interface_name›, ‹addr›, ‹community›))","Tag":"CREATE TABLE","User":"root","DescriptorID":259,"TableName":"‹omicron.public.switch_port_settings_bgp_peer_config_communities›"}
218			I241018 22:57:45.439023 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 212 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_bgp_peer_config_allow_import› (‹port_settings_id› UUID NOT NULL, ‹interface_name› STRING NOT NULL, ‹addr› INET NOT NULL, ‹prefix› INET NOT NULL, PRIMARY KEY (‹port_settings_id›, ‹interface_name›, ‹addr›, ‹prefix›))","Tag":"CREATE TABLE","User":"root","DescriptorID":260,"TableName":"‹omicron.public.switch_port_settings_bgp_peer_config_allow_import›"}
219			I241018 22:57:45.439038 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 213 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_bgp_peer_config_allow_export› (‹port_settings_id› UUID NOT NULL, ‹interface_name› STRING NOT NULL, ‹addr› INET NOT NULL, ‹prefix› INET NOT NULL, PRIMARY KEY (‹port_settings_id›, ‹interface_name›, ‹addr›, ‹prefix›))","Tag":"CREATE TABLE","User":"root","DescriptorID":261,"TableName":"‹omicron.public.switch_port_settings_bgp_peer_config_allow_export›"}
220			I241018 22:57:45.439046 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 214 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bgp_config› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹asn› INT8 NOT NULL, ‹vrf› STRING, ‹bgp_announce_set_id› UUID NOT NULL, ‹shaper› STRING, ‹checker› STRING)","Tag":"CREATE TABLE","User":"root","DescriptorID":262,"TableName":"‹omicron.public.bgp_config›"}
221			I241018 22:57:45.439059 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 215 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_bgp_config_by_name› ON ‹omicron›.public.‹bgp_config› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":262,"TableName":"‹omicron.public.bgp_config›","IndexName":"‹lookup_bgp_config_by_name›"}
222			I241018 22:57:45.439069 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 216 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_bgp_config_by_asn› ON ‹omicron›.public.‹bgp_config› (‹asn›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":262,"TableName":"‹omicron.public.bgp_config›","IndexName":"‹lookup_bgp_config_by_asn›"}
223			I241018 22:57:45.439076 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 217 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bgp_announce_set› (‹id› UUID PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":263,"TableName":"‹omicron.public.bgp_announce_set›"}
224			I241018 22:57:45.439083 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 218 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_bgp_announce_set_by_name› ON ‹omicron›.public.‹bgp_announce_set› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":263,"TableName":"‹omicron.public.bgp_announce_set›","IndexName":"‹lookup_bgp_announce_set_by_name›"}
225			I241018 22:57:45.439090 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 219 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bgp_announcement› (‹announce_set_id› UUID, ‹address_lot_block_id› UUID NOT NULL, ‹network› INET, PRIMARY KEY (‹announce_set_id›, ‹network›))","Tag":"CREATE TABLE","User":"root","DescriptorID":264,"TableName":"‹omicron.public.bgp_announcement›"}
226			I241018 22:57:45.439098 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 220 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹switch_port_settings_address_config› (‹port_settings_id› UUID, ‹address_lot_block_id› UUID NOT NULL, ‹rsvd_address_lot_block_id› UUID NOT NULL, ‹address› INET, ‹interface_name› STRING, ‹vlan_id› INT4, PRIMARY KEY (‹port_settings_id›, ‹address›, ‹interface_name›))","Tag":"CREATE TABLE","User":"root","DescriptorID":265,"TableName":"‹omicron.public.switch_port_settings_address_config›"}
227			I241018 22:57:45.439106 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 221 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bootstore_keys› (‹key› STRING NOT NULL PRIMARY KEY, ‹generation› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":266,"TableName":"‹omicron.public.bootstore_keys›"}
228			I241018 22:57:45.439122 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 222 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹hw_baseboard_id› (‹id› UUID PRIMARY KEY, ‹part_number› STRING NOT NULL, ‹serial_number› STRING NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":267,"TableName":"‹omicron.public.hw_baseboard_id›"}
229			I241018 22:57:45.439128 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 223 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_baseboard_id_by_props› ON ‹omicron›.public.‹hw_baseboard_id› (‹part_number›, ‹serial_number›)","Tag":"CREATE INDEX","User":"root","DescriptorID":267,"TableName":"‹omicron.public.hw_baseboard_id›","IndexName":"‹lookup_baseboard_id_by_props›"}
230			I241018 22:57:45.439145 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 224 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹hw_power_state› AS ENUM ('A0', 'A1', 'A2')","Tag":"CREATE TYPE","User":"root","DescriptorID":268,"TypeName":"‹omicron.public.hw_power_state›"}
231			I241018 22:57:45.439160 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 225 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹hw_rot_slot› AS ENUM ('A', 'B')","Tag":"CREATE TYPE","User":"root","DescriptorID":270,"TypeName":"‹omicron.public.hw_rot_slot›"}
232			I241018 22:57:45.439166 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 226 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹sw_caboose› (‹id› UUID PRIMARY KEY, ‹board› STRING NOT NULL, ‹git_commit› STRING NOT NULL, ‹name› STRING NOT NULL, ‹version› STRING NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":272,"TableName":"‹omicron.public.sw_caboose›"}
233			I241018 22:57:45.439173 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 227 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹caboose_properties› ON ‹omicron›.public.‹sw_caboose› (‹board›, ‹git_commit›, ‹name›, ‹version›)","Tag":"CREATE INDEX","User":"root","DescriptorID":272,"TableName":"‹omicron.public.sw_caboose›","IndexName":"‹caboose_properties›"}
234			I241018 22:57:45.439181 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 228 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹sw_root_of_trust_page› (‹id› UUID PRIMARY KEY, ‹data_base64› STRING NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":273,"TableName":"‹omicron.public.sw_root_of_trust_page›"}
235			I241018 22:57:45.439189 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 229 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹root_of_trust_page_properties› ON ‹omicron›.public.‹sw_root_of_trust_page› (‹data_base64›)","Tag":"CREATE INDEX","User":"root","DescriptorID":273,"TableName":"‹omicron.public.sw_root_of_trust_page›","IndexName":"‹root_of_trust_page_properties›"}
236			I241018 22:57:45.439196 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 230 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_collection› (‹id› UUID PRIMARY KEY, ‹time_started› TIMESTAMPTZ NOT NULL, ‹time_done› TIMESTAMPTZ NOT NULL, ‹collector› STRING NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":274,"TableName":"‹omicron.public.inv_collection›"}
237			I241018 22:57:45.439203 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 231 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹inv_collection_by_time_started› ON ‹omicron›.public.‹inv_collection› (‹time_started›)","Tag":"CREATE INDEX","User":"root","DescriptorID":274,"TableName":"‹omicron.public.inv_collection›","IndexName":"‹inv_collection_by_time_started›"}
238			I241018 22:57:45.439210 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 232 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹inv_collectionby_time_done› ON ‹omicron›.public.‹inv_collection› (‹time_done› DESC)","Tag":"CREATE INDEX","User":"root","DescriptorID":274,"TableName":"‹omicron.public.inv_collection›","IndexName":"‹inv_collectionby_time_done›"}
239			I241018 22:57:45.439221 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 233 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_collection_error› (‹inv_collection_id› UUID NOT NULL, ‹idx› INT4 NOT NULL, ‹message› STRING)","Tag":"CREATE TABLE","User":"root","DescriptorID":275,"TableName":"‹omicron.public.inv_collection_error›"}
240			I241018 22:57:45.439227 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 234 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹errors_by_collection› ON ‹omicron›.public.‹inv_collection_error› (‹inv_collection_id›, ‹idx›)","Tag":"CREATE INDEX","User":"root","DescriptorID":275,"TableName":"‹omicron.public.inv_collection_error›","IndexName":"‹errors_by_collection›"}
241			I241018 22:57:45.439238 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 235 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹sp_type› AS ENUM ('sled', 'switch', 'power')","Tag":"CREATE TYPE","User":"root","DescriptorID":276,"TypeName":"‹omicron.public.sp_type›"}
242			I241018 22:57:45.439246 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 236 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_service_processor› (‹inv_collection_id› UUID NOT NULL, ‹hw_baseboard_id› UUID NOT NULL, ‹time_collected› TIMESTAMPTZ NOT NULL, ‹source› STRING NOT NULL, ‹sp_type› omicron.public.sp_type NOT NULL, ‹sp_slot› INT4 NOT NULL, ‹baseboard_revision› INT8 NOT NULL, ‹hubris_archive_id› STRING NOT NULL, ‹power_state› omicron.public.hw_power_state NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹hw_baseboard_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":278,"TableName":"‹omicron.public.inv_service_processor›"}
243			I241018 22:57:45.439255 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 237 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹rot_image_error› AS ENUM ('unchecked', 'first_page_erased', 'partially_programmed', 'invalid_length', 'header_not_programmed', 'bootloader_too_small', 'bad_magic', 'header_image_size', 'unaligned_length', 'unsupported_type', 'not_thumb2', 'reset_vector', 'signature')","Tag":"CREATE TYPE","User":"root","DescriptorID":279,"TypeName":"‹omicron.public.rot_image_error›"}
244			I241018 22:57:45.439262 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 238 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_root_of_trust› (‹inv_collection_id› UUID NOT NULL, ‹hw_baseboard_id› UUID NOT NULL, ‹time_collected› TIMESTAMPTZ NOT NULL, ‹source› STRING NOT NULL, ‹slot_active› omicron.public.hw_rot_slot NOT NULL, ‹slot_boot_pref_transient› omicron.public.hw_rot_slot, ‹slot_boot_pref_persistent› omicron.public.hw_rot_slot NOT NULL, ‹slot_boot_pref_persistent_pending› omicron.public.hw_rot_slot, ‹slot_a_sha3_256› STRING, ‹slot_b_sha3_256› STRING, ‹stage0_fwid› STRING, ‹stage0next_fwid› STRING, ‹slot_a_error› omicron.public.rot_image_error, ‹slot_b_error› omicron.public.rot_image_error, ‹stage0_error› omicron.public.rot_image_error, ‹stage0next_error› omicron.public.rot_image_error, PRIMARY KEY (‹inv_collection_id›, ‹hw_baseboard_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":281,"TableName":"‹omicron.public.inv_root_of_trust›"}
245			I241018 22:57:45.439273 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 239 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹caboose_which› AS ENUM ('sp_slot_0', 'sp_slot_1', 'rot_slot_A', 'rot_slot_B', 'stage0', 'stage0next')","Tag":"CREATE TYPE","User":"root","DescriptorID":282,"TypeName":"‹omicron.public.caboose_which›"}
246			I241018 22:57:45.439281 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 240 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_caboose› (‹inv_collection_id› UUID NOT NULL, ‹hw_baseboard_id› UUID NOT NULL, ‹time_collected› TIMESTAMPTZ NOT NULL, ‹source› STRING NOT NULL, ‹which› omicron.public.caboose_which NOT NULL, ‹sw_caboose_id› UUID NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹hw_baseboard_id›, ‹which›))","Tag":"CREATE TABLE","User":"root","DescriptorID":284,"TableName":"‹omicron.public.inv_caboose›"}
247			I241018 22:57:45.439288 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 241 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹root_of_trust_page_which› AS ENUM ('cmpa', 'cfpa_active', 'cfpa_inactive', 'cfpa_scratch')","Tag":"CREATE TYPE","User":"root","DescriptorID":285,"TypeName":"‹omicron.public.root_of_trust_page_which›"}
248			I241018 22:57:45.439294 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 242 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_root_of_trust_page› (‹inv_collection_id› UUID NOT NULL, ‹hw_baseboard_id› UUID NOT NULL, ‹time_collected› TIMESTAMPTZ NOT NULL, ‹source› STRING NOT NULL, ‹which› omicron.public.root_of_trust_page_which NOT NULL, ‹sw_root_of_trust_page_id› UUID NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹hw_baseboard_id›, ‹which›))","Tag":"CREATE TABLE","User":"root","DescriptorID":287,"TableName":"‹omicron.public.inv_root_of_trust_page›"}
249			I241018 22:57:45.439302 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 243 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹sled_role› AS ENUM ('scrimlet', 'gimlet')","Tag":"CREATE TYPE","User":"root","DescriptorID":288,"TypeName":"‹omicron.public.sled_role›"}
250			I241018 22:57:45.439307 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 244 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_sled_agent› (‹inv_collection_id› UUID NOT NULL, ‹time_collected› TIMESTAMPTZ NOT NULL, ‹source› STRING NOT NULL, ‹sled_id› UUID NOT NULL, ‹hw_baseboard_id› UUID, ‹sled_agent_ip› INET NOT NULL, ‹sled_agent_port› INT4 NOT NULL, ‹sled_role› omicron.public.sled_role NOT NULL, ‹usable_hardware_threads› INT8 NOT NULL, ‹usable_physical_ram› INT8 NOT NULL, ‹reservoir_size› INT8 NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹sled_id›), CHECK (‹usable_hardware_threads› BETWEEN ‹0› AND ‹4294967295›), CHECK (‹reservoir_size› < ‹usable_physical_ram›))","Tag":"CREATE TABLE","User":"root","DescriptorID":290,"TableName":"‹omicron.public.inv_sled_agent›"}
251			I241018 22:57:45.439316 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 245 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_physical_disk› (‹inv_collection_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹slot› INT8 NOT NULL, ‹vendor› STRING(63) NOT NULL, ‹model› STRING(63) NOT NULL, ‹serial› STRING(63) NOT NULL, ‹variant› omicron.public.physical_disk_kind NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹sled_id›, ‹slot›), CHECK (‹slot› >= ‹0›))","Tag":"CREATE TABLE","User":"root","DescriptorID":291,"TableName":"‹omicron.public.inv_physical_disk›"}
252			I241018 22:57:45.439355 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 246 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_nvme_disk_firmware› (‹inv_collection_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹slot› INT8 NOT NULL, ‹number_of_slots› INT2 NOT NULL, ‹active_slot› INT2 NOT NULL, ‹next_active_slot› INT2, ‹slot1_is_read_only› BOOL, ‹slot_firmware_versions› STRING(8)[], PRIMARY KEY (‹inv_collection_id›, ‹sled_id›, ‹slot›), CHECK (‹slot› >= ‹0›), CHECK (‹number_of_slots› BETWEEN ‹1› AND ‹7›), CHECK (‹active_slot› BETWEEN ‹1› AND ‹7›), CHECK (‹next_active_slot› BETWEEN ‹1› AND ‹7›), CHECK (array_length(‹slot_firmware_versions›, ‹1›) BETWEEN ‹1› AND ‹7›))","Tag":"CREATE TABLE","User":"root","DescriptorID":292,"TableName":"‹omicron.public.inv_nvme_disk_firmware›"}
253			I241018 22:57:45.439367 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 247 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_zpool› (‹inv_collection_id› UUID NOT NULL, ‹time_collected› TIMESTAMPTZ NOT NULL, ‹id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹total_size› INT8 NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹sled_id›, ‹id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":293,"TableName":"‹omicron.public.inv_zpool›"}
254			I241018 22:57:45.439375 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 248 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹inv_zpool_by_id_and_time› ON ‹omicron›.public.‹inv_zpool› (‹id›, ‹time_collected› DESC)","Tag":"CREATE INDEX","User":"root","DescriptorID":293,"TableName":"‹omicron.public.inv_zpool›","IndexName":"‹inv_zpool_by_id_and_time›"}
255			I241018 22:57:45.439383 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 249 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_dataset› (‹inv_collection_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹id› UUID, ‹name› STRING NOT NULL, ‹available› INT8 NOT NULL, ‹used› INT8 NOT NULL, ‹quota› INT8, ‹reservation› INT8, ‹compression› STRING NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹sled_id›, ‹name›))","Tag":"CREATE TABLE","User":"root","DescriptorID":294,"TableName":"‹omicron.public.inv_dataset›"}
256			I241018 22:57:45.439391 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 250 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_sled_omicron_zones› (‹inv_collection_id› UUID NOT NULL, ‹time_collected› TIMESTAMPTZ NOT NULL, ‹source› STRING NOT NULL, ‹sled_id› UUID NOT NULL, ‹generation› INT8 NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹sled_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":295,"TableName":"‹omicron.public.inv_sled_omicron_zones›"}
257			I241018 22:57:45.439400 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 251 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹zone_type› AS ENUM ('boundary_ntp', 'clickhouse', 'clickhouse_keeper', 'clickhouse_server', 'cockroach_db', 'crucible', 'crucible_pantry', 'external_dns', 'internal_dns', 'internal_ntp', 'nexus', 'oximeter')","Tag":"CREATE TYPE","User":"root","DescriptorID":296,"TypeName":"‹omicron.public.zone_type›"}
258			I241018 22:57:45.439408 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 252 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_omicron_zone› (‹inv_collection_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹id› UUID NOT NULL, ‹underlay_address› INET NOT NULL, ‹zone_type› omicron.public.zone_type NOT NULL, ‹primary_service_ip› INET NOT NULL, ‹primary_service_port› INT4 NOT NULL, ‹second_service_ip› INET, ‹second_service_port› INT4, ‹dataset_zpool_name› STRING, ‹nic_id› UUID, ‹dns_gz_address› INET, ‹dns_gz_address_index› INT8, ‹ntp_ntp_servers› STRING[], ‹ntp_dns_servers› INET[], ‹ntp_domain› STRING, ‹nexus_external_tls› BOOL, ‹nexus_external_dns_servers› INET[], ‹snat_ip› INET, ‹snat_first_port› INT4, ‹snat_last_port› INT4, ‹filesystem_pool› UUID, PRIMARY KEY (‹inv_collection_id›, ‹id›), CHECK (‹primary_service_port› BETWEEN ‹0› AND ‹65535›), CHECK ((‹second_service_port› IS NULL) OR (‹second_service_port› BETWEEN ‹0› AND ‹65535›)), CHECK ((‹snat_first_port› IS NULL) OR (‹snat_first_port› BETWEEN ‹0› AND ‹65535›)), CHECK ((‹snat_last_port› IS NULL) OR (‹snat_last_port› BETWEEN ‹0› AND ‹65535›)))","Tag":"CREATE TABLE","User":"root","DescriptorID":298,"TableName":"‹omicron.public.inv_omicron_zone›"}
259			I241018 22:57:45.439423 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 253 ={"Timestamp":1729292264415881370,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹inv_omicron_zone_nic_id› ON ‹omicron›.public.‹inv_omicron_zone› (‹nic_id›) STORING (‹sled_id›, ‹primary_service_ip›, ‹second_service_ip›, ‹snat_ip›)","Tag":"CREATE INDEX","User":"root","DescriptorID":298,"TableName":"‹omicron.public.inv_omicron_zone›","IndexName":"‹inv_omicron_zone_nic_id›"}
260			I241018 22:57:45.439432 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 254 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_omicron_zone_nic› (‹inv_collection_id› UUID NOT NULL, ‹id› UUID NOT NULL, ‹name› STRING NOT NULL, ‹ip› INET NOT NULL, ‹mac› INT8 NOT NULL, ‹subnet› INET NOT NULL, ‹vni› INT8 NOT NULL, ‹is_primary› BOOL NOT NULL, ‹slot› INT2 NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":299,"TableName":"‹omicron.public.inv_omicron_zone_nic›"}
261			I241018 22:57:45.439440 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 255 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹inv_clickhouse_keeper_membership› (‹inv_collection_id› UUID NOT NULL, ‹queried_keeper_id› INT8 NOT NULL, ‹leader_committed_log_index› INT8 NOT NULL, ‹raft_config› INT8[] NOT NULL, PRIMARY KEY (‹inv_collection_id›, ‹queried_keeper_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":300,"TableName":"‹omicron.public.inv_clickhouse_keeper_membership›"}
262			I241018 22:57:45.439447 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 256 ={"Timestamp":1729292264415881370,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹bp_zone_disposition› AS ENUM ('in_service', 'quiesced', 'expunged')","Tag":"CREATE TYPE","User":"root","DescriptorID":301,"TypeName":"‹omicron.public.bp_zone_disposition›"}
263			I241018 22:57:45.439456 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 257 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹blueprint› (‹id› UUID PRIMARY KEY, ‹parent_blueprint_id› UUID, ‹time_created› TIMESTAMPTZ NOT NULL, ‹creator› STRING NOT NULL, ‹comment› STRING NOT NULL, ‹internal_dns_version› INT8 NOT NULL, ‹external_dns_version› INT8 NOT NULL, ‹cockroachdb_fingerprint› STRING NOT NULL, ‹cockroachdb_setting_preserve_downgrade› STRING)","Tag":"CREATE TABLE","User":"root","DescriptorID":303,"TableName":"‹omicron.public.blueprint›"}
264			I241018 22:57:45.439466 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 258 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_target› (‹version› INT8 PRIMARY KEY, ‹blueprint_id› UUID NOT NULL, ‹enabled› BOOL NOT NULL, ‹time_made_target› TIMESTAMPTZ NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":304,"TableName":"‹omicron.public.bp_target›"}
265			I241018 22:57:45.439472 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 259 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_sled_state› (‹blueprint_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹sled_state› omicron.public.sled_state NOT NULL, PRIMARY KEY (‹blueprint_id›, ‹sled_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":305,"TableName":"‹omicron.public.bp_sled_state›"}
266			I241018 22:57:45.439479 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 260 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_sled_omicron_physical_disks› (‹blueprint_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹generation› INT8 NOT NULL, PRIMARY KEY (‹blueprint_id›, ‹sled_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":306,"TableName":"‹omicron.public.bp_sled_omicron_physical_disks›"}
267			I241018 22:57:45.439485 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 261 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_omicron_physical_disk› (‹blueprint_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹vendor› STRING NOT NULL, ‹serial› STRING NOT NULL, ‹model› STRING NOT NULL, ‹id› UUID NOT NULL, ‹pool_id› UUID NOT NULL, PRIMARY KEY (‹blueprint_id›, ‹id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":307,"TableName":"‹omicron.public.bp_omicron_physical_disk›"}
268			I241018 22:57:45.439494 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 262 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_sled_omicron_zones› (‹blueprint_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹generation› INT8 NOT NULL, PRIMARY KEY (‹blueprint_id›, ‹sled_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":308,"TableName":"‹omicron.public.bp_sled_omicron_zones›"}
269			I241018 22:57:45.439502 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 263 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_omicron_zone› (‹blueprint_id› UUID NOT NULL, ‹sled_id› UUID NOT NULL, ‹id› UUID NOT NULL, ‹underlay_address› INET NOT NULL, ‹zone_type› omicron.public.zone_type NOT NULL, ‹primary_service_ip› INET NOT NULL, ‹primary_service_port› INT4 NOT NULL, ‹second_service_ip› INET, ‹second_service_port› INT4, ‹dataset_zpool_name› STRING, ‹bp_nic_id› UUID, ‹dns_gz_address› INET, ‹dns_gz_address_index› INT8, ‹ntp_ntp_servers› STRING[], ‹ntp_dns_servers› INET[], ‹ntp_domain› STRING, ‹nexus_external_tls› BOOL, ‹nexus_external_dns_servers› INET[], ‹snat_ip› INET, ‹snat_first_port› INT4, ‹snat_last_port› INT4, ‹disposition› omicron.public.bp_zone_disposition NOT NULL, ‹external_ip_id› UUID, ‹filesystem_pool› UUID, PRIMARY KEY (‹blueprint_id›, ‹id›), CHECK (‹primary_service_port› BETWEEN ‹0› AND ‹65535›), CHECK ((‹second_service_port› IS NULL) OR (‹second_service_port› BETWEEN ‹0› AND ‹65535›)), CHECK ((‹snat_first_port› IS NULL) OR (‹snat_first_port› BETWEEN ‹0› AND ‹65535›)), CHECK ((‹snat_last_port› IS NULL) OR (‹snat_last_port› BETWEEN ‹0› AND ‹65535›)))","Tag":"CREATE TABLE","User":"root","DescriptorID":309,"TableName":"‹omicron.public.bp_omicron_zone›"}
270			I241018 22:57:45.439517 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 264 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_omicron_zone_nic› (‹blueprint_id› UUID NOT NULL, ‹id› UUID NOT NULL, ‹name› STRING NOT NULL, ‹ip› INET NOT NULL, ‹mac› INT8 NOT NULL, ‹subnet› INET NOT NULL, ‹vni› INT8 NOT NULL, ‹is_primary› BOOL NOT NULL, ‹slot› INT2 NOT NULL, PRIMARY KEY (‹blueprint_id›, ‹id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":310,"TableName":"‹omicron.public.bp_omicron_zone_nic›"}
271			I241018 22:57:45.439525 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 265 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_clickhouse_cluster_config› (‹blueprint_id› UUID PRIMARY KEY, ‹generation› INT8 NOT NULL, ‹max_used_server_id› INT8 NOT NULL, ‹max_used_keeper_id› INT8 NOT NULL, ‹cluster_name› STRING NOT NULL, ‹cluster_secret› STRING NOT NULL, ‹highest_seen_keeper_leader_committed_log_index› INT8 NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":311,"TableName":"‹omicron.public.bp_clickhouse_cluster_config›"}
272			I241018 22:57:45.439532 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 266 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_clickhouse_keeper_zone_id_to_node_id› (‹blueprint_id› UUID NOT NULL, ‹omicron_zone_id› UUID NOT NULL, ‹keeper_id› INT8 NOT NULL, PRIMARY KEY (‹blueprint_id›, ‹omicron_zone_id›, ‹keeper_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":312,"TableName":"‹omicron.public.bp_clickhouse_keeper_zone_id_to_node_id›"}
273			I241018 22:57:45.439539 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 267 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bp_clickhouse_server_zone_id_to_node_id› (‹blueprint_id› UUID NOT NULL, ‹omicron_zone_id› UUID NOT NULL, ‹server_id› INT8 NOT NULL, PRIMARY KEY (‹blueprint_id›, ‹omicron_zone_id›, ‹server_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":313,"TableName":"‹omicron.public.bp_clickhouse_server_zone_id_to_node_id›"}
274			I241018 22:57:45.439546 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 268 ={"Timestamp":1729292264415881370,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹cockroachdb_zone_id_to_node_id› (‹omicron_zone_id› UUID NOT NULL UNIQUE, ‹crdb_node_id› STRING NOT NULL UNIQUE, PRIMARY KEY (‹omicron_zone_id›, ‹crdb_node_id›))","Tag":"CREATE TABLE","User":"root","DescriptorID":314,"TableName":"‹omicron.public.cockroachdb_zone_id_to_node_id›"}
275			I241018 22:57:46.054507 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 269 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹vmm› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹instance_id› UUID NOT NULL, ‹time_state_updated› TIMESTAMPTZ NOT NULL, ‹state_generation› INT8 NOT NULL, ‹sled_id› UUID NOT NULL, ‹propolis_ip› INET NOT NULL, ‹propolis_port› INT4 NOT NULL DEFAULT ‹12400›, ‹state› omicron.public.vmm_state NOT NULL, CHECK (‹propolis_port› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":315,"TableName":"‹omicron.public.vmm›"}
276			I241018 22:57:46.054542 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 270 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_vmms_by_sled_id› ON ‹omicron›.public.‹vmm› (‹sled_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":315,"TableName":"‹omicron.public.vmm›","IndexName":"‹lookup_vmms_by_sled_id›"}
277			I241018 22:57:46.054554 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 271 ={"Timestamp":1729292265694536565,"EventType":"create_view","Statement":"CREATE OR REPLACE VIEW ‹omicron›.public.‹sled_instance› AS SELECT ‹instance›.‹id›, ‹instance›.‹name›, ‹silo›.‹name› AS ‹silo_name›, ‹project›.‹name› AS ‹project_name›, ‹vmm›.‹sled_id› AS ‹active_sled_id›, ‹instance›.‹time_created›, ‹instance›.‹time_modified›, ‹instance›.‹migration_id›, ‹instance›.‹ncpus›, ‹instance›.‹memory›, ‹vmm›.‹state› FROM ‹omicron›.public.‹instance› AS ‹instance› JOIN ‹omicron›.public.‹project› AS ‹project› ON ‹instance›.‹project_id› = ‹project›.‹id› JOIN ‹omicron›.public.‹silo› AS ‹silo› ON ‹project›.‹silo_id› = ‹silo›.‹id› JOIN ‹omicron›.public.‹vmm› AS ‹vmm› ON ‹instance›.‹active_propolis_id› = ‹vmm›.‹id› WHERE (‹instance›.‹time_deleted› IS NULL) AND (‹vmm›.‹time_deleted› IS NULL)","Tag":"CREATE VIEW","User":"root","DescriptorID":164,"ViewName":"‹omicron.public.sled_instance›","ViewQuery":"‹SELECT instance.id, instance.name, silo.name AS silo_name, project.name AS project_name, vmm.sled_id AS active_sled_id, instance.time_created, instance.time_modified, instance.migration_id, instance.ncpus, instance.memory, vmm.state FROM omicron.public.instance AS instance JOIN omicron.public.project AS project ON instance.project_id = project.id JOIN omicron.public.silo AS silo ON project.silo_id = silo.id JOIN omicron.public.vmm AS vmm ON instance.active_propolis_id = vmm.id WHERE (instance.time_deleted IS NULL) AND (vmm.time_deleted IS NULL)›"}
278			I241018 22:57:46.054582 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 272 ={"Timestamp":1729292265694536565,"EventType":"create_sequence","Statement":"CREATE SEQUENCE IF NOT EXISTS ‹omicron›.public.‹ipv4_nat_version› START 1 INCREMENT 1","Tag":"CREATE SEQUENCE","User":"root","DescriptorID":316,"SequenceName":"‹omicron.public.ipv4_nat_version›"}
279			I241018 22:57:46.054590 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 273 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹ipv4_nat_entry› (‹id› UUID PRIMARY KEY DEFAULT gen_random_uuid(), ‹external_address› INET NOT NULL, ‹first_port› INT4 NOT NULL, ‹last_port› INT4 NOT NULL, ‹sled_address› INET NOT NULL, ‹vni› INT4 NOT NULL, ‹mac› INT8 NOT NULL, ‹version_added› INT8 NOT NULL DEFAULT nextval(‹'omicron.public.ipv4_nat_version'›), ‹version_removed› INT8, ‹time_created› TIMESTAMPTZ NOT NULL DEFAULT now(), ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":317,"TableName":"‹omicron.public.ipv4_nat_entry›"}
280			I241018 22:57:46.054601 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 274 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹ipv4_nat_version_added› ON ‹omicron›.public.‹ipv4_nat_entry› (‹version_added›) STORING (‹external_address›, ‹first_port›, ‹last_port›, ‹sled_address›, ‹vni›, ‹mac›, ‹time_created›, ‹time_deleted›)","Tag":"CREATE INDEX","User":"root","DescriptorID":317,"TableName":"‹omicron.public.ipv4_nat_entry›","IndexName":"‹ipv4_nat_version_added›"}
281			I241018 22:57:46.054610 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 275 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹overlapping_ipv4_nat_entry› ON ‹omicron›.public.‹ipv4_nat_entry› (‹external_address›, ‹first_port›, ‹last_port›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":317,"TableName":"‹omicron.public.ipv4_nat_entry›","IndexName":"‹overlapping_ipv4_nat_entry›"}
282			I241018 22:57:46.054619 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 276 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹ipv4_nat_lookup› ON ‹omicron›.public.‹ipv4_nat_entry› (‹external_address›, ‹first_port›, ‹last_port›, ‹sled_address›, ‹vni›, ‹mac›)","Tag":"CREATE INDEX","User":"root","DescriptorID":317,"TableName":"‹omicron.public.ipv4_nat_entry›","IndexName":"‹ipv4_nat_lookup›"}
283			I241018 22:57:46.054629 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 277 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹ipv4_nat_version_removed› ON ‹omicron›.public.‹ipv4_nat_entry› (‹version_removed›) STORING (‹external_address›, ‹first_port›, ‹last_port›, ‹sled_address›, ‹vni›, ‹mac›, ‹time_created›, ‹time_deleted›)","Tag":"CREATE INDEX","User":"root","DescriptorID":317,"TableName":"‹omicron.public.ipv4_nat_entry›","IndexName":"‹ipv4_nat_version_removed›"}
284			I241018 22:57:46.054639 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 278 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹bfd_mode› AS ENUM ('single_hop', 'multi_hop')","Tag":"CREATE TYPE","User":"root","DescriptorID":318,"TypeName":"‹omicron.public.bfd_mode›"}
285			I241018 22:57:46.054646 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 279 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bfd_session› (‹id› UUID PRIMARY KEY, ‹local› INET, ‹remote› INET NOT NULL, ‹detection_threshold› INT8 NOT NULL, ‹required_rx› INT8 NOT NULL, ‹switch› STRING NOT NULL, ‹mode› omicron.public.bfd_mode, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":320,"TableName":"‹omicron.public.bfd_session›"}
286			I241018 22:57:46.054656 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 280 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_bfd_session› ON ‹omicron›.public.‹bfd_session› (‹remote›, ‹switch›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":320,"TableName":"‹omicron.public.bfd_session›","IndexName":"‹lookup_bfd_session›"}
287			I241018 22:57:46.054664 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 281 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹ipv4_nat_lookup_by_vni› ON ‹omicron›.public.‹ipv4_nat_entry› (‹vni›) STORING (‹external_address›, ‹first_port›, ‹last_port›, ‹sled_address›, ‹mac›, ‹version_added›, ‹version_removed›, ‹time_created›, ‹time_deleted›)","Tag":"CREATE INDEX","User":"root","DescriptorID":317,"TableName":"‹omicron.public.ipv4_nat_entry›","IndexName":"‹ipv4_nat_lookup_by_vni›"}
288			I241018 22:57:46.054673 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 282 ={"Timestamp":1729292265694536565,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹ipv4_nat_changes› AS WITH ‹interleaved_versions› AS (SELECT ‹external_address›, ‹first_port›, ‹last_port›, ‹sled_address›, ‹vni›, ‹mac›, ‹version_added› AS ‹version›, (‹version_removed› IS NOT NULL) AS ‹deleted› FROM ‹omicron›.public.‹ipv4_nat_entry› WHERE ‹version_removed› IS NULL UNION SELECT ‹external_address›, ‹first_port›, ‹last_port›, ‹sled_address›, ‹vni›, ‹mac›, ‹version_removed› AS ‹version›, (‹version_removed› IS NOT NULL) AS ‹deleted› FROM ‹omicron›.public.‹ipv4_nat_entry› WHERE ‹version_removed› IS NOT NULL) SELECT ‹external_address›, ‹first_port›, ‹last_port›, ‹sled_address›, ‹vni›, ‹mac›, ‹version›, ‹deleted› FROM ‹\"\"›.‹\"\"›.‹interleaved_versions›","Tag":"CREATE VIEW","User":"root","DescriptorID":321,"ViewName":"‹omicron.public.ipv4_nat_changes›","ViewQuery":"‹WITH interleaved_versions AS (SELECT external_address, first_port, last_port, sled_address, vni, mac, version_added AS version, (version_removed IS NOT NULL) AS deleted FROM omicron.public.ipv4_nat_entry WHERE version_removed IS NULL UNION SELECT external_address, first_port, last_port, sled_address, vni, mac, version_removed AS version, (version_removed IS NOT NULL) AS deleted FROM omicron.public.ipv4_nat_entry WHERE version_removed IS NOT NULL) SELECT external_address, first_port, last_port, sled_address, vni, mac, version, deleted FROM interleaved_versions›"}
289			I241018 22:57:46.054697 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 283 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹probe› (‹id› UUID NOT NULL PRIMARY KEY, ‹name› STRING(63) NOT NULL, ‹description› STRING(512) NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹project_id› UUID NOT NULL, ‹sled› UUID NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":322,"TableName":"‹omicron.public.probe›"}
290			I241018 22:57:46.054706 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 284 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE UNIQUE INDEX IF NOT EXISTS ‹lookup_probe_by_name› ON ‹omicron›.public.‹probe› (‹name›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":322,"TableName":"‹omicron.public.probe›","IndexName":"‹lookup_probe_by_name›"}
291			I241018 22:57:46.054714 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 285 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹upstairs_repair_notification_type› AS ENUM ('started', 'succeeded', 'failed')","Tag":"CREATE TYPE","User":"root","DescriptorID":323,"TypeName":"‹omicron.public.upstairs_repair_notification_type›"}
292			I241018 22:57:46.054723 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 286 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹upstairs_repair_type› AS ENUM ('live', 'reconciliation')","Tag":"CREATE TYPE","User":"root","DescriptorID":325,"TypeName":"‹omicron.public.upstairs_repair_type›"}
293			I241018 22:57:46.054731 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 287 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹upstairs_repair_notification› (‹\"time\"› TIMESTAMPTZ NOT NULL, ‹repair_id› UUID NOT NULL, ‹repair_type› omicron.public.upstairs_repair_type NOT NULL, ‹upstairs_id› UUID NOT NULL, ‹session_id› UUID NOT NULL, ‹region_id› UUID NOT NULL, ‹target_ip› INET NOT NULL, ‹target_port› INT4 NOT NULL, ‹notification_type› omicron.public.upstairs_repair_notification_type NOT NULL, PRIMARY KEY (‹repair_id›, ‹upstairs_id›, ‹session_id›, ‹region_id›, ‹notification_type›), CHECK (‹target_port› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":327,"TableName":"‹omicron.public.upstairs_repair_notification›"}
294			I241018 22:57:46.054742 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 288 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹upstairs_repair_progress› (‹repair_id› UUID NOT NULL, ‹\"time\"› TIMESTAMPTZ NOT NULL, ‹current_item› INT8 NOT NULL, ‹total_items› INT8 NOT NULL, PRIMARY KEY (‹repair_id›, ‹\"time\"›, ‹current_item›, ‹total_items›))","Tag":"CREATE TABLE","User":"root","DescriptorID":328,"TableName":"‹omicron.public.upstairs_repair_progress›"}
295			I241018 22:57:46.054750 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 289 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹downstairs_client_stop_request_reason_type› AS ENUM ('replacing', 'disabled', 'failed_reconcile', 'io_error', 'bad_negotiation_order', 'incompatible', 'failed_live_repair', 'too_many_outstanding_jobs', 'deactivated')","Tag":"CREATE TYPE","User":"root","DescriptorID":329,"TypeName":"‹omicron.public.downstairs_client_stop_request_reason_type›"}
296			I241018 22:57:46.054757 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 290 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹downstairs_client_stop_request_notification› (‹\"time\"› TIMESTAMPTZ NOT NULL, ‹upstairs_id› UUID NOT NULL, ‹downstairs_id› UUID NOT NULL, ‹reason› omicron.public.downstairs_client_stop_request_reason_type NOT NULL, PRIMARY KEY (‹\"time\"›, ‹upstairs_id›, ‹downstairs_id›, ‹reason›))","Tag":"CREATE TABLE","User":"root","DescriptorID":331,"TableName":"‹omicron.public.downstairs_client_stop_request_notification›"}
297			I241018 22:57:46.054766 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 291 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹downstairs_client_stopped_reason_type› AS ENUM ('connection_timeout', 'connection_failed', 'timeout', 'write_failed', 'read_failed', 'requested_stop', 'finished', 'queue_closed', 'receive_task_cancelled')","Tag":"CREATE TYPE","User":"root","DescriptorID":332,"TypeName":"‹omicron.public.downstairs_client_stopped_reason_type›"}
298			I241018 22:57:46.054773 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 292 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹downstairs_client_stopped_notification› (‹\"time\"› TIMESTAMPTZ NOT NULL, ‹upstairs_id› UUID NOT NULL, ‹downstairs_id› UUID NOT NULL, ‹reason› omicron.public.downstairs_client_stopped_reason_type NOT NULL, PRIMARY KEY (‹\"time\"›, ‹upstairs_id›, ‹downstairs_id›, ‹reason›))","Tag":"CREATE TABLE","User":"root","DescriptorID":334,"TableName":"‹omicron.public.downstairs_client_stopped_notification›"}
299			I241018 22:57:46.054782 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 293 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹rack_initialized› ON ‹omicron›.public.‹rack› (‹initialized›)","Tag":"CREATE INDEX","User":"root","DescriptorID":109,"TableName":"‹omicron.public.rack›","IndexName":"‹rack_initialized›","MutationID":1}
300			I241018 22:57:46.054789 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 294 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹bootstore_config› (‹key› STRING NOT NULL, ‹generation› INT8 NOT NULL, PRIMARY KEY (‹key›, ‹generation›), ‹data› JSONB NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":335,"TableName":"‹omicron.public.bootstore_config›"}
301			I241018 22:57:46.054807 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 295 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹address_lot_names› ON ‹omicron›.public.‹address_lot› (‹name›)","Tag":"CREATE INDEX","User":"root","DescriptorID":236,"TableName":"‹omicron.public.address_lot›","IndexName":"‹address_lot_names›","MutationID":1}
302			I241018 22:57:46.054815 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 296 ={"Timestamp":1729292265694536565,"EventType":"create_view","Statement":"CREATE VIEW IF NOT EXISTS ‹omicron›.public.‹bgp_peer_view› AS SELECT ‹sp›.‹switch_location›, ‹sp›.‹port_name›, ‹bpc›.‹addr›, ‹bpc›.‹hold_time›, ‹bpc›.‹idle_hold_time›, ‹bpc›.‹delay_open›, ‹bpc›.‹connect_retry›, ‹bpc›.‹keepalive›, ‹bpc›.‹remote_asn›, ‹bpc›.‹min_ttl›, ‹bpc›.‹md5_auth_key›, ‹bpc›.‹multi_exit_discriminator›, ‹bpc›.‹local_pref›, ‹bpc›.‹enforce_first_as›, ‹bpc›.‹vlan_id›, ‹bc›.‹asn› FROM ‹omicron›.public.‹switch_port› AS ‹sp› JOIN ‹omicron›.public.‹switch_port_settings_bgp_peer_config› AS ‹bpc› ON ‹sp›.‹port_settings_id› = ‹bpc›.‹port_settings_id› JOIN ‹omicron›.public.‹bgp_config› AS ‹bc› ON ‹bc›.‹id› = ‹bpc›.‹bgp_config_id›","Tag":"CREATE VIEW","User":"root","DescriptorID":336,"ViewName":"‹omicron.public.bgp_peer_view›","ViewQuery":"‹SELECT sp.switch_location, sp.port_name, bpc.addr, bpc.hold_time, bpc.idle_hold_time, bpc.delay_open, bpc.connect_retry, bpc.keepalive, bpc.remote_asn, bpc.min_ttl, bpc.md5_auth_key, bpc.multi_exit_discriminator, bpc.local_pref, bpc.enforce_first_as, bpc.vlan_id, bc.asn FROM omicron.public.switch_port AS sp JOIN omicron.public.switch_port_settings_bgp_peer_config AS bpc ON sp.port_settings_id = bpc.port_settings_id JOIN omicron.public.bgp_config AS bc ON bc.id = bpc.bgp_config_id›"}
303			I241018 22:57:46.054836 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 297 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹switch_port_id_and_name› ON ‹omicron›.public.‹switch_port› (‹port_settings_id›, ‹port_name›) STORING (‹switch_location›)","Tag":"CREATE INDEX","User":"root","DescriptorID":240,"TableName":"‹omicron.public.switch_port›","IndexName":"‹switch_port_id_and_name›","MutationID":1}
304			I241018 22:57:46.054846 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 298 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹switch_port_name› ON ‹omicron›.public.‹switch_port› (‹port_name›)","Tag":"CREATE INDEX","User":"root","DescriptorID":240,"TableName":"‹omicron.public.switch_port›","IndexName":"‹switch_port_name›","MutationID":1}
305			I241018 22:57:46.054853 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 299 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹network_interface_by_parent› ON ‹omicron›.public.‹network_interface› (‹parent_id›) STORING (‹name›, ‹kind›, ‹vpc_id›, ‹subnet_id›, ‹mac›, ‹ip›, ‹slot›)","Tag":"CREATE INDEX","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›","IndexName":"‹network_interface_by_parent›","MutationID":1}
306			I241018 22:57:46.054864 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 300 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹sled_by_policy_and_state› ON ‹omicron›.public.‹sled› (‹sled_policy›, ‹sled_state›, ‹id›) STORING (‹ip›)","Tag":"CREATE INDEX","User":"root","DescriptorID":114,"TableName":"‹omicron.public.sled›","IndexName":"‹sled_by_policy_and_state›","MutationID":1}
307			I241018 22:57:46.054890 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 301 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹active_vmm› ON ‹omicron›.public.‹vmm› (‹time_deleted›, ‹sled_id›, ‹instance_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":315,"TableName":"‹omicron.public.vmm›","IndexName":"‹active_vmm›"}
308			I241018 22:57:46.054897 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 302 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹v2p_mapping_details› ON ‹omicron›.public.‹network_interface› (‹time_deleted›, ‹kind›, ‹subnet_id›, ‹vpc_id›, ‹parent_id›) STORING (‹mac›, ‹ip›)","Tag":"CREATE INDEX","User":"root","DescriptorID":182,"TableName":"‹omicron.public.network_interface›","IndexName":"‹v2p_mapping_details›","MutationID":1}
309			I241018 22:57:46.054905 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 303 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹sled_by_policy› ON ‹omicron›.public.‹sled› (‹sled_policy›) STORING (‹ip›, ‹sled_state›)","Tag":"CREATE INDEX","User":"root","DescriptorID":114,"TableName":"‹omicron.public.sled›","IndexName":"‹sled_by_policy›","MutationID":1}
310			I241018 22:57:46.054913 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 304 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹vmm_by_instance_id› ON ‹omicron›.public.‹vmm› (‹instance_id›) STORING (‹sled_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":315,"TableName":"‹omicron.public.vmm›","IndexName":"‹vmm_by_instance_id›"}
311			I241018 22:57:46.054920 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 305 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹region_replacement_state› AS ENUM ('requested', 'allocating', 'running', 'driving', 'replacement_done', 'completing', 'complete')","Tag":"CREATE TYPE","User":"root","DescriptorID":337,"TypeName":"‹omicron.public.region_replacement_state›"}
312			I241018 22:57:46.054928 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 306 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹region_replacement› (‹id› UUID PRIMARY KEY, ‹request_time› TIMESTAMPTZ NOT NULL, ‹old_region_id› UUID NOT NULL, ‹volume_id› UUID NOT NULL, ‹old_region_volume_id› UUID, ‹new_region_id› UUID, ‹replacement_state› omicron.public.region_replacement_state NOT NULL, ‹operating_saga_id› UUID)","Tag":"CREATE TABLE","User":"root","DescriptorID":339,"TableName":"‹omicron.public.region_replacement›"}
313			I241018 22:57:46.054936 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 307 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_replacement_by_state› ON ‹omicron›.public.‹region_replacement› (‹replacement_state›)","Tag":"CREATE INDEX","User":"root","DescriptorID":339,"TableName":"‹omicron.public.region_replacement›","IndexName":"‹lookup_region_replacement_by_state›"}
314			I241018 22:57:46.054945 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 308 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹volume_repair› (‹volume_id› UUID PRIMARY KEY, ‹repair_id› UUID NOT NULL)","Tag":"CREATE TABLE","User":"root","DescriptorID":340,"TableName":"‹omicron.public.volume_repair›"}
315			I241018 22:57:46.054952 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 309 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_volume_repair_by_repair_id› ON ‹omicron›.public.‹volume_repair› (‹repair_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":340,"TableName":"‹omicron.public.volume_repair›","IndexName":"‹lookup_volume_repair_by_repair_id›"}
316			I241018 22:57:46.054960 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 310 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹region_replacement_step_type› AS ENUM ('propolis', 'pantry')","Tag":"CREATE TYPE","User":"root","DescriptorID":341,"TypeName":"‹omicron.public.region_replacement_step_type›"}
317			I241018 22:57:46.054968 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 311 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹region_replacement_step› (‹replacement_id› UUID NOT NULL, ‹step_time› TIMESTAMPTZ NOT NULL, ‹step_type› omicron.public.region_replacement_step_type NOT NULL, ‹step_associated_instance_id› UUID, ‹step_associated_vmm_id› UUID, ‹step_associated_pantry_ip› INET, ‹step_associated_pantry_port› INT4, ‹step_associated_pantry_job_id› UUID, PRIMARY KEY (‹replacement_id›, ‹step_time›, ‹step_type›), CHECK (‹step_associated_pantry_port› BETWEEN ‹0› AND ‹65535›))","Tag":"CREATE TABLE","User":"root","DescriptorID":343,"TableName":"‹omicron.public.region_replacement_step›"}
318			I241018 22:57:46.054977 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 312 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹step_time_order› ON ‹omicron›.public.‹region_replacement_step› (‹step_time›)","Tag":"CREATE INDEX","User":"root","DescriptorID":343,"TableName":"‹omicron.public.region_replacement_step›","IndexName":"‹step_time_order›"}
319			I241018 22:57:46.054985 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 313 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹search_for_repair_notifications› ON ‹omicron›.public.‹upstairs_repair_notification› (‹region_id›, ‹notification_type›)","Tag":"CREATE INDEX","User":"root","DescriptorID":327,"TableName":"‹omicron.public.upstairs_repair_notification›","IndexName":"‹search_for_repair_notifications›"}
320			I241018 22:57:46.054995 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 314 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_any_disk_by_volume_id› ON ‹omicron›.public.‹disk› (‹volume_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":167,"TableName":"‹omicron.public.disk›","IndexName":"‹lookup_any_disk_by_volume_id›","MutationID":1}
321			I241018 22:57:46.055003 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 315 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_snapshot_by_destination_volume_id› ON ‹omicron›.public.‹snapshot› (‹destination_volume_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":173,"TableName":"‹omicron.public.snapshot›","IndexName":"‹lookup_snapshot_by_destination_volume_id›","MutationID":1}
322			I241018 22:57:46.055012 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 316 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹region_snapshot_replacement_state› AS ENUM ('requested', 'allocating', 'replacement_done', 'deleting_old_volume', 'running', 'complete')","Tag":"CREATE TYPE","User":"root","DescriptorID":344,"TypeName":"‹omicron.public.region_snapshot_replacement_state›"}
323			I241018 22:57:46.055020 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 317 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹region_snapshot_replacement› (‹id› UUID PRIMARY KEY, ‹request_time› TIMESTAMPTZ NOT NULL, ‹old_dataset_id› UUID NOT NULL, ‹old_region_id› UUID NOT NULL, ‹old_snapshot_id› UUID NOT NULL, ‹old_snapshot_volume_id› UUID, ‹new_region_id› UUID, ‹replacement_state› omicron.public.region_snapshot_replacement_state NOT NULL, ‹operating_saga_id› UUID)","Tag":"CREATE TABLE","User":"root","DescriptorID":346,"TableName":"‹omicron.public.region_snapshot_replacement›"}
324			I241018 22:57:46.055029 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 318 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_snapshot_replacement_by_state› ON ‹omicron›.public.‹region_snapshot_replacement› (‹replacement_state›)","Tag":"CREATE INDEX","User":"root","DescriptorID":346,"TableName":"‹omicron.public.region_snapshot_replacement›","IndexName":"‹lookup_region_snapshot_replacement_by_state›"}
325			I241018 22:57:46.055037 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 319 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹region_snapshot_replacement_step_state› AS ENUM ('requested', 'running', 'complete', 'volume_deleted')","Tag":"CREATE TYPE","User":"root","DescriptorID":347,"TypeName":"‹omicron.public.region_snapshot_replacement_step_state›"}
326			I241018 22:57:46.055045 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 320 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹region_snapshot_replacement_step› (‹id› UUID PRIMARY KEY, ‹request_id› UUID NOT NULL, ‹request_time› TIMESTAMPTZ NOT NULL, ‹volume_id› UUID NOT NULL, ‹old_snapshot_volume_id› UUID, ‹replacement_state› omicron.public.region_snapshot_replacement_step_state NOT NULL, ‹operating_saga_id› UUID)","Tag":"CREATE TABLE","User":"root","DescriptorID":349,"TableName":"‹omicron.public.region_snapshot_replacement_step›"}
327			I241018 22:57:46.055054 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 321 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_snapshot_replacement_step_by_state› ON ‹omicron›.public.‹region_snapshot_replacement_step› (‹replacement_state›)","Tag":"CREATE INDEX","User":"root","DescriptorID":349,"TableName":"‹omicron.public.region_snapshot_replacement_step›","IndexName":"‹lookup_region_snapshot_replacement_step_by_state›"}
328			I241018 22:57:46.055063 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 322 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_snapshot_replacement_step_by_old_volume_id› ON ‹omicron›.public.‹region_snapshot_replacement_step› (‹old_snapshot_volume_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":349,"TableName":"‹omicron.public.region_snapshot_replacement_step›","IndexName":"‹lookup_region_snapshot_replacement_step_by_old_volume_id›"}
329			I241018 22:57:46.055072 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 323 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹db_metadata› (‹singleton› BOOL NOT NULL PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹version› STRING(64) NOT NULL, ‹target_version› STRING(64), CHECK (‹singleton› = ‹true›))","Tag":"CREATE TABLE","User":"root","DescriptorID":350,"TableName":"‹omicron.public.db_metadata›"}
330			I241018 22:57:46.055081 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 324 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹allow_list› (‹id› UUID PRIMARY KEY, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_modified› TIMESTAMPTZ NOT NULL, ‹allowed_ips› INET[], CHECK (array_length(‹allowed_ips›, ‹1›) > ‹0›))","Tag":"CREATE TABLE","User":"root","DescriptorID":351,"TableName":"‹omicron.public.allow_list›"}
331			I241018 22:57:46.055088 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 325 ={"Timestamp":1729292265694536565,"EventType":"create_type","Statement":"CREATE TYPE IF NOT EXISTS ‹omicron›.‹public›.‹migration_state› AS ENUM ('pending', 'in_progress', 'failed', 'completed')","Tag":"CREATE TYPE","User":"root","DescriptorID":352,"TypeName":"‹omicron.public.migration_state›"}
332			I241018 22:57:46.055095 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 326 ={"Timestamp":1729292265694536565,"EventType":"create_table","Statement":"CREATE TABLE IF NOT EXISTS ‹omicron›.public.‹migration› (‹id› UUID PRIMARY KEY, ‹instance_id› UUID NOT NULL, ‹time_created› TIMESTAMPTZ NOT NULL, ‹time_deleted› TIMESTAMPTZ, ‹source_state› omicron.public.migration_state NOT NULL, ‹source_propolis_id› UUID NOT NULL, ‹source_gen› INT8 NOT NULL DEFAULT ‹1›, ‹time_source_updated› TIMESTAMPTZ, ‹target_state› omicron.public.migration_state NOT NULL, ‹target_propolis_id› UUID NOT NULL, ‹target_gen› INT8 NOT NULL DEFAULT ‹1›, ‹time_target_updated› TIMESTAMPTZ)","Tag":"CREATE TABLE","User":"root","DescriptorID":354,"TableName":"‹omicron.public.migration›"}
333			I241018 22:57:46.055104 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 327 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_migrations_by_instance_id› ON ‹omicron›.public.‹migration› (‹instance_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":354,"TableName":"‹omicron.public.migration›","IndexName":"‹lookup_migrations_by_instance_id›"}
334			I241018 22:57:46.055113 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 328 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹migrations_by_time_created› ON ‹omicron›.public.‹migration› (‹time_created›)","Tag":"CREATE INDEX","User":"root","DescriptorID":354,"TableName":"‹omicron.public.migration›","IndexName":"‹migrations_by_time_created›"}
335			I241018 22:57:46.055121 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 329 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_region_snapshot_by_snapshot_id› ON ‹omicron›.public.‹region_snapshot› (‹snapshot_id›)","Tag":"CREATE INDEX","User":"root","DescriptorID":137,"TableName":"‹omicron.public.region_snapshot›","IndexName":"‹lookup_region_snapshot_by_snapshot_id›","MutationID":1}
336			I241018 22:57:46.055129 765 5@util/log/event_log.go:32 ⋮ [n1,client=[::1]:41407,user=root] 330 ={"Timestamp":1729292265694536565,"EventType":"create_index","Statement":"CREATE INDEX IF NOT EXISTS ‹lookup_bgp_config_by_bgp_announce_set_id› ON ‹omicron›.public.‹bgp_config› (‹bgp_announce_set_id›) WHERE ‹time_deleted› IS NULL","Tag":"CREATE INDEX","User":"root","DescriptorID":262,"TableName":"‹omicron.public.bgp_config›","IndexName":"‹lookup_bgp_config_by_bgp_announce_set_id›","MutationID":1}
337			I241018 22:57:46.405817 3574 5@util/log/event_log.go:32 ⋮ [n1,job=1013258209882701825,scExec,id=182,mutation=1] 331 ={"Timestamp":1729292266384505661,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":182,"MutationID":1}
338			I241018 22:57:46.482551 3783 5@util/log/event_log.go:32 ⋮ [n1,job=1013258210052833281,scExec,id=173,mutation=1] 332 ={"Timestamp":1729292266473260649,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":173,"MutationID":1}
339			I241018 22:57:46.482939 3627 5@util/log/event_log.go:32 ⋮ [n1,job=1013258209834827777,scExec,id=236,mutation=1] 333 ={"Timestamp":1729292266474034884,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":236,"MutationID":1}
340			I241018 22:57:46.512459 3650 5@util/log/event_log.go:32 ⋮ [n1,job=1013258209821655041,scExec,id=109,mutation=1] 334 ={"Timestamp":1729292266494425429,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":109,"MutationID":1}
341			I241018 22:57:46.514863 3577 5@util/log/event_log.go:32 ⋮ [n1,job=1013258209892827137,scExec,id=114,mutation=1] 335 ={"Timestamp":1729292266497714222,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":114,"MutationID":1}
342			I241018 22:57:46.524234 3539 5@util/log/event_log.go:32 ⋮ [n1,job=1013258209854619649,scExec,id=240,mutation=1] 336 ={"Timestamp":1729292266510115353,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":240,"MutationID":1}
343			I241018 22:57:46.584787 3758 5@util/log/event_log.go:32 ⋮ [n1,job=1013258210590490625,scExec,id=137,mutation=1] 337 ={"Timestamp":1729292266577579552,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":137,"MutationID":1}
344			I241018 22:57:46.595100 3527 5@util/log/event_log.go:32 ⋮ [n1,job=1013258209856421889,scExec,id=262,mutation=1] 338 ={"Timestamp":1729292266587112724,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":262,"MutationID":1}
345			I241018 22:57:46.657163 3632 5@util/log/event_log.go:32 ⋮ [n1,job=1013258210043101185,scExec,id=167,mutation=1] 339 ={"Timestamp":1729292266648857497,"EventType":"finish_schema_change","InstanceID":1,"DescriptorID":167,"MutationID":1}