DuckDBQueryOrThrow does not respond to cancel requests
- Dominant language
- C++
- Stars
- 3.2k
- Forks
- 205
- PR merge metrics
- No merged PRs in 30d
Description
### What happens?
When I install the extension in the private network, it hangs for a long time. If I try to use pg_terminate_backend to terminate the execution, It still fails to be canceled.
### To Reproduce

### OS:
Linux
### pg_duckdb Version (if built from source use commit hash):
66cb6e64feb40bc1b0a7511485703442e39e60ad
### Postgres Version (if built from source use commit hash):
16.8
### Hardware:
_No response_
### Full Name:
Cobolbaby
### Affiliation:
Inventec
### What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have not tested with any build
### Did you include all relevant data sets for reproducing the issue?
No - Other reason (please specify in the issue body)
### Did you include all code required to reproduce the issue?
- [ ] Yes, I have
### Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?
- [ ] Yes, I have
Contributor guide
Research direction
Start by investigating the DuckDBQueryOrThrow entry point and reproducing cancellation through PostgreSQL's pg_terminate_backend on Linux. Compare behavior with a current build, then verify that a running query can be terminated and no longer hangs; the issue does not name source files or tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 28/100