Re: warm standby server stops doing checkpoints afterawhile

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Frank Wittig <fw(at)weisshuhn(dot)de>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: warm standby server stops doing checkpoints afterawhile
Date: 2007-06-01 12:58:09
Message-ID: 466017E1.7010602@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> <2007-06-01 13:11:29.365 CEST:%> DEBUG: 00000: Ressource manager (13)
>> has partial state information
> To me, this points clearly to there being an improperly completed action
> in resource manager 13. (GIN) In summary, it appears that there may be
> an issue with the GIN code for WAL recovery and this is effecting the
> Warm Standby.

Hmm. I found that gin_xlog_cleanup doesn't reset incomplete_splits list. Is it
possible reason of bug?

Attached patch fixes it.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

Attachment Content-Type Size
patch.txt text/plain 293 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Wittig 2007-06-01 13:21:31 Re: warm standby server stops doing checkpoints afterawhile
Previous Message Michael Glaesemann 2007-06-01 12:53:13 Re: Geographic data sources, queries and questions