Archiving skipped an xlog?

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: Raw Message | Whole Thread | 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

Browse pgsql-general by date

  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?