I250317 16:40:47.747687 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2025/03/17 16:40:47 I250317 16:40:47.747697 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01JPJCRW7YD5PCBB85PYNY4V9K› I250317 16:40:47.747704 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) I250317 16:40:47.747710 1 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:47.747726 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 I250317 16:40:47.747730 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 W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 + W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only. W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 + W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode: W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. W250317 16:40:47.745871 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. I250317 16:40:47.747843 1 1@cli/start.go:1196 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, I250317 16:40:47.747843 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: I250317 16:40:47.747843 1 1@cli/start.go:1196 ⋮ [n?] 2 + I250317 16:40:47.747843 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› I250317 16:40:47.747843 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html I250317 16:40:47.748109 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› W250317 16:40:47.748130 1 1@cli/start.go:1112 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› W250317 16:40:47.748130 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› W250317 16:40:47.748130 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).› I250317 16:40:47.748330 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› I250317 16:40:47.748346 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)› I250317 16:40:47.750344 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› I250317 16:40:47.750360 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 server configuration: I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 7.7 GiB› I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› I250317 16:40:47.750369 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› I250317 16:40:47.750429 1 1@cli/start.go:1090 ⋮ [n?] 10 using local environment variables: I250317 16:40:47.750429 1 1@cli/start.go:1090 ⋮ [n?] 10 +GOTRACEBACK=crash I250317 16:40:47.750429 1 1@cli/start.go:1090 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› I250317 16:40:47.750429 1 1@cli/start.go:1090 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› I250317 16:40:47.750429 1 1@cli/start.go:1090 ⋮ [n?] 10 +TZ=‹UTC› I250317 16:40:47.750438 1 1@cli/start.go:1097 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› W250317 16:40:47.750598 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› I250317 16:40:47.750643 1 1@cli/start.go:581 ⋮ [n?] 13 starting cockroach node I250317 16:40:48.012446 91 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized I250317 16:40:48.012573 91 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB I250317 16:40:48.012588 91 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 10000 I250317 16:40:48.012594 91 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpcTEl7B/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} I250317 16:40:48.014085 91 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/logs/inflight_trace_dump› I250317 16:40:48.077256 91 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled I250317 16:40:48.083327 91 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1742229648083325180 to catches up to 1742229648577247601 to ensure monotonicity. Delta: 493.922421ms I250317 16:40:48.083363 195 1@server/server.go:1319 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"20a8c400-683a-4de1-8185-1f5b43baac9d"› I250317 16:40:48.582214 91 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmpcTEl7B/listen-url› W250317 16:40:48.596108 91 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node I250317 16:40:48.596192 91 gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address: attrs:<> locality:<> ServerVersion: build_tag:"v22.1.22-29-g865aff1595" started_at:1742229648596186178 cluster_name:"" sql_address: http_address:› I250317 16:40:48.663872 195 1@server/server.go:1322 ⋮ [n1] 25 node connected via gossip I250317 16:40:48.664065 91 server/node.go:470 ⋮ [n1] 26 initialized store s1 I250317 16:40:48.664124 91 kv/kvserver/stores.go:250 ⋮ [n1] 27 read 0 node addresses from persistent storage I250317 16:40:48.670276 91 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2› I250317 16:40:48.670316 91 server/node.go:551 ⋮ [n1] 29 started with attributes [] I250317 16:40:48.670383 91 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/logs/goroutine_dump› I250317 16:40:48.670408 91 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/logs/heap_profiler› at least every 1h0m0s I250317 16:40:48.670424 91 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32 to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf" I250317 16:40:48.670435 91 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/logs/heap_profiler› at last every 1h0m0s I250317 16:40:48.670593 91 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/logs/heap_profiler› I250317 16:40:48.670668 91 1@server/server.go:1458 ⋮ [n1] 35 starting http server at ‹[::1]:44279› (use: ‹[::1]:44279›) I250317 16:40:48.670695 91 1@server/server.go:1465 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:42081› I250317 16:40:48.670713 91 1@server/server.go:1466 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:42081› E250317 16:40:48.766237 296 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r3/1:‹/System/{NodeLive…-tsd}›] 38 1 matching stores are currently throttled: [‹s1: draining›] I250317 16:40:48.778291 304 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 39 spanconfig-subscriber: established range feed cache E250317 16:40:48.779280 301 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r26/1:‹/NamespaceTable/{30-Max}›] 40 1 matching stores are currently throttled: [‹s1: draining›] E250317 16:40:48.779403 308 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r2/1:‹/System/NodeLiveness{-Max}›] 41 1 matching stores are currently throttled: [‹s1: draining›] E250317 16:40:48.779463 308 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r1/1:‹/{Min-System/NodeL…}›] 42 1 matching stores are currently throttled: [‹s1: draining›] I250317 16:40:48.779478 308 kv/kvserver/queue.go:1206 ⋮ [n1,replicate] 43 purgatory is now empty E250317 16:40:48.779576 354 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r6/1:‹/Table/{SystemCon…-11}›] 44 1 matching stores are currently throttled: [‹s1: draining›] E250317 16:40:48.780088 355 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r16/1:‹/Table/2{0-1}›] 45 1 matching stores are currently throttled: [‹s1: draining›] I250317 16:40:48.780155 319 kv/kvserver/replica_rangefeed.go:698 ⋮ [n1,rangefeed=‹table-stats-cache›,s1,r16] 46 RangeFeed closed timestamp is empty E250317 16:40:48.785530 408 kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r43/1:‹/Table/{47-50}›] 47 1 matching stores are currently throttled: [‹s1: draining›] I250317 16:40:48.808851 91 1@util/log/event_log.go:32 ⋮ [n1] 48 ={"Timestamp":1742229648808847600,"EventType":"node_restart","NodeID":1,"StartedAt":1742229648596186178,"LastUp":1742227499064987979} I250317 16:40:48.808910 91 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 49 starting SQL liveness instance I250317 16:40:48.835515 790 sql/temporary_schema.go:514 ⋮ [n1] 50 running temporary object cleanup background job I250317 16:40:48.835788 792 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 51 starting sql-stats-worker with initial delay: 8m49.025597488s I250317 16:40:48.860717 772 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 52 inserted sqlliveness session bf4dbc04e21140f89b8ce9eaf312f237 I250317 16:40:48.860796 772 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 53 created new SQL liveness session bf4dbc04e21140f89b8ce9eaf312f237 I250317 16:40:48.874618 855 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 54 settings-watcher: established range feed cache I250317 16:40:48.875784 91 server/server_sql.go:1295 ⋮ [n1] 55 done ensuring all necessary startup migrations have run I250317 16:40:48.876046 869 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 56 tenant-settings-watcher: established range feed cache I250317 16:40:48.876351 863 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 57 system-config-cache: established range feed cache I250317 16:40:48.877906 865 jobs/job_scheduler.go:433 ⋮ [n1] 58 waiting 3m0s before scheduled jobs daemon start I250317 16:40:48.882039 790 sql/temporary_schema.go:559 ⋮ [n1] 59 found 0 temporary schemas I250317 16:40:48.882070 790 sql/temporary_schema.go:562 ⋮ [n1] 60 early exiting temporary schema cleaner as no temporary schemas were found I250317 16:40:48.882085 790 sql/temporary_schema.go:563 ⋮ [n1] 61 completed temporary object cleanup job I250317 16:40:48.882100 790 sql/temporary_schema.go:646 ⋮ [n1] 62 temporary object cleaner next scheduled to run at 2025-03-17 17:10:48.835492386 +0000 UTC I250317 16:40:48.894972 868 server/auto_upgrade.go:79 ⋮ [n1] 63 no need to upgrade, cluster already at the newest version I250317 16:40:48.943206 911 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 64 deleted session 9c50af16274f4bec837d62c0565722d1 which expired at 1742227536.920689863,0 I250317 16:40:48.988551 91 1@server/server_sql.go:1365 ⋮ [n1] 65 serving sql connections I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 node startup completed: I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +CockroachDB node starting at 2025-03-17 16:40:48.988609713 +0000 UTC (took 1.2s) I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +build: OSS v22.1.22-29-g865aff1595 @ 2024/11/04 18:35:23 (go1.17.13) I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +webui: ‹http://[::1]:44279› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +sql: ‹postgresql://root@[::1]:42081/defaultdb?sslmode=disable› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +sql (JDBC): ‹jdbc:postgresql://[::1]:42081/defaultdb?sslmode=disable&user=root› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +RPC client flags: ‹cockroach --host=[::1]:42081 --insecure› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +logs: ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/logs› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +temp dir: ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/cockroach-temp3825832145› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +external I/O path: ‹/var/tmp/omicron_tmp/.tmpcTEl7B/data/extern› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmpcTEl7B/data› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +storage engine: pebble I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +clusterID: ‹20a8c400-683a-4de1-8185-1f5b43baac9d› I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +status: restarted pre-existing node I250317 16:40:48.988711 91 1@cli/start.go:1033 ⋮ [n1] 66 +nodeID: 1 I250317 16:40:49.183278 925 server/diagnostics/update_checker.go:150 ⋮ [n1] 67 a new version is available: ‹25.1.1›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.1#v25-1-1› I250317 16:40:50.370666 210 1@gossip/gossip.go:1547 ⋮ [n1] 68 node has connected to cluster via gossip I250317 16:40:50.374443 210 kv/kvserver/stores.go:269 ⋮ [n1] 69 wrote 0 node addresses to persistent storage I250317 16:40:56.699414 1102 util/log/event_log.go:32 ⋮ [n1,client=[::1]:50470,user=root] 70 ={"Timestamp":1742229656653819497,"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›"} I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 +__level_____count____size___score______in__ingest(sz_cnt)____move(sz_cnt)___write(sz_cnt)____read___r-amp___w-amp I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + WAL 2 1.9 M - 1.9 M - - - - 1.9 M - - - 1.0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + 0 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + 1 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + 2 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + 3 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + 4 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + 5 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + 6 1 723 K - 1.2 M 0 B 0 0 B 0 723 K 1 1.2 M 1 0.6 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + total 1 723 K - 1.9 M 0 B 0 0 B 0 2.6 M 1 1.2 M 1 1.4 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + flush 0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 +compact 1 0 B 1.2 M 0 (size == estimated-debt, score = in-progress-bytes, in = num-in-progress) I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + ctype 1 0 0 0 0 0 (default, delete, elision, move, read, rewrite) I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + memtbl 2 64 M I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 +zmemtbl 0 0 B I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + ztbl 0 0 B I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + bcache 47 1.6 M 99.0% (score == hit-rate) I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + tcache 1 680 B 99.9% (score == hit-rate) I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + snaps 0 - 0 (score == earliest seq num) I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + titers 0 I250317 16:41:08.677025 202 kv/kvserver/store.go:3290 ⋮ [n1,s1] 71 + filter - - 90.5% (score == utility)