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

Re: Bad behaviour in Sun Cluster

From: Patricio Mora <patricio(dot)mora(at)juntadeandalucia(dot)es>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bad behaviour in Sun Cluster
Date: 2008-10-31 13:17:07
Message-ID: 490B0553.8030008@juntadeandalucia.es (view raw or flat)
Thread:
Lists: pgsql-general
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Scott Marlowe escribi&oacute;:
<blockquote
 cite="middcc563d10810310603k52b0b63emb3809a6e8123dd59(at)mail(dot)gmail(dot)com"
 type="cite">
  <pre wrap="">On Fri, Oct 31, 2008 at 5:00 AM, Patricio Mora
<a class="moz-txt-link-rfc2396E" href="mailto:patricio(dot)mora(at)juntadeandalucia(dot)es">&lt;patricio(dot)mora(at)juntadeandalucia(dot)es&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Hello all.

- postmaster (PostgreSQL) 7.4.5 (Update unviable due to application)
    </pre>
  </blockquote>
  <pre wrap=""><!---->
And this prevents you from updating to 7.4.22?
  </pre>
</blockquote>
Thanks, I'll try it on my development environment. I tried some 8
version and application crashed.<br>
<blockquote
 cite="middcc563d10810310603k52b0b63emb3809a6e8123dd59(at)mail(dot)gmail(dot)com"
 type="cite">
  <pre wrap="">
  </pre>
  <blockquote type="cite">
    <pre wrap="">- 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" &gt; /tmp/postgres_server-postgres-tbl-out  2&gt;
/tmp/postgres_server-postgres-tbl-err

A minute after the timeout occurs. Postgres.log doesn't show anything (I
dont log SQL instructions)
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Are there any errors in the logs?
  </pre>
</blockquote>
Postgres doesn't show any log (I'm logging only connections)<br>
Cluster says that the service is broken.<br>
And SUNWscPostgreSQL says:<br>
<br>
15:45:47 The probe command &lt;/opt/SUNWscPostgreSQL/bin/control_pgs -R
postgres_server -G postgres_rg -P /postgres/data/postgres.conf.cluster
probe&gt; timed out<br>
15:45:47 Restarting the resource postgres_server.<br>
<br>
</body>
</html>


Attachment: unknown_filename
Description: text/html (2.4 KB)

In response to

Responses

pgsql-general by date

Next:From: Kevin MurphyDate: 2008-10-31 13:20:48
Subject: perl-DBD-Pg package for CentOS 5?
Previous:From: Scott MarloweDate: 2008-10-31 13:03:52
Subject: Re: Bad behaviour in Sun Cluster

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