Thread: BUG #2099: too many private dirs ?

The following bug has been logged online:

Bug reference:      2099
Logged by:          Tom
Email address:      tom.zschockelt@flender.com
PostgreSQL version: 8.1.0
Operating system:   win2003 server
Description:        too many private dirs ?
Details:

we got the following error in our environment:

2005-12-08 13:43:04 ERROR:  too many private dirs demanded
2005-12-08 13:43:04 ERROR:  checkpoint request failed
2005-12-08 13:43:04 HINT:  Consult the server log for details.

Our environment is the following :
1 x win2003 server with postgresql 8.1.0-2
DB-Data on a NAS-device (mounted as network drive)

The error occurs when we want to create a new database in the
postgres-cluster. Creation of databases are only possible a few hours after
restarting the postgres
service.

Any idea ?

"Tom" <tom.zschockelt@flender.com> writes:
> we got the following error in our environment:

> 2005-12-08 13:43:04 ERROR:  too many private dirs demanded
> 2005-12-08 13:43:04 ERROR:  checkpoint request failed
> 2005-12-08 13:43:04 HINT:  Consult the server log for details.

I can see a possible mechanism for this, but it requires assuming that
there have been repeated prior failures in the bgwriter/checkpointer.
What else is in the postmaster log?

            regards, tom lane

Hi,

I've found the following additional lines in postmaster.log

2005-12-08 15:42:02 ERROR:  too many private dirs demanded
2005-12-08 15:42:03 ERROR:  too many private dirs demanded
2005-12-08 15:42:04 PANIC:  too many private files demanded
2005-12-08 15:42:04 CONTEXT:  writing block 236 of relation
1663/19946/20844
This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.
2005-12-08 15:42:04 LOG:  background writer process (PID 5748) was
terminated by signal 3
2005-12-08 15:42:04 LOG:  terminating any other active server processes
2005-12-08 15:42:04 WARNING:  terminating connection because of crash of
another server process
2005-12-08 15:42:04 DETAIL:  The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2005-12-08 15:42:04 HINT:  In a moment you should be able to reconnect to
the database and repeat your command.

Hope this helps

regards Tom







Tom Lane <tgl@sss.pgh.pa.us>
08.12.2005 16:57


        An:     "Tom" <tom.zschockelt@flender.com>
        Kopie:  pgsql-bugs@postgresql.org
        Thema:  Re: [BUGS] BUG #2099: too many private dirs ?


"Tom" <tom.zschockelt@flender.com> writes:
> we got the following error in our environment:

> 2005-12-08 13:43:04 ERROR:  too many private dirs demanded
> 2005-12-08 13:43:04 ERROR:  checkpoint request failed
> 2005-12-08 13:43:04 HINT:  Consult the server log for details.

I can see a possible mechanism for this, but it requires assuming that
there have been repeated prior failures in the bgwriter/checkpointer.
What else is in the postmaster log?

                                                 regards, tom lane