| From: | Mike Mascari <mascarm(at)mascari(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Eric Freeman <ejf7(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 7.3.3 drop table takes very long time |
| Date: | 2004-01-08 17:14:21 |
| Message-ID: | 3FFD8FED.3000900@mascari.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
>"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?
>
>
Is there any possibility that he's got an open transacation sitting out
there for days holding a lock on that table?
Mike Mascari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-08 17:16:49 | Re: 7.3.3 drop table takes very long time |
| Previous Message | Tom Lane | 2004-01-08 17:05:48 | Re: 7.3.3 drop table takes very long time |