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
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 |