REINDEX and COPY is wainting since Jun 21!
| От | Ing.Edmundo.Robles.Lopez |
|---|---|
| Тема | REINDEX and COPY is wainting since Jun 21! |
| Дата | |
| Msg-id | 5012C905.60001@sensacd.com.mx обсуждение исходный текст |
| Ответы |
Re: REINDEX and COPY is wainting since Jun 21!
(Alan Hodgson <ahodgson@simkin.ca>)
|
| Список | 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 exclusivamentea su destinatario. No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de estainformación por un receptor o entidades distintas al destinatario. Si recibe este correo sin ser el destinatario sele solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicacionesno 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 theindividual or entity to which they are addressed. The retransmission, dissemination, or any other use of this informationother than by the intended recipient is prohibited. If you have received this email in error please delete itand 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.
В списке pgsql-general по дате отправления: