Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Maxim Boguk
On Wed, Aug 22, 2012 at 1:50 PM, Maxim Boguk wrote: > > > On Wed, Aug 22, 2012 at 6:08 AM, Andres Freund wrote: > >> On Tuesday, August 21, 2012 03:30:44 PM Maxim Boguk wrote: >> > Hi Andres, >> >> I would add something akin to >> >> elog(WARNING, "pid of startup is: %d, sleeping for 10s", getpid

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Maxim Boguk
On Wed, Aug 22, 2012 at 6:08 AM, Andres Freund wrote: > On Tuesday, August 21, 2012 03:30:44 PM Maxim Boguk wrote: > > Hi Andres, > > I would add something akin to > > elog(WARNING, "pid of startup is: %d, sleeping for 10s", getpid()); > sleep(10); > Hi Andres, There is it: gdb backtrace: #0

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

2012-08-21 Thread Robert Haas
On Tue, Aug 21, 2012 at 4:30 PM, Tom Lane wrote: > Meanwhile, back at the ranch: I'm fine with applying that patch now that > it's had some field testing. Attached is a version that applies OK to 9.1, after resolving some conflicts. Review appreciated. It wasn't exactly clear to me how to handl

Re: [BUGS] Database crash in Postgres 8.4.3

2012-08-21 Thread Tom Lane
"Freddie Burgess" writes: > Late yesterday afternoon our DB server went down hard. we tried to re-start > and it went into recovery mode to recover transaction history and failed. Oh dear. I'll spare you the lecture about running up-to-date minor releases, because this doesn't seem to exactly m

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

2012-08-21 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Robert Haas's message of mar ago 21 14:54:28 -0400 2012: >> (BTW, I think commit 9b63e9869ffaa4d6d3e8bf45086a765d8f310f1c contains >> a thinko in one of the comments: shouldn't "a crock of the first >> water" be "a crock of the first order"?) > I was interes

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Andres Freund
On Tuesday, August 21, 2012 03:30:44 PM Maxim Boguk wrote: > Hi Andres, > > > > I have some problems with debug startup process with gdb... > > > > > I following next sequence of commands (and got no useful results): > > Youre debugging the postmaster that way. The easiest way would be to just >

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

2012-08-21 Thread Alvaro Herrera
Excerpts from Robert Haas's message of mar ago 21 14:54:28 -0400 2012: > (BTW, I think commit 9b63e9869ffaa4d6d3e8bf45086a765d8f310f1c contains > a thinko in one of the comments: shouldn't "a crock of the first > water" be "a crock of the first order"?) I was interested by that phrase when I saw

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

2012-08-21 Thread Robert Haas
On Tue, Aug 7, 2012 at 2:22 PM, Tom Lane wrote: > Robert Haas writes: >> We just had a customer hit a very similar problem on 9.1.3, running on >> Windows Server 2008 SP2. ... >> The customer finds that they can reproduce this on a variety of >> systems under heavy load. > >> Now, it looks to me

[BUGS] Database crash in Postgres 8.4.3

2012-08-21 Thread Freddie Burgess
Late yesterday afternoon our DB server went down hard. we tried to re-start and it went into recovery mode to recover transaction history and failed. Notable error was: FATAL: failed to re-find parent key in index "257969064" for split pages 8366/12375 If you look this error up, it indi

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Maxim Boguk
Hi Andres, > > I have some problems with debug startup process with gdb... > > I following next sequence of commands (and got no useful results): > Youre debugging the postmaster that way. The easiest way would be to just > attach to the startup process with gdb -p. Not sure if you can manage tha

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Andres Freund
Hi, On Tuesday, August 21, 2012 02:28:54 PM Maxim Boguk wrote: > On Tue, Aug 21, 2012 at 8:08 PM, Maxim Boguk wrote: > >> > I have kept all that database files for the future investigation. > >> > > >> > What I should look into first? > >> > >> Could you reproduce the error with log_error_verb

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Maxim Boguk
On Tue, Aug 21, 2012 at 8:08 PM, Maxim Boguk wrote: > > > >> > >> > I have kept all that database files for the future investigation. >> > >> > What I should look into first? >> Could you reproduce the error with log_error_verbosity=verbose? Or even >> better >> provide a backtrace with gdb? >> >

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Maxim Boguk
> > > > > > I have kept all that database files for the future investigation. > > > > What I should look into first? > Could you reproduce the error with log_error_verbosity=verbose? Or even > better > provide a backtrace with gdb? > > There log with log_error_verbosity=verbose: 2012-08-21 14:04:

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread Andres Freund
On Tuesday, August 21, 2012 10:08:11 AM maxim.bo...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 7500 > Logged by: Maxim Boguk > Email address: maxim.bo...@gmail.com > PostgreSQL version: 9.0.8 > Operating system: FreeBSD > Descriptio

[BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-21 Thread maxim . boguk
The following bug has been logged on the website: Bug reference: 7500 Logged by: Maxim Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 9.0.8 Operating system: FreeBSD Description: Hi, Reinitialization of the replica after failover is procedure performe