I260528 07:19:02.159476 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2026/05/28 07:19:02 I260528 07:19:02.159478 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01KSPP365J5F9C5A1N6JC8NY13› I260528 07:19:02.159480 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) I260528 07:19:02.159483 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmp5V6Olh/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmp5V6Olh/listen-url› ‹--max-sql-memory› ‹256MiB›] I260528 07:19:02.159488 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 I260528 07:19:02.159490 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 W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 + W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 +This mode is intended for non-production testing only. W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 + W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 +In this mode: W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. W260528 07:19:02.159389 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. I260528 07:19:02.159530 1 1@cli/start.go:1190 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, I260528 07:19:02.159530 1 1@cli/start.go:1190 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: I260528 07:19:02.159530 1 1@cli/start.go:1190 ⋮ [n?] 2 + I260528 07:19:02.159530 1 1@cli/start.go:1190 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› I260528 07:19:02.159530 1 1@cli/start.go:1190 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html I260528 07:19:02.159665 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› W260528 07:19:02.159673 1 1@cli/start.go:1106 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› W260528 07:19:02.159673 1 1@cli/start.go:1106 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› W260528 07:19:02.159673 1 1@cli/start.go:1106 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).› I260528 07:19:02.159732 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› I260528 07:19:02.159735 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)› I260528 07:19:02.160008 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› I260528 07:19:02.160014 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 server configuration: I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 256 MiB› I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› I260528 07:19:02.160021 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› I260528 07:19:02.160059 1 1@cli/start.go:1084 ⋮ [n?] 10 using local environment variables: I260528 07:19:02.160059 1 1@cli/start.go:1084 ⋮ [n?] 10 +GOTRACEBACK=crash I260528 07:19:02.160059 1 1@cli/start.go:1084 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› I260528 07:19:02.160059 1 1@cli/start.go:1084 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› I260528 07:19:02.160059 1 1@cli/start.go:1084 ⋮ [n?] 10 +TZ=‹UTC› I260528 07:19:02.160064 1 1@cli/start.go:1091 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› W260528 07:19:02.160171 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› I260528 07:19:02.160201 1 1@cli/start.go:581 ⋮ [n?] 13 ‹starting cockroach node› I260528 07:19:02.288397 67 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized I260528 07:19:02.288421 67 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB I260528 07:19:02.288428 67 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 519288 I260528 07:19:02.288430 67 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmp5V6Olh/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} I260528 07:19:02.289223 67 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/logs/inflight_trace_dump› I260528 07:19:02.334071 67 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 ‹monitoring forward clock jumps based on server.clock.forward_jump_check_enabled› I260528 07:19:02.339219 67 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1779952742339217882 to catches up to 1779952742834064195 to ensure monotonicity. Delta: 494.846313ms I260528 07:19:02.339247 212 1@server/server.go:1294 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"b90e82ee-a6ae-47ae-bfb0-bfa2a5aa0517"› I260528 07:19:02.834328 67 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmp5V6Olh/listen-url› W260528 07:19:02.847199 67 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node I260528 07:19:02.847245 67 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:1779952742847240858 cluster_name:"" sql_address: http_address:› I260528 07:19:02.849778 67 server/node.go:470 ⋮ [n1] 25 initialized store s1 I260528 07:19:02.849808 67 kv/kvserver/stores.go:250 ⋮ [n1] 26 read 0 node addresses from persistent storage I260528 07:19:02.850191 212 1@server/server.go:1297 ⋮ [n1] 27 node connected via gossip I260528 07:19:02.852277 67 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2› I260528 07:19:02.852314 67 server/node.go:551 ⋮ [n1] 29 started with attributes [] I260528 07:19:02.852346 67 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/logs/goroutine_dump› I260528 07:19:02.852359 67 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/logs/heap_profiler› at least every 1h0m0s I260528 07:19:02.852369 67 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32 to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf" I260528 07:19:02.852375 67 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/logs/heap_profiler› at last every 1h0m0s I260528 07:19:02.852509 67 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/logs/heap_profiler› I260528 07:19:02.852558 67 1@server/server.go:1423 ⋮ [n1] 35 starting http server at ‹[::1]:38727› (use: ‹[::1]:38727›) I260528 07:19:02.852569 67 1@server/server.go:1430 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:35075› I260528 07:19:02.852578 67 1@server/server.go:1431 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:35075› I260528 07:19:02.969171 399 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache I260528 07:19:02.980076 67 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1779952742980073106,"EventType":"node_restart","NodeID":1,"StartedAt":1779952742847240858,"LastUp":1779952322854382176} I260528 07:19:02.980115 67 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance I260528 07:19:03.011743 454 sql/temporary_schema.go:514 ⋮ [n1] 41 running temporary object cleanup background job I260528 07:19:03.011856 439 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 42 settings-watcher: established range feed cache I260528 07:19:03.012241 454 sql/temporary_schema.go:559 ⋮ [n1] 43 found 0 temporary schemas I260528 07:19:03.012256 454 sql/temporary_schema.go:562 ⋮ [n1] 44 early exiting temporary schema cleaner as no temporary schemas were found I260528 07:19:03.012264 454 sql/temporary_schema.go:563 ⋮ [n1] 45 completed temporary object cleanup job I260528 07:19:03.012267 442 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 46 system-config-cache: established range feed cache I260528 07:19:03.012270 454 sql/temporary_schema.go:646 ⋮ [n1] 47 temporary object cleaner next scheduled to run at 2026-05-28 07:49:03.011716701 +0000 UTC I260528 07:19:03.012243 67 server/server_sql.go:1287 ⋮ [n1] 48 done ensuring all necessary startup migrations have run I260528 07:19:03.012443 335 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 49 tenant-settings-watcher: established range feed cache I260528 07:19:03.012746 456 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 50 starting sql-stats-worker with initial delay: 9m27.3133582s I260528 07:19:03.012794 331 jobs/job_scheduler.go:433 ⋮ [n1] 51 waiting 3m0s before scheduled jobs daemon start I260528 07:19:03.013907 449 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 52 RangeFeed closed timestamp 1779952319.456698004,0 is behind by 7m3.557207883s I260528 07:19:03.014879 334 server/auto_upgrade.go:79 ⋮ [n1] 53 ‹no need to upgrade, cluster already at the newest version› I260528 07:19:03.019250 435 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 54 inserted sqlliveness session 83696a5075284ec7a2812f6904a5e3f8 I260528 07:19:03.019578 435 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 55 created new SQL liveness session 83696a5075284ec7a2812f6904a5e3f8 I260528 07:19:03.039754 740 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56 deleted session 81ee39150c214b1d995d7bfb6851f18e which expired at 1779952360.635446210,0 I260528 07:19:03.063606 67 1@server/server_sql.go:1350 ⋮ [n1] 57 ‹serving sql connections› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 node startup completed: I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +CockroachDB node starting at 2026-05-28 07:19:03.063648987 +0000 UTC (took 0.9s) I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +build: OSS v22.1.22-64-g86fdbfca06 @ 2026/03/18 01:46:58 (go1.22.11) I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +webui: ‹http://[::1]:38727› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +sql: ‹postgresql://root@[::1]:35075/defaultdb?sslmode=disable› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +sql (JDBC): ‹jdbc:postgresql://[::1]:35075/defaultdb?sslmode=disable&user=root› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +RPC client flags: ‹cockroach --host=[::1]:35075 --insecure› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +logs: ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/logs› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +temp dir: ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/cockroach-temp1095859684› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +external I/O path: ‹/var/tmp/omicron_tmp/.tmp5V6Olh/data/extern› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmp5V6Olh/data› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +storage engine: pebble I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +clusterID: ‹b90e82ee-a6ae-47ae-bfb0-bfa2a5aa0517› I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +status: restarted pre-existing node I260528 07:19:03.063723 67 1@cli/start.go:1027 ⋮ [n1] 58 +nodeID: 1 I260528 07:19:03.072177 769 util/log/event_log.go:32 ⋮ [n1,client=[::1]:39220,user=root] 59 ={"Timestamp":1779952743070599959,"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›"} I260528 07:19:04.645322 215 1@gossip/gossip.go:1547 ⋮ [n1] 60 node has connected to cluster via gossip I260528 07:19:04.649211 215 kv/kvserver/stores.go:269 ⋮ [n1] 61 wrote 0 node addresses to persistent storage I260528 07:19:09.890126 1 1@cli/start.go:749 ⋮ [n1] 62 received signal 'terminated' I260528 07:19:09.890180 1 1@cli/start.go:846 ⋮ [n1] 63 ‹initiating graceful shutdown of server› I260528 07:19:09.890221 2057 1@server/drain.go:342 ⋮ [n1,server drain process] 64 ‹waiting for health probes to notice that the node is not ready for new sql connections› I260528 07:19:09.890233 2057 1@sql/pgwire/server.go:612 ⋮ [n1,server drain process] 65 ‹starting draining SQL connections› I260528 07:19:11.088022 1710 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39270,user=root] 66 ‹closing existing connection while server is draining› I260528 07:19:11.105370 1669 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39266,user=root] 67 ‹closing existing connection while server is draining› I260528 07:19:11.105370 1712 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39268,user=root] 68 ‹closing existing connection while server is draining› I260528 07:19:11.113517 1670 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39264,user=root] 69 ‹closing existing connection while server is draining› I260528 07:19:11.131668 1507 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39262,user=root] 70 ‹closing existing connection while server is draining› I260528 07:19:11.134861 1858 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39274,user=root] 71 ‹closing existing connection while server is draining› I260528 07:19:11.137973 1862 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39276,user=root] 72 ‹closing existing connection while server is draining› I260528 07:19:11.144100 1449 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39258,user=root] 73 ‹closing existing connection while server is draining› I260528 07:19:11.149235 1396 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39260,user=root] 74 ‹closing existing connection while server is draining› I260528 07:19:11.181461 1475 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39254,user=root] 75 ‹closing existing connection while server is draining› I260528 07:19:11.183574 1490 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39256,user=root] 76 ‹closing existing connection while server is draining› I260528 07:19:11.207831 867 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39244,user=root] 77 ‹closing existing connection while server is draining› I260528 07:19:11.227919 1197 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39252,user=root] 78 ‹closing existing connection while server is draining› I260528 07:19:11.264536 1196 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39250,user=root] 79 ‹closing existing connection while server is draining› I260528 07:19:11.751220 792 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39222,user=root] 80 ‹closing existing connection while server is draining› I260528 07:19:11.752240 836 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:39226,user=root] 81 ‹closing existing connection while server is draining› I260528 07:19:11.752340 2057 sql/sqlstats/persistedsqlstats/flush.go:68 ⋮ [n1,server drain process] 82 flushing 212 stmt/txn fingerprints (204800 bytes) after 1.47µs I260528 07:19:12.097786 2057 1@server/drain.go:285 ⋮ [n1,server drain process] 83 drain remaining: 204 I260528 07:19:12.097855 2057 1@server/drain.go:287 ⋮ [n1,server drain process] 84 drain details: SQL clients: 16, descriptor leases: 187, liveness record: 1 E260528 07:19:12.167589 465 jobs/registry.go:738 ⋮ [n1] 85 error expiring job sessions: ‹expire-sessions›: cannot acquire lease when draining E260528 07:19:12.169863 465 jobs/registry.go:746 ⋮ [n1] 86 failed to serve pause and cancel requests: could not query jobs table: ‹cancel/pause-requested›: cannot acquire lease when draining I260528 07:19:12.298415 2057 sql/sqlstats/persistedsqlstats/flush.go:68 ⋮ [n1,server drain process] 87 flushing 2 stmt/txn fingerprints (10240 bytes) after 1.55µs W260528 07:19:12.299282 2057 sql/sqlstats/persistedsqlstats/flush.go:170 ⋮ [n1,server drain process] 88 ‹failed to flush statement statistics›: flush statement ‹4025915790256006928›'s statistics: ‹insert-stmt-stats›: cannot acquire lease when draining W260528 07:19:12.299493 2057 sql/sqlstats/persistedsqlstats/flush.go:170 ⋮ [n1,server drain process] 89 ‹failed to flush transaction statistics›: flushing transaction ‹11006041404254834895›'s statistics: ‹insert-txn-stats›: cannot acquire lease when draining I260528 07:19:12.305856 2057 1@server/drain.go:285 ⋮ [n1,server drain process] 90 drain remaining: 0 W260528 07:19:12.305933 2704 kv/kvserver/intentresolver/intent_resolver.go:793 ⋮ [-] 91 failed to gc transaction record: could not GC completed transaction anchored at ‹/Table/43/1/4/2026-05-28T07:00:00Z/"GC\xb7>\xff\x8e\t\xcb"/"$ internal-get-table-statistics"/1›: ‹node unavailable; try another peer› I260528 07:19:12.305956 460 sql/stats/automatic_stats.go:489 ⋮ [n1] 92 ‹quiescing auto stats refresher› W260528 07:19:12.305983 465 jobs/registry.go:815 ⋮ [n1] 93 canceling all adopted jobs due to stopper quiescing W260528 07:19:12.306037 435 sql/sqlliveness/slinstance/slinstance.go:235 ⋮ [n1] 94 ‹exiting heartbeat loop› I260528 07:19:12.317524 1 1@cli/start.go:898 ⋮ [n1] 95 server drained and shutdown completed