|
good suggestion jeff I would also add starting postgres with log_connections=on postgres -c log_connections=on check postgressql.cong logdirectory log_destination = '/fubar' just to make sure you have permission to write to fubar.. HTH Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: postgres@xxxxxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: again... > Date: Sun, 26 Oct 2008 11:47:24 -0400 > > > ----- Original Message ----- > From: "Scott Marlowe" <scott.marlowe@xxxxxxxxx> > To: "Ati Rosselet" <ati.rosselet@xxxxxxxxx> > Cc: <pgsql-general@xxxxxxxxxxxxxx> > Sent: Saturday, October 25, 2008 12:04 PM > Subject: Re: again... > > > > On Sat, Oct 25, 2008 at 9:12 AM, Ati Rosselet <ati.rosselet@xxxxxxxxx> > > wrote: > >> I'm still getting a lot of these entries in my eventlog whenever I have a > >> reasonably large amount of logging: > >> > >> Event Type: Error > >> Event Source: PostgreSQL > >> Event Category: None > >> Event ID: 0 > >> Date: 10/22/2008 > >> Time: 9:36:28 AM > >> User: N/A > >> Computer: ---------- > >> Description: > >> could not write to log file: Bad file descriptor > >> > >> production server 8.3.3 (tried with 8.3.4 - same thing), win 2003 server. > >> I'd send this to psql-bugs, but I can't figure out how to reproduce it.. > >> and > >> apparently noone else has seen this? Or is noone else running postgres > >> on > >> win2003??? (survey says??) > >> > >> The timing of each appears to be when log is rolled over (size limited to > >> 10MB) and postgres attempts to write a log entry at the same time: > >> > >> Any ideas? help? How to proceed??? > > > > Maybe you've got a virus scanner that's locking your log files on you? > > Hi Ati, > > Inconsistent misbehavior is always fun ;). You may need to increase the > probability that the misbehavior shows itself. I'd change the 10 MB limit > to 1MB and document your findings. Additionally, you may take the size > limit out of the picture and lower the time limit to something ridiculously > low. (120 minutes?) > > Just a suggestion... Good luck! > > Jeff > > > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general When your life is on the go—take your life with you. Try Windows Mobile® today |
