On Wed, Dec 16, 2015 at 9:48 PM, Victor Blomqvist <vb@xxxxxxxx> wrote: > 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. Step #1: Install 9.3.10 on both servers. If the issue is still then reproducing, then this problem gets a lot more interesting. Are you running with checksums on? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
