A node failure during COPY causes log spam
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
If you run `pg_ctl stop -m immediate` on the worker node during a COPY you're given (I think) a WARNING per connection:
```
brian=# COPY copy_perf FROM '/home/brian/rdesktop-share/lots-of-wider-rows.csv' WITH csv;
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
WARNING: could not cancel connection: PQcancel() -- connect() failed: Connection refused
ERROR: failed to COPY to shard 102039 on localhost:9701
DETAIL: failed to send 44 bytes
CONTEXT: COPY copy_perf, line 975703: "975702,randomdatarandomdatarandomdata"
```
Contributor guide
Assessment
This issue has not been assessed yet.