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 16:21:34
Message-ID: 00af01c6f6bf$4f21a7f0$0201a8c0@iwing (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
there is defenitely something terribly wrong in the windows 8.2b1 regarding 
file access/locking. 2nd total db lockup today due to file access locks (all 
hold by postmaster):

{...}
2006-10-23 17:48:10 LOG:  42501: could not fsync segment 0 of relation 
1663/3964774/6419608: Permission denied
2006-10-23 17:48:10 LOCATION:  mdsync, md.c:785
2006-10-23 17:48:10 ERROR:  XX000: storage sync failed on magnetic disk: 
Permission denied
2006-10-23 17:48:10 LOCATION:  smgrsync, smgr.c:888
2006-10-23 17:48:10 LOG:  00000: duration: 327.999 ms  statement: SELECT 
threads.*, first.login AS first_user, last.login AS last_user FROM 
forum.threads JOIN users.users AS first ON first.id = threads.t_first_user 
LEFT JOIN users.users AS last ON last.id = threads.t_last_user WHERE t_b_id 
= 4 AND t_status_deleted = false ORDER BY t_status_sticky DESC, t_last_post 
DESC
2006-10-23 17:48:10 LOCATION:  exec_simple_query, postgres.c:1007
2006-10-23 17:48:14 LOG:  00000: could not rename file 
"pg_xlog/00000001000000040000002E" to "pg_xlog/000000010000000400000037", 
continuing to try
2006-10-23 17:48:14 LOCATION:  pgrename, dirmod.c:142
2006-10-23 18:12:05 LOG:  00000: received fast shutdown request
2006-10-23 18:12:05 LOCATION:  pmdie, postmaster.c:1903
2006-10-23 18:12:05 LOG:  00000: aborting any active transactions
2006-10-23 18:12:05 LOCATION:  pmdie, postmaster.c:1910
2006-10-23 18:12:05 FATAL:  57P01: terminating connection due to 
administrator command
2006-10-23 18:12:05 LOCATION:  ProcessInterrupts, postgres.c:2465
2006-10-23 18:12:06 ERROR:  XX000: could not rename file 
"pg_xlog/00000001000000040000002E" to "pg_xlog/000000010000000400000037" 
(initialization of log file 4, segment 55): A blocking operation was 
interrupted by a call to WSACancelBlockingCall.
2006-10-23 18:12:06 LOCATION:  InstallXLogFileSegment, xlog.c:2201
{...}

from 17:48:14 on pgsql didn't handle anymore queries until shutdown. as soon 
as one restarts postmaster, the file locks are cleared up.

and no, there are no other file locking tools (av scanners and the such) 
running - 8.1 on the same box (even on same partition) run fine.

regarnds,
- thomas




----- Original Message ----- 
From: "Thomas H." <me(at)alternize(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Monday, October 23, 2006 11:52 AM
Subject: Re: [BUGS] BUG #2712: could not fsync segment: Permission denied


> unfortunately not. and this is not happening with 8.1
>
> regards,
> thomas
>
> ----- Original Message ----- 
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: "Thomas H" <me(at)alternize(dot)com>
> Cc: <pgsql-bugs(at)postgresql(dot)org>
> Sent: Monday, October 23, 2006 4:07 AM
> Subject: Re: [BUGS] BUG #2712: could not fsync segment: Permission denied
>
>
>> "Thomas H" <me(at)alternize(dot)com> writes:
>>> Operating system:   windows 2003 standard
>>> Description:        could not fsync segment: Permission denied
>>
>> The usual answer to this has been that you're running some
>> overenthusiastic antivirus software.
>>
>> regards, tom lane
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
> 



In response to

Responses

pgsql-bugs by date

Next:From: Peter BrantDate: 2006-10-23 16:42:39
Subject: Re: BUG #2712: could not fsync segment: Permission
Previous:From: Kresimir TonkovicDate: 2006-10-23 14:31:54
Subject: Re: Hanging locks?

pgsql-patches by date

Next:From: Peter BrantDate: 2006-10-23 16:42:39
Subject: Re: BUG #2712: could not fsync segment: Permission
Previous:From: Thomas H.Date: 2006-10-23 09:52:58
Subject: Re: BUG #2712: could not fsync segment: Permission denied

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