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

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

2013-10-10 Thread Amit Kapila
One of the user's of PostgreSQL has reported that if tablespace path is long, it leads to hang and the hang is unbreakable. Simple testcase to reproduce hang is: a. initdb -D E:\WorkSpace\PostgreSQL\master\RM30253_Data\aa