I250125 04:43:19.928236 1 util/log/file_sync_buffer.go:238 ⋮ [config] file created at: 2025/01/25 04:43:19 I250125 04:43:19.928243 1 util/log/file_sync_buffer.go:238 ⋮ [config] running on machine: ‹w-01JJDNXFCB07W5VRVGEPN9EQVE› I250125 04:43:19.928250 1 util/log/file_sync_buffer.go:238 ⋮ [config] binary: CockroachDB OSS v22.1.22-27-g76e176e260 (x86_64-pc-solaris2.11, built 2024/10/23 21:38:21, go1.17.13) I250125 04:43:19.928256 1 util/log/file_sync_buffer.go:238 ⋮ [config] arguments: [‹cockroach› ‹start-single-node› ‹--insecure› ‹--http-addr=:0› ‹--store=path=/var/tmp/omicron_tmp/.tmpqa9IPZ/data,ballast-size=0› ‹--listen-addr› ‹[::1]:0› ‹--listening-url-file› ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/listen-url›] I250125 04:43:19.928282 1 util/log/file_sync_buffer.go:238 ⋮ [config] log format (utf8=✓): crdb-v2 I250125 04:43:19.928288 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 W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 ALL SECURITY CONTROLS HAVE BEEN DISABLED! W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 + W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 +This mode is intended for non-production testing only. W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 + W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 +In this mode: W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Your cluster is open to any client that can access ‹::1›. W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders with access to your machine or network can observe client-server traffic. W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can log in without password and read or write any data in the cluster. W250125 04:43:19.928088 1 1@cli/start.go:1186 ⋮ [n?] 1 +- Intruders can consume all your server's resources and cause unavailability. I250125 04:43:19.928577 1 1@cli/start.go:1196 ⋮ [n?] 2 To start a secure server without mandating TLS for clients, I250125 04:43:19.928577 1 1@cli/start.go:1196 ⋮ [n?] 2 +consider --accept-sql-without-tls instead. For other options, see: I250125 04:43:19.928577 1 1@cli/start.go:1196 ⋮ [n?] 2 + I250125 04:43:19.928577 1 1@cli/start.go:1196 ⋮ [n?] 2 +- ‹https://go.crdb.dev/issue-v/53404/v22.1› I250125 04:43:19.928577 1 1@cli/start.go:1196 ⋮ [n?] 2 +- https://www.cockroachlabs.com/docs/v22.1/secure-a-cluster.html W250125 04:43:19.928664 1 1@cli/start.go:1112 ⋮ [n?] 3 ‹Using the default setting for --cache (128 MiB).› W250125 04:43:19.928664 1 1@cli/start.go:1112 ⋮ [n?] 3 +‹ A significantly larger value is usually needed for good performance.› W250125 04:43:19.928664 1 1@cli/start.go:1112 ⋮ [n?] 3 +‹ If you have a dedicated server a reasonable setting is 25% of physical memory.› I250125 04:43:19.928710 1 1@cli/start.go:1225 ⋮ [n?] 4 ‹CockroachDB OSS v22.1.22-27-g76e176e260 (x86_64-pc-solaris2.11, built 2024/10/23 21:38:21, go1.17.13)› I250125 04:43:19.933276 1 server/config.go:485 ⋮ [n?] 5 unable to retrieve system total memory: ‹not implemented on illumos› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 server configuration: I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹max offset 500000000› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹cache size 128 MiB› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹SQL memory pool size 128 MiB› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹scan interval 10m0s› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹scan min idle time 10ms› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹scan max idle time 1s› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹event log enabled true› I250125 04:43:19.933394 1 server/config.go:489 ⋮ [n?] 6 +‹span configs enabled true› I250125 04:43:19.933542 1 1@cli/start.go:1090 ⋮ [n?] 7 using local environment variables: I250125 04:43:19.933542 1 1@cli/start.go:1090 ⋮ [n?] 7 +GOTRACEBACK=crash I250125 04:43:19.933542 1 1@cli/start.go:1090 ⋮ [n?] 7 +LANG=‹en_US.UTF-8› I250125 04:43:19.933542 1 1@cli/start.go:1090 ⋮ [n?] 7 +LC_ALL=‹en_US.UTF-8› I250125 04:43:19.933542 1 1@cli/start.go:1090 ⋮ [n?] 7 +TZ=‹UTC› I250125 04:43:19.933609 1 1@cli/start.go:1097 ⋮ [n?] 8 process identity: ‹uid 12345 euid 12345 gid 12345 egid 12345› W250125 04:43:19.934218 1 1@cli/start.go:1310 ⋮ [n?] 9 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: ld.so.1: cockroach: fatal: /usr/local/lib/cockroach/libgeos.so: open failed: No such file or directory› I250125 04:43:19.934301 1 1@cli/start.go:581 ⋮ [n?] 10 starting cockroach node I250125 04:43:20.132682 32 server/config.go:665 ⋮ [n?] 11 1 storage engine‹› initialized I250125 04:43:20.132784 32 server/config.go:668 ⋮ [n?] 12 Pebble cache size: 128 MiB I250125 04:43:20.132814 32 server/config.go:668 ⋮ [n?] 13 store 0: max size 0 B, max open file limit 60536 I250125 04:43:20.132822 32 server/config.go:668 ⋮ [n?] 14 store 0: {Encrypted:false ReadOnly:false FileStoreProperties:{path=‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data›, fs=zfs, blkdev=‹rpool/work›, mnt=‹/work› opts=‹rw,devices,setuid,nonbmand,exec,xattr,atime,dev=4350006›}} E250125 04:43:20.133397 32 1@server/status/runtime.go:343 ⋮ [n?] 15 could not get initial disk IO counters: ‹not implemented yet› E250125 04:43:20.133501 32 1@server/status/runtime.go:347 ⋮ [n?] 16 could not get initial disk IO counters: ‹not implemented yet› I250125 04:43:20.136561 32 server/tracedumper/tracedumper.go:120 ⋮ [n?] 17 writing job trace dumps to ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data/logs/inflight_trace_dump› I250125 04:43:20.196061 32 1@server/clock_monotonicity.go:65 ⋮ [n?] 18 monitoring forward clock jumps based on server.clock.forward_jump_check_enabled I250125 04:43:20.198211 32 1@server/clock_monotonicity.go:140 ⋮ [n1] 19 Sleeping till wall time 1737780200198208107 to catches up to 1737780200696028486 to ensure monotonicity. Delta: 497.820379ms I250125 04:43:20.198338 197 1@server/server.go:1319 ⋮ [n1] 20 connecting to gossip network to verify cluster ID ‹"89eb322c-cfa7-4e65-81cf-c79a6fae3c8b"› I250125 04:43:20.696075 32 1@cli/start.go:521 ⋮ [n1] 21 listening URL file: ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/listen-url› W250125 04:43:20.696564 32 1@gossip/gossip.go:1531 ⋮ [n1] 22 no addresses found; use --join to specify a connected node I250125 04:43:20.696702 32 gossip/gossip.go:401 ⋮ [n1] 23 NodeDescriptor set to ‹node_id:1 address: attrs:<> locality:<> ServerVersion: build_tag:"v22.1.22-27-g76e176e260" started_at:1737780200696689678 cluster_name:"" sql_address: http_address:› I250125 04:43:20.706584 32 server/node.go:470 ⋮ [n1] 24 initialized store s1 I250125 04:43:20.706655 32 kv/kvserver/stores.go:250 ⋮ [n1] 25 read 0 node addresses from persistent storage I250125 04:43:20.706842 32 server/node.go:549 ⋮ [n1] 26 started with engine type ‹2› I250125 04:43:20.706893 32 server/node.go:551 ⋮ [n1] 27 started with attributes [] I250125 04:43:20.707012 32 server/goroutinedumper/goroutinedumper.go:122 ⋮ [n1] 28 writing goroutine dumps to ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data/logs/goroutine_dump› I250125 04:43:20.707145 32 server/heapprofiler/heapprofiler.go:49 ⋮ [n1] 29 writing go heap profiles to ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data/logs/heap_profiler› at least every 1h0m0s I250125 04:43:20.707185 32 server/heapprofiler/cgoprofiler.go:53 ⋮ [n1] 30 to enable jmalloc profiling: "export MALLOC_CONF=prof:true" or "ln -s prof:true /etc/malloc.conf" I250125 04:43:20.707221 32 server/heapprofiler/statsprofiler.go:54 ⋮ [n1] 31 writing memory stats to ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data/logs/heap_profiler› at last every 1h0m0s W250125 04:43:20.707272 32 server/env_sampler.go:121 ⋮ [n1] 32 failed to start query profiler worker: failed to read ‹memory› cgroup from cgroups file: ‹/proc/self/cgroup›: open ‹/proc/self/cgroup›: no such file or directory I250125 04:43:20.707434 32 1@server/server.go:1458 ⋮ [n1] 33 starting http server at ‹[::1]:42522› (use: ‹[::1]:42522›) I250125 04:43:20.707473 32 1@server/server.go:1465 ⋮ [n1] 34 starting grpc/postgres server at ‹[::1]:34055› I250125 04:43:20.707492 32 1@server/server.go:1466 ⋮ [n1] 35 advertising CockroachDB node at ‹[::1]:34055› I250125 04:43:20.707561 197 1@server/server.go:1322 ⋮ [n1] 36 node connected via gossip E250125 04:43:20.707537 32 server/status/recorder.go:420 ⋮ [n1,summaries] 37 could not get total system memory: ‹not implemented on illumos› I250125 04:43:20.721426 297 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 38 spanconfig-subscriber: established range feed cache I250125 04:43:20.761388 32 1@util/log/event_log.go:32 ⋮ [n1] 39 ={"Timestamp":1737780200761379421,"EventType":"node_restart","NodeID":1,"StartedAt":1737780200696689678,"LastUp":1737778117339831579} I250125 04:43:20.761468 32 sql/sqlliveness/slinstance/slinstance.go:313 ⋮ [n1] 40 starting SQL liveness instance I250125 04:43:20.764068 506 sql/sqlstats/persistedsqlstats/provider.go:132 ⋮ [n1] 41 starting sql-stats-worker with initial delay: 10m57.120318201s I250125 04:43:20.764239 551 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 42 settings-watcher: established range feed cache I250125 04:43:20.764675 318 kv/kvserver/replica_rangefeed.go:700 ⋮ [n1,rangefeed=‹lease›,s1,r6] 43 RangeFeed closed timestamp 1737778114.151167307,0 is behind by 34m46.61350528s I250125 04:43:20.765159 529 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 44 system-config-cache: established range feed cache I250125 04:43:20.765442 32 server/server_sql.go:1295 ⋮ [n1] 45 done ensuring all necessary startup migrations have run I250125 04:43:20.765771 579 kv/kvclient/rangefeed/rangefeedcache/watcher.go:316 ⋮ [n1] 46 tenant-settings-watcher: established range feed cache I250125 04:43:20.766077 567 jobs/job_scheduler.go:433 ⋮ [n1] 47 waiting 3m0s before scheduled jobs daemon start I250125 04:43:20.767863 301 sql/sqlliveness/slstorage/slstorage.go:460 ⋮ [n1] 48 inserted sqlliveness session 4ad1260909124c2abffd5cb69fbeb6fd I250125 04:43:20.767908 301 sql/sqlliveness/slinstance/slinstance.go:198 ⋮ [n1] 49 created new SQL liveness session 4ad1260909124c2abffd5cb69fbeb6fd I250125 04:43:20.770061 504 sql/temporary_schema.go:514 ⋮ [n1] 50 running temporary object cleanup background job I250125 04:43:20.771096 504 sql/temporary_schema.go:559 ⋮ [n1] 51 found 0 temporary schemas I250125 04:43:20.771118 504 sql/temporary_schema.go:562 ⋮ [n1] 52 early exiting temporary schema cleaner as no temporary schemas were found I250125 04:43:20.771131 504 sql/temporary_schema.go:563 ⋮ [n1] 53 completed temporary object cleanup job I250125 04:43:20.771144 504 sql/temporary_schema.go:646 ⋮ [n1] 54 temporary object cleaner next scheduled to run at 2025-01-25 05:13:20.763978221 +0000 UTC I250125 04:43:20.774478 570 server/auto_upgrade.go:79 ⋮ [n1] 55 no need to upgrade, cluster already at the newest version I250125 04:43:20.775410 603 sql/sqlliveness/slstorage/slstorage.go:342 ⋮ [n1,intExec=‹expire-sessions›] 56 deleted session 4b71d8d509884f84b59213d0d87a72e1 which expired at 1737778154.706862593,0 I250125 04:43:20.890750 32 1@server/server_sql.go:1365 ⋮ [n1] 57 serving sql connections I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 node startup completed: I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +CockroachDB node starting at 2025-01-25 04:43:20.890801763 +0000 UTC (took 1.0s) I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +build: OSS v22.1.22-27-g76e176e260 @ 2024/10/23 21:38:21 (go1.17.13) I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +webui: ‹http://[::1]:42522› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +sql: ‹postgresql://root@[::1]:34055/defaultdb?sslmode=disable› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +sql (JDBC): ‹jdbc:postgresql://[::1]:34055/defaultdb?sslmode=disable&user=root› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +RPC client flags: ‹cockroach --host=[::1]:34055 --insecure› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +logs: ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data/logs› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +temp dir: ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data/cockroach-temp3049433566› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +external I/O path: ‹/var/tmp/omicron_tmp/.tmpqa9IPZ/data/extern› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +store[0]: ‹path=/var/tmp/omicron_tmp/.tmpqa9IPZ/data› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +storage engine: pebble I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +clusterID: ‹89eb322c-cfa7-4e65-81cf-c79a6fae3c8b› I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +status: restarted pre-existing node I250125 04:43:20.890993 32 1@cli/start.go:1033 ⋮ [n1] 58 +nodeID: 1 E250125 04:43:21.351913 336 server/status/recorder.go:420 ⋮ [n1] 59 could not get total system memory: ‹not implemented on illumos› I250125 04:43:21.815669 335 server/diagnostics/update_checker.go:150 ⋮ [n1] 60 a new version is available: ‹25.1.0-beta.1›, details: ‹https://www.cockroachlabs.com/docs/releases/v25.1#v25-1-0-beta-1› I250125 04:43:22.695830 104 1@gossip/gossip.go:1547 ⋮ [n1] 61 node has connected to cluster via gossip I250125 04:43:22.696045 104 kv/kvserver/stores.go:269 ⋮ [n1] 62 wrote 0 node addresses to persistent storage I250125 04:43:29.080615 876 util/log/event_log.go:32 ⋮ [n1,client=[::1]:34175,user=root] 63 ={"Timestamp":1737780209076313885,"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›"} E250125 04:43:30.710728 198 1@server/status/runtime.go:454 ⋮ [n1] 64 unable to get mem usage: ‹not implemented on illumos› E250125 04:43:30.710866 198 1@server/status/runtime.go:458 ⋮ [n1] 65 unable to get cpu usage: ‹not implemented on illumos› W250125 04:43:30.710929 198 1@server/status/runtime.go:468 ⋮ [n1] 66 unable to get file descriptor usage (will not try again): ‹not implemented on illumos› W250125 04:43:30.710967 198 1@server/status/runtime.go:478 ⋮ [n1] 67 problem fetching disk stats: ‹not implemented yet›; disk stats will be empty. W250125 04:43:30.710987 198 1@server/status/runtime.go:499 ⋮ [n1] 68 problem fetching net stats: ‹not implemented yet›; net stats will be empty. E250125 04:43:30.721390 295 server/status/recorder.go:420 ⋮ [n1,summaries] 69 could not get total system memory: ‹not implemented on illumos› I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 +__level_____count____size___score______in__ingest(sz_cnt)____move(sz_cnt)___write(sz_cnt)____read___r-amp___w-amp I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + WAL 2 2.0 M - 1.9 M - - - - 2.0 M - - - 1.0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + 0 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + 1 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + 2 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + 3 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + 4 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + 5 0 0 B 0.00 0 B 0 B 0 0 B 0 0 B 0 0 B 0 0.0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + 6 1 523 K - 956 K 0 B 0 0 B 0 523 K 1 956 K 1 0.5 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + total 1 523 K - 2.0 M 0 B 0 0 B 0 2.5 M 1 956 K 1 1.3 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + flush 0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 +compact 1 0 B 956 K 0 (size == estimated-debt, score = in-progress-bytes, in = num-in-progress) I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + ctype 1 0 0 0 0 0 (default, delete, elision, move, read, rewrite) I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + memtbl 2 32 M I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 +zmemtbl 0 0 B I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + ztbl 0 0 B I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + bcache 54 1.6 M 98.9% (score == hit-rate) I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + tcache 1 680 B 99.9% (score == hit-rate) I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + snaps 0 - 0 (score == earliest seq num) I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + titers 0 I250125 04:43:40.708703 167 kv/kvserver/store.go:3290 ⋮ [n1,s1] 70 + filter - - 0.0% (score == utility) E250125 04:43:40.709265 198 1@server/status/runtime.go:454 ⋮ [n1] 71 unable to get mem usage: ‹not implemented on illumos› E250125 04:43:40.709335 198 1@server/status/runtime.go:458 ⋮ [n1] 72 unable to get cpu usage: ‹not implemented on illumos› W250125 04:43:40.709384 198 1@server/status/runtime.go:478 ⋮ [n1] 73 problem fetching disk stats: ‹not implemented yet›; disk stats will be empty. W250125 04:43:40.709404 198 1@server/status/runtime.go:499 ⋮ [n1] 74 problem fetching net stats: ‹not implemented yet›; net stats will be empty. E250125 04:43:40.721449 295 server/status/recorder.go:420 ⋮ [n1,summaries] 75 could not get total system memory: ‹not implemented on illumos›