upgrading to 7.0.2

Started by pgsql-generalover 25 years ago2 messagesgeneral
Jump to latest
#1pgsql-general
pgsql-general@fc.emc.com.ph

Hi!

I have just upgraded from 6.5.3 to 7.0.2.
sql dump and large objects (2,119 lobj) were restored.
When I tried to vacuum database, I got a "NOTICE"
message from those with large objects.

psql -c "vacuum analyze" applicationdata
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
VACUUM

psql -c "vacuum analyze" testdata
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
VACUUM

Is this something that I have to worry?
Anyway, it did not happen again the second time i did the vacuum.
Thanks.

Sherwin

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: pgsql-general (#1)
Re: upgrading to 7.0.2

"pgsql-general" <pgsql-general@fc.emc.com.ph> writes:

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

Is this something that I have to worry?

No. Those are just debugging messages, left over from a time when the
shared-inval messaging code wasn't too reliable. We should probably
take them out, or at least downgrade them to DEBUG messages ...

regards, tom lane