Random order of archiving files

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "PGSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Random order of archiving files
Date: 2008-05-23 16:20:24
Message-ID: 65937bea0805230920r57a8efb3q316e06afc80b5755@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

Can this random order in archival of files be explained?

grep archived /var/log/localmessages

2008-05-23 08:43:43 PDTLOG: archived transaction log file
"00000001000009BD0000009D"
2008-05-23 08:44:41 PDTLOG: archived transaction log file
"00000001000009BD000000A0" <----- 9D and 9F archived much later
2008-05-23 08:45:01 PDTLOG: archived transaction log file
"00000001000009BD000000A1"
2008-05-23 08:46:00 PDTLOG: archived transaction log file
"00000001000009BD000000A4"
2008-05-23 08:46:26 PDTLOG: archived transaction log file
"00000001000009BD0000006C"
2008-05-23 08:46:29 PDTLOG: archived transaction log file
"00000001000009BD00000069"
2008-05-23 08:46:32 PDTLOG: archived transaction log file
"00000001000009BD0000006D"
2008-05-23 08:46:33 PDTLOG: archived transaction log file
"00000001000009BD00000071"
2008-05-23 08:46:34 PDTLOG: archived transaction log file
"00000001000009BD00000073"
2008-05-23 08:46:35 PDTLOG: archived transaction log file
"00000001000009BD00000074"
2008-05-23 08:46:38 PDTLOG: archived transaction log file
"00000001000009BD00000075"
2008-05-23 08:46:41 PDTLOG: archived transaction log file
"00000001000009BD00000076"
2008-05-23 08:46:42 PDTLOG: archived transaction log file
"00000001000009BD00000077"
2008-05-23 08:46:43 PDTLOG: archived transaction log file
"00000001000009BD0000007A"
2008-05-23 08:46:49 PDTLOG: archived transaction log file
"00000001000009BD0000007B"
2008-05-23 08:46:52 PDTLOG: archived transaction log file
"00000001000009BD0000007D"
2008-05-23 08:46:53 PDTLOG: archived transaction log file
"00000001000009BD0000007F"
2008-05-23 08:46:54 PDTLOG: archived transaction log file
"00000001000009BD000000A7" <--- chain broken here again...
2008-05-23 08:47:59 PDTLOG: archived transaction log file
"00000001000009BD000000AA"
2008-05-23 08:48:21 PDTLOG: archived transaction log file
"00000001000009BD000000AB"
2008-05-23 08:49:33 PDTLOG: archived transaction log file
"00000001000009BD000000AD"
2008-05-23 08:50:30 PDTLOG: archived transaction log file
"00000001000009BD000000AE"
2008-05-23 08:52:30 PDTLOG: archived transaction log file
"00000001000009BD000000AF"
2008-05-23 08:54:30 PDTLOG: archived transaction log file
"00000001000009BD000000B0"
2008-05-23 08:55:42 PDTLOG: archived transaction log file
"00000001000009BD000000B1"
2008-05-23 08:57:39 PDTLOG: archived transaction log file
"00000001000009BD000000B2"
2008-05-23 08:59:27 PDTLOG: archived transaction log file
"00000001000009BD000000B3"
2008-05-23 09:01:26 PDTLOG: archived transaction log file
"00000001000009BD00000085"
2008-05-23 09:01:27 PDTLOG: archived transaction log file
"00000001000009BD00000080"
2008-05-23 09:01:28 PDTLOG: archived transaction log file
"00000001000009BD00000081"
2008-05-23 09:01:29 PDTLOG: archived transaction log file
"00000001000009BD00000086"
2008-05-23 09:01:30 PDTLOG: archived transaction log file
"00000001000009BD00000088"
2008-05-23 09:01:34 PDTLOG: archived transaction log file
"00000001000009BD00000089"
2008-05-23 09:01:37 PDTLOG: archived transaction log file
"00000001000009BD0000008C"
2008-05-23 09:01:38 PDTLOG: archived transaction log file
"00000001000009BD0000008F"
2008-05-23 09:01:39 PDTLOG: archived transaction log file
"00000001000009BD00000090"
2008-05-23 09:01:42 PDTLOG: archived transaction log file
"00000001000009BD00000091"
2008-05-23 09:01:46 PDTLOG: archived transaction log file
"00000001000009BD00000093"
2008-05-23 09:01:47 PDTLOG: archived transaction log file
"00000001000009BD00000094"
2008-05-23 09:01:48 PDTLOG: archived transaction log file
"00000001000009BD00000095"
2008-05-23 09:01:52 PDTLOG: archived transaction log file
"00000001000009BD00000097"
2008-05-23 09:01:54 PDTLOG: archived transaction log file
"00000001000009BD00000099"
2008-05-23 09:01:55 PDTLOG: archived transaction log file
"00000001000009BD0000009A"
2008-05-23 09:01:56 PDTLOG: archived transaction log file
"00000001000009BD0000009B"
2008-05-23 09:01:57 PDTLOG: archived transaction log file
"00000001000009BD0000009C"
2008-05-23 09:01:58 PDTLOG: archived transaction log file
"00000001000009BD0000009E"
2008-05-23 09:01:59 PDTLOG: archived transaction log file
"00000001000009BD0000009F"
2008-05-23 09:02:01 PDTLOG: archived transaction log file
"00000001000009BD000000A2"
2008-05-23 09:02:04 PDTLOG: archived transaction log file
"00000001000009BD000000A3"
2008-05-23 09:02:06 PDTLOG: archived transaction log file
"00000001000009BD000000A5"
2008-05-23 09:02:06 PDTLOG: archived transaction log file
"00000001000009BD000000B4" <--- continuing from where it left earlier!!!
2008-05-23 09:02:58 PDTLOG: archived transaction log file
"00000001000009BD000000B5"
2008-05-23 09:04:32 PDTLOG: archived transaction log file
"00000001000009BD000000B6"
2008-05-23 09:06:28 PDTLOG: archived transaction log file
"00000001000009BD000000B7"
2008-05-23 09:08:21 PDTLOG: archived transaction log file
"00000001000009BD000000B8"

I always assumed that the XLogs are generated in sequence. Apparently,
the hot-standby server is expecting and consuming the XLogs in-order, and
not in the order they are being generated here!

Best regards,
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yoshiyuki Asaba 2008-05-23 18:21:01 Re: WITH RECURSIVE patch V0.1
Previous Message Tom Lane 2008-05-23 13:20:21 Re: How embarrassing: optimization of a one-shot query doesn't work