Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

tember 10, 2009 5:44 AM > Cc: Tom Lane; Luke Koops; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5038: WAL file is pending deletion > in pg_xlog folder, this interferes with WAL archiving. > > Heikki Linnakangas wrote: > > Tom Lane wrote: > >> Heikki Linnak

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Heikki Linnakangas wrote: > Tom Lane wrote: >> Heikki Linnakangas writes: >>> No, it's a backend that's holding the file open, with FILE_SHARE_DELETE. >> If that's the only case we care about covering, then rename might be >> enough. I was just wondering what it would take to solve the more >> ge

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Tom Lane wrote: > Heikki Linnakangas writes: >> No, it's a backend that's holding the file open, with FILE_SHARE_DELETE. > > If that's the only case we care about covering, then rename might be > enough. I was just wondering what it would take to solve the more > general problem of something hol

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Heikki Linnakangas writes: > No, it's a backend that's holding the file open, with FILE_SHARE_DELETE. If that's the only case we care about covering, then rename might be enough. I was just wondering what it would take to solve the more general problem of something holding it open with the wrong

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Tom Lane wrote: > Luke Koops writes: >> Heikki is proposing that the file be renamed before it is first >> deleted. > > Indeed, and what I'm saying is that that will still fail if some > unhelpful program is holding the file open without FILE_SHARE_DELETE. > Which is what I understood yo

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

t: Re: [BUGS] BUG #5038: WAL file is pending deletion > in pg_xlog folder, this interferes with WAL archiving. > > Luke Koops writes: > > Heikki is proposing that the file be renamed before > it is first deleted. > > Indeed, and what I'm saying is that that will s

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Luke Koops writes: > Heikki is proposing that the file be renamed before it is first > deleted. Indeed, and what I'm saying is that that will still fail if some unhelpful program is holding the file open without FILE_SHARE_DELETE. Which is what I understood your case to be ...

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

.pa.us] > Sent: Wednesday, September 09, 2009 3:06 PM > To: Heikki Linnakangas > Cc: Luke Koops; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5038: WAL file is pending deletion > in pg_xlog folder, this interferes with WAL archiving. > > Heikki Linnakangas writes: >

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Heikki Linnakangas writes: > One option is to rename the file before deleting it. I was under the impression that renaming would fail in the same cases where deletion fails, ie something else holding the file open ... regards, tom lane -- Sent via pgsql-bugs mailing lis

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Luke Koops wrote: > For those of you who are still looking at this, I tried to reproduce the > issue by holding one of the WAL files open with another program (just opened > it with the cygwin build of less.exe for windows). That didn't do the trick. > It prevented unlink or rename from workin

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

gsql-bugs-ow...@postgresql.org > [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Luke Koops > Sent: Monday, September 07, 2009 4:30 PM > To: 'Tom Lane'; Heikki Linnakangas > Cc: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5038: WAL file is pending deletion

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

> -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Monday, September 07, 2009 1:17 PM > To: Heikki Linnakangas > Cc: Luke Koops; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5038: WAL file is pending deletion > in pg_xlog folder, thi

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Heikki Linnakangas writes: > Perhaps we should try to close the old WAL file sooner. There is zero hope of making that work. What we probably need to do is fix the code that scans pg_xlog so that it ignores files that are pending deletion. (I assume there's some way to find that out on Windows.

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Luke Koops wrote: > The following bug has been logged online: > > Bug reference: 5038 > Logged by: Luke Koops > Email address: luke.ko...@entrust.com > PostgreSQL version: 8.3.7 > Operating system: Windows 2003 Server Enterprise Edition > Description:WAL file is pendin

[BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

The following bug has been logged online: Bug reference: 5038 Logged by: Luke Koops Email address: luke.ko...@entrust.com PostgreSQL version: 8.3.7 Operating system: Windows 2003 Server Enterprise Edition Description:WAL file is pending deletion in pg_xlog folder, thi