From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org> |
Cc: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Strange replication problem - segment restored from archive but still requested from master |
Date: | 2015-05-25 09:30:35 |
Message-ID: | CAECtzeUn1b=YAJweHqQoT7ATBzi7r3JyF2VuG8Qp-Ut2X=Mm4w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
2015-05-22 18:36 GMT+02:00 Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>:
> 2015-05-22 6:55 GMT+02:00 Fujii Masao <masao(dot)fujii(at)gmail(dot)com>:
> >
> > This problem happens when WAL record is stored in separate two WAL files
> and
> > there is no valid latter WAL file in the standby. In your case, the
> former file
> > is 0000000400004C4D00000090 and the latter is 0000000400004C4D00000091.
> >
> > In this case, the first half of WAL record can be read from the former
> WAL file,
> > but the remaining half not because no valid latter file exists in the
> standby.
> > Then the standby tries to retrieve the latter WAL file via replication.
> > The problem here is that the standby tries to start the replication from
> the
> > starting point of WAL record, i.e., that's the location of the former
> WAL file.
> > So the already-read WAL file is requested via replication.
> > (..)
>
> I currently have wal_keep_segments set to 0.
> Setting this to higher value will help? As I understand: master won't
> delete segment and could stream it to slave on request - so it will
> help.
>
It definitely helps, but the issue could still happen.
> Does this setting delays WAL archiving?
>
>
Nope. It delays recycling.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Medhavi Mahansaria | 2015-05-25 12:24:01 | Reg: BULK COLLECT |
Previous Message | twoflower | 2015-05-25 07:41:43 | Re: Server tries to read a different config file than it is supposed to |
From | Date | Subject | |
---|---|---|---|
Next Message | Colin 't Hart | 2015-05-25 09:32:04 | Re: Order of columns in query is important?! |
Previous Message | Colin 't Hart | 2015-05-25 09:26:49 | Order of columns in query is important?! |