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
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 |