WAL contains references to invalid pages

From: JotaComm <jota(dot)comm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL contains references to invalid pages
Date: 2013-05-16 14:12:28
Message-ID: CAA8OQ6_jQ=gaH1gMuQkhoijuh1grQ0QyadJMTJke4kLo1_rvzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ioana Danes 2013-05-16 14:13:32 Re: Running out of memory at vacuum
Previous Message Jeff Janes 2013-05-16 13:56:07 Re: Running out of memory at vacuum