I found 'LOG, 00000, "incorrect resource manager data checksum in record at 5/2CEE6930' from the replica's log

From: cao(dot)wei56(at)zte(dot)com(dot)cn
To: pgsql-admin(at)postgresql(dot)org
Subject: I found 'LOG, 00000, "incorrect resource manager data checksum in record at 5/2CEE6930' from the replica's log
Date: 2015-11-26 06:55:03
Message-ID: OFA29AF159.ADE42C78-ON48257F09.00252AA4-48257F09.0025CCF8@zte.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I build a postgresql cluster with pgpool,I can synchronize data from
MasterDB to SlaveDB.

The replica DB's pglog has the following information:

2015-11-26 13:37:52.772 CST,,,48373,,5655ce2d.bcf5,522,,2015-11-25
23:05:17 CST,,0,LOG,00000,"recovery restart point at 5/2B3BDB28","last
completed transaction was at log time 2015-11-26
13:37:47.240807+08",,,,,,,,""
2015-11-26 13:40:32.880 CST,,,48373,,5655ce2d.bcf5,523,,2015-11-25
23:05:17 CST,,0,LOG,00000,"restartpoint starting: time",,,,,,,,,""
2015-11-26 13:43:02.090 CST,,,48373,,5655ce2d.bcf5,524,,2015-11-25
23:05:17 CST,,0,LOG,00000,"restartpoint complete: wrote 1517 buffers
(1.2%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=149.003 s, sync=0.077 s, total=149.209 s; sync files=49,
longest=0.029 s, average=0.001 s",,,,,,,,,""
2015-11-26 13:43:02.090 CST,,,48373,,5655ce2d.bcf5,525,,2015-11-25
23:05:17 CST,,0,LOG,00000,"recovery restart point at 5/2BAD3A50","last
completed transaction was at log time 2015-11-26
13:42:56.292062+08",,,,,,,,""
2015-11-26 13:45:32.199 CST,,,48373,,5655ce2d.bcf5,526,,2015-11-25
23:05:17 CST,,0,LOG,00000,"restartpoint starting: time",,,,,,,,,""
2015-11-26 13:47:05.785 CST,,,48372,,5655ce2d.bcf4,99,,2015-11-25 23:05:17
CST,1/0,0,LOG,00000,"incorrect resource manager data checksum in record at
5/2CEE6930",,,,,,,,,""
2015-11-26 13:47:05.786 CST,,,34260,,5656994b.85d4,2,,2015-11-26 13:31:55
CST,,0,FATAL,57P01,"terminating walreceiver process due to administrator
command",,,,,,,,,""
2015-11-26 13:47:05.904 CST,,,48372,,5655ce2d.bcf4,100,,2015-11-25
23:05:17 CST,1/0,0,LOG,00000,"record with zero length at
5/2CF17778",,,,,,,,,""
2015-11-26 13:47:05.918 CST,,,34909,,56569cd9.885d,1,,2015-11-26 13:47:05
CST,,0,LOG,00000,"started streaming WAL from primary at 5/2C000000 on
timeline 19",,,,,,,,,""
2015-11-26 13:48:02.073 CST,,,48373,,5655ce2d.bcf5,527,,2015-11-25
23:05:17 CST,,0,LOG,00000,"restartpoint complete: wrote 1489 buffers
(1.1%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=149.621 s, sync=0.092 s, total=149.873 s; sync files=47,
longest=0.036 s, average=0.001 s",,,,,,,,,""

Can you please advise what it means? Can it be ignored?

regards
--------------------------------------------------------
ZTE Information Security Notice: The information contained in this mail (and any attachment transmitted herewith) is privileged and confidential and is intended for the exclusive use of the addressee(s). If you are not an intended recipient, any disclosure, reproduction, distribution or other dissemination or use of the information contained is strictly prohibited. If you have received this mail in error, please delete it and notify us immediately.

Browse pgsql-admin by date

  From Date Subject
Next Message Mauricio Tavares 2015-11-26 14:10:05 Help environment mount with multimaster servers
Previous Message Terry Schmitt 2015-11-25 23:36:26 Re: How to store the PSQL command result into an array or Python dictionary?