CRAN Package Check Results for Package datacaged

Last updated on 2026-10-13 09:50:26 CEST.

Flavor	Version	T_install	T_check	T_total	Status
r-devel-linux-x86_64-debian-clang	0.2.1	7.77	98.11	105.88	ERROR
r-devel-linux-x86_64-debian-gcc	0.2.1	5.42	73.70	79.12	ERROR
r-devel-linux-x86_64-fedora-clang	0.2.3			75.20	OK
r-devel-linux-x86_64-fedora-gcc	0.2.3			78.09	OK
r-devel-windows-x86_64	0.2.1	10.00	148.00	158.00	OK
r-patched-linux-x86_64	0.2.1	7.14	90.62	97.76	ERROR
r-release-linux-x86_64	0.2.1	7.57	90.33	97.90	ERROR
r-release-macos-arm64	0.2.3	2.00	101.00	103.00	OK
r-release-macos-x86_64	0.2.3	6.00	216.00	222.00	OK
r-release-windows-x86_64	0.2.1	13.00	134.00	147.00	ERROR
r-oldrel-macos-arm64	0.2.3	3.00	101.00	104.00	OK
r-oldrel-macos-x86_64	0.2.3	6.00	176.00	182.00	OK
r-oldrel-windows-x86_64	0.2.1	13.00	156.00	169.00	ERROR

Check Details

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [17s/61s] 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 (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f31f02bf7.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f3a207425.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f4799fae4.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f36fbb422.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f6f43e7f5.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f79ea5236.duckdb' Empty data.frame - nothing to write. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f25aa4a75.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 [1.8s] ETA: ETA: 4s ==============================> 3/3 [3s] ETA: ETA: 0s No valid competency to download. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpIufvFn/file2c387f1b76cdb2.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_2c387f3f17d3b6' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_2c387f3f17d3b6' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_2c387f3f17d3b6' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/RtmpIufvFn/caged_dl_2c387f1ad8b787' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/RtmpIufvFn/caged_lay_mock_2c387f3bfee70a/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 15s ETA ETA: 15s curl: (78) The file does not exist ==============================> 2/2 28.2s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_test_2c387f3e289b3f' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_test_2c387f3e289b3f' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_test_2c387f3e289b3f' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpIufvFn/novo_dir_2898047' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/novo_dir_2898047' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/novo_dir_2898047' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_ow_2c387f754274e2' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_ow_2c387f754274e2' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_ow_2c387f754274e2' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpIufvFn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_ow_2c387f754274e2' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_ow_2c387f754274e2' [ 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 `/home/hornik/tmp/scratch/RtmpIufvFn/caged_load_mock_2c387f2503aa4d.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 `/home/hornik/tmp/scratch/RtmpIufvFn/caged_adj_mock_2c387f4baccbd5.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 Flavor: r-devel-linux-x86_64-debian-clang

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [13s/52s] 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 (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd673cd11959.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd6711fc1ec3.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd6765d48bd0.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd67e1b387f.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd6746ca58c8.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd6714dff771.duckdb' Empty data.frame - nothing to write. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd6730078f23.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 [2.1s] ETA: ETA: 4s ==============================> 3/3 [3.1s] ETA: ETA: 0s No valid competency to download. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpRcK9Yj/file3bfd67e0a6438.duckdb' -- File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_3bfd675cada8ad' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_3bfd675cada8ad' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_3bfd675cada8ad' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/RtmpRcK9Yj/caged_dl_3bfd6720f28c1b' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/RtmpRcK9Yj/caged_lay_mock_3bfd672164b853/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 17.2s ETA ETA: 17s curl: (78) The file does not exist ==============================> 2/2 30.5s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_test_3bfd673f314796' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_test_3bfd673f314796' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_test_3bfd673f314796' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpRcK9Yj/novo_dir_3931495' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/novo_dir_3931495' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/novo_dir_3931495' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_ow_3bfd674dc78442' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_ow_3bfd674dc78442' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_ow_3bfd674dc78442' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpRcK9Yj/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_ow_3bfd674dc78442' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/RtmpRcK9Yj/parquet_ow_3bfd674dc78442' [ 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 `/home/hornik/tmp/scratch/RtmpRcK9Yj/caged_load_mock_3bfd6724699adb.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 `/home/hornik/tmp/scratch/RtmpRcK9Yj/caged_adj_mock_3bfd673a317de0.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 Flavor: r-devel-linux-x86_64-debian-gcc

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [17s/64s] 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 (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmprPwckn/file1a67482e65718a.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmprPwckn/file1a674854366730.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmprPwckn/file1a6748431fc6d8.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmprPwckn/file1a67486238e259.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmprPwckn/file1a6748133fff76.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmprPwckn/file1a67483046bc0e.duckdb' Empty data.frame - nothing to write. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmprPwckn/file1a674858717db3.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 [2.2s] ETA: ETA: 4s ==============================> 3/3 [3.4s] ETA: ETA: 0s No valid competency to download. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmprPwckn/file1a674843786026.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_1a67487d4c3f14' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_1a67487d4c3f14' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_1a67487d4c3f14' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/RtmprPwckn/caged_dl_1a67485a30c651' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/RtmprPwckn/caged_lay_mock_1a674873acaba9/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 15.6s ETA ETA: 16s curl: (78) The file does not exist ==============================> 2/2 28.9s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_test_1a67483b3e7053' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_test_1a67483b3e7053' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_test_1a67483b3e7053' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmprPwckn/novo_dir_1730376' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmprPwckn/novo_dir_1730376' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmprPwckn/novo_dir_1730376' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_ow_1a67486153a603' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_ow_1a67486153a603' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_ow_1a67486153a603' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmprPwckn/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_ow_1a67486153a603' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_ow_1a67486153a603' [ 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 `/home/hornik/tmp/scratch/RtmprPwckn/caged_load_mock_1a67487a663d33.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 `/home/hornik/tmp/scratch/RtmprPwckn/caged_adj_mock_1a67483ab62d4b.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 Flavor: r-patched-linux-x86_64

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [16s/64s] 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 (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c21f9919a.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c3755a5ca.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c35f59b5f.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c2505ea3a.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c39d49879.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c7eae71be.duckdb' Empty data.frame - nothing to write. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c3f9064e6.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 [1.8s] ETA: ETA: 4s ==============================> 3/3 [3s] ETA: ETA: 0s No valid competency to download. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). 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 keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/Rtmp0CNn1Z/file27aa0c76924d7.duckdb' -- File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_27aa0c3b42d260' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_27aa0c3b42d260' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_27aa0c3b42d260' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/caged_dl_27aa0cd321b28' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/Rtmp0CNn1Z/caged_lay_mock_27aa0c1557e571/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 15.7s ETA ETA: 16s curl: (78) The file does not exist ==============================> 2/2 29s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_test_27aa0c5629528f' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_test_27aa0c5629528f' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_test_27aa0c5629528f' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/novo_dir_2599436' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/novo_dir_2599436' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/novo_dir_2599436' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_ow_27aa0c10a5cd84' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_ow_27aa0c10a5cd84' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_ow_27aa0c10a5cd84' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp0CNn1Z/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_ow_27aa0c10a5cd84' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/Rtmp0CNn1Z/parquet_ow_27aa0c10a5cd84' [ 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 `/home/hornik/tmp/scratch/Rtmp0CNn1Z/caged_load_mock_27aa0c4ed9c024.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 `/home/hornik/tmp/scratch/Rtmp0CNn1Z/caged_adj_mock_27aa0c3f3f32b7.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 Flavor: r-release-linux-x86_64

Version: 0.2.1
Check: tests
Result: 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 (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... 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 <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> 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 Flavor: r-release-windows-x86_64

Version: 0.2.1
Check: tests
Result: ERROR Running 'testthat.R' [48s] 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 (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... 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_10_09_10_23_25_30964\Rtmp61wEpV\file6a54870da478a.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_10_09_10_23_25_30964\Rtmp61wEpV\file6a54820df56e.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_10_09_10_23_25_30964\Rtmp61wEpV\file6a548355e1d60.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_10_09_10_23_25_30964\Rtmp61wEpV\file6a5486fcdf52.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_10_09_10_23_25_30964\Rtmp61wEpV\file6a5486c19588f.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_10_09_10_23_25_30964\Rtmp61wEpV\file6a54830507ccd.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_10_09_10_23_25_30964\Rtmp61wEpV\file6a54816067f37.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 [4.4s] ETA: ETA: 9s ====================>---------- 2/3 [5.1s] ETA: ETA: 3s ==============================> 3/3 [5.7s] 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_10_09_10_23_25_30964\Rtmp61wEpV\file6a54827296373.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_10_09_10_23_25_30964\Rtmp61wEpV\parquet_6a548684740a3' 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_10_09_10_23_25_30964\Rtmp61wEpV\parquet_6a548684740a3' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_09_10_23_25_30964\Rtmp61wEpV\parquet_6a548684740a3' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: 'D:\temp\2026_10_09_10_23_25_30964\Rtmp61wEpV\caged_dl_6a5482ea8144c' 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_10_09_10_23_25_30964\Rtmp61wEpV\caged_lay_mock_6a5487fcc667d/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). ===============>--------------- 1/2 9.9s ETA ETA: 10s ==============================> 2/2 18.8s 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_10_09_10_23_25_30964\Rtmp61wEpV\parquet_test_6a5482408549c' 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_10_09_10_23_25_30964\Rtmp61wEpV\parquet_test_6a5482408549c' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_09_10_23_25_30964\Rtmp61wEpV\parquet_test_6a5482408549c' 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_10_09_10_23_25_30964\Rtmp61wEpV/novo_dir_435528' 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_10_09_10_23_25_30964\Rtmp61wEpV/novo_dir_435528' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_09_10_23_25_30964\Rtmp61wEpV/novo_dir_435528' 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_10_09_10_23_25_30964\Rtmp61wEpV\parquet_ow_6a5481669594b' 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_10_09_10_23_25_30964\Rtmp61wEpV\parquet_ow_6a5481669594b' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_09_10_23_25_30964\Rtmp61wEpV\parquet_ow_6a5481669594b' 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_10_09_10_23_25_30964\Rtmp61wEpV\parquet_ow_6a5481669594b' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: 'D:\temp\2026_10_09_10_23_25_30964\Rtmp61wEpV\parquet_ow_6a5481669594b' [ 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_10_09_10_23_25_30964\Rtmp61wEpV\caged_load_mock_6a548792068bb.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_10_09_10_23_25_30964\Rtmp61wEpV\caged_adj_mock_6a5487b4a2861.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 Flavor: r-oldrel-windows-x86_64