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

2012-08-29 Thread Stuart Bishop
On Wed, Aug 29, 2012 at 10:59 PM, Andres Freund wrote: > On Wednesday, August 29, 2012 05:32:31 PM Stuart Bishop wrote: >> I believe I just hit this same issue, but with PG 9.1.3: >> >> <@:32407> 2012-08-29 10:02:09 UTC LOG: shutting down >> <@:32407> 2012-08-29 10:02:09 UTC LOG: database system

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

2012-08-29 Thread Andres Freund
On Wednesday, August 29, 2012 05:32:31 PM Stuart Bishop wrote: > I believe I just hit this same issue, but with PG 9.1.3: > > <@:32407> 2012-08-29 10:02:09 UTC LOG: shutting down > <@:32407> 2012-08-29 10:02:09 UTC LOG: database system is shut down > <[unknown]@[unknown]:31687> 2012-08-29 13:34:

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

2012-08-29 Thread Stuart Bishop
I believe I just hit this same issue, but with PG 9.1.3: <@:32407> 2012-08-29 10:02:09 UTC LOG: shutting down <@:32407> 2012-08-29 10:02:09 UTC LOG: database system is shut down <[unknown]@[unknown]:31687> 2012-08-29 13:34:03 UTC LOG: connection received: host=[local] <[unknown]@[unknown]:31687

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

2012-08-22 Thread Andres Freund
On Wednesday, August 22, 2012 12:08:25 PM Maxim Boguk wrote: > > > Does that mean that file was damaged during rsync? > > > > Not necessarily. When did you initially set up that cluster? Normally the > > file > > should get zeroed out before its being used. If the cluster was copied > > improperly

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

2012-08-22 Thread Maxim Boguk
> > Does that mean that file was damaged during rsync? > Not necessarily. When did you initially set up that cluster? Normally the > file > should get zeroed out before its being used. If the cluster was copied > improperly (i.e. no pg_start/stop backup or such) it could easily happen. > But > I wo

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

2012-08-22 Thread Andres Freund
Hi Maxim, On Wednesday, August 22, 2012 06:18:14 AM Maxim Boguk wrote: > 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 somethin

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 #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 #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