Search Postgresql Archives

WAL replay issue from 9.6.8 to 9.6.10

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

 



Hello, I'm seeing some issues with WAL replay on a test server running 9.6.10 using WAL archived from a 9.6.8 primary server. It reliably PANICs during replay with messages like so:

WARNING:  page 1209270272 of relation base/16422/47496599 does not exist
CONTEXT:  xlog redo at 4810/C84F8A0 for Btree/DELETE: 88 items
PANIC:  WAL contains references to invalid pages

This is after restoring from a snapshot that completed successfully as far as I can tell.

I downgraded the test server to 9.6.8 and I was able to replay WAL past the point where 9.6.10 would PANIC and crash. Curiously, 9.6.8 PANICed the first time, but then when I restarted it was able to replay through.

Should I expect this to just not work until the primary database is upgraded to 9.6.10? I'm a little wary to upgrade the primary at this point until I understand what might be going on.

thanks,
dave

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux