I240926 19:42:57.788990 1 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2024/09/26 19:42:57
I240926 19:42:57.788998 1 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01J8QWT48330KGPGA5BJVQ5NQB›
I240926 19:42:57.789004 1 util/log/file_sync_buffer.go:238 ⋮ [config]   binary: CockroachDB CCL v22.1.9 (x86_64-pc-linux-gnu, built 2022/10/17 18:24:57, go1.17.11)
I240926 19:42:57.789011 1 util/log/file_sync_buffer.go:238 ⋮ [config]   arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpCYRwlf/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpCYRwlf/listen-url›]
I240926 19:42:57.789027 1 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I240926 19:42:57.789031 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
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1  ALL SECURITY CONTROLS HAVE BEEN DISABLED!
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +This mode is intended for non-production testing only.
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +In this mode:
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2  To start a secure server without mandating TLS for clients,
I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 +
I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
I240926 19:42:57.789419 1 server/status/recorder.go:620 ⋮ [n?] 3  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
W240926 19:42:57.789442 1 1@cli/start.go:1107 ⋮ [n?] 4  ‹Using the default setting for --cache (128 MiB).›
W240926 19:42:57.789442 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹  A significantly larger value is usually needed for good performance.›
W240926 19:42:57.789442 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹  If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).›
I240926 19:42:57.789604 1 server/status/recorder.go:620 ⋮ [n?] 5  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I240926 19:42:57.789614 1 1@cli/start.go:1220 ⋮ [n?] 6  ‹CockroachDB CCL v22.1.9 (x86_64-pc-linux-gnu, built 2022/10/17 18:24:57, go1.17.11)›
I240926 19:42:57.790898 1 server/status/recorder.go:620 ⋮ [n?] 7  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I240926 19:42:57.790916 1 server/config.go:487 ⋮ [n?] 8  system total memory: 31 GiB
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9  server configuration:
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹max offset             500000000›
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹cache size             128 MiB›
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size   7.7 GiB›
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval          10m0s›
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time     10ms›
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time     1s›
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled      true›
I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled   true›
I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10  using local environment variables:
I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +GOTRACEBACK=crash
I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +LANG=‹en_US.UTF-8›
I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8›
I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +TZ=‹UTC›
I240926 19:42:57.791072 1 1@cli/start.go:1092 ⋮ [n?] 11  process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
W240926 19:42:57.791362 1 1@cli/start.go:1305 ⋮ [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›
I240926 19:42:57.791427 1 1@cli/start.go:576 ⋮ [n?] 13  starting cockroach node
I240926 19:42:58.006231 49 server/config.go:665 ⋮ [n?] 14  1 storage engine‹› initialized
I240926 19:42:58.006280 49 server/config.go:668 ⋮ [n?] 15  Pebble cache size: 128 MiB
I240926 19:42:58.006295 49 server/config.go:668 ⋮ [n?] 16  store 0: max size 0 B, max open file limit 10000
I240926 19:42:58.006301 49 server/config.go:668 ⋮ [n?] 17  store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpCYRwlf/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}}
I240926 19:42:58.007851 49 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18  writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/inflight_trace_dump›
I240926 19:42:58.074772 49 1@server/clock_monotonicity.go:65 ⋮ [n?] 19  monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
I240926 19:42:58.090464 49 1@server/clock_monotonicity.go:140 ⋮ [n1] 20  Sleeping till wall time 1727379778090461422 to catches up to 1727379778574756969 to ensure monotonicity. Delta: 484.295547ms
I240926 19:42:58.090502 185 1@server/server.go:1307 ⋮ [n1] 21  connecting to gossip network to verify cluster ID ‹"ebd53b95-d4ae-4b6d-a89d-34c9d199bc92"›
I240926 19:42:58.574921 49 1@cli/start.go:516 ⋮ [n1] 22  listening URL file: ‹/var/tmp/omicron_tmp/.tmpCYRwlf/listen-url›
W240926 19:42:58.585625 49 1@gossip/pkg/gossip/gossip.go:1531 ⋮ [n1] 23  no addresses found; use --join to specify a connected node
I240926 19:42:58.585690 49 gossip/pkg/gossip/gossip.go:401 ⋮ [n1] 24  NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:33723" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.9" started_at:1727379778585683448 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:33723" > http_address:<network_field:"tcp" address_field:"[::1]:44561" >›
I240926 19:42:58.611749 185 1@server/server.go:1310 ⋮ [n1] 25  node connected via gossip
I240926 19:42:58.611870 49 server/node.go:469 ⋮ [n1] 26  initialized store s1
I240926 19:42:58.611959 49 kv/kvserver/pkg/kv/kvserver/stores.go:250 ⋮ [n1] 27  read 0 node addresses from persistent storage
I240926 19:42:59.049970 49 server/node.go:548 ⋮ [n1] 28  started with engine type ‹2›
I240926 19:42:59.050016 49 server/node.go:550 ⋮ [n1] 29  started with attributes []
I240926 19:42:59.050074 49 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30  writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/goroutine_dump›
I240926 19:42:59.050104 49 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31  writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/heap_profiler› at least every 1h0m0s
I240926 19:42:59.050121 49 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32  to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf"
I240926 19:42:59.050133 49 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33  writing memory stats to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/heap_profiler› at last every 1h0m0s
I240926 19:42:59.050311 49 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34  writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/heap_profiler›
I240926 19:42:59.050378 49 1@server/server.go:1446 ⋮ [n1] 35  starting http server at ‹[::1]:44561› (use: ‹[::1]:44561›)
I240926 19:42:59.050403 49 1@server/server.go:1453 ⋮ [n1] 36  starting grpc/postgres server at ‹[::1]:33723›
I240926 19:42:59.050423 49 1@server/server.go:1454 ⋮ [n1] 37  advertising CockroachDB node at ‹[::1]:33723›
I240926 19:42:59.319319 387 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38  spanconfig-subscriber: established range feed cache
I240926 19:42:59.319900 307 kv/kvserver/pkg/kv/kvserver/replica_rangefeed.go:703 ⋮ [n1,rangefeed=‹table-stats-cache›,s1,r16] 39  RangeFeed closed timestamp is empty
I240926 19:42:59.366183 49 1@util/log/event_log.go:32 ⋮ [n1] 40 ={"Timestamp":1727379779366180177,"EventType":"node_restart","NodeID":1,"StartedAt":1727379778585683448,"LastUp":1727379561390489199}
I240926 19:42:59.366230 49 sql/sqlliveness/slinstance/slinstance.go:348 ⋮ [n1] 41  starting SQL liveness instance
I240926 19:42:59.373369 708 kv/kvserver/pkg/kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r175/1:‹/{Table/299-Max}›] 42  initiating a split of this range at key ‹/Table/300› [r185] (‹span config›)‹›
I240926 19:42:59.394107 776 sql/sqlstats/persistedsqlstats/pkg/sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 43  starting sql-stats-worker with initial delay: 10m3.985105385s
I240926 19:42:59.394196 774 sql/temporary_schema.go:514 ⋮ [n1] 44  running temporary object cleanup background job
I240926 19:42:59.394264 805 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 45  settings-watcher: established range feed cache
I240926 19:42:59.395325 774 sql/temporary_schema.go:559 ⋮ [n1] 46  found 0 temporary schemas
I240926 19:42:59.395344 774 sql/temporary_schema.go:562 ⋮ [n1] 47  early exiting temporary schema cleaner as no temporary schemas were found
I240926 19:42:59.395357 774 sql/temporary_schema.go:563 ⋮ [n1] 48  completed temporary object cleanup job
I240926 19:42:59.395371 774 sql/temporary_schema.go:646 ⋮ [n1] 49  temporary object cleaner next scheduled to run at 2024-09-26 20:12:59.394168481 +0000 UTC
I240926 19:42:59.397468 49 server/server_sql.go:1290 ⋮ [n1] 50  done ensuring all necessary startup migrations have run
I240926 19:42:59.397663 836 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 51  tenant-settings-watcher: established range feed cache
I240926 19:42:59.397911 830 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 52  system-config-cache: established range feed cache
I240926 19:42:59.398984 832 jobs/job_scheduler.go:433 ⋮ [n1] 53  waiting 3m0s before scheduled jobs daemon start
I240926 19:42:59.411747 835 server/auto_upgrade.go:59 ⋮ [n1] 54  no need to upgrade, cluster already at the newest version
I240926 19:42:59.411843 391 sql/sqlliveness/slstorage/slstorage.go:406 ⋮ [n1] 55  inserted sqlliveness session efcfd344489146c587ab80d440875a18
I240926 19:42:59.411866 391 sql/sqlliveness/slinstance/slinstance.go:206 ⋮ [n1] 56  created new SQL liveness session efcfd344489146c587ab80d440875a18
I240926 19:42:59.462463 969 kv/kvserver/pkg/kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r185/1:‹/{Table/300-Max}›] 57  initiating a split of this range at key ‹/Table/301› [r186] (‹span config›)‹›
I240926 19:42:59.493026 49 1@server/server_sql.go:1360 ⋮ [n1] 58  serving sql connections
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59  node startup completed:
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +CockroachDB node starting at 2024-09-26 19:42:59.493063302 +0000 UTC (took 1.7s)
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +build:               CCL v22.1.9 @ 2022/10/17 18:24:57 (go1.17.11)
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +webui:               ‹http://[::1]:44561›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +sql:                 ‹postgresql://root@[::1]:33723/defaultdb?sslmode=disable›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +sql (JDBC):          ‹jdbc:postgresql://[::1]:33723/defaultdb?sslmode=disable&user=root›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +RPC client flags:    ‹cockroach <client cmd> --host=[::1]:33723 --insecure›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +logs:                ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +temp dir:            ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/cockroach-temp2275887970›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +external I/O path:   ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/extern›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +store[0]:            ‹path=/var/tmp/omicron_tmp/.tmpCYRwlf/data›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +storage engine:      pebble
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +clusterID:           ‹ebd53b95-d4ae-4b6d-a89d-34c9d199bc92›
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +status:              restarted pre-existing node
I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +nodeID:              1