> Ashley Clark <aclark@ghoti.org> writes:
> > Occasionally and without warning I get this from my daily vacuum
> > cronjob:
> > NOTICE: RegisterSharedInvalid: SI buffer overflow
> > NOTICE: InvalidateSharedInvalid: cache state reset
> > I don't understand what these mean. Should I be concerned about them
> > and what do they signify?
>
> No real need to worry. Those should've been downgraded to DEBUG-level
> messages a release or two back, but nobody bothered...
OK, Tom, I assume you are recommending the following changes. I will
apply the patch.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Index: src/backend/storage/ipc/sinval.c
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/storage/ipc/sinval.c,v
retrieving revision 1.29
diff -c -r1.29 sinval.c
*** src/backend/storage/ipc/sinval.c 2001/03/23 04:49:54 1.29
--- src/backend/storage/ipc/sinval.c 2001/05/07 17:16:56
***************
*** 91,97 ****
insertOK = SIInsertDataEntry(shmInvalBuffer, &newInvalid);
SpinRelease(SInvalLock);
if (!insertOK)
! elog(NOTICE, "RegisterSharedInvalid: SI buffer overflow");
}
/*
--- 91,97 ----
insertOK = SIInsertDataEntry(shmInvalBuffer, &newInvalid);
SpinRelease(SInvalLock);
if (!insertOK)
! elog(DEBUG, "RegisterSharedInvalid: SI buffer overflow");
}
/*
***************
*** 116,122 ****
if (getResult < 0)
{
/* got a reset message */
! elog(NOTICE, "InvalidateSharedInvalid: cache state reset");
resetFunction();
}
else
--- 116,122 ----
if (getResult < 0)
{
/* got a reset message */
! elog(DEBUG, "InvalidateSharedInvalid: cache state reset");
resetFunction();
}
else