I241009 22:27:47.893042 650 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2024/10/09 22:27:47 I241009 22:27:47.893055 650 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01J9SJYPAAMH99N23X9HXASMYF› I241009 22:27:47.893064 650 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) I241009 22:27:47.893073 650 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpHsdvu3/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpHsdvu3/listen-url›] I241009 22:27:47.893095 650 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 I241009 22:27:47.893101 650 util/log/file_sync_buffer.go:238 ⋮ [config] line format: [IWEF]yymmdd hh:mm:ss.uuuuuu goid [chan@]file:line redactionmark \[tags\] [counter] msg I241009 22:27:47.892706 650 12@util/log/event_log.go:32 ⋮ [n1] 1 ={"Timestamp":1728512867892703328,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":106,"IndexID":1,"DatabaseName":"omicron","TableName":"rack","IndexName":"rack_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:48.400484 650 12@util/log/event_log.go:32 ⋮ [n1] 2 ={"Timestamp":1728512868400459624,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":106,"IndexID":2,"DatabaseName":"omicron","TableName":"rack","IndexName":"rack_initialized","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:05.243015 +0000 UTC","SchemaName":"public"} I241009 22:27:48.900759 650 12@util/log/event_log.go:32 ⋮ [n1] 3 ={"Timestamp":1728512868900755255,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":111,"IndexID":1,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:49.621244 650 12@util/log/event_log.go:32 ⋮ [n1] 4 ={"Timestamp":1728512869401082745,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":111,"IndexID":2,"DatabaseName":"omicron","TableName":"sled","IndexName":"commissioned_sled_uniqueness","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:50.124227 650 12@util/log/event_log.go:32 ⋮ [n1] 5 ={"Timestamp":1728512870124222878,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":111,"IndexID":4,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:50.624909 650 12@util/log/event_log.go:32 ⋮ [n1] 6 ={"Timestamp":1728512870624903991,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":111,"IndexID":6,"DatabaseName":"omicron","TableName":"sled","IndexName":"lookup_sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:51.125022 650 12@util/log/event_log.go:32 ⋮ [n1] 7 ={"Timestamp":1728512871125014172,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":111,"IndexID":8,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy_and_state","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:05.243015 +0000 UTC","SchemaName":"public"} I241009 22:27:51.627464 650 12@util/log/event_log.go:32 ⋮ [n1] 8 ={"Timestamp":1728512871627461321,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":111,"IndexID":10,"DatabaseName":"omicron","TableName":"sled","IndexName":"sled_by_policy","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:05.243015 +0000 UTC","SchemaName":"public"} I241009 22:27:52.127948 650 12@util/log/event_log.go:32 ⋮ [n1] 9 ={"Timestamp":1728512872127943064,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_resource","IndexName":"sled_resource_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:52.629954 650 12@util/log/event_log.go:32 ⋮ [n1] 10 ={"Timestamp":1728512872629949314,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":114,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_resource","IndexName":"lookup_resource_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:53.130483 650 12@util/log/event_log.go:32 ⋮ [n1] 11 ={"Timestamp":1728512873130478624,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":115,"IndexID":1,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:53.630580 650 12@util/log/event_log.go:32 ⋮ [n1] 12 ={"Timestamp":1728512873630573706,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":115,"IndexID":2,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"sled_underlay_subnet_allocation_subnet_octet_key","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:54.130983 650 12@util/log/event_log.go:32 ⋮ [n1] 13 ={"Timestamp":1728512874130978132,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":115,"IndexID":3,"DatabaseName":"omicron","TableName":"sled_underlay_subnet_allocation","IndexName":"lookup_subnet_allocation_by_rack_and_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:54.631200 650 12@util/log/event_log.go:32 ⋮ [n1] 14 ={"Timestamp":1728512874631192678,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":116,"IndexID":1,"DatabaseName":"omicron","TableName":"switch","IndexName":"switch_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:55.137538 650 12@util/log/event_log.go:32 ⋮ [n1] 15 ={"Timestamp":1728512875137454815,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":116,"IndexID":2,"DatabaseName":"omicron","TableName":"switch","IndexName":"lookup_switch_by_rack","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:55.637624 650 12@util/log/event_log.go:32 ⋮ [n1] 16 ={"Timestamp":1728512875637619123,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":125,"IndexID":1,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"physical_disk_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:56.139307 650 12@util/log/event_log.go:32 ⋮ [n1] 17 ={"Timestamp":1728512876137712024,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":125,"IndexID":2,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"vendor_serial_model_unique","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:56.639887 650 12@util/log/event_log.go:32 ⋮ [n1] 18 ={"Timestamp":1728512876639880027,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":125,"IndexID":4,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_variant","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:57.140010 650 12@util/log/event_log.go:32 ⋮ [n1] 19 ={"Timestamp":1728512877140002737,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":125,"IndexID":6,"DatabaseName":"omicron","TableName":"physical_disk","IndexName":"lookup_physical_disk_by_sled","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:57.640418 650 12@util/log/event_log.go:32 ⋮ [n1] 20 ={"Timestamp":1728512877640410654,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":126,"IndexID":1,"DatabaseName":"omicron","TableName":"certificate","IndexName":"certificate_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:58.140560 650 12@util/log/event_log.go:32 ⋮ [n1] 21 ={"Timestamp":1728512878140552032,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":126,"IndexID":2,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_service","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:58.646807 650 12@util/log/event_log.go:32 ⋮ [n1] 22 ={"Timestamp":1728512878646775401,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":126,"IndexID":4,"DatabaseName":"omicron","TableName":"certificate","IndexName":"lookup_certificate_by_silo","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:59.146946 650 12@util/log/event_log.go:32 ⋮ [n1] 23 ={"Timestamp":1728512879146939899,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":127,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_collection","IndexName":"virtual_provisioning_collection_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:27:59.647056 650 12@util/log/event_log.go:32 ⋮ [n1] 24 ={"Timestamp":1728512879647046720,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":128,"IndexID":1,"DatabaseName":"omicron","TableName":"virtual_provisioning_resource","IndexName":"virtual_provisioning_resource_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:00.147169 650 12@util/log/event_log.go:32 ⋮ [n1] 25 ={"Timestamp":1728512880147162550,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":129,"IndexID":1,"DatabaseName":"omicron","TableName":"zpool","IndexName":"zpool_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:00.649608 650 12@util/log/event_log.go:32 ⋮ [n1] 26 ={"Timestamp":1728512880649602100,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":129,"IndexID":2,"DatabaseName":"omicron","TableName":"zpool","IndexName":"lookup_zpool_by_disk","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:01.149720 650 12@util/log/event_log.go:32 ⋮ [n1] 27 ={"Timestamp":1728512881149715351,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":132,"IndexID":1,"DatabaseName":"omicron","TableName":"dataset","IndexName":"dataset_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:01.650114 650 12@util/log/event_log.go:32 ⋮ [n1] 28 ={"Timestamp":1728512881650105048,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":132,"IndexID":2,"DatabaseName":"omicron","TableName":"dataset","IndexName":"lookup_dataset_by_size_used_crucible","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:02.150362 650 12@util/log/event_log.go:32 ⋮ [n1] 29 ={"Timestamp":1728512882150353342,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":132,"IndexID":4,"DatabaseName":"omicron","TableName":"dataset","IndexName":"lookup_dataset_by_size_used","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:02.650498 650 12@util/log/event_log.go:32 ⋮ [n1] 30 ={"Timestamp":1728512882650489972,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":132,"IndexID":6,"DatabaseName":"omicron","TableName":"dataset","IndexName":"lookup_dataset_by_zpool","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:03.150613 650 12@util/log/event_log.go:32 ⋮ [n1] 31 ={"Timestamp":1728512883150608692,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":1,"DatabaseName":"omicron","TableName":"region","IndexName":"region_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:03.650724 650 12@util/log/event_log.go:32 ⋮ [n1] 32 ={"Timestamp":1728512883650716343,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":2,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_volume","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:04.150827 650 12@util/log/event_log.go:32 ⋮ [n1] 33 ={"Timestamp":1728512884150819614,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":4,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_region_by_dataset","IndexType":"secondary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:04.650927 650 12@util/log/event_log.go:32 ⋮ [n1] 34 ={"Timestamp":1728512884650922045,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":133,"IndexID":6,"DatabaseName":"omicron","TableName":"region","IndexName":"lookup_regions_missing_ports","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:05.151030 650 12@util/log/event_log.go:32 ⋮ [n1] 35 ={"Timestamp":1728512885151024536,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":1,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"region_snapshot_pkey","IndexType":"primary","IsUnique":true,"CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:05.651296 650 12@util/log/event_log.go:32 ⋮ [n1] 36 ={"Timestamp":1728512885651290019,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":2,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_by_dataset","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:06.151484 650 12@util/log/event_log.go:32 ⋮ [n1] 37 ={"Timestamp":1728512886151477596,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":4,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_snapshot_by_region_id","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:06.651644 650 12@util/log/event_log.go:32 ⋮ [n1] 38 ={"Timestamp":1728512886651635355,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":6,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_snapshot_by_volume_reference","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:07.151752 650 12@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1728512887151745585,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":8,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_snapshot_by_snapshot_addr","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:03.976471 +0000 UTC","SchemaName":"public"} I241009 22:28:07.651884 650 12@util/log/event_log.go:32 ⋮ [n1] 40 ={"Timestamp":1728512887651875995,"EventType":"captured_index_usage_stats","LastRead":"0001-01-01 00:00:00 +0000 UTC","TableID":134,"IndexID":10,"DatabaseName":"omicron","TableName":"region_snapshot","IndexName":"lookup_region_snapshot_by_snapshot_id","IndexType":"secondary","CreatedAt":"2024-10-09 22:24:05.243015 +0000 UTC","SchemaName":"public"}