Re: root cause of corruption in hot standby

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



No I havent.  Not sure how to or what it would reveal but willing to give it a try.

On Wed, Oct 10, 2018 at 2:25 PM Andres Freund <andres@xxxxxxxxxxx> wrote:
Hi,

On 2018-09-06 12:28:18 -0500, Mike Broers wrote:
> So I have discovered corruption in a postgres 9.5.12 read replica, yay
> checksums!
>
> 2018-09-06 12:00:53 CDT [1563]: [4-1] user=postgres,db=production WARNING:
> page verification failed, calculated checksum 3482 but expected 32232
>
> 2018-09-06 12:00:53 CDT [1563]: [5-1] user=postgres,db=production ERROR:
> invalid page in block 15962 of relation base/16384/464832386

Have you compared whether that block looks significantly different on
the primary from the standby with a hex editor?

Greetings,

Andres Freund

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux