I250401 18:05:59.526273 1 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2025/04/01 18:05:59
I250401 18:05:59.526281 1 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01JQS5H9BX9S5R4CVPR9959RGZ›
I250401 18:05:59.526289 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)
I250401 18:05:59.526296 1 util/log/file_sync_buffer.go:238 ⋮ [config]   arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpuoq8Uu/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/listen-url›]
I250401 18:05:59.526312 1 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I250401 18:05:59.526316 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
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1  ALL SECURITY CONTROLS HAVE BEEN DISABLED!
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only.
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode:
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2  To start a secure server without mandating TLS for clients,
I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +
I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
I250401 18:05:59.526731 1 server/status/recorder.go:620 ⋮ [n?] 3  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
W250401 18:05:59.526753 1 1@cli/start.go:1112 ⋮ [n?] 4  ‹Using the default setting for --cache (128 MiB).›
W250401 18:05:59.526753 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹  A significantly larger value is usually needed for good performance.›
W250401 18:05:59.526753 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹  If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).›
I250401 18:05:59.526945 1 server/status/recorder.go:620 ⋮ [n?] 5  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I250401 18:05:59.526960 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)›
I250401 18:05:59.529645 1 server/status/recorder.go:620 ⋮ [n?] 7  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I250401 18:05:59.529664 1 server/config.go:487 ⋮ [n?] 8  system total memory: 31 GiB
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9  server configuration:
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹max offset             500000000›
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹cache size             128 MiB›
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size   7.7 GiB›
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval          10m0s›
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time     10ms›
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time     1s›
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled      true›
I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled   true›
I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10  using local environment variables:
I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +GOTRACEBACK=crash
I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +LANG=‹en_US.UTF-8›
I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8›
I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +TZ=‹UTC›
I250401 18:05:59.529778 1 1@cli/start.go:1097 ⋮ [n?] 11  process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
W250401 18:05:59.529993 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›
I250401 18:05:59.530054 1 1@cli/start.go:581 ⋮ [n?] 13  starting cockroach node
I250401 18:05:59.754360 32 server/config.go:665 ⋮ [n?] 14  1 storage engine‹› initialized
I250401 18:05:59.754401 32 server/config.go:668 ⋮ [n?] 15  Pebble cache size: 128 MiB
I250401 18:05:59.754415 32 server/config.go:668 ⋮ [n?] 16  store 0: max size 0 B, max open file limit 10000
I250401 18:05:59.754421 32 server/config.go:668 ⋮ [n?] 17  store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}}
I250401 18:05:59.757463 32 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18  writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/inflight_trace_dump›
I250401 18:05:59.831221 32 1@server/clock_monotonicity.go:65 ⋮ [n?] 19  monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
I250401 18:05:59.838608 32 1@server/clock_monotonicity.go:140 ⋮ [n1] 20  Sleeping till wall time 1743530759838604841 to catches up to 1743530760331211958 to ensure monotonicity. Delta: 492.607117ms
I250401 18:05:59.838661 161 1@server/server.go:1319 ⋮ [n1] 21  connecting to gossip network to verify cluster ID ‹"269d6f9d-8223-4f0e-bdd9-be856a51fc82"›
I250401 18:06:00.331941 32 1@cli/start.go:521 ⋮ [n1] 22  listening URL file: ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/listen-url›
W250401 18:06:00.346787 32 1@gossip/gossip.go:1531 ⋮ [n1] 23  no addresses found; use --join to specify a connected node
I250401 18:06:00.346865 32 gossip/gossip.go:401 ⋮ [n1] 24  NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:37363" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-29-g865aff1595" started_at:1743530760346846399 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:37363" > http_address:<network_field:"tcp" address_field:"[::1]:40241" >›
I250401 18:06:00.403743 161 1@server/server.go:1322 ⋮ [n1] 25  node connected via gossip
I250401 18:06:00.403840 32 server/node.go:470 ⋮ [n1] 26  initialized store s1
I250401 18:06:00.403892 32 kv/kvserver/stores.go:250 ⋮ [n1] 27  read 0 node addresses from persistent storage
I250401 18:06:00.410694 32 server/node.go:549 ⋮ [n1] 28  started with engine type ‹2›
I250401 18:06:00.410743 32 server/node.go:551 ⋮ [n1] 29  started with attributes []
I250401 18:06:00.410808 32 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30  writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/goroutine_dump›
I250401 18:06:00.410844 32 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31  writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/heap_profiler› at least every 1h0m0s
I250401 18:06:00.410862 32 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32  to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf"
I250401 18:06:00.410882 32 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33  writing memory stats to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/heap_profiler› at last every 1h0m0s
I250401 18:06:00.411077 32 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34  writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/heap_profiler›
I250401 18:06:00.411152 32 1@server/server.go:1458 ⋮ [n1] 35  starting http server at ‹[::1]:40241› (use: ‹[::1]:40241›)
I250401 18:06:00.411184 32 1@server/server.go:1465 ⋮ [n1] 36  starting grpc/postgres server at ‹[::1]:37363›
I250401 18:06:00.411219 32 1@server/server.go:1466 ⋮ [n1] 37  advertising CockroachDB node at ‹[::1]:37363›
I250401 18:06:00.495726 350 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38  spanconfig-subscriber: established range feed cache
I250401 18:06:00.535296 32 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1743530760535293124,"EventType":"node_restart","NodeID":1,"StartedAt":1743530760346846399,"LastUp":1743528527794925292}
I250401 18:06:00.535370 32 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40  starting SQL liveness instance
I250401 18:06:00.560310 737 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r189/1:‹/{Table/332-Max}›] 41  initiating a split of this range at key ‹/Table/333› [r205] (‹span config›)‹›
I250401 18:06:00.570278 754 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 42  inserted sqlliveness session 15f54618896141b3adfd9a5eb9a057c3
I250401 18:06:00.570337 754 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 43  created new SQL liveness session 15f54618896141b3adfd9a5eb9a057c3
I250401 18:06:00.570366 803 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹spanconfig-subscriber›,s1,r43] 44  RangeFeed closed timestamp 1743528520.401193893,0 is behind by 37m20.169169327s
I250401 18:06:00.581094 776 sql/temporary_schema.go:514 ⋮ [n1] 45  running temporary object cleanup background job
I250401 18:06:00.582120 776 sql/temporary_schema.go:559 ⋮ [n1] 46  found 0 temporary schemas
I250401 18:06:00.582147 776 sql/temporary_schema.go:562 ⋮ [n1] 47  early exiting temporary schema cleaner as no temporary schemas were found
I250401 18:06:00.582162 776 sql/temporary_schema.go:563 ⋮ [n1] 48  completed temporary object cleanup job
I250401 18:06:00.582175 776 sql/temporary_schema.go:646 ⋮ [n1] 49  temporary object cleaner next scheduled to run at 2025-04-01 18:36:00.581050385 +0000 UTC
I250401 18:06:00.582222 778 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 50  starting sql-stats-worker with initial delay: 10m40.779414223s
I250401 18:06:00.585227 823 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 51  settings-watcher: established range feed cache
I250401 18:06:00.585793 32 server/server_sql.go:1295 ⋮ [n1] 52  done ensuring all necessary startup migrations have run
I250401 18:06:00.586006 832 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 53  tenant-settings-watcher: established range feed cache
I250401 18:06:00.586304 828 jobs/job_scheduler.go:433 ⋮ [n1] 54  waiting 2m0s before scheduled jobs daemon start
I250401 18:06:00.586352 826 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 55  system-config-cache: established range feed cache
I250401 18:06:00.600424 831 server/auto_upgrade.go:79 ⋮ [n1] 56  no need to upgrade, cluster already at the newest version
I250401 18:06:00.688522 976 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 57  deleted session 034cf85006e14632a6a702f72dc3f99f which expired at 1743528566.610414079,0
I250401 18:06:00.742458 32 1@server/server_sql.go:1365 ⋮ [n1] 58  serving sql connections
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59  node startup completed:
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +CockroachDB node starting at 2025-04-01 18:06:00.742526896 +0000 UTC (took 1.2s)
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +build:               OSS v22.1.22-29-g865aff1595 @ 2024/11/04 18:35:23 (go1.17.13)
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +webui:               ‹http://[::1]:40241›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +sql:                 ‹postgresql://root@[::1]:37363/defaultdb?sslmode=disable›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +sql (JDBC):          ‹jdbc:postgresql://[::1]:37363/defaultdb?sslmode=disable&user=root›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +RPC client flags:    ‹cockroach <client cmd> --host=[::1]:37363 --insecure›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +logs:                ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +temp dir:            ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/cockroach-temp3706854270›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +external I/O path:   ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/extern›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +store[0]:            ‹path=/var/tmp/omicron_tmp/.tmpuoq8Uu/data›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +storage engine:      pebble
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +clusterID:           ‹269d6f9d-8223-4f0e-bdd9-be856a51fc82›
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +status:              restarted pre-existing node
I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +nodeID:              1
I250401 18:06:00.758891 1002 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r205/1:‹/{Table/333-Max}›] 60  initiating a split of this range at key ‹/Table/334› [r206] (‹span config›)‹›
I250401 18:06:00.788990 959 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r206/1:‹/{Table/334-Max}›] 61  initiating a split of this range at key ‹/Table/335› [r207] (‹span config›)‹›
I250401 18:06:00.816719 1072 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r207/1:‹/{Table/335-Max}›] 62  initiating a split of this range at key ‹/Table/338› [r208] (‹span config›)‹›
I250401 18:06:00.850995 1093 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r208/1:‹/{Table/338-Max}›] 63  initiating a split of this range at key ‹/Table/340› [r209] (‹span config›)‹›
I250401 18:06:00.876008 1098 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r209/1:‹/{Table/340-Max}›] 64  initiating a split of this range at key ‹/Table/345› [r210] (‹span config›)‹›
I250401 18:06:00.914887 1104 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r210/1:‹/{Table/345-Max}›] 65  initiating a split of this range at key ‹/Table/346› [r211] (‹span config›)‹›
I250401 18:06:00.938761 1143 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r211/1:‹/{Table/346-Max}›] 66  initiating a split of this range at key ‹/Table/349› [r212] (‹span config›)‹›
I250401 18:06:00.963657 1186 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r212/1:‹/{Table/349-Max}›] 67  initiating a split of this range at key ‹/Table/352› [r213] (‹span config›)‹›
I250401 18:06:00.973036 987 server/diagnostics/update_checker.go:150 ⋮ [n1] 68  a new version is available: ‹25.2.0-alpha.2›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.2#v25-2-0-alpha-2›
I250401 18:06:00.991804 1164 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r213/1:‹/{Table/352-Max}›] 69  initiating a split of this range at key ‹/Table/353› [r214] (‹span config›)‹›
I250401 18:06:01.023509 1196 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r214/1:‹/{Table/353-Max}›] 70  initiating a split of this range at key ‹/Table/357› [r215] (‹span config›)‹›
I250401 18:06:01.050455 1182 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r215/1:‹/{Table/357-Max}›] 71  initiating a split of this range at key ‹/Table/358› [r216] (‹span config›)‹›
I250401 18:06:01.093316 1054 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r216/1:‹/{Table/358-Max}›] 72  initiating a split of this range at key ‹/Table/361› [r217] (‹span config›)‹›
I250401 18:06:01.132652 1282 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r217/1:‹/{Table/361-Max}›] 73  initiating a split of this range at key ‹/Table/366› [r218] (‹span config›)‹›
I250401 18:06:01.159354 1272 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r218/1:‹/{Table/366-Max}›] 74  initiating a split of this range at key ‹/Table/369› [r219] (‹span config›)‹›
I250401 18:06:01.184931 1316 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r219/1:‹/{Table/369-Max}›] 75  initiating a split of this range at key ‹/Table/370› [r220] (‹span config›)‹›
I250401 18:06:01.214071 1319 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r220/1:‹/{Table/370-Max}›] 76  initiating a split of this range at key ‹/Table/371› [r221] (‹span config›)‹›
I250401 18:06:01.246153 1324 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r221/1:‹/{Table/371-Max}›] 77  initiating a split of this range at key ‹/Table/374› [r222] (‹span config›)‹›
I250401 18:06:01.274920 1253 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r222/1:‹/{Table/374-Max}›] 78  initiating a split of this range at key ‹/Table/377› [r223] (‹span config›)‹›
I250401 18:06:02.699403 124 1@gossip/gossip.go:1547 ⋮ [n1] 79  node has connected to cluster via gossip
I250401 18:06:02.705762 124 kv/kvserver/stores.go:269 ⋮ [n1] 80  wrote 0 node addresses to persistent storage
I250401 18:06:07.407360 1424 util/log/event_log.go:32 ⋮ [n1,client=[::1]:52536,user=root] 81 ={"Timestamp":1743530767374739486,"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›"}