Re: [BUGS] BUG #4961: pg_standby.exe crashes with no args

2009-08-03 Thread Fujii Masao
Hi, On Mon, Aug 3, 2009 at 9:18 PM, wrote: > also clashes when run with recovery.conf, > after logged message below. > > could not restore file "0001.history" from archive: return code > -1073741811 Does pg_standby (e.g., pg_standby.exe --version) succeed when you execute it alone? If not, y

Re: [BUGS] fix: plpgsql: return query and dropped columns problem

2009-08-03 Thread Pavel Stehule
There is fixed patch. Please, Jaime, can you look on it? Thank You Pavel 2009/7/30 Tom Lane : > Jaime Casanova writes: >>> On Mon, Jul 20, 2009 at 10:09 AM, Alvaro Getting rid of the check on natts was "ungood" ... it needs to compare the number of undropped columns of both tupdescs. >

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-08-03 Thread Nikhil Sontakke
Hi, > > Maybe. I'm unsure if it's enough to just try another > WaitForSingleObjectEx() on it, or if we need to actually issue a > WSARecv() on it as well. Maybe it would be enough to just change the > INIFINTE on line 318 of socket.c to a fixed value. That will loop down >

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-08-03 Thread Magnus Hagander
On Mon, Aug 3, 2009 at 16:20, Nikhil Sontakke wrote: > Hi, > > > And this fact should lend credence to Alvaro's (as well as mine) > suspicions that it seems to be a Windows kernel issue. > > As a consequence, Magnus I was wondering if having a loop similar to > the WRITE han

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-08-03 Thread Nikhil Sontakke
Hi, And this fact should lend credence to Alvaro's (as well as mine) suspicions that it seems to be a Windows kernel issue. As a consequence, Magnus I was wondering if having a loop similar to the WRITE handling of waiting for a fixed timeout in a loop (rather th

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-08-03 Thread Magnus Hagander
On Mon, Aug 3, 2009 at 16:12, Nikhil Sontakke wrote: > Hi, > > >> ntdll.dll!NtWaitForMultipleObjects+0xc >> kernel32.dll!WaitForMultipleObjectsEx+0x11a >> postgres.exe!pgwin32_waitforsinglesocket+0x1ed >> postgres.exe!pgwin32_recv+0x90 >> postgres.exe!PgstatCollectorMain+0x1

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-08-03 Thread Nikhil Sontakke
Hi, > ntdll.dll!NtWaitForMultipleObjects+0xc > kernel32.dll!WaitForMultipleObjectsEx+0x11a > postgres.exe!pgwin32_waitforsinglesocket+0x1ed > postgres.exe!pgwin32_recv+0x90 > postgres.exe!PgstatCollectorMain+0x17f > postgres.exe!SubPostmasterMain+0x33a > postgres.e

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-08-03 Thread Magnus Hagander
On Mon, Aug 3, 2009 at 15:47, Nikhil Sontakke wrote: > Hi, > >>> >>> ntdll.dll!NtWaitForMultipleObjects+0xc kernel32.dll!WaitForMultipleObjectsEx+0x11a postgres.exe!pgwin32_waitforsinglesocket+0x1ed postgres.exe!pgwin32_recv+0x90 postgres.exe!PgstatCollectorMain+0x17f

[BUGS] BUG #4961: pg_standby.exe crashes with no args

2009-08-03 Thread
The following bug has been logged online: Bug reference: 4961 Logged by: Email address: wad...@jcom.home.ne.jp PostgreSQL version: 8.4.0 Operating system: Windows XP/2000 Description:pg_standby.exe crashes with no args Details: also clashes when run with recovery.c

Re: [BUGS] BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram

2009-08-03 Thread Nikhil Sontakke
Hi, >> >> >>> ntdll.dll!NtWaitForMultipleObjects+0xc >>> kernel32.dll!WaitForMultipleObjectsEx+0x11a >>> postgres.exe!pgwin32_waitforsinglesocket+0x1ed >>> postgres.exe!pgwin32_recv+0x90 >>> postgres.exe!PgstatCollectorMain+0x17f >>> postgres.exe!SubPostmasterMain+0x33a >>> postgres.exe!main+0x168