Index contains unexpected zero page at block

From: Victor Blomqvist <vb(at)viblo(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Index contains unexpected zero page at block
Date: 2015-12-17 03:48:53
Message-ID: CAL870DVXR9fHkyEJ5sMydK4pJUPL5kWabUhSPbTQeK03gdDcqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From time to time I get this and similar errors in my Postgres log file:

< 2015-12-17 07:45:05.976 CST >ERROR: index
"user_pictures_picture_dhash_idx" contains unexpected zero page at block
123780
< 2015-12-17 07:45:05.976 CST >HINT: Please REINDEX it.
< 2015-12-17 07:45:05.976 CST >CONTEXT: PL/pgSQL function
select_pictures_by_dhash(bigint,integer,integer) line 3 at RETURN QUERY
< 2015-12-17 07:45:05.976 CST >STATEMENT: SELECT * FROM
select_pictures_by_dhash(8559245352688506666,100,0)

I have tried to recreate the index (create new index, drop the old one),
but it doesnt help, the error comes back anyway. Also, its not there all
the time, when I tried to rerun the statement from the logfile above a
couple of hours later it worked fine without any error.

The server is a read slave, set up with streaming replication. We run
PostgreSQL 9.3.5.

Is this anything I should be worried about, and if so, what can I do to fix
it? Will it be fixed with a newer version of Postgres?

Thanks!
Victor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-12-17 04:22:39 Re: Index contains unexpected zero page at block
Previous Message Stephen Frost 2015-12-17 03:29:03 Re: Check old and new tuple in row-level policy?