| 1 | I240812 20:52:10.660751 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2024/08/12 20:52:10 | ||
| 2 | I240812 20:52:10.660758 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01J544P9SGK5S0VTVDN4Y2W3F8› | ||
| 3 | I240812 20:52:10.660766 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 | I240812 20:52:10.660772 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmp2bzsJ0/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/listen-url›] | ||
| 5 | I240812 20:52:10.660787 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 | ||
| 6 | I240812 20:52:10.660791 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 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! | ||
| 8 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 + | ||
| 9 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +This mode is intended for non-production testing only. | ||
| 10 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 + | ||
| 11 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +In this mode: | ||
| 12 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. | ||
| 13 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. | ||
| 14 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. | ||
| 15 | W240812 20:52:10.660671 1 1@cli/start.go:1181 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. | ||
| 16 | I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, | ||
| 17 | I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: | ||
| 18 | I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 + | ||
| 19 | I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› | ||
| 20 | I240812 20:52:10.660907 1 1@cli/start.go:1191 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html | ||
| 21 | I240812 20:52:10.661149 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 22 | W240812 20:52:10.661171 1 1@cli/start.go:1107 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› | ||
| 23 | W240812 20:52:10.661171 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› | ||
| 24 | W240812 20:52:10.661171 1 1@cli/start.go:1107 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).› | ||
| 25 | I240812 20:52:10.661363 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 26 | I240812 20:52:10.661379 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 | I240812 20:52:10.662987 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 28 | I240812 20:52:10.663007 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB | ||
| 29 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 server configuration: | ||
| 30 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› | ||
| 31 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› | ||
| 32 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 7.7 GiB› | ||
| 33 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› | ||
| 34 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› | ||
| 35 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› | ||
| 36 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› | ||
| 37 | I240812 20:52:10.663029 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› | ||
| 38 | I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 using local environment variables: | ||
| 39 | I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +GOTRACEBACK=crash | ||
| 40 | I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› | ||
| 41 | I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› | ||
| 42 | I240812 20:52:10.663112 1 1@cli/start.go:1085 ⋮ [n?] 10 +TZ=‹UTC› | ||
| 43 | I240812 20:52:10.663126 1 1@cli/start.go:1092 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› | ||
| 44 | W240812 20:52:10.663334 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 | I240812 20:52:10.663383 1 1@cli/start.go:576 ⋮ [n?] 13 starting cockroach node | ||
| 46 | I240812 20:52:10.846730 102 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized | ||
| 47 | I240812 20:52:10.846767 102 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB | ||
| 48 | I240812 20:52:10.846789 102 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 10000 | ||
| 49 | I240812 20:52:10.846797 102 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} | ||
| 50 | I240812 20:52:10.850842 102 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/inflight_trace_dump› | ||
| 51 | I240812 20:52:10.932527 102 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled | ||
| 52 | I240812 20:52:10.941195 102 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1723495930941193474 to catches up to 1723495931432515928 to ensure monotonicity. Delta: 491.322454ms | ||
| 53 | I240812 20:52:10.941249 125 1@server/server.go:1307 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"8e97d791-83b9-4f5d-ae7b-0efa9e4f2f98"› | ||
| 54 | I240812 20:52:11.432744 102 1@cli/start.go:516 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/listen-url› | ||
| 55 | W240812 20:52:11.444982 102 1@gossip/pkg/gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node | ||
| 56 | I240812 20:52:11.445035 102 gossip/pkg/gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:45747" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.9" started_at:1723495931445028033 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:45747" > http_address:<network_field:"tcp" address_field:"[::1]:42265" >› | ||
| 57 | I240812 20:52:11.462479 102 server/node.go:469 ⋮ [n1] 25 initialized store s1 | ||
| 58 | I240812 20:52:11.462536 102 kv/kvserver/pkg/kv/kvserver/stores.go:250 ⋮ [n1] 26 read 0 node addresses from persistent storage | ||
| 59 | I240812 20:52:11.462795 125 1@server/server.go:1310 ⋮ [n1] 27 node connected via gossip | ||
| 60 | I240812 20:52:11.464536 102 server/node.go:548 ⋮ [n1] 28 started with engine type ‹2› | ||
| 61 | I240812 20:52:11.464563 102 server/node.go:550 ⋮ [n1] 29 started with attributes [] | ||
| 62 | I240812 20:52:11.464616 102 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/goroutine_dump› | ||
| 63 | I240812 20:52:11.464643 102 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/heap_profiler› at least every 1h0m0s | ||
| 64 | I240812 20:52:11.464661 102 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 | I240812 20:52:11.464674 102 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/heap_profiler› at last every 1h0m0s | ||
| 66 | I240812 20:52:11.464847 102 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs/heap_profiler› | ||
| 67 | I240812 20:52:11.464903 102 1@server/server.go:1446 ⋮ [n1] 35 starting http server at ‹[::1]:42265› (use: ‹[::1]:42265›) | ||
| 68 | I240812 20:52:11.464946 102 1@server/server.go:1453 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:45747› | ||
| 69 | I240812 20:52:11.464965 102 1@server/server.go:1454 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:45747› | ||
| 70 | E240812 20:52:11.531098 325 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r26/1:‹/NamespaceTable/{30-Max}›] 38 1 matching stores are currently throttled: [‹s1: draining›] | ||
| 71 | E240812 20:52:11.542775 360 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r3/1:‹/System/{NodeLive…-tsd}›] 39 1 matching stores are currently throttled: [‹s1: draining›] | ||
| 72 | E240812 20:52:11.542924 110 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r2/1:‹/System/NodeLiveness{-Max}›] 40 1 matching stores are currently throttled: [‹s1: draining›] | ||
| 73 | E240812 20:52:11.543001 110 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r1/1:‹/{Min-System/NodeL…}›] 41 1 matching stores are currently throttled: [‹s1: draining›] | ||
| 74 | I240812 20:52:11.543019 110 kv/kvserver/pkg/kv/kvserver/queue.go:1205 ⋮ [n1,replicate] 42 purgatory is now empty | ||
| 75 | E240812 20:52:11.546209 175 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r6/1:‹/Table/{SystemCon…-11}›] 43 1 matching stores are currently throttled: [‹s1: draining›] | ||
| 76 | I240812 20:52:11.554110 331 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 44 spanconfig-subscriber: established range feed cache | ||
| 77 | E240812 20:52:11.559336 75 kv/kvserver/pkg/kv/kvserver/queue.go:1106 ⋮ [n1,replicate,s1,r7/1:‹/Table/1{1-2}›] 45 1 matching stores are currently throttled: [‹s1: draining›] | ||
| 78 | I240812 20:52:11.590619 102 1@util/log/event_log.go:32 ⋮ [n1] 46 ={"Timestamp":1723495931590615755,"EventType":"node_restart","NodeID":1,"StartedAt":1723495931445028033,"LastUp":1723495408945552352} | ||
| 79 | I240812 20:52:11.590688 102 sql/sqlliveness/slinstance/slinstance.go:348 ⋮ [n1] 47 starting SQL liveness instance | ||
| 80 | I240812 20:52:11.626009 335 sql/sqlliveness/slstorage/slstorage.go:406 ⋮ [n1] 48 inserted sqlliveness session 4449bbc348f84f56b7efcd340669f11a | ||
| 81 | I240812 20:52:11.626071 335 sql/sqlliveness/slinstance/slinstance.go:206 ⋮ [n1] 49 created new SQL liveness session 4449bbc348f84f56b7efcd340669f11a | ||
| 82 | I240812 20:52:11.627992 398 sql/temporary_schema.go:514 ⋮ [n1] 50 running temporary object cleanup background job | ||
| 83 | I240812 20:52:11.627999 790 sql/sqlstats/persistedsqlstats/pkg/sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 51 starting sql-stats-worker with initial delay: 9m47.75495601s | ||
| 84 | I240812 20:52:11.645221 827 kv/kvserver/pkg/kv/kvserver/replica_rangefeed.go:705 ⋮ [n1,rangefeed=‹spanconfig-subscriber›,s1,r43] 52 RangeFeed closed timestamp 1723495400.575730577,0 is behind by 8m51.069486762s | ||
| 85 | I240812 20:52:11.648143 398 sql/temporary_schema.go:559 ⋮ [n1] 53 found 0 temporary schemas | ||
| 86 | I240812 20:52:11.648167 398 sql/temporary_schema.go:562 ⋮ [n1] 54 early exiting temporary schema cleaner as no temporary schemas were found | ||
| 87 | I240812 20:52:11.648183 398 sql/temporary_schema.go:563 ⋮ [n1] 55 completed temporary object cleanup job | ||
| 88 | I240812 20:52:11.648198 398 sql/temporary_schema.go:646 ⋮ [n1] 56 temporary object cleaner next scheduled to run at 2024-08-12 21:22:11.627958499 +0000 UTC | ||
| 89 | I240812 20:52:11.661673 858 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 57 settings-watcher: established range feed cache | ||
| 90 | I240812 20:52:11.662299 102 server/server_sql.go:1290 ⋮ [n1] 58 done ensuring all necessary startup migrations have run | ||
| 91 | I240812 20:52:11.662452 863 jobs/job_scheduler.go:433 ⋮ [n1] 59 waiting 3m0s before scheduled jobs daemon start | ||
| 92 | I240812 20:52:11.662536 883 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 60 tenant-settings-watcher: established range feed cache | ||
| 93 | I240812 20:52:11.662553 861 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 61 system-config-cache: established range feed cache | ||
| 94 | I240812 20:52:11.681036 882 server/auto_upgrade.go:59 ⋮ [n1] 62 no need to upgrade, cluster already at the newest version | ||
| 95 | I240812 20:52:11.758842 102 1@server/server_sql.go:1360 ⋮ [n1] 63 serving sql connections | ||
| 96 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 node startup completed: | ||
| 97 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +CockroachDB node starting at 2024-08-12 20:52:11.758885258 +0000 UTC (took 1.1s) | ||
| 98 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +build: CCL v22.1.9 @ 2022/10/17 18:24:57 (go1.17.11) | ||
| 99 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +webui: ‹http://[::1]:42265› | ||
| 100 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +sql: ‹postgresql://root@[::1]:45747/defaultdb?sslmode=disable› | ||
| 101 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +sql (JDBC): ‹jdbc:postgresql://[::1]:45747/defaultdb?sslmode=disable&user=root› | ||
| 102 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +RPC client flags: ‹cockroach <client cmd> --host=[::1]:45747 --insecure› | ||
| 103 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +logs: ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/logs› | ||
| 104 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +temp dir: ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/cockroach-temp2378304453› | ||
| 105 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +external I/O path: ‹/var/tmp/omicron_tmp/.tmp2bzsJ0/data/extern› | ||
| 106 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmp2bzsJ0/data› | ||
| 107 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +storage engine: pebble | ||
| 108 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +clusterID: ‹8e97d791-83b9-4f5d-ae7b-0efa9e4f2f98› | ||
| 109 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +status: restarted pre-existing node | ||
| 110 | I240812 20:52:11.758996 102 1@cli/start.go:1028 ⋮ [n1] 64 +nodeID: 1 | ||
| 111 | I240812 20:52:12.281560 970 server/diagnostics/update_checker.go:150 ⋮ [n1] 65 a new version is available: ‹24.1.3›, details: ‹https://www.cockroachlabs.com/docs/releases/v24.1#v24-1-3› | ||
| 112 | I240812 20:52:12.992469 226 1@gossip/pkg/gossip/gossip.go:1547 ⋮ [n1] 66 node has connected to cluster via gossip | ||
| 113 | I240812 20:52:12.995959 226 kv/kvserver/pkg/kv/kvserver/stores.go:269 ⋮ [n1] 67 wrote 0 node addresses to persistent storage | ||
| 114 | I240812 20:52:16.637141 1694 util/log/event_log.go:32 ⋮ [n1,client=[::1]:41866,user=root] 68 ={"Timestamp":1723495936600582081,"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›"} | ||