Re: warm standby server stops doing checkpoints afterawhile - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: warm standby server stops doing checkpoints afterawhile
Date
Msg-id 466017E1.7010602@sigaev.ru
Whole thread Raw
In response to Re: warm standby server stops doing checkpoints afterawhile  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: warm standby server stops doing checkpoints afterawhile  (Frank Wittig <fw@weisshuhn.de>)
Re: warm standby server stops doing checkpointsafterawhile  ("Simon Riggs" <simon@2ndquadrant.com>)
List 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@sigaev.ru
                                                    WWW: http://www.sigaev.ru/
*** ./src/backend/access/gin/ginxlog.c.orig    Fri Jun  1 16:47:47 2007
--- ./src/backend/access/gin/ginxlog.c    Fri Jun  1 16:53:47 2007
***************
*** 594,599 ****
--- 594,600 ----

      MemoryContextSwitchTo(topCtx);
      MemoryContextDelete(opCtx);
+     incomplete_splits = NIL;
  }

  bool

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Geographic data sources, queries and questions
Next
From: Frank Wittig
Date:
Subject: Re: warm standby server stops doing checkpoints afterawhile