<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi, Andrey.
<br>
<br>
Check parameter <i>postgrresql.conf</i> (unix_socket_directories)
and <br>
RA pqsql (OCF_RESKEY_socketdir=/tmp)<br>
<br>
> stderr: psql: could not connect to server: No such file or
directory
<br>
> stderr: Is the server running locally and accepting
<br>
> stderr: connections on Unix domain socket "<i
class="moz-txt-slash"><span class="moz-txt-tag">/</span>tmp<span
class="moz-txt-tag">/</span></i>.s.PGSQL.5432"?
<br>
> stderr: WARNING: Can't get PostgreSQL recovery status. rc=2
<br>
<br>
<div class="moz-cite-prefix">12.10.2015 17:44, Andrey Rubik пишет:<br>
</div>
<blockquote cite="mid:561BC747.70604@gmail.com" type="cite">Thanks
for reply.
<br>
<br>
Now I testing only Master/Slave configuration, but before i tried
full configuration with same results:
<br>
<br>
pcs cluster cib pgsql_cfg
<br>
<br>
pcs -f pgsql_cfg property set no-quorum-policy="ignore"
<br>
pcs -f pgsql_cfg property set stonith-enabled="false"
<br>
pcs -f pgsql_cfg resource defaults resource-stickiness="INFINITY"
<br>
pcs -f pgsql_cfg resource defaults migration-threshold="2"
<br>
<br>
pcs -f pgsql_cfg resource create vip-master IPaddr2 \
<br>
ip="10.200.200.225" \
<br>
nic="eth0" \
<br>
cidr_netmask="24" \
<br>
op start timeout="60s" interval="0s" on-fail="restart" \
<br>
op monitor timeout="60s" interval="10s" on-fail="restart" \
<br>
op stop timeout="60s" interval="0s" on-fail="block"
<br>
<br>
pcs -f pgsql_cfg resource create vip-rep IPaddr2 \
<br>
ip="10.200.200.224" \
<br>
nic="eth0" \
<br>
cidr_netmask="24" \
<br>
meta migration-threshold="0" \
<br>
op start timeout="60s" interval="0s" on-fail="stop" \
<br>
op monitor timeout="60s" interval="10s" on-fail="restart" \
<br>
op stop timeout="60s" interval="0s" on-fail="ignore"
<br>
<br>
pcs -f pgsql_cfg resource create pgsql pgsql \
<br>
pgctl="/usr/pgsql-9.3/bin/pg_ctl" \
<br>
psql="/usr/pgsql-9.3/bin/psql" \
<br>
pgdata="/var/lib/pgsql/9.3/data/" \
<br>
tmpdir="/var/lib/pgsql/9.3/tmp/" \
<br>
rep_mode="sync" \
<br>
node_list="pg1 pg2" \
<br>
restore_command="cp /var/lib/pgsql/9.3/backups/%f %p" \
<br>
primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5
keepalives_count=5" \
<br>
master_ip="10.200.200.225" \
<br>
restart_on_promote='false' \
<br>
op start timeout="60s" interval="0s" on-fail="restart" \
<br>
op monitor timeout="60s" interval="4s" on-fail="restart" \
<br>
op monitor timeout="60s" interval="3s" on-fail="restart"
role="Master" \
<br>
op promote timeout="60s" interval="0s" on-fail="restart" \
<br>
op demote timeout="60s" interval="0s" on-fail="stop" \
<br>
op stop timeout="60s" interval="0s" on-fail="block" \
<br>
op notify timeout="60s" interval="0s"
<br>
<br>
pcs -f pgsql_cfg resource master msPostgresql pgsql \
<br>
master-max=1 master-node-max=1 clone-max=2 clone-node-max=1
notify=true
<br>
<br>
pcs -f pgsql_cfg resource group add master-group vip-master
vip-rep
<br>
<br>
pcs -f pgsql_cfg constraint colocation add master-group with
Master msPostgresql INFINITY
<br>
pcs -f pgsql_cfg constraint order promote msPostgresql then start
master-group symmetrical=false score=INFINITY
<br>
pcs -f pgsql_cfg constraint order demote msPostgresql then stop
master-group symmetrical=false score=0
<br>
<br>
pcs cluster cib-push pgsql_cfg
<br>
<br>
<br>
<br>
crm_mon in this case:
<br>
<br>
Stack: corosync
<br>
Current DC: pm2 (version 1.1.13-a14efad) - partition with quorum
<br>
2 nodes and 4 resources configured
<br>
<br>
Online: [ pm1 pm2 ]
<br>
<br>
Full list of resources:
<br>
<br>
Master/Slave Set: msPostgresql [pgsql]
<br>
Slaves: [ pm1 pm2 ]
<br>
Resource Group: master-group
<br>
vip-master (ocf::heartbeat:IPaddr2): Stopped
<br>
vip-rep (ocf::heartbeat:IPaddr2): Stopped
<br>
<br>
Node Attributes:
<br>
* Node pm1:
<br>
+ master-pgsql : -INFINITY
<br>
+ pgsql-status : HS:alone
<br>
+ pgsql-xlog-loc : 0000000000000000
<br>
* Node pm2:
<br>
+ pgsql-status : HS:alone
<br>
+ pgsql-xlog-loc : 0000000000000000
<br>
<br>
Migration Summary:
<br>
* Node pm2:
<br>
* Node pm1:
<br>
<br>
<br>
<br>
<br>
<br>
<br>
On 12.10.2015 17:36, Nikolay Popov wrote:
<br>
<blockquote type="cite">Hi, Andrey.
<br>
<br>
You added VIP?
<br>
That is a VIP (master_ip="10.200.200.233")?
<br>
<br>
<br>
<br>
12.10.2015 17:23, Andrey Rubik пишет:
<br>
<blockquote type="cite">Hi all.
<br>
<br>
I'm trying to configure pgsql Master/Slave set with 2 nodes.
<br>
<br>
I'm get successful installation Master/Slave without
pacemaker.
<br>
<br>
Pacemaker version:
<br>
<br>
pacemakerd --features
<br>
Pacemaker 1.1.13 (Build: a14efad)
<br>
Supporting v3.0.10: generated-manpages agent-manpages
ascii-docs publican-docs ncurses libqb-logging libqb-ipc
upstart systemd nagios corosync-native atomic-attrd acls
<br>
<br>
That's my configuration:
<br>
<br>
pcs cluster cib pgsql_cfg
<br>
<br>
pcs -f pgsql_cfg property set no-quorum-policy="ignore"
<br>
pcs -f pgsql_cfg property set stonith-enabled="false"
<br>
<br>
pcs -f pgsql_cfg resource create pgsql pgsql \
<br>
pgctl="/usr/pgsql-9.3/bin/pg_ctl" \
<br>
psql="/usr/pgsql-9.3/bin/psql" \
<br>
pgdata="/var/lib/pgsql/9.3/data/" \
<br>
tmpdir="/var/lib/pgsql/9.3/tmp/" \
<br>
rep_mode="sync" \
<br>
node_list="pg1 pg2" \
<br>
restore_command="cp /var/lib/pgsql/9.3/backups/%f %p" \
<br>
primary_conninfo_opt="keepalives_idle=60
keepalives_interval=5 keepalives_count=5" \
<br>
master_ip="10.200.200.233" \
<br>
restart_on_promote='true' \
<br>
op start timeout="60s" interval="0s" on-fail="restart" \
<br>
op monitor timeout="60s" interval="4s" on-fail="restart" \
<br>
op monitor timeout="60s" interval="3s" on-fail="restart"
role="Master" \
<br>
op promote timeout="60s" interval="0s" on-fail="restart" \
<br>
op demote timeout="60s" interval="0s" on-fail="stop" \
<br>
op stop timeout="60s" interval="0s" on-fail="block" \
<br>
op notify timeout="60s" interval="0s"
<br>
<br>
pcs -f pgsql_cfg resource master msPostgresql pgsql \
<br>
master-max=1 master-node-max=1 clone-max=2 clone-node-max=1
notify=true
<br>
<br>
pcs cluster cib-push pgsql_cfg
<br>
<br>
<br>
<br>
crm_mon:
<br>
<br>
Stack: corosync
<br>
Current DC: pm2 (version 1.1.13-a14efad) - partition with
quorum
<br>
2 nodes and 2 resources configured
<br>
<br>
Online: [ pm1 pm2 ]
<br>
<br>
Full list of resources:
<br>
<br>
Master/Slave Set: msPostgresql [pgsql]
<br>
Slaves: [ pm1 pm2 ]
<br>
<br>
Node Attributes:
<br>
* Node pm1:
<br>
+ master-pgsql : -INFINITY
<br>
+ pgsql-data-status : LATEST
<br>
+ pgsql-status : HS:alone
<br>
+ pgsql-xlog-loc : 0000000000000000
<br>
* Node pm2:
<br>
+ master-pgsql : -INFINITY
<br>
+ pgsql-data-status : LATEST
<br>
+ pgsql-master-baseline : 0000000000000000
<br>
+ pgsql-status : HS:alone
<br>
+ pgsql-xlog-loc : 0000000000000000
<br>
<br>
Migration Summary:
<br>
* Node pm2:
<br>
* Node pm1:
<br>
<br>
<br>
<br>
/var/log/pacemaker.log:
<br>
<br>
WARNING: Can't get pg1 xlog location.
<br>
WARNING: Can't get pg2 xlog location.
<br>
WARNING: Can't get pg1 xlog location.
<br>
WARNING: Can't get pg2 xlog location.
<br>
.....
<br>
<br>
Its very strange messages since i have pgsql-xlog-loc in
crm_mon.
<br>
<br>
<br>
<br>
<br>
If I try set master manually it fails and then stop pm1 node:
<br>
<br>
crm_resource -N pm1 -r pgsql --force-promote
<br>
<br>
Operation promote for pgsql:0 (ocf:heartbeat:pgsql) returned 0
<br>
> stderr: INFO: Creating
/var/lib/pgsql/9.3/tmp//PGSQL.lock.
<br>
> stderr: INFO: My master baseline : 0000000000000000.
<br>
> stderr: INFO: Restarting PostgreSQL instead of promote.
<br>
> stderr: INFO: waiting for server to shut down.... done
server stopped
<br>
> stderr: INFO: PostgreSQL is down
<br>
> stderr: INFO: server starting
<br>
> stderr: INFO: PostgreSQL start command sent.
<br>
> stderr: psql: could not connect to server: No such file
or directory
<br>
> stderr: Is the server running locally and accepting
<br>
> stderr: connections on Unix domain socket
"/tmp/.s.PGSQL.5432"?
<br>
> stderr: WARNING: Can't get PostgreSQL recovery status.
rc=2
<br>
> stderr: WARNING: Connection error (connection to the
server went bad and the session was not interactive) occurred
while executing the psql command.
<br>
> stderr: DEBUG: PostgreSQL still hasn't started yet.
Waiting...
<br>
> stderr: DEBUG: PostgreSQL is running as a primary.
<br>
> stderr: INFO: PostgreSQL is started.
<br>
> stderr: INFO: Changing pgsql-status on pm1 :
HS:alone->PRI.
<br>
<br>
crm_mon:
<br>
<br>
Stack: corosync
<br>
Current DC: pm2 (version 1.1.13-a14efad) - partition with
quorum
<br>
2 nodes and 2 resources configured
<br>
<br>
Online: [ pm1 pm2 ]
<br>
<br>
Full list of resources:
<br>
<br>
Master/Slave Set: msPostgresql [pgsql]
<br>
Slaves: [ pm2 ]
<br>
Stopped: [ pm1 ]
<br>
<br>
Node Attributes:
<br>
* Node pm1:
<br>
+ master-pgsql : -INFINITY
<br>
+ master-pgsql:0 : 1000
<br>
+ pgsql-data-status : LATEST
<br>
+ pgsql-status : STOP
<br>
* Node pm2:
<br>
+ master-pgsql : -INFINITY
<br>
+ pgsql-data-status : LATEST
<br>
+ pgsql-master-baseline : 0000000000000000
<br>
+ pgsql-status : HS:alone
<br>
+ pgsql-xlog-loc : 0000000000000000
<br>
<br>
Migration Summary:
<br>
* Node pm2:
<br>
* Node pm1:
<br>
pgsql: migration-threshold=1000000 fail-count=1000000
last-failure='Mon Oct 12 17:12:04 2015'
<br>
<br>
Failed Actions:
<br>
* pgsql_start_0 on pm1 'unknown error' (1): call=47,
status=complete, exitreason='My data may be inconsistent. You
have to remove /var/lib/pgsql/9.3/tmp//PGSQL.lock file to
force start.',
<br>
last-rc-change='Mon Oct 12 17:12:04 2015', queued=0ms,
exec=170ms
<br>
<br>
<br>
<br>
That is verbose variant:
<br>
rm -f /var/lib/pgsql/9.3/tmp//PGSQL.lock
<br>
crm_resource -N pm1 -r pgsql --force-promote -V
<br>
Operation promote for pgsql:0 (ocf:heartbeat:pgsql) returned 0
<br>
> stderr: + 17:14:11: 22: '[' -x /sbin/runuser ']'
<br>
> stderr: + 17:14:11: 23: SU=runuser
<br>
> stderr: + 17:14:11: 45:
OCF_RESKEY_pgctl_default=/usr/bin/pg_ctl
<br>
> stderr: + 17:14:11: 46:
OCF_RESKEY_psql_default=/usr/bin/psql
<br>
> stderr: + 17:14:11: 47:
OCF_RESKEY_pgdata_default=/var/lib/pgsql/data
<br>
> stderr: + 17:14:11: 48:
OCF_RESKEY_pgdba_default=postgres
<br>
> stderr: + 17:14:11: 49: OCF_RESKEY_pghost_default=
<br>
> stderr: + 17:14:11: 50: OCF_RESKEY_pgport_default=5432
<br>
> stderr: + 17:14:11: 51:
OCF_RESKEY_pglibs_default=/usr/lib
<br>
> stderr: + 17:14:11: 52: OCF_RESKEY_start_opt_default=
<br>
> stderr: + 17:14:11: 53:
OCF_RESKEY_pgdb_default=template1
<br>
> stderr: + 17:14:11: 54:
OCF_RESKEY_logfile_default=/dev/null
<br>
> stderr: + 17:14:11: 55:
OCF_RESKEY_stop_escalate_default=30
<br>
> stderr: + 17:14:11: 56:
OCF_RESKEY_monitor_user_default=
<br>
> stderr: + 17:14:11: 57:
OCF_RESKEY_monitor_password_default=
<br>
> stderr: + 17:14:11: 58:
OCF_RESKEY_monitor_sql_default='select now();'
<br>
> stderr: + 17:14:11: 59:
OCF_RESKEY_check_wal_receiver_default=false
<br>
> stderr: + 17:14:11: 61:
OCF_RESKEY_rep_mode_default=none
<br>
> stderr: + 17:14:11: 62: OCF_RESKEY_node_list_default=
<br>
> stderr: + 17:14:11: 63:
OCF_RESKEY_restore_command_default=
<br>
> stderr: + 17:14:11: 64:
OCF_RESKEY_archive_cleanup_command_default=
<br>
> stderr: + 17:14:11: 65:
OCF_RESKEY_recovery_end_command_default=
<br>
> stderr: + 17:14:11: 66: OCF_RESKEY_master_ip_default=
<br>
> stderr: + 17:14:11: 67:
OCF_RESKEY_repuser_default=postgres
<br>
> stderr: + 17:14:11: 68:
OCF_RESKEY_primary_conninfo_opt_default=
<br>
> stderr: + 17:14:11: 69:
OCF_RESKEY_restart_on_promote_default=false
<br>
> stderr: + 17:14:11: 70:
OCF_RESKEY_tmpdir_default=/var/lib/pgsql/tmp
<br>
> stderr: + 17:14:11: 71:
OCF_RESKEY_xlog_check_count_default=3
<br>
> stderr: + 17:14:11: 72:
OCF_RESKEY_crm_attr_timeout_default=5
<br>
> stderr: + 17:14:11: 73:
OCF_RESKEY_stop_escalate_in_slave_default=30
<br>
> stderr: + 17:14:11: 74:
OCF_RESKEY_replication_slot_name_default=
<br>
> stderr: + 17:14:11: 76: : /usr/pgsql-9.3/bin/pg_ctl
<br>
> stderr: + 17:14:11: 77: : /usr/pgsql-9.3/bin/psql
<br>
> stderr: + 17:14:11: 78: : /var/lib/pgsql/9.3/data/
<br>
> stderr: + 17:14:11: 79: : postgres
<br>
> stderr: + 17:14:11: 80: :
<br>
> stderr: + 17:14:11: 81: : 5432
<br>
> stderr: + 17:14:11: 82: : /usr/lib
<br>
> stderr: + 17:14:11: 83: :
/var/lib/pgsql/9.3/data//postgresql.conf
<br>
> stderr: + 17:14:11: 84: :
<br>
> stderr: + 17:14:11: 85: : template1
<br>
> stderr: + 17:14:11: 86: : /dev/null
<br>
> stderr: + 17:14:11: 87: : 30
<br>
> stderr: + 17:14:11: 88: :
<br>
> stderr: + 17:14:11: 89: :
<br>
> stderr: + 17:14:11: 90: : select 'now();'
<br>
> stderr: + 17:14:11: 91: : false
<br>
> stderr: + 17:14:11: 94: : sync
<br>
> stderr: + 17:14:11: 95: : pg1 pg2
<br>
> stderr: + 17:14:11: 96: : cp
/var/lib/pgsql/9.3/backups/%f %p
<br>
> stderr: + 17:14:11: 97: :
<br>
> stderr: + 17:14:11: 98: :
<br>
> stderr: + 17:14:11: 99: : 10.200.200.233
<br>
> stderr: + 17:14:11: 100: : postgres
<br>
> stderr: + 17:14:11: 101: : keepalives_idle=60
keepalives_interval=5 keepalives_count=5
<br>
> stderr: + 17:14:11: 102: : true
<br>
> stderr: + 17:14:11: 103: : /var/lib/pgsql/9.3/tmp/
<br>
> stderr: + 17:14:11: 104: : 3
<br>
> stderr: + 17:14:11: 105: : 5
<br>
> stderr: + 17:14:11: 106: : 30
<br>
> stderr: + 17:14:11: 107: :
<br>
> stderr: + 17:14:11: 1935: '[' 1 -ne 1 ']'
<br>
> stderr: + 17:14:11: 1942:
PIDFILE=/var/lib/pgsql/9.3/data//postmaster.pid
<br>
> stderr: + 17:14:11: 1943:
BACKUPLABEL=/var/lib/pgsql/9.3/data//backup_label
<br>
> stderr: ++ 17:14:11: 1944: echo pgsql:0
<br>
> stderr: ++ 17:14:11: 1944: cut -d : -f 1
<br>
> stderr: + 17:14:11: 1944: RESOURCE_NAME=pgsql
<br>
> stderr: + 17:14:11: 1945:
PGSQL_WAL_RECEIVER_STATUS_ATTR=pgsql-receiver-status
<br>
> stderr: + 17:14:11: 1946:
RECOVERY_CONF=/var/lib/pgsql/9.3/data//recovery.conf
<br>
> stderr: ++ 17:14:11: 1947: ocf_local_nodename
<br>
> stderr: ++ 17:14:11: 1947: tr '[A-Z]' '[a-z]'
<br>
> stderr: ++ 17:14:11: ocf_local_nodename:570: which
pacemakerd
<br>
> stderr: ++ 17:14:11: ocf_local_nodename:571: '[' 0 -eq
0 ']'
<br>
> stderr: +++ 17:14:11: ocf_local_nodename:572:
pacemakerd '-$'
<br>
> stderr: +++ 17:14:12: ocf_local_nodename:572: grep
'Pacemaker .*'
<br>
> stderr: +++ 17:14:12: ocf_local_nodename:572: awk '{
print $2 }'
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:572: local
version=1.1.13
<br>
> stderr: +++ 17:14:12: ocf_local_nodename:573: echo
1.1.13
<br>
> stderr: +++ 17:14:12: ocf_local_nodename:573: awk -F-
'{ print $1 }'
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:573:
version=1.1.13
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:574:
ocf_version_cmp 1.1.13 1.1.8
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:543: ocf_is_ver
1.1.13
<br>
> stderr: ++ 17:14:12: ocf_is_ver:513: grep
'^[0-9][0-9.-]*[0-9]$'
<br>
> stderr: ++ 17:14:12: ocf_is_ver:513: echo 1.1.13
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:544: ocf_is_ver
1.1.8
<br>
> stderr: ++ 17:14:12: ocf_is_ver:513: grep
'^[0-9][0-9.-]*[0-9]$'
<br>
> stderr: ++ 17:14:12: ocf_is_ver:513: echo 1.1.8
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:545: local
v1=1.1.13
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:546: local
v2=1.1.8
<br>
> stderr: +++ 17:14:12: ocf_version_cmp:547:
ocf_ver_level 1.1.13
<br>
> stderr: +++ 17:14:12: ocf_ver_level:521: awk '-F[.-]'
'{print NF}'
<br>
> stderr: +++ 17:14:12: ocf_ver_level:521: echo 1.1.13
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:547: local
v1_level=3
<br>
> stderr: +++ 17:14:12: ocf_version_cmp:548:
ocf_ver_level 1.1.8
<br>
> stderr: +++ 17:14:12: ocf_ver_level:521: awk '-F[.-]'
'{print NF}'
<br>
> stderr: +++ 17:14:12: ocf_ver_level:521: echo 1.1.8
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:548: local
v2_level=3
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:549: local
level_diff
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:550: '[' 3 -lt 3
']'
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:553: '[' 3 -gt 3
']'
<br>
> stderr: +++ 17:14:12: ocf_version_cmp:557: ocf_ver2num
1.1.13
<br>
> stderr: +++ 17:14:12: ocf_ver2num:516: awk '-F[.-]' '
<br>
> stderr: {for(i=1; i<=NF; i++) s=s*1000+$i; print
s}
<br>
> stderr: '
<br>
> stderr: +++ 17:14:12: ocf_ver2num:516: echo 1.1.13
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:557: v1=1001013
<br>
> stderr: +++ 17:14:12: ocf_version_cmp:558: ocf_ver2num
1.1.8
<br>
> stderr: +++ 17:14:12: ocf_ver2num:516: awk '-F[.-]' '
<br>
> stderr: {for(i=1; i<=NF; i++) s=s*1000+$i; print
s}
<br>
> stderr: '
<br>
> stderr: +++ 17:14:12: ocf_ver2num:516: echo 1.1.8
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:558: v2=1001008
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:559: '[' 1001013
-eq 1001008 ']'
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:561: '[' 1001013
-lt 1001008 ']'
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:564: return 2
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:575: '[' 2 -eq
2 ']'
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:576: which
crm_node
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:577: '[' 0 -eq
0 ']'
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:578: crm_node
-n
<br>
> stderr: ++ 17:14:12: ocf_local_nodename:579: return
<br>
> stderr: + 17:14:12: 1947: NODENAME=pm1
<br>
> stderr: + 17:14:12: 1949: is_replication
<br>
> stderr: + 17:14:12: is_replication:1287: '[' sync '!='
none -a sync '!=' slave ']'
<br>
> stderr: + 17:14:12: is_replication:1288: return 0
<br>
> stderr: + 17:14:12: 1950:
REP_MODE_CONF=/var/lib/pgsql/9.3/tmp//rep_mode.conf
<br>
> stderr: + 17:14:12: 1951:
PGSQL_LOCK=/var/lib/pgsql/9.3/tmp//PGSQL.lock
<br>
> stderr: + 17:14:12: 1952:
XLOG_NOTE_FILE=/var/lib/pgsql/9.3/tmp//xlog_note
<br>
> stderr: + 17:14:12: 1954:
CRM_MASTER='/usr/sbin/crm_master -l reboot'
<br>
> stderr: + 17:14:12: 1955:
CRM_ATTR_REBOOT='/usr/sbin/crm_attribute -l reboot'
<br>
> stderr: + 17:14:12: 1956:
CRM_ATTR_FOREVER='/usr/sbin/crm_attribute -l forever'
<br>
> stderr: + 17:14:12: 1957:
CRM_FAILCOUNT=/usr/sbin/crm_failcount
<br>
> stderr: + 17:14:12: 1959: CAN_NOT_PROMOTE=-INFINITY
<br>
> stderr: + 17:14:12: 1960: CAN_PROMOTE=100
<br>
> stderr: + 17:14:12: 1961: PROMOTE_ME=1000
<br>
> stderr: + 17:14:12: 1963: CHECK_MS_SQL='select
pg_is_in_recovery()'
<br>
> stderr: + 17:14:12: 1964: CHECK_XLOG_LOC_SQL='select
pg_last_xlog_replay_location(),pg_last_xlog_receive_location()'
<br>
> stderr: + 17:14:12: 1965:
CHECK_REPLICATION_STATE_SQL='select
application_name,upper(state),upper(sync_state) from
pg_stat_replication'
<br>
> stderr: + 17:14:12: 1967:
PGSQL_STATUS_ATTR=pgsql-status
<br>
> stderr: + 17:14:12: 1968:
PGSQL_DATA_STATUS_ATTR=pgsql-data-status
<br>
> stderr: + 17:14:12: 1969:
PGSQL_XLOG_LOC_NAME=pgsql-xlog-loc
<br>
> stderr: + 17:14:12: 1970:
PGSQL_MASTER_BASELINE=pgsql-master-baseline
<br>
> stderr: ++ 17:14:12: 1972: echo pg1 pg2
<br>
> stderr: ++ 17:14:12: 1972: tr '[A-Z]' '[a-z]'
<br>
> stderr: + 17:14:12: 1972: NODE_LIST='pg1 pg2'
<br>
> stderr: + 17:14:12: 1973: RE_CONTROL_SLAVE=false
<br>
> stderr: + 17:14:12: 1976: case "$1" in
<br>
> stderr: + 17:14:12: 1984: pgsql_validate_all
<br>
> stderr: + 17:14:12: pgsql_validate_all:1749: local
version
<br>
> stderr: + 17:14:12: pgsql_validate_all:1750: local
check_config_rc
<br>
> stderr: + 17:14:12: pgsql_validate_all:1751: local
rep_mode_string
<br>
> stderr: + 17:14:12: pgsql_validate_all:1752: local
socket_directories
<br>
> stderr: ++ 17:14:12: pgsql_validate_all:1754: cat
/var/lib/pgsql/9.3/data//PG_VERSION
<br>
> stderr: + 17:14:12: pgsql_validate_all:1754:
version=9.3
<br>
> stderr: + 17:14:12: pgsql_validate_all:1756:
check_binary2 /usr/pgsql-9.3/bin/pg_ctl
<br>
> stderr: + 17:14:12: check_binary2:1724: have_binary
/usr/pgsql-9.3/bin/pg_ctl
<br>
> stderr: + 17:14:12: have_binary:68: '[' '' = 1 ']'
<br>
> stderr: ++ 17:14:12: have_binary:71: echo
/usr/pgsql-9.3/bin/pg_ctl
<br>
> stderr: ++ 17:14:12: have_binary:71: sed -e 's/ -.*//'
<br>
> stderr: + 17:14:12: have_binary:71: local
bin=/usr/pgsql-9.3/bin/pg_ctl
<br>
> stderr: ++ 17:14:12: have_binary:72: which
/usr/pgsql-9.3/bin/pg_ctl
<br>
> stderr: + 17:14:12: have_binary:72: test -x
/usr/pgsql-9.3/bin/pg_ctl
<br>
> stderr: + 17:14:12: check_binary2:1728: return 0
<br>
> stderr: + 17:14:12: pgsql_validate_all:1757:
check_binary2 /usr/pgsql-9.3/bin/psql
<br>
> stderr: + 17:14:12: check_binary2:1724: have_binary
/usr/pgsql-9.3/bin/psql
<br>
> stderr: + 17:14:12: have_binary:68: '[' '' = 1 ']'
<br>
> stderr: ++ 17:14:12: have_binary:71: echo
/usr/pgsql-9.3/bin/psql
<br>
> stderr: ++ 17:14:12: have_binary:71: sed -e 's/ -.*//'
<br>
> stderr: + 17:14:12: have_binary:71: local
bin=/usr/pgsql-9.3/bin/psql
<br>
> stderr: ++ 17:14:12: have_binary:72: which
/usr/pgsql-9.3/bin/psql
<br>
> stderr: + 17:14:12: have_binary:72: test -x
/usr/pgsql-9.3/bin/psql
<br>
> stderr: + 17:14:12: check_binary2:1728: return 0
<br>
> stderr: + 17:14:12: pgsql_validate_all:1761:
check_config /var/lib/pgsql/9.3/data//postgresql.conf
<br>
> stderr: + 17:14:12: check_config:1732: local rc=0
<br>
> stderr: + 17:14:12: check_config:1734: '[' '!' -f
/var/lib/pgsql/9.3/data//postgresql.conf ']'
<br>
> stderr: + 17:14:12: check_config:1744: return 0
<br>
> stderr: + 17:14:12: pgsql_validate_all:1762:
check_config_rc=0
<br>
> stderr: + 17:14:12: pgsql_validate_all:1763: '[' 0 -eq
2 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1764: '[' 0 -eq
0 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1765:
ocf_version_cmp 9.3 9.3
<br>
> stderr: + 17:14:12: ocf_version_cmp:543: ocf_is_ver 9.3
<br>
> stderr: + 17:14:12: ocf_is_ver:513: echo 9.3
<br>
> stderr: + 17:14:12: ocf_is_ver:513: grep
'^[0-9][0-9.-]*[0-9]$'
<br>
> stderr: + 17:14:12: ocf_version_cmp:544: ocf_is_ver 9.3
<br>
> stderr: + 17:14:12: ocf_is_ver:513: grep
'^[0-9][0-9.-]*[0-9]$'
<br>
> stderr: + 17:14:12: ocf_is_ver:513: echo 9.3
<br>
> stderr: + 17:14:12: ocf_version_cmp:545: local v1=9.3
<br>
> stderr: + 17:14:12: ocf_version_cmp:546: local v2=9.3
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:547: ocf_ver_level
9.3
<br>
> stderr: ++ 17:14:12: ocf_ver_level:521: awk '-F[.-]'
'{print NF}'
<br>
> stderr: ++ 17:14:12: ocf_ver_level:521: echo 9.3
<br>
> stderr: + 17:14:12: ocf_version_cmp:547: local
v1_level=2
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:548: ocf_ver_level
9.3
<br>
> stderr: ++ 17:14:12: ocf_ver_level:521: awk '-F[.-]'
'{print NF}'
<br>
> stderr: ++ 17:14:12: ocf_ver_level:521: echo 9.3
<br>
> stderr: + 17:14:12: ocf_version_cmp:548: local
v2_level=2
<br>
> stderr: + 17:14:12: ocf_version_cmp:549: local
level_diff
<br>
> stderr: + 17:14:12: ocf_version_cmp:550: '[' 2 -lt 2
']'
<br>
> stderr: + 17:14:12: ocf_version_cmp:553: '[' 2 -gt 2
']'
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:557: ocf_ver2num
9.3
<br>
> stderr: ++ 17:14:12: ocf_ver2num:516: awk '-F[.-]' '
<br>
> stderr: {for(i=1; i<=NF; i++) s=s*1000+$i; print
s}
<br>
> stderr: '
<br>
> stderr: ++ 17:14:12: ocf_ver2num:516: echo 9.3
<br>
> stderr: + 17:14:12: ocf_version_cmp:557: v1=9003
<br>
> stderr: ++ 17:14:12: ocf_version_cmp:558: ocf_ver2num
9.3
<br>
> stderr: ++ 17:14:12: ocf_ver2num:516: echo 9.3
<br>
> stderr: ++ 17:14:12: ocf_ver2num:516: awk '-F[.-]' '
<br>
> stderr: {for(i=1; i<=NF; i++) s=s*1000+$i; print
s}
<br>
> stderr: '
<br>
> stderr: + 17:14:12: ocf_version_cmp:558: v2=9003
<br>
> stderr: + 17:14:12: ocf_version_cmp:559: '[' 9003 -eq
9003 ']'
<br>
> stderr: + 17:14:12: ocf_version_cmp:560: return 1
<br>
> stderr: + 17:14:12: pgsql_validate_all:1766: '[' 1 -eq
0 ']'
<br>
> stderr: ++ 17:14:12: pgsql_validate_all:1770:
get_pgsql_param unix_socket_directories
<br>
> stderr: ++ 17:14:12: get_pgsql_param:32: local
param_name
<br>
> stderr: ++ 17:14:12: get_pgsql_param:34:
param_name=unix_socket_directories
<br>
> stderr: ++ 17:14:12: get_pgsql_param:39: perl_code='if
(/^\s*unix_socket_directories[\s=]+\s*(.*)$/) {
<br>
> stderr: $dir=$1;
<br>
> stderr: $dir =~ s/\s*\#.*//;
<br>
> stderr: $dir =~ s/^'\''(\S*)'\''/$1/;
<br>
> stderr: print $dir;}'
<br>
> stderr: ++ 17:14:12: get_pgsql_param:41: perl -ne 'if
(/^\s*unix_socket_directories[\s=]+\s*(.*)$/) {
<br>
> stderr: $dir=$1;
<br>
> stderr: $dir =~ s/\s*\#.*//;
<br>
> stderr: $dir =~ s/^'\''(\S*)'\''/$1/;
<br>
> stderr: print $dir;}'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1770:
socket_directories=
<br>
> stderr: + 17:14:12: pgsql_validate_all:1771: '[' -n ''
']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1782: getent
passwd postgres
<br>
> stderr: + 17:14:12: pgsql_validate_all:1783: '[' '!' 0
-eq 0 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1788:
ocf_is_probe
<br>
> stderr: + 17:14:12: ocf_is_probe:490: '[' promote =
monitor -a 0 = 0 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1791: runasowner
'test -w /var/lib/pgsql/9.3/data/'
<br>
> stderr: + 17:14:12: runasowner:467: local quietrun=
<br>
> stderr: + 17:14:12: runasowner:468: local loglevel=-err
<br>
> stderr: + 17:14:12: runasowner:469: local var
<br>
> stderr: + 17:14:12: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:12: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:12: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:12: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:12: runasowner:485: ocf_run -err
runuser postgres -c 'cd /var/lib/pgsql/9.3/data/; test -w
/var/lib/pgsql/9.3/data/'
<br>
> stderr: + 17:14:12: ocf_run:413: local rc
<br>
> stderr: + 17:14:12: ocf_run:414: local output
<br>
> stderr: + 17:14:12: ocf_run:415: local verbose=1
<br>
> stderr: + 17:14:12: ocf_run:416: local loglevel=err
<br>
> stderr: + 17:14:12: ocf_run:417: local var
<br>
> stderr: + 17:14:12: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:12: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:12: ocf_run:426: echo -err
<br>
> stderr: ++ 17:14:12: ocf_run:426: sed -e s/-//g
<br>
> stderr: + 17:14:12: ocf_run:426: loglevel=err
<br>
> stderr: + 17:14:12: ocf_run:427: shift 1
<br>
> stderr: + 17:14:12: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:12: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:12: ocf_run:433: runuser postgres -c
'cd /var/lib/pgsql/9.3/data/; test -w
/var/lib/pgsql/9.3/data/'
<br>
> stderr: + 17:14:12: ocf_run:433: output=
<br>
> stderr: + 17:14:12: ocf_run:434: rc=0
<br>
> stderr: ++ 17:14:12: ocf_run:435: echo
<br>
> stderr: + 17:14:12: ocf_run:435: output=
<br>
> stderr: + 17:14:12: ocf_run:436: '[' 0 -eq 0 ']'
<br>
> stderr: + 17:14:12: ocf_run:437: '[' 1 -a '!' -z '' ']'
<br>
> stderr: + 17:14:12: ocf_run:440: return 0
<br>
> stderr: + 17:14:12: pgsql_validate_all:1797: '[' -n ''
-a '!' -n '' ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1803: '[' '!' -n
'' -a -n '' ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1809:
is_replication
<br>
> stderr: + 17:14:12: is_replication:1287: '[' sync '!='
none -a sync '!=' slave ']'
<br>
> stderr: + 17:14:12: is_replication:1288: return 0
<br>
> stderr: ++ 17:14:12: pgsql_validate_all:1810: printf
'9.3\n9.1'
<br>
> stderr: ++ 17:14:12: pgsql_validate_all:1810: sort -n
<br>
> stderr: ++ 17:14:12: pgsql_validate_all:1810: head -1
<br>
> stderr: + 17:14:12: pgsql_validate_all:1810: '[' 9.1
'!=' 9.1 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1814: '[' '!' -n
10.200.200.233 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1820:
is_replication
<br>
> stderr: + 17:14:12: is_replication:1287: '[' sync '!='
none -a sync '!=' slave ']'
<br>
> stderr: + 17:14:12: is_replication:1288: return 0
<br>
> stderr: + 17:14:12: pgsql_validate_all:1821: ocf_is_ms
<br>
> stderr: + 17:14:12: ocf_is_ms:504: '[' '!' -z 1 ']'
<br>
> stderr: + 17:14:12: ocf_is_ms:504: '[' 1 -gt 0 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1825: '[' '!'
sync = sync -a '!' sync = async ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1829: '[' '!' -n
'pg1 pg2' ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1833: '[' 0 -eq
0 ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1834:
rep_mode_string='include
'\''/var/lib/pgsql/9.3/tmp//rep_mode.conf'\'' # added by pgsql
RA'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1835: '[' sync =
sync ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1836: grep -q
'include '\''/var/lib/pgsql/9.3/tmp//rep_mode.conf'\'' # added
by pgsql RA' /var/lib/pgsql/9.3/data//postgresql.conf
<br>
> stderr: + 17:14:12: pgsql_validate_all:1848: mkdir -p
/var/lib/pgsql/9.3/tmp/
<br>
> stderr: + 17:14:12: pgsql_validate_all:1848: chown
postgres /var/lib/pgsql/9.3/tmp/
<br>
> stderr: + 17:14:12: pgsql_validate_all:1848: chmod 700
/var/lib/pgsql/9.3/tmp/
<br>
> stderr: + 17:14:12: pgsql_validate_all:1854: '[' sync =
slave ']'
<br>
> stderr: + 17:14:12: pgsql_validate_all:1861:
use_replication_slot
<br>
> stderr: + 17:14:12: use_replication_slot:1294: '[' -n
'' ']'
<br>
> stderr: + 17:14:12: use_replication_slot:1298: return 1
<br>
> stderr: + 17:14:12: pgsql_validate_all:1869: return 0
<br>
> stderr: + 17:14:12: 1985: rc=0
<br>
> stderr: + 17:14:12: 1987: '[' promote = validate-all
']'
<br>
> stderr: + 17:14:12: 1989: '[' 0 -ne 0 ']'
<br>
> stderr: ++ 17:14:12: 2002: id -u -n
<br>
> stderr: + 17:14:12: 2002: US=root
<br>
> stderr: + 17:14:12: 2004: '[' root '!=' root -a root
'!=' postgres ']'
<br>
> stderr: + 17:14:12: 2011: '[' -n '' ']'
<br>
> stderr: + 17:14:12: 2016: psql_options='-p 5432 -U
postgres template1'
<br>
> stderr: + 17:14:12: 2019: '[' -n '' ']'
<br>
> stderr: + 17:14:12: 2022: '[' -n '' ']'
<br>
> stderr: + 17:14:12: 2027: '[' -n 5432 ']'
<br>
> stderr: + 17:14:12: 2028: export PGPORT=5432
<br>
> stderr: + 17:14:12: 2028: PGPORT=5432
<br>
> stderr: + 17:14:12: 2031: '[' -n /usr/lib ']'
<br>
> stderr: + 17:14:12: 2032: '[' -n '' ']'
<br>
> stderr: + 17:14:12: 2035: export
LD_LIBRARY_PATH=/usr/lib
<br>
> stderr: + 17:14:12: 2035: LD_LIBRARY_PATH=/usr/lib
<br>
> stderr: + 17:14:12: 2041: case "$1" in
<br>
> stderr: + 17:14:12: 2057: pgsql_promote
<br>
> stderr: + 17:14:12: pgsql_promote:665: local target
<br>
> stderr: + 17:14:12: pgsql_promote:666: local rc
<br>
> stderr: + 17:14:12: pgsql_promote:668: is_replication
<br>
> stderr: + 17:14:12: is_replication:1287: '[' sync '!='
none -a sync '!=' slave ']'
<br>
> stderr: + 17:14:12: is_replication:1288: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:672: rm -f
'/var/lib/pgsql/9.3/tmp//xlog_note.*'
<br>
> stderr: + 17:14:12: pgsql_promote:674: for target in
'$NODE_LIST'
<br>
> stderr: + 17:14:12: pgsql_promote:675: '[' pg1 = pm1
']'
<br>
> stderr: + 17:14:12: pgsql_promote:676:
change_data_status pg1 DISCONNECT
<br>
> stderr: + 17:14:12: change_data_status:1569: local
output
<br>
> stderr: + 17:14:12: change_data_status:1571: node_exist
pg1
<br>
> stderr: + 17:14:12: node_exist:1720: print_crm_mon
<br>
> stderr: + 17:14:12: node_exist:1720: tr '[A-Z]' '[a-z]'
<br>
> stderr: + 17:14:12: node_exist:1720: grep -q '^node
pg1'
<br>
> stderr: + 17:14:12: print_crm_mon:1924: '[' -z '' ']'
<br>
> stderr: ++ 17:14:12: print_crm_mon:1925:
exec_with_retry 0 crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1689: local
count=86400
<br>
> stderr: ++ 17:14:12: exec_with_retry:1690: local output
<br>
> stderr: ++ 17:14:12: exec_with_retry:1691: local rc
<br>
> stderr: ++ 17:14:12: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1696: shift
<br>
> stderr: ++ 17:14:12: exec_with_retry:1698: '[' 86400
-gt 0 ']'
<br>
> stderr: +++ 17:14:12: exec_with_retry:1699: crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1699: output='Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1700: rc=0
<br>
> stderr: ++ 17:14:12: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1706: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:12: print_crm_mon:1925:
CRM_MON_OUTPUT='Last updated: Mon Oct 12 17:14:12 2015 Last
change: Mon Oct 12 16:07:56 2015 by root via crm_attribute on
pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: + 17:14:12: print_crm_mon:1927: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql):
Slave\n'
<br>
> stderr: + 17:14:12: change_data_status:1572: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:677:
change_master_score pg1 -INFINITY
<br>
> stderr: + 17:14:12: change_master_score:1604: local
instance
<br>
> stderr: + 17:14:12: change_master_score:1606:
is_node_online pg1
<br>
> stderr: + 17:14:12: is_node_online:1716: print_crm_mon
<br>
> stderr: + 17:14:12: is_node_online:1716: tr '[A-Z]'
'[a-z]'
<br>
> stderr: + 17:14:12: is_node_online:1716: grep -e '^node
pg1 ' -e '^node pg1:'
<br>
> stderr: + 17:14:12: is_node_online:1716: grep -q -v
offline
<br>
> stderr: + 17:14:12: print_crm_mon:1924: '[' -z '' ']'
<br>
> stderr: ++ 17:14:12: print_crm_mon:1925:
exec_with_retry 0 crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1689: local
count=86400
<br>
> stderr: ++ 17:14:12: exec_with_retry:1690: local output
<br>
> stderr: ++ 17:14:12: exec_with_retry:1691: local rc
<br>
> stderr: ++ 17:14:12: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1696: shift
<br>
> stderr: ++ 17:14:12: exec_with_retry:1698: '[' 86400
-gt 0 ']'
<br>
> stderr: +++ 17:14:12: exec_with_retry:1699: crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1699: output='Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1700: rc=0
<br>
> stderr: ++ 17:14:12: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1706: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:12: print_crm_mon:1925:
CRM_MON_OUTPUT='Last updated: Mon Oct 12 17:14:12 2015 Last
change: Mon Oct 12 16:07:56 2015 by root via crm_attribute on
pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: + 17:14:12: print_crm_mon:1927: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql):
Slave\n'
<br>
> stderr: + 17:14:12: change_master_score:1607: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:674: for target in
'$NODE_LIST'
<br>
> stderr: + 17:14:12: pgsql_promote:675: '[' pg2 = pm1
']'
<br>
> stderr: + 17:14:12: pgsql_promote:676:
change_data_status pg2 DISCONNECT
<br>
> stderr: + 17:14:12: change_data_status:1569: local
output
<br>
> stderr: + 17:14:12: change_data_status:1571: node_exist
pg2
<br>
> stderr: + 17:14:12: node_exist:1720: print_crm_mon
<br>
> stderr: + 17:14:12: node_exist:1720: tr '[A-Z]' '[a-z]'
<br>
> stderr: + 17:14:12: node_exist:1720: grep -q '^node
pg2'
<br>
> stderr: + 17:14:12: print_crm_mon:1924: '[' -z '' ']'
<br>
> stderr: ++ 17:14:12: print_crm_mon:1925:
exec_with_retry 0 crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1689: local
count=86400
<br>
> stderr: ++ 17:14:12: exec_with_retry:1690: local output
<br>
> stderr: ++ 17:14:12: exec_with_retry:1691: local rc
<br>
> stderr: ++ 17:14:12: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1696: shift
<br>
> stderr: ++ 17:14:12: exec_with_retry:1698: '[' 86400
-gt 0 ']'
<br>
> stderr: +++ 17:14:12: exec_with_retry:1699: crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1699: output='Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1700: rc=0
<br>
> stderr: ++ 17:14:12: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1706: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:12: print_crm_mon:1925:
CRM_MON_OUTPUT='Last updated: Mon Oct 12 17:14:12 2015 Last
change: Mon Oct 12 16:07:56 2015 by root via crm_attribute on
pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: + 17:14:12: print_crm_mon:1927: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql):
Slave\n'
<br>
> stderr: + 17:14:12: change_data_status:1572: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:677:
change_master_score pg2 -INFINITY
<br>
> stderr: + 17:14:12: change_master_score:1604: local
instance
<br>
> stderr: + 17:14:12: change_master_score:1606:
is_node_online pg2
<br>
> stderr: + 17:14:12: is_node_online:1716: grep -q -v
offline
<br>
> stderr: + 17:14:12: is_node_online:1716: print_crm_mon
<br>
> stderr: + 17:14:12: is_node_online:1716: tr '[A-Z]'
'[a-z]'
<br>
> stderr: + 17:14:12: is_node_online:1716: grep -e '^node
pg2 ' -e '^node pg2:'
<br>
> stderr: + 17:14:12: print_crm_mon:1924: '[' -z '' ']'
<br>
> stderr: ++ 17:14:12: print_crm_mon:1925:
exec_with_retry 0 crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1689: local
count=86400
<br>
> stderr: ++ 17:14:12: exec_with_retry:1690: local output
<br>
> stderr: ++ 17:14:12: exec_with_retry:1691: local rc
<br>
> stderr: ++ 17:14:12: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1696: shift
<br>
> stderr: ++ 17:14:12: exec_with_retry:1698: '[' 86400
-gt 0 ']'
<br>
> stderr: +++ 17:14:12: exec_with_retry:1699: crm_mon -n1
<br>
> stderr: ++ 17:14:12: exec_with_retry:1699: output='Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1700: rc=0
<br>
> stderr: ++ 17:14:12: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1706: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:12: print_crm_mon:1925:
CRM_MON_OUTPUT='Last updated: Mon Oct 12 17:14:12 2015 Last
change: Mon Oct 12 16:07:56 2015 by root via crm_attribute on
pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: + 17:14:12: print_crm_mon:1927: printf 'Last
updated: Mon Oct 12 17:14:12 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql):
Slave\n'
<br>
> stderr: + 17:14:12: change_master_score:1607: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:680: ocf_log info
'Creating /var/lib/pgsql/9.3/tmp//PGSQL.lock.'
<br>
> stderr: + 17:14:12: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:12: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:12: ocf_log:326: shift
<br>
> stderr: + 17:14:12: ocf_log:327: __OCF_MSG='Creating
/var/lib/pgsql/9.3/tmp//PGSQL.lock.'
<br>
> stderr: + 17:14:12: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:12: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:12: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:12: ocf_log:341: ha_log 'INFO: Creating
/var/lib/pgsql/9.3/tmp//PGSQL.lock.'
<br>
> stderr: + 17:14:12: ha_log:253: __ha_log 'INFO:
Creating /var/lib/pgsql/9.3/tmp//PGSQL.lock.'
<br>
> stderr: + 17:14:12: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:12: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:12: __ha_log:188: '[' 'xINFO: Creating
/var/lib/pgsql/9.3/tmp//PGSQL.lock.' = x--ignore-stderr ']'
<br>
> stderr: + 17:14:12: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:12: __ha_log:192: tty
<br>
> stderr: + 17:14:12: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:12: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:12: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:12: __ha_log:202: echo 'INFO: Creating
/var/lib/pgsql/9.3/tmp//PGSQL.lock.'
<br>
> stderr: INFO: Creating
/var/lib/pgsql/9.3/tmp//PGSQL.lock.
<br>
> stderr: + 17:14:12: __ha_log:204: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:681: touch
/var/lib/pgsql/9.3/tmp//PGSQL.lock
<br>
> stderr: + 17:14:12: pgsql_promote:682:
show_master_baseline
<br>
> stderr: + 17:14:12: show_master_baseline:1438: local rc
<br>
> stderr: + 17:14:12: show_master_baseline:1439: local
location
<br>
> stderr: ++ 17:14:12: show_master_baseline:1441:
get_my_location
<br>
> stderr: ++ 17:14:12: get_my_location:1389: local rc
<br>
> stderr: ++ 17:14:12: get_my_location:1390: local output
<br>
> stderr: ++ 17:14:12: get_my_location:1391: local
replay_loc
<br>
> stderr: ++ 17:14:12: get_my_location:1392: local
receive_loc
<br>
> stderr: ++ 17:14:12: get_my_location:1393: local
output1
<br>
> stderr: ++ 17:14:12: get_my_location:1394: local
output2
<br>
> stderr: ++ 17:14:12: get_my_location:1395: local log1
<br>
> stderr: ++ 17:14:12: get_my_location:1396: local log2
<br>
> stderr: ++ 17:14:12: get_my_location:1397: local
newer_location
<br>
> stderr: +++ 17:14:12: get_my_location:1399: exec_sql ''
<br>
> stderr: +++ 17:14:12: exec_sql:518: local sql=
<br>
> stderr: +++ 17:14:12: exec_sql:519: local output
<br>
> stderr: +++ 17:14:12: exec_sql:520: local rc
<br>
> stderr: ++++ 17:14:12: exec_sql:524: runuser postgres
-c 'cd /var/lib/pgsql/9.3/data/; /usr/pgsql-9.3/bin/psql -p
5432 -U postgres template1 -U postgres -Atc
""'
<br>
> stderr: +++ 17:14:12: exec_sql:524: output=
<br>
> stderr: +++ 17:14:12: exec_sql:525: rc=0
<br>
> stderr: +++ 17:14:12: exec_sql:527: echo
<br>
> stderr: +++ 17:14:12: exec_sql:528: return 0
<br>
> stderr: ++ 17:14:12: get_my_location:1399: output=
<br>
> stderr: ++ 17:14:12: get_my_location:1400: rc=0
<br>
> stderr: ++ 17:14:12: get_my_location:1402: '[' 0 -ne 0
']'
<br>
> stderr: +++ 17:14:12: get_my_location:1406: cut -d '|'
-f 1
<br>
> stderr: +++ 17:14:12: get_my_location:1406: echo
<br>
> stderr: ++ 17:14:12: get_my_location:1406: replay_loc=
<br>
> stderr: +++ 17:14:12: get_my_location:1407: cut -d '|'
-f 2
<br>
> stderr: +++ 17:14:12: get_my_location:1407: echo
<br>
> stderr: ++ 17:14:12: get_my_location:1407: receive_loc=
<br>
> stderr: +++ 17:14:12: get_my_location:1409: echo ''
<br>
> stderr: +++ 17:14:12: get_my_location:1409: cut -d / -f
1
<br>
> stderr: ++ 17:14:12: get_my_location:1409: output1=
<br>
> stderr: +++ 17:14:12: get_my_location:1410: echo ''
<br>
> stderr: +++ 17:14:12: get_my_location:1410: cut -d / -f
2
<br>
> stderr: ++ 17:14:12: get_my_location:1410: output2=
<br>
> stderr: +++ 17:14:12: get_my_location:1411: printf
'%08s\n'
<br>
> stderr: +++ 17:14:12: get_my_location:1411: sed 's/
/0/g'
<br>
> stderr: ++ 17:14:12: get_my_location:1411:
log1=00000000
<br>
> stderr: +++ 17:14:12: get_my_location:1412: printf
'%08s\n'
<br>
> stderr: +++ 17:14:12: get_my_location:1412: sed 's/
/0/g'
<br>
> stderr: ++ 17:14:12: get_my_location:1412:
log2=00000000
<br>
> stderr: ++ 17:14:12: get_my_location:1413:
replay_loc=0000000000000000
<br>
> stderr: +++ 17:14:12: get_my_location:1415: cut -d / -f
1
<br>
> stderr: +++ 17:14:12: get_my_location:1415: echo ''
<br>
> stderr: ++ 17:14:12: get_my_location:1415: output1=
<br>
> stderr: +++ 17:14:12: get_my_location:1416: cut -d / -f
2
<br>
> stderr: +++ 17:14:12: get_my_location:1416: echo ''
<br>
> stderr: ++ 17:14:12: get_my_location:1416: output2=
<br>
> stderr: +++ 17:14:12: get_my_location:1417: sed 's/
/0/g'
<br>
> stderr: +++ 17:14:12: get_my_location:1417: printf
'%08s\n'
<br>
> stderr: ++ 17:14:12: get_my_location:1417:
log1=00000000
<br>
> stderr: +++ 17:14:12: get_my_location:1418: sed 's/
/0/g'
<br>
> stderr: +++ 17:14:12: get_my_location:1418: printf
'%08s\n'
<br>
> stderr: ++ 17:14:12: get_my_location:1418:
log2=00000000
<br>
> stderr: ++ 17:14:12: get_my_location:1419:
receive_loc=0000000000000000
<br>
> stderr: +++ 17:14:12: get_my_location:1421: printf
'0000000000000000\n0000000000000000'
<br>
> stderr: +++ 17:14:12: get_my_location:1421: sort -r
<br>
> stderr: +++ 17:14:12: get_my_location:1421: head -1
<br>
> stderr: ++ 17:14:12: get_my_location:1421:
newer_location=0000000000000000
<br>
> stderr: ++ 17:14:12: get_my_location:1422: echo
0000000000000000
<br>
> stderr: ++ 17:14:12: get_my_location:1423: return 0
<br>
> stderr: + 17:14:12: show_master_baseline:1441:
location=0000000000000000
<br>
> stderr: + 17:14:12: show_master_baseline:1442: ocf_log
info 'My master baseline : 0000000000000000.'
<br>
> stderr: + 17:14:12: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:12: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:12: ocf_log:326: shift
<br>
> stderr: + 17:14:12: ocf_log:327: __OCF_MSG='My master
baseline : 0000000000000000.'
<br>
> stderr: + 17:14:12: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:12: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:12: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:12: ocf_log:341: ha_log 'INFO: My
master baseline : 0000000000000000.'
<br>
> stderr: + 17:14:12: ha_log:253: __ha_log 'INFO: My
master baseline : 0000000000000000.'
<br>
> stderr: + 17:14:12: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:12: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:12: __ha_log:188: '[' 'xINFO: My master
baseline : 0000000000000000.' = x--ignore-stderr ']'
<br>
> stderr: + 17:14:12: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:12: __ha_log:192: tty
<br>
> stderr: + 17:14:12: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:12: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:12: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:12: __ha_log:202: echo 'INFO: My master
baseline : 0000000000000000.'
<br>
> stderr: INFO: My master baseline : 0000000000000000.
<br>
> stderr: + 17:14:12: __ha_log:204: return 0
<br>
> stderr: + 17:14:12: show_master_baseline:1443:
exec_with_retry 0 /usr/sbin/crm_attribute -l reboot -N pm1 -n
pgsql-master-baseline -v 0000000000000000
<br>
> stderr: + 17:14:12: exec_with_retry:1689: local
count=86400
<br>
> stderr: + 17:14:12: exec_with_retry:1690: local output
<br>
> stderr: + 17:14:12: exec_with_retry:1691: local rc
<br>
> stderr: + 17:14:12: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: + 17:14:12: exec_with_retry:1696: shift
<br>
> stderr: + 17:14:12: exec_with_retry:1698: '[' 86400 -gt
0 ']'
<br>
> stderr: ++ 17:14:12: exec_with_retry:1699:
/usr/sbin/crm_attribute -l reboot -N pm1 -n
pgsql-master-baseline -v 0000000000000000
<br>
> stderr: + 17:14:12: exec_with_retry:1699: output=
<br>
> stderr: + 17:14:12: exec_with_retry:1700: rc=0
<br>
> stderr: + 17:14:12: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: + 17:14:12: exec_with_retry:1706: printf ''
<br>
> stderr: + 17:14:12: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:684: ocf_is_true true
<br>
> stderr: + 17:14:12: ocf_is_true:101: case "$1" in
<br>
> stderr: + 17:14:12: ocf_is_true:102: true
<br>
> stderr: + 17:14:12: pgsql_promote:685: ocf_log info
'Restarting PostgreSQL instead of promote.'
<br>
> stderr: + 17:14:12: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:12: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:12: ocf_log:326: shift
<br>
> stderr: + 17:14:12: ocf_log:327: __OCF_MSG='Restarting
PostgreSQL instead of promote.'
<br>
> stderr: + 17:14:12: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:12: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:12: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:12: ocf_log:341: ha_log 'INFO:
Restarting PostgreSQL instead of promote.'
<br>
> stderr: + 17:14:12: ha_log:253: __ha_log 'INFO:
Restarting PostgreSQL instead of promote.'
<br>
> stderr: + 17:14:12: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:12: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:12: __ha_log:188: '[' 'xINFO:
Restarting PostgreSQL instead of promote.' = x--ignore-stderr
']'
<br>
> stderr: + 17:14:12: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:12: __ha_log:192: tty
<br>
> stderr: + 17:14:12: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:12: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:12: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:12: __ha_log:202: echo 'INFO:
Restarting PostgreSQL instead of promote.'
<br>
> stderr: INFO: Restarting PostgreSQL instead of promote.
<br>
> stderr: + 17:14:12: __ha_log:204: return 0
<br>
> stderr: + 17:14:12: pgsql_promote:687: pgsql_real_stop
slave
<br>
> stderr: + 17:14:12: pgsql_real_stop:758: local rc
<br>
> stderr: + 17:14:12: pgsql_real_stop:759: local count
<br>
> stderr: + 17:14:12: pgsql_real_stop:760: local
stop_escalate
<br>
> stderr: + 17:14:12: pgsql_real_stop:762: ocf_is_true
false
<br>
> stderr: + 17:14:12: ocf_is_true:101: case "$1" in
<br>
> stderr: + 17:14:12: ocf_is_true:103: false
<br>
> stderr: + 17:14:12: pgsql_real_stop:766: pgsql_status
<br>
> stderr: + 17:14:12: pgsql_status:866: '[' -f
/var/lib/pgsql/9.3/data//postmaster.pid ']'
<br>
> stderr: ++ 17:14:12: pgsql_status:868: head -n 1
/var/lib/pgsql/9.3/data//postmaster.pid
<br>
> stderr: + 17:14:12: pgsql_status:868: PID=6046
<br>
> stderr: + 17:14:12: pgsql_status:869: runasowner 'kill
-s 0 6046 >/dev/null 2>&1'
<br>
> stderr: + 17:14:12: runasowner:467: local quietrun=
<br>
> stderr: + 17:14:12: runasowner:468: local loglevel=-err
<br>
> stderr: + 17:14:12: runasowner:469: local var
<br>
> stderr: + 17:14:12: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:12: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:12: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:12: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:12: runasowner:485: ocf_run -err
runuser postgres -c 'cd /var/lib/pgsql/9.3/data/; kill -s 0
6046 >/dev/null 2>&1'
<br>
> stderr: + 17:14:12: ocf_run:413: local rc
<br>
> stderr: + 17:14:12: ocf_run:414: local output
<br>
> stderr: + 17:14:12: ocf_run:415: local verbose=1
<br>
> stderr: + 17:14:12: ocf_run:416: local loglevel=err
<br>
> stderr: + 17:14:12: ocf_run:417: local var
<br>
> stderr: + 17:14:12: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:12: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:12: ocf_run:426: echo -err
<br>
> stderr: ++ 17:14:12: ocf_run:426: sed -e s/-//g
<br>
> stderr: + 17:14:12: ocf_run:426: loglevel=err
<br>
> stderr: + 17:14:12: ocf_run:427: shift 1
<br>
> stderr: + 17:14:12: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:12: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:12: ocf_run:433: runuser postgres -c
'cd /var/lib/pgsql/9.3/data/; kill -s 0 6046 >/dev/null
2>&1'
<br>
> stderr: + 17:14:12: ocf_run:433: output=
<br>
> stderr: + 17:14:12: ocf_run:434: rc=0
<br>
> stderr: ++ 17:14:12: ocf_run:435: echo
<br>
> stderr: + 17:14:12: ocf_run:435: output=
<br>
> stderr: + 17:14:12: ocf_run:436: '[' 0 -eq 0 ']'
<br>
> stderr: + 17:14:12: ocf_run:437: '[' 1 -a '!' -z '' ']'
<br>
> stderr: + 17:14:12: ocf_run:440: return 0
<br>
> stderr: + 17:14:12: pgsql_status:870: return 0
<br>
> stderr: + 17:14:12: pgsql_real_stop:772:
stop_escalate=30
<br>
> stderr: + 17:14:12: pgsql_real_stop:773: '[' slave =
slave ']'
<br>
> stderr: + 17:14:12: pgsql_real_stop:774:
stop_escalate=30
<br>
> stderr: + 17:14:12: pgsql_real_stop:778: '[' 30 -gt 0
']'
<br>
> stderr: + 17:14:12: pgsql_real_stop:779: runasowner
'/usr/pgsql-9.3/bin/pg_ctl -D /var/lib/pgsql/9.3/data/ stop -m
fast'
<br>
> stderr: + 17:14:12: runasowner:467: local quietrun=
<br>
> stderr: + 17:14:12: runasowner:468: local loglevel=-err
<br>
> stderr: + 17:14:12: runasowner:469: local var
<br>
> stderr: + 17:14:12: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:12: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:12: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:12: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:12: runasowner:485: ocf_run -err
runuser postgres -c 'cd /var/lib/pgsql/9.3/data/;
/usr/pgsql-9.3/bin/pg_ctl -D /var/lib/pgsql/9.3/data/ stop -m
fast'
<br>
> stderr: + 17:14:12: ocf_run:413: local rc
<br>
> stderr: + 17:14:12: ocf_run:414: local output
<br>
> stderr: + 17:14:12: ocf_run:415: local verbose=1
<br>
> stderr: + 17:14:12: ocf_run:416: local loglevel=err
<br>
> stderr: + 17:14:12: ocf_run:417: local var
<br>
> stderr: + 17:14:12: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:12: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:12: ocf_run:426: echo -err
<br>
> stderr: ++ 17:14:12: ocf_run:426: sed -e s/-//g
<br>
> stderr: + 17:14:12: ocf_run:426: loglevel=err
<br>
> stderr: + 17:14:12: ocf_run:427: shift 1
<br>
> stderr: + 17:14:12: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:12: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:12: ocf_run:433: runuser postgres -c
'cd /var/lib/pgsql/9.3/data/; /usr/pgsql-9.3/bin/pg_ctl -D
/var/lib/pgsql/9.3/data/ stop -m fast'
<br>
> stderr: + 17:14:13: ocf_run:433: output='waiting for
server to shut down.... done
<br>
> stderr: server stopped'
<br>
> stderr: + 17:14:13: ocf_run:434: rc=0
<br>
> stderr: ++ 17:14:13: ocf_run:435: echo waiting for
server to shut down.... done server stopped
<br>
> stderr: + 17:14:13: ocf_run:435: output='waiting for
server to shut down.... done server stopped'
<br>
> stderr: + 17:14:13: ocf_run:436: '[' 0 -eq 0 ']'
<br>
> stderr: + 17:14:13: ocf_run:437: '[' 1 -a '!' -z
'waiting for server to shut down.... done server stopped' ']'
<br>
> stderr: + 17:14:13: ocf_run:438: ocf_log info 'waiting
for server to shut down.... done server stopped'
<br>
> stderr: + 17:14:13: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:13: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:13: ocf_log:326: shift
<br>
> stderr: + 17:14:13: ocf_log:327: __OCF_MSG='waiting for
server to shut down.... done server stopped'
<br>
> stderr: + 17:14:13: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:13: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:13: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:13: ocf_log:341: ha_log 'INFO: waiting
for server to shut down.... done server stopped'
<br>
> stderr: + 17:14:13: ha_log:253: __ha_log 'INFO: waiting
for server to shut down.... done server stopped'
<br>
> stderr: + 17:14:13: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:13: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:13: __ha_log:188: '[' 'xINFO: waiting
for server to shut down.... done server stopped' =
x--ignore-stderr ']'
<br>
> stderr: + 17:14:13: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:13: __ha_log:192: tty
<br>
> stderr: + 17:14:13: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:13: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:13: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:13: __ha_log:202: echo 'INFO: waiting
for server to shut down.... done server stopped'
<br>
> stderr: INFO: waiting for server to shut down.... done
server stopped
<br>
> stderr: + 17:14:13: __ha_log:204: return 0
<br>
> stderr: + 17:14:13: ocf_run:440: return 0
<br>
> stderr: + 17:14:13: pgsql_real_stop:783: count=0
<br>
> stderr: + 17:14:13: pgsql_real_stop:784: '[' 0 -lt 30
']'
<br>
> stderr: + 17:14:13: pgsql_real_stop:786: pgsql_status
<br>
> stderr: + 17:14:13: pgsql_status:866: '[' -f
/var/lib/pgsql/9.3/data//postmaster.pid ']'
<br>
> stderr: + 17:14:13: pgsql_status:874: false
<br>
> stderr: + 17:14:13: pgsql_real_stop:789: break
<br>
> stderr: + 17:14:13: pgsql_real_stop:795: pgsql_status
<br>
> stderr: + 17:14:13: pgsql_status:866: '[' -f
/var/lib/pgsql/9.3/data//postmaster.pid ']'
<br>
> stderr: + 17:14:13: pgsql_status:874: false
<br>
> stderr: + 17:14:13: pgsql_real_stop:802: :
<br>
> stderr: + 17:14:13: pgsql_real_stop:804:
pgsql_real_monitor
<br>
> stderr: + 17:14:13: pgsql_real_monitor:905: local
loglevel
<br>
> stderr: + 17:14:13: pgsql_real_monitor:906: local rc
<br>
> stderr: + 17:14:13: pgsql_real_monitor:907: local
output
<br>
> stderr: + 17:14:13: pgsql_real_monitor:910:
loglevel=err
<br>
> stderr: + 17:14:13: pgsql_real_monitor:912:
pgsql_status
<br>
> stderr: + 17:14:13: pgsql_status:866: '[' -f
/var/lib/pgsql/9.3/data//postmaster.pid ']'
<br>
> stderr: + 17:14:13: pgsql_status:874: false
<br>
> stderr: + 17:14:13: pgsql_real_monitor:914: ocf_log
info 'PostgreSQL is down'
<br>
> stderr: + 17:14:13: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:13: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:13: ocf_log:326: shift
<br>
> stderr: + 17:14:13: ocf_log:327: __OCF_MSG='PostgreSQL
is down'
<br>
> stderr: + 17:14:13: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:13: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:13: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:13: ocf_log:341: ha_log 'INFO:
PostgreSQL is down'
<br>
> stderr: + 17:14:13: ha_log:253: __ha_log 'INFO:
PostgreSQL is down'
<br>
> stderr: + 17:14:13: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:13: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:13: __ha_log:188: '[' 'xINFO:
PostgreSQL is down' = x--ignore-stderr ']'
<br>
> stderr: + 17:14:13: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:13: __ha_log:192: tty
<br>
> stderr: + 17:14:13: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:13: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:13: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:13: __ha_log:202: echo 'INFO:
PostgreSQL is down'
<br>
> stderr: INFO: PostgreSQL is down
<br>
> stderr: + 17:14:13: __ha_log:204: return 0
<br>
> stderr: + 17:14:13: pgsql_real_monitor:915: return 7
<br>
> stderr: + 17:14:13: pgsql_real_stop:805: rc=7
<br>
> stderr: + 17:14:13: pgsql_real_stop:806: '[' 7 -eq 7
']'
<br>
> stderr: + 17:14:13: pgsql_real_stop:808: break
<br>
> stderr: + 17:14:13: pgsql_real_stop:815: rm -f
/var/lib/pgsql/9.3/data//postmaster.pid
<br>
> stderr: + 17:14:13: pgsql_real_stop:817: '[' slave =
master -a '' = ' ' ']'
<br>
> stderr: + 17:14:13: pgsql_real_stop:821: return 0
<br>
> stderr: + 17:14:13: pgsql_promote:688: rm -f
/var/lib/pgsql/9.3/data//recovery.conf
<br>
> stderr: + 17:14:13: pgsql_promote:689: pgsql_real_start
<br>
> stderr: + 17:14:13: pgsql_real_start:534: local
pgctl_options
<br>
> stderr: + 17:14:13: pgsql_real_start:535: local
postgres_options
<br>
> stderr: + 17:14:13: pgsql_real_start:536: local rc
<br>
> stderr: + 17:14:13: pgsql_real_start:538: pgsql_status
<br>
> stderr: + 17:14:13: pgsql_status:866: '[' -f
/var/lib/pgsql/9.3/data//postmaster.pid ']'
<br>
> stderr: + 17:14:13: pgsql_status:874: false
<br>
> stderr: + 17:14:13: pgsql_real_start:548: rm -f
/var/lib/pgsql/9.3/data//postmaster.pid
<br>
> stderr: + 17:14:13: pgsql_real_start:551: '[' -f
/var/lib/pgsql/9.3/data//backup_label ']'
<br>
> stderr: + 17:14:13: pgsql_real_start:557:
check_log_file /dev/null
<br>
> stderr: + 17:14:13: check_log_<a class="moz-txt-link-freetext" href="file:1878">file:1878</a>: '[' '!' -f
/dev/null ']'
<br>
> stderr: + 17:14:13: check_log_<a class="moz-txt-link-freetext" href="file:1880">file:1880</a>: touch
/dev/null
<br>
> stderr: ++ 17:14:13: check_log_<a class="moz-txt-link-freetext" href="file:1881">file:1881</a>: getent passwd
postgres
<br>
> stderr: ++ 17:14:13: check_log_<a class="moz-txt-link-freetext" href="file:1881">file:1881</a>: cut -d : -f 4
<br>
> stderr: + 17:14:13: check_log_<a class="moz-txt-link-freetext" href="file:1881">file:1881</a>: chown
postgres:26 /dev/null
<br>
> stderr: + 17:14:13: check_log_<a class="moz-txt-link-freetext" href="file:1885">file:1885</a>: runasowner
'test -w /dev/null'
<br>
> stderr: + 17:14:13: runasowner:467: local quietrun=
<br>
> stderr: + 17:14:13: runasowner:468: local loglevel=-err
<br>
> stderr: + 17:14:13: runasowner:469: local var
<br>
> stderr: + 17:14:13: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:13: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:13: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:13: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:13: runasowner:485: ocf_run -err
runuser postgres -c 'cd /var/lib/pgsql/9.3/data/; test -w
/dev/null'
<br>
> stderr: + 17:14:13: ocf_run:413: local rc
<br>
> stderr: + 17:14:13: ocf_run:414: local output
<br>
> stderr: + 17:14:13: ocf_run:415: local verbose=1
<br>
> stderr: + 17:14:13: ocf_run:416: local loglevel=err
<br>
> stderr: + 17:14:13: ocf_run:417: local var
<br>
> stderr: + 17:14:13: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:13: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:13: ocf_run:426: echo -err
<br>
> stderr: ++ 17:14:13: ocf_run:426: sed -e s/-//g
<br>
> stderr: + 17:14:13: ocf_run:426: loglevel=err
<br>
> stderr: + 17:14:13: ocf_run:427: shift 1
<br>
> stderr: + 17:14:13: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:13: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:13: ocf_run:433: runuser postgres -c
'cd /var/lib/pgsql/9.3/data/; test -w /dev/null'
<br>
> stderr: + 17:14:13: ocf_run:433: output=
<br>
> stderr: + 17:14:13: ocf_run:434: rc=0
<br>
> stderr: ++ 17:14:13: ocf_run:435: echo
<br>
> stderr: + 17:14:13: ocf_run:435: output=
<br>
> stderr: + 17:14:13: ocf_run:436: '[' 0 -eq 0 ']'
<br>
> stderr: + 17:14:13: ocf_run:437: '[' 1 -a '!' -z '' ']'
<br>
> stderr: + 17:14:13: ocf_run:440: return 0
<br>
> stderr: + 17:14:13: check_log_<a class="moz-txt-link-freetext" href="file:1890">file:1890</a>: return 0
<br>
> stderr: + 17:14:13: pgsql_real_start:564: '[' -n '' ']'
<br>
> stderr: + 17:14:13: pgsql_real_start:569: '[' sync =
slave ']'
<br>
> stderr: + 17:14:13: pgsql_real_start:575:
pgctl_options=' -D /var/lib/pgsql/9.3/data/ -l /dev/null'
<br>
> stderr: + 17:14:13: pgsql_real_start:578:
postgres_options='-c
config_file=/var/lib/pgsql/9.3/data//postgresql.conf'
<br>
> stderr: + 17:14:13: pgsql_real_start:580: '[' -n '' ']'
<br>
> stderr: + 17:14:13: pgsql_real_start:583: '[' -n '' ']'
<br>
> stderr: + 17:14:13: pgsql_real_start:588:
pgctl_options=' -D /var/lib/pgsql/9.3/data/ -l /dev/null -o
'\''-c
config_file=/var/lib/pgsql/9.3/data//postgresql.conf'\'''
<br>
> stderr: + 17:14:13: pgsql_real_start:591: runasowner
'unset PGUSER; unset PGPASSWORD; /usr/pgsql-9.3/bin/pg_ctl -D
/var/lib/pgsql/9.3/data/ -l /dev/null -o '\''-c
config_file=/var/lib/pgsql/9.3/data//postgresql.conf'\''
start'
<br>
> stderr: + 17:14:13: runasowner:467: local quietrun=
<br>
> stderr: + 17:14:13: runasowner:468: local loglevel=-err
<br>
> stderr: + 17:14:13: runasowner:469: local var
<br>
> stderr: + 17:14:13: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:13: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:13: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:13: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:13: runasowner:485: ocf_run -err
runuser postgres -c 'cd /var/lib/pgsql/9.3/data/; unset
PGUSER; unset PGPASSWORD; /usr/pgsql-9.3/bin/pg_ctl -D
/var/lib/pgsql/9.3/data/ -l /dev/null -o '\''-c
config_file=/var/lib/pgsql/9.3/data//postgresql.conf'\''
start'
<br>
> stderr: + 17:14:13: ocf_run:413: local rc
<br>
> stderr: + 17:14:13: ocf_run:414: local output
<br>
> stderr: + 17:14:13: ocf_run:415: local verbose=1
<br>
> stderr: + 17:14:13: ocf_run:416: local loglevel=err
<br>
> stderr: + 17:14:13: ocf_run:417: local var
<br>
> stderr: + 17:14:13: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:13: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:13: ocf_run:426: sed -e s/-//g
<br>
> stderr: ++ 17:14:13: ocf_run:426: echo -err
<br>
> stderr: + 17:14:13: ocf_run:426: loglevel=err
<br>
> stderr: + 17:14:13: ocf_run:427: shift 1
<br>
> stderr: + 17:14:13: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:13: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:13: ocf_run:433: runuser postgres -c
'cd /var/lib/pgsql/9.3/data/; unset PGUSER; unset PGPASSWORD;
/usr/pgsql-9.3/bin/pg_ctl -D /var/lib/pgsql/9.3/data/ -l
/dev/null -o '\''-c
config_file=/var/lib/pgsql/9.3/data//postgresql.conf'\''
start'
<br>
> stderr: + 17:14:13: ocf_run:433: output='server
starting'
<br>
> stderr: + 17:14:13: ocf_run:434: rc=0
<br>
> stderr: ++ 17:14:13: ocf_run:435: echo server starting
<br>
> stderr: + 17:14:13: ocf_run:435: output='server
starting'
<br>
> stderr: + 17:14:13: ocf_run:436: '[' 0 -eq 0 ']'
<br>
> stderr: + 17:14:13: ocf_run:437: '[' 1 -a '!' -z
'server starting' ']'
<br>
> stderr: + 17:14:13: ocf_run:438: ocf_log info 'server
starting'
<br>
> stderr: + 17:14:13: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:13: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:13: ocf_log:326: shift
<br>
> stderr: + 17:14:13: ocf_log:327: __OCF_MSG='server
starting'
<br>
> stderr: + 17:14:13: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:13: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:14: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:14: ocf_log:341: ha_log 'INFO: server
starting'
<br>
> stderr: + 17:14:14: ha_log:253: __ha_log 'INFO: server
starting'
<br>
> stderr: + 17:14:14: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:14: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:14: __ha_log:188: '[' 'xINFO: server
starting' = x--ignore-stderr ']'
<br>
> stderr: + 17:14:14: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:14: __ha_log:192: tty
<br>
> stderr: + 17:14:14: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:14: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:14: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:14: __ha_log:202: echo 'INFO: server
starting'
<br>
> stderr: INFO: server starting
<br>
> stderr: + 17:14:14: __ha_log:204: return 0
<br>
> stderr: + 17:14:14: ocf_run:440: return 0
<br>
> stderr: + 17:14:14: pgsql_real_start:593: '[' 0 -eq 0
']'
<br>
> stderr: + 17:14:14: pgsql_real_start:595: ocf_log info
'PostgreSQL start command sent.'
<br>
> stderr: + 17:14:14: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:14: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:14: ocf_log:326: shift
<br>
> stderr: + 17:14:14: ocf_log:327: __OCF_MSG='PostgreSQL
start command sent.'
<br>
> stderr: + 17:14:14: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:14: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:14: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:14: ocf_log:341: ha_log 'INFO:
PostgreSQL start command sent.'
<br>
> stderr: + 17:14:14: ha_log:253: __ha_log 'INFO:
PostgreSQL start command sent.'
<br>
> stderr: + 17:14:14: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:14: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:14: __ha_log:188: '[' 'xINFO:
PostgreSQL start command sent.' = x--ignore-stderr ']'
<br>
> stderr: + 17:14:14: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:14: __ha_log:192: tty
<br>
> stderr: + 17:14:14: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:14: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:14: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:14: __ha_log:202: echo 'INFO:
PostgreSQL start command sent.'
<br>
> stderr: INFO: PostgreSQL start command sent.
<br>
> stderr: + 17:14:14: __ha_log:204: return 0
<br>
> stderr: + 17:14:14: pgsql_real_start:601: :
<br>
> stderr: + 17:14:14: pgsql_real_start:603:
pgsql_real_monitor warn
<br>
> stderr: + 17:14:14: pgsql_real_monitor:905: local
loglevel
<br>
> stderr: + 17:14:14: pgsql_real_monitor:906: local rc
<br>
> stderr: + 17:14:14: pgsql_real_monitor:907: local
output
<br>
> stderr: + 17:14:14: pgsql_real_monitor:910:
loglevel=warn
<br>
> stderr: + 17:14:14: pgsql_real_monitor:912:
pgsql_status
<br>
> stderr: + 17:14:14: pgsql_status:866: '[' -f
/var/lib/pgsql/9.3/data//postmaster.pid ']'
<br>
> stderr: ++ 17:14:14: pgsql_status:868: head -n 1
/var/lib/pgsql/9.3/data//postmaster.pid
<br>
> stderr: + 17:14:14: pgsql_status:868: PID=9556
<br>
> stderr: + 17:14:14: pgsql_status:869: runasowner 'kill
-s 0 9556 >/dev/null 2>&1'
<br>
> stderr: + 17:14:14: runasowner:467: local quietrun=
<br>
> stderr: + 17:14:14: runasowner:468: local loglevel=-err
<br>
> stderr: + 17:14:14: runasowner:469: local var
<br>
> stderr: + 17:14:14: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:14: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:14: runasowner:471: for var in 1 2
<br>
> stderr: + 17:14:14: runasowner:473: case "$1" in
<br>
> stderr: + 17:14:14: runasowner:485: ocf_run -err
runuser postgres -c 'cd /var/lib/pgsql/9.3/data/; kill -s 0
9556 >/dev/null 2>&1'
<br>
> stderr: + 17:14:14: ocf_run:413: local rc
<br>
> stderr: + 17:14:14: ocf_run:414: local output
<br>
> stderr: + 17:14:14: ocf_run:415: local verbose=1
<br>
> stderr: + 17:14:14: ocf_run:416: local loglevel=err
<br>
> stderr: + 17:14:14: ocf_run:417: local var
<br>
> stderr: + 17:14:14: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:14: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:14: ocf_run:426: echo -err
<br>
> stderr: ++ 17:14:14: ocf_run:426: sed -e s/-//g
<br>
> stderr: + 17:14:14: ocf_run:426: loglevel=err
<br>
> stderr: + 17:14:14: ocf_run:427: shift 1
<br>
> stderr: + 17:14:14: ocf_run:419: for var in 1 2
<br>
> stderr: + 17:14:14: ocf_run:421: case "$1" in
<br>
> stderr: ++ 17:14:14: ocf_run:433: runuser postgres -c
'cd /var/lib/pgsql/9.3/data/; kill -s 0 9556 >/dev/null
2>&1'
<br>
> stderr: + 17:14:14: ocf_run:433: output=
<br>
> stderr: + 17:14:14: ocf_run:434: rc=0
<br>
> stderr: ++ 17:14:14: ocf_run:435: echo
<br>
> stderr: + 17:14:14: ocf_run:435: output=
<br>
> stderr: + 17:14:14: ocf_run:436: '[' 0 -eq 0 ']'
<br>
> stderr: + 17:14:14: ocf_run:437: '[' 1 -a '!' -z '' ']'
<br>
> stderr: + 17:14:14: ocf_run:440: return 0
<br>
> stderr: + 17:14:14: pgsql_status:870: return 0
<br>
> stderr: + 17:14:14: pgsql_real_monitor:918:
is_replication
<br>
> stderr: + 17:14:14: is_replication:1287: '[' sync '!='
none -a sync '!=' slave ']'
<br>
> stderr: + 17:14:14: is_replication:1288: return 0
<br>
> stderr: ++ 17:14:14: pgsql_real_monitor:920: exec_sql
'select pg_is_in_recovery()'
<br>
> stderr: ++ 17:14:14: exec_sql:518: local 'sql=select
pg_is_in_recovery()'
<br>
> stderr: ++ 17:14:14: exec_sql:519: local output
<br>
> stderr: ++ 17:14:14: exec_sql:520: local rc
<br>
> stderr: +++ 17:14:14: exec_sql:524: runuser postgres -c
'cd /var/lib/pgsql/9.3/data/; /usr/pgsql-9.3/bin/psql -p 5432
-U postgres template1 -U postgres -Atc "select
pg_is_in_recovery()"'
<br>
> stderr: ++ 17:14:14: exec_sql:524: output=f
<br>
> stderr: ++ 17:14:14: exec_sql:525: rc=0
<br>
> stderr: ++ 17:14:14: exec_sql:527: echo f
<br>
> stderr: ++ 17:14:14: exec_sql:528: return 0
<br>
> stderr: + 17:14:14: pgsql_real_monitor:920: output=f
<br>
> stderr: + 17:14:14: pgsql_real_monitor:921: rc=0
<br>
> stderr: + 17:14:14: pgsql_real_monitor:923: '[' 0 -ne 0
']'
<br>
> stderr: + 17:14:14: pgsql_real_monitor:928: case
"$output" in
<br>
> stderr: + 17:14:14: pgsql_real_monitor:929: ocf_log
debug 'PostgreSQL is running as a primary.'
<br>
> stderr: + 17:14:14: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:14: ocf_log:325: __OCF_PRIO=debug
<br>
> stderr: + 17:14:14: ocf_log:326: shift
<br>
> stderr: + 17:14:14: ocf_log:327: __OCF_MSG='PostgreSQL
is running as a primary.'
<br>
> stderr: + 17:14:14: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:14: ocf_log:334: __OCF_PRIO=DEBUG
<br>
> stderr: + 17:14:14: ocf_log:338: '[' DEBUG = DEBUG ']'
<br>
> stderr: + 17:14:14: ocf_log:339: ha_debug 'DEBUG:
PostgreSQL is running as a primary.'
<br>
> stderr: + 17:14:14: ha_debug:258: '[' x = x0 ']'
<br>
> stderr: + 17:14:14: ha_debug:261: tty
<br>
> stderr: + 17:14:14: ha_debug:262: '[' '' ']'
<br>
> stderr: + 17:14:14: ha_debug:265: echo 'DEBUG:
PostgreSQL is running as a primary.'
<br>
> stderr: DEBUG: PostgreSQL is running as a primary.
<br>
> stderr: + 17:14:14: ha_debug:267: return 0
<br>
> stderr: + 17:14:14: pgsql_real_monitor:930: '[' 'select
now();' = 'select now();' ']'
<br>
> stderr: + 17:14:14: pgsql_real_monitor:931: return 8
<br>
> stderr: + 17:14:14: pgsql_real_start:604: rc=8
<br>
> stderr: + 17:14:14: pgsql_real_start:605: '[' 8 -eq 0
-o 8 -eq 8 ']'
<br>
> stderr: + 17:14:14: pgsql_real_start:606: break
<br>
> stderr: + 17:14:14: pgsql_real_start:614:
use_replication_slot
<br>
> stderr: + 17:14:14: use_replication_slot:1294: '[' -n
'' ']'
<br>
> stderr: + 17:14:14: use_replication_slot:1298: return 1
<br>
> stderr: + 17:14:14: pgsql_real_start:622: ocf_log info
'PostgreSQL is started.'
<br>
> stderr: + 17:14:14: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:14: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:14: ocf_log:326: shift
<br>
> stderr: + 17:14:14: ocf_log:327: __OCF_MSG='PostgreSQL
is started.'
<br>
> stderr: + 17:14:14: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:14: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:14: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:14: ocf_log:341: ha_log 'INFO:
PostgreSQL is started.'
<br>
> stderr: + 17:14:14: ha_log:253: __ha_log 'INFO:
PostgreSQL is started.'
<br>
> stderr: + 17:14:14: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:14: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:14: __ha_log:188: '[' 'xINFO:
PostgreSQL is started.' = x--ignore-stderr ']'
<br>
> stderr: + 17:14:14: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:14: __ha_log:192: tty
<br>
> stderr: + 17:14:14: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:14: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:14: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:14: __ha_log:202: echo 'INFO:
PostgreSQL is started.'
<br>
> stderr: INFO: PostgreSQL is started.
<br>
> stderr: + 17:14:14: __ha_log:204: return 0
<br>
> stderr: + 17:14:14: pgsql_real_start:623: return 8
<br>
> stderr: + 17:14:14: pgsql_promote:690: rc=8
<br>
> stderr: + 17:14:14: pgsql_promote:691: '[' 8 -ne 8 ']'
<br>
> stderr: + 17:14:14: pgsql_promote:723:
change_data_status pm1 LATEST
<br>
> stderr: + 17:14:14: change_data_status:1569: local
output
<br>
> stderr: + 17:14:14: change_data_status:1571: node_exist
pm1
<br>
> stderr: + 17:14:14: node_exist:1720: print_crm_mon
<br>
> stderr: + 17:14:14: node_exist:1720: grep -q '^node
pm1'
<br>
> stderr: + 17:14:14: node_exist:1720: tr '[A-Z]' '[a-z]'
<br>
> stderr: + 17:14:14: print_crm_mon:1924: '[' -z '' ']'
<br>
> stderr: ++ 17:14:14: print_crm_mon:1925:
exec_with_retry 0 crm_mon -n1
<br>
> stderr: ++ 17:14:14: exec_with_retry:1689: local
count=86400
<br>
> stderr: ++ 17:14:14: exec_with_retry:1690: local output
<br>
> stderr: ++ 17:14:14: exec_with_retry:1691: local rc
<br>
> stderr: ++ 17:14:14: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1696: shift
<br>
> stderr: ++ 17:14:14: exec_with_retry:1698: '[' 86400
-gt 0 ']'
<br>
> stderr: +++ 17:14:14: exec_with_retry:1699: crm_mon -n1
<br>
> stderr: ++ 17:14:14: exec_with_retry:1699: output='Last
updated: Mon Oct 12 17:14:14 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1700: rc=0
<br>
> stderr: ++ 17:14:14: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1706: printf 'Last
updated: Mon Oct 12 17:14:14 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:14: print_crm_mon:1925:
CRM_MON_OUTPUT='Last updated: Mon Oct 12 17:14:14 2015 Last
change: Mon Oct 12 16:07:56 2015 by root via crm_attribute on
pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: + 17:14:14: print_crm_mon:1927: printf 'Last
updated: Mon Oct 12 17:14:14 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql):
Slave\n'
<br>
> stderr: + 17:14:14: change_data_status:1575: :
<br>
> stderr: ++ 17:14:14: change_data_status:1577:
/usr/sbin/crm_attribute -l forever -N pm1 -n pgsql-data-status
-G -q
<br>
> stderr: + 17:14:14: change_data_status:1577:
output=LATEST
<br>
> stderr: + 17:14:14: change_data_status:1578: '[' LATEST
'!=' LATEST ']'
<br>
> stderr: + 17:14:14: change_data_status:1582: break
<br>
> stderr: + 17:14:14: change_data_status:1585: return 0
<br>
> stderr: + 17:14:14: pgsql_promote:724: exec_with_retry
0 /usr/sbin/crm_master -l reboot -v 1000
<br>
> stderr: + 17:14:14: exec_with_retry:1689: local
count=86400
<br>
> stderr: + 17:14:14: exec_with_retry:1690: local output
<br>
> stderr: + 17:14:14: exec_with_retry:1691: local rc
<br>
> stderr: + 17:14:14: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: + 17:14:14: exec_with_retry:1696: shift
<br>
> stderr: + 17:14:14: exec_with_retry:1698: '[' 86400 -gt
0 ']'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1699:
/usr/sbin/crm_master -l reboot -v 1000
<br>
> stderr: + 17:14:14: exec_with_retry:1699: output=
<br>
> stderr: + 17:14:14: exec_with_retry:1700: rc=0
<br>
> stderr: + 17:14:14: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: + 17:14:14: exec_with_retry:1706: printf ''
<br>
> stderr: + 17:14:14: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:14: pgsql_promote:725:
change_pgsql_status pm1 PRI
<br>
> stderr: + 17:14:14: change_pgsql_status:1543: local
output
<br>
> stderr: + 17:14:14: change_pgsql_status:1545:
is_node_online pm1
<br>
> stderr: + 17:14:14: is_node_online:1716: print_crm_mon
<br>
> stderr: + 17:14:14: is_node_online:1716: tr '[A-Z]'
'[a-z]'
<br>
> stderr: + 17:14:14: is_node_online:1716: grep -e '^node
pm1 ' -e '^node pm1:'
<br>
> stderr: + 17:14:14: is_node_online:1716: grep -q -v
offline
<br>
> stderr: + 17:14:14: print_crm_mon:1924: '[' -z '' ']'
<br>
> stderr: ++ 17:14:14: print_crm_mon:1925:
exec_with_retry 0 crm_mon -n1
<br>
> stderr: ++ 17:14:14: exec_with_retry:1689: local
count=86400
<br>
> stderr: ++ 17:14:14: exec_with_retry:1690: local output
<br>
> stderr: ++ 17:14:14: exec_with_retry:1691: local rc
<br>
> stderr: ++ 17:14:14: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1696: shift
<br>
> stderr: ++ 17:14:14: exec_with_retry:1698: '[' 86400
-gt 0 ']'
<br>
> stderr: +++ 17:14:14: exec_with_retry:1699: crm_mon -n1
<br>
> stderr: ++ 17:14:14: exec_with_retry:1699: output='Last
updated: Mon Oct 12 17:14:14 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1700: rc=0
<br>
> stderr: ++ 17:14:14: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1706: printf 'Last
updated: Mon Oct 12 17:14:14 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:14: print_crm_mon:1925:
CRM_MON_OUTPUT='Last updated: Mon Oct 12 17:14:14 2015 Last
change: Mon Oct 12 16:07:56 2015 by root via crm_attribute on
pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Slave'
<br>
> stderr: + 17:14:14: print_crm_mon:1927: printf 'Last
updated: Mon Oct 12 17:14:14 2015 Last change: Mon Oct
12 16:07:56 2015 by root via crm_attribute on pm1
<br>
> stderr: Stack: corosync
<br>
> stderr: Current DC: pm2 (version 1.1.13-a14efad) -
partition with quorum
<br>
> stderr: 2 nodes and 2 resources configured
<br>
> stderr:
<br>
> stderr: Node pm1: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql): Started
<br>
> stderr: Node pm2: online
<br>
> stderr: pgsql (ocf::heartbeat:pgsql):
Slave\n'
<br>
> stderr: ++ 17:14:14: change_pgsql_status:1549:
/usr/sbin/crm_attribute -l reboot -N pm1 -n pgsql-status -G -q
<br>
> stderr: + 17:14:14: change_pgsql_status:1549:
output=HS:alone
<br>
> stderr: + 17:14:14: change_pgsql_status:1550: '['
HS:alone '!=' PRI ']'
<br>
> stderr: + 17:14:14: change_pgsql_status:1554: '['
HS:alone = STOP -o HS:alone = UNKNOWN ']'
<br>
> stderr: + 17:14:14: change_pgsql_status:1560: ocf_log
info 'Changing pgsql-status on pm1 : HS:alone->PRI.'
<br>
> stderr: + 17:14:14: ocf_log:321: '[' 2 -lt 2 ']'
<br>
> stderr: + 17:14:14: ocf_log:325: __OCF_PRIO=info
<br>
> stderr: + 17:14:14: ocf_log:326: shift
<br>
> stderr: + 17:14:14: ocf_log:327: __OCF_MSG='Changing
pgsql-status on pm1 : HS:alone->PRI.'
<br>
> stderr: + 17:14:14: ocf_log:329: case "${__OCF_PRIO}"
in
<br>
> stderr: + 17:14:14: ocf_log:333: __OCF_PRIO=INFO
<br>
> stderr: + 17:14:14: ocf_log:338: '[' INFO = DEBUG ']'
<br>
> stderr: + 17:14:14: ocf_log:341: ha_log 'INFO: Changing
pgsql-status on pm1 : HS:alone->PRI.'
<br>
> stderr: + 17:14:14: ha_log:253: __ha_log 'INFO:
Changing pgsql-status on pm1 : HS:alone->PRI.'
<br>
> stderr: + 17:14:14: __ha_log:185: local
ignore_stderr=false
<br>
> stderr: + 17:14:14: __ha_log:186: local loglevel
<br>
> stderr: + 17:14:14: __ha_log:188: '[' 'xINFO: Changing
pgsql-status on pm1 : HS:alone->PRI.' = x--ignore-stderr
']'
<br>
> stderr: + 17:14:14: __ha_log:190: '[' none = '' ']'
<br>
> stderr: + 17:14:14: __ha_log:192: tty
<br>
> stderr: + 17:14:14: __ha_log:193: '[' x = x0 -a x =
xdebug ']'
<br>
> stderr: + 17:14:14: __ha_log:195: '[' false = true ']'
<br>
> stderr: + 17:14:14: __ha_log:199: '[' '' ']'
<br>
> stderr: + 17:14:14: __ha_log:202: echo 'INFO: Changing
pgsql-status on pm1 : HS:alone->PRI.'
<br>
> stderr: INFO: Changing pgsql-status on pm1 :
HS:alone->PRI.
<br>
> stderr: + 17:14:14: __ha_log:204: return 0
<br>
> stderr: + 17:14:14: change_pgsql_status:1561:
exec_with_retry 0 /usr/sbin/crm_attribute -l reboot -N pm1 -n
pgsql-status -v PRI
<br>
> stderr: + 17:14:14: exec_with_retry:1689: local
count=86400
<br>
> stderr: + 17:14:14: exec_with_retry:1690: local output
<br>
> stderr: + 17:14:14: exec_with_retry:1691: local rc
<br>
> stderr: + 17:14:14: exec_with_retry:1693: '[' 0 -ne 0
']'
<br>
> stderr: + 17:14:14: exec_with_retry:1696: shift
<br>
> stderr: + 17:14:14: exec_with_retry:1698: '[' 86400 -gt
0 ']'
<br>
> stderr: ++ 17:14:14: exec_with_retry:1699:
/usr/sbin/crm_attribute -l reboot -N pm1 -n pgsql-status -v
PRI
<br>
> stderr: + 17:14:14: exec_with_retry:1699: output=
<br>
> stderr: + 17:14:14: exec_with_retry:1700: rc=0
<br>
> stderr: + 17:14:14: exec_with_retry:1701: '[' 0 -ne 0
']'
<br>
> stderr: + 17:14:14: exec_with_retry:1706: printf ''
<br>
> stderr: + 17:14:14: exec_with_retry:1707: return 0
<br>
> stderr: + 17:14:14: change_pgsql_status:1563: return 0
<br>
> stderr: + 17:14:14: pgsql_promote:726: return 0
<br>
> stderr: + 17:14:14: 2058: exit 0
<br>
<br>
<br>
Thanks in advance!
<br>
<br>
<br>
_______________________________________________
<br>
Users mailing list: <a class="moz-txt-link-abbreviated" href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://clusterlabs.org/mailman/listinfo/users">http://clusterlabs.org/mailman/listinfo/users</a>
<br>
<br>
Project Home: <a class="moz-txt-link-freetext" href="http://www.clusterlabs.org">http://www.clusterlabs.org</a>
<br>
Getting started:
<a class="moz-txt-link-freetext" href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a>
<br>
Bugs: <a class="moz-txt-link-freetext" href="http://bugs.clusterlabs.org">http://bugs.clusterlabs.org</a>
<br>
</blockquote>
<br>
</blockquote>
<br>
<br>
_______________________________________________
<br>
Users mailing list: <a class="moz-txt-link-abbreviated" href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://clusterlabs.org/mailman/listinfo/users">http://clusterlabs.org/mailman/listinfo/users</a>
<br>
<br>
Project Home: <a class="moz-txt-link-freetext" href="http://www.clusterlabs.org">http://www.clusterlabs.org</a>
<br>
Getting started:
<a class="moz-txt-link-freetext" href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a>
<br>
Bugs: <a class="moz-txt-link-freetext" href="http://bugs.clusterlabs.org">http://bugs.clusterlabs.org</a>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nikolay Popov
<a class="moz-txt-link-abbreviated" href="mailto:n.popov@postgrespro.ru">n.popov@postgrespro.ru</a>
Postgres Professional: <a class="moz-txt-link-freetext" href="http://www.postgrespro.com">http://www.postgrespro.com</a>
The Russian Postgres Company</pre>
</body>
</html>