Search Postgresql Archives

Re: warm standby server stops doing checkpoints afterawhile

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux