I260624 02:04:02.922690 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2026/06/24 02:04:02 I260624 02:04:02.922695 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01KVVMVY1VWNENA227KNPYHTRR› I260624 02:04:02.922698 1 util/log/file_sync_buffer.go:238 ⋮ [config] binary: CockroachDB OSS v22.1.22-64-g86fdbfca06 (x86_64-linux-gnu, built 2026/03/18 01:46:58, go1.22.11) I260624 02:04:02.922702 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpQdUtxq/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpQdUtxq/listen-url› ‹--max-sql-memory› ‹256MiB›] I260624 02:04:02.922711 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 I260624 02:04:02.922713 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 W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 + W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 +This mode is intended for non-production testing only. W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 + W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 +In this mode: W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. W260624 02:04:02.922562 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. I260624 02:04:02.922769 1 1@cli/start.go:1190 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, I260624 02:04:02.922769 1 1@cli/start.go:1190 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: I260624 02:04:02.922769 1 1@cli/start.go:1190 ⋮ [n?] 2 + I260624 02:04:02.922769 1 1@cli/start.go:1190 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› I260624 02:04:02.922769 1 1@cli/start.go:1190 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html I260624 02:04:02.922923 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› W260624 02:04:02.922933 1 1@cli/start.go:1106 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› W260624 02:04:02.922933 1 1@cli/start.go:1106 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› W260624 02:04:02.922933 1 1@cli/start.go:1106 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).› I260624 02:04:02.922992 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› I260624 02:04:02.922996 1 1@cli/start.go:1219 ⋮ [n?] 6 ‹CockroachDB OSS v22.1.22-64-g86fdbfca06 (x86_64-linux-gnu, built 2026/03/18 01:46:58, go1.22.11)› I260624 02:04:02.923288 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› I260624 02:04:02.923295 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 server configuration: I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 256 MiB› I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› I260624 02:04:02.923304 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› I260624 02:04:02.923349 1 1@cli/start.go:1084 ⋮ [n?] 10 using local environment variables: I260624 02:04:02.923349 1 1@cli/start.go:1084 ⋮ [n?] 10 +GOTRACEBACK=crash I260624 02:04:02.923349 1 1@cli/start.go:1084 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› I260624 02:04:02.923349 1 1@cli/start.go:1084 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› I260624 02:04:02.923349 1 1@cli/start.go:1084 ⋮ [n?] 10 +TZ=‹UTC› I260624 02:04:02.923356 1 1@cli/start.go:1091 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› W260624 02:04:02.923504 1 1@cli/start.go:1304 ⋮ [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› I260624 02:04:02.923539 1 1@cli/start.go:581 ⋮ [n?] 13 ‹starting cockroach node› I260624 02:04:03.122365 79 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized I260624 02:04:03.122384 79 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB I260624 02:04:03.122391 79 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 519288 I260624 02:04:03.122393 79 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpQdUtxq/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} I260624 02:04:03.123261 79 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/logs/inflight_trace_dump› I260624 02:04:03.176145 79 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 ‹monitoring forward clock jumps based on server.clock.forward_jump_check_enabled› I260624 02:04:03.181590 79 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1782266643181588401 to catches up to 1782266643676138227 to ensure monotonicity. Delta: 494.549826ms I260624 02:04:03.181633 196 1@server/server.go:1294 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"f7a658b2-b58d-40f9-8779-4846dceb6ba0"› I260624 02:04:03.676954 79 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmpQdUtxq/listen-url› W260624 02:04:03.691616 79 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node I260624 02:04:03.691678 79 gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address: attrs:<> locality:<> ServerVersion: build_tag:"v22.1.22-64-g86fdbfca06" started_at:1782266643691672565 cluster_name:"" sql_address: http_address:› I260624 02:04:03.694412 79 server/node.go:470 ⋮ [n1] 25 initialized store s1 I260624 02:04:03.694439 79 kv/kvserver/stores.go:250 ⋮ [n1] 26 read 0 node addresses from persistent storage I260624 02:04:03.694983 196 1@server/server.go:1297 ⋮ [n1] 27 node connected via gossip I260624 02:04:03.698262 79 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2› I260624 02:04:03.698296 79 server/node.go:551 ⋮ [n1] 29 started with attributes [] I260624 02:04:03.698324 79 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/logs/goroutine_dump› I260624 02:04:03.698335 79 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/logs/heap_profiler› at least every 1h0m0s I260624 02:04:03.698344 79 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32 to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf" I260624 02:04:03.698350 79 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/logs/heap_profiler› at last every 1h0m0s I260624 02:04:03.698475 79 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/logs/heap_profiler› I260624 02:04:03.698510 79 1@server/server.go:1423 ⋮ [n1] 35 starting http server at ‹[::1]:36827› (use: ‹[::1]:36827›) I260624 02:04:03.698520 79 1@server/server.go:1430 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:36407› I260624 02:04:03.698528 79 1@server/server.go:1431 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:36407› I260624 02:04:03.841277 161 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache I260624 02:04:03.851104 79 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1782266643851101055,"EventType":"node_restart","NodeID":1,"StartedAt":1782266643691672565,"LastUp":1782266193032257532} I260624 02:04:03.851154 79 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance I260624 02:04:03.914723 586 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 41 settings-watcher: established range feed cache I260624 02:04:03.915091 395 sql/temporary_schema.go:514 ⋮ [n1] 42 running temporary object cleanup background job I260624 02:04:03.915540 395 sql/temporary_schema.go:559 ⋮ [n1] 43 found 0 temporary schemas I260624 02:04:03.915555 395 sql/temporary_schema.go:562 ⋮ [n1] 44 early exiting temporary schema cleaner as no temporary schemas were found I260624 02:04:03.915554 437 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 45 inserted sqlliveness session 74e33e31752f4dada9f5ccce0d4c8cd1 I260624 02:04:03.915577 437 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 46 created new SQL liveness session 74e33e31752f4dada9f5ccce0d4c8cd1 I260624 02:04:03.915561 395 sql/temporary_schema.go:563 ⋮ [n1] 47 completed temporary object cleanup job I260624 02:04:03.915591 395 sql/temporary_schema.go:646 ⋮ [n1] 48 temporary object cleaner next scheduled to run at 2026-06-24 02:34:03.915063628 +0000 UTC I260624 02:04:03.915597 397 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 49 starting sql-stats-worker with initial delay: 10m51.914402218s I260624 02:04:03.916537 606 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 50 RangeFeed closed timestamp 1782266189.174448507,0 is behind by 7m34.74208744s I260624 02:04:03.916681 79 server/server_sql.go:1287 ⋮ [n1] 51 done ensuring all necessary startup migrations have run I260624 02:04:03.916814 627 jobs/job_scheduler.go:433 ⋮ [n1] 52 waiting 2m0s before scheduled jobs daemon start I260624 02:04:03.916833 631 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 53 tenant-settings-watcher: established range feed cache I260624 02:04:03.917069 593 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 54 system-config-cache: established range feed cache I260624 02:04:03.921854 630 server/auto_upgrade.go:79 ⋮ [n1] 55 ‹no need to upgrade, cluster already at the newest version› I260624 02:04:03.939414 682 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56 deleted session 11c243c9bd5d46f5b19b29214c3f28f0 which expired at 1782266230.779611493,0 I260624 02:04:03.979544 79 1@server/server_sql.go:1350 ⋮ [n1] 57 ‹serving sql connections› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 node startup completed: I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +CockroachDB node starting at 2026-06-24 02:04:03.979580665 +0000 UTC (took 1.1s) I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +build: OSS v22.1.22-64-g86fdbfca06 @ 2026/03/18 01:46:58 (go1.22.11) I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +webui: ‹http://[::1]:36827› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +sql: ‹postgresql://root@[::1]:36407/defaultdb?sslmode=disable› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +sql (JDBC): ‹jdbc:postgresql://[::1]:36407/defaultdb?sslmode=disable&user=root› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +RPC client flags: ‹cockroach --host=[::1]:36407 --insecure› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +logs: ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/logs› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +temp dir: ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/cockroach-temp1223797679› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +external I/O path: ‹/var/tmp/omicron_tmp/.tmpQdUtxq/data/extern› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmpQdUtxq/data› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +storage engine: pebble I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +clusterID: ‹f7a658b2-b58d-40f9-8779-4846dceb6ba0› I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +status: restarted pre-existing node I260624 02:04:03.979658 79 1@cli/start.go:1027 ⋮ [n1] 58 +nodeID: 1 I260624 02:04:03.988594 803 util/log/event_log.go:32 ⋮ [n1,client=[::1]:58742,user=root] 59 ={"Timestamp":1782266643986559280,"EventType":"set_cluster_setting","Statement":"SET CLUSTER SETTING \"kv.raft_log.disable_synchronization_unsafe\" = true","Tag":"SET CLUSTER SETTING","User":"root","SettingName":"kv.raft_log.disable_synchronization_unsafe","Value":"‹true›"} I260624 02:04:05.237706 56 1@gossip/gossip.go:1547 ⋮ [n1] 60 node has connected to cluster via gossip I260624 02:04:05.241425 56 kv/kvserver/stores.go:269 ⋮ [n1] 61 wrote 0 node addresses to persistent storage I260624 02:04:08.707565 852 util/log/event_log.go:32 ⋮ [n1,client=[::1]:58752,user=root] 62 ={"Timestamp":1782266648705262991,"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›"} I260624 02:04:09.770957 1 1@cli/start.go:749 ⋮ [n1] 63 received signal 'terminated' I260624 02:04:09.772524 1 1@cli/start.go:846 ⋮ [n1] 64 ‹initiating graceful shutdown of server› I260624 02:04:09.772597 2484 1@server/drain.go:342 ⋮ [n1,server drain process] 65 ‹waiting for health probes to notice that the node is not ready for new sql connections› I260624 02:04:09.772609 2484 1@sql/pgwire/server.go:612 ⋮ [n1,server drain process] 66 ‹starting draining SQL connections› I260624 02:04:10.833668 1057 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58788,user=root] 67 ‹closing existing connection while server is draining› I260624 02:04:10.987879 1575 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58780,user=root] 68 ‹closing existing connection while server is draining› I260624 02:04:11.007567 1517 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58784,user=root] 69 ‹closing existing connection while server is draining› I260624 02:04:11.048608 1579 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58782,user=root] 70 ‹closing existing connection while server is draining› I260624 02:04:11.128735 1582 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58786,user=root] 71 ‹closing existing connection while server is draining› I260624 02:04:11.445230 1571 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58774,user=root] 72 ‹closing existing connection while server is draining› I260624 02:04:11.445233 817 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58764,user=root] 73 ‹closing existing connection while server is draining› I260624 02:04:11.484799 755 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58746,user=root] 74 ‹closing existing connection while server is draining› I260624 02:04:11.577708 814 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58762,user=root] 75 ‹closing existing connection while server is draining› I260624 02:04:11.577708 883 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58760,user=root] 76 ‹closing existing connection while server is draining› I260624 02:04:11.729110 866 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58758,user=root] 77 ‹closing existing connection while server is draining› I260624 02:04:11.729110 1537 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58776,user=root] 78 ‹closing existing connection while server is draining› I260624 02:04:11.737259 758 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58750,user=root] 79 ‹closing existing connection while server is draining› I260624 02:04:11.758402 762 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58754,user=root] 80 ‹closing existing connection while server is draining› I260624 02:04:11.758402 851 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58752,user=root] 81 ‹closing existing connection while server is draining› I260624 02:04:11.759511 812 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:58756,user=root] 82 ‹closing existing connection while server is draining› I260624 02:04:11.760351 2484 sql/sqlstats/persistedsqlstats/flush.go:68 ⋮ [n1,server drain process] 83 flushing 321 stmt/txn fingerprints (215040 bytes) after 1.32µs I260624 02:04:12.284378 2484 1@server/drain.go:285 ⋮ [n1,server drain process] 84 drain remaining: 237 I260624 02:04:12.285827 2484 1@server/drain.go:287 ⋮ [n1,server drain process] 85 drain details: liveness record: 1, SQL clients: 16, descriptor leases: 220 I260624 02:04:12.486469 2484 sql/sqlstats/persistedsqlstats/flush.go:68 ⋮ [n1,server drain process] 86 flushing 2 stmt/txn fingerprints (10240 bytes) after 1.24µs W260624 02:04:12.487377 2484 sql/sqlstats/persistedsqlstats/flush.go:170 ⋮ [n1,server drain process] 87 ‹failed to flush statement statistics›: flush statement ‹4025915790256006928›'s statistics: ‹insert-stmt-stats›: cannot acquire lease when draining W260624 02:04:12.488576 2484 sql/sqlstats/persistedsqlstats/flush.go:170 ⋮ [n1,server drain process] 88 ‹failed to flush transaction statistics›: flushing transaction ‹11006041404254834895›'s statistics: ‹insert-txn-stats›: cannot acquire lease when draining I260624 02:04:12.494861 2484 1@server/drain.go:285 ⋮ [n1,server drain process] 89 drain remaining: 0 I260624 02:04:12.495233 401 sql/stats/automatic_stats.go:489 ⋮ [n1] 90 ‹quiescing auto stats refresher› W260624 02:04:12.495270 582 jobs/registry.go:815 ⋮ [n1] 91 canceling all adopted jobs due to stopper quiescing W260624 02:04:12.495473 437 sql/sqlliveness/slinstance/slinstance.go:235 ⋮ [n1] 92 ‹exiting heartbeat loop› I260624 02:04:12.510336 1 1@cli/start.go:898 ⋮ [n1] 93 server drained and shutdown completed