cache state reset

From: David Lobron <dlobron(at)akamai(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: cache state reset
Date: 2002-09-27 16:15:39
Message-ID: Pine.LNX.4.44.0209271206330.20303-100000@muppet.kendall.corp.akamai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I've recently begun seeing an unusually high number of error messages
from my database, of this type:

NOTICE: InvalidateSharedInvalid: cache state reset

I noticed in the archives that people have asked about this issue before,
but my case seems a bit different, in that my errors do not seem related
to any database vacuuming. Tom Lane noted in one of his archived replies
that these messages can sometimes be caused by applications with very long
database access times. I'm running a series of cron'ed Perl tools, each
of which opens a connection to Postgres for up to 5 minutes. Could this
be the problem? More generally: what is a cache state reset, and what
might trigger one?

Thank you very much in advance.

Sincerely,

David Lobron

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Morgan 2002-09-27 16:18:00 Re: Feature comparison between Postgresql, Oracle and Mysql ?
Previous Message Tom Lane 2002-09-27 15:50:58 Re: How do i make use of listen/notify properly