Re: [GENERAL] warm standby server stops doing checkpointsafterawhile

2007-06-01 Thread Dhaval Shah
I am following this thread with interest and hence as a request if the discussion is kept in this thread, is easier for me to follow it. Just recently I have put the WAL standby in production using 8.2.3 and would like to know the circumstances where I will need to upgrade. Hence the interest. R

Re: [GENERAL] warm standby server stops doing checkpointsafterawhile

2007-06-01 Thread Teodor Sigaev
<2007-06-01 16:28:51.708 CEST:%> LOG: GIN incomplete split root:8 l:45303 r:111740 at redo CA/C8243C28 ... <2007-06-01 16:38:23.133 CEST:%> LOG: GIN incomplete split root:8 l:45303 r:111740 at redo CA/C8243C28 Looks like a bug in GIN. I'll play with it. Can you provide more details a

Re: [GENERAL] warm standby server stops doing checkpointsafterawhile

2007-06-01 Thread Frank Wittig
Hi Simon, > The attached patch should show which of these it is. As I thought, I can trigger the issue by letting the database recreate and reindex some ten thousand data sets. Here is what happened in the log (I cleaned it to the lines your patch provides): <2007-06-01 16:28:51.708 CEST:%> LOG

Re: [GENERAL] warm standby server stops doing checkpointsafterawhile

2007-06-01 Thread Frank Wittig
Hi Simon, > The attached patch should show which of these it is. I'll dress it up a > little better so we have a debug option on this. Please note I've not > tested this patch myself, so Frank if you don't mind me splatting > something at you we'll see what we see. I'll test that. I have an idea

Re: [GENERAL] warm standby server stops doing checkpointsafterawhile

2007-06-01 Thread Simon Riggs
On Fri, 2007-06-01 at 16:58 +0400, Teodor Sigaev wrote: > >> <2007-06-01 13:11:29.365 CEST:%> DEBUG: 0: 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 appear