1 | I240926 19:42:57.788990 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2024/09/26 19:42:57 | ||
2 | I240926 19:42:57.788998 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01J8QWT48330KGPGA5BJVQ5NQB› | ||
3 | I240926 19:42:57.789004 1 util/log/file_sync_buffer.go:238 ⋮ [config] binary: CockroachDB CCL v22.1.9 (x86_64-pc-linux-gnu, built 2022/10/17 18:24:57, go1.17.11) | ||
4 | I240926 19:42:57.789011 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpCYRwlf/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpCYRwlf/listen-url›] | ||
5 | I240926 19:42:57.789027 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 | ||
6 | I240926 19:42:57.789031 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 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! | ||
8 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 + | ||
9 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +This mode is intended for non-production testing only. | ||
10 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 + | ||
11 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +In this mode: | ||
12 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. | ||
13 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. | ||
14 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. | ||
15 | W240926 19:42:57.788904 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. | ||
16 | I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, | ||
17 | I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: | ||
18 | I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 + | ||
19 | I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› | ||
20 | I240926 19:42:57.789151 1 1@cli/start.go:1191 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html | ||
21 | I240926 19:42:57.789419 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
22 | W240926 19:42:57.789442 1 1@cli/start.go:1107 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› | ||
23 | W240926 19:42:57.789442 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› | ||
24 | W240926 19:42:57.789442 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).› | ||
25 | I240926 19:42:57.789604 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
26 | I240926 19:42:57.789614 1 1@cli/start.go:1220 ⋮ [n?] 6 ‹CockroachDB CCL v22.1.9 (x86_64-pc-linux-gnu, built 2022/10/17 18:24:57, go1.17.11)› | ||
27 | I240926 19:42:57.790898 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
28 | I240926 19:42:57.790916 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB | ||
29 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 server configuration: | ||
30 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› | ||
31 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› | ||
32 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 7.7 GiB› | ||
33 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› | ||
34 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› | ||
35 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› | ||
36 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› | ||
37 | I240926 19:42:57.790950 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› | ||
38 | I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 using local environment variables: | ||
39 | I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +GOTRACEBACK=crash | ||
40 | I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› | ||
41 | I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› | ||
42 | I240926 19:42:57.791057 1 1@cli/start.go:1085 ⋮ [n?] 10 +TZ=‹UTC› | ||
43 | I240926 19:42:57.791072 1 1@cli/start.go:1092 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› | ||
44 | W240926 19:42:57.791362 1 1@cli/start.go:1305 ⋮ [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 | I240926 19:42:57.791427 1 1@cli/start.go:576 ⋮ [n?] 13 starting cockroach node | ||
46 | I240926 19:42:58.006231 49 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized | ||
47 | I240926 19:42:58.006280 49 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB | ||
48 | I240926 19:42:58.006295 49 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 10000 | ||
49 | I240926 19:42:58.006301 49 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpCYRwlf/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} | ||
50 | I240926 19:42:58.007851 49 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/inflight_trace_dump› | ||
51 | I240926 19:42:58.074772 49 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled | ||
52 | I240926 19:42:58.090464 49 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1727379778090461422 to catches up to 1727379778574756969 to ensure monotonicity. Delta: 484.295547ms | ||
53 | I240926 19:42:58.090502 185 1@server/server.go:1307 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"ebd53b95-d4ae-4b6d-a89d-34c9d199bc92"› | ||
54 | I240926 19:42:58.574921 49 1@cli/start.go:516 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmpCYRwlf/listen-url› | ||
55 | W240926 19:42:58.585625 49 1@gossip/pkg/gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node | ||
56 | I240926 19:42:58.585690 49 gossip/pkg/gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:33723" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.9" started_at:1727379778585683448 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:33723" > http_address:<network_field:"tcp" address_field:"[::1]:44561" >› | ||
57 | I240926 19:42:58.611749 185 1@server/server.go:1310 ⋮ [n1] 25 node connected via gossip | ||
58 | I240926 19:42:58.611870 49 server/node.go:469 ⋮ [n1] 26 initialized store s1 | ||
59 | I240926 19:42:58.611959 49 kv/kvserver/pkg/kv/kvserver/stores.go:250 ⋮ [n1] 27 read 0 node addresses from persistent storage | ||
60 | I240926 19:42:59.049970 49 server/node.go:548 ⋮ [n1] 28 started with engine type ‹2› | ||
61 | I240926 19:42:59.050016 49 server/node.go:550 ⋮ [n1] 29 started with attributes [] | ||
62 | I240926 19:42:59.050074 49 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/goroutine_dump› | ||
63 | I240926 19:42:59.050104 49 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/heap_profiler› at least every 1h0m0s | ||
64 | I240926 19:42:59.050121 49 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 | I240926 19:42:59.050133 49 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/heap_profiler› at last every 1h0m0s | ||
66 | I240926 19:42:59.050311 49 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs/heap_profiler› | ||
67 | I240926 19:42:59.050378 49 1@server/server.go:1446 ⋮ [n1] 35 starting http server at ‹[::1]:44561› (use: ‹[::1]:44561›) | ||
68 | I240926 19:42:59.050403 49 1@server/server.go:1453 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:33723› | ||
69 | I240926 19:42:59.050423 49 1@server/server.go:1454 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:33723› | ||
70 | I240926 19:42:59.319319 387 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache | ||
71 | I240926 19:42:59.319900 307 kv/kvserver/pkg/kv/kvserver/replica_rangefeed.go:703 ⋮ [n1,rangefeed=‹table-stats-cache›,s1,r16] 39 RangeFeed closed timestamp is empty | ||
72 | I240926 19:42:59.366183 49 1@util/log/event_log.go:32 ⋮ [n1] 40 ={"Timestamp":1727379779366180177,"EventType":"node_restart","NodeID":1,"StartedAt":1727379778585683448,"LastUp":1727379561390489199} | ||
73 | I240926 19:42:59.366230 49 sql/sqlliveness/slinstance/slinstance.go:348 ⋮ [n1] 41 starting SQL liveness instance | ||
74 | I240926 19:42:59.373369 708 kv/kvserver/pkg/kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r175/1:‹/{Table/299-Max}›] 42 initiating a split of this range at key ‹/Table/300› [r185] (‹span config›)‹› | ||
75 | I240926 19:42:59.394107 776 sql/sqlstats/persistedsqlstats/pkg/sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 43 starting sql-stats-worker with initial delay: 10m3.985105385s | ||
76 | I240926 19:42:59.394196 774 sql/temporary_schema.go:514 ⋮ [n1] 44 running temporary object cleanup background job | ||
77 | I240926 19:42:59.394264 805 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 45 settings-watcher: established range feed cache | ||
78 | I240926 19:42:59.395325 774 sql/temporary_schema.go:559 ⋮ [n1] 46 found 0 temporary schemas | ||
79 | I240926 19:42:59.395344 774 sql/temporary_schema.go:562 ⋮ [n1] 47 early exiting temporary schema cleaner as no temporary schemas were found | ||
80 | I240926 19:42:59.395357 774 sql/temporary_schema.go:563 ⋮ [n1] 48 completed temporary object cleanup job | ||
81 | I240926 19:42:59.395371 774 sql/temporary_schema.go:646 ⋮ [n1] 49 temporary object cleaner next scheduled to run at 2024-09-26 20:12:59.394168481 +0000 UTC | ||
82 | I240926 19:42:59.397468 49 server/server_sql.go:1290 ⋮ [n1] 50 done ensuring all necessary startup migrations have run | ||
83 | I240926 19:42:59.397663 836 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 51 tenant-settings-watcher: established range feed cache | ||
84 | I240926 19:42:59.397911 830 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 52 system-config-cache: established range feed cache | ||
85 | I240926 19:42:59.398984 832 jobs/job_scheduler.go:433 ⋮ [n1] 53 waiting 3m0s before scheduled jobs daemon start | ||
86 | I240926 19:42:59.411747 835 server/auto_upgrade.go:59 ⋮ [n1] 54 no need to upgrade, cluster already at the newest version | ||
87 | I240926 19:42:59.411843 391 sql/sqlliveness/slstorage/slstorage.go:406 ⋮ [n1] 55 inserted sqlliveness session efcfd344489146c587ab80d440875a18 | ||
88 | I240926 19:42:59.411866 391 sql/sqlliveness/slinstance/slinstance.go:206 ⋮ [n1] 56 created new SQL liveness session efcfd344489146c587ab80d440875a18 | ||
89 | I240926 19:42:59.462463 969 kv/kvserver/pkg/kv/kvserver/replica_command.go:421 ⋮ [n1,split,s1,r185/1:‹/{Table/300-Max}›] 57 initiating a split of this range at key ‹/Table/301› [r186] (‹span config›)‹› | ||
90 | I240926 19:42:59.493026 49 1@server/server_sql.go:1360 ⋮ [n1] 58 serving sql connections | ||
91 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 node startup completed: | ||
92 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +CockroachDB node starting at 2024-09-26 19:42:59.493063302 +0000 UTC (took 1.7s) | ||
93 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +build: CCL v22.1.9 @ 2022/10/17 18:24:57 (go1.17.11) | ||
94 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +webui: ‹http://[::1]:44561› | ||
95 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +sql: ‹postgresql://root@[::1]:33723/defaultdb?sslmode=disable› | ||
96 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +sql (JDBC): ‹jdbc:postgresql://[::1]:33723/defaultdb?sslmode=disable&user=root› | ||
97 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +RPC client flags: ‹cockroach <client cmd> --host=[::1]:33723 --insecure› | ||
98 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +logs: ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/logs› | ||
99 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +temp dir: ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/cockroach-temp2275887970› | ||
100 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +external I/O path: ‹/var/tmp/omicron_tmp/.tmpCYRwlf/data/extern› | ||
101 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmpCYRwlf/data› | ||
102 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +storage engine: pebble | ||
103 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +clusterID: ‹ebd53b95-d4ae-4b6d-a89d-34c9d199bc92› | ||
104 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +status: restarted pre-existing node | ||
105 | I240926 19:42:59.493168 49 1@cli/start.go:1028 ⋮ [n1] 59 +nodeID: 1 |