I250317 16:40:48.965617 866 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2025/03/17 16:40:48
I250317 16:40:48.965625 866 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01JPJCRW7YD5PCBB85PYNY4V9K›
I250317 16:40:48.965630 866 util/log/file_sync_buffer.go:238 ⋮ [config]   binary: CockroachDB OSS v22.1.22-29-g865aff1595 (x86_64-linux-gnu, built 2024/11/04 18:35:23, go1.17.13)
I250317 16:40:48.965635 866 util/log/file_sync_buffer.go:238 ⋮ [config]   arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpcTEl7B/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpcTEl7B/listen-url›]
I250317 16:40:48.965647 866 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I250317 16:40:48.965650 866 util/log/file_sync_buffer.go:238 ⋮ [config]   line format: [IWEF]yymmdd hh:mm:ss.uuuuuu goid [chan@]file:line redactionmark \[tags\] [counter] msg
I250317 16:40:48.965524 866 12@util/log/event_log.go:32 ⋮ [n1] 1 ={"Timestamp":1742229648965521695,"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":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:49.465970 866 12@util/log/event_log.go:32 ⋮ [n1] 2 ={"Timestamp":1742229649465964178,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":109,"IndexID":1,"DatabaseName":"omicron","TableName":"rack","IndexName":"rack_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:49.974812 866 12@util/log/event_log.go:32 ⋮ [n1] 3 ={"Timestamp":1742229649974808017,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":109,"IndexID":2,"DatabaseName":"omicron","TableName":"rack","IndexName":"rack_initialized","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:49.982648 +0000 UTC","SchemaName":"public"}
I250317 16:40:50.475894 866 12@util/log/event_log.go:32 ⋮ [n1] 4 ={"Timestamp":1742229650475878976,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":1,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:50.976519 866 12@util/log/event_log.go:32 ⋮ [n1] 5 ={"Timestamp":1742229650976514484,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":2,"DatabaseName":"omicron","TableName":"sled","IndexName":"commissioned_sled_uniqueness","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:51.477473 866 12@util/log/event_log.go:32 ⋮ [n1] 6 ={"Timestamp":1742229651477468009,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":4,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:51.978378 866 12@util/log/event_log.go:32 ⋮ [n1] 7 ={"Timestamp":1742229651978371943,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":6,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:52.482431 866 12@util/log/event_log.go:32 ⋮ [n1] 8 ={"Timestamp":1742229652482426744,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":8,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:49.982648 +0000 UTC","SchemaName":"public"}
I250317 16:40:52.983182 866 12@util/log/event_log.go:32 ⋮ [n1] 9 ={"Timestamp":1742229652983178105,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":10,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:49.982648 +0000 UTC","SchemaName":"public"}
I250317 16:40:53.483454 866 12@util/log/event_log.go:32 ⋮ [n1] 10 ={"Timestamp":1742229653483449444,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":115,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"sled_resource_vmm_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:54.002734 866 12@util/log/event_log.go:32 ⋮ [n1] 11 ={"Timestamp":1742229654002550796,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":115,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"lookup_vmm_resource_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:54.507977 866 12@util/log/event_log.go:32 ⋮ [n1] 12 ={"Timestamp":1742229654507971331,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":115,"IndexID":4,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"lookup_vmm_resource_by_instance","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:55.010713 866 12@util/log/event_log.go:32 ⋮ [n1] 13 ={"Timestamp":1742229655010708008,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":116,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:55.511469 866 12@util/log/event_log.go:32 ⋮ [n1] 14 ={"Timestamp":1742229655511462446,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":116,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_subnet_octet_key","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:56.011925 866 12@util/log/event_log.go:32 ⋮ [n1] 15 ={"Timestamp":1742229656011917457,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":116,"IndexID":3,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"lookup_subnet_allocation_by_rack_and_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:56.512024 866 12@util/log/event_log.go:32 ⋮ [n1] 16 ={"Timestamp":1742229656512017118,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":1,"DatabaseName":"omicron","TableName":"switch","IndexName":"switch_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:57.013000 866 12@util/log/event_log.go:32 ⋮ [n1] 17 ={"Timestamp":1742229657012990972,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":2,"DatabaseName":"omicron","TableName":"switch","IndexName":"lookup_switch_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:57.513053 866 12@util/log/event_log.go:32 ⋮ [n1] 18 ={"Timestamp":1742229657513047402,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":126,"IndexID":1,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"physical_disk_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:58.013394 866 12@util/log/event_log.go:32 ⋮ [n1] 19 ={"Timestamp":1742229658013389250,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":126,"IndexID":2,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"vendor_serial_model_unique","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:58.514311 866 12@util/log/event_log.go:32 ⋮ [n1] 20 ={"Timestamp":1742229658514304542,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":126,"IndexID":4,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_variant","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:59.014611 866 12@util/log/event_log.go:32 ⋮ [n1] 21 ={"Timestamp":1742229659014606929,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":126,"IndexID":6,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:40:59.515551 866 12@util/log/event_log.go:32 ⋮ [n1] 22 ={"Timestamp":1742229659515544191,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":127,"IndexID":1,"DatabaseName":"omicron","TableName":"certificate","IndexName":"certificate_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:00.015620 866 12@util/log/event_log.go:32 ⋮ [n1] 23 ={"Timestamp":1742229660015613802,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":127,"IndexID":2,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_service","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:00.516503 866 12@util/log/event_log.go:32 ⋮ [n1] 24 ={"Timestamp":1742229660516496293,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":127,"IndexID":4,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_silo","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:01.017465 866 12@util/log/event_log.go:32 ⋮ [n1] 25 ={"Timestamp":1742229661017459126,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":128,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_collection","IndexName":"virtual_provisioning_collection_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:01.518262 866 12@util/log/event_log.go:32 ⋮ [n1] 26 ={"Timestamp":1742229661518256104,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":129,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_resource","IndexName":"virtual_provisioning_resource_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:02.018550 866 12@util/log/event_log.go:32 ⋮ [n1] 27 ={"Timestamp":1742229662018543671,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":130,"IndexID":1,"DatabaseName":"omicron","TableName":"zpool","IndexName":"zpool_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:02.519695 866 12@util/log/event_log.go:32 ⋮ [n1] 28 ={"Timestamp":1742229662519686088,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":130,"IndexID":2,"DatabaseName":"omicron","TableName":"zpool","IndexName":"lookup_zpool_by_disk","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:03.025776 866 12@util/log/event_log.go:32 ⋮ [n1] 29 ={"Timestamp":1742229663025770377,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":1,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"crucible_dataset_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:03.526201 866 12@util/log/event_log.go:32 ⋮ [n1] 30 ={"Timestamp":1742229663526197097,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":2,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_size_used","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:04.026285 866 12@util/log/event_log.go:32 ⋮ [n1] 31 ={"Timestamp":1742229664026279258,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":4,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_zpool","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:04.527214 866 12@util/log/event_log.go:32 ⋮ [n1] 32 ={"Timestamp":1742229664527206310,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":6,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_ip","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:05.028060 866 12@util/log/event_log.go:32 ⋮ [n1] 33 ={"Timestamp":1742229665028052351,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":1,"DatabaseName":"omicron","TableName":"region","IndexName":"region_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:05.529133 866 12@util/log/event_log.go:32 ⋮ [n1] 34 ={"Timestamp":1742229665529126596,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":2,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_volume","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:06.029903 866 12@util/log/event_log.go:32 ⋮ [n1] 35 ={"Timestamp":1742229666029897804,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":4,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_dataset","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:06.530362 866 12@util/log/event_log.go:32 ⋮ [n1] 36 ={"Timestamp":1742229666530355594,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":6,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_regions_missing_ports","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:07.032514 866 12@util/log/event_log.go:32 ⋮ [n1] 37 ={"Timestamp":1742229667032507637,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":8,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_regions_by_read_only","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:07.533092 866 12@util/log/event_log.go:32 ⋮ [n1] 38 ={"Timestamp":1742229667533085040,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":1,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"region_snapshot_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:08.033630 866 12@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1742229668033624243,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":2,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_by_dataset","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:08.534724 866 12@util/log/event_log.go:32 ⋮ [n1] 40 ={"Timestamp":1742229668534717469,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":4,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_snapshot_by_region_id","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:09.034828 866 12@util/log/event_log.go:32 ⋮ [n1] 41 ={"Timestamp":1742229669034824201,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":6,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_snapshot_by_deleting","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}
I250317 16:41:09.536258 866 12@util/log/event_log.go:32 ⋮ [n1] 42 ={"Timestamp":1742229669536251515,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":135,"IndexID":8,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_snapshot_by_volume_reference","IndexType":"secondary","CreatedAt":"2025-03-17 16:04:47.359518 +0000 UTC","SchemaName":"public"}