Strange errors in log file

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Strange errors in log file
Date: 2006-05-25 19:00:33
Message-ID: 8511B4970E0D124898E973DF496F9B432516DD@stash.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2006-05-25 19:08:23 pg_clog questions
Previous Message César Maldonado 2006-05-25 17:37:32 TIENEN ALGUN REPOSITORIO PARA INSTALAR POSTGRE 8 EN DEBIAN