SEO

#1 (**permalink**) 04-10-2008, 09:33 AM

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 ?

---------------------------(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

#2 (**permalink**) 04-10-2008, 09:33 AM

"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

---------------------------(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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

BUG #2099: too many private dirs ?