[HACKERS] Random order of archiving files

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[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device