Обсуждение: Error while dropping a table

Howdy:

Running PostgreSQL 7.1.3 on RedHat Linux 2.4.7-10.

I'm doing a bit of housecleaning and after dropping a table,
I get this error:

[snip error]

testdb=> drop table db2_se_2002;
NOTICE:  RegisterSharedInvalid: SI buffer overflow
DROP
testdb=>

[/snip error]

I've never seen this before.  What does it mean?
Should I be concerned?

Thanks!

-X

"Johnson, Shaunn" <SJohnson6@bcbsm.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

Thanks for the reply:

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]

[snip rest of email]

--Okay, but now, how do I find out what client is holding
--the table hostage?  Generally, I would do something like
--'pg_query' and see what people are doing and against
--whatever table ... but it doesn't appear to be the case
--in this matter.

--Any particular method in finding this out?

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

--Thanks again!

-X

On Thu, Jul 25, 2002 at 02:04:56PM -0400, Johnson, Shaunn wrote:
>
> --Okay, but now, how do I find out what client is holding
> --the table hostage?  Generally, I would do something like

ps -auxww and look for something "idle in transaction" that's been
running a long time.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110