| From: | Kyotaro HORIGUCHI <kyota(dot)horiguchi(at)gmail(dot)com> |
|---|---|
| To: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
| Cc: | Amit Langote <amitlangote09(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Failing start-up archive recovery at Standby mode in PG9.2.4 |
| Date: | 2013-04-25 15:56:53 |
| Message-ID: | CAM103DtTF70Dr=F95h0LZhKFeHUS5J+ScUZj7xYFsa7cCb2k8g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Can you share the modified script, please?
Please find the attached files:
test.sh : test script. most significant change is the load.
I used simple insert instead of pgbench.
It might need some more adjustment for other environment
as my usual.
xlog.c.diff : Additional log output I thought to be useful to diagnose.
> I'm not sure I understand what the problem is, though. When the standby
> opens the bogus, recycled, file in pg_xlog, it will notice that the header
> is incorrect, and retry reading the file from the archive.
It looks the corrupted header only once. It continues to make retry
without looking there after that.
> Perhaps, but it should nevertheless not get confused by recycled segments.
regards, and good night.
--
Kyotaro Horiguchi
| Attachment | Content-Type | Size |
|---|---|---|
| promtest_20130426.tar.gz | application/x-gzip | 1.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2013-04-25 16:05:53 | Re: putting a bgworker to rest |
| Previous Message | Heikki Linnakangas | 2013-04-25 15:38:51 | Re: 9.3 Beta1 status report |