INSTALL spatial fails on windows

[fvalenduc]

Can somebody explain this ?

dbExecute(con,"INSTALL spatial")
Error in duckdb_result():
! Invalid Error: HTTP Error: Failed to download extension "spatial" at URL "http://extensions.duckdb.org/f40ac6e565/windows_amd64_mingw/spatial.duckdb_extension.gz" (HTTP 403)
Extension "spatial" is an existing extension.

For more info, visit https://duckdb.org/docs/stable/extensions/troubleshooting/?version=f40ac6e565&platform=windows_amd64_mingw&extension=spatial
ℹ Context: rapi_execute
ℹ Error type: INVALID
ℹ Raw message: HTTP Error: Failed to download extension "spatial" at URL "http://extensions.duckdb.org/f40ac6e565/windows_amd64_mingw/spatial.duckdb_extension.gz" (HTTP 403)
Extension "spatial" is an existing extension.

For more info, visit https://duckdb.org/docs/stable/extensions/troubleshooting/?version=f40ac6e565&platform=windows_amd64_mingw&extension=spatial
Run rlang::last_trace() to see where the error occurred.

This is on a Windows VM running on a Linux host. On the linux host, it works perfectly fine.

[krlmlr]

Thanks. Please use duckdb >= 1.4.0 (from r-universe, soon available as binary on CRAN or Posit Package Manager).

[fvalenduc]

Still the same problem with duckdb 1.4.0 installed via RTools on Windows:

[fvalenduc]

dbExecute(con,'INSTALL SPATIAL;')
Error in duckdb_result():
! Invalid Error: HTTP Error: Failed to download extension "spatial" at URL "http://extensions.duckdb.org/v1.4.0/windows_amd64_mingw/spatial.duckdb_extension.gz" (HTTP 403)
Extension "spatial" is an existing extension.

For more info, visit https://duckdb.org/docs/stable/extensions/troubleshooting?version=v1.4.0&platform=windows_amd64_mingw&extension=spatial
ℹ Context: rapi_execute
ℹ Error type: INVALID
ℹ Raw message: HTTP Error: Failed to download extension "spatial" at URL "http://extensions.duckdb.org/v1.4.0/windows_amd64_mingw/spatial.duckdb_extension.gz" (HTTP 403)
Extension "spatial" is an existing extension.

For more info, visit https://duckdb.org/docs/stable/extensions/troubleshooting?version=v1.4.0&platform=windows_amd64_mingw&extension=spatial
Run rlang::last_trace() to see where the error occurred.

[krlmlr]

Thanks. No, this is unexpected. Do other extensions work for you?

As an end user, please work with v1.3.2 for now.

[samansmink]

We should be able to build this, but not 100% sure. I think @Maxxen will know!

[ChuanTC]

I think I come across a similar issue when I try to install extension using the duckdb R package (I am using v1.4 duckdb):

r$> dbExecute(con, "install postgres;") Error in duckdb_result()`:
! Invalid Error: HTTP Error: Failed to download extension "postgres_scanner" at URL "http://extensions.duckdb.org/v1.4.0/windows_amd64_mingw/postgres_scanner.duckdb_extension.gz" (HTTP 404)
Extension "postgres_scanner" is an existing extension.

For more info, visit https://duckdb.org/docs/stable/extensions/troubleshooting?version=v1.4.0&platform=windows_amd64_mingw&extension=postgres_scanner
i Context: rapi_execute
i Error type: INVALID
i Raw message: HTTP Error: Failed to download extension "postgres_scanner" at URL "http://extensions.duckdb.org/v1.4.0/windows_amd64_mingw/postgres_scanner.duckdb_extension.gz" (HTTP 404)
Extension "postgres_scanner" is an existing extension.

For more info, visit https://duckdb.org/docs/stable/extensions/troubleshooting?version=v1.4.0&platform=windows_amd64_mingw&extension=postgres_scanner
Run rlang::last_trace() to see where the error occurred.`

Can anyone offer a solution? thanks!

[samansmink]

This issue should be resolved in the upcoming v1.4.1 release