The following bug has been logged online:

Bug reference: 2099
Logged by: Tom
Email address: tom.zschockelt (AT) flender (DOT) 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 ?

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"Tom" <tom.zschockelt (AT) flender (DOT) com> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

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 (AT) sss (DOT) pgh.pa.us>
08.12.2005 16:57


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


"Tom" <tom.zschockelt (AT) flender (DOT) com> writes:
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




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

I am also getting the "too many private dirs demanded". I initially
noticed it when trying to drop / create a database. Restarting the
service allowed me to perform the drop and then recreate it. I am also
seeing the same error on the server in just everyday usage.

We are using a similar setup with win2k3, postgresql-8.1.0-1, data on a
mounted drive.

Is there additional information I should provide?

Thanks,
Scott


Tom.Zschockelt (AT) flender (DOT) com wrote: