search

duckdb / duckdb_azure

Azure extension for DuckDB
MIT License
50 stars 17 forks source link

Not able to attach to .db file placed over azure blob storage using azure extension #70

Open rupeshtej opened 3 months ago

rupeshtej commented 3 months ago

i downloaded latest azure extension code and trying to attach to .db file using duckdb cli and .db file is placed over azure blob storage.

While attaching i am getting below issue -

ATTACH 'az://samplecontainer/sample.db' AS sample_test (READ_ONLY); INTERNAL Error: Attempting to dereference an optional pointer that is not set This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.

To Reproduce

Below are the steps and commands to reproduce -

Run duckdb CLI and run below commands

CREATE SECRET secret ( TYPE AZURE, CONNECTION_STRING '***' );

Attach .db file using below command - ATTACH 'az://samplecontainer/sample.db' AS sample_test (READ_ONLY);

djouallah commented 2 months ago

same problem here :(

rupeshtej commented 3 weeks ago

hi @Mytherin , can you please check this

rupeshtej commented 1 week ago

hi @Mytherin , i checked again with your commit and it is working with single thread... but when i set max_threads to more than 1 then Database attach is working correctly but in query execution program is crashing with below error -

Error in executing query: IO Error: Corrupt database file: computed checksum 10704450356758579597 does not match stored checksum 8071570260309647359 in block at location 2371584

I used duckdb version - 1.1.2