I260624 02:04:13.007907 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2026/06/24 02:04:13 I260624 02:04:13.007912 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01KVVMVY1VWNENA227KNPYHTRR› I260624 02:04:13.007923 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:13.007926 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpjJWvga/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpjJWvga/listen-url› ‹--max-sql-memory› ‹256MiB›] I260624 02:04:13.007934 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 I260624 02:04:13.007936 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:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! W260624 02:04:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 + W260624 02:04:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 +This mode is intended for non-production testing only. W260624 02:04:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 + W260624 02:04:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 +In this mode: W260624 02:04:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. W260624 02:04:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. W260624 02:04:13.007861 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:13.007861 1 1@cli/start.go:1180 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. I260624 02:04:13.007994 1 1@cli/start.go:1190 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, I260624 02:04:13.007994 1 1@cli/start.go:1190 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: I260624 02:04:13.007994 1 1@cli/start.go:1190 ⋮ [n?] 2 + I260624 02:04:13.007994 1 1@cli/start.go:1190 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› I260624 02:04:13.007994 1 1@cli/start.go:1190 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html I260624 02:04:13.008141 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:13.008150 1 1@cli/start.go:1106 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› W260624 02:04:13.008150 1 1@cli/start.go:1106 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› W260624 02:04:13.008150 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:13.008214 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:13.008219 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:13.008516 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:13.008523 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 server configuration: I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 256 MiB› I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› I260624 02:04:13.008532 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› I260624 02:04:13.008575 1 1@cli/start.go:1084 ⋮ [n?] 10 using local environment variables: I260624 02:04:13.008575 1 1@cli/start.go:1084 ⋮ [n?] 10 +GOTRACEBACK=crash I260624 02:04:13.008575 1 1@cli/start.go:1084 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› I260624 02:04:13.008575 1 1@cli/start.go:1084 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› I260624 02:04:13.008575 1 1@cli/start.go:1084 ⋮ [n?] 10 +TZ=‹UTC› I260624 02:04:13.008582 1 1@cli/start.go:1091 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› W260624 02:04:13.008727 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:13.008760 1 1@cli/start.go:581 ⋮ [n?] 13 ‹starting cockroach node› I260624 02:04:13.179769 48 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized I260624 02:04:13.179817 48 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB I260624 02:04:13.179824 48 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 519288 I260624 02:04:13.179827 48 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpjJWvga/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} I260624 02:04:13.180625 48 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/logs/inflight_trace_dump› I260624 02:04:13.236963 48 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 ‹monitoring forward clock jumps based on server.clock.forward_jump_check_enabled› I260624 02:04:13.243143 48 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1782266653243141798 to catches up to 1782266653736956919 to ensure monotonicity. Delta: 493.815121ms I260624 02:04:13.243172 200 1@server/server.go:1294 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"f7a658b2-b58d-40f9-8779-4846dceb6ba0"› I260624 02:04:13.737337 48 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmpjJWvga/listen-url› W260624 02:04:13.754440 48 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node I260624 02:04:13.754487 48 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:1782266653754481596 cluster_name:"" sql_address: http_address:› I260624 02:04:13.757233 48 server/node.go:470 ⋮ [n1] 25 initialized store s1 I260624 02:04:13.757268 48 kv/kvserver/stores.go:250 ⋮ [n1] 26 read 0 node addresses from persistent storage I260624 02:04:13.757354 200 1@server/server.go:1297 ⋮ [n1] 27 node connected via gossip I260624 02:04:13.762582 48 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2› I260624 02:04:13.762614 48 server/node.go:551 ⋮ [n1] 29 started with attributes [] I260624 02:04:13.762646 48 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/logs/goroutine_dump› I260624 02:04:13.762659 48 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/logs/heap_profiler› at least every 1h0m0s I260624 02:04:13.762668 48 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:13.762674 48 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/logs/heap_profiler› at last every 1h0m0s I260624 02:04:13.762788 48 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/logs/heap_profiler› I260624 02:04:13.762830 48 1@server/server.go:1423 ⋮ [n1] 35 starting http server at ‹[::1]:41417› (use: ‹[::1]:41417›) I260624 02:04:13.762843 48 1@server/server.go:1430 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:38867› I260624 02:04:13.762851 48 1@server/server.go:1431 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:38867› I260624 02:04:13.857524 365 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache I260624 02:04:13.867050 48 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1782266653867046959,"EventType":"node_restart","NodeID":1,"StartedAt":1782266653754481596,"LastUp":1782266193032257532} I260624 02:04:13.867092 48 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance I260624 02:04:13.896888 570 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 41 settings-watcher: established range feed cache I260624 02:04:13.896967 555 sql/temporary_schema.go:514 ⋮ [n1] 42 running temporary object cleanup background job I260624 02:04:13.897454 555 sql/temporary_schema.go:559 ⋮ [n1] 43 found 0 temporary schemas I260624 02:04:13.897465 555 sql/temporary_schema.go:562 ⋮ [n1] 44 early exiting temporary schema cleaner as no temporary schemas were found I260624 02:04:13.897473 555 sql/temporary_schema.go:563 ⋮ [n1] 45 completed temporary object cleanup job I260624 02:04:13.897478 555 sql/temporary_schema.go:646 ⋮ [n1] 46 temporary object cleaner next scheduled to run at 2026-06-24 02:34:13.896945562 +0000 UTC I260624 02:04:13.897496 557 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 47 starting sql-stats-worker with initial delay: 9m17.61071847s I260624 02:04:13.898198 48 server/server_sql.go:1287 ⋮ [n1] 48 done ensuring all necessary startup migrations have run I260624 02:04:13.898256 579 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 49 system-config-cache: established range feed cache I260624 02:04:13.898317 585 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 50 tenant-settings-watcher: established range feed cache I260624 02:04:13.898716 581 jobs/job_scheduler.go:433 ⋮ [n1] 51 waiting 2m0s before scheduled jobs daemon start I260624 02:04:13.899064 597 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 52 RangeFeed closed timestamp 1782266189.174448507,0 is behind by 7m44.724614748s I260624 02:04:13.900010 369 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 53 inserted sqlliveness session a91643346d574b66b27de41b3526a11e I260624 02:04:13.900026 369 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 54 created new SQL liveness session a91643346d574b66b27de41b3526a11e I260624 02:04:13.902338 584 server/auto_upgrade.go:79 ⋮ [n1] 55 ‹no need to upgrade, cluster already at the newest version› I260624 02:04:13.936034 714 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56 deleted session 11c243c9bd5d46f5b19b29214c3f28f0 which expired at 1782266230.779611493,0 I260624 02:04:13.956363 48 1@server/server_sql.go:1350 ⋮ [n1] 57 ‹serving sql connections› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 node startup completed: I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +CockroachDB node starting at 2026-06-24 02:04:13.956406044 +0000 UTC (took 1.0s) I260624 02:04:13.956502 48 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:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +webui: ‹http://[::1]:41417› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +sql: ‹postgresql://root@[::1]:38867/defaultdb?sslmode=disable› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +sql (JDBC): ‹jdbc:postgresql://[::1]:38867/defaultdb?sslmode=disable&user=root› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +RPC client flags: ‹cockroach --host=[::1]:38867 --insecure› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +logs: ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/logs› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +temp dir: ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/cockroach-temp2869731610› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +external I/O path: ‹/var/tmp/omicron_tmp/.tmpjJWvga/data/extern› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmpjJWvga/data› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +storage engine: pebble I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +clusterID: ‹f7a658b2-b58d-40f9-8779-4846dceb6ba0› I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +status: restarted pre-existing node I260624 02:04:13.956502 48 1@cli/start.go:1027 ⋮ [n1] 58 +nodeID: 1 I260624 02:04:13.974114 775 util/log/event_log.go:32 ⋮ [n1,client=[::1]:54424,user=root] 59 ={"Timestamp":1782266653972187845,"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:15.386162 167 1@gossip/gossip.go:1547 ⋮ [n1] 60 node has connected to cluster via gossip I260624 02:04:15.391252 167 kv/kvserver/stores.go:269 ⋮ [n1] 61 wrote 0 node addresses to persistent storage I260624 02:04:18.669938 733 util/log/event_log.go:32 ⋮ [n1,client=[::1]:54438,user=root] 62 ={"Timestamp":1782266658667700527,"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:19.426339 1 1@cli/start.go:749 ⋮ [n1] 63 received signal 'terminated' I260624 02:04:19.427610 1 1@cli/start.go:846 ⋮ [n1] 64 ‹initiating graceful shutdown of server› I260624 02:04:19.427677 2316 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:19.427689 2316 1@sql/pgwire/server.go:612 ⋮ [n1,server drain process] 66 ‹starting draining SQL connections› I260624 02:04:20.950176 1441 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54466,user=root] 67 ‹closing existing connection while server is draining› I260624 02:04:20.950330 1484 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54468,user=root] 68 ‹closing existing connection while server is draining› I260624 02:04:20.950349 1530 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54472,user=root] 69 ‹closing existing connection while server is draining› I260624 02:04:21.013333 1532 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54470,user=root] 70 ‹closing existing connection while server is draining› I260624 02:04:21.019576 1471 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54464,user=root] 71 ‹closing existing connection while server is draining› I260624 02:04:21.213444 834 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54446,user=root] 72 ‹closing existing connection while server is draining› I260624 02:04:21.222801 1511 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54458,user=root] 73 ‹closing existing connection while server is draining› I260624 02:04:21.273373 822 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54440,user=root] 74 ‹closing existing connection while server is draining› I260624 02:04:21.301725 732 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54438,user=root] 75 ‹closing existing connection while server is draining› I260624 02:04:21.302768 825 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54444,user=root] 76 ‹closing existing connection while server is draining› I260624 02:04:21.337050 807 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54432,user=root] 77 ‹closing existing connection while server is draining› I260624 02:04:21.384362 735 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54442,user=root] 78 ‹closing existing connection while server is draining› I260624 02:04:21.384362 1512 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54462,user=root] 79 ‹closing existing connection while server is draining› I260624 02:04:21.395606 784 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54430,user=root] 80 ‹closing existing connection while server is draining› I260624 02:04:21.414147 819 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54436,user=root] 81 ‹closing existing connection while server is draining› I260624 02:04:21.414281 804 1@sql/pgwire/conn.go:601 ⋮ [n1,client=[::1]:54428,user=root] 82 ‹closing existing connection while server is draining› I260624 02:04:21.414351 2316 sql/sqlstats/persistedsqlstats/flush.go:68 ⋮ [n1,server drain process] 83 flushing 323 stmt/txn fingerprints (215040 bytes) after 1.11µs I260624 02:04:21.976770 2316 1@server/drain.go:285 ⋮ [n1,server drain process] 84 drain remaining: 237 I260624 02:04:21.976819 2316 1@server/drain.go:287 ⋮ [n1,server drain process] 85 drain details: SQL clients: 16, descriptor leases: 220, liveness record: 1 I260624 02:04:22.177808 2316 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:22.178713 2316 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:22.179965 2316 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:22.186673 2316 1@server/drain.go:285 ⋮ [n1,server drain process] 89 drain remaining: 0 W260624 02:04:22.186819 566 jobs/registry.go:815 ⋮ [n1] 90 canceling all adopted jobs due to stopper quiescing I260624 02:04:22.186951 561 sql/stats/automatic_stats.go:489 ⋮ [n1] 91 ‹quiescing auto stats refresher› W260624 02:04:22.187079 369 sql/sqlliveness/slinstance/slinstance.go:235 ⋮ [n1] 92 ‹exiting heartbeat loop› I260624 02:04:22.200269 1 1@cli/start.go:898 ⋮ [n1] 93 server drained and shutdown completed