invalid page in block - Mailing list pgsql-admin

From Artem Tomyuk
Subject invalid page in block
Date
Msg-id CANYYVqJTgvaSA7Rto5RDwteMt07XDJ4MfLCNxQ8QGRYFoVExoQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hi.

Today slave exited with error

===========>16008   2016-02-14 02:42:53 EET XX001 [11-1]FATAL:  invalid page in block 35921 of relation base/69823/12792

===========>16008   2016-02-14 02:42:53 EET XX001 [12-1]CONTEXT:  xlog redo vacuum: rel 1663/69823/12792; blk 73837, lastBlockVacuumed 7360

===========>16005   2016-02-14 02:42:55 EET 00000 [4-1]LOG:  startup process (PID 16008) exited with exit code 1

===========>16005   2016-02-14 02:42:55 EET 00000 [5-1]LOG:  terminating any other active server processes

===========>31144   2016-02-14 08:54:04 EET 00000 [1-1]LOG:  database system was interrupted while in recovery at log time 2016-02-14 02:03:17 EET

===========>31144   2016-02-14 08:54:04 EET 00000 [2-1]HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.

What should i do?

From the message i see that is somehow connected with vacuum process?

I've added the zero_damaged_pages = on to conf, then started service.

For now replica is working with no errors.

Thanks!



pgsql-admin by date:

Previous
From: jaime soler
Date:
Subject: Re: Downgrade 9.2.13.28 to 9.2.8
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Error with libdir - PostgreSQL 9.2