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

Re: Bad behaviour in Sun Cluster

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Patricio Mora" <patricio(dot)mora(at)juntadeandalucia(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bad behaviour in Sun Cluster
Date: 2008-10-31 13:03:52
Message-ID: dcc563d10810310603k52b0b63emb3809a6e8123dd59@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Oct 31, 2008 at 5:00 AM, Patricio Mora
<patricio(dot)mora(at)juntadeandalucia(dot)es> wrote:
> Hello all.
>
> - postmaster (PostgreSQL) 7.4.5 (Update unviable due to application)

And this prevents you from updating to 7.4.22?

> - 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)

Are there any errors in the logs?

In response to

Responses

pgsql-general by date

Next:From: Patricio MoraDate: 2008-10-31 13:17:07
Subject: Re: Bad behaviour in Sun Cluster
Previous:From: John DeSoiDate: 2008-10-31 12:19:23
Subject: Re: tsearch2 problem

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