Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-29 Thread Dave Peticolas
On Wed, Aug 29, 2018 at 1:50 PM Michael Paquier wrote: > On Wed, Aug 29, 2018 at 09:15:29AM -0700, Dave Peticolas wrote: > > Oh, perhaps I do, depending on what you mean by worker. There are a > couple > > of periodic processes that connect to the server to obtain metrics. Is > that > > what is t

Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-29 Thread Michael Paquier
On Wed, Aug 29, 2018 at 09:15:29AM -0700, Dave Peticolas wrote: > Oh, perhaps I do, depending on what you mean by worker. There are a couple > of periodic processes that connect to the server to obtain metrics. Is that > what is triggering this issue? In my case I could probably suspend them > unti

Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-29 Thread Dave Peticolas
On Wed, Aug 29, 2018 at 4:54 AM Michael Paquier wrote: > On Wed, Aug 29, 2018 at 08:31:50AM +0200, Alexander Kukushkin wrote: > > 2018-08-29 6:02 GMT+02:00 Dave Peticolas : > >> 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 prim

Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-29 Thread Michael Paquier
On Wed, Aug 29, 2018 at 08:31:50AM +0200, Alexander Kukushkin wrote: > 2018-08-29 6:02 GMT+02:00 Dave Peticolas : >> 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 lik

Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-28 Thread Alexander Kukushkin
Hi, 2018-08-29 6:02 GMT+02:00 Dave Peticolas : > 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

Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-28 Thread Andreas Kretschmer
On 29 August 2018 06:26:06 CEST, Dave Peticolas wrote: >On Tue, Aug 28, 2018 at 9:21 PM Andreas Kretschmer > >wrote: > >> On 29 August 2018 06:02:45 CEST, Dave Peticolas >wrote: >> >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

Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-28 Thread Dave Peticolas
On Tue, Aug 28, 2018 at 9:21 PM Andreas Kretschmer wrote: > On 29 August 2018 06:02:45 CEST, Dave Peticolas wrote: > >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 > > > > Can you tell us the wal-level

Re: WAL replay issue from 9.6.8 to 9.6.10

2018-08-28 Thread Andreas Kretschmer
On 29 August 2018 06:02:45 CEST, Dave Peticolas wrote: >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 > Can you tell us the wal-level? Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company

WAL replay issue from 9.6.8 to 9.6.10

2018-08-28 Thread Dave Peticolas
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 Btr