* using log directory ‘/data/blackswan/ripley/R/packages/tests-devel/duckspatial.Rcheck’ * using R Under development (unstable) (2026-03-14 r89622) * using platform: x86_64-pc-linux-gnu * R was compiled by gcc (GCC) 14.2.1 20240912 (Red Hat 14.2.1-3) GNU Fortran (GCC) 14.2.1 20240912 (Red Hat 14.2.1-3) * running under: Fedora Linux 40 (Workstation Edition) * using session charset: UTF-8 * current time: 2026-03-15 00:16:59 UTC * checking for file ‘duckspatial/DESCRIPTION’ ... OK * checking extension type ... Package * this is package ‘duckspatial’ version ‘0.9.0’ * package encoding: UTF-8 * checking package namespace information ... OK * checking package dependencies ... OK * checking if this is a source package ... OK * checking if there is a namespace ... OK * checking for executable files ... OK * checking for hidden files and directories ... OK * checking for portable file names ... OK * checking for sufficient/correct file permissions ... OK * checking whether package ‘duckspatial’ can be installed ... OK * checking package directory ... OK * checking ‘build’ directory ... OK * checking DESCRIPTION meta-information ... OK * checking top-level files ... OK * checking for left-over files ... OK * checking index information ... OK * checking package subdirectories ... OK * checking code files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... OK * checking whether the package can be loaded with stated dependencies ... OK * checking whether the package can be unloaded cleanly ... OK * checking whether the namespace can be loaded with stated dependencies ... OK * checking whether the namespace can be unloaded cleanly ... OK * checking loading without being on the library search path ... OK * checking whether startup messages can be suppressed ... OK * checking dependencies in R code ... OK * checking S3 generic/method consistency ... OK * checking replacement functions ... OK * checking foreign function calls ... OK * checking R code for possible problems ... OK * checking Rd files ... OK * checking Rd metadata ... OK * checking Rd line widths ... OK * checking Rd cross-references ... OK * checking for missing documentation entries ... OK * checking for code/documentation mismatches ... OK * checking Rd \usage sections ... OK * checking Rd contents ... OK * checking for unstated dependencies in examples ... OK * checking installed files from ‘inst/doc’ ... OK * checking files in ‘vignettes’ ... OK * checking examples ... OK * checking examples with --run-donttest ... ERROR Running examples in ‘duckspatial-Ex.R’ failed The error most likely occurred in: > ### Name: ddbs_interpolate_aw > ### Title: Areal-Weighted Interpolation using DuckDB > ### Aliases: ddbs_interpolate_aw > > ### ** Examples > > ## No test: > library(sf) Linking to GEOS 3.12.2, GDAL 3.8.5, PROJ 9.3.1; sf_use_s2() is TRUE > > # 1. Prepare Data > # Load NC counties (Source) and project to Albers (EPSG:5070) > nc <- st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) > nc <- st_transform(nc, 5070) > nc$sid <- seq_len(nrow(nc)) # Create Source ID > > # Create a target grid > g <- st_make_grid(nc, n = c(10, 5)) > g_sf <- st_as_sf(g) > g_sf$tid <- seq_len(nrow(g_sf)) # Create Target ID > > # 2. Extensive Interpolation (Counts) > # Use weight = "total" for strict mass preservation (e.g., total births) > res_ext <- ddbs_interpolate_aw( + target = g_sf, source = nc, + tid = "tid", sid = "sid", + extensive = "BIR74", + weight = "total" + ) Error in `get_geom_name()`: ! The table does not exist. Backtrace: ▆ 1. └─duckspatial::ddbs_interpolate_aw(...) 2. └─duckspatial:::get_geom_name(conn, t_list$query_name) 3. └─cli::cli_abort("The table <{x}> does not exist.") 4. └─rlang::abort(...) Execution halted * checking for unstated dependencies in ‘tests’ ... OK * checking tests ... Running ‘testthat.R’ ERROR Running the tests in ‘tests/testthat.R’ failed. Complete output: > # This file is part of the standard setup for testthat. > # It is recommended that you do not modify it. > # > # Where should you do additional test configuration? > # Learn more about the roles of various files in: > # * https://r-pkgs.org/testing-design.html#sec-tests-files-overview > # * https://testthat.r-lib.org/articles/special-files.html > > library(testthat) > library(duckspatial) Important: 'crs_column' and 'crs' arguments are deprecated and will be removed in the next version. If possible, use the default values of these arguments to avoid future issues. > library(duckdb) Loading required package: DBI > > test_check("duckspatial") Reading layer `countries' from data source `/data/blackswan/ripley/R/packages/tests-devel/duckspatial.Rcheck/duckspatial/spatial/countries.geojson' using driver `GeoJSON' Simple feature collection with 257 features and 6 fields Geometry type: POLYGON Dimension: XY Bounding box: xmin: -178.9125 ymin: -89.9 xmax: 180 ymax: 83.65187 Geodetic CRS: WGS 84 Reading layer `argentina' from data source `/data/blackswan/ripley/R/packages/tests-devel/duckspatial.Rcheck/duckspatial/spatial/argentina.geojson' using driver `GeoJSON' Simple feature collection with 1 feature and 6 fields Geometry type: POLYGON Dimension: XY Bounding box: xmin: -73.52455 ymin: -52.39755 xmax: -53.62409 ymax: -21.81793 Geodetic CRS: WGS 84 Reading layer `rivers' from data source `/data/blackswan/ripley/R/packages/tests-devel/duckspatial.Rcheck/duckspatial/spatial/rivers.geojson' using driver `GeoJSON' Simple feature collection with 100 features and 1 field Geometry type: LINESTRING Dimension: XY Bounding box: xmin: 2766878 ymin: 2222357 xmax: 3578648 ymax: 2459939 Projected CRS: ETRS89-extended / LAEA Europe v Temporary view view_test registered Saving _problems/test-compatibility-28.R i Table dropped v Table rt_write_line successfully imported Saving _problems/test-compatibility-63.R v Temporary view rt_register_line registered Saving _problems/test-compatibility-92.R i Table dropped v Table countries_from_file_compat successfully imported Saving _problems/test-compatibility-112.R [ FAIL 4 | WARN 1 | SKIP 17 | PASS 3 ] ══ Skipped tests (17) ══════════════════════════════════════════════════════════ • On CRAN (17): 'test-db_read.R:2:1', 'test-db_register.R:3:1', 'test-db_write.R:3:1', 'test-ddbs_area.R:3:1', 'test-ddbs_bbox.R:3:1', 'test-ddbs_combine.R:3:1', 'test-ddbs_concave_hull.R:3:1', 'test-ddbs_convex_hull.R:3:1', 'test-ddbs_distance.R:3:1', 'test-ddbs_envelope.R:3:1', 'test-ddbs_generate_points.R:5:1', 'test-ddbs_interpolate_aw.R:2:1', 'test-ddbs_join.R:3:1', 'test-ddbs_length.R:3:1', 'test-ddbs_transform.R:5:1', 'test-ddbs_union.R:3:1', 'test-utils.R:2:1' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-compatibility.R:28:5'): Compatibility: Arrow Views behave like Persistent Tables ── Error in `dbSendQuery(conn, statement, ...)`: Unknown column type for prepare: GEOMETRY i Context: rapi_prepare Backtrace: ▆ 1. ├─duckspatial::ddbs_read_vector(conn, "view_test", crs = 4326) at test-compatibility.R:28:5 2. │ ├─DBI::dbListFields(conn, name_list$query_name) 3. │ └─DBI::dbListFields(conn, name_list$query_name) 4. │ ├─DBI::dbGetQuery(...) 5. │ └─DBI::dbGetQuery(...) 6. │ └─DBI (local) .local(conn, statement, ...) 7. │ ├─DBI::dbSendQuery(conn, statement, ...) 8. │ └─duckdb::dbSendQuery(conn, statement, ...) 9. │ └─duckdb (local) .local(conn, statement, ...) 10. │ └─duckdb:::rethrow_rapi_prepare(conn@conn_ref, statement, env) 11. │ ├─rlang::try_fetch(...) 12. │ │ ├─base::tryCatch(...) 13. │ │ │ └─base (local) tryCatchList(expr, classes, parentenv, handlers) 14. │ │ │ └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]]) 15. │ │ │ └─base (local) doTryCatch(return(expr), name, parentenv, handler) 16. │ │ └─base::withCallingHandlers(...) 17. │ └─duckdb:::rapi_prepare(conn, query, env) 18. ├─duckdb (local) ``("rapi_prepare", "Unknown column type for prepare: GEOMETRY") 19. │ └─rlang::abort(error_parts, class = "duckdb_error", !!!fields) 20. │ └─rlang:::signal_abort(cnd, .file) 21. │ └─base::signalCondition(cnd) 22. └─rlang (local) ``(``) 23. └─handlers[[1L]](cnd) 24. └─duckdb:::rethrow_error_from_rapi(e, call) 25. └─rlang::abort(msg, call = call) ── Error ('test-compatibility.R:63:9'): Round trip: write -> read for various geometry types ── Error in `get_geom_name(conn, name_list$query_name)`: The table does not exist. Backtrace: ▆ 1. └─duckspatial::ddbs_read_vector(conn, table_name) at test-compatibility.R:63:9 2. └─duckspatial:::get_geom_name(conn, name_list$query_name) 3. └─cli::cli_abort("The table <{x}> does not exist.") 4. └─rlang::abort(...) ── Error ('test-compatibility.R:92:9'): Round trip: register -> read for various geometry types ── Error in `dbSendQuery(conn, statement, ...)`: Unknown column type for prepare: GEOMETRY i Context: rapi_prepare Backtrace: ▆ 1. ├─duckspatial::ddbs_read_vector(conn, view_name) at test-compatibility.R:92:9 2. │ ├─DBI::dbListFields(conn, name_list$query_name) 3. │ └─DBI::dbListFields(conn, name_list$query_name) 4. │ ├─DBI::dbGetQuery(...) 5. │ └─DBI::dbGetQuery(...) 6. │ └─DBI (local) .local(conn, statement, ...) 7. │ ├─DBI::dbSendQuery(conn, statement, ...) 8. │ └─duckdb::dbSendQuery(conn, statement, ...) 9. │ └─duckdb (local) .local(conn, statement, ...) 10. │ └─duckdb:::rethrow_rapi_prepare(conn@conn_ref, statement, env) 11. │ ├─rlang::try_fetch(...) 12. │ │ ├─base::tryCatch(...) 13. │ │ │ └─base (local) tryCatchList(expr, classes, parentenv, handlers) 14. │ │ │ └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]]) 15. │ │ │ └─base (local) doTryCatch(return(expr), name, parentenv, handler) 16. │ │ └─base::withCallingHandlers(...) 17. │ └─duckdb:::rapi_prepare(conn, query, env) 18. ├─duckdb (local) ``("rapi_prepare", "Unknown column type for prepare: GEOMETRY") 19. │ └─rlang::abort(error_parts, class = "duckdb_error", !!!fields) 20. │ └─rlang:::signal_abort(cnd, .file) 21. │ └─base::signalCondition(cnd) 22. └─rlang (local) ``(``) 23. └─handlers[[1L]](cnd) 24. └─duckdb:::rethrow_error_from_rapi(e, call) 25. └─rlang::abort(msg, call = call) ── Error ('test-compatibility.R:112:5'): Compatibility: Writing from file path and reading back ── Error in `get_geom_name(conn, name_list$query_name)`: The table does not exist. Backtrace: ▆ 1. └─duckspatial::ddbs_read_vector(conn, table_name) at test-compatibility.R:112:5 2. └─duckspatial:::get_geom_name(conn, name_list$query_name) 3. └─cli::cli_abort("The table <{x}> does not exist.") 4. └─rlang::abort(...) [ FAIL 4 | WARN 1 | SKIP 17 | PASS 3 ] Error: ! Test failures. Execution halted * checking for unstated dependencies in vignettes ... OK * checking package vignettes ... OK * checking re-building of vignette outputs ... [16s/15s] ERROR Error(s) in re-building vignettes: ... --- re-building ‘aw_interpolation.Rmd’ using rmarkdown Quitting from aw_interpolation.Rmd:67-78 [unnamed-chunk-2] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error in `get_geom_name()`: ! The table does not exist. --- Backtrace: ▆ 1. └─duckspatial::ddbs_interpolate_aw(...) 2. └─duckspatial:::get_geom_name(conn, t_list$query_name) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: processing vignette 'aw_interpolation.Rmd' failed with diagnostics: The table does not exist. --- failed re-building ‘aw_interpolation.Rmd’ --- re-building ‘benchmark.Rmd’ using rmarkdown --- finished re-building ‘benchmark.Rmd’ --- re-building ‘duckspatial.Rmd’ using rmarkdown [WARNING] Deprecated: --highlight-style. Use --syntax-highlighting instead. --- finished re-building ‘duckspatial.Rmd’ --- re-building ‘spatial_joins.Rmd’ using rmarkdown [WARNING] Deprecated: --highlight-style. Use --syntax-highlighting instead. --- finished re-building ‘spatial_joins.Rmd’ SUMMARY: processing the following file failed: ‘aw_interpolation.Rmd’ Error: Vignette re-building failed. Execution halted * checking PDF version of manual ... OK * checking for non-standard things in the check directory ... OK * checking for detritus in the temp directory ... OK * checking for new files in some other directories ... OK * DONE Status: 3 ERRORs See ‘/data/blackswan/ripley/R/packages/tests-devel/duckspatial.Rcheck/00check.log’ for details. Command exited with non-zero status 1 Time 1:27.43, 68.58 + 23.50