Skip site navigation (1) Skip section navigation (2)

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

From: Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7500: hot-standby replica crash after an initial rsync
Date: 2012-08-21 10:08:01
Message-ID: CAK-MWwQth6QSMb5OqZaov1uh1PfaGfV5EWiv+kHdqkuN4UQbvg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
> >
> >
> > 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 33950 @ from  [vxid: txid:0] []LOG:  00000:
database system was interrupted while in recovery at log time 2012-08-21
08:21:42 MSK
2012-08-21 14:04:18.973 MSK 33950 @ from  [vxid: txid:0] []HINT:  If this
has occurred more than once some data might be corrupted and you might need
to choose an earlier recovery target.
2012-08-21 14:04:18.973 MSK 33950 @ from  [vxid: txid:0] []LOCATION:
StartupXLOG, xlog.c:5757
2012-08-21 14:04:18.973 MSK 33950 @ from  [vxid: txid:0] []LOG:  00000:
creating missing WAL directory "pg_xlog/archive_status"
2012-08-21 14:04:18.973 MSK 33950 @ from  [vxid: txid:0] []LOCATION:
ValidateXLOGDirectoryStructure, xlog.c:3452
2012-08-21 14:04:19.009 MSK 33950 @ from  [vxid: txid:0] []LOG:  00000:
entering standby mode
2012-08-21 14:04:19.009 MSK 33950 @ from  [vxid: txid:0] []LOCATION:
StartupXLOG, xlog.c:5827
2012-08-21 14:04:19.041 MSK 33951 @ from  [vxid: txid:0] []LOG:  00000:
streaming replication successfully connected to primary
2012-08-21 14:04:19.041 MSK 33951 @ from  [vxid: txid:0] []LOCATION:
libpqrcv_connect, libpqwalreceiver.c:169
2012-08-21 14:04:20.140 MSK 33950 @ from  [vxid:1/0 txid:0] []LOG:  00000:
redo starts at 925/2C0004C8
2012-08-21 14:04:20.140 MSK 33950 @ from  [vxid:1/0 txid:0] []LOCATION:
StartupXLOG, xlog.c:6199
2012-08-21 14:04:20.160 MSK 33950 @ from  [vxid:1/0 txid:0] []FATAL:
XX000: could not access status of transaction 361788644
2012-08-21 14:04:20.161 MSK 33950 @ from  [vxid:1/0 txid:0] []DETAIL:
Could not read from file "pg_multixact/offsets/1590" at offset 114688:
Unknown error: 0.
2012-08-21 14:04:20.161 MSK 33950 @ from  [vxid:1/0 txid:0] []CONTEXT:
xlog redo create multixact 361788644 offset 822580965: 1768508061 1768508078
2012-08-21 14:04:20.161 MSK 33950 @ from  [vxid:1/0 txid:0] []LOCATION:
SlruReportIOError, slru.c:840
2012-08-21 14:04:20.169 MSK 33948 @ from  [vxid: txid:0] []LOG:  00000:
startup process (PID 33950) exited with exit code 1
2012-08-21 14:04:20.169 MSK 33948 @ from  [vxid: txid:0] []LOCATION:
LogChildExit, postmaster.c:2840
2012-08-21 14:04:20.169 MSK 33948 @ from  [vxid: txid:0] []LOG:  00000:
terminating any other active server processes
2012-08-21 14:04:20.169 MSK 33948 @ from  [vxid: txid:0] []LOCATION:
HandleChildCrash, postmaster.c:2674


Kind Regards,
Maksym

In response to

Responses

pgsql-bugs by date

Next:From: Maxim BogukDate: 2012-08-21 12:28:54
Subject: Re: BUG #7500: hot-standby replica crash after an initial rsync
Previous:From: Andres FreundDate: 2012-08-21 09:13:45
Subject: Re: BUG #7500: hot-standby replica crash after an initial rsync

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group