Thread: Regression Tests

Regression Tests

From
Paul Juliano
Date:
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

Re: Regression Tests

From
Patrick Welche
Date:
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

Re: Regression Tests

From
Karel Zak
Date:
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


Re: Regression Tests

From
Stephan Szabo
Date:
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.