I250313 19:21:09.368360 1 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2025/03/13 19:21:09
I250313 19:21:09.368384 1 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01JP8BJPKS3GN7ZYTTJ4F0C973›
I250313 19:21:09.368406 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)
I250313 19:21:09.368416 1 util/log/file_sync_buffer.go:238 ⋮ [config]   arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmp79Wz6I/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmp79Wz6I/listen-url›]
I250313 19:21:09.368453 1 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I250313 19:21:09.368533 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
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1  ALL SECURITY CONTROLS HAVE BEEN DISABLED!
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only.
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode:
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
W250313 19:21:09.368083 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
I250313 19:21:09.368936 1 1@cli/start.go:1196 ⋮ [n?] 2  To start a secure server without mandating TLS for clients,
I250313 19:21:09.368936 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
I250313 19:21:09.368936 1 1@cli/start.go:1196 ⋮ [n?] 2 +
I250313 19:21:09.368936 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
I250313 19:21:09.368936 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
W250313 19:21:09.369008 1 1@cli/start.go:1112 ⋮ [n?] 3  ‹Using the default setting for --cache (128 MiB).›
W250313 19:21:09.369008 1 1@cli/start.go:1112 ⋮ [n?] 3 +‹  A significantly larger value is usually needed for good performance.›
W250313 19:21:09.369008 1 1@cli/start.go:1112 ⋮ [n?] 3 +‹  If you have a dedicated server a reasonable setting is 25% of physical memory.›
I250313 19:21:09.369042 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)›
I250313 19:21:09.369379 1 server/config.go:485 ⋮ [n?] 5  unable to retrieve system total memory: ‹not implemented on illumos›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6  server configuration:
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹max offset             500000000›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹cache size             128 MiB›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹SQL memory pool size   128 MiB›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹scan interval          10m0s›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹scan min idle time     10ms›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹scan max idle time     1s›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹event log enabled      true›
I250313 19:21:09.369436 1 server/config.go:489 ⋮ [n?] 6 +‹span configs enabled   true›
I250313 19:21:09.369527 1 1@cli/start.go:1090 ⋮ [n?] 7  using local environment variables:
I250313 19:21:09.369527 1 1@cli/start.go:1090 ⋮ [n?] 7 +GOTRACEBACK=crash
I250313 19:21:09.369527 1 1@cli/start.go:1090 ⋮ [n?] 7 +LANG=‹en_US.UTF-8›
I250313 19:21:09.369527 1 1@cli/start.go:1090 ⋮ [n?] 7 +LC_ALL=‹en_US.UTF-8›
I250313 19:21:09.369527 1 1@cli/start.go:1090 ⋮ [n?] 7 +TZ=‹UTC›
I250313 19:21:09.369560 1 1@cli/start.go:1097 ⋮ [n?] 8  process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
W250313 19:21:09.369842 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›
I250313 19:21:09.369878 1 1@cli/start.go:581 ⋮ [n?] 10  starting cockroach node
I250313 19:21:09.428929 68 server/config.go:665 ⋮ [n?] 11  1 storage engine‹› initialized
I250313 19:21:09.428971 68 server/config.go:668 ⋮ [n?] 12  Pebble cache size: 128 MiB
I250313 19:21:09.429017 68 server/config.go:668 ⋮ [n?] 13  store 0: max size 0 B, max open file limit 60536
I250313 19:21:09.429022 68 server/config.go:668 ⋮ [n?] 14  store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmp79Wz6I/data›, fs=zfs, blkdev=‹rpool/work›, mnt=‹/work› opts=‹rw,devices,setuid,nonbmand,exec,xattr,atime,dev=4350006›}}
E250313 19:21:09.429230 68 1@server/status/runtime.go:343 ⋮ [n?] 15  could not get initial disk IO counters: ‹not implemented yet›
E250313 19:21:09.429262 68 1@server/status/runtime.go:347 ⋮ [n?] 16  could not get initial disk IO counters: ‹not implemented yet›
I250313 19:21:09.430879 68 server/tracedumper/tracedumper.go:120 ⋮ [n?] 17  writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmp79Wz6I/data/logs/inflight_trace_dump›
I250313 19:21:09.456501 68 1@server/clock_monotonicity.go:65 ⋮ [n?] 18  monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
I250313 19:21:09.457707 68 1@server/clock_monotonicity.go:140 ⋮ [n1] 19  Sleeping till wall time 1741893669457705056 to catches up to 1741893669956485540 to ensure monotonicity. Delta: 498.780484ms
I250313 19:21:09.457795 196 1@server/server.go:1319 ⋮ [n1] 20  connecting to gossip network to verify cluster ID ‹"a5f0da06-9ace-4013-be42-532b587ec218"›
I250313 19:21:09.957309 68 1@cli/start.go:521 ⋮ [n1] 21  listening URL file: ‹/var/tmp/omicron_tmp/.tmp79Wz6I/listen-url›
W250313 19:21:09.957663 68 1@gossip/gossip.go:1531 ⋮ [n1] 22  no addresses found; use --join to specify a connected node
I250313 19:21:09.957731 68 gossip/gossip.go:401 ⋮ [n1] 23  NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:37739" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-29-g865aff1595" started_at:1741893669957721011 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:37739" > http_address:<network_field:"tcp" address_field:"[::1]:33166" >›
I250313 19:21:09.965520 68 server/node.go:470 ⋮ [n1] 24  initialized store s1
I250313 19:21:09.965619 68 kv/kvserver/stores.go:250 ⋮ [n1] 25  read 0 node addresses from persistent storage
I250313 19:21:09.965959 68 server/node.go:549 ⋮ [n1] 26  started with engine type ‹2›
I250313 19:21:09.966041 68 server/node.go:551 ⋮ [n1] 27  started with attributes []
I250313 19:21:09.966239 68 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 28  writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmp79Wz6I/data/logs/goroutine_dump›
I250313 19:21:09.966357 68 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 29  writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmp79Wz6I/data/logs/heap_profiler› at least every 1h0m0s
I250313 19:21:09.966391 68 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 30  to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf"
I250313 19:21:09.966397 196 1@server/server.go:1322 ⋮ [n1] 31  node connected via gossip
I250313 19:21:09.966412 68 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 32  writing memory stats to ‹/var/tmp/omicron_tmp/.tmp79Wz6I/data/logs/heap_profiler› at last every 1h0m0s
W250313 19:21:09.966471 68 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
I250313 19:21:09.966599 68 1@server/server.go:1458 ⋮ [n1] 34  starting http server at ‹[::1]:33166› (use: ‹[::1]:33166›)
I250313 19:21:09.966633 68 1@server/server.go:1465 ⋮ [n1] 35  starting grpc/postgres server at ‹[::1]:37739›
I250313 19:21:09.966670 68 1@server/server.go:1466 ⋮ [n1] 36  advertising CockroachDB node at ‹[::1]:37739›
E250313 19:21:09.966720 68 server/status/recorder.go:420 ⋮ [n1,summaries] 37  could not get total system memory: ‹not implemented on illumos›
I250313 19:21:09.971447 387 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38  spanconfig-subscriber: established range feed cache
I250313 19:21:09.986965 68 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1741893669986960727,"EventType":"node_restart","NodeID":1,"StartedAt":1741893669957721011,"LastUp":1741891823068155886}
I250313 19:21:09.987017 68 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40  starting SQL liveness instance
I250313 19:21:09.988375 525 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 41  settings-watcher: established range feed cache
I250313 19:21:09.988405 391 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 42  inserted sqlliveness session 1b7d427da0bd4f1899113ca6dd2bece1
I250313 19:21:09.988428 391 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 43  created new SQL liveness session 1b7d427da0bd4f1899113ca6dd2bece1
I250313 19:21:09.988471 206 sql/temporary_schema.go:514 ⋮ [n1] 44  running temporary object cleanup background job
I250313 19:21:09.988517 208 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 45  starting sql-stats-worker with initial delay: 10m21.120178388s
I250313 19:21:09.988928 549 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 46  RangeFeed closed timestamp 1741891819.801015868,0 is behind by 30m50.187910134s
I250313 19:21:09.989206 554 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 47  system-config-cache: established range feed cache
I250313 19:21:09.989503 206 sql/temporary_schema.go:559 ⋮ [n1] 48  found 0 temporary schemas
I250313 19:21:09.989525 206 sql/temporary_schema.go:562 ⋮ [n1] 49  early exiting temporary schema cleaner as no temporary schemas were found
I250313 19:21:09.989540 206 sql/temporary_schema.go:563 ⋮ [n1] 50  completed temporary object cleanup job
I250313 19:21:09.989560 206 sql/temporary_schema.go:646 ⋮ [n1] 51  temporary object cleaner next scheduled to run at 2025-03-13 19:51:09.988416715 +0000 UTC
I250313 19:21:09.989587 68 server/server_sql.go:1295 ⋮ [n1] 52  done ensuring all necessary startup migrations have run
I250313 19:21:09.989728 478 jobs/job_scheduler.go:433 ⋮ [n1] 53  waiting 3m0s before scheduled jobs daemon start
I250313 19:21:09.989884 562 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 54  tenant-settings-watcher: established range feed cache
I250313 19:21:09.995149 642 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 55  deleted session ee7f4141386d4737a5ecb1686fad4bdc which expired at 1741891860.261838576,0
I250313 19:21:09.995270 481 server/auto_upgrade.go:79 ⋮ [n1] 56  no need to upgrade, cluster already at the newest version
I250313 19:21:10.021261 68 1@server/server_sql.go:1365 ⋮ [n1] 57  serving sql connections
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58  node startup completed:
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +CockroachDB node starting at 2025-03-13 19:21:10.021288459 +0000 UTC (took 0.7s)
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +build:               OSS v22.1.22-29-g865aff1595 @ 2024/11/04 18:39:00 (go1.17.13)
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +webui:               ‹http://[::1]:33166›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +sql:                 ‹postgresql://root@[::1]:37739/defaultdb?sslmode=disable›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +sql (JDBC):          ‹jdbc:postgresql://[::1]:37739/defaultdb?sslmode=disable&user=root›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +RPC client flags:    ‹cockroach <client cmd> --host=[::1]:37739 --insecure›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +logs:                ‹/var/tmp/omicron_tmp/.tmp79Wz6I/data/logs›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +temp dir:            ‹/var/tmp/omicron_tmp/.tmp79Wz6I/data/cockroach-temp3914063361›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +external I/O path:   ‹/var/tmp/omicron_tmp/.tmp79Wz6I/data/extern›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +store[0]:            ‹path=/var/tmp/omicron_tmp/.tmp79Wz6I/data›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +storage engine:      pebble
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +clusterID:           ‹a5f0da06-9ace-4013-be42-532b587ec218›
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +status:              restarted pre-existing node
I250313 19:21:10.021367 68 1@cli/start.go:1033 ⋮ [n1] 58 +nodeID:              1
E250313 19:21:10.276394 545 server/status/recorder.go:420 ⋮ [n1] 59  could not get total system memory: ‹not implemented on illumos›
I250313 19:21:10.424790 544 server/diagnostics/update_checker.go:150 ⋮ [n1] 60  a new version is available: ‹25.1.1›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.1#v25-1-1›
I250313 19:21:12.031196 129 1@gossip/gossip.go:1547 ⋮ [n1] 61  node has connected to cluster via gossip
I250313 19:21:12.031334 129 kv/kvserver/stores.go:269 ⋮ [n1] 62  wrote 0 node addresses to persistent storage
I250313 19:21:12.977373 1736 kv/kvserver/replica_consistency.go:267 ⋮ [n1,consistencyChecker,s1,r4/1:‹/System{/tsd-tse}›] 63  triggering stats recomputation to resolve delta of {ContainsEstimates:5168 LastUpdateNanos:1741893669998330120 IntentAge:0 GCBytesAge:0 LiveBytes:-178947 LiveCount:-2584 KeyBytes:-137603 KeyCount:-2584 ValBytes:-41344 ValCount:-2584 IntentBytes:0 IntentCount:0 SeparatedIntentCount:0 SysBytes:0 SysCount:0 AbortSpanBytes:0}