| Lists: | pgsql-hackers |
|---|
| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Invalid pages in WAL |
| Date: | 2008-12-17 15:07:35 |
| Message-ID: | 1229526455.4793.37.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
I've had a private report of these error messages in a test of Hot
Standby, but IMHO these aren't related to that patch. It seems more
likely to be related to the new VACUUM code? Certainly hot standby does
nothing to the normal flow of existing WAL records.
LOG: database system was interrupted; last known up at 2008-12-16
12:56:57 EST
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/655A68
LOG: record with zero length at 0/658150
LOG: redo done at 0/658080
WARNING: page 35 of relation base/11517/1249 did not exist
WARNING: page 32 of relation base/11517/1249 did not exist
WARNING: page 33 of relation base/11517/1249 did not exist
WARNING: page 34 of relation base/11517/1249 did not exist
PANIC: WAL contains references to invalid pages
The WAL record was destroyed before it could be analysed, so we can't do
much for now.
Ideas please?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Invalid pages in WAL |
| Date: | 2008-12-17 15:12:04 |
| Message-ID: | 494916C4.4050801@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Simon Riggs wrote:
> I've had a private report of these error messages in a test of Hot
> Standby, but IMHO these aren't related to that patch. It seems more
> likely to be related to the new VACUUM code? Certainly hot standby does
> nothing to the normal flow of existing WAL records.
>
> LOG: database system was interrupted; last known up at 2008-12-16
> 12:56:57 EST
> LOG: database system was not properly shut down; automatic recovery in
> progress
> LOG: redo starts at 0/655A68
> LOG: record with zero length at 0/658150
> LOG: redo done at 0/658080
> WARNING: page 35 of relation base/11517/1249 did not exist
> WARNING: page 32 of relation base/11517/1249 did not exist
> WARNING: page 33 of relation base/11517/1249 did not exist
> WARNING: page 34 of relation base/11517/1249 did not exist
> PANIC: WAL contains references to invalid pages
>
> The WAL record was destroyed before it could be analysed, so we can't do
> much for now.
Hmm, could well be related to the visibility map or FSM. Although those
messages suggest that it's a heap/index page that's missing, not FSM or
VM page. Any idea how to reproduce that?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Invalid pages in WAL |
| Date: | 2008-12-17 15:19:03 |
| Message-ID: | 1229527143.4793.40.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Wed, 2008-12-17 at 17:12 +0200, Heikki Linnakangas wrote:
> Hmm, could well be related to the visibility map or FSM. Although those
> messages suggest that it's a heap/index page that's missing, not FSM or
> VM page. Any idea how to reproduce that?
Regrettably, none. I will ask to see if the sequence of actions can be
repeated, but that may not get us anywhere.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
| Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Invalid pages in WAL |
| Date: | 2008-12-17 15:43:25 |
| Message-ID: | 87ej06n6xu.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> On Wed, 2008-12-17 at 17:12 +0200, Heikki Linnakangas wrote:
>
>> Hmm, could well be related to the visibility map or FSM. Although those
>> messages suggest that it's a heap/index page that's missing, not FSM or
>> VM page. Any idea how to reproduce that?
>
> Regrettably, none. I will ask to see if the sequence of actions can be
> repeated, but that may not get us anywhere.
This was with CVS HEAD?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Invalid pages in WAL |
| Date: | 2008-12-17 15:47:46 |
| Message-ID: | 1229528866.4793.59.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Wed, 2008-12-17 at 15:43 +0000, Gregory Stark wrote:
> Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
>
> > On Wed, 2008-12-17 at 17:12 +0200, Heikki Linnakangas wrote:
> >
> >> Hmm, could well be related to the visibility map or FSM. Although those
> >> messages suggest that it's a heap/index page that's missing, not FSM or
> >> VM page. Any idea how to reproduce that?
> >
> > Regrettably, none. I will ask to see if the sequence of actions can be
> > repeated, but that may not get us anywhere.
>
> This was with CVS HEAD?
Yes
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support