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
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:
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
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
> > 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
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
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
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
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
>
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
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
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?
>>
>
> >
> >
> > 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:
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
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
15 matches
Mail list logo