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

2014-06-30 Thread Amit Kapila
On Sat, Feb 15, 2014 at 1:26 PM, Amit Kapila wrote: > On Fri, Feb 14, 2014 at 8:27 AM, Bruce Momjian wrote: > > On Tue, Jan 7, 2014 at 12:33:33PM +0530, Amit Kapila wrote: > >> Still they have not told anything about other API's > >> (rmdir, RemoveDirectory) which has same problem. > > > > Wher

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

2014-02-17 Thread Craig Ringer
On 02/14/2014 10:57 AM, Bruce Momjian wrote: > On Tue, Jan 7, 2014 at 12:33:33PM +0530, Amit Kapila wrote: >> 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 >> suggestio

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

2014-02-14 Thread Amit Kapila
On Fri, Feb 14, 2014 at 8:27 AM, Bruce Momjian wrote: > On Tue, Jan 7, 2014 at 12:33:33PM +0530, Amit Kapila wrote: >> On Thu, Oct 31, 2013 at 8:58 AM, Amit Kapila wrote: >> > On Wed, Oct 16, 2013 at 1:44 AM, Amit Kapila >> > wrote: >> >> On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander >> >

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

2014-02-13 Thread Bruce Momjian
On Tue, Jan 7, 2014 at 12:33:33PM +0530, Amit Kapila wrote: > On Thu, Oct 31, 2013 at 8:58 AM, Amit Kapila wrote: > > On Wed, Oct 16, 2013 at 1:44 AM, Amit Kapila > > wrote: > >> On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander > >> wrote: > >>> On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas

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

2014-01-06 Thread Amit Kapila
On Thu, Oct 31, 2013 at 8:58 AM, Amit Kapila wrote: > On Wed, Oct 16, 2013 at 1:44 AM, Amit Kapila wrote: >> On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander wrote: >>> On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas wrote: On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane wrote: >> Well, that s

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

2013-10-30 Thread Amit Kapila
On Wed, Oct 16, 2013 at 1:44 AM, Amit Kapila wrote: > On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander wrote: >> On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas wrote: >>> On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane wrote: > Well, that sucks. So it's a Windows bug. >> >> I agree we'll probably

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

2013-10-15 Thread Amit Kapila
On Wed, Oct 16, 2013 at 2:04 AM, Robert Haas wrote: > On Tue, Oct 15, 2013 at 4:14 PM, Amit Kapila wrote: >> On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander wrote: >>> On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas wrote: On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane wrote: >> Well, that s

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

2013-10-15 Thread Robert Haas
On Tue, Oct 15, 2013 at 4:14 PM, Amit Kapila wrote: > On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander wrote: >> On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas wrote: >>> On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane wrote: > Well, that sucks. So it's a Windows bug. It's not clear to m

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

2013-10-15 Thread Amit Kapila
On Tue, Oct 15, 2013 at 6:28 PM, Magnus Hagander wrote: > On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas wrote: >> On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane wrote: Well, that sucks. So it's a Windows bug. >>> >>> It's not clear to me that we should do anything about this at all, >>> except p

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

2013-10-15 Thread Magnus Hagander
On Tue, Oct 15, 2013 at 2:55 PM, Robert Haas wrote: > On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane wrote: >>> Well, that sucks. So it's a Windows bug. >> >> It's not clear to me that we should do anything about this at all, >> except perhaps document that people should avoid long tablespace >> path

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

2013-10-15 Thread Robert Haas
On Mon, Oct 14, 2013 at 1:30 PM, Tom Lane wrote: >> Well, that sucks. So it's a Windows bug. > > It's not clear to me that we should do anything about this at all, > except perhaps document that people should avoid long tablespace > path names on an unknown set of Windows versions. We should not

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

2013-10-15 Thread Amit Kapila
On Mon, Oct 14, 2013 at 11:00 PM, Tom Lane wrote: > Robert Haas writes: >> On Thu, Oct 10, 2013 at 9:34 AM, Amit Kapila wrote: >>> On further analysis, I found that hang occurs in some of Windows >>> API(FindFirstFile, RemoveDirectroy) when symlink path >>> (pg_tblspc/spcoid/TABLESPACE_VERSION_D

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

2013-10-14 Thread Tom Lane
Robert Haas writes: > On Thu, Oct 10, 2013 at 9:34 AM, Amit Kapila wrote: >> On further analysis, I found that hang occurs in some of Windows >> API(FindFirstFile, RemoveDirectroy) when symlink path >> (pg_tblspc/spcoid/TABLESPACE_VERSION_DIRECTORY) is used in these >> API's. For above testcase,

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

2013-10-14 Thread Amit Kapila
On Mon, Oct 14, 2013 at 8:40 PM, Magnus Hagander wrote: > On Mon, Oct 14, 2013 at 2:28 PM, Robert Haas wrote: >> On Thu, Oct 10, 2013 at 9:34 AM, Amit Kapila wrote: >>> On further analysis, I found that hang occurs in some of Windows >>> API(FindFirstFile, RemoveDirectroy) when symlink path >>>

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

2013-10-14 Thread Magnus Hagander
On Mon, Oct 14, 2013 at 2:28 PM, Robert Haas wrote: > On Thu, Oct 10, 2013 at 9:34 AM, Amit Kapila wrote: >> On further analysis, I found that hang occurs in some of Windows >> API(FindFirstFile, RemoveDirectroy) when symlink path >> (pg_tblspc/spcoid/TABLESPACE_VERSION_DIRECTORY) is used in thes

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

2013-10-14 Thread Robert Haas
On Thu, Oct 10, 2013 at 9:34 AM, Amit Kapila wrote: > On further analysis, I found that hang occurs in some of Windows > API(FindFirstFile, RemoveDirectroy) when symlink path > (pg_tblspc/spcoid/TABLESPACE_VERSION_DIRECTORY) is used in these > API's. For above testcase, it will hang in path > dest