Search Postgresql Archives

Re: REINDEX and COPY is wainting since Jun 21!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



thanks a lot for answer.
El 27/07/2012 12:26 p.m., Alan Hodgson escribió:
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?

No, is a vacuum analyze.

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.



I will try pg_cancel_backend(). By the way, i reproduced the fail on another database and tested with kill -2 and kill -9 and, the database entered into a database recovery mode.
El contenido de este correo electrónico y sus archivos adjuntos son privados y confidenciales y va dirigido exclusivamente a su destinatario.  No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de esta información por un receptor o entidades distintas al destinatario.  Si recibe este correo sin ser el destinatario se le solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicaciones no autorizadas o emitidas por personas ajenas a sus colaboradores utilizando éste medio electrónico.

The content of this email and its attached files are private and confidential and intended exclusively for the use of the individual or entity to which they are addressed. The retransmission, dissemination, or any other use of this information other than by the intended recipient is prohibited.  If you have received this email in error please delete it and notify the sender.  The company cannot be held liable for unauthorized electronic transmissions or communications, nor for those emitted by non-company individuals and entities.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux