Re: SI buffer overflow, cache state reset

Neil Conway wrote:
> On Sat, 13 Apr 2002 01:56:52 +0200
> "Johann Zuschlag" <zuschlag(at)online(dot)de> wrote:
> > On Thu, 11 Apr 2002 23:58:03 +0200, Johann Zuschlag wrote:
> >
> > During restore I found following messages in the log:
>
> Your last message was just 26 hours ago, why not wait for people
> to answer you? If you're desperate to get an answer, the first thing
> I would do is search the list archives (which has numerous answers
> to your question).
>
> > ->DEBUG: SendSharedInvalidMessage: SI buffer overflow
> > ->DEBUG: ReceiveSharedInvalidMessages: cache state reset
> > (DEBUG: copy: line 4762, XLogWrite: new log file created - consider increasing WAL_FILES)
>
> You might want to consider following this advice...
>
> > (DEBUG: recycled transaction log file 000000000000000D)
> > (DEBUG: recycled transaction log file 000000000000000E)
> > ->DEBUG: ReceiveSharedInvalidMessages: cache state reset
> > ->DEBUG: ReceiveSharedInvalidMessages: cache state reset
> > ->DEBUG: ReceiveSharedInvalidMessages: cache state reset
> >
> > Never saw them before. It would be of some help to have a table of
> > certain error messages. Couldn't find any. The database seems to be ok.
>
> These are routine -- it's nothing to worry about. The fact that
> it is logged at level "DEBUG" indicates that it is informational,
> not an error message.

Actually, in 7.3, they will not even show because of the new GUC
server_min_messages levels. I see it now at DEBUG3, which will not
appear in the logs unless you set 7.3 server_min_messages = debug3 or
lower.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026