On Wed, Dec 11, 2019 at 04:06:26PM +0800, jiankang liu wrote: > During my use of PG, I encountered such errors "incorrect resource manager > data checksum in record at 0/5013730", > it will keeps printing this error message and never stops on standby > server，at same time, the walreceier process is lost. > Maybe disk problem, but also the line is operating system problems, leading > off the data disk error occurred.
An incorrect resource manager checksum points to the checksum of a record to be busted, because the full record has been read from disk, but it is failing a basic sanity check. That's basically a sign of corruption. Do you have data checksums enabled? If your WAL records are broken, you have unfortunately good chances of having problems in other areas of your data folder :( At this stage, it would be wiser to run diagnostics on your server, and be very careful with your chosen steps. Here are guidelines on the wiki: https://wiki.postgresql.org/wiki/Corruption -- Michael
signature.asc
Description: PGP signature
