Ati Rosselet 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???
Change the log settings to panic and up the size limit. Almost nothing
gets written to the log and the log never gets full enough to rotate.
Other than that, you'll need to get visual studio and the source and
work it out.
Reproducing it is relatively easy - make a function that does raise
notice and call it a lot. I had one that essentially took out the server.
http://archives.postgresql.org/pgsql-general/2008-08/msg00615.php
+1 for survey.
klint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@xxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
