Re: [GENERAL] 7.3.3 drop table takes very long time

[Mike Mascari]

Tom Lane wrote:

"Eric Freeman" <[EMAIL PROTECTED]> writes:
 

I started the drop table command yesterday and it's been running for almost 
24 hours.
   

You're stuck in some kind of infinite loop --- there's no way that DROP
should take any noticeable amount of time.  I'm guessing that the system
catalog entries for this particular table are corrupted somehow, but no
idea just how.  It would be worth trying to track it down in case there
is a PG bug lurking.
Can you attach to the looping backend with a debugger and get a stack
trace for us?
 

Is there any possibility that he's got an open transacation sitting out 
there for days holding a lock on that table?

Mike Mascari



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])