Re: 7.3.3 drop table takes very long time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Freeman" <ejf7(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.3.3 drop table takes very long time
Date: 2004-01-08 17:05:48
Message-ID: 11871.1073581548@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Eric Freeman" <ejf7(at)hotmail(dot)com> 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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2004-01-08 17:14:21 Re: 7.3.3 drop table takes very long time
Previous Message Richard Huxton 2004-01-08 16:52:05 Re: Queries taking a very long time