SEO

#1 (**permalink**) 04-10-2008, 06:13 AM

Neither is the case.
I have over 60GB of space left, and the database is currently at about
800Mb.
Restarting the service resolves the problem, so it is not a file
permissions issue.
As I mentioned, I this sems to happen, internmittently, when
postgresql.conf is reloaded.

-----Original Message-----
From: Scott Marlowe [mailto:smarlowe@g2switchworks.com]
Sent: Thursday, May 25, 2006 1:14 PM
To: Benjamin Krajmalnik
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Strange errors in log file

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 4: Have you searched our list archives?

http://archives.postgresql.org

#2 (**permalink**) 04-10-2008, 06:13 AM

Not that I'm sure it'll help much, but what OS, server version et. al.
are you running?

On Thu, 2006-05-25 at 14:17, Benjamin Krajmalnik wrote:
> Neither is the case.
> I have over 60GB of space left, and the database is currently at about
> 800Mb.
> Restarting the service resolves the problem, so it is not a file
> permissions issue.
> As I mentioned, I this sems to happen, internmittently, when
> postgresql.conf is reloaded.
>
> -----Original Message-----
> From: Scott Marlowe [mailto:smarlowe@g2switchworks.com]
> Sent: Thursday, May 25, 2006 1:14 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Strange errors in log file
>
> 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 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#3 (**permalink**) 04-10-2008, 06:13 AM

"Benjamin Krajmalnik" <kraj@illumen.com> writes:
> Restarting the service resolves the problem, so it is not a file
> permissions issue.

It sure *looks* like a file permissions issue.

FWIW, I see that port/win32/error.c translates these Windows
error codes to EACCES:

ERROR_ACCESS_DENIED
ERROR_CURRENT_DIRECTORY
ERROR_LOCK_VIOLATION
ERROR_SHARING_VIOLATION
ERROR_NETWORK_ACCESS_DENIED
ERROR_CANNOT_MAKE
ERROR_FAIL_I24
ERROR_DRIVE_LOCKED
ERROR_SEEK_ON_DEVICE
ERROR_NOT_LOCKED
ERROR_LOCK_FAILED

It would appear that the underlying problem is one of these.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: Strange errors in log file