Re: Long paths for tablespace leads to uninterruptible hang in Windows

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Long paths for tablespace leads to uninterruptible hang in Windows
Date: 2014-02-14 02:57:00
Message-ID: 20140214025700.GC3243@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 7, 2014 at 12:33:33PM +0530, Amit Kapila wrote:
> On Thu, Oct 31, 2013 at 8:58 AM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> > On Wed, Oct 16, 2013 at 1:44 AM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >> On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> >>> On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> >>>> On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >>>>>> Well, that sucks. So it's a Windows bug.
> >>>
> >>> I agree we'll probably want to work around it in the end, but I still
> >>> think it should be put to Microsoft PSS if we can. The usual - have we
> >>> actually produced a self-contained example that does just this (and
> >>> doesn't include the full postgres support) and submitted it to
> >>> *microsoft* for comments?
> >>
> >> I have written a self contained win32 console application with which
> >> the issue can be reproduced.
> >> The application project is attached with this mail.
> >
> > Logged a support ticket with Microsoft, they could reproduce the issue
> > with the sample application (it is same what I had posted on hackers
> > in this thread) and working on it.
>
> Further update on this issue:
>
> Microsoft has suggested a workaround for stat API. Their suggestion
> is to use 'GetFileAttributesEx' instead of stat, when I tried their
> suggestion, it also gives me same problem as stat.
>
> Still they have not told anything about other API's
> (rmdir, RemoveDirectory) which has same problem.

Where are we on this? Is there a check we should add in our code?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-02-14 03:50:33 Re: HBA files w/include support?
Previous Message Peter Eisentraut 2014-02-14 02:53:03 Re: Changeset Extraction v7.0 (was logical changeset generation)