Обсуждение: Random order of archiving files

Hi All,<br /><br />   Can this random order in archival of files be explained?<br /><br />grep archived
/var/log/localmessages<br/><br />2008-05-23 08:43:43 PDTLOG:  archived transaction log file
"00000001000009BD0000009D"<br/> 2008-05-23 08:44:41 PDTLOG:  archived transaction log file "00000001000009BD000000A0" 
<-----9D and 9F archived much later<br />2008-05-23 08:45:01 PDTLOG:  archived transaction log file
"00000001000009BD000000A1"<br/> 2008-05-23 08:46:00 PDTLOG:  archived transaction log file
"00000001000009BD000000A4"<br/>2008-05-23 08:46:26 PDTLOG:  archived transaction log file "00000001000009BD0000006C"<br
/>2008-05-2308:46:29 PDTLOG:  archived transaction log file "00000001000009BD00000069"<br /> 2008-05-23 08:46:32
PDTLOG: archived transaction log file "00000001000009BD0000006D"<br />2008-05-23 08:46:33 PDTLOG:  archived transaction
logfile "00000001000009BD00000071"<br />2008-05-23 08:46:34 PDTLOG:  archived transaction log file
"00000001000009BD00000073"<br/> 2008-05-23 08:46:35 PDTLOG:  archived transaction log file
"00000001000009BD00000074"<br/>2008-05-23 08:46:38 PDTLOG:  archived transaction log file "00000001000009BD00000075"<br
/>2008-05-2308:46:41 PDTLOG:  archived transaction log file "00000001000009BD00000076"<br /> 2008-05-23 08:46:42
PDTLOG: archived transaction log file "00000001000009BD00000077"<br />2008-05-23 08:46:43 PDTLOG:  archived transaction
logfile "00000001000009BD0000007A"<br />2008-05-23 08:46:49 PDTLOG:  archived transaction log file
"00000001000009BD0000007B"<br/> 2008-05-23 08:46:52 PDTLOG:  archived transaction log file
"00000001000009BD0000007D"<br/>2008-05-23 08:46:53 PDTLOG:  archived transaction log file "00000001000009BD0000007F"<br
/>2008-05-2308:46:54 PDTLOG:  archived transaction log file "00000001000009BD000000A7"  <--- chain broken here
again...<br/> 2008-05-23 08:47:59 PDTLOG:  archived transaction log file "00000001000009BD000000AA"<br />2008-05-23
08:48:21PDTLOG:  archived transaction log file "00000001000009BD000000AB"<br />2008-05-23 08:49:33 PDTLOG:  archived
transactionlog file "00000001000009BD000000AD"<br /> 2008-05-23 08:50:30 PDTLOG:  archived transaction log file
"00000001000009BD000000AE"<br/>2008-05-23 08:52:30 PDTLOG:  archived transaction log file "00000001000009BD000000AF"<br
/>2008-05-2308:54:30 PDTLOG:  archived transaction log file "00000001000009BD000000B0"<br /> 2008-05-23 08:55:42
PDTLOG: archived transaction log file "00000001000009BD000000B1"<br />2008-05-23 08:57:39 PDTLOG:  archived transaction
logfile "00000001000009BD000000B2"<br />2008-05-23 08:59:27 PDTLOG:  archived transaction log file
"00000001000009BD000000B3"<br/> 2008-05-23 09:01:26 PDTLOG:  archived transaction log file
"00000001000009BD00000085"<br/>2008-05-23 09:01:27 PDTLOG:  archived transaction log file "00000001000009BD00000080"<br
/>2008-05-2309:01:28 PDTLOG:  archived transaction log file "00000001000009BD00000081"<br /> 2008-05-23 09:01:29
PDTLOG: archived transaction log file "00000001000009BD00000086"<br />2008-05-23 09:01:30 PDTLOG:  archived transaction
logfile "00000001000009BD00000088"<br />2008-05-23 09:01:34 PDTLOG:  archived transaction log file
"00000001000009BD00000089"<br/> 2008-05-23 09:01:37 PDTLOG:  archived transaction log file
"00000001000009BD0000008C"<br/>2008-05-23 09:01:38 PDTLOG:  archived transaction log file "00000001000009BD0000008F"<br
/>2008-05-2309:01:39 PDTLOG:  archived transaction log file "00000001000009BD00000090"<br /> 2008-05-23 09:01:42
PDTLOG: archived transaction log file "00000001000009BD00000091"<br />2008-05-23 09:01:46 PDTLOG:  archived transaction
logfile "00000001000009BD00000093"<br />2008-05-23 09:01:47 PDTLOG:  archived transaction log file
"00000001000009BD00000094"<br/> 2008-05-23 09:01:48 PDTLOG:  archived transaction log file
"00000001000009BD00000095"<br/>2008-05-23 09:01:52 PDTLOG:  archived transaction log file "00000001000009BD00000097"<br
/>2008-05-2309:01:54 PDTLOG:  archived transaction log file "00000001000009BD00000099"<br /> 2008-05-23 09:01:55
PDTLOG: archived transaction log file "00000001000009BD0000009A"<br />2008-05-23 09:01:56 PDTLOG:  archived transaction
logfile "00000001000009BD0000009B"<br />2008-05-23 09:01:57 PDTLOG:  archived transaction log file
"00000001000009BD0000009C"<br/> 2008-05-23 09:01:58 PDTLOG:  archived transaction log file
"00000001000009BD0000009E"<br/>2008-05-23 09:01:59 PDTLOG:  archived transaction log file "00000001000009BD0000009F"<br
/>2008-05-2309:02:01 PDTLOG:  archived transaction log file "00000001000009BD000000A2"<br /> 2008-05-23 09:02:04
PDTLOG: archived transaction log file "00000001000009BD000000A3"<br />2008-05-23 09:02:06 PDTLOG:  archived transaction
logfile "00000001000009BD000000A5"<br />2008-05-23 09:02:06 PDTLOG:  archived transaction log file
"00000001000009BD000000B4" <--- continuing from where it left earlier!!!<br /> 2008-05-23 09:02:58 PDTLOG:  archived
transactionlog file "00000001000009BD000000B5"<br />2008-05-23 09:04:32 PDTLOG:  archived transaction log file
"00000001000009BD000000B6"<br/>2008-05-23 09:06:28 PDTLOG:  archived transaction log file "00000001000009BD000000B7"<br
/>2008-05-23 09:08:21 PDTLOG:  archived transaction log file "00000001000009BD000000B8"<br /><br clear="all" /><br
/>   I always assumed that the XLogs are generated in sequence. Apparently, the hot-standby server is expecting and
consumingthe XLogs in-order, and not in the order they are being generated here!<br /><br />Best regards,<br />-- <br
/>gurjeet[.singh]@EnterpriseDB.com<br/>singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com<br /><br
/>EnterpriseDB<a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br /><br />Mail sent from my
BlackLaptopdevice  

"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
>    Can this random order in archival of files be explained?

Maybe something wiped out the contents of the archive status
subdirectory?  If the .ready files all went away, the backends would
eventually recreate them, but possibly in a surprising order.
        regards, tom lane