I250812 02:17:03.890135 527 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2025/08/12 02:17:03 I250812 02:17:03.890146 527 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01K2DXR3SK6JTECCH555K97F0W› I250812 02:17:03.890154 527 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) I250812 02:17:03.890166 527 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpileBtm/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpileBtm/listen-url›] I250812 02:17:03.890183 527 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 I250812 02:17:03.890187 527 util/log/file_sync_buffer.go:238 ⋮ [config] line format: [IWEF]yymmdd hh:mm:ss.uuuuuu goid [chan@]file:line redactionmark \[tags\] [counter] msg I250812 02:17:03.890046 527 12@util/log/event_log.go:32 ⋮ [n1] 1 ={"Timestamp":1754965023890042979,"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-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:04.391205 527 12@util/log/event_log.go:32 ⋮ [n1] 2 ={"Timestamp":1754965024391198365,"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":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:04.892353 527 12@util/log/event_log.go:32 ⋮ [n1] 3 ={"Timestamp":1754965024892348872,"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":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:05.393351 527 12@util/log/event_log.go:32 ⋮ [n1] 4 ={"Timestamp":1754965025393346685,"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":"2025-08-12 01:35:20.005318 +0000 UTC","SchemaName":"public"} I250812 02:17:05.893459 527 12@util/log/event_log.go:32 ⋮ [n1] 5 ={"Timestamp":1754965025893454475,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":1,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:06.393535 527 12@util/log/event_log.go:32 ⋮ [n1] 6 ={"Timestamp":1754965026393526654,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":2,"DatabaseName":"omicron","TableName":"sled","IndexName":"commissioned_sled_uniqueness","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:06.899575 527 12@util/log/event_log.go:32 ⋮ [n1] 7 ={"Timestamp":1754965026899570169,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":4,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:07.399891 527 12@util/log/event_log.go:32 ⋮ [n1] 8 ={"Timestamp":1754965027399887462,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":6,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:07.901053 527 12@util/log/event_log.go:32 ⋮ [n1] 9 ={"Timestamp":1754965027900101153,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":8,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:20.005318 +0000 UTC","SchemaName":"public"} I250812 02:17:08.401549 527 12@util/log/event_log.go:32 ⋮ [n1] 10 ={"Timestamp":1754965028401538304,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":117,"IndexID":10,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:20.005318 +0000 UTC","SchemaName":"public"} I250812 02:17:08.901946 527 12@util/log/event_log.go:32 ⋮ [n1] 11 ={"Timestamp":1754965028901938778,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":118,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"sled_resource_vmm_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:09.402959 527 12@util/log/event_log.go:32 ⋮ [n1] 12 ={"Timestamp":1754965029402951413,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":118,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"lookup_vmm_resource_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:09.903374 527 12@util/log/event_log.go:32 ⋮ [n1] 13 ={"Timestamp":1754965029903368807,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":118,"IndexID":4,"DatabaseName":"omicron","TableName":"sled_resource_vmm","IndexName":"lookup_vmm_resource_by_instance","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:10.404137 527 12@util/log/event_log.go:32 ⋮ [n1] 14 ={"Timestamp":1754965030404131628,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:10.904377 527 12@util/log/event_log.go:32 ⋮ [n1] 15 ={"Timestamp":1754965030904371809,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_subnet_octet_key","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:11.404465 527 12@util/log/event_log.go:32 ⋮ [n1] 16 ={"Timestamp":1754965031404459039,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":119,"IndexID":3,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"lookup_subnet_allocation_by_rack_and_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:11.905434 527 12@util/log/event_log.go:32 ⋮ [n1] 17 ={"Timestamp":1754965031905428412,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":120,"IndexID":1,"DatabaseName":"omicron","TableName":"switch","IndexName":"switch_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:12.406524 527 12@util/log/event_log.go:32 ⋮ [n1] 18 ={"Timestamp":1754965032406511758,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":120,"IndexID":2,"DatabaseName":"omicron","TableName":"switch","IndexName":"lookup_switch_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:12.907349 527 12@util/log/event_log.go:32 ⋮ [n1] 19 ={"Timestamp":1754965032907342119,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":129,"IndexID":1,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"physical_disk_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:13.408083 527 12@util/log/event_log.go:32 ⋮ [n1] 20 ={"Timestamp":1754965033408076289,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":129,"IndexID":2,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"vendor_serial_model_unique","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:13.908869 527 12@util/log/event_log.go:32 ⋮ [n1] 21 ={"Timestamp":1754965033908861439,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":129,"IndexID":4,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_variant","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:14.409772 527 12@util/log/event_log.go:32 ⋮ [n1] 22 ={"Timestamp":1754965034409765222,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":129,"IndexID":6,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:14.910147 527 12@util/log/event_log.go:32 ⋮ [n1] 23 ={"Timestamp":1754965034910141605,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":130,"IndexID":1,"DatabaseName":"omicron","TableName":"certificate","IndexName":"certificate_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:15.411197 527 12@util/log/event_log.go:32 ⋮ [n1] 24 ={"Timestamp":1754965035411189781,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":130,"IndexID":2,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_service","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:15.911860 527 12@util/log/event_log.go:32 ⋮ [n1] 25 ={"Timestamp":1754965035911854319,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":130,"IndexID":4,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_silo","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:16.412146 527 12@util/log/event_log.go:32 ⋮ [n1] 26 ={"Timestamp":1754965036412141052,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":131,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_collection","IndexName":"virtual_provisioning_collection_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:16.912879 527 12@util/log/event_log.go:32 ⋮ [n1] 27 ={"Timestamp":1754965036912871591,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":132,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_resource","IndexName":"virtual_provisioning_resource_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:17.413733 527 12@util/log/event_log.go:32 ⋮ [n1] 28 ={"Timestamp":1754965037413728113,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":1,"DatabaseName":"omicron","TableName":"zpool","IndexName":"zpool_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:17.914491 527 12@util/log/event_log.go:32 ⋮ [n1] 29 ={"Timestamp":1754965037914485713,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":2,"DatabaseName":"omicron","TableName":"zpool","IndexName":"lookup_zpool_by_disk","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:18.415344 527 12@util/log/event_log.go:32 ⋮ [n1] 30 ={"Timestamp":1754965038415338625,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":136,"IndexID":1,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"crucible_dataset_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:18.915469 527 12@util/log/event_log.go:32 ⋮ [n1] 31 ={"Timestamp":1754965038915465645,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":136,"IndexID":2,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_size_used","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:19.416193 527 12@util/log/event_log.go:32 ⋮ [n1] 32 ={"Timestamp":1754965039416186544,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":136,"IndexID":4,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_zpool","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:19.916765 527 12@util/log/event_log.go:32 ⋮ [n1] 33 ={"Timestamp":1754965039916758421,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":136,"IndexID":6,"DatabaseName":"omicron","TableName":"crucible_dataset","IndexName":"lookup_crucible_dataset_by_ip","IndexType":"secondary","CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:20.417183 527 12@util/log/event_log.go:32 ⋮ [n1] 34 ={"Timestamp":1754965040417180656,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":139,"IndexID":1,"DatabaseName":"omicron","TableName":"region","IndexName":"region_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:20.918133 527 12@util/log/event_log.go:32 ⋮ [n1] 35 ={"Timestamp":1754965040918125889,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":139,"IndexID":2,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_volume","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"} I250812 02:17:21.422405 527 12@util/log/event_log.go:32 ⋮ [n1] 36 ={"Timestamp":1754965041422399146,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":139,"IndexID":4,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_dataset","IndexType":"secondary","IsUnique":true,"CreatedAt":"2025-08-12 01:35:19.244586 +0000 UTC","SchemaName":"public"}