Skip site navigation (1) Skip section navigation (2)

Re: BUG #2712: could not fsync segment: Permission denied

From: "Thomas H(dot)" <me(at)alternize(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #2712: could not fsync segment: Permission denied
Date: 2006-10-23 01:31:50
Message-ID: 07fa01c6f643$03b7d9a0$0201a8c0@iwing (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
in verbose mode, the log shows a little bit more:

2006-10-23 03:23:14 LOG:  42501: could not fsync segment 0 of relation 
1663/3964774/6411190: Permission denied
2006-10-23 03:23:14 LOCATION:  mdsync, md.c:785
2006-10-23 03:23:14 ERROR:  XX000: storage sync failed on magnetic disk: 
Permission denied
2006-10-23 03:23:14 LOCATION:  smgrsync, smgr.c:888

- thomas

----- Original Message ----- 
From: "Thomas H" <me(at)alternize(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Sent: Monday, October 23, 2006 1:28 AM
Subject: [BUGS] BUG #2712: could not fsync segment: Permission denied


>
> The following bug has been logged online:
>
> Bug reference:      2712
> Logged by:          Thomas H
> Email address:      me(at)alternize(dot)com
> PostgreSQL version: 8.2b1
> Operating system:   windows 2003 standard
> Description:        could not fsync segment: Permission denied
> Details:
>
> sometimes we're seeing loads of errors in the log:
>
> 2006-10-22 23:48:50 LOG:  could not fsync segment 0 of relation
> 1663/3964774/6409340: Permission denied
> 2006-10-22 23:48:50 ERROR:  storage sync failed on magnetic disk: 
> Permission
> denied
> 2006-10-22 23:48:51 LOG:  could not fsync segment 0 of relation
> 1663/3964774/6409340: Permission denied
> 2006-10-22 23:48:51 ERROR:  storage sync failed on magnetic disk: 
> Permission
> denied
> 2006-10-22 23:48:52 LOG:  could not fsync segment 0 of relation
> 1663/3964774/6409340: Permission denied
> 2006-10-22 23:48:52 ERROR:  storage sync failed on magnetic disk: 
> Permission
> denied
> 2006-10-22 23:48:53 LOG:  could not fsync segment 0 of relation
> 1663/3964774/6409340: Permission denied
> 2006-10-22 23:48:53 ERROR:  storage sync failed on magnetic disk: 
> Permission
> denied
> {...}
>
> when this happens, there are also files locked within the 
> data\base\{dbid}\.
> access to those files are denied by the os - the files vanish as soon as
> postmaster ist stopped & restarted.
>
> i haven't yet found a possible reason - i suspect the error to appear
> *sometimes* after issuing a "VACUUM FULL ANALYZE {tablename}" / "REINDEX
> TABLE {tablename}".
>
> the hardware is checked and ok.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 



In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-10-23 02:07:21
Subject: Re: BUG #2712: could not fsync segment: Permission denied
Previous:From: Thomas HDate: 2006-10-22 23:28:32
Subject: BUG #2712: could not fsync segment: Permission denied

pgsql-patches by date

Next:From: Tom LaneDate: 2006-10-23 02:07:21
Subject: Re: BUG #2712: could not fsync segment: Permission denied
Previous:From: Hitoshi HaradaDate: 2006-10-23 01:02:49
Subject: Re: [PATCHES] smartvacuum() instead of autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group