X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B54CA9F9B01 for ; Thu, 25 May 2006 16:00:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 16024-09 for ; Thu, 25 May 2006 16:00:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 935AE9F94EA for ; Thu, 25 May 2006 16:00:37 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6802D.800DC010" Subject: Strange errors in log file X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Thu, 25 May 2006 13:00:33 -0600 Message-ID: <8511B4970E0D124898E973DF496F9B432516DD@stash.stackdump.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Strange errors in log file thread-index: AcaALYC1UMKOdN0HTSGRWY86A2v6RA== From: "Benjamin Krajmalnik" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/352 X-Sequence-Number: 21884 This is a multi-part message in MIME format. ------_=_NextPart_001_01C6802D.800DC010 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am running PostgreSQL 8.1.3/Win =20 Earlier yesterday, it appeared that the server stopped responding. I went through the log files and noticed the following type of entries. =20 =20 22462 is the filenode for my database. I could not find what the other two are. =20 =20 2006-05-24 12:16:35 LOG: could not fsync segment 0 of relation 1663/22462/18193301: Permission denied =20 2006-05-24 12:16:35 ERROR: storage sync failed on magnetic disk: Permission denied =20 Today, I managed to get the server to act up in the same manner. Using pgAdmin, I had turned on logging to isolate a problem coming on from a query being autogenetrated by a monitoring system. =20 When I turned off the logging, saved the file, and sent a trigger to to reload the config it happened again. =20 The log entries for that chain of events are as follows: =20 2006-05-25 12:42:53 LOG: statement: SELECT pg_reload_conf() 2006-05-25 12:42:53 LOG: duration: 31.000 ms 2006-05-25 12:42:53 LOG: received SIGHUP, reloading configuration files 2006-05-25 12:42:53 LOG: duration: 422.000 ms 2006-05-25 12:42:53 LOG: could not fsync segment 0 of relation 1663/22462/18329383: Permission denied 2006-05-25 12:42:53 ERROR: storage sync failed on magnetic disk: Permission denied 2006-05-25 12:42:54 LOG: could not fsync segment 0 of relation 1663/22462/18329383: Permission denied =20 =20 =20 Thanks in advance. =20 Regards, =20 Benjamin =20 ------_=_NextPart_001_01C6802D.800DC010 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am running PostgreSQL = 8.1.3/Win

 

Earlier yesterday, it appeared that the server = stopped responding.

I went through the log files and noticed the = following type of entries.

 

 

22462 is the filenode for my database.  I could = not find what the other two are.

 

 

2006-05-24 12:16:35 LOG:  could not fsync = segment 0 of relation 1663/22462/18193301: Permission = denied

 

2006-05-24 12:16:35 ERROR:  storage sync failed = on magnetic disk: Permission denied

 

Today, I managed to get the server to act up in the = same manner.

Using pgAdmin, I had turned on logging to isolate a = problem coming on from a query being autogenetrated by a monitoring = system.

 

When I turned off the logging, saved the file, and = sent a trigger to to reload the config it happened = again.

 

The log entries for that chain of events are as = follows:

 

2006-05-25 12:42:53 LOG:  statement: SELECT pg_reload_conf()

2006-05-25 12:42:53 LOG:  duration: 31.000 = ms

2006-05-25 12:42:53 LOG:  received SIGHUP, = reloading configuration files

2006-05-25 12:42:53 LOG:  duration: 422.000 = ms

2006-05-25 12:42:53 LOG:  could not fsync = segment 0 of relation 1663/22462/18329383: Permission = denied

2006-05-25 12:42:53 ERROR:  storage sync failed = on magnetic disk: Permission denied

2006-05-25 12:42:54 LOG:  could not fsync = segment 0 of relation 1663/22462/18329383: Permission = denied

 

 

 

Thanks in advance.

 

Regards,

 

Benjamin

 

------_=_NextPart_001_01C6802D.800DC010--