Max level shown:
1 I250125 03:38:23.246660 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2025/01/25 03:38:23
2 I250125 03:38:23.246669 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01JJDP0GE8E03KHSZ361H3MQR2›
3 I250125 03:38:23.246675 1 util/log/file_sync_buffer.go:238 ⋮ [config] binary: CockroachDB OSS v22.1.22-27-g76e176e260 (x86_64-linux-gnu, built 2024/10/23 21:35:46, go1.17.13)
4 I250125 03:38:23.246682 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmplox3Cb/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmplox3Cb/listen-url›]
5 I250125 03:38:23.246697 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2
6 I250125 03:38:23.246700 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 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED!
8 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +
9 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only.
10 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +
11 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode:
12 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
13 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
14 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
15 W250125 03:38:23.246349 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
16 I250125 03:38:23.246817 1 1@cli/start.go:1196 ⋮ [n?] 2 To start a secure server without mandating TLS for clients,
17 I250125 03:38:23.246817 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
18 I250125 03:38:23.246817 1 1@cli/start.go:1196 ⋮ [n?] 2 +
19 I250125 03:38:23.246817 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
20 I250125 03:38:23.246817 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
21 I250125 03:38:23.247079 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
22 W250125 03:38:23.247097 1 1@cli/start.go:1112 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).›
23 W250125 03:38:23.247097 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.›
24 W250125 03:38:23.247097 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).›
25 I250125 03:38:23.247304 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
26 I250125 03:38:23.247320 1 1@cli/start.go:1225 ⋮ [n?] 6 ‹CockroachDB OSS v22.1.22-27-g76e176e260 (x86_64-linux-gnu, built 2024/10/23 21:35:46, go1.17.13)›
27 I250125 03:38:23.249291 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
28 I250125 03:38:23.249308 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB
29 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 server configuration:
30 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000›
31 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB›
32 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 7.7 GiB›
33 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s›
34 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms›
35 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s›
36 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true›
37 I250125 03:38:23.249320 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true›
38 I250125 03:38:23.249403 1 1@cli/start.go:1090 ⋮ [n?] 10 using local environment variables:
39 I250125 03:38:23.249403 1 1@cli/start.go:1090 ⋮ [n?] 10 +GOTRACEBACK=crash
40 I250125 03:38:23.249403 1 1@cli/start.go:1090 ⋮ [n?] 10 +LANG=‹en_US.UTF-8›
41 I250125 03:38:23.249403 1 1@cli/start.go:1090 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8›
42 I250125 03:38:23.249403 1 1@cli/start.go:1090 ⋮ [n?] 10 +TZ=‹UTC›
43 I250125 03:38:23.249430 1 1@cli/start.go:1097 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
44 W250125 03:38:23.249616 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 I250125 03:38:23.249674 1 1@cli/start.go:581 ⋮ [n?] 13 starting cockroach node
46 I250125 03:38:23.480455 82 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized
47 I250125 03:38:23.480493 82 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB
48 I250125 03:38:23.480509 82 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 10000
49 I250125 03:38:23.480516 82 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmplox3Cb/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}}
50 I250125 03:38:23.482912 82 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/logs/inflight_trace_dump›
51 I250125 03:38:23.555677 82 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
52 I250125 03:38:23.575210 82 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1737776303575206995 to catches up to 1737776304055667256 to ensure monotonicity. Delta: 480.460261ms
53 I250125 03:38:23.575268 156 1@server/server.go:1319 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"8925ca43-d8f7-4cbb-9eeb-ae027f444815"›
54 I250125 03:38:24.055773 82 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmplox3Cb/listen-url›
55 W250125 03:38:24.069967 82 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node
56 I250125 03:38:24.070041 82 gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:46307" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-27-g76e176e260" started_at:1737776304070036376 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:46307" > http_address:<network_field:"tcp" address_field:"[::1]:34955" >›
57 I250125 03:38:24.090816 82 server/node.go:470 ⋮ [n1] 25 initialized store s1
58 I250125 03:38:24.090886 82 kv/kvserver/stores.go:250 ⋮ [n1] 26 read 0 node addresses from persistent storage
59 I250125 03:38:24.091199 156 1@server/server.go:1322 ⋮ [n1] 27 node connected via gossip
60 I250125 03:38:24.110237 82 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2›
61 I250125 03:38:24.110303 82 server/node.go:551 ⋮ [n1] 29 started with attributes []
62 I250125 03:38:24.110383 82 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/logs/goroutine_dump›
63 I250125 03:38:24.110421 82 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/logs/heap_profiler› at least every 1h0m0s
64 I250125 03:38:24.110442 82 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 I250125 03:38:24.110453 82 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/logs/heap_profiler› at last every 1h0m0s
66 I250125 03:38:24.110633 82 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/logs/heap_profiler›
67 I250125 03:38:24.110719 82 1@server/server.go:1458 ⋮ [n1] 35 starting http server at ‹[::1]:34955› (use: ‹[::1]:34955›)
68 I250125 03:38:24.110756 82 1@server/server.go:1465 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:46307›
69 I250125 03:38:24.110778 82 1@server/server.go:1466 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:46307›
70 I250125 03:38:24.198729 360 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache
71 I250125 03:38:24.218265 82 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1737776304218263368,"EventType":"node_restart","NodeID":1,"StartedAt":1737776304070036376,"LastUp":1737774372504954725}
72 I250125 03:38:24.218333 82 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance
73 I250125 03:38:24.243828 789 sql/temporary_schema.go:514 ⋮ [n1] 41 running temporary object cleanup background job
74 I250125 03:38:24.243860 791 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 42 starting sql-stats-worker with initial delay: 10m28.696203504s
75 I250125 03:38:24.244219 808 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 43 RangeFeed closed timestamp 1737774359.836218041,0 is behind by 32m24.407998675s
76 I250125 03:38:24.244739 789 sql/temporary_schema.go:559 ⋮ [n1] 44 found 0 temporary schemas
77 I250125 03:38:24.244759 789 sql/temporary_schema.go:562 ⋮ [n1] 45 early exiting temporary schema cleaner as no temporary schemas were found
78 I250125 03:38:24.244773 789 sql/temporary_schema.go:563 ⋮ [n1] 46 completed temporary object cleanup job
79 I250125 03:38:24.244784 789 sql/temporary_schema.go:646 ⋮ [n1] 47 temporary object cleaner next scheduled to run at 2025-01-25 04:08:24.243777756 +0000 UTC
80 I250125 03:38:24.244854 820 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 48 settings-watcher: established range feed cache
81 I250125 03:38:24.245419 82 server/server_sql.go:1295 ⋮ [n1] 49 done ensuring all necessary startup migrations have run
82 I250125 03:38:24.245607 851 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 50 tenant-settings-watcher: established range feed cache
83 I250125 03:38:24.245817 783 jobs/job_scheduler.go:433 ⋮ [n1] 51 waiting 3m0s before scheduled jobs daemon start
84 I250125 03:38:24.245908 781 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 52 system-config-cache: established range feed cache
85 I250125 03:38:24.249451 364 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 53 inserted sqlliveness session fe323df9edd64370928fadcc75275445
86 I250125 03:38:24.249480 364 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 54 created new SQL liveness session fe323df9edd64370928fadcc75275445
87 I250125 03:38:24.265413 850 server/auto_upgrade.go:79 ⋮ [n1] 55 no need to upgrade, cluster already at the newest version
88 I250125 03:38:24.328290 965 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56 deleted session cd89a8d037244421b2414f1d54209037 which expired at 1737774412.292231323,0
89 I250125 03:38:24.370638 82 1@server/server_sql.go:1365 ⋮ [n1] 57 serving sql connections
90 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 node startup completed:
91 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +CockroachDB node starting at 2025-01-25 03:38:24.370684108 +0000 UTC (took 1.1s)
92 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +build: OSS v22.1.22-27-g76e176e260 @ 2024/10/23 21:35:46 (go1.17.13)
93 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +webui: ‹http://[::1]:34955›
94 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +sql: ‹postgresql://root@[::1]:46307/defaultdb?sslmode=disable›
95 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +sql (JDBC): ‹jdbc:postgresql://[::1]:46307/defaultdb?sslmode=disable&user=root›
96 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +RPC client flags: ‹cockroach <client cmd> --host=[::1]:46307 --insecure›
97 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +logs: ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/logs›
98 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +temp dir: ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/cockroach-temp1638629745›
99 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +external I/O path: ‹/var/tmp/omicron_tmp/.tmplox3Cb/data/extern›
100 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmplox3Cb/data›
101 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +storage engine: pebble
102 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +clusterID: ‹8925ca43-d8f7-4cbb-9eeb-ae027f444815›
103 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +status: restarted pre-existing node
104 I250125 03:38:24.370834 82 1@cli/start.go:1033 ⋮ [n1] 58 +nodeID: 1
105 I250125 03:38:24.575791 1043 server/diagnostics/update_checker.go:150 ⋮ [n1] 59 a new version is available: ‹25.1.0-beta.1›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.1#v25-1-0-beta-1›
106 I250125 03:38:25.930820 194 1@gossip/gossip.go:1547 ⋮ [n1] 60 node has connected to cluster via gossip
107 I250125 03:38:25.933929 194 kv/kvserver/stores.go:269 ⋮ [n1] 61 wrote 0 node addresses to persistent storage
108 I250125 03:38:31.796924 1142 util/log/event_log.go:32 ⋮ [n1,client=[::1]:33430,user=root] 62 ={"Timestamp":1737776311756475594,"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›"}
109 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63
110 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 +__level_____count____size___score______in__ingest(sz_cnt)____move(sz_cnt)___write(sz_cnt)____read___r-amp___w-amp
111 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + WAL 2 2.2 M - 2.2 M - - - - 2.2 M - - - 1.0
112 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + 0 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0
113 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + 1 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0
114 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + 2 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0
115 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + 3 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0
116 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + 4 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0
117 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + 5 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0
118 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + 6 1 685 K - 1.2 M 0 B 0 0 B 0 685 K 1 1.2 M 1 0.5
119 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + total 1 685 K - 2.2 M 0 B 0 0 B 0 2.9 M 1 1.2 M 1 1.3
120 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + flush 0
121 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 +compact 1 0 B 1.2 M 0 (size == estimated-debt, score = in-progress-bytes, in = num-in-progress)
122 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + ctype 1 0 0 0 0 0 (default, delete, elision, move, read, rewrite)
123 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + memtbl 2 64 M
124 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 +zmemtbl 0 0 B
125 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + ztbl 0 0 B
126 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + bcache 44 1.3 M 99.1% (score == hit-rate)
127 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + tcache 1 680 B 99.9% (score == hit-rate)
128 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + snaps 0 - 0 (score == earliest seq num)
129 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + titers 0
130 I250125 03:38:44.111857 132 kv/kvserver/store.go:3290 ⋮ [n1,s1] 63 + filter - - 0.0% (score == utility)