Re: [GENERAL] Strange notices, should I worry?

> 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