Re: Error while dropping a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error while dropping a table
Date: 2002-07-25 18:01:05
Message-ID: 19772.1027620065@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> NOTICE: RegisterSharedInvalid: SI buffer overflow

> I've never seen this before. What does it mean?

It's just an internal debugging message. (It should have been
downgraded to DEBUG level awhile ago, and was in 7.2.)

> Should I be concerned?

This suggests that you've got some other backend that's been sitting
in an open transaction for a long time. While that isn't directly
harmful, it'll probably be blocking VACUUM, so you might want to
figure out which client is holding the open transaction and zap it.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message vitorgv 2002-07-25 18:04:37 pg_group and pg_user
Previous Message Tom Jenkins 2002-07-25 17:39:19 Re: Getting a Database List