duckdb: Error when coping data to Cloudflare R2

What happens?

using the S3 API, when I try to copy a file to R2, I get this error duckdb.IOException: IO Error: Unexpected response during S3 multipart upload finalization

the same file was fine using AWS Boto package

To Reproduce

import streamlit as st
import duckdb
con=duckdb.connect()

con.execute(f'''
install httpfs;
LOAD httpfs;
PRAGMA enable_object_cache ;
set s3_region = 'auto';
set s3_access_key_id = "{st.secrets["aws_access_key_id_secret"]}" ;
set s3_secret_access_key = '{st.secrets["aws_secret_access_key_secret"] }';
set s3_endpoint = '{st.secrets["endpoint_url_secret"]}'  ;
SET s3_url_style='path';
COPY (select * from 'Parquet/0.1/lineitem.parquet' ) to 's3://delta/1/lineitem.parquet'
''')

OS:

windows 10

DuckDB Version:

0.6.2.dev480

DuckDB Client:

python

Full Name:

mimoune djouallah

Affiliation:

Personal project

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree