Skip site navigation (1) Skip section navigation (2)

warning message in standby

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: warning message in standby
Date: 2010-06-07 13:21:56
Message-ID: AANLkTilfIqLbLXZLEekVgBhfIun-VT_LLIMpWy5DB6ls@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

When an error is found in the WAL streamed from the master, a warning
message is repeated without interval forever in the standby. This
consumes CPU load very much, and would interfere with read-only queries.
To fix this problem, we should add a sleep into emode_for_corrupt_record()
or somewhere? Or we should stop walreceiver and retry to read WAL from
pg_xlog or the archive?

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Responses

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-06-07 13:35:10
Subject: Re: [COMMITTERS] pgsql: Add current WAL end (as seen by walsender, ie, GetWriteRecPtr()
Previous:From: Stephen FrostDate: 2010-06-07 12:56:21
Subject: Re: [PATCH] Fix leaky VIEWs for RLS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group