auth into S3 fails after cancelling query #957
Description
What happens?
Issue that I found while working on #956.
Basically it seems that cancelling a query will make it so that I cannot connect to the s3 bucket until i close the connection and reopen it.
Happy to do more testing/details if needed.
To Reproduce
> SELECT {{ select_columns }}
FROM read_parquet('s3://path/to/file.parquet') AS r
WHERE {{ where_condititions }}
limit 1;
^CCancel request sent
ERROR: (PGDuckDB/Duckdb_ExecCustomScan_Cpp) Executor Error: Query cancelled
> SELECT {{ select_columns }}
FROM read_parquet('s3://path/to/file.parquet') AS r
WHERE {{ where_condititions }}
limit 1;
ERROR: (PGDuckDB/CreatePlan) Prepared query returned an error: HTTP Error: Unable to connect to URL "s3://path/to/file.parquet": 404 (Not Found).
LINE 1: ... REDACTED..
^
> \q
> psql \
'postgresql://ajackson@localhost:5432/postgres'
psql (17.6)
Type "help" for help.
> SELECT {{ select_columns }}
FROM read_parquet('s3://path/to/file.parquet') AS r
WHERE {{ where_condititions }}
limit 1;
OS:
Linux
pg_duckdb Version (if built from source use commit hash):
Postgres Version (if built from source use commit hash):
17.6
Hardware:
No response
Full Name:
Andrew Jackson
Affiliation:
Andrew Jackson
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a source build
Did you include all relevant data sets for reproducing the issue?
Yes
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