Re: warm standby server stops doing checkpoints afterawhile
| От | Teodor Sigaev |
|---|---|
| Тема | Re: warm standby server stops doing checkpoints afterawhile |
| Дата | |
| Msg-id | 466017E1.7010602@sigaev.ru обсуждение исходный текст |
| Ответ на | Re: warm standby server stops doing checkpoints afterawhile ("Simon Riggs" <simon@2ndquadrant.com>) |
| Ответы |
Re: warm standby server stops doing checkpoints afterawhile
Re: warm standby server stops doing checkpointsafterawhile |
| Список | 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 по дате отправления: