Re: Errors in logs

From: Philip Molter <philip(at)datafoundry(dot)net>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Errors in logs
Date: 2001-07-18 14:16:08
Message-ID: 20010718091608.F10534@datafoundry.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 18, 2001 at 05:23:53PM +1000, Martijn van Oosterhout wrote:
: I'm getting these errors in my logs. they don't seem bad but I like to be
: sure:
:
: 010708.02:33:03.966 [2369] SIInsertDataEntry: table is 70% full, signaling postmaster
: 010708.02:33:03.966 [27400] pmdie 12
: 010708.02:33:03.991 [27400] SignalChildren: sending signal 12 to process 2369
: 010708.02:33:03.991 [27400] SignalChildren: sending signal 12 to process 24757
: 010708.02:33:03.991 [27400] SignalChildren: sending signal 12 to process 9657
: 010708.02:33:04.420 [9657] NOTICE: InvalidateSharedInvalid: cache state reset
: 010708.04:00:03.924 [2535] NOTICE: RegisterSharedInvalid: SI buffer overflow
: 010708.04:00:03.924 [2535] NOTICE: InvalidateSharedInvalid: cache state reset
: 010710.04:09:26.357 [18323] NOTICE: RegisterSharedInvalid: SI buffer overflow
: 010710.04:09:26.357 [18323] NOTICE: InvalidateSharedInvalid: cache state reset
: 010711.02:45:25.467 [25307] SIInsertDataEntry: table is 70% full, signaling post master
: 010711.02:45:25.467 [27400] pmdie 12
: 010711.02:45:25.523 [27400] SignalChildren: sending signal 12 to process 25307
: 010711.02:45:25.523 [27400] SignalChildren: sending signal 12 to process 22906
: 010711.02:45:25.523 [27400] SignalChildren: sending signal 12 to process 24757
: 010711.04:03:48.358 [25494] NOTICE: RegisterSharedInvalid: SI buffer overflow
: 010711.04:03:48.358 [25494] NOTICE: InvalidateSharedInvalid: cache state reset

For the record, I've seen the same errors at various times through the
use of our database, and it's almost always during vacuums (7.1.2).

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip(at)datafoundry(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janning Vygen 2001-07-18 14:17:41 Re: Re: PG rules! (RULES being the word ;->)
Previous Message Steve Werby 2001-07-18 13:02:37 Program to convert from PostgreSQL to Access or view table relationships