I250307 23:25:42.653079 1 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2025/03/07 23:25:42
I250307 23:25:42.653091 1 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01JNSBCF62YQNNN8V58898SVCT›
I250307 23:25:42.653107 1 util/log/file_sync_buffer.go:238 ⋮ [config]   binary: CockroachDB OSS v22.1.22-29-g865aff1595 (x86_64-pc-solaris2.11, built 2024/11/04 18:39:00, go1.17.13)
I250307 23:25:42.653121 1 util/log/file_sync_buffer.go:238 ⋮ [config]   arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmp7gNCNN/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmp7gNCNN/listen-url›]
I250307 23:25:42.653155 1 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I250307 23:25:42.653177 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
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1  ALL SECURITY CONTROLS HAVE BEEN DISABLED!
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only.
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode:
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
W250307 23:25:42.652788 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
I250307 23:25:42.653350 1 1@cli/start.go:1196 ⋮ [n?] 2  To start a secure server without mandating TLS for clients,
I250307 23:25:42.653350 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
I250307 23:25:42.653350 1 1@cli/start.go:1196 ⋮ [n?] 2 +
I250307 23:25:42.653350 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
I250307 23:25:42.653350 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
W250307 23:25:42.653422 1 1@cli/start.go:1112 ⋮ [n?] 3  ‹Using the default setting for --cache (128 MiB).›
W250307 23:25:42.653422 1 1@cli/start.go:1112 ⋮ [n?] 3 +‹  A significantly larger value is usually needed for good performance.›
W250307 23:25:42.653422 1 1@cli/start.go:1112 ⋮ [n?] 3 +‹  If you have a dedicated server a reasonable setting is 25% of physical memory.›
I250307 23:25:42.653491 1 1@cli/start.go:1225 ⋮ [n?] 4  ‹CockroachDB OSS v22.1.22-29-g865aff1595 (x86_64-pc-solaris2.11, built 2024/11/04 18:39:00, go1.17.13)›
I250307 23:25:42.654172 1 server/config.go:485 ⋮ [n?] 5  unable to retrieve system total memory: ‹not implemented on illumos›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6  server configuration:
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹max offset             500000000›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹cache size             128 MiB›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹SQL memory pool size   128 MiB›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹scan interval          10m0s›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹scan min idle time     10ms›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹scan max idle time     1s›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹event log enabled      true›
I250307 23:25:42.654271 1 server/config.go:489 ⋮ [n?] 6 +‹span configs enabled   true›
I250307 23:25:42.654472 1 1@cli/start.go:1090 ⋮ [n?] 7  using local environment variables:
I250307 23:25:42.654472 1 1@cli/start.go:1090 ⋮ [n?] 7 +GOTRACEBACK=crash
I250307 23:25:42.654472 1 1@cli/start.go:1090 ⋮ [n?] 7 +LANG=‹en_US.UTF-8›
I250307 23:25:42.654472 1 1@cli/start.go:1090 ⋮ [n?] 7 +LC_ALL=‹en_US.UTF-8›
I250307 23:25:42.654472 1 1@cli/start.go:1090 ⋮ [n?] 7 +TZ=‹UTC›
I250307 23:25:42.654519 1 1@cli/start.go:1097 ⋮ [n?] 8  process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
W250307 23:25:42.654925 1 1@cli/start.go:1310 ⋮ [n?] 9  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: ld.so.1: cockroach: fatal: /usr/local/lib/cockroach/libgeos.so: open failed: No such file or directory›
I250307 23:25:42.655016 1 1@cli/start.go:581 ⋮ [n?] 10  starting cockroach node
I250307 23:25:42.779823 82 server/config.go:665 ⋮ [n?] 11  1 storage engine‹› initialized
I250307 23:25:42.779855 82 server/config.go:668 ⋮ [n?] 12  Pebble cache size: 128 MiB
I250307 23:25:42.779878 82 server/config.go:668 ⋮ [n?] 13  store 0: max size 0 B, max open file limit 60536
I250307 23:25:42.779886 82 server/config.go:668 ⋮ [n?] 14  store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmp7gNCNN/data›, fs=zfs, blkdev=‹rpool/work›, mnt=‹/work› opts=‹rw,devices,setuid,nonbmand,exec,xattr,atime,dev=4350006›}}
E250307 23:25:42.780231 82 1@server/status/runtime.go:343 ⋮ [n?] 15  could not get initial disk IO counters: ‹not implemented yet›
E250307 23:25:42.780725 82 1@server/status/runtime.go:347 ⋮ [n?] 16  could not get initial disk IO counters: ‹not implemented yet›
I250307 23:25:42.782977 82 server/tracedumper/tracedumper.go:120 ⋮ [n?] 17  writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmp7gNCNN/data/logs/inflight_trace_dump›
I250307 23:25:42.858577 82 1@server/clock_monotonicity.go:65 ⋮ [n?] 18  monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
I250307 23:25:42.861112 82 1@server/clock_monotonicity.go:140 ⋮ [n1] 19  Sleeping till wall time 1741389942861109430 to catches up to 1741389943358540669 to ensure monotonicity. Delta: 497.431239ms
I250307 23:25:42.861265 97 1@server/server.go:1319 ⋮ [n1] 20  connecting to gossip network to verify cluster ID ‹"ec081b70-a625-4bf7-a87c-2f7e89a2d6c1"›
I250307 23:25:43.363157 82 1@cli/start.go:521 ⋮ [n1] 21  listening URL file: ‹/var/tmp/omicron_tmp/.tmp7gNCNN/listen-url›
W250307 23:25:43.363649 82 1@gossip/gossip.go:1531 ⋮ [n1] 22  no addresses found; use --join to specify a connected node
I250307 23:25:43.363726 82 gossip/gossip.go:401 ⋮ [n1] 23  NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:35738" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-29-g865aff1595" started_at:1741389943363716078 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:35738" > http_address:<network_field:"tcp" address_field:"[::1]:34314" >›
I250307 23:25:43.391493 82 server/node.go:470 ⋮ [n1] 24  initialized store s1
I250307 23:25:43.391599 82 kv/kvserver/stores.go:250 ⋮ [n1] 25  read 0 node addresses from persistent storage
I250307 23:25:43.391827 82 server/node.go:549 ⋮ [n1] 26  started with engine type ‹2›
I250307 23:25:43.391867 82 server/node.go:551 ⋮ [n1] 27  started with attributes []
I250307 23:25:43.391967 82 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 28  writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmp7gNCNN/data/logs/goroutine_dump›
I250307 23:25:43.392050 82 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 29  writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmp7gNCNN/data/logs/heap_profiler› at least every 1h0m0s
I250307 23:25:43.392075 82 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 30  to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf"
I250307 23:25:43.392088 82 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 31  writing memory stats to ‹/var/tmp/omicron_tmp/.tmp7gNCNN/data/logs/heap_profiler› at last every 1h0m0s
I250307 23:25:43.392252 97 1@server/server.go:1322 ⋮ [n1] 32  node connected via gossip
W250307 23:25:43.392137 82 server/env_sampler.go:121 ⋮ [n1] 33  failed to start query profiler worker: failed to read ‹memory› cgroup from cgroups file: ‹/proc/self/cgroup›: open ‹/proc/self/cgroup›: no such file or directory
I250307 23:25:43.393409 82 1@server/server.go:1458 ⋮ [n1] 34  starting http server at ‹[::1]:34314› (use: ‹[::1]:34314›)
I250307 23:25:43.393454 82 1@server/server.go:1465 ⋮ [n1] 35  starting grpc/postgres server at ‹[::1]:35738›
I250307 23:25:43.393476 82 1@server/server.go:1466 ⋮ [n1] 36  advertising CockroachDB node at ‹[::1]:35738›
E250307 23:25:43.393531 82 server/status/recorder.go:420 ⋮ [n1,summaries] 37  could not get total system memory: ‹not implemented on illumos›
I250307 23:25:43.399720 336 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38  spanconfig-subscriber: established range feed cache
I250307 23:25:43.449812 312 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹spanconfig-subscriber›,s1,r43] 39  RangeFeed closed timestamp 1741388205.337980475,0 is behind by 28m58.111826789s
I250307 23:25:43.450457 82 1@util/log/event_log.go:32 ⋮ [n1] 40 ={"Timestamp":1741389943450449305,"EventType":"node_restart","NodeID":1,"StartedAt":1741389943363716078,"LastUp":1741388210872425932}
I250307 23:25:43.450507 82 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 41  starting SQL liveness instance
I250307 23:25:43.452984 531 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 42  starting sql-stats-worker with initial delay: 9m9.505864049s
I250307 23:25:43.453188 544 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 43  settings-watcher: established range feed cache
I250307 23:25:43.453294 529 sql/temporary_schema.go:514 ⋮ [n1] 44  running temporary object cleanup background job
I250307 23:25:43.453405 516 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 45  inserted sqlliveness session ad65a2b496f249959e3853c733950236
I250307 23:25:43.453445 516 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 46  created new SQL liveness session ad65a2b496f249959e3853c733950236
I250307 23:25:43.454121 463 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 47  system-config-cache: established range feed cache
I250307 23:25:43.454182 82 server/server_sql.go:1295 ⋮ [n1] 48  done ensuring all necessary startup migrations have run
I250307 23:25:43.454346 381 jobs/job_scheduler.go:433 ⋮ [n1] 49  waiting 3m0s before scheduled jobs daemon start
I250307 23:25:43.454418 385 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 50  tenant-settings-watcher: established range feed cache
I250307 23:25:43.454449 529 sql/temporary_schema.go:559 ⋮ [n1] 51  found 0 temporary schemas
I250307 23:25:43.454474 529 sql/temporary_schema.go:562 ⋮ [n1] 52  early exiting temporary schema cleaner as no temporary schemas were found
I250307 23:25:43.454488 529 sql/temporary_schema.go:563 ⋮ [n1] 53  completed temporary object cleanup job
I250307 23:25:43.454500 529 sql/temporary_schema.go:646 ⋮ [n1] 54  temporary object cleaner next scheduled to run at 2025-03-07 23:55:43.453250482 +0000 UTC
I250307 23:25:43.459316 384 server/auto_upgrade.go:79 ⋮ [n1] 55  no need to upgrade, cluster already at the newest version
I250307 23:25:43.472113 569 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56  deleted session 11b40a8ace154104bc49308c69616a6b which expired at 1741388248.277979278,0
I250307 23:25:43.505776 82 1@server/server_sql.go:1365 ⋮ [n1] 57  serving sql connections
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58  node startup completed:
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +CockroachDB node starting at 2025-03-07 23:25:43.50581905 +0000 UTC (took 0.9s)
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +build:               OSS v22.1.22-29-g865aff1595 @ 2024/11/04 18:39:00 (go1.17.13)
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +webui:               ‹http://[::1]:34314›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +sql:                 ‹postgresql://root@[::1]:35738/defaultdb?sslmode=disable›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +sql (JDBC):          ‹jdbc:postgresql://[::1]:35738/defaultdb?sslmode=disable&user=root›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +RPC client flags:    ‹cockroach <client cmd> --host=[::1]:35738 --insecure›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +logs:                ‹/var/tmp/omicron_tmp/.tmp7gNCNN/data/logs›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +temp dir:            ‹/var/tmp/omicron_tmp/.tmp7gNCNN/data/cockroach-temp619317171›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +external I/O path:   ‹/var/tmp/omicron_tmp/.tmp7gNCNN/data/extern›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +store[0]:            ‹path=/var/tmp/omicron_tmp/.tmp7gNCNN/data›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +storage engine:      pebble
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +clusterID:           ‹ec081b70-a625-4bf7-a87c-2f7e89a2d6c1›
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +status:              restarted pre-existing node
I250307 23:25:43.505929 82 1@cli/start.go:1033 ⋮ [n1] 58 +nodeID:              1
E250307 23:25:44.025705 641 server/status/recorder.go:420 ⋮ [n1] 59  could not get total system memory: ‹not implemented on illumos›
I250307 23:25:44.036591 640 server/diagnostics/update_checker.go:150 ⋮ [n1] 60  a new version is available: ‹25.1.0›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.1#v25-1-0›
I250307 23:25:45.398594 190 1@gossip/gossip.go:1547 ⋮ [n1] 61  node has connected to cluster via gossip
I250307 23:25:45.398693 190 kv/kvserver/stores.go:269 ⋮ [n1] 62  wrote 0 node addresses to persistent storage
I250307 23:25:50.405933 1690 kv/kvserver/replica_consistency.go:267 ⋮ [n1,consistencyChecker,s1,r4/1:‹/System{/tsd-tse}›] 63  triggering stats recomputation to resolve delta of {ContainsEstimates:5180 LastUpdateNanos:1741389943466123848 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}
I250307 23:25:50.800483 842 util/log/event_log.go:32 ⋮ [n1,client=[::1]:45860,user=root] 64 ={"Timestamp":1741389950796798852,"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›"}
E250307 23:25:53.394776 322 1@server/status/runtime.go:454 ⋮ [n1] 65  unable to get mem usage: ‹not implemented on illumos›
E250307 23:25:53.394870 322 1@server/status/runtime.go:458 ⋮ [n1] 66  unable to get cpu usage: ‹not implemented on illumos›
W250307 23:25:53.394927 322 1@server/status/runtime.go:468 ⋮ [n1] 67  unable to get file descriptor usage (will not try again): ‹not implemented on illumos›
W250307 23:25:53.394973 322 1@server/status/runtime.go:478 ⋮ [n1] 68  problem fetching disk stats: ‹not implemented yet›; disk stats will be empty.
W250307 23:25:53.395034 322 1@server/status/runtime.go:499 ⋮ [n1] 69  problem fetching net stats: ‹not implemented yet›; net stats will be empty.
E250307 23:25:53.399654 334 server/status/recorder.go:420 ⋮ [n1,summaries] 70  could not get total system memory: ‹not implemented on illumos›