| From: | Dave Peticolas <dave(at)krondo(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | WAL replay issue from 9.6.8 to 9.6.10 |
| Date: | 2018-08-29 04:02:45 |
| Message-ID: | CAPRbp06PWuV=NETrb_fDXatbTNJvS-v4L2MQwAn-u38Eipvg6g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2018-08-29 04:20:17 | Re: WAL replay issue from 9.6.8 to 9.6.10 |
| Previous Message | Tom Lane | 2018-08-28 20:51:51 | Re: archive items not in correct section order |