Re: Strange replication problem - segment restored from archive but still requested from master

From: Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange replication problem - segment restored from archive but still requested from master
Date: 2015-05-22 08:12:51
Message-ID: CAF8akQtXWP5mSvwRaK_zMdKDMR4KBE7edzEd=iWzR2P1bhAHEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

2015-05-22 6:55 GMT+02:00 Fujii Masao <masao(dot)fujii(at)gmail(dot)com>:
> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2015-05-22 08:13:29 Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for?
Previous Message Piotr Gasidło 2015-05-22 08:08:35 Re: Strange replication problem - segment restored from archive but still requested from master

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2015-05-22 09:14:14 Re: Add a hint when postgresql.conf hot_standby = 'off' and recovery.conf standby = 'on'
Previous Message Piotr Gasidło 2015-05-22 08:08:35 Re: Strange replication problem - segment restored from archive but still requested from master