[Pacemaker] Daemon Start attempt on wrong Server

[Hauke Homburg]

Hello,

I am installing a 6 Node pacemaker CLuster. 3 Nodes for Apache, 3 Nodes 
for Postgres.

My Cluster Config is

node kvm-node1
node sql-node1
node sql-node2
node sql-node3
node www-node1
node www-node2
node www-node3
primitive pri_kvm_ip ocf:heartbeat:IPaddr2 \
         params ip="10.0.6.41" cidr_netmask="255.255.255.0" \
         op monitor interval="10s" timeout="20s"
primitive pri_sql_ip ocf:heartbeat:IPaddr2 \
         params ip="10.0.6.31" cidr_netmask="255.255.255.0" \
         op monitor interval="10s" timeout="20s"
primitive pri_www_ip ocf:heartbeat:IPaddr2 \
         params ip="10.0.6.21" cidr_netmask="255.255.255.0" \
         op monitor interval="10s" timeout="20s"
primitive res_apache ocf:heartbeat:apache \
         params configfile="/etc/apache2/apache2.conf" \
         op start interval="0" timeout="40" \
         op stop interval="0" timeout="60" \
         op monitor interval="60" timeout="120" start-delay="0" \
         meta target-role="Started"
primitive res_pgsql ocf:heartbeat:pgsql \
         params pgctl="/usr/lib/postgresql/9.1/bin/pg_ctl" 
psql="/usr/bin/psql" start_opt="" pgdata="/var/lib/postgresql/9.1/main" 
config="/etc/postgresql/9.1/main/postgresql.conf" pgdba="postgres" \
         op start interval="0" timeout="120s" \
         op stop interval="0" timeout="120s" \
         op monitor interval="30s" timeout="30s" depth="0"
location loc_kvm_ip_node1 pri_kvm_ip 10001: kvm-node1
location loc_sql_ip_node1 pri_sql_ip inf: sql-node1
location loc_sql_ip_node2 pri_sql_ip inf: sql-node2
location loc_sql_ip_node3 pri_sql_ip inf: sql-node3
location loc_sql_srv_node1 res_pgsql inf: sql-node1
location loc_sql_srv_node2 res_pgsql inf: sql-node2
location loc_sql_srv_node3 res_pgsql inf: sql-node3
location loc_www_ip_node1 pri_www_ip inf: www-node1
location loc_www_ip_node2 pri_www_ip inf: www-node2
location loc_www_ip_node3 pri_www_ip inf: www-node3
location loc_www_srv_node1 res_apache inf: www-node1
location loc_www_srv_node2 res_apache inf: www-node2
location loc_www_srv_node3 res_apache inf: www-node3
property $id="cib-bootstrap-options" \
         dc-version="1.1.7-ee0730e13d124c3d58f00016c3376a1de5323cff" \
         cluster-infrastructurFailed actions:

Why do i see in crm_mon the following output?

     res_pgsql_start_0 (node=www-node1, call=16, rc=5, status=complete): 
not installed
     res_pgsql_start_0 (node=www-node2, call=13, rc=5, status=complete): 
not installed
     pri_www_ip_monitor_10000 (node=www-node3, call=22, rc=7, 
status=complete): not running
     res_pgsql_start_0 (node=www-node3, call=13, rc=5, status=complete): 
not installed
     res_apache_start_0 (node=sql-node2, call=18, rc=5, 
status=complete): not installed
     res_pgsql_start_0 (node=sql-node2, call=12, rc=5, status=complete): 
not installed
     res_apache_start_0 (node=sql-node3, call=12, rc=5, 
status=complete): not installed
     res_pgsql_start_0 (node=sql-node3, call=10, rc=5, status=complete): 
not installed
     res_apache_start_0 (node=kvm-node1, call=12, rc=5, 
status=complete): not installed
     res_pgsql_start_0 (node=kvm-node1, call=20, rc=5, status=complete): 
not installede="openais" \
         expected-quorum-votes="7" \
         stonith-enabled="false"


I set the infinity for pgsql on all 3 sql nodes, but not! on the www 
nodes. Why tries Pacemaker to start the Postgres SQL Server on the www 
Node? In example?

Thank for your Help

greetings

Hauke