Re: SI buffer overflow, cache state reset

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: "Johann Zuschlag" <zuschlag(at)online(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SI buffer overflow, cache state reset
Date: 2002-04-13 01:10:00
Message-ID: 20020412211000.79c0ca13.nconway@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-04-13 01:14:11 Re: SI buffer overflow, cache state reset
Previous Message Tom Lane 2002-04-13 00:27:56 Re: A *short* planner question