I260807 17:10:34.207611 665 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2026/08/07 17:10:34
I260807 17:10:34.207617 665 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01KZEHV8NNGTQAQ8MJ7CAX3682›
I260807 17:10:34.207622 665 util/log/file_sync_buffer.go:238 ⋮ [config]   binary: CockroachDB OSS v22.1.22-64-g86fdbfca06 (x86_64-linux-gnu, built 2026/03/18 01:46:58, go1.22.11)
I260807 17:10:34.207627 665 util/log/file_sync_buffer.go:238 ⋮ [config]   arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpB0BUuS/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpB0BUuS/listen-url› ‹--max-sql-memory› ‹256MiB›]
I260807 17:10:34.207637 665 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I260807 17:10:34.207640 665 util/log/file_sync_buffer.go:238 ⋮ [config]   line format: [IWEF]yymmdd hh:mm:ss.uuuuuu goid [chan@]file:line redactionmark \[tags\] [counter] msg
I260807 17:10:34.207519 665 12@util/log/event_log.go:32 ⋮ [n1] 1 ={"Timestamp":1786122634207515622,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":108,"IndexID":1,"DatabaseName":"omicron","TableName":"clickhouse_policy","IndexName":"clickhouse_policy_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:34.708483 665 12@util/log/event_log.go:32 ⋮ [n1] 2 ={"Timestamp":1786122634708476919,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":111,"IndexID":1,"DatabaseName":"omicron","TableName":"oximeter_read_policy","IndexName":"oximeter_read_policy_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:35.208584 665 12@util/log/event_log.go:32 ⋮ [n1] 3 ={"Timestamp":1786122635208581070,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":112,"IndexID":1,"DatabaseName":"omicron","TableName":"rack","IndexName":"rack_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:35.708767 665 12@util/log/event_log.go:32 ⋮ [n1] 4 ={"Timestamp":1786122635708759613,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":112,"IndexID":2,"DatabaseName":"omicron","TableName":"rack","IndexName":"rack_initialized","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:41.428635 +0000 UTC","SchemaName":"public"}
I260807 17:10:36.230217 665 12@util/log/event_log.go:32 ⋮ [n1] 5 ={"Timestamp":1786122636230212788,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":1,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:36.731299 665 12@util/log/event_log.go:32 ⋮ [n1] 6 ={"Timestamp":1786122636731295358,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":2,"DatabaseName":"omicron","TableName":"sled","IndexName":"commissioned_sled_uniqueness","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:37.233735 665 12@util/log/event_log.go:32 ⋮ [n1] 7 ={"Timestamp":1786122637233728657,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":4,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:37.734226 665 12@util/log/event_log.go:32 ⋮ [n1] 8 ={"Timestamp":1786122637734222944,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":6,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:38.234625 665 12@util/log/event_log.go:32 ⋮ [n1] 9 ={"Timestamp":1786122638234621321,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":8,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:41.428635 +0000 UTC","SchemaName":"public"}
I260807 17:10:38.735496 665 12@util/log/event_log.go:32 ⋮ [n1] 10 ={"Timestamp":1786122638735492660,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":10,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:41.428635 +0000 UTC","SchemaName":"public"}
I260807 17:10:39.235577 665 12@util/log/event_log.go:32 ⋮ [n1] 11 ={"Timestamp":1786122639235573864,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":122,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"sled_resource_vmm_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:39.735646 665 12@util/log/event_log.go:32 ⋮ [n1] 12 ={"Timestamp":1786122639735640009,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":122,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"lookup_vmm_resource_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:40.235895 665 12@util/log/event_log.go:32 ⋮ [n1] 13 ={"Timestamp":1786122640235891524,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":122,"IndexID":4,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"single_vmm_reservation_per_state","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:40.736130 665 12@util/log/event_log.go:32 ⋮ [n1] 14 ={"Timestamp":1786122640736122729,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":122,"IndexID":6,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"lookup_vmm_resource_by_instance","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:41.236357 665 12@util/log/event_log.go:32 ⋮ [n1] 15 ={"Timestamp":1786122641236353365,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":123,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:41.736430 665 12@util/log/event_log.go:32 ⋮ [n1] 16 ={"Timestamp":1786122641736425459,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":123,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_subnet_octet_key","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:42.244391 665 12@util/log/event_log.go:32 ⋮ [n1] 17 ={"Timestamp":1786122642244387771,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":123,"IndexID":3,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"lookup_subnet_allocation_by_rack_and_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:42.745439 665 12@util/log/event_log.go:32 ⋮ [n1] 18 ={"Timestamp":1786122642745435452,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":124,"IndexID":1,"DatabaseName":"omicron","TableName":"switch","IndexName":"switch_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:43.245627 665 12@util/log/event_log.go:32 ⋮ [n1] 19 ={"Timestamp":1786122643245623787,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":124,"IndexID":2,"DatabaseName":"omicron","TableName":"switch","IndexName":"lookup_switch_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:43.745969 665 12@util/log/event_log.go:32 ⋮ [n1] 20 ={"Timestamp":1786122643745964913,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":1,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"physical_disk_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:44.246572 665 12@util/log/event_log.go:32 ⋮ [n1] 21 ={"Timestamp":1786122644246567410,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":2,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"vendor_serial_model_unique","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:44.747026 665 12@util/log/event_log.go:32 ⋮ [n1] 22 ={"Timestamp":1786122644747022317,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":4,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_variant","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:45.249236 665 12@util/log/event_log.go:32 ⋮ [n1] 23 ={"Timestamp":1786122645249232754,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":6,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:45.749489 665 12@util/log/event_log.go:32 ⋮ [n1] 24 ={"Timestamp":1786122645749485790,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":1,"DatabaseName":"omicron","TableName":"physical_disk_adoption_request","IndexName":"physical_disk_adoption_request_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:46.249922 665 12@util/log/event_log.go:32 ⋮ [n1] 25 ={"Timestamp":1786122646249917946,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":2,"DatabaseName":"omicron","TableName":"physical_disk_adoption_request","IndexName":"physical_disk_adoption_request_by_physical_id","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:46.750423 665 12@util/log/event_log.go:32 ⋮ [n1] 26 ={"Timestamp":1786122646750419834,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":1,"DatabaseName":"omicron","TableName":"certificate","IndexName":"certificate_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:47.251348 665 12@util/log/event_log.go:32 ⋮ [n1] 27 ={"Timestamp":1786122647251345703,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":2,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_service","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:47.751585 665 12@util/log/event_log.go:32 ⋮ [n1] 28 ={"Timestamp":1786122647751582148,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":4,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_silo","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:48.252388 665 12@util/log/event_log.go:32 ⋮ [n1] 29 ={"Timestamp":1786122648252384297,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":136,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_collection","IndexName":"virtual_provisioning_collection_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:48.752686 665 12@util/log/event_log.go:32 ⋮ [n1] 30 ={"Timestamp":1786122648752681253,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":137,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_resource","IndexName":"virtual_provisioning_resource_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:49.253627 665 12@util/log/event_log.go:32 ⋮ [n1] 31 ={"Timestamp":1786122649253623212,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":138,"IndexID":1,"DatabaseName":"omicron","TableName":"zpool","IndexName":"zpool_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:49.753875 665 12@util/log/event_log.go:32 ⋮ [n1] 32 ={"Timestamp":1786122649753871408,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":138,"IndexID":2,"DatabaseName":"omicron","TableName":"zpool","IndexName":"lookup_zpool_by_disk","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:50.254075 665 12@util/log/event_log.go:32 ⋮ [n1] 33 ={"Timestamp":1786122650254071823,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":141,"IndexID":1,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"crucible_dataset_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:50.756218 665 12@util/log/event_log.go:32 ⋮ [n1] 34 ={"Timestamp":1786122650756215110,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":141,"IndexID":2,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_size_used","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:51.256835 665 12@util/log/event_log.go:32 ⋮ [n1] 35 ={"Timestamp":1786122651256829557,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":141,"IndexID":4,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_zpool","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:51.761880 665 12@util/log/event_log.go:32 ⋮ [n1] 36 ={"Timestamp":1786122651761873992,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":141,"IndexID":6,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_ip","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:52.262892 665 12@util/log/event_log.go:32 ⋮ [n1] 37 ={"Timestamp":1786122652262886888,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":144,"IndexID":1,"DatabaseName":"omicron","TableName":"region","IndexName":"region_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:52.763460 665 12@util/log/event_log.go:32 ⋮ [n1] 38 ={"Timestamp":1786122652763454243,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":144,"IndexID":2,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_volume","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:53.264340 665 12@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1786122653264336952,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":144,"IndexID":4,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_dataset","IndexType":"secondary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:53.765133 665 12@util/log/event_log.go:32 ⋮ [n1] 40 ={"Timestamp":1786122653765129899,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":144,"IndexID":6,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_regions_missing_ports","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:54.266094 665 12@util/log/event_log.go:32 ⋮ [n1] 41 ={"Timestamp":1786122654266090187,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":144,"IndexID":8,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_regions_by_read_only","IndexType":"secondary","CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}
I260807 17:10:54.766488 665 12@util/log/event_log.go:32 ⋮ [n1] 42 ={"Timestamp":1786122654766484972,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":145,"IndexID":1,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"region_snapshot_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2026-08-07 16:54:40.918398 +0000 UTC","SchemaName":"public"}