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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2008-10-31 11:31:47 | Re: tsearch2 problem |
Previous Message | Scott Marlowe | 2008-10-31 10:50:29 | Re: Are there plans to add data compression feature to postgresql? |