<p dir="ltr">Thanks, I was already on my way to do it.<br>
Note that's done.</p>
<div class="gmail_quote">Le 20 févr. 2015 20:50, "Digimer" <<a href="mailto:lists@alteeve.ca">lists@alteeve.ca</a>> a écrit :<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
Do you mind asking this in the new mailing list?<br>
<br>
<a href="http://clusterlabs.org/mailman/listinfo/users" target="_blank">http://clusterlabs.org/mailman/listinfo/users</a><br>
<br>
This list is scheduled to be closed and all users are encouraged to<br>
switch. :)<br>
<br>
On 20/02/15 02:18 PM, Alexandre wrote:<br>
> Hi list,<br>
><br>
> I am facing a very strange issue. I have setup a postgresql cluster<br>
> (with streaming repl). The replication works ok when started<br>
> manually but the RA seems to never promote any host where the<br>
> resource is started.<br>
><br>
> my config is bellow: node <a href="http://pp-obm-sgbd.upond.fr" target="_blank">pp-obm-sgbd.upond.fr</a><br>
> <<a href="http://pp-obm-sgbd.upond.fr" target="_blank">http://pp-obm-sgbd.upond.fr</a>> node <a href="http://pp-obm-sgbd2.upond.fr" target="_blank">pp-obm-sgbd2.upond.fr</a><br>
> <<a href="http://pp-obm-sgbd2.upond.fr" target="_blank">http://pp-obm-sgbd2.upond.fr</a>> \ attributes<br>
> pri_pgsql-data-status=DISCONNECT primitive pri_obm-locator<br>
> lsb:obm-locator \ params \ op start interval=0s timeout=60s \ op<br>
> stop interval=0s timeout=60s \ op monitor interval=10s timeout=20s<br>
> primitive pri_pgsql pgsql \ params<br>
> pgctl="/usr/pgsql-9.1/bin/pg_ctl" psql="/usr/pgsql-9.1/bin/psql"<br>
> pgdata="/var/lib/pgsql/9.1/data/" node_list="<a href="http://pp-obm-sgbd.upond.fr" target="_blank">pp-obm-sgbd.upond.fr</a><br>
> <<a href="http://pp-obm-sgbd.upond.fr" target="_blank">http://pp-obm-sgbd.upond.fr</a>> <a href="http://pp-obm-sgbd2.upond.fr" target="_blank">pp-obm-sgbd2.upond.fr</a><br>
> <<a href="http://pp-obm-sgbd2.upond.fr" target="_blank">http://pp-obm-sgbd2.upond.fr</a>>" repuser=replication rep_mode=sync<br>
> restart_on_promote=true restore_command="cp<br>
> /var/lib/pgsql/replication/%f %p"<br>
> primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5<br>
> keepalives_count=5" master_ip=193.50.151.200 \ op start interval=0<br>
> on-fail=restart timeout=120s \ op monitor interval=20s<br>
> on-fail=restart timeout=60s \ op monitor interval=15s<br>
> on-fail=restart role=Master timeout=60s \ op promote interval=0<br>
> on-fail=restart timeout=120s \ op demote interval=0 on-fail=stop<br>
> timeout=120s \ op notify interval=0s timeout=60s \ op stop<br>
> interval=0 on-fail=block timeout=120s primitive pri_vip IPaddr2 \<br>
> params ip=193.50.151.200 nic=eth1 cidr_netmask=32 \ op start<br>
> interval=0s timeout=60s \ op monitor interval=10s timeout=60s \ op<br>
> stop interval=0s timeout=60s ms ms_pgsql pri_pgsql \ meta<br>
> master-max=1 master-node-max=1 clone-max=2 clone-node-max=1<br>
> colocation clc_vip-ms_pgsql inf: pri_vip:Started ms_pgsql:Master<br>
> order ord_dm_pgsql-vip 0: ms_pgsql:demote pri_vip:stop order<br>
> ord_pm_pgsql-vip 0: ms_pgsql:promote pri_vip:start<br>
> symmetrical=false property cib-bootstrap-options: \<br>
> dc-version=1.1.11-97629de \ cluster-infrastructure=cman \<br>
> last-lrm-refresh=1424459378 \ no-quorum-policy=ignore \<br>
> stonith-enabled=false \ maintenance-mode=false rsc_defaults<br>
> rsc_defaults-options: \ resource-stickiness=1000 \<br>
> migration-threshold=5<br>
><br>
> crm_mon shows both hosts as slaves and none is never promoted<br>
> ever:<br>
><br>
> Master/Slave Set: ms_pgsql [pri_pgsql] Slaves: [<br>
> <a href="http://pp-obm-sgbd.upond.fr" target="_blank">pp-obm-sgbd.upond.fr</a> <<a href="http://pp-obm-sgbd.upond.fr" target="_blank">http://pp-obm-sgbd.upond.fr</a>><br>
> <a href="http://pp-obm-sgbd2.upond.fr" target="_blank">pp-obm-sgbd2.upond.fr</a> <<a href="http://pp-obm-sgbd2.upond.fr" target="_blank">http://pp-obm-sgbd2.upond.fr</a>> ] Node<br>
> Attributes: * Node <a href="http://pp-obm-sgbd.upond.fr" target="_blank">pp-obm-sgbd.upond.fr</a><br>
> <<a href="http://pp-obm-sgbd.upond.fr" target="_blank">http://pp-obm-sgbd.upond.fr</a>>: + master-pri_pgsql<br>
> : 1000 + pri_pgsql-status : HS:alone +<br>
> pri_pgsql-xlog-loc : 000000002D000078 * Node<br>
> <a href="http://pp-obm-sgbd2.upond.fr" target="_blank">pp-obm-sgbd2.upond.fr</a> <<a href="http://pp-obm-sgbd2.upond.fr" target="_blank">http://pp-obm-sgbd2.upond.fr</a>>: +<br>
> master-pri_pgsql : -INFINITY +<br>
> pri_pgsql-data-status : DISCONNECT + pri_pgsql-status<br>
> : HS:alone + pri_pgsql-xlog-loc : 000000002D000000<br>
><br>
> on the host I am expecting promotion I see when doing cleanups: Feb<br>
> 20 20:15:07 pp-obm-sgbd pgsql(pri_pgsql)[30994]: INFO: Master does<br>
> not exist. Feb 20 20:15:07 pp-obm-sgbd pgsql(pri_pgsql)[30994]:<br>
> INFO: My data status=.<br>
><br>
> And on the other node I see the following logs that sounds<br>
> interrseting: Feb 20 20:16:10 pp-obm-sgbd2 crmd[19626]: notice:<br>
> print_synapse: [Action 18]: Pending pseudo op ms_pgsql_promoted_0<br>
> on N/A (priority: 1000000, waiting: 11) Feb 20 20:16:10<br>
> pp-obm-sgbd2 crmd[19626]: notice: print_synapse: [Action 17]:<br>
> Pending pseudo op ms_pgsql_promote_0 on N/A<br>
> (priority: 0, waiting: 21)<br>
><br>
> the N/A part seems to tell me the cluster don't know where to<br>
> promote the resource but I can't understand why.<br>
><br>
> bellow are my constraint rules:<br>
><br>
> pcs constraint show Location Constraints: Ordering Constraints:<br>
> demote ms_pgsql then stop pri_vip (score:0) promote ms_pgsql then<br>
> start pri_vip (score:0) (non-symmetrical) Colocation Constraints:<br>
> pri_vip with ms_pgsql (score:INFINITY) (rsc-role:Started)<br>
> (with-rsc-role:Master)<br>
><br>
> I am now out of ideas so any help is very much appreciated.<br>
><br>
> Regards.<br>
><br>
><br>
> _______________________________________________ Pacemaker mailing<br>
> list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a> Getting started:<br>
> <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a> Bugs:<br>
> <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
><br>
<br>
<br>
- --<br>
Digimer<br>
Papers and Projects: <a href="https://alteeve.ca/w/" target="_blank">https://alteeve.ca/w/</a><br>
What if the cure for cancer is trapped in the mind of a person without<br>
access to education?<br>
-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1<br>
<br>
iQIcBAEBAgAGBQJU541RAAoJECChztQA3mh0/RMP/1ldfDi4Vai2Y2bkUbiDnY03<br>
oiVrPK0T8jswH04SpdkwyzQxiiAl9stWEy3VWgqn1sfqZAmoYAXK+8GncFshRxwr<br>
LygQH/BD4AhMGvONqtScMzwvk+5MiVuZxU5IY/oGkCNXKO104GL+XDnM4QPi8ppe<br>
ELmu6BApcN20FZ62Qsao4nDqsXmuSxbVBYssAQzNTPlRgqJzIUeXWtbNGiIub4FN<br>
5PNNhpsoxPBe55myVKgIqqE0RYDhdi5SomZ29hDuYOl9dmTaTxF8nwOU7DuXaSfO<br>
ZBoQIWG5fmm4qiy2BkleHgetfQKYqt7VHYkD+Bm0AiJkBL3hJt58fJC8QrO0VWMp<br>
3EfXqA1N33Ov43jF2IocsrEUIghpwx4ytaTUN5XszV2lR3EEoklG17uOJ7qRHFjr<br>
2PuOYRvZLlCwInAfYKp56kkfJztYtnKOCpf+l0MdOAAIh/vq8mjDxhoptSXVyc+O<br>
xaoKEvTxROEHOtc2gtYPAV6UNnuE+BF5Bt09bOeVoAD49nhuu7iuvszF245QGt/T<br>
10Z1I0jgMhbuyEDW/NQZZT3mhXJ/Jz3IadcnKPuSHdfrfZI2rKlCyYGEOUdesrFq<br>
ty4U4wganYJdbfAMR4E9x5gXeBUpLkdGcI+28lWJKsZ1d2jincY1wT+e4MwZwqJW<br>
zyFEQmZXCF4k5BMTlYED<br>
=ntpM<br>
-----END PGP SIGNATURE-----<br>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
</blockquote></div>