Help with SI buffer overflow error

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Help with SI buffer overflow error
Date: 2001-06-29 15:34:17
Message-ID: 000901c100b0$f58a9a30$040a0a0a@ctlno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, I have a nightly cron script that runs: vacuumdb -a -z. The output
of the cron script is emailed to me every night. For the last several
weeks, about 50% of the time I get the following error at least once but
sometimes more:

NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset

I am wondering if this is just something that will happen sometimes, or if
it implies some type of problem. I have not noticed any problems in using
the system. Any input would be appreciated.

I am running PG7.0.3 from RPMs (I plan on upgrading to 7.1.2 soon) on RedHat
7.0, 800Mhz Athlon w/ 256M. Most of the databases are reasonably small (a
few Meg) but some of them are over 1Gig.

The Postmaster command is: /usr/bin/postmaster -i -B 5000 -N 48 -o -S 16384

The output of the vacuum command looks like:

Vacuuming template1
VACUUM
... < Several more databases > ...
Vacuuming postgres
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
VACUUM
Vacuuming jpplanning
VACUUM
... < Several more databases> ...
Vacuuming OEA
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
VACUUM
Vacuuming nutil
VACUUM
Vacuuming feedback
VACUUM
Vacuuming ctlno
VACUUM
0.21user 0.08system 21:37.58elapsed 0%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (5074major+1093minor)pagefaults 0swaps

Matt O'Connor

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2001-06-29 15:51:11 Re: Configuration of statistical views
Previous Message Thomas Lockhart 2001-06-29 15:06:19 Re: Postgres to Dia UML