2015-05-22 6:55 GMT+02:00 Fujii Masao <masao.fujii@xxxxxxxxx>: > Thanks for the report! This seems to be a bug. > > This problem happens when WAL record is stored in separate two WAL files and > there is no valid latter WAL file in the standby. In your case, the former file > is 0000000400004C4D00000090 and the latter is 0000000400004C4D00000091. I've got bot files, when I've pg_xdumplog-ed them: $ cat dump1 0000000400004C4D00000090.dump ... rmgr: Heap2 len (rec/tot): 24/ 7772, tx: 0, lsn: 4C4D/90FF6DB8, prev 4C4D/90FF51E8, bkp: 1000, desc: clean: rel 1663/131438/10079072; blk 13843 remxid 472083193 rmgr: Heap2 len (rec/tot): 504/ 536, tx: 0, lsn: 4C4D/90FF8C30, prev 4C4D/90FF6DB8, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13843; cutoff xid 422325322 ntuples 40 rmgr: Heap2 len (rec/tot): 24/ 5632, tx: 0, lsn: 4C4D/90FF8E48, prev 4C4D/90FF8C30, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13844; cutoff xid 422325322 ntuples 30 rmgr: Heap2 len (rec/tot): 24/ 7528, tx: 0, lsn: 4C4D/90FFA460, prev 4C4D/90FF8E48, bkp: 1000, desc: clean: rel 1663/131438/10079072; blk 13845 remxid 472083193 rmgr: Heap2 len (rec/tot): 564/ 596, tx: 0, lsn: 4C4D/90FFC1E0, prev 4C4D/90FFA460, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13845; cutoff xid 422325322 ntuples 45 rmgr: Heap2 len (rec/tot): 24/ 5316, tx: 0, lsn: 4C4D/90FFC438, prev 4C4D/90FFC1E0, bkp: 1000, desc: clean: rel 1663/131438/10079072; blk 13846 remxid 472083193 rmgr: Heap2 len (rec/tot): 420/ 452, tx: 0, lsn: 4C4D/90FFD900, prev 4C4D/90FFC438, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13846; cutoff xid 422325322 ntuples 33 rmgr: Heap2 len (rec/tot): 24/ 7856, tx: 0, lsn: 4C4D/90FFDAC8, prev 4C4D/90FFD900, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13847; cutoff xid 422325322 ntuples 53 rmgr: Heap2 len (rec/tot): 20/ 52, tx: 0, lsn: 4C4D/90FFF990, prev 4C4D/90FFDAC8, bkp: 0000, desc: visible: rel 1663/131438/10079072; blk 13847 0000000400004C4D00000091.dump rmgr: Heap2 len (rec/tot): 600/ 632, tx: 0, lsn: 4C4D/910014A0, prev 4C4D/90FFF9C8, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13848; cutoff xid 422325322 ntuples 48 rmgr: Heap2 len (rec/tot): 24/ 6640, tx: 0, lsn: 4C4D/91001718, prev 4C4D/910014A0, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13849; cutoff xid 422325322 ntuples 42 rmgr: Heap2 len (rec/tot): 24/ 7848, tx: 0, lsn: 4C4D/91003120, prev 4C4D/91001718, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13850; cutoff xid 422325322 ntuples 36 rmgr: Heap2 len (rec/tot): 20/ 52, tx: 0, lsn: 4C4D/91004FE0, prev 4C4D/91003120, bkp: 0000, desc: visible: rel 1663/131438/10079072; blk 13850 rmgr: Heap2 len (rec/tot): 24/ 6208, tx: 0, lsn: 4C4D/91005018, prev 4C4D/91004FE0, bkp: 1000, desc: clean: rel 1663/131438/10079072; blk 13851 remxid 472083193 rmgr: Heap2 len (rec/tot): 564/ 596, tx: 0, lsn: 4C4D/91006870, prev 4C4D/91005018, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13851; cutoff xid 422325322 ntuples 45 rmgr: Heap2 len (rec/tot): 24/ 7340, tx: 0, lsn: 4C4D/91006AC8, prev 4C4D/91006870, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13852; cutoff xid 422325322 ntuples 39 rmgr: Heap2 len (rec/tot): 24/ 7744, tx: 0, lsn: 4C4D/91008790, prev 4C4D/91006AC8, bkp: 1000, desc: clean: rel 1663/131438/10079072; blk 13853 remxid 472083193 rmgr: Heap2 len (rec/tot): 492/ 524, tx: 0, lsn: 4C4D/9100A5E8, prev 4C4D/91008790, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13853; cutoff xid 422325322 ntuples 39 rmgr: Heap2 len (rec/tot): 24/ 7152, tx: 0, lsn: 4C4D/9100A7F8, prev 4C4D/9100A5E8, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13854; cutoff xid 422325322 ntuples 32 rmgr: Heap2 len (rec/tot): 24/ 7380, tx: 0, lsn: 4C4D/9100C400, prev 4C4D/9100A7F8, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13855; cutoff xid 422325322 ntuples 42 rmgr: Heap2 len (rec/tot): 24/ 6784, tx: 0, lsn: 4C4D/9100E0F0, prev 4C4D/9100C400, bkp: 1000, desc: clean: rel 1663/131438/10079072; blk 13856 remxid 472083193 rmgr: Heap2 len (rec/tot): 408/ 440, tx: 0, lsn: 4C4D/9100FB70, prev 4C4D/9100E0F0, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13856; cutoff xid 422325322 ntuples 32 rmgr: Heap2 len (rec/tot): 24/ 7312, tx: 0, lsn: 4C4D/9100FD28, prev 4C4D/9100FB70, bkp: 1000, desc: clean: rel 1663/131438/10079072; blk 13857 remxid 472083193 rmgr: Heap2 len (rec/tot): 432/ 464, tx: 0, lsn: 4C4D/910119D0, prev 4C4D/9100FD28, bkp: 0000, desc: freeze_page: rel 1663/131438/10079072; blk 13857; cutoff xid 422325322 ntuples 34 rmgr: Heap2 len (rec/tot): 24/ 7920, tx: 0, lsn: 4C4D/91011BA0, prev 4C4D/910119D0, bkp: 1000, desc: freeze_page: rel 1663/131438/10079072; blk 13858; cutoff xid 422325322 ntuples 60 ... I this is not enought, I can attach both files. -- Piotr Gasidło -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
