[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

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:18.973 MSK

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 maxim.bo...@gmail.com wrote: I have kept all that database files for the future investigation. What I should look into first? Could you reproduce the error with

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 that

[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

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 t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com 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

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 the

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 attach to

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

2012-08-21 Thread Tom Lane
Alvaro Herrera alvhe...@2ndquadrant.com 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?)

Re: [BUGS] Database crash in Postgres 8.4.3

2012-08-21 Thread Tom Lane
Freddie Burgess fburg...@radiantblue.com 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

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 t...@sss.pgh.pa.us 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

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 and...@2ndquadrant.comwrote: 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

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 maxim.bo...@gmail.com wrote: On Wed, Aug 22, 2012 at 6:08 AM, Andres Freund and...@2ndquadrant.comwrote: 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,