Skip site navigation (1) Skip section navigation (2)

Bad behaviour in Sun Cluster

From: Patricio Mora <patricio(dot)mora(at)juntadeandalucia(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: Bad behaviour in Sun Cluster
Date: 2008-10-31 11:00:53
Message-ID: 490AE565.1080308@juntadeandalucia.es (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-general
Hello all.

- postmaster (PostgreSQL) 7.4.5 (Update unviable due to application)
- Solaris 9
- Sun Cluster 3.1.0
- SUNWscPostgreSQL 3.1.0

About 3 times each week, the check_pgs function of the SUNWscPostgreSQL 
bin/functios file, stops my Postgres database.
I enabled the cluster's monitor logs (DEBUG=ALL on etc/config) and found 
it complains about a time out when manipulating the tables of the 
Postgres user used for the cluster to test the health of the DB server.

The command it throws is this:

/usr/bin/su - postgres -c   /usr/bin/env 
LD_LIBRARY_PATH=/usr/local/lib:/usr/local/pgsql/lib /usr/bin/env 
PGPASSWORD=XXXX /usr/bin/env PGDATA=/postgres/data /usr/bin/env 
PGPORT=5432 /usr/local/pgsql/bin/psql -d sc3_test_database -U scuser -c 
"truncate sc3_table;insert into sc3_table (sccol) values('hello im 
there');select * from sc3_table" > 
/tmp/postgres_server-postgres-tbl-out  2> 
/tmp/postgres_server-postgres-tbl-err

A minute after the timeout occurs. Postgres.log doesn't show anything (I 
dont log SQL instructions)

Someone's seen something similar? TIA.

Responses

pgsql-general by date

Next:From: Oleg BartunovDate: 2008-10-31 11:31:47
Subject: Re: tsearch2 problem
Previous:From: Scott MarloweDate: 2008-10-31 10:50:29
Subject: Re: Are there plans to add data compression feature to postgresql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group