cache state reset - Mailing list pgsql-general

From David Lobron
Subject cache state reset
Date
Msg-id Pine.LNX.4.44.0209271206330.20303-100000@muppet.kendall.corp.akamai.com
Whole thread Raw
Responses Re: cache state reset  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How do i make use of listen/notify properly
Next
From: "Weaver, Walt"
Date:
Subject: Hey, where is Python.h ???