Skip to content

Instantly share code, notes, and snippets.

@irfansharif
Created July 20, 2020 21:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save irfansharif/0b363fca93648fffd3189a924413d90f to your computer and use it in GitHub Desktop.
Save irfansharif/0b363fca93648fffd3189a924413d90f to your computer and use it in GitHub Desktop.
I200720 21:13:22.954399 1 util/log/sync_buffer.go:70 [config] file created at: 2020/07/20 21:13:22
I200720 21:13:22.954399 1 util/log/sync_buffer.go:70 [config] running on machine: Irfans-MacBook-Pro
I200720 21:13:22.954399 1 util/log/sync_buffer.go:70 [config] binary: CockroachDB CCL v20.1.3 (x86_64-apple-darwin14, built 2020/06/23 08:38:34, go1.13.9)
I200720 21:13:22.954399 1 util/log/sync_buffer.go:70 [config] arguments: [/Users/irfansharif/local/2/cockroach-20.1.3 start --insecure --store=path=/Users/irfansharif/local/2/data --log-dir=/Users/irfansharif/local/2/logs --cache=6% --max-sql-memory=6% --listen-addr=127.0.0.1 --port=26259 --http-port=26260 --locality=region=local,zone=local --join=127.0.0.1:26257]
I200720 21:13:22.954399 1 util/log/sync_buffer.go:70 line format: [IWEF]yymmdd hh:mm:ss.uuuuuu goid file:line msg utf8=✓
I200720 21:13:22.954397 1 cli/start.go:1223 logging to directory /Users/irfansharif/local/2/logs
W200720 21:13:22.954924 1 cli/start.go:1272 RUNNING IN INSECURE MODE!
- Your cluster is open for any client that can access 127.0.0.1.
- Any user, even root, can log in without providing a password.
- Any user, connecting as root, can read or write any data in your cluster.
- There is no network encryption nor authentication, and thus no confidentiality.
Check out how to secure your cluster: https://www.cockroachlabs.com/docs/v20.1/secure-a-cluster.html
I200720 21:13:22.954942 1 cli/start.go:1286 CockroachDB CCL v20.1.3 (x86_64-apple-darwin14, built 2020/06/23 08:38:34, go1.13.9)
I200720 21:13:22.956941 1 server/config.go:404 system total memory: 16 GiB
I200720 21:13:22.956982 1 server/config.go:406 server configuration:
max offset 500000000
cache size 983 MiB
SQL memory pool size 983 MiB
scan interval 10m0s
scan min idle time 10ms
scan max idle time 1s
event log enabled true
I200720 21:13:22.956990 1 cli/start.go:1122 using local environment variables: COCKROACH_ENABLE_RPC_COMPRESSION=false, COCKROACH_BACKGROUND_RESTART=1, GOTRACEBACK=crash
I200720 21:13:22.957016 1 cli/start.go:1129 process identity: uid 501 euid 501 gid 20 egid 20
I200720 21:13:22.957077 1 cli/start.go:697 starting cockroach node
I200720 21:13:22.957803 133 storage/rocksdb.go:606 opening rocksdb instance at "/Users/irfansharif/local/2/data/cockroach-temp199849177"
I200720 21:13:22.980748 133 server/server.go:1066 [n?] monitoring forward clock jumps based on server.clock.forward_jump_check_enabled
I200720 21:13:22.982950 133 storage/rocksdb.go:606 opening rocksdb instance at "/Users/irfansharif/local/2/data"
I200720 21:13:22.991422 133 server/config.go:578 [n?] 1 storage engine initialized
I200720 21:13:22.991433 133 server/config.go:581 [n?] RocksDB cache size: 983 MiB
I200720 21:13:22.991437 133 server/config.go:581 [n?] store 0: RocksDB, max size 0 B, max open file limit 10000
W200720 21:13:23.004673 133 gossip/gossip.go:1513 [n?] no incoming or outgoing connections
I200720 21:13:23.005934 42 gossip/client.go:124 [n?] started gossip client to 127.0.0.1:26257
I200720 21:13:23.058215 133 server/server.go:1112 [n?] Sleeping till wall time 1595279603058184000 to catches up to 1595279603480710001 to ensure monotonicity. Delta: 422.526001ms
I200720 21:13:23.481192 133 gossip/gossip.go:395 [n2] NodeDescriptor set to node_id:2 address:<network_field:"tcp" address_field:"127.0.0.1:26259" > attrs:<> locality:<tiers:<key:"region" value:"local" > tiers:<key:"zone" value:"local" > > ServerVersion:<major_val:20 minor_val:1 patch:0 unstable:0 > build_tag:"v20.1.3" started_at:1595279603481020000 cluster_name:"" sql_address:<network_field:"tcp" address_field:"127.0.0.1:26259" >
I200720 21:13:23.507373 133 server/node.go:428 [n2] initialized store [n2,s2]: disk (capacity=234 GiB, available=43 GiB, used=751 KiB, logicalBytes=1.4 MiB), ranges=95, leases=0, queries=0.00, writes=0.00, bytesPerReplica={p10=0.00 p25=0.00 p50=0.00 p75=0.00 p90=0.00 pMax=899589.00}, writesPerReplica={p10=0.00 p25=0.00 p50=0.00 p75=0.00 p90=0.00 pMax=0.00}
I200720 21:13:23.507500 133 kv/kvserver/stores.go:247 [n2] read 3 node addresses from persistent storage
I200720 21:13:23.507680 133 server/node.go:649 [n2] connecting to gossip network to verify cluster ID...
I200720 21:13:23.507700 133 server/node.go:669 [n2] node connected via gossip and verified as part of cluster "af163ac3-1b89-4039-b468-45d7f6153dff"
I200720 21:13:23.507767 133 server/node.go:512 [n2] node=2: started with [<no-attributes>=/Users/irfansharif/local/2/data] engine(s) and attributes []
I200720 21:13:23.507987 383 sql/temporary_schema.go:452 [n2] skipping temporary object cleanup run as it is not the leaseholder
I200720 21:13:23.508007 383 sql/temporary_schema.go:453 [n2] completed temporary object cleanup job
I200720 21:13:23.508035 383 sql/temporary_schema.go:575 [n2] temporary object cleaner next scheduled to run at 2020-07-20 21:43:23.507881 +0000 UTC
I200720 21:13:23.508198 133 server/server.go:1630 [n2] starting http server at 127.0.0.1:26260 (use: 127.0.0.1:26260)
I200720 21:13:23.508215 133 server/server.go:1637 [n2] starting grpc/postgres server at 127.0.0.1:26259
I200720 21:13:23.508234 133 server/server.go:1638 [n2] advertising CockroachDB node at 127.0.0.1:26259
I200720 21:13:24.680359 133 server/server.go:1798 [n2] done ensuring all necessary migrations have run
I200720 21:13:24.680437 133 server/server.go:2040 [n2] serving sql connections
I200720 21:13:24.680515 416 sqlmigrations/migrations.go:759 [n2] starting wait for upgrade finalization before system.namespace migration
I200720 21:13:24.680571 133 cli/start.go:857 [config] clusterID: af163ac3-1b89-4039-b468-45d7f6153dff
I200720 21:13:24.680611 133 cli/start.go:866 node startup completed:
CockroachDB node starting at 2020-07-20 21:13:24.680482 +0000 UTC (took 1.7s)
build: CCL v20.1.3 @ 2020/06/23 08:38:34 (go1.13.9)
webui: http://127.0.0.1:26260
sql: postgresql://root@127.0.0.1:26259?sslmode=disable
RPC client flags: /Users/irfansharif/local/2/cockroach-20.1.3 <client cmd> --host=127.0.0.1:26259 --insecure
logs: /Users/irfansharif/local/2/logs
locality: region=local,zone=local
temp dir: /Users/irfansharif/local/2/data/cockroach-temp199849177
external I/O path: /Users/irfansharif/local/2/data/extern
store[0]: path=/Users/irfansharif/local/2/data
storage engine: rocksdb
status: restarted pre-existing node
clusterID: af163ac3-1b89-4039-b468-45d7f6153dff
nodeID: 2
I200720 21:13:24.680669 415 sqlmigrations/migrations.go:668 [n2] starting wait for upgrade finalization before schema change job migration
I200720 21:13:24.681008 416 sqlmigrations/migrations.go:792 [n2] starting system.namespace migration
I200720 21:13:24.739019 415 sqlmigrations/migrations.go:700 [n2] starting schema change job migration
I200720 21:13:25.246297 184 gossip/gossip.go:1527 [n2] node has connected to cluster via gossip
I200720 21:13:25.246627 184 kv/kvserver/stores.go:266 [n2] wrote 3 node addresses to persistent storage
W200720 21:13:25.513175 91 kv/kvserver/node_liveness.go:563 [n2,s2,r5/2:/Table/{SystemCon…-11}] slow heartbeat took 2.0s
E200720 21:13:25.513193 91 kv/kvserver/replica_range_lease.go:339 [n2,s2,r5/2:/Table/{SystemCon…-11}] heartbeat failed on epoch increment
W200720 21:13:25.513217 424 kv/kvserver/node_liveness.go:563 [n2,liveness-hb] slow heartbeat took 2.0s
I200720 21:13:25.513235 424 kv/kvserver/node_liveness.go:478 [n2,liveness-hb] heartbeat failed on epoch increment; retrying
I200720 21:13:25.520437 413 server/server_update.go:55 [n2] no need to upgrade, cluster already at the newest version
I200720 21:13:25.522258 415 sqlmigrations/migrations.go:1124 [schema-change-job-migration] evaluating tables for creating jobs
I200720 21:13:25.522285 415 sqlmigrations/migrations.go:719 [n2] schema change job migration completed
I200720 21:13:25.523051 417 sql/event_log.go:132 [n2] Event: "node_restart", target: 2, info: {Descriptor:{NodeID:2 Address:127.0.0.1:26259 Attrs: Locality:region=local,zone=local ServerVersion:20.1 BuildTag:v20.1.3 StartedAt:1595279603481020000 LocalityAddress:[] ClusterName: SQLAddress:127.0.0.1:26259} ClusterID:af163ac3-1b89-4039-b468-45d7f6153dff StartedAt:1595279603481020000 LastUp:1593452711671680000}
I200720 21:13:25.526813 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.527105 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.527367 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.527645 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.527890 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.528161 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.528390 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.528628 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.528866 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.529105 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.529336 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.529555 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.529776 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.529995 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.530221 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.530453 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.530702 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.530934 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.531201 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.531444 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.531688 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.531932 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
I200720 21:13:25.532176 416 sqlmigrations/migrations.go:846 [n2,system-namespace-migration] system.namespace migration already complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment