| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | "Booth, Robert" <Robert_Booth(at)intuit(dot)com> |
| Cc: | Pgsql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Lost Access To Table |
| Date: | 2002-06-04 19:30:46 |
| Message-ID: | Pine.LNX.4.21.0206042028120.2635-100000@ponder.fairway2k.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 4 Jun 2002, Booth, Robert wrote:
> I have a strange problem. I have lost the ability to query a table. Every
> time I try to query it the system just hangs. I can use psql to view the
> table and it's structure but I can't access any data. I've even tried to
> vacuum the table and I get the same hang. Is there anything else I should
> be looking to do?
It sounds like you should be worrying about your filesystem. When you kill
whatever process you're using to query the table presumably the associated
backend stays hanging around.
It'd be a good idea to make sure you have a back up and try rebuilding your
database on a different filesystem/machine.
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Snyder | 2002-06-04 19:32:29 | continual growth of pg_largeobjects and another table? |
| Previous Message | Booth, Robert | 2002-06-04 19:20:02 | Lost Access To Table |