I240812 20:52:10.660751 1 util/log/file_sync_buffer.go:238 ⋮ [config]   file created at: 2024/08/12 20:52:10
I240812 20:52:10.660758 1 util/log/file_sync_buffer.go:238 ⋮ [config]   running on machine: ‹w-01J544P9SGK5S0VTVDN4Y2W3F8›
I240812 20:52:10.660766 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)
I240812 20:52:10.660772 1 util/log/file_sync_buffer.go:238 ⋮ [config]   arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmp2bzsJ0/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/listen-url›]
I240812 20:52:10.660787 1 util/log/file_sync_buffer.go:238 ⋮ [config]   log format (utf8=✓): crdb-v2
I240812 20:52:10.660791 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
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1  ALL SECURITY CONTROLS HAVE BEEN DISABLED!
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +This mode is intended for non-production testing only.
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +In this mode:
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2  To start a secure server without mandating TLS for clients,
I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 +
I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
I240812 20:52:10.661149 1 server/status/recorder.go:620 ⋮ [n?] 3  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
W240812 20:52:10.661171 1 1@cli/start.go:1107 ⋮ [n?] 4  ‹Using the default setting for --cache (128 MiB).›
W240812 20:52:10.661171 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹  A significantly larger value is usually needed for good performance.›
W240812 20:52:10.661171 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹  If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).›
I240812 20:52:10.661363 1 server/status/recorder.go:620 ⋮ [n?] 5  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I240812 20:52:10.661379 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)›
I240812 20:52:10.662987 1 server/status/recorder.go:620 ⋮ [n?] 7  ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
I240812 20:52:10.663007 1 server/config.go:487 ⋮ [n?] 8  system total memory: 31 GiB
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9  server configuration:
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹max offset             500000000›
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹cache size             128 MiB›
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size   7.7 GiB›
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval          10m0s›
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time     10ms›
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time     1s›
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled      true›
I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled   true›
I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10  using local environment variables:
I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +GOTRACEBACK=crash
I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +LANG=‹en_US.UTF-8›
I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8›
I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +TZ=‹UTC›
I240812 20:52:10.663126 1 1@cli/start.go:1092 ⋮ [n?] 11  process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
W240812 20:52:10.663334 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›
I240812 20:52:10.663383 1 1@cli/start.go:576 ⋮ [n?] 13  starting cockroach node
I240812 20:52:10.846730 102 server/config.go:665 ⋮ [n?] 14  1 storage engine‹› initialized
I240812 20:52:10.846767 102 server/config.go:668 ⋮ [n?] 15  Pebble cache size: 128 MiB
I240812 20:52:10.846789 102 server/config.go:668 ⋮ [n?] 16  store 0: max size 0 B, max open file limit 10000
I240812 20:52:10.846797 102 server/config.go:668 ⋮ [n?] 17  store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}}
I240812 20:52:10.850842 102 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18  writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/inflight_trace_dump›
I240812 20:52:10.932527 102 1@server/clock_monotonicity.go:65 ⋮ [n?] 19  monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
I240812 20:52:10.941195 102 1@server/clock_monotonicity.go:140 ⋮ [n1] 20  Sleeping till wall time 1723495930941193474 to catches up to 1723495931432515928 to ensure monotonicity. Delta: 491.322454ms
I240812 20:52:10.941249 125 1@server/server.go:1307 ⋮ [n1] 21  connecting to gossip network to verify cluster ID ‹"8e97d791-83b9-4f5d-ae7b-0efa9e4f2f98"›
I240812 20:52:11.432744 102 1@cli/start.go:516 ⋮ [n1] 22  listening URL file: ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/listen-url›
W240812 20:52:11.444982 102 1@gossip/pkg/gossip/gossip.go:1531 ⋮ [n1] 23  no addresses found; use --join to specify a connected node
I240812 20:52:11.445035 102 gossip/pkg/gossip/gossip.go:401 ⋮ [n1] 24  NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:45747" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.9" started_at:1723495931445028033 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:45747" > http_address:<network_field:"tcp" address_field:"[::1]:42265" >›
I240812 20:52:11.462479 102 server/node.go:469 ⋮ [n1] 25  initialized store s1
I240812 20:52:11.462536 102 kv/kvserver/pkg/kv/kvserver/stores.go:250 ⋮ [n1] 26  read 0 node addresses from persistent storage
I240812 20:52:11.462795 125 1@server/server.go:1310 ⋮ [n1] 27  node connected via gossip
I240812 20:52:11.464536 102 server/node.go:548 ⋮ [n1] 28  started with engine type ‹2›
I240812 20:52:11.464563 102 server/node.go:550 ⋮ [n1] 29  started with attributes []
I240812 20:52:11.464616 102 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30  writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/goroutine_dump›
I240812 20:52:11.464643 102 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31  writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/heap_profiler› at least every 1h0m0s
I240812 20:52:11.464661 102 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32  to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf"
I240812 20:52:11.464674 102 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33  writing memory stats to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/heap_profiler› at last every 1h0m0s
I240812 20:52:11.464847 102 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34  writing go query profiles to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/heap_profiler›
I240812 20:52:11.464903 102 1@server/server.go:1446 ⋮ [n1] 35  starting http server at ‹[::1]:42265› (use: ‹[::1]:42265›)
I240812 20:52:11.464946 102 1@server/server.go:1453 ⋮ [n1] 36  starting grpc/postgres server at ‹[::1]:45747›
I240812 20:52:11.464965 102 1@server/server.go:1454 ⋮ [n1] 37  advertising CockroachDB node at ‹[::1]:45747›
E240812 20:52:11.531098 325 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r26/1:‹/NamespaceTable/{30-Max}›] 38  1 matching stores are currently throttled: [‹s1: draining›]
E240812 20:52:11.542775 360 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r3/1:‹/System/{NodeLive…-tsd}›] 39  1 matching stores are currently throttled: [‹s1: draining›]
E240812 20:52:11.542924 110 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r2/1:‹/System/NodeLiveness{-Max}›] 40  1 matching stores are currently throttled: [‹s1: draining›]
E240812 20:52:11.543001 110 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r1/1:‹/{Min-System/NodeL…}›] 41  1 matching stores are currently throttled: [‹s1: draining›]
I240812 20:52:11.543019 110 kv/kvserver/pkg/kv/kvserver/queue.go:1205 ⋮ [n1,replicate] 42  purgatory is now empty
E240812 20:52:11.546209 175 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r6/1:‹/Table/{SystemCon…-11}›] 43  1 matching stores are currently throttled: [‹s1: draining›]
I240812 20:52:11.554110 331 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 44  spanconfig-subscriber: established range feed cache
E240812 20:52:11.559336 75 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r7/1:‹/Table/1{1-2}›] 45  1 matching stores are currently throttled: [‹s1: draining›]
I240812 20:52:11.590619 102 1@util/log/event_log.go:32 ⋮ [n1] 46 ={"Timestamp":1723495931590615755,"EventType":"node_restart","NodeID":1,"StartedAt":1723495931445028033,"LastUp":1723495408945552352}
I240812 20:52:11.590688 102 sql/sqlliveness/slinstance/slinstance.go:348 ⋮ [n1] 47  starting SQL liveness instance
I240812 20:52:11.626009 335 sql/sqlliveness/slstorage/slstorage.go:406 ⋮ [n1] 48  inserted sqlliveness session 4449bbc348f84f56b7efcd340669f11a
I240812 20:52:11.626071 335 sql/sqlliveness/slinstance/slinstance.go:206 ⋮ [n1] 49  created new SQL liveness session 4449bbc348f84f56b7efcd340669f11a
I240812 20:52:11.627992 398 sql/temporary_schema.go:514 ⋮ [n1] 50  running temporary object cleanup background job
I240812 20:52:11.627999 790 sql/sqlstats/persistedsqlstats/pkg/sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 51  starting sql-stats-worker with initial delay: 9m47.75495601s
I240812 20:52:11.645221 827 kv/kvserver/pkg/kv/kvserver/replica_rangefeed.go:705 ⋮ [n1,rangefeed=‹spanconfig-subscriber›,s1,r43] 52  RangeFeed closed timestamp 1723495400.575730577,0 is behind by 8m51.069486762s
I240812 20:52:11.648143 398 sql/temporary_schema.go:559 ⋮ [n1] 53  found 0 temporary schemas
I240812 20:52:11.648167 398 sql/temporary_schema.go:562 ⋮ [n1] 54  early exiting temporary schema cleaner as no temporary schemas were found
I240812 20:52:11.648183 398 sql/temporary_schema.go:563 ⋮ [n1] 55  completed temporary object cleanup job
I240812 20:52:11.648198 398 sql/temporary_schema.go:646 ⋮ [n1] 56  temporary object cleaner next scheduled to run at 2024-08-12 21:22:11.627958499 +0000 UTC
I240812 20:52:11.661673 858 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 57  settings-watcher: established range feed cache
I240812 20:52:11.662299 102 server/server_sql.go:1290 ⋮ [n1] 58  done ensuring all necessary startup migrations have run
I240812 20:52:11.662452 863 jobs/job_scheduler.go:433 ⋮ [n1] 59  waiting 3m0s before scheduled jobs daemon start
I240812 20:52:11.662536 883 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 60  tenant-settings-watcher: established range feed cache
I240812 20:52:11.662553 861 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 61  system-config-cache: established range feed cache
I240812 20:52:11.681036 882 server/auto_upgrade.go:59 ⋮ [n1] 62  no need to upgrade, cluster already at the newest version
I240812 20:52:11.758842 102 1@server/server_sql.go:1360 ⋮ [n1] 63  serving sql connections
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64  node startup completed:
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +CockroachDB node starting at 2024-08-12 20:52:11.758885258 +0000 UTC (took 1.1s)
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +build:               CCL v22.1.9 @ 2022/10/17 18:24:57 (go1.17.11)
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +webui:               ‹http://[::1]:42265›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +sql:                 ‹postgresql://root@[::1]:45747/defaultdb?sslmode=disable›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +sql (JDBC):          ‹jdbc:postgresql://[::1]:45747/defaultdb?sslmode=disable&user=root›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +RPC client flags:    ‹cockroach <client cmd> --host=[::1]:45747 --insecure›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +logs:                ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +temp dir:            ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/cockroach-temp2378304453›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +external I/O path:   ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/extern›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +store[0]:            ‹path=/var/tmp/omicron_tmp/.tmp2bzsJ0/data›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +storage engine:      pebble
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +clusterID:           ‹8e97d791-83b9-4f5d-ae7b-0efa9e4f2f98›
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +status:              restarted pre-existing node
I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +nodeID:              1
I240812 20:52:12.281560 970 server/diagnostics/update_checker.go:150 ⋮ [n1] 65  a new version is available: ‹24.1.3›, details: ‹https://www.cockroachlabs.com/docs/releases/v24.1#v24-1-3›
I240812 20:52:12.992469 226 1@gossip/pkg/gossip/gossip.go:1547 ⋮ [n1] 66  node has connected to cluster via gossip
I240812 20:52:12.995959 226 kv/kvserver/pkg/kv/kvserver/stores.go:269 ⋮ [n1] 67  wrote 0 node addresses to persistent storage
I240812 20:52:16.637141 1694 util/log/event_log.go:32 ⋮ [n1,client=[::1]:41866,user=root] 68 ={"Timestamp":1723495936600582081,"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›"}