From: | Naoko Reeves <naokoreeves(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Unable to kill local COPY |
Date: | 2010-12-19 17:42:23 |
Message-ID: | AANLkTi=TUQwyRuD6bjaAOd4-GNp+-PrcUUc-Y1vf4rGi@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
version: 8.3
The other day, my DB stop processing request. It still accepts connections
but not processing those.
So I quit all client connections from client yet those process still alive
on SQL Server.
I tried to Stop DB by issuing pt_ctl STOP -m fast but failed to shut down
database.
Next I issued pg_ctl stop -m immediate. I think this one killed all
processes that were from client.
The returning message says the server was stopped.
So I issued ps -ef | grep postgres but master and 4 child processes were
still there...
502 150 1 0 0:10.70 ?? 0:12.69
/Library/PostgresPlus/8.3/bin/postgres -D /data
502 165 150 0 0:03.71 ?? 0:05.15 postgres: logger process
502 171 150 0 0:44.15 ?? 1:06.28 postgres: writer process
502 72026 150 0 0:00.15 ?? 0:00.87 postgres: postgres mydata
[local] VACUUM
502 81413 150 0 0:00.48 ?? 0:06.52 postgres: postgres mydata
127.0.0.1(56760) COPY
I then tried to kill the following process
502 81413 150 0 0:00.48 ?? 0:06.52 postgres: postgres mydata
127.0.0.1(56760) COPY
even with -s 15 I could not kill....
So what I end up doing was to hard reboot the machine...
I have questions:
1) Did I have better choice than hard-reboot the machine? (soft reboot
didn't work).
2) The COPY command I was tying to kill is local request. Is this the
process postgres trying to write changes to the disk? If so, what could I
have done to data?
Thank you very much for your time.
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2010-12-19 18:05:04 | Re: Table both does not and does exist! wth? |
Previous Message | Антон | 2010-12-19 17:17:30 | Re: unable to write inside TEMP... |