duckdb / duckdb_aws

MIT License
34 stars 12 forks source link

Unable to load aws.duckdb_extension - v0.10.0 - 20b1486d11 #30

Closed orzom411 closed 4 months ago

orzom411 commented 4 months ago

Good Morning,

Not sure if this should be posted here or under the main thread so if I am in error please let me know and I'll re-post under duckdb. My issue, attempting to employ create credential, PROVIDER CREDENTIAL_CHAIN, or any and ran into "aws" module wasn't able to be loaded. I have it installed but I'm unable to "load" the aws extension. The message seems to imply the hook, module, has an issue. This was working with version 0.9.2.

Here is what I did:

C:\temp\2024\02\20240214\duckdb.exe v0.10.0 20b1486d11 …

D install aws; Run Time (s): real 0.001 user 0.000000 sys 0.000000

D load aws; Run Time (s): real 0.026 user 0.015625 sys 0.000000 Error: IO Error: Extension "C:\Users\mo.duckdb\extensions\v0.10.0\windows_amd64\aws.duckdb_extension" could not be loaded: The specified module could not be found.

D .shell "dir C:\\Users\\mo\\.duckdb\\extensions\\v0.10.0\\windows_amd64\\aws.duckdb_extension" Volume in drive C has no label. Volume Serial Number is 4E4F-4D14

Directory of C:\Users\mo.duckdb\extensions\v0.10.0\windows_amd64

02/14/2024 11:38 PM 20,776,704 aws.duckdb_extension 1 File(s) 20,776,704 bytes 0 Dir(s) 1,836,358,496,256 bytes free

D select e.extension_name, e.loaded, e.installed, e.install_path from duckdb_extensions() as e where e.extension_name = 'aws' ; extension_name|loaded|installed|install_path aws|false|true|C:\Users\mo.duckdb\extensions\v0.10.0\windows_amd64\aws.duckdb_extension Run Time (s): real 0.002 user 0.000000 sys 0.000000

I'm unable to work around this issue. I tried putting the aws.duckdb_extension in the same folder as the executable and loading it directly:

D load "./aws.duckdb_extension"; Run Time (s): real 0.058 user 0.000000 sys 0.000000 Error: IO Error: Extension ".\aws.duckdb_extension" could not be loaded: The specified module could not be found.

D .shell "dir ."; Volume in drive C has no label. Volume Serial Number is 4E4F-4D14

Directory of C:\temp\2024\02\20240214

02/14/2024 11:52 PM

. 02/14/2024 03:04 PM .. 02/14/2024 11:38 PM 20,776,704 aws.duckdb_extension 02/14/2024 11:35 PM 26,275,840 duckdb.exe 02/14/2024 11:38 PM 34,882,816 httpfs.duckdb_extension 3 File(s) 81,935,360 bytes 2 Dir(s) 1,836,354,637,824 bytes free

Incase this was a platform issue I tried this as well: D load ".\\aws.duckdb_extension"; Run Time (s): real 0.029 user 0.000000 sys 0.000000 Error: IO Error: Extension ".\aws.duckdb_extension" could not be loaded: The specified module could not be found.

I'll try all of this again in a few days and update this if successful. Wishing all a happy Thursday.

samansmink commented 4 months ago

Thanks a lot for the extensive report, this seems like some linking issue that has been introduced by the recent vcpkg bump

samansmink commented 4 months ago

This is now deployed to the main extension repository, running force install aws should fix things now