| From: | hubert depesz lubaczewski <depesz(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Archiving skipped an xlog? |
| Date: | 2014-08-15 18:09:37 |
| Message-ID: | CAKrjmhdRcLbTCUs5twvPsnoDMdWUdrHzdoPbc1makB8=p4Vi+Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
we have weird situation today.
Pg 9.1.13, on ubuntu, on AWS.
At ~ 7am one of db servers stopped responding, and got restarted using AWS
console.
After reboot everything seemed to work fine.
But later on I found that one of the segments was not archived.
Segment ...7 was written (mtime of file in pg_xlog) at 6:51 (more or less)
Segment ...8 was written at 6:57
Segment ...9 was written at 7:13
then there were more.
What's interesting - in archive_status, i see .done files for all xlogs,
except for ...8. In logs the *8 xlog is not mentioned (I was looking for
error message or something).
The xlog didn't make it to destination or archiving, but instead of being
retried after reboot - pg moved to *9, and then continued.
I manually archived *8, and everythinh was fine afterwards, but I'm puzzled
on how could it happen that an xlog gets skipped? Even in case of
force-reboot.
Regards,
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | AlexK | 2014-08-15 20:52:44 | Missing objects in pg_dump |
| Previous Message | Terry Schmitt | 2014-08-15 17:00:51 | Re: Next steps in debugging database storage problems? |