Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Reply-To:	<ybaykshtis AT micropat DOT com>
From:	"Yurgis Baykshtis" <ybaykshtis AT micropat DOT com>
To:	<cygwin AT cygwin DOT com>
Subject:	readdir? problems in Postgres under Cygwin (leading to panic rename error)
Date:	Mon, 1 Dec 2003 11:26:54 -0800
Message-ID:	<000201c3b841$14dcb720$a5936e3f@aurigin.com>
MIME-Version:	1.0
X-Priority:	3 (Normal)
X-MSMail-Priority:	Normal
In-reply-to:	<AJEJLHAOIOFCBGHBFLLGGECMECAA.services@AndreasK.de>
Importance:	Normal
X-MimeOLE:	Produced By Microsoft MimeOLE V6.00.2800.1165

We've been experiencing a problem with Postgres on Cygwin.
The problem has not been reported by Unix/Linux
But I just received a confirmation that we are not alone and other
pg-on-cygwin folks having the same problem too.

Basically, the ending result of the problem is the panic transaction log
rename failure possibly because the file to be renamed is missing.

Here is the part of the discussion thread with Tom Lane with more details
about the problem.
http://archives.postgresql.org/pgsql-hackers/2003-11/msg01358.php

So, the problem is not in rename() function itself but in the fact that the
file is missing.
According to Tom, this is either due to readdir() issue (possibly returning
files previously deleted) or the LWLock code is not working properly under
Cygwin (which is quite unlikely because nothing else in PG would work
basically). So, the most likely reason is in readdir() function that
according to Tom "misbehaves if there are concurrent insert,
rename or delete operations carried out in the same directory"

Any help is greatly appreciated.








--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -