From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
Cc: | Johann Zuschlag <zuschlag(at)online(dot)de>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: SI buffer overflow, cache state reset |
Date: | 2002-04-13 01:14:11 |
Message-ID: | 200204130114.g3D1EB206220@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-13 06:05:54 | Re: Suggestions please: names for function cachabilityattributes |
Previous Message | Neil Conway | 2002-04-13 01:10:00 | Re: SI buffer overflow, cache state reset |