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
"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