Comments (5)
Creating the data directory manually gives a new error:
$ mkdir -p data/postgres
postgres@sql1:~/governor$ ./governor.py postgresql.yml
^CTraceback (most recent call last):
File "./governor.py", line 48, in <module>
time.sleep(5)
KeyboardInterrupt
pg_ctl: directory "data/postgres" is not a database cluster directory
from governor.
So after adding some more debugging I am actually stuck at
while not synced_from_leader:
logging.info("I am not in sync")
leader = etcd.current_leader()
print(leader)
if not leader:
logging.info("I am not the leader, waiting 5 seconds")
time.sleep(5)
continue
because my leader is None
. Not sure how to recover from that..
from governor.
Actually on sql1 node:
curl http://127.0.0.1:2379/v2/stats/leader
{"leader":"f3a45927640b6da1","followers":{"8d32f0c7cf61d86f":{"latency":{"current":0.005404,"average":0.005804184899796387,"standardDeviation":0.004551149296781203,"minimum":0,"maximum":0.453886},"counts":{"fail":0,"success":1084939}},"c351a9659cc1ca65":{"latency":{"current":0.004392,"average":0.004885503809053086,"standardDeviation":0.008000549516033555,"minimum":0,"maximum":6.972503},"counts":{"fail":0,"success":1085703}}}}
On the other two nodes:
curl http://127.0.0.1:2379/v2/stats/leader
{"message":"not current leader"}
So the leader is f3a45927640b6da1
which is the sql1 node..
from governor.
Ok, I had to clear/rm the initialize key as there was probably a previous value defined?
postgres@sql2:~/governor$ etcdctl -o extended get /service/batman/initialize
Key: /service/batman/initialize
Created-Index: 8
Modified-Index: 8
TTL: 0
Etcd-Index: 54
Raft-Index: 520353
Raft-Term: 9
sql1
from governor.
Typically, if you are starting a new test with governor, it is best to stop etcd and any governor processes. Then, run rm -rf data/*
from the governor directory. Then, restart etcd + the governor processes.
from governor.
Related Issues (20)
- database system identifier differs between the primary and standby? HOT 2
- etcd returns 500 internal server error on ubuntu which causes postgres to crash. HOT 1
- 404 error causing the postgres to go down
- Use python-etcd client library HOT 1
- Fatal: requested timeline 8 is not a child of this server's history HOT 3
- Fencing and Quorum Support HOT 3
- Local Docker cluster with Governor on board HOT 1
- Make governor a module
- PostgreSQL + haproxy with multiple IP HOT 3
- not catching ssl timeout exception HOT 1
- rewind ex-leader before joining again HOT 2
- [Errno 32] Broken pipe HOT 1
- non atomic has_lock() and update_lock()
- cannot easily "go build" golang-custom-raft; maybe we should have a new project? HOT 1
- golang-custom-raft: add abilty to execute post-election script HOT 14
- New GB build tool based off of golang-custom-raft branch with a new name - hapg HOT 2
- golang-custom-raft: If a PG process is unhealthy - it can kill governor
- golang-custom-raft: maximum_lag_on_failover doesn't work as it should
- help:the connect info in the recover.conf are "None"
- replication slots failing when names contain dashes
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from governor.