Problem with trying to install httpfs from nightly builds

[gustavdelius]

I am using duckdbfs from within rfishbase and am getting the following error:

<error/rlang_error>
Error in `duckdb_result()`:
! rapi_execute: Failed to run query
Error: HTTP Error: Failed to download extension "httpfs" at URL "http://nightly-extensions.duckdb.org/v1.1.3/linux_amd64/httpfs.duckdb_extension.gz" (HTTP 403)
Extension "httpfs" is an existing extension.
---
Backtrace:
     ▆
  1. ├─dplyr::select(...)
  2. ├─rfishbase::species(sp$latin_name[missing])
  3. │ ├─fb_tbl(endpt, server, version) %>% fix_ids()
  4. │ └─rfishbase::fb_tbl(endpt, server, version)
  5. │   └─duckdbfs::open_dataset(urls[tbl])
  6. │     └─duckdbfs:::parse_uri(sources, conn = conn, recursive = recursive)
  7. │       └─duckdbfs:::load_httpfs(conn)
  8. │         ├─DBI::dbExecute(conn, paste0("INSTALL 'httpfs'", source, ";"))
  9. │         └─DBI::dbExecute(conn, paste0("INSTALL 'httpfs'", source, ";"))
 10. │           ├─DBI::dbSendStatement(conn, statement, ...)
 11. │           └─DBI::dbSendStatement(conn, statement, ...)
 12. │             ├─DBI::dbSendQuery(conn, statement, ...)
 13. │             └─duckdb::dbSendQuery(conn, statement, ...)
 14. │               └─duckdb (local) .local(conn, statement, ...)
 15. │                 └─duckdb:::duckdb_result(connection = conn, stmt_lst = stmt_lst, arrow = arrow)
 16. └─rfishbase:::fix_ids(.)
 17.   ├─"Speccode" %in% colnames(full_data)
 18.   └─base::colnames(full_data)
 19.     └─base::is.data.frame(x)
Run rlang::last_trace(drop = FALSE) to see 14 hidden frames.

This goes away if I do

options("duckdbfs_use_nightly" = FALSE)

[cboettig]

thanks, should be resolved in 0.0.9 now.

(previously the default extensions was broken but nightly worked. looks like duckdb team fixed the default extension, but now the nightly is broken 🤷 . anyway we keep updating to move with these issues )