Hi, On Mon, May 17, 2010 at 11:17:21AM +0200, Jose wrote: > Hi, > > I'm trying to build a PostgreSQL two-node cluster in ubuntu 10.04 but > I get this error: > > ============ > Last updated: Mon May 17 09:11:42 2010 > Stack: openais > Current DC: ubuntu01 - partition with quorum > Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd > 2 Nodes configured, 2 expected votes > 2 Resources configured. > ============ > > Online: [ ubuntu01 ubuntu02 ] > > ClusterIP (ocf::heartbeat:IPaddr2): Started ubuntu01 > > Failed actions: > Database_start_0 (node=ubuntu01, call=5, rc=-2, status=Timed Out): > unknown exec error > Database_start_0 (node=ubuntu02, call=4, rc=-2, status=Timed Out): > unknown exec error > > > My cluster configuration is: > > r...@ubuntu01:~# crm configure show > node ubuntu01 \ > attributes standby="off" > node ubuntu02 > primitive ClusterIP ocf:heartbeat:IPaddr2 \ > params ip="193.147.51.171" cidr_netmask="32" \ > op monitor interval="30s" > primitive Database ocf:heartbeat:pgsql \ > op monitor interval="120s" \ > op start interval="0" timeout="120s" \ > op stop interval="0" timeout="120s" \ > params pgctl="/usr/lib/postgresql/8.4/bin/pg_ctl" > psql="/usr/lib/postgresql/8.4/bin/psql" > pgdata="/var/lib/postgresql/8.4/main/" > config="/etc/postgresql/8.4/main/postgresql.conf" \ > meta target-role="Started" > location cli-prefer-ClusterIP ClusterIP \ > rule $id="cli-prefer-rule-ClusterIP" inf: #uname eq ubuntu01 > property $id="cib-bootstrap-options" \ > dc-version="1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd" \ > cluster-infrastructure="openais" \ > expected-quorum-votes="2" \ > stonith-enabled="false" \ > no-quorum-policy="ignore" \ > last-lrm-refresh="1274084375" > > > If I run ocf by hand I get: > > r...@ubuntu01:~# OCF_ROOT=/usr/lib/ocf > OCF_RESKEY_pgctl=/usr/lib/postgresql/8.4/bin/pg_ctl > OCF_RESKEY_psql=/usr/lib/postgresql/8.4/bin/psql > OCF_RESKEY_pgdata=/var/lib/postgresql/8.4/main/ > OCF_RESKEY_config=/etc/postgresql/8.4/main/pg_hba.conf > /usr/lib/ocf/resource.d/heartbeat/pgsql start > pgsql[17611]: INFO: could not change directory to "/root" server starting > pgsql[17611]: INFO: PostgreSQL start command sent. > pgsql[17611]: INFO: PostgreSQL is down > pgsql[17611]: DEBUG: PostgreSQL still hasn't started yet. Waiting... > pgsql[17611]: INFO: PostgreSQL is down > pgsql[17611]: DEBUG: PostgreSQL still hasn't started yet. Waiting... > > and continues throws this error all time. > > Could anybody tell me where I'm wrong? Thanks.
This is either PostgreSQL specific problem (look at its logs?) or it simply takes longer to start the database than what you set as the timeout. Thanks, Dejan > _______________________________________________ > Linux-HA mailing list > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
