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

Re: Tests randomly failed

From: Justin Clift <aa2(at)bigpond(dot)net(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Justin Clift <jclift(at)iprimus(dot)com(dot)au>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Alexander Klimov <ask(at)wisdom(dot)weizmann(dot)ac(dot)il>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Tests randomly failed
Date: 2001-03-22 23:55:07
Message-ID: 3ABA90DB.5D4D56C3@bigpond.net.au (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi Tom,

I know what you're saying, but I've come across it multiple times.

The process for building a Solaris server for PostgreSQL is (from
memory) :

A) Install the OS
B) Install the latest Maintenance Update
C) Install the latest recommended patches
D) Adjust system values for semaphores and shared memory
E) Do an initial lockdown for system security
F) Reboot for the new settings to take effect
G) Create postgres group and postgres user
H) Compile postgres
I) Run the regression tests
J) Lockdown system again
K) Reboot, test startup scripts, etc
<etc>

If I'm working very late and can't find the semaphore settings, then
sometimes I'll do them out-of-order.

A number of times I've totally forgotten to change things until
PostgreSQL complains either in the regression tests (as described in
this thread) or during normal startup.

We're talking a few times anyway, probably about.... um... 15 - 20 times
or so that I've forgotten.

Regards and best wishes,

Justin Clift

Tom Lane wrote:
> 
> Justin Clift <jclift(at)iprimus(dot)com(dot)au> writes:
> > If it's of any help, I get the same types of regression testing failures
> > on Solaris, with the same "is the backend running?" type error
> > messages.. when the installation of solaris HAS NOT had it's /etc/system
> > file altered to change the amount of shared memory segments and
> > semaphores.
> 
> > Whenever I have those problems, I insert the updated (higher) values for
> > shared memory and semaphores, reboot the system, then the tests pass as
> > the backend is able to start fine.
> 
> Hm.  That's interesting, but it's fairly hard to believe.  For at least
> a couple releases past, Postgres has grabbed all the shared memory and
> semaphores that it wants at postmaster start.  Insufficient shmem/sema
> resources should result in postmaster abort, not in occasional failures
> to start backends.
> 
>                         regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl

In response to

pgsql-bugs by date

Next:From: Rainer MagerDate: 2001-03-23 06:19:36
Subject: Problems with latest tests
Previous:From: Tom LaneDate: 2001-03-22 23:27:01
Subject: Re: Tests randomly failed

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