I250812 02:17:02.893207 1 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2025/08/12 02:17:02
I250812 02:17:02.893212 1 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01K2DXR3SK6JTECCH555K97F0W›
I250812 02:17:02.893236 1 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:02.893242 1 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:02.893255 1 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I250812 02:17:02.893259 1 util/log/file_sync_buffer.go:238 ⋮ [config]   line format: [IWEF]yymmdd hh:mm:ss.uuuuuu goid [chan@]file:line redactionmark \[tags\] [counter] msg
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1  ALL SECURITY CONTROLS HAVE BEEN DISABLED!
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only.
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode:
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
W250812 02:17:02.893137 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
I250812 02:17:02.893355 1 1@cli/start.go:1196 ⋮ [n?] 2  To start a secure server without mandating TLS for clients,
I250812 02:17:02.893355 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
I250812 02:17:02.893355 1 1@cli/start.go:1196 ⋮ [n?] 2 +
I250812 02:17:02.893355 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
I250812 02:17:02.893355 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
I250812 02:17:02.893596 1 server/status/recorder.go:620 ⋮ [n?] 3  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
W250812 02:17:02.893614 1 1@cli/start.go:1112 ⋮ [n?] 4  ‹Using the default setting for --cache (128 MiB).›
W250812 02:17:02.893614 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹  A significantly larger value is usually needed for good performance.›
W250812 02:17:02.893614 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹  If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).›
I250812 02:17:02.893770 1 server/status/recorder.go:620 ⋮ [n?] 5  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I250812 02:17:02.893781 1 1@cli/start.go:1225 ⋮ [n?] 6  ‹CockroachDB OSS v22.1.22-29-g865aff1595 (x86_64-linux-gnu, built 2024/11/04 18:35:23, go1.17.13)›
I250812 02:17:02.894348 1 server/status/recorder.go:620 ⋮ [n?] 7  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I250812 02:17:02.894362 1 server/config.go:487 ⋮ [n?] 8  system total memory: 31 GiB
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9  server configuration:
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹max offset             500000000›
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹cache size             128 MiB›
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size   7.7 GiB›
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval          10m0s›
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time     10ms›
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time     1s›
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled      true›
I250812 02:17:02.894373 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled   true›
I250812 02:17:02.894454 1 1@cli/start.go:1090 ⋮ [n?] 10  using local environment variables:
I250812 02:17:02.894454 1 1@cli/start.go:1090 ⋮ [n?] 10 +GOTRACEBACK=crash
I250812 02:17:02.894454 1 1@cli/start.go:1090 ⋮ [n?] 10 +LANG=‹en_US.UTF-8›
I250812 02:17:02.894454 1 1@cli/start.go:1090 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8›
I250812 02:17:02.894454 1 1@cli/start.go:1090 ⋮ [n?] 10 +TZ=‹UTC›
I250812 02:17:02.894471 1 1@cli/start.go:1097 ⋮ [n?] 11  process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
W250812 02:17:02.894635 1 1@cli/start.go:1310 ⋮ [n?] 12  could not initialize GEOS - spatial functions may not be available: geos: error during GEOS init: geos: cannot load GEOS from dir ‹"/usr/local/lib/cockroach"›: ‹geos error: /usr/local/lib/cockroach/libgeos.so: cannot open shared object file: No such file or directory›
I250812 02:17:02.894686 1 1@cli/start.go:581 ⋮ [n?] 13  starting cockroach node
I250812 02:17:03.031159 72 server/config.go:665 ⋮ [n?] 14  1 storage engine‹› initialized
I250812 02:17:03.031196 72 server/config.go:668 ⋮ [n?] 15  Pebble cache size: 128 MiB
I250812 02:17:03.031209 72 server/config.go:668 ⋮ [n?] 16  store 0: max size 0 B, max open file limit 10000
I250812 02:17:03.034708 72 server/config.go:668 ⋮ [n?] 17  store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpileBtm/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}}
I250812 02:17:03.036417 72 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18  writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpileBtm/data/logs/inflight_trace_dump›
I250812 02:17:03.132962 72 1@server/clock_monotonicity.go:65 ⋮ [n?] 19  monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
I250812 02:17:03.143071 72 1@server/clock_monotonicity.go:140 ⋮ [n1] 20  Sleeping till wall time 1754965023143068135 to catches up to 1754965023632952534 to ensure monotonicity. Delta: 489.884399ms
I250812 02:17:03.143122 167 1@server/server.go:1319 ⋮ [n1] 21  connecting to gossip network to verify cluster ID ‹"65bfb73c-4228-4d3c-8dc6-0268727c7723"›
I250812 02:17:03.633986 72 1@cli/start.go:521 ⋮ [n1] 22  listening URL file: ‹/var/tmp/omicron_tmp/.tmpileBtm/listen-url›
W250812 02:17:03.643870 72 1@gossip/gossip.go:1531 ⋮ [n1] 23  no addresses found; use --join to specify a connected node
I250812 02:17:03.643951 72 gossip/gossip.go:401 ⋮ [n1] 24  NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:35299" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-29-g865aff1595" started_at:1754965023643943876 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:35299" > http_address:<network_field:"tcp" address_field:"[::1]:36883" >›
I250812 02:17:03.651475 72 server/node.go:470 ⋮ [n1] 25  initialized store s1
I250812 02:17:03.651524 72 kv/kvserver/stores.go:250 ⋮ [n1] 26  read 0 node addresses from persistent storage
I250812 02:17:03.652076 167 1@server/server.go:1322 ⋮ [n1] 27  node connected via gossip
I250812 02:17:03.655567 72 server/node.go:549 ⋮ [n1] 28  started with engine type ‹2›
I250812 02:17:03.655598 72 server/node.go:551 ⋮ [n1] 29  started with attributes []
I250812 02:17:03.655669 72 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30  writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpileBtm/data/logs/goroutine_dump›
I250812 02:17:03.655702 72 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31  writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpileBtm/data/logs/heap_profiler› at least every 1h0m0s
I250812 02:17:03.655719 72 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32  to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf"
I250812 02:17:03.655731 72 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33  writing memory stats to ‹/var/tmp/omicron_tmp/.tmpileBtm/data/logs/heap_profiler› at last every 1h0m0s
I250812 02:17:03.655897 72 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34  writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpileBtm/data/logs/heap_profiler›
I250812 02:17:03.655959 72 1@server/server.go:1458 ⋮ [n1] 35  starting http server at ‹[::1]:36883› (use: ‹[::1]:36883›)
I250812 02:17:03.655993 72 1@server/server.go:1465 ⋮ [n1] 36  starting grpc/postgres server at ‹[::1]:35299›
I250812 02:17:03.656012 72 1@server/server.go:1466 ⋮ [n1] 37  advertising CockroachDB node at ‹[::1]:35299›
I250812 02:17:03.675869 306 kv/kvserver/liveness/liveness.go:775 ⋮ [n1,liveness-hb] 38  heartbeat failed on epoch increment; retrying
E250812 02:17:03.679105 305 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r3/1:‹/System/{NodeLive…-tsd}›] 39  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.685316 317 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 40  spanconfig-subscriber: established range feed cache
E250812 02:17:03.687894 314 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r26/1:‹/NamespaceTable/{30-Max}›] 41  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.688009 283 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r2/1:‹/System/NodeLiveness{-Max}›] 42  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.688068 283 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r1/1:‹/{Min-System/NodeL…}›] 43  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.688087 283 kv/kvserver/queue.go:1206 ⋮ [n1,replicate] 44  purgatory is now empty
E250812 02:17:03.708617 124 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r43/1:‹/Table/{47-50}›] 45  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.711257 341 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r6/1:‹/Table/{SystemCon…-11}›] 46  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.712052 72 1@util/log/event_log.go:32 ⋮ [n1] 47 ={"Timestamp":1754965023712050435,"EventType":"node_restart","NodeID":1,"StartedAt":1754965023643943876,"LastUp":1754962521588483265}
I250812 02:17:03.712092 72 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 48  starting SQL liveness instance
E250812 02:17:03.714276 484 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r44/1:‹/Table/{50-112/2}›] 49  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.742917 507 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 50  settings-watcher: established range feed cache
E250812 02:17:03.743756 510 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r42/1:‹/Table/4{6-7}›] 51  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.743881 476 sql/temporary_schema.go:514 ⋮ [n1] 52  running temporary object cleanup background job
I250812 02:17:03.745341 478 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 53  starting sql-stats-worker with initial delay: 10m25.9717058s
I250812 02:17:03.745929 516 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 54  RangeFeed closed timestamp 1754962518.383692579,0 is behind by 41m45.362233817s
I250812 02:17:03.747484 72 server/server_sql.go:1295 ⋮ [n1] 55  done ensuring all necessary startup migrations have run
I250812 02:17:03.747809 546 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 56  tenant-settings-watcher: established range feed cache
I250812 02:17:03.747854 526 jobs/job_scheduler.go:433 ⋮ [n1] 57  waiting 4m0s before scheduled jobs daemon start
I250812 02:17:03.748057 524 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 58  system-config-cache: established range feed cache
E250812 02:17:03.757158 578 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r7/1:‹/Table/1{1-2}›] 59  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.757942 579 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r54/1:‹/Table/11{2/2-7/8}›] 60  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.763012 137 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r4/1:‹/System{/tsd-tse}›] 61  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.763167 141 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r35/1:‹/Table/{39-40}›] 62  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.763547 321 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 63  inserted sqlliveness session ef716cc2b39b4c8fbcfa27eb2c763c77
I250812 02:17:03.763577 321 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 64  created new SQL liveness session ef716cc2b39b4c8fbcfa27eb2c763c77
E250812 02:17:03.764153 595 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r56/1:‹/Table/117/{8-10}›] 65  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.765129 600 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r31/1:‹/Table/3{5-6}›] 66  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.765158 476 sql/temporary_schema.go:559 ⋮ [n1] 67  found 0 temporary schemas
I250812 02:17:03.765169 476 sql/temporary_schema.go:562 ⋮ [n1] 68  early exiting temporary schema cleaner as no temporary schemas were found
I250812 02:17:03.765177 476 sql/temporary_schema.go:563 ⋮ [n1] 69  completed temporary object cleanup job
I250812 02:17:03.765185 476 sql/temporary_schema.go:646 ⋮ [n1] 70  temporary object cleaner next scheduled to run at 2025-08-12 02:47:03.743859953 +0000 UTC
E250812 02:17:03.767040 617 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r8/1:‹/Table/1{2-3}›] 71  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.767119 618 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r33/1:‹/Table/3{7-8}›] 72  1 matching stores are currently throttled: [‹s1: draining›]
E250812 02:17:03.769165 580 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r11/1:‹/Table/1{5-6}›] 73  1 matching stores are currently throttled: [‹s1: draining›]
I250812 02:17:03.781280 72 1@server/server_sql.go:1365 ⋮ [n1] 74  serving sql connections
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75  node startup completed:
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +CockroachDB node starting at 2025-08-12 02:17:03.781319151 +0000 UTC (took 0.9s)
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +build:               OSS v22.1.22-29-g865aff1595 @ 2024/11/04 18:35:23 (go1.17.13)
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +webui:               ‹http://[::1]:36883›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +sql:                 ‹postgresql://root@[::1]:35299/defaultdb?sslmode=disable›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +sql (JDBC):          ‹jdbc:postgresql://[::1]:35299/defaultdb?sslmode=disable&user=root›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +RPC client flags:    ‹cockroach <client cmd> --host=[::1]:35299 --insecure›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +logs:                ‹/var/tmp/omicron_tmp/.tmpileBtm/data/logs›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +temp dir:            ‹/var/tmp/omicron_tmp/.tmpileBtm/data/cockroach-temp4263258851›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +external I/O path:   ‹/var/tmp/omicron_tmp/.tmpileBtm/data/extern›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +store[0]:            ‹path=/var/tmp/omicron_tmp/.tmpileBtm/data›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +storage engine:      pebble
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +clusterID:           ‹65bfb73c-4228-4d3c-8dc6-0268727c7723›
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +status:              restarted pre-existing node
I250812 02:17:03.781433 72 1@cli/start.go:1033 ⋮ [n1] 75 +nodeID:              1
I250812 02:17:03.793912 609 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 76  deleted session 1b9233a2a33440eab3f6219a703ce38c which expired at 1754962558.177188316,0
I250812 02:17:03.824229 529 server/auto_upgrade.go:79 ⋮ [n1] 77  no need to upgrade, cluster already at the newest version
I250812 02:17:03.829653 583 util/log/event_log.go:32 ⋮ [n1,client=[::1]:43432,user=root] 78 ={"Timestamp":1754965023785381786,"EventType":"set_cluster_setting","Statement":"SET CLUSTER SETTING \"kv.raft_log.disable_synchronization_unsafe\" = true","Tag":"SET CLUSTER SETTING","User":"root","SettingName":"kv.raft_log.disable_synchronization_unsafe","Value":"‹true›"}
I250812 02:17:04.086819 576 server/diagnostics/update_checker.go:150 ⋮ [n1] 79  a new version is available: ‹25.3.0-rc.1›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.3#v25-3-0-rc-1›
I250812 02:17:04.667479 841 kv/kvserver/replica_consistency.go:267 ⋮ [n1,consistencyChecker,s1,r4/1:‹/System{/tsd-tse}›] 80  triggering stats recomputation to resolve delta of {ContainsEstimates:5180 LastUpdateNanos:1754965023762097484 IntentAge:0 GCBytesAge:0 LiveBytes:-179498 LiveCount:-2590 KeyBytes:-138058 KeyCount:-2590 ValBytes:-41440 ValCount:-2590 IntentBytes:0 IntentCount:0 SeparatedIntentCount:0 SysBytes:0 SysCount:0 AbortSpanBytes:0}
I250812 02:17:06.071517 196 1@gossip/gossip.go:1547 ⋮ [n1] 81  node has connected to cluster via gossip
I250812 02:17:06.076646 196 kv/kvserver/stores.go:269 ⋮ [n1] 82  wrote 0 node addresses to persistent storage
I250812 02:17:09.811300 814 util/log/event_log.go:32 ⋮ [n1,client=[::1]:43436,user=root] 83 ={"Timestamp":1754965029807792600,"EventType":"set_cluster_setting","Statement":"SET CLUSTER SETTING \"cluster.preserve_downgrade_option\" = CASE encode(digest(crdb_internal.active_version() || crdb_internal.node_executable_version(), ‹'sha1'›), ‹'hex'›) = $1 WHEN ‹true› THEN $2 ELSE ‹NULL› END","Tag":"SET CLUSTER SETTING","User":"root","PlaceholderValues":["‹'d4d87aa2ad877a4cc2fddd0573952362739110de'›","‹'22.1'›"],"SettingName":"cluster.preserve_downgrade_option","Value":"‹22.1›"}