agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Paul M. Aoki <aoki@CS.Berkeley.EDU>
To: V.Grabner <zen@eka.gklw.co.at>
Cc: linux-postgres@native-ed.bc.ca
Cc: postgres-arch@postgres.Berkeley.EDU
Subject: Re: SIMarkEntryData cache state reset
Date: Fri, 03 Mar 95 14:18:11 -0800
Message-ID: <199503032218.OAA05918@faerie.CS.Berkeley.EDU> (raw)
In-Reply-To: <m0rkVP4-000I3jC@eka>

"V.Grabner" <zen@eka.gklw.co.at> writes:
> NOTICE   Mar  3 010834   SIMarkEntryData  cache state reset

this message is a NOTICE, which does not in itself cause an abort or a
core dump or anything.  this particular message simply means that the
Shared Invalidation buffer overflowed -- "too many" metadata (catalog)
updates occurred.  when a given backend makes a catalog update, it
places an invalidation message into a shared memory queue.  this queue
is read by the other servers when they commit their current
transaction and is used to invalidate entries in the internal system
metadata caches (e.g., pg_class and pg_attribute entries).  an
overflow means that everything will get invalidated and is typically
caused by one or more servers sitting too long without committing.

the other message (about the other backends exiting) is due to one or
more backends having dumped core.  the only way to know what happened
there is to fire up gdb.
--
  Paul M. Aoki          |  University of California at Berkeley
  aoki@CS.Berkeley.EDU  |  Dept. of EECS, Computer Science Division (#1776) 
                        |  Berkeley, CA 94720-1776

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: aoki@CS.Berkeley.EDU, zen@eka.gklw.co.at, linux-postgres@native-ed.bc.ca, postgres-arch@postgres.Berkeley.EDU
  Subject: Re: SIMarkEntryData cache state reset
  In-Reply-To: <199503032218.OAA05918@faerie.CS.Berkeley.EDU>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox