BUG #6088: copy to stdout cannot be stopped with kill(pid) or pg_terminate_backend

From: "Maksym Boguk" <Maxim(dot)Boguk(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6088: copy to stdout cannot be stopped with kill(pid) or pg_terminate_backend
Date: 2011-07-02 04:42:36
Message-ID: 201107020442.p624gahY078103@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6088
Logged by: Maksym Boguk
Email address: Maxim(dot)Boguk(at)gmail(dot)com
PostgreSQL version: 8.4.7
Operating system: Freebsd
Description: copy to stdout cannot be stopped with kill(pid) or
pg_terminate_backend
Details:

Again I not sure it is actual bug or intended behaviour.

But I found I can not stop
COPY bill.changes (id, cdate, mdate, status, table_name, pk_id, old_row,
new_row) TO stdout;
with pg_terminate_backend(procpid) or kill (procpid).

At the same time copy to stdout completely ignore fact other side (pg_dump
itself) was killed long time ago.

That is can be problem because backup of some huge table can be very long
process and prevent any DDL changes for all tables in the that database
(because pg_dump keep lock on all tables).

Now I'm sitting with open ssh and waiting 2 hour while that 120Gb table
finally finish copying and I can perform some urgent DDL on the database.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-07-02 04:53:42 Re: BUG #6088: copy to stdout cannot be stopped with kill(pid) or pg_terminate_backend
Previous Message Tom Lane 2011-07-02 03:35:21 Re: BUG #6080: information_schema.columns.column_default contains NULL inconsistently