| 1 | I251103 21:57:08.342497 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2025/11/03 21:57:08 | ||
| 2 | I251103 21:57:08.342506 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01K95S4XHP32MZJ9BGTZR0NNZM› | ||
| 3 | I251103 21:57:08.342515 1 util/log/file_sync_buffer.go:238 ⋮ [config] binary: CockroachDB OSS v22.1.22-44-g2eee7afbdf (x86_64-linux-gnu, built 2025/07/29 23:10:38, go1.22.11) | ||
| 4 | I251103 21:57:08.342523 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpleQ0dt/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpleQ0dt/listen-url›] | ||
| 5 | I251103 21:57:08.342538 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 | ||
| 6 | I251103 21:57:08.342542 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 | ||
| 7 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! | ||
| 8 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 + | ||
| 9 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only. | ||
| 10 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 + | ||
| 11 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode: | ||
| 12 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. | ||
| 13 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. | ||
| 14 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. | ||
| 15 | W251103 21:57:08.342403 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. | ||
| 16 | I251103 21:57:08.342652 1 1@cli/start.go:1196 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, | ||
| 17 | I251103 21:57:08.342652 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: | ||
| 18 | I251103 21:57:08.342652 1 1@cli/start.go:1196 ⋮ [n?] 2 + | ||
| 19 | I251103 21:57:08.342652 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› | ||
| 20 | I251103 21:57:08.342652 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html | ||
| 21 | I251103 21:57:08.342917 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 22 | W251103 21:57:08.342940 1 1@cli/start.go:1112 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› | ||
| 23 | W251103 21:57:08.342940 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› | ||
| 24 | W251103 21:57:08.342940 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).› | ||
| 25 | I251103 21:57:08.343130 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 26 | I251103 21:57:08.343144 1 1@cli/start.go:1225 ⋮ [n?] 6 ‹CockroachDB OSS v22.1.22-44-g2eee7afbdf (x86_64-linux-gnu, built 2025/07/29 23:10:38, go1.22.11)› | ||
| 27 | I251103 21:57:08.343837 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 28 | I251103 21:57:08.343855 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB | ||
| 29 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 server configuration: | ||
| 30 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› | ||
| 31 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› | ||
| 32 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 7.7 GiB› | ||
| 33 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› | ||
| 34 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› | ||
| 35 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› | ||
| 36 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› | ||
| 37 | I251103 21:57:08.343874 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› | ||
| 38 | I251103 21:57:08.343952 1 1@cli/start.go:1090 ⋮ [n?] 10 using local environment variables: | ||
| 39 | I251103 21:57:08.343952 1 1@cli/start.go:1090 ⋮ [n?] 10 +GOTRACEBACK=crash | ||
| 40 | I251103 21:57:08.343952 1 1@cli/start.go:1090 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› | ||
| 41 | I251103 21:57:08.343952 1 1@cli/start.go:1090 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› | ||
| 42 | I251103 21:57:08.343952 1 1@cli/start.go:1090 ⋮ [n?] 10 +TZ=‹UTC› | ||
| 43 | I251103 21:57:08.343971 1 1@cli/start.go:1097 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› | ||
| 44 | W251103 21:57:08.344206 1 1@cli/start.go:1310 ⋮ [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› | ||
| 45 | I251103 21:57:08.344268 1 1@cli/start.go:581 ⋮ [n?] 13 starting cockroach node | ||
| 46 | I251103 21:57:08.559209 85 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized | ||
| 47 | I251103 21:57:08.559252 85 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB | ||
| 48 | I251103 21:57:08.559271 85 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 519288 | ||
| 49 | I251103 21:57:08.559281 85 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpleQ0dt/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} | ||
| 50 | I251103 21:57:08.560666 85 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/logs/inflight_trace_dump› | ||
| 51 | I251103 21:57:08.653618 85 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled | ||
| 52 | I251103 21:57:08.664549 85 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1762207028664545885 to catches up to 1762207029153605284 to ensure monotonicity. Delta: 489.059399ms | ||
| 53 | I251103 21:57:08.664599 199 1@server/server.go:1319 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"6d0eef7e-e68c-4e01-a871-716005e77a83"› | ||
| 54 | I251103 21:57:09.153900 85 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmpleQ0dt/listen-url› | ||
| 55 | W251103 21:57:09.165336 85 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node | ||
| 56 | I251103 21:57:09.165420 85 gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:36879" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-44-g2eee7afbdf" started_at:1762207029165412592 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:36879" > http_address:<network_field:"tcp" address_field:"[::1]:39103" >› | ||
| 57 | I251103 21:57:09.172573 85 server/node.go:470 ⋮ [n1] 25 initialized store s1 | ||
| 58 | I251103 21:57:09.172645 85 kv/kvserver/stores.go:250 ⋮ [n1] 26 read 0 node addresses from persistent storage | ||
| 59 | I251103 21:57:09.173202 199 1@server/server.go:1322 ⋮ [n1] 27 node connected via gossip | ||
| 60 | I251103 21:57:09.176002 85 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2› | ||
| 61 | I251103 21:57:09.176063 85 server/node.go:551 ⋮ [n1] 29 started with attributes [] | ||
| 62 | I251103 21:57:09.176132 85 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/logs/goroutine_dump› | ||
| 63 | I251103 21:57:09.176160 85 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/logs/heap_profiler› at least every 1h0m0s | ||
| 64 | I251103 21:57:09.176177 85 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 32 to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf" | ||
| 65 | I251103 21:57:09.176190 85 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/logs/heap_profiler› at last every 1h0m0s | ||
| 66 | I251103 21:57:09.176387 85 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/logs/heap_profiler› | ||
| 67 | I251103 21:57:09.176456 85 1@server/server.go:1458 ⋮ [n1] 35 starting http server at ‹[::1]:39103› (use: ‹[::1]:39103›) | ||
| 68 | I251103 21:57:09.176480 85 1@server/server.go:1465 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:36879› | ||
| 69 | I251103 21:57:09.176499 85 1@server/server.go:1466 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:36879› | ||
| 70 | I251103 21:57:09.289819 80 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache | ||
| 71 | I251103 21:57:09.309980 85 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1762207029309976604,"EventType":"node_restart","NodeID":1,"StartedAt":1762207029165412592,"LastUp":1762205545813487475} | ||
| 72 | I251103 21:57:09.310040 85 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance | ||
| 73 | I251103 21:57:09.335107 542 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 41 settings-watcher: established range feed cache | ||
| 74 | I251103 21:57:09.335685 399 sql/temporary_schema.go:514 ⋮ [n1] 42 running temporary object cleanup background job | ||
| 75 | I251103 21:57:09.336746 399 sql/temporary_schema.go:559 ⋮ [n1] 43 found 0 temporary schemas | ||
| 76 | I251103 21:57:09.336767 399 sql/temporary_schema.go:562 ⋮ [n1] 44 early exiting temporary schema cleaner as no temporary schemas were found | ||
| 77 | I251103 21:57:09.336783 399 sql/temporary_schema.go:563 ⋮ [n1] 45 completed temporary object cleanup job | ||
| 78 | I251103 21:57:09.336795 399 sql/temporary_schema.go:646 ⋮ [n1] 46 temporary object cleaner next scheduled to run at 2025-11-03 22:27:09.335648749 +0000 UTC | ||
| 79 | I251103 21:57:09.337948 401 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 47 starting sql-stats-worker with initial delay: 11m16.321988438s | ||
| 80 | I251103 21:57:09.341487 386 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 48 inserted sqlliveness session a9aeaa6721d34d9fb6d32cd627ec1b74 | ||
| 81 | I251103 21:57:09.341528 386 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 49 created new SQL liveness session a9aeaa6721d34d9fb6d32cd627ec1b74 | ||
| 82 | I251103 21:57:09.342037 85 server/server_sql.go:1295 ⋮ [n1] 50 done ensuring all necessary startup migrations have run | ||
| 83 | I251103 21:57:09.342259 580 jobs/job_scheduler.go:433 ⋮ [n1] 51 waiting 3m0s before scheduled jobs daemon start | ||
| 84 | I251103 21:57:09.342314 584 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 52 tenant-settings-watcher: established range feed cache | ||
| 85 | I251103 21:57:09.342345 578 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 53 system-config-cache: established range feed cache | ||
| 86 | I251103 21:57:09.344823 554 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 54 RangeFeed closed timestamp 1762205542.595493581,0 is behind by 24m46.749326573s | ||
| 87 | I251103 21:57:09.349119 583 server/auto_upgrade.go:79 ⋮ [n1] 55 no need to upgrade, cluster already at the newest version | ||
| 88 | I251103 21:57:09.365885 494 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56 deleted session 20a798b34a8d45819a8b3b86d3c30de6 which expired at 1762205582.869313353,0 | ||
| 89 | I251103 21:57:09.404576 85 1@server/server_sql.go:1365 ⋮ [n1] 57 serving sql connections | ||
| 90 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 node startup completed: | ||
| 91 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +CockroachDB node starting at 2025-11-03 21:57:09.404663849 +0000 UTC (took 1.1s) | ||
| 92 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +build: OSS v22.1.22-44-g2eee7afbdf @ 2025/07/29 23:10:38 (go1.22.11) | ||
| 93 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +webui: ‹http://[::1]:39103› | ||
| 94 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +sql: ‹postgresql://root@[::1]:36879/defaultdb?sslmode=disable› | ||
| 95 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +sql (JDBC): ‹jdbc:postgresql://[::1]:36879/defaultdb?sslmode=disable&user=root› | ||
| 96 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +RPC client flags: ‹cockroach <client cmd> --host=[::1]:36879 --insecure› | ||
| 97 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +logs: ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/logs› | ||
| 98 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +temp dir: ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/cockroach-temp4234085653› | ||
| 99 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +external I/O path: ‹/var/tmp/omicron_tmp/.tmpleQ0dt/data/extern› | ||
| 100 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmpleQ0dt/data› | ||
| 101 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +storage engine: pebble | ||
| 102 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +clusterID: ‹6d0eef7e-e68c-4e01-a871-716005e77a83› | ||
| 103 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +status: restarted pre-existing node | ||
| 104 | I251103 21:57:09.404828 85 1@cli/start.go:1033 ⋮ [n1] 58 +nodeID: 1 | ||
| 105 | I251103 21:57:09.423381 685 util/log/event_log.go:32 ⋮ [n1,client=[::1]:53998,user=root] 59 ={"Timestamp":1762207029417628127,"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›"} | ||
| 106 | I251103 21:57:09.594033 617 server/diagnostics/update_checker.go:150 ⋮ [n1] 60 a new version is available: ‹25.4.0-rc.1›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.4#v25-4-0-rc-1› | ||
| 107 | I251103 21:57:11.139683 211 1@gossip/gossip.go:1547 ⋮ [n1] 61 node has connected to cluster via gossip | ||
| 108 | I251103 21:57:11.143395 211 kv/kvserver/stores.go:269 ⋮ [n1] 62 wrote 0 node addresses to persistent storage | ||
| 109 | I251103 21:57:16.168634 801 util/log/event_log.go:32 ⋮ [n1,client=[::1]:54002,user=root] 63 ={"Timestamp":1762207036165846464,"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›"} | ||