Regression Tests

Started by Paul Julianoover 25 years ago4 messages
#1Paul Juliano
paul@edsamail.com

Hi,

I've installed PostgreSQL 7.0.2 on Solaris following the INSTALL file
that comes with the source.

When I do:

make runtest

it gives out the following error message in regress.out:

postmaster must already be running for the regression tests to succeed.
The time zone is set to PST8PDT for these tests by the client frontend.
Please report any apparent problems to ports@postgresql.org
See regress/README for more information.

=============== dropping old regression database... =================
DROP DATABASE
=============== creating new regression database... =================
CREATE DATABASE
=============== installing languages... =================
installing PL/pgSQL .. createlang: missing required argument PGLIB
directory
(This is the directory where the interpreter for the procedural
language is stored. Traditionally, these are installed in whatever
'lib' directory was specified at configure time.)
failed

Also, when I do:

make runcheck

the following message is in the postmaster.log

IpcSemaphoreCreate: semget failed (No space left on device)
key=65432015, num=16, permission=600
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
FATAL 1: InitProcGlobal: IpcSemaphoreCreate failed

#2Patrick Welche
prlw1@newn.cam.ac.uk
In reply to: Paul Juliano (#1)
Re: Regression Tests

On Thu, Aug 17, 2000 at 05:00:49PM +0800, Paul Juliano wrote:

installing PL/pgSQL .. createlang: missing required argument PGLIB
directory

I don't know about this one.

Also, when I do:

make runcheck

the following message is in the postmaster.log

IpcSemaphoreCreate: semget failed (No space left on device)
key=65432015, num=16, permission=600
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
FATAL 1: InitProcGlobal: IpcSemaphoreCreate failed

Simplest solution: quit the other postmaster, then make runcheck. Otherwise
double your IPC settings - depending on the OS this might involve building
a new kernel.

Cheers,

Patrick

#3Karel Zak
zakkr@zf.jcu.cz
In reply to: Paul Juliano (#1)
Re: Regression Tests

On Thu, 17 Aug 2000, Paul Juliano wrote:

=============== installing languages... =================
installing PL/pgSQL .. createlang: missing required argument PGLIB
directory

It's easy:

$ export PGLIB=/path/to/postgresql/lib
$ make runtest

BTW.:

Hackers, why this 'export' not handle regression test itself
from $libdir that is already defined in Makefile.global?

Needs a patch? :-)

Karel

#4Stephan Szabo
sszabo@megazone23.bigpanda.com
In reply to: Paul Juliano (#1)
Re: Regression Tests

On Thu, 17 Aug 2000, Paul Juliano wrote:

Hi,

I've installed PostgreSQL 7.0.2 on Solaris following the INSTALL file
that comes with the source.

When I do:

make runtest

it gives out the following error message in regress.out:

postmaster must already be running for the regression tests to succeed.
The time zone is set to PST8PDT for these tests by the client frontend.
Please report any apparent problems to ports@postgresql.org
See regress/README for more information.

=============== dropping old regression database... =================
DROP DATABASE
=============== creating new regression database... =================
CREATE DATABASE
=============== installing languages... =================
installing PL/pgSQL .. createlang: missing required argument PGLIB
directory
(This is the directory where the interpreter for the procedural
language is stored. Traditionally, these are installed in whatever
'lib' directory was specified at configure time.)
failed

Do you have a PGLIB environment variable set?
You may need one so that createlang can find the procedural
language information. It's probably /usr/local/pgsql/lib
if you didn't change the locations.

I thought this information was in the INSTALL, but it's not there any
more in any case.

Also, when I do:

make runcheck

the following message is in the postmaster.log

IpcSemaphoreCreate: semget failed (No space left on device)
key=65432015, num=16, permission=600
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
FATAL 1: InitProcGlobal: IpcSemaphoreCreate failed

Sounds like you don't have a large enough shared memory block
configured on the machine. I don't know enough about solaris
to help here, but I believe people have posted shared memory
configurations on either -general or -hackers in the past.
You might be able to find more info in the archives.