| 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: | Whole Thread | Raw Message | 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
| 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 |