invalid page in block

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: invalid page in block
Date: 2016-02-14 07:08:50
Message-ID: CANYYVqJTgvaSA7Rto5RDwteMt07XDJ4MfLCNxQ8QGRYFoVExoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Browse pgsql-admin by date

  From Date Subject
Next Message drum.lucas@gmail.com 2016-02-14 20:21:07 Error with libdir - PostgreSQL 9.2
Previous Message jaime soler 2016-02-13 00:01:54 Re: Downgrade 9.2.13.28 to 9.2.8