Обсуждение: BUG #13968: invalid page in block error

The following bug has been logged on the website:

Bug reference:      13968
Logged by:          Jeff Frost
Email address:      jeff@pgexperts.com
PostgreSQL version: 9.4.5
Operating system:   Ubuntu 14.04
Description:

We ran into this error on 9.4.5 this morning:

2016-02-17 03:32:49.598
GMT,"procore_db","procore",22743,"10.232.0.19:59846",56c3df6e.58d7,3,"UPDATE",2016-02-17
02:48:14 GMT,276/1452926,4123653835,ERROR,XX001,"invalid page in block
185809 of relation base/16477/7324724",,
,,,,"update meetings set vectors = setweight( to_tsvector(coalesce(title,'')
|| ' ' || coalesce(location,'') || ' ' || coalesce(minutes,'') || ' ' ||
coalesce(overview,'') || ' ' || coalesce(conclusion,'') || ' ' || coalesce
(array_to_string(array(
       select
               coalesce(title, '') || ' ' ||
               coalesce(description, '') || ' ' ||
               coalesce(status, '') || ' ' ||
               coalesce(minutes, '')
             from meeting_topics
             where
               meeting_topics.meeting_id = meetings.id
          ), ' '),'')),'A') where meetings.id =
287295",,,"/usr/local/rbenv/versions/2.2.3/bin/rake"

As far as we can tell, there was no filesystem corruption.

Fortunately, we were able to dump the table and restore it, but thought we
would report upstream since this is the first corruption I've seen on 9.4.
Unfortunately, that means there's probably no useful forensics we can do at
this point.

jeff@pgexperts.com writes:
> We ran into this error on 9.4.5 this morning:

> 2016-02-17 03:32:49.598
> GMT,"procore_db","procore",22743,"10.232.0.19:59846",56c3df6e.58d7,3,"UPDATE",2016-02-17
> 02:48:14 GMT,276/1452926,4123653835,ERROR,XX001,"invalid page in block
> 185809 of relation base/16477/7324724",,

Probably not much we can do with this amount of info ... but I wonder if
you identified which relation that was (table? index?)

            regards, tom lane

> On Feb 17, 2016, at 8:37 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> jeff@pgexperts.com writes:
>> We ran into this error on 9.4.5 this morning:
>=20
>> 2016-02-17 03:32:49.598
>> =
GMT,"procore_db","procore",22743,"10.232.0.19:59846",56c3df6e.58d7,3,"UPDA=
TE",2016-02-17
>> 02:48:14 GMT,276/1452926,4123653835,ERROR,XX001,"invalid page in =
block
>> 185809 of relation base/16477/7324724",,
>=20
> Probably not much we can do with this amount of info ... but I wonder =
if
> you identified which relation that was (table? index?)

It was actually a toast table.=