Max level shown:
1 I250401 18:05:59.526273 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2025/04/01 18:05:59
2 I250401 18:05:59.526281 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01JQS5H9BX9S5R4CVPR9959RGZ›
3 I250401 18:05:59.526289 1 util/log/file_sync_buffer.go:238 ⋮ [config] binary: CockroachDB OSS v22.1.22-29-g865aff1595 (x86_64-linux-gnu, built 2024/11/04 18:35:23, go1.17.13)
4 I250401 18:05:59.526296 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpuoq8Uu/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/listen-url›]
5 I250401 18:05:59.526312 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2
6 I250401 18:05:59.526316 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 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED!
8 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +
9 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only.
10 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +
11 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode:
12 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›.
13 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic.
14 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster.
15 W250401 18:05:59.526155 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability.
16 I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 To start a secure server without mandating TLS for clients,
17 I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see:
18 I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +
19 I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1›
20 I250401 18:05:59.526466 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html
21 I250401 18:05:59.526731 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
22 W250401 18:05:59.526753 1 1@cli/start.go:1112 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).›
23 W250401 18:05:59.526753 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.›
24 W250401 18:05:59.526753 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).›
25 I250401 18:05:59.526945 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
26 I250401 18:05:59.526960 1 1@cli/start.go:1225 ⋮ [n?] 6 ‹CockroachDB OSS v22.1.22-29-g865aff1595 (x86_64-linux-gnu, built 2024/11/04 18:35:23, go1.17.13)›
27 I250401 18:05:59.529645 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:›
28 I250401 18:05:59.529664 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB
29 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 server configuration:
30 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000›
31 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB›
32 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 7.7 GiB›
33 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s›
34 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms›
35 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s›
36 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true›
37 I250401 18:05:59.529676 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true›
38 I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 using local environment variables:
39 I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +GOTRACEBACK=crash
40 I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +LANG=‹en_US.UTF-8›
41 I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8›
42 I250401 18:05:59.529759 1 1@cli/start.go:1090 ⋮ [n?] 10 +TZ=‹UTC›
43 I250401 18:05:59.529778 1 1@cli/start.go:1097 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345›
44 W250401 18:05:59.529993 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 I250401 18:05:59.530054 1 1@cli/start.go:581 ⋮ [n?] 13 starting cockroach node
46 I250401 18:05:59.754360 32 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized
47 I250401 18:05:59.754401 32 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB
48 I250401 18:05:59.754415 32 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 10000
49 I250401 18:05:59.754421 32 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}}
50 I250401 18:05:59.757463 32 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/inflight_trace_dump›
51 I250401 18:05:59.831221 32 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
52 I250401 18:05:59.838608 32 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1743530759838604841 to catches up to 1743530760331211958 to ensure monotonicity. Delta: 492.607117ms
53 I250401 18:05:59.838661 161 1@server/server.go:1319 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"269d6f9d-8223-4f0e-bdd9-be856a51fc82"›
54 I250401 18:06:00.331941 32 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/listen-url›
55 W250401 18:06:00.346787 32 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node
56 I250401 18:06:00.346865 32 gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:37363" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-29-g865aff1595" started_at:1743530760346846399 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:37363" > http_address:<network_field:"tcp" address_field:"[::1]:40241" >›
57 I250401 18:06:00.403743 161 1@server/server.go:1322 ⋮ [n1] 25 node connected via gossip
58 I250401 18:06:00.403840 32 server/node.go:470 ⋮ [n1] 26 initialized store s1
59 I250401 18:06:00.403892 32 kv/kvserver/stores.go:250 ⋮ [n1] 27 read 0 node addresses from persistent storage
60 I250401 18:06:00.410694 32 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2›
61 I250401 18:06:00.410743 32 server/node.go:551 ⋮ [n1] 29 started with attributes []
62 I250401 18:06:00.410808 32 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/goroutine_dump›
63 I250401 18:06:00.410844 32 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/heap_profiler› at least every 1h0m0s
64 I250401 18:06:00.410862 32 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 I250401 18:06:00.410882 32 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/heap_profiler› at last every 1h0m0s
66 I250401 18:06:00.411077 32 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs/heap_profiler›
67 I250401 18:06:00.411152 32 1@server/server.go:1458 ⋮ [n1] 35 starting http server at ‹[::1]:40241› (use: ‹[::1]:40241›)
68 I250401 18:06:00.411184 32 1@server/server.go:1465 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:37363›
69 I250401 18:06:00.411219 32 1@server/server.go:1466 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:37363›
70 I250401 18:06:00.495726 350 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache
71 I250401 18:06:00.535296 32 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1743530760535293124,"EventType":"node_restart","NodeID":1,"StartedAt":1743530760346846399,"LastUp":1743528527794925292}
72 I250401 18:06:00.535370 32 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance
73 I250401 18:06:00.560310 737 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r189/1:‹/{Table/332-Max}›] 41 initiating a split of this range at key ‹/Table/333› [r205] (‹span config›)‹›
74 I250401 18:06:00.570278 754 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 42 inserted sqlliveness session 15f54618896141b3adfd9a5eb9a057c3
75 I250401 18:06:00.570337 754 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 43 created new SQL liveness session 15f54618896141b3adfd9a5eb9a057c3
76 I250401 18:06:00.570366 803 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹spanconfig-subscriber›,s1,r43] 44 RangeFeed closed timestamp 1743528520.401193893,0 is behind by 37m20.169169327s
77 I250401 18:06:00.581094 776 sql/temporary_schema.go:514 ⋮ [n1] 45 running temporary object cleanup background job
78 I250401 18:06:00.582120 776 sql/temporary_schema.go:559 ⋮ [n1] 46 found 0 temporary schemas
79 I250401 18:06:00.582147 776 sql/temporary_schema.go:562 ⋮ [n1] 47 early exiting temporary schema cleaner as no temporary schemas were found
80 I250401 18:06:00.582162 776 sql/temporary_schema.go:563 ⋮ [n1] 48 completed temporary object cleanup job
81 I250401 18:06:00.582175 776 sql/temporary_schema.go:646 ⋮ [n1] 49 temporary object cleaner next scheduled to run at 2025-04-01 18:36:00.581050385 +0000 UTC
82 I250401 18:06:00.582222 778 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 50 starting sql-stats-worker with initial delay: 10m40.779414223s
83 I250401 18:06:00.585227 823 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 51 settings-watcher: established range feed cache
84 I250401 18:06:00.585793 32 server/server_sql.go:1295 ⋮ [n1] 52 done ensuring all necessary startup migrations have run
85 I250401 18:06:00.586006 832 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 53 tenant-settings-watcher: established range feed cache
86 I250401 18:06:00.586304 828 jobs/job_scheduler.go:433 ⋮ [n1] 54 waiting 2m0s before scheduled jobs daemon start
87 I250401 18:06:00.586352 826 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 55 system-config-cache: established range feed cache
88 I250401 18:06:00.600424 831 server/auto_upgrade.go:79 ⋮ [n1] 56 no need to upgrade, cluster already at the newest version
89 I250401 18:06:00.688522 976 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 57 deleted session 034cf85006e14632a6a702f72dc3f99f which expired at 1743528566.610414079,0
90 I250401 18:06:00.742458 32 1@server/server_sql.go:1365 ⋮ [n1] 58 serving sql connections
91 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 node startup completed:
92 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +CockroachDB node starting at 2025-04-01 18:06:00.742526896 +0000 UTC (took 1.2s)
93 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +build: OSS v22.1.22-29-g865aff1595 @ 2024/11/04 18:35:23 (go1.17.13)
94 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +webui: ‹http://[::1]:40241›
95 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +sql: ‹postgresql://root@[::1]:37363/defaultdb?sslmode=disable›
96 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +sql (JDBC): ‹jdbc:postgresql://[::1]:37363/defaultdb?sslmode=disable&user=root›
97 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +RPC client flags: ‹cockroach <client cmd> --host=[::1]:37363 --insecure›
98 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +logs: ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/logs›
99 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +temp dir: ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/cockroach-temp3706854270›
100 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +external I/O path: ‹/var/tmp/omicron_tmp/.tmpuoq8Uu/data/extern›
101 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmpuoq8Uu/data›
102 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +storage engine: pebble
103 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +clusterID: ‹269d6f9d-8223-4f0e-bdd9-be856a51fc82›
104 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +status: restarted pre-existing node
105 I250401 18:06:00.742654 32 1@cli/start.go:1033 ⋮ [n1] 59 +nodeID: 1
106 I250401 18:06:00.758891 1002 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r205/1:‹/{Table/333-Max}›] 60 initiating a split of this range at key ‹/Table/334› [r206] (‹span config›)‹›
107 I250401 18:06:00.788990 959 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r206/1:‹/{Table/334-Max}›] 61 initiating a split of this range at key ‹/Table/335› [r207] (‹span config›)‹›
108 I250401 18:06:00.816719 1072 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r207/1:‹/{Table/335-Max}›] 62 initiating a split of this range at key ‹/Table/338› [r208] (‹span config›)‹›
109 I250401 18:06:00.850995 1093 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r208/1:‹/{Table/338-Max}›] 63 initiating a split of this range at key ‹/Table/340› [r209] (‹span config›)‹›
110 I250401 18:06:00.876008 1098 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r209/1:‹/{Table/340-Max}›] 64 initiating a split of this range at key ‹/Table/345› [r210] (‹span config›)‹›
111 I250401 18:06:00.914887 1104 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r210/1:‹/{Table/345-Max}›] 65 initiating a split of this range at key ‹/Table/346› [r211] (‹span config›)‹›
112 I250401 18:06:00.938761 1143 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r211/1:‹/{Table/346-Max}›] 66 initiating a split of this range at key ‹/Table/349› [r212] (‹span config›)‹›
113 I250401 18:06:00.963657 1186 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r212/1:‹/{Table/349-Max}›] 67 initiating a split of this range at key ‹/Table/352› [r213] (‹span config›)‹›
114 I250401 18:06:00.973036 987 server/diagnostics/update_checker.go:150 ⋮ [n1] 68 a new version is available: ‹25.2.0-alpha.2›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.2#v25-2-0-alpha-2›
115 I250401 18:06:00.991804 1164 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r213/1:‹/{Table/352-Max}›] 69 initiating a split of this range at key ‹/Table/353› [r214] (‹span config›)‹›
116 I250401 18:06:01.023509 1196 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r214/1:‹/{Table/353-Max}›] 70 initiating a split of this range at key ‹/Table/357› [r215] (‹span config›)‹›
117 I250401 18:06:01.050455 1182 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r215/1:‹/{Table/357-Max}›] 71 initiating a split of this range at key ‹/Table/358› [r216] (‹span config›)‹›
118 I250401 18:06:01.093316 1054 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r216/1:‹/{Table/358-Max}›] 72 initiating a split of this range at key ‹/Table/361› [r217] (‹span config›)‹›
119 I250401 18:06:01.132652 1282 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r217/1:‹/{Table/361-Max}›] 73 initiating a split of this range at key ‹/Table/366› [r218] (‹span config›)‹›
120 I250401 18:06:01.159354 1272 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r218/1:‹/{Table/366-Max}›] 74 initiating a split of this range at key ‹/Table/369› [r219] (‹span config›)‹›
121 I250401 18:06:01.184931 1316 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r219/1:‹/{Table/369-Max}›] 75 initiating a split of this range at key ‹/Table/370› [r220] (‹span config›)‹›
122 I250401 18:06:01.214071 1319 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r220/1:‹/{Table/370-Max}›] 76 initiating a split of this range at key ‹/Table/371› [r221] (‹span config›)‹›
123 I250401 18:06:01.246153 1324 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r221/1:‹/{Table/371-Max}›] 77 initiating a split of this range at key ‹/Table/374› [r222] (‹span config›)‹›
124 I250401 18:06:01.274920 1253 kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r222/1:‹/{Table/374-Max}›] 78 initiating a split of this range at key ‹/Table/377› [r223] (‹span config›)‹›
125 I250401 18:06:02.699403 124 1@gossip/gossip.go:1547 ⋮ [n1] 79 node has connected to cluster via gossip
126 I250401 18:06:02.705762 124 kv/kvserver/stores.go:269 ⋮ [n1] 80 wrote 0 node addresses to persistent storage
127 I250401 18:06:07.407360 1424 util/log/event_log.go:32 ⋮ [n1,client=[::1]:52536,user=root] 81 ={"Timestamp":1743530767374739486,"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›"}