REINDEX and COPY is wainting since Jun 21!

From: "Ing(dot)Edmundo(dot)Robles(dot)Lopez" <erobles(at)sensacd(dot)com(dot)mx>
To: <pgsql-general(at)postgresql(dot)org>
Subject: REINDEX and COPY is wainting since Jun 21!
Date: 2012-07-27 16:59:49
Message-ID: 5012C905.60001@sensacd.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!!!!

Can i kill safely these process?
there is any risk to corrupt the database???

PPID PID STIME
499 19802 Jun-20 36-12:12:07 postgres: postgres databasefoo
127.0.0.1(4730) VACUUM
499 17203 Jun-20 36-14:42:40 postgres: postgres databasefoo
192.168.1.242(2350) COPY
499 17195 Jun-20 36-14:42:41 postgres: postgres databasefoo
192.168.1.242(2336) idle
13925 13927 Jun-21 35-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 13930 Jun-21 35-12:12:08 postgres: postgres databasefoo
127.0.0.1(4612) REINDEX waiting
7551 7553 Jun-22 34-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 7761 Jun-22 34-12:02:07 postgres: us405 databasefoo
192.168.1.244(3302) DELETE waiting
499 7556 Jun-22 34-12:12:08 postgres: postgres databasefoo
127.0.0.1(1251) REINDEX waiting
1196 1198 Jun-23 33-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 1391 Jun-23 33-12:02:08 postgres: us405 databasefoo
192.168.1.244(1111) DELETE waiting
499 1201 Jun-23 33-12:12:08 postgres: postgres databasefoo
127.0.0.1(3623) REINDEX waiting
24682 24684 Jun-24 32-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 24887 Jun-24 32-12:02:06 postgres: us405 databasefoo
192.168.1.244(2910) DELETE waiting
499 24687 Jun-24 32-12:12:07 postgres: postgres databasefoo
127.0.0.1(2699) REINDEX waiting
18386 18388 Jun-25 31-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 18585 Jun-25 31-12:02:07 postgres: us405 databasefoo
192.168.1.244(4713) DELETE waiting
499 18391 Jun-25 31-12:12:07 postgres: postgres databasefoo
127.0.0.1(3411) REINDEX waiting
12176 12178 Jun-26 30-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 12373 Jun-26 30-12:02:08 postgres: us405 databasefoo
192.168.1.244(2648) DELETE waiting
499 12181 Jun-26 30-12:12:08 postgres: postgres databasefoo
127.0.0.1(3322) REINDEX waiting
5889 5891 Jun-27 29-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 6092 Jun-27 29-12:02:05 postgres: us405 databasefoo
192.168.1.244(4479) DELETE waiting
499 5894 Jun-27 29-12:12:08 postgres: postgres databasefoo
127.0.0.1(1797) REINDEX waiting
29401 29403 Jun-28 28-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 29606 Jun-28 28-12:02:05 postgres: us405 databasefoo
192.168.1.244(2288) DELETE waiting
499 29406 Jun-28 28-12:12:08 postgres: postgres databasefoo
127.0.0.1(4203) REINDEX waiting
23072 23074 Jun-29 27-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 23266 Jun-29 27-12:02:08 postgres: us405 databasefoo
192.168.1.244(4147) DELETE waiting
499 23077 Jun-29 27-12:12:07 postgres: postgres databasefoo
127.0.0.1(4313) REINDEX waiting
16692 16694 Jun-30 26-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 16902 Jun-30 26-12:02:06 postgres: us405 databasefoo
192.168.1.244(1964) DELETE waiting
499 16697 Jun-30 26-12:12:08 postgres: postgres databasefoo
127.0.0.1(4288) REINDEX waiting
10408 10410 Jul-01 25-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 10603 Jul-01 25-12:02:08 postgres: us405 databasefoo
192.168.1.244(3808) DELETE waiting
499 10413 Jul-01 25-12:12:08 postgres: postgres databasefoo
127.0.0.1(3881) REINDEX waiting
4056 4058 Jul-02 24-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 4255 Jul-02 24-12:02:08 postgres: us405 databasefoo
192.168.1.244(1641) DELETE waiting
499 4061 Jul-02 24-12:12:08 postgres: postgres databasefoo
127.0.0.1(4679) REINDEX waiting
27578 27580 Jul-03 23-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 27782 Jul-03 23-12:02:04 postgres: us405 databasefoo
192.168.1.244(3470) DELETE waiting
499 27583 Jul-03 23-12:12:08 postgres: postgres databasefoo
127.0.0.1(1078) REINDEX waiting
22375 22377 Jul-04 22-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 22582 Jul-04 22-12:02:05 postgres: us405 databasefoo
192.168.1.244(1380) DELETE waiting
499 22380 Jul-04 22-12:12:08 postgres: postgres databasefoo
127.0.0.1(2960) REINDEX waiting
16197 16199 Jul-05 21-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 16392 Jul-05 21-12:02:06 postgres: us405 databasefoo
192.168.1.244(3223) DELETE waiting
499 16202 Jul-05 21-12:12:08 postgres: postgres databasefoo
127.0.0.1(1850) REINDEX waiting
9991 9993 Jul-06 20-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 10196 Jul-06 20-12:02:07 postgres: us405 databasefoo
192.168.1.244(1131) DELETE waiting
499 9996 Jul-06 20-12:12:08 postgres: postgres databasefoo
127.0.0.1(2136) REINDEX waiting
3747 3749 Jul-07 19-12:12:07 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 3950 Jul-07 19-12:02:05 postgres: us405 databasefoo
192.168.1.244(2984) DELETE waiting
499 3752 Jul-07 19-12:12:07 postgres: postgres databasefoo
127.0.0.1(1109) REINDEX waiting
27327 27329 Jul-08 18-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 27530 Jul-08 18-12:02:06 postgres: us405 databasefoo
192.168.1.244(4805) DELETE waiting
499 27332 Jul-08 18-12:12:08 postgres: postgres databasefoo
127.0.0.1(3189) REINDEX waiting
21054 21056 Jul-09 17-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 21252 Jul-09 17-12:02:06 postgres: us405 databasefoo
192.168.1.244(2665) DELETE waiting
499 21059 Jul-09 17-12:12:08 postgres: postgres databasefoo
127.0.0.1(1962) REINDEX waiting
14765 14767 Jul-10 16-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 14969 Jul-10 16-12:02:04 postgres: us405 databasefoo
192.168.1.244(4476) DELETE waiting
499 14770 Jul-10 16-12:12:08 postgres: postgres databasefoo
127.0.0.1(2505) REINDEX waiting
8499 8501 Jul-11 15-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 8708 Jul-11 15-12:02:04 postgres: us405 databasefoo
192.168.1.244(2313) DELETE waiting
499 8504 Jul-11 15-12:12:08 postgres: postgres databasefoo
127.0.0.1(2620) REINDEX waiting
2757 2759 Jul-12 14-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 21678 Jul-12 14-22:58:05 postgres: us405 databasefoo
192.168.1.241(1119) idle
499 2961 Jul-12 14-12:02:05 postgres: us405 databasefoo
192.168.1.244(4191) DELETE waiting
499 2762 Jul-12 14-12:12:08 postgres: postgres databasefoo
127.0.0.1(2221) REINDEX waiting
26384 26386 Jul-13 13-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 26579 Jul-13 13-12:02:05 postgres: us405 databasefoo
192.168.1.244(2033) DELETE waiting
499 26389 Jul-13 13-12:12:08 postgres: postgres databasefoo
127.0.0.1(1952) REINDEX waiting
20052 20054 Jul-14 12-12:12:07 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
9280 9282 23:00:00 12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 20263 Jul-14 12-12:02:06 postgres: us405 databasefoo
192.168.1.244(3873) DELETE waiting
499 20057 Jul-14 12-12:12:07 postgres: postgres databasefoo
127.0.0.1(3874) REINDEX waiting
499 10272 23:10:01 12:02:07 postgres: us405 databasefoo
192.168.1.244(3744) DELETE waiting
499 9285 23:00:00 12:12:08 postgres: postgres databasefoo
127.0.0.1(3734) REINDEX waiting
13831 13833 Jul-15 11-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 14041 Jul-15 11-12:02:07 postgres: us405 databasefoo
192.168.1.244(1724) DELETE waiting
499 13836 Jul-15 11-12:12:08 postgres: postgres databasefoo
127.0.0.1(2609) REINDEX waiting
7667 7669 Jul-16 10-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 7863 Jul-16 10-12:02:09 postgres: us405 databasefoo
192.168.1.244(3576) DELETE waiting
499 7672 Jul-16 10-12:12:08 postgres: postgres databasefoo
127.0.0.1(4896) REINDEX waiting
1451 1453 Jul-17 09-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 1656 Jul-17 09-12:02:04 postgres: us405 databasefoo
192.168.1.244(1438) DELETE waiting
499 1456 Jul-17 09-12:12:08 postgres: postgres databasefoo
127.0.0.1(3514) REINDEX waiting
25097 25099 Jul-18 08-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 25296 Jul-18 08-12:02:05 postgres: us405 databasefoo
192.168.1.244(3294) DELETE waiting
499 25102 Jul-18 08-12:12:08 postgres: postgres databasefoo
127.0.0.1(1886) REINDEX waiting
18918 18920 Jul-19 07-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 19116 Jul-19 07-12:02:05 postgres: us405 databasefoo
192.168.1.244(1182) DELETE waiting
499 18923 Jul-19 07-12:12:08 postgres: postgres databasefoo
127.0.0.1(2313) REINDEX waiting
13273 13275 Jul-20 06-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 13445 Jul-20 06-12:02:09 postgres: us405 databasefoo
192.168.1.244(3181) DELETE waiting
499 13278 Jul-20 06-12:12:07 postgres: postgres databasefoo
127.0.0.1(1754) REINDEX waiting
6671 6673 Jul-21 05-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 6845 Jul-21 05-12:02:09 postgres: us405 databasefoo
192.168.1.244(1029) DELETE waiting
499 6676 Jul-21 05-12:12:07 postgres: postgres databasefoo
127.0.0.1(1417) REINDEX waiting
29958 29960 Jul-22 04-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 29963 Jul-22 04-12:12:08 postgres: postgres databasefoo
127.0.0.1(1204) REINDEX waiting
499 156 Jul-22 04-12:02:09 postgres: us405 databasefoo
192.168.1.244(2870) DELETE waiting
23574 23576 Jul-23 03-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 23756 Jul-23 03-12:02:09 postgres: us405 databasefoo
192.168.1.244(4804) DELETE waiting
499 23579 Jul-23 03-12:12:08 postgres: postgres databasefoo
127.0.0.1(3748) REINDEX waiting
17014 17016 Jul-24 02-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 17190 Jul-24 02-12:02:05 postgres: us405 databasefoo
192.168.1.244(2672) DELETE waiting
499 17019 Jul-24 02-12:12:08 postgres: postgres databasefoo
127.0.0.1(2491) REINDEX waiting
499 1135 09:11:44 02:00:24 postgres: us405 databasefoo
192.168.1.243(2707) idle
8198 8200 Jul-25 01-12:12:08 /usr/local/pgsql/bin/psql -h localhost
databasefoo postgres
499 25536 Jul-26 01-01:05:52 postgres: us405 databasefoo
192.168.1.241(1647) idle
499 24829 Jul-26 01-01:42:44 postgres: us405 databasefoo
192.168.1.241(4460) idle in transaction
499 8409 Jul-25 01-12:02:09 postgres: us405 databasefoo
192.168.1.244(3702) DELETE waiting
499 8203 Jul-25 01-12:12:07 postgres: postgres databasefoo
127.0.0.1(1541) REINDEX waiting
499 2097 10:04:24 01:07:44 postgres: us405 databasefoo
192.168.1.243(2713) idle
=
4087 4200 11:12:08 00:00 grep postgres
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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2012-07-27 17:00:41 can we avoid pg_basebackup on planned switches?
Previous Message Tom Lane 2012-07-27 16:57:49 Re: information_schema.referential_constraints broken?