| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: REINDEX and COPY is wainting since Jun 21! |
| Date: | 2012-07-27 17:26:09 |
| Message-ID: | 7685681.eManIEc7jQ@skynet.simkin.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday, July 27, 2012 11:59:49 AM Ing.Edmundo.Robles.Lopez wrote:
> Hi, i have postgres 8.3 running in SCO Openserver 5.0.7
>
> today, i had problems to start psql, the error mesage was: 'FATAL
> Memory out, Detail: Failed on resqueted size ...' , and after i checked
> the process i noticed the following:
>
> the elder REINDEX had been running since Jun-21 by 35 days 12 hrs
> (35-12:12:08) WTF!!!!
Well it looks like either the COPY or the VACUUM have been running since the
20th and are blocking the other processes. Is that a VACUUM FULL perhaps?
>
> Can i kill safely these process?
> there is any risk to corrupt the database???
I would use pg_cancel_backend() on them. Supposed to be safe, and I've never
had corruption issues.
--
When the Athenians finally wanted not to give to society but for society to
give to them, when the freedom they wished for most was freedom from
responsibility, then Athens ceased to be free and was never free again.” --
Edward Gibbon
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daoud Abdelmonem Faleh | 2012-07-27 17:35:00 | Re: BI tools and postgresql |
| Previous Message | Tom Lane | 2012-07-27 17:21:10 | Re: fgets failure in Solaris after patching |