SEO

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

On Thu, 2006-05-25 at 14:00, Benjamin Krajmalnik wrote:
> 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

You're likely either out of disk space, or someone's changed the
permissions on a pgsql directory or file.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend