| 1 | I250722 14:53:42.054059 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2025/07/22 14:53:42 | ||
| 2 | I250722 14:53:42.054068 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01K0S8P5ZC097S4HP7X8CB9J5J› | ||
| 3 | I250722 14:53:42.054076 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 | I250722 14:53:42.054083 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmppfHXhC/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmppfHXhC/listen-url›] | ||
| 5 | I250722 14:53:42.054099 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 | ||
| 6 | I250722 14:53:42.054103 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 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! | ||
| 8 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 + | ||
| 9 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only. | ||
| 10 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 + | ||
| 11 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode: | ||
| 12 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. | ||
| 13 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. | ||
| 14 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. | ||
| 15 | W250722 14:53:42.052343 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. | ||
| 16 | I250722 14:53:42.054230 1 1@cli/start.go:1196 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, | ||
| 17 | I250722 14:53:42.054230 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: | ||
| 18 | I250722 14:53:42.054230 1 1@cli/start.go:1196 ⋮ [n?] 2 + | ||
| 19 | I250722 14:53:42.054230 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› | ||
| 20 | I250722 14:53:42.054230 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html | ||
| 21 | I250722 14:53:42.054526 1 server/status/recorder.go:620 ⋮ [n?] 3 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 22 | W250722 14:53:42.054545 1 1@cli/start.go:1112 ⋮ [n?] 4 ‹Using the default setting for --cache (128 MiB).› | ||
| 23 | W250722 14:53:42.054545 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ A significantly larger value is usually needed for good performance.› | ||
| 24 | W250722 14:53:42.054545 1 1@cli/start.go:1112 ⋮ [n?] 4 +‹ If you have a dedicated server a reasonable setting is --cache=.25 (7.7 GiB).› | ||
| 25 | I250722 14:53:42.054695 1 server/status/recorder.go:620 ⋮ [n?] 5 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 26 | I250722 14:53:42.054710 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 | I250722 14:53:42.055296 1 server/status/recorder.go:620 ⋮ [n?] 7 ‹available memory from cgroups (8.0 EiB) is unsupported, using system memory 31 GiB instead:› | ||
| 28 | I250722 14:53:42.055313 1 server/config.go:487 ⋮ [n?] 8 system total memory: 31 GiB | ||
| 29 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 server configuration: | ||
| 30 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹max offset 500000000› | ||
| 31 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹cache size 128 MiB› | ||
| 32 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹SQL memory pool size 7.7 GiB› | ||
| 33 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹scan interval 10m0s› | ||
| 34 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹scan min idle time 10ms› | ||
| 35 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹scan max idle time 1s› | ||
| 36 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹event log enabled true› | ||
| 37 | I250722 14:53:42.055329 1 server/config.go:489 ⋮ [n?] 9 +‹span configs enabled true› | ||
| 38 | I250722 14:53:42.055414 1 1@cli/start.go:1090 ⋮ [n?] 10 using local environment variables: | ||
| 39 | I250722 14:53:42.055414 1 1@cli/start.go:1090 ⋮ [n?] 10 +GOTRACEBACK=crash | ||
| 40 | I250722 14:53:42.055414 1 1@cli/start.go:1090 ⋮ [n?] 10 +LANG=‹en_US.UTF-8› | ||
| 41 | I250722 14:53:42.055414 1 1@cli/start.go:1090 ⋮ [n?] 10 +LC_ALL=‹en_US.UTF-8› | ||
| 42 | I250722 14:53:42.055414 1 1@cli/start.go:1090 ⋮ [n?] 10 +TZ=‹UTC› | ||
| 43 | I250722 14:53:42.055437 1 1@cli/start.go:1097 ⋮ [n?] 11 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› | ||
| 44 | W250722 14:53:42.055650 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 | I250722 14:53:42.055705 1 1@cli/start.go:581 ⋮ [n?] 13 starting cockroach node | ||
| 46 | I250722 14:53:42.221680 65 server/config.go:665 ⋮ [n?] 14 1 storage engine‹› initialized | ||
| 47 | I250722 14:53:42.221716 65 server/config.go:668 ⋮ [n?] 15 Pebble cache size: 128 MiB | ||
| 48 | I250722 14:53:42.221844 65 server/config.go:668 ⋮ [n?] 16 store 0: max size 0 B, max open file limit 10000 | ||
| 49 | I250722 14:53:42.221854 65 server/config.go:668 ⋮ [n?] 17 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmppfHXhC/data›, fs=nsfs, blkdev=‹nsfs›, mnt=‹/run/snapd/ns/lxd.mnt› opts=‹rw›}} | ||
| 50 | I250722 14:53:42.223129 65 server/tracedumper/tracedumper.go:120 ⋮ [n?] 18 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/logs/inflight_trace_dump› | ||
| 51 | I250722 14:53:42.290374 65 1@server/clock_monotonicity.go:65 ⋮ [n?] 19 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled | ||
| 52 | I250722 14:53:42.296657 65 1@server/clock_monotonicity.go:140 ⋮ [n1] 20 Sleeping till wall time 1753196022296653456 to catches up to 1753196022790364419 to ensure monotonicity. Delta: 493.710963ms | ||
| 53 | I250722 14:53:42.296736 75 1@server/server.go:1319 ⋮ [n1] 21 connecting to gossip network to verify cluster ID ‹"a4debf25-6e10-4308-a2e5-28be8c3018a5"› | ||
| 54 | I250722 14:53:42.790728 65 1@cli/start.go:521 ⋮ [n1] 22 listening URL file: ‹/var/tmp/omicron_tmp/.tmppfHXhC/listen-url› | ||
| 55 | W250722 14:53:42.804579 65 1@gossip/gossip.go:1531 ⋮ [n1] 23 no addresses found; use --join to specify a connected node | ||
| 56 | I250722 14:53:42.804658 65 gossip/gossip.go:401 ⋮ [n1] 24 NodeDescriptor set to ‹node_id:1 address:<network_field:"tcp" address_field:"[::1]:40055" > attrs:<> locality:<> ServerVersion:<major_val:22 minor_val:1 patch:0 internal:0 > build_tag:"v22.1.22-29-g865aff1595" started_at:1753196022804650861 cluster_name:"" sql_address:<network_field:"tcp" address_field:"[::1]:40055" > http_address:<network_field:"tcp" address_field:"[::1]:36307" >› | ||
| 57 | I250722 14:53:42.815856 65 server/node.go:470 ⋮ [n1] 25 initialized store s1 | ||
| 58 | I250722 14:53:42.815921 65 kv/kvserver/stores.go:250 ⋮ [n1] 26 read 0 node addresses from persistent storage | ||
| 59 | I250722 14:53:42.816542 75 1@server/server.go:1322 ⋮ [n1] 27 node connected via gossip | ||
| 60 | I250722 14:53:42.820487 65 server/node.go:549 ⋮ [n1] 28 started with engine type ‹2› | ||
| 61 | I250722 14:53:42.820579 65 server/node.go:551 ⋮ [n1] 29 started with attributes [] | ||
| 62 | I250722 14:53:42.820650 65 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 30 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/logs/goroutine_dump› | ||
| 63 | I250722 14:53:42.820686 65 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 31 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/logs/heap_profiler› at least every 1h0m0s | ||
| 64 | I250722 14:53:42.820707 65 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 | I250722 14:53:42.820721 65 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 33 writing memory stats to ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/logs/heap_profiler› at last every 1h0m0s | ||
| 66 | I250722 14:53:42.820909 65 server/heapprofiler/activequeryprofiler.go:85 ⋮ [n1] 34 writing go query profiles to ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/logs/heap_profiler› | ||
| 67 | I250722 14:53:42.820975 65 1@server/server.go:1458 ⋮ [n1] 35 starting http server at ‹[::1]:36307› (use: ‹[::1]:36307›) | ||
| 68 | I250722 14:53:42.820998 65 1@server/server.go:1465 ⋮ [n1] 36 starting grpc/postgres server at ‹[::1]:40055› | ||
| 69 | I250722 14:53:42.821016 65 1@server/server.go:1466 ⋮ [n1] 37 advertising CockroachDB node at ‹[::1]:40055› | ||
| 70 | I250722 14:53:42.846977 193 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache | ||
| 71 | I250722 14:53:42.872108 65 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1753196022872105859,"EventType":"node_restart","NodeID":1,"StartedAt":1753196022804650861,"LastUp":1753195609731990614} | ||
| 72 | I250722 14:53:42.872168 65 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance | ||
| 73 | I250722 14:53:42.889686 325 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 41 inserted sqlliveness session 3d1a50cdf6d149449493c5a69fc77524 | ||
| 74 | I250722 14:53:42.889726 325 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 42 created new SQL liveness session 3d1a50cdf6d149449493c5a69fc77524 | ||
| 75 | I250722 14:53:42.894820 528 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 43 settings-watcher: established range feed cache | ||
| 76 | I250722 14:53:42.895069 353 sql/temporary_schema.go:514 ⋮ [n1] 44 running temporary object cleanup background job | ||
| 77 | I250722 14:53:42.895904 353 sql/temporary_schema.go:559 ⋮ [n1] 45 found 0 temporary schemas | ||
| 78 | I250722 14:53:42.895920 353 sql/temporary_schema.go:562 ⋮ [n1] 46 early exiting temporary schema cleaner as no temporary schemas were found | ||
| 79 | I250722 14:53:42.895928 353 sql/temporary_schema.go:563 ⋮ [n1] 47 completed temporary object cleanup job | ||
| 80 | I250722 14:53:42.895936 353 sql/temporary_schema.go:646 ⋮ [n1] 48 temporary object cleaner next scheduled to run at 2025-07-22 15:23:42.895043229 +0000 UTC | ||
| 81 | I250722 14:53:42.895966 515 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 49 starting sql-stats-worker with initial delay: 10m51.586792394s | ||
| 82 | I250722 14:53:42.896535 65 server/server_sql.go:1295 ⋮ [n1] 50 done ensuring all necessary startup migrations have run | ||
| 83 | I250722 14:53:42.896704 334 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 51 system-config-cache: established range feed cache | ||
| 84 | I250722 14:53:42.896634 565 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 52 RangeFeed closed timestamp 1753195605.730485419,0 is behind by 6m57.166146352s | ||
| 85 | I250722 14:53:42.896730 596 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 53 tenant-settings-watcher: established range feed cache | ||
| 86 | I250722 14:53:42.896655 336 jobs/job_scheduler.go:433 ⋮ [n1] 54 waiting 3m0s before scheduled jobs daemon start | ||
| 87 | I250722 14:53:42.902652 595 server/auto_upgrade.go:79 ⋮ [n1] 55 no need to upgrade, cluster already at the newest version | ||
| 88 | I250722 14:53:42.935601 582 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56 deleted session 6a124c22908e4bd19bcbf7ce2b6a8d5c which expired at 1753195646.087289025,0 | ||
| 89 | I250722 14:53:42.952134 65 1@server/server_sql.go:1365 ⋮ [n1] 57 serving sql connections | ||
| 90 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 node startup completed: | ||
| 91 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +CockroachDB node starting at 2025-07-22 14:53:42.952176565 +0000 UTC (took 0.9s) | ||
| 92 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +build: OSS v22.1.22-29-g865aff1595 @ 2024/11/04 18:35:23 (go1.17.13) | ||
| 93 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +webui: ‹http://[::1]:36307› | ||
| 94 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +sql: ‹postgresql://root@[::1]:40055/defaultdb?sslmode=disable› | ||
| 95 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +sql (JDBC): ‹jdbc:postgresql://[::1]:40055/defaultdb?sslmode=disable&user=root› | ||
| 96 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +RPC client flags: ‹cockroach <client cmd> --host=[::1]:40055 --insecure› | ||
| 97 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +logs: ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/logs› | ||
| 98 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +temp dir: ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/cockroach-temp2644566226› | ||
| 99 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +external I/O path: ‹/var/tmp/omicron_tmp/.tmppfHXhC/data/extern› | ||
| 100 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmppfHXhC/data› | ||
| 101 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +storage engine: pebble | ||
| 102 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +clusterID: ‹a4debf25-6e10-4308-a2e5-28be8c3018a5› | ||
| 103 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +status: restarted pre-existing node | ||
| 104 | I250722 14:53:42.952299 65 1@cli/start.go:1033 ⋮ [n1] 58 +nodeID: 1 | ||
| 105 | I250722 14:53:42.968191 665 util/log/event_log.go:32 ⋮ [n1,client=[::1]:54128,user=root] 59 ={"Timestamp":1753196022964769411,"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 | I250722 14:53:43.163377 684 server/diagnostics/update_checker.go:150 ⋮ [n1] 60 a new version is available: ‹25.3.0-beta.3›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.3#v25-3-0-beta-3› | ||
| 107 | I250722 14:53:44.926465 154 1@gossip/gossip.go:1547 ⋮ [n1] 61 node has connected to cluster via gossip | ||
| 108 | I250722 14:53:44.932232 154 kv/kvserver/stores.go:269 ⋮ [n1] 62 wrote 0 node addresses to persistent storage | ||