[Pacemaker] postgresql never promoted

Fri Feb 20 19:38:58 UTC 2015

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Do you mind asking this in the new mailing list?

http://clusterlabs.org/mailman/listinfo/users

This list is scheduled to be closed and all users are encouraged to
switch. :)

On 20/02/15 02:18 PM, Alexandre wrote:
> Hi list,
> 
> I am facing a very strange issue. I have setup a postgresql cluster
> (with streaming repl). The replication works ok when started
> manually but the RA seems to never promote any host where the
> resource is started.
> 
> my config is bellow: node pp-obm-sgbd.upond.fr
> <http://pp-obm-sgbd.upond.fr> node pp-obm-sgbd2.upond.fr
> <http://pp-obm-sgbd2.upond.fr> \ attributes
> pri_pgsql-data-status=DISCONNECT primitive pri_obm-locator
> lsb:obm-locator \ params \ op start interval=0s timeout=60s \ op
> stop interval=0s timeout=60s \ op monitor interval=10s timeout=20s 
> primitive pri_pgsql pgsql \ params
> pgctl="/usr/pgsql-9.1/bin/pg_ctl" psql="/usr/pgsql-9.1/bin/psql"
> pgdata="/var/lib/pgsql/9.1/data/" node_list="pp-obm-sgbd.upond.fr
> <http://pp-obm-sgbd.upond.fr> pp-obm-sgbd2.upond.fr
> <http://pp-obm-sgbd2.upond.fr>" repuser=replication rep_mode=sync
> restart_on_promote=true restore_command="cp
> /var/lib/pgsql/replication/%f %p" 
> primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5 
> keepalives_count=5" master_ip=193.50.151.200 \ op start interval=0
> on-fail=restart timeout=120s \ op monitor interval=20s
> on-fail=restart timeout=60s \ op monitor interval=15s
> on-fail=restart role=Master timeout=60s \ op promote interval=0
> on-fail=restart timeout=120s \ op demote interval=0 on-fail=stop
> timeout=120s \ op notify interval=0s timeout=60s \ op stop
> interval=0 on-fail=block timeout=120s primitive pri_vip IPaddr2 \ 
> params ip=193.50.151.200 nic=eth1 cidr_netmask=32 \ op start
> interval=0s timeout=60s \ op monitor interval=10s timeout=60s \ op
> stop interval=0s timeout=60s ms ms_pgsql pri_pgsql \ meta
> master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 
> colocation clc_vip-ms_pgsql inf: pri_vip:Started ms_pgsql:Master 
> order ord_dm_pgsql-vip 0: ms_pgsql:demote pri_vip:stop order
> ord_pm_pgsql-vip 0: ms_pgsql:promote pri_vip:start
> symmetrical=false property cib-bootstrap-options: \ 
> dc-version=1.1.11-97629de \ cluster-infrastructure=cman \ 
> last-lrm-refresh=1424459378 \ no-quorum-policy=ignore \ 
> stonith-enabled=false \ maintenance-mode=false rsc_defaults
> rsc_defaults-options: \ resource-stickiness=1000 \ 
> migration-threshold=5
> 
> crm_mon shows both hosts as slaves and none is never promoted
> ever:
> 
> Master/Slave Set: ms_pgsql [pri_pgsql] Slaves: [
> pp-obm-sgbd.upond.fr <http://pp-obm-sgbd.upond.fr> 
> pp-obm-sgbd2.upond.fr <http://pp-obm-sgbd2.upond.fr> ] Node
> Attributes: * Node pp-obm-sgbd.upond.fr
> <http://pp-obm-sgbd.upond.fr>: + master-pri_pgsql
> : 1000 + pri_pgsql-status                  : HS:alone +
> pri_pgsql-xlog-loc                : 000000002D000078 * Node
> pp-obm-sgbd2.upond.fr <http://pp-obm-sgbd2.upond.fr>: +
> master-pri_pgsql                  : -INFINITY +
> pri_pgsql-data-status             : DISCONNECT + pri_pgsql-status
> : HS:alone + pri_pgsql-xlog-loc                : 000000002D000000
> 
> on the host I am expecting promotion I see when doing cleanups: Feb
> 20 20:15:07 pp-obm-sgbd pgsql(pri_pgsql)[30994]: INFO: Master does 
> not exist. Feb 20 20:15:07 pp-obm-sgbd pgsql(pri_pgsql)[30994]:
> INFO: My data status=.
> 
> And on the other node I see the following logs that sounds
> interrseting: Feb 20 20:16:10 pp-obm-sgbd2 crmd[19626]:   notice:
> print_synapse: [Action   18]: Pending pseudo op ms_pgsql_promoted_0
> on N/A (priority: 1000000, waiting:  11) Feb 20 20:16:10
> pp-obm-sgbd2 crmd[19626]:   notice: print_synapse: [Action   17]:
> Pending pseudo op ms_pgsql_promote_0               on N/A 
> (priority: 0, waiting:  21)
> 
> the N/A part seems to tell me the cluster don't know where to
> promote the resource but I can't understand why.
> 
> bellow are my constraint rules:
> 
> pcs constraint show Location Constraints: Ordering Constraints: 
> demote ms_pgsql then stop pri_vip (score:0) promote ms_pgsql then
> start pri_vip (score:0) (non-symmetrical) Colocation Constraints: 
> pri_vip with ms_pgsql (score:INFINITY) (rsc-role:Started) 
> (with-rsc-role:Master)
> 
> I am now out of ideas so any help is very much appreciated.
> 
> Regards.
> 
> 
> _______________________________________________ Pacemaker mailing
> list: Pacemaker at oss.clusterlabs.org 
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> 
> Project Home: http://www.clusterlabs.org Getting started:
> http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs:
> http://bugs.clusterlabs.org
> 

- -- 
Digimer
Papers and Projects: https://alteeve.ca/w/
What if the cure for cancer is trapped in the mind of a person without
access to education?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJU541RAAoJECChztQA3mh0/RMP/1ldfDi4Vai2Y2bkUbiDnY03
oiVrPK0T8jswH04SpdkwyzQxiiAl9stWEy3VWgqn1sfqZAmoYAXK+8GncFshRxwr
LygQH/BD4AhMGvONqtScMzwvk+5MiVuZxU5IY/oGkCNXKO104GL+XDnM4QPi8ppe
ELmu6BApcN20FZ62Qsao4nDqsXmuSxbVBYssAQzNTPlRgqJzIUeXWtbNGiIub4FN
5PNNhpsoxPBe55myVKgIqqE0RYDhdi5SomZ29hDuYOl9dmTaTxF8nwOU7DuXaSfO
ZBoQIWG5fmm4qiy2BkleHgetfQKYqt7VHYkD+Bm0AiJkBL3hJt58fJC8QrO0VWMp
3EfXqA1N33Ov43jF2IocsrEUIghpwx4ytaTUN5XszV2lR3EEoklG17uOJ7qRHFjr
2PuOYRvZLlCwInAfYKp56kkfJztYtnKOCpf+l0MdOAAIh/vq8mjDxhoptSXVyc+O
xaoKEvTxROEHOtc2gtYPAV6UNnuE+BF5Bt09bOeVoAD49nhuu7iuvszF245QGt/T
10Z1I0jgMhbuyEDW/NQZZT3mhXJ/Jz3IadcnKPuSHdfrfZI2rKlCyYGEOUdesrFq
ty4U4wganYJdbfAMR4E9x5gXeBUpLkdGcI+28lWJKsZ1d2jincY1wT+e4MwZwqJW
zyFEQmZXCF4k5BMTlYED
=ntpM
-----END PGP SIGNATURE-----