Comments (3)
Ok removed the files from pg_xlog/, base/ and global/. Governor is now trying to start again.
LOG: database system was shut down in recovery at 2015-08-27 12:21:31 CEST
WARNING: recovery command file "recovery.conf" specified neither primary_conninfo nor restore_command
HINT: The database server will regularly poll the pg_xlog subdirectory to check for files placed there.
LOG: entering standby mode
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
2015-08-27 12:24:18,544 ERROR: Error communicating with Postgresql. Will try again.
2015-08-27 12:24:18,545 INFO: None
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
Traceback (most recent call last):
File "./governor.py", line 64, in <module>
if postgresql.is_leader():
File "/var/lib/postgresql/governor/helpers/postgresql.py", line 84, in is_leader
return not self.query("SELECT pg_is_in_recovery();").fetchone()[0]
File "/var/lib/postgresql/governor/helpers/postgresql.py", line 49, in query
raise e
psycopg2.OperationalError: FATAL: the database system is starting up
LOG: received fast shutdown request
waiting for server to shut down....LOG: shutting down
LOG: database system is shut down
done
server stopped
from governor.
Ok bacially I did a clean restart by cleaning up as you recommended in #13 (comment)
But now I get:
2015-08-27 13:17:39,940 INFO: Lock owner: sql2; I am sql3
2015-08-27 13:17:39,941 INFO: does not have lock
2015-08-27 13:17:39,946 INFO: no action. i am a secondary and i am following a leader
FATAL: database system identifier differs between the primary and standby
DETAIL: The primary's identifier is 6187648254339472088, the standby's identifier is 6150520899791371405.
FATAL: database system identifier differs between the primary and standby
from governor.
This happens when you do a pg_basebackup
from a different Postgres cluster than you are trying to stream replication from. This can also happen if you run initdb
for the member instead of running pg_basebackup
from the cluster's leader.
I'm assuming you ran initdb
for this Postgres directory. If you did, remove the data directory for that Postgres, and let governor run initialize the empty directory from the cluster's leader. Basically, you should start governor with Postgres uninitialized.
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
- 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.