duckdb / duckdb/pg_duckdb

DuckDBQueryOrThrow does not respond to cancel requests

Open
#637 4 comments 0 reactions 0 assignees View on GitHub
bug
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

![Image](https://github.com/user-attachments/assets/f4c80e7b-8065-42b1-a733-eaf420dc4412)

### 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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.