[Pacemaker] postgresql never promoted

Fri Feb 20 20:00:41 UTC 2015

Thanks, I was already on my way to do it.
Note that's done.
Le 20 févr. 2015 20:50, "Digimer" <lists at alteeve.ca> a écrit :

> -----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-----
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20150220/8984b020/attachment.htm>