Wal contains references to invalid pages

From: JotaComm <jota(dot)comm(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Wal contains references to invalid pages
Date: 2013-06-03 14:19:26
Message-ID: CAA8OQ69em4-WH4VO0eyT2veB63c9d91ih3eD1ga4D6oDJkX5fQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, guys

Yesterday I identified the following messages in my log file (slave):

user=,db= WARNING: page 6629 of relation base/20449/24818 is uninitialized
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631,
lastBlockVacuumed 6626
user=,db= PANIC: WAL contains references to invalid pages
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631,
lastBlockVacuumed 6626
user=,db= LOG: startup process (PID 26293) was terminated by signal 6:
Aborted
user=,db= LOG: terminating any other active server processes

Information:

PostgreSQL 9.2.3 (master and slave)

Operational System: CentOS release 6.3 (Final)

The parameter full_page_writes is enabled in both servers.

Analyzing the objects in my cluster (master) I identified the database
[20449] and the relation [24818]. The relation 24818 is an index, so I ran
the command REINDEX to try solving the problem. Immediately after, I tried
to up the slave but I received the same errors.

user=,db= WARNING: page 6629 of relation base/20449/24818 is uninitialized
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631,
lastBlockVacuumed 6626
user=,db= PANIC: WAL contains references to invalid pages
user=,db= CONTEXT: xlog redo vacuum: rel 1663/20449/24818; blk 6631,
lastBlockVacuumed 6626
user=,db= LOG: startup process (PID 26293) was terminated by signal 6:
Aborted
user=,db= LOG: terminating any other active server processes

As the problem is in the wal file, so the process (above) doesn't work
according my wish.

Any idea?

Thanks a lot.

Regards

--
JotaComm
http://jotacomm.wordpress.com

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Lai 2013-06-03 16:45:09 VACUUM does not update pg_catalog.pg_stat_all_tables views
Previous Message Amit Langote 2013-06-03 14:16:18 Re: Steps to switch from Master to standby mode :