* using log directory 'd:/Rcompile/CRANpkg/local/4.6/datacaged.Rcheck' * using R version 4.6.1 (2026-06-24 ucrt) * using platform: x86_64-w64-mingw32 * R was compiled by gcc.exe (GCC) 14.3.0 GNU Fortran (GCC) 14.3.0 * running under: Windows Server 2022 x64 (build 20348) * using session charset: UTF-8 * current time: 2026-09-29 17:19:45 UTC * checking for file 'datacaged/DESCRIPTION' ... OK * this is package 'datacaged' version '0.2.1' * 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 hidden files and directories ... OK * checking for portable file names ... OK * checking whether package 'datacaged' can be installed ... OK * checking installed package size ... 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 ... [2s] OK * checking whether the package can be loaded with stated dependencies ... [2s] OK * checking whether the package can be unloaded cleanly ... [1s] OK * checking whether the namespace can be loaded with stated dependencies ... [1s] OK * checking whether the namespace can be unloaded cleanly ... [2s] OK * checking loading without being on the library search path ... [2s] OK * checking whether startup messages can be suppressed ... [2s] OK * checking use of S3 registration ... 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 ... [6s] OK * checking Rd files ... [1s] OK * checking Rd metadata ... 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 contents of 'data' directory ... OK * checking data for non-ASCII characters ... [0s] OK * checking LazyData ... OK * checking data for ASCII and uncompressed saves ... OK * checking installed files from 'inst/doc' ... OK * checking files in 'vignettes' ... OK * checking examples ... [3s] OK * checking for unstated dependencies in 'tests' ... OK * checking tests ... [41s] ERROR Running 'testthat.R' [41s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository ()... Querying HuggingFace repository ()... Querying HuggingFace repository ()... Querying HuggingFace repository ()... duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d8149179b2.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d817973848.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d84f4c2e88.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d84eac3d7a.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d86ec66836.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d87b6d6fd9.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d829ce1e9e.d File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [4s] ETA: ETA: 8s ==============================> 3/3 [5.2s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d85141276b.d File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_617d876776e2d' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_617d876776e2d' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_617d876776e2d' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_dl_617d8551f453' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_lay_mock_617d8641d410e/layouts' -- Listando - "novo" -- i Consultando v 2 arquivo(s) encontrado(s). ===============>--------------- 1/2 10.3s ETA ETA: 10s ==============================> 2/2 19.7s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_test_617d86d434cd' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_test_617d86d434cd' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_test_617d86d434cd' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag/novo_dir_399320' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag/novo_dir_399320' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag/novo_dir_399320' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_load_mock_617d86f0a51c3.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_adj_mock_617d832013f31.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted * checking for unstated dependencies in vignettes ... OK * checking package vignettes ... OK * checking re-building of vignette outputs ... [15s] OK * checking PDF version of manual ... [20s] OK * checking HTML version of manual ... [4s] OK * DONE Status: 1 ERROR