CRAN Package Check Results for Package datacaged

The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

CRAN Package Check Results for Package datacaged

Last updated on 2026-10-01 18:50:41 CEST.

Flavor	Version	T_install	T_check	T_total	Status
r-devel-linux-x86_64-debian-clang	0.2.1	6.62	96.05	102.67	OK
r-devel-linux-x86_64-debian-gcc	0.2.1	5.37	71.18	76.55	ERROR
r-devel-linux-x86_64-fedora-clang	0.2.1	6.00	70.64	76.64	ERROR
r-devel-linux-x86_64-fedora-gcc	0.2.1			74.10	ERROR
r-devel-windows-x86_64	0.2.1	10.00	148.00	158.00	OK
r-patched-linux-x86_64	0.2.1	7.66	87.14	94.80	ERROR
r-release-linux-x86_64	0.2.1	7.95	88.60	96.55	OK
r-release-macos-arm64	0.2.1	2.00	101.00	103.00	OK
r-release-macos-x86_64	0.2.1	6.00	222.00	228.00	OK
r-release-windows-x86_64	0.2.1	13.00	134.00	147.00	ERROR
r-oldrel-macos-arm64	0.2.1	2.00	102.00	104.00	OK
r-oldrel-macos-x86_64	0.2.1	6.00	211.00	217.00	OK
r-oldrel-windows-x86_64	0.2.1	16.00	167.00	183.00	OK

Check Details

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [13s/50s] 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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpzIDEFs/file16341433bf4eb.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpzIDEFs/file1634147bb76d2d.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpzIDEFs/file16341435ba9bc4.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpzIDEFs/file1634143a24c275.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpzIDEFs/file16341444ae3a27.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpzIDEFs/file163414544bd9ed.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 - '/home/hornik/tmp/scratch/RtmpzIDEFs/file1634143f0b0ff1.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 [1.8s] ETA: ETA: 4s ====================>---------- 2/3 [2.4s] ETA: ETA: 1s ==============================> 3/3 [2.9s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 - '/home/hornik/tmp/scratch/RtmpzIDEFs/file163414419bdba0.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_16341439027a88' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_16341439027a88' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_16341439027a88' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/RtmpzIDEFs/caged_dl_16341439eb2a7c' 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/RtmpzIDEFs/caged_lay_mock_16341420ab0f90/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.4s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_test_16341424747f21' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_test_16341424747f21' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_test_16341424747f21' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/novo_dir_1455124' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/novo_dir_1455124' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpzIDEFs/novo_dir_1455124' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_ow_16341468497269' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_ow_16341468497269' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_ow_16341468497269' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_ow_16341468497269' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/RtmpzIDEFs/parquet_ow_16341468497269' [ 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/RtmpzIDEFs/caged_load_mock_1634144f56968c.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/RtmpzIDEFs/caged_adj_mock_16341436fb2c6.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’ [11s/63s] 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 /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b444d281c5.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to ':memory:' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b44452da65e8.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. 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 /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b444eb4b735.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b44433c4b665.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b4443b620fd4.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b4443d1c7f2d.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- datacaged - '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b444822be60.duckdb' File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. 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 [2.9s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. 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 /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- datacaged - '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b4446ce3c8ae.duckdb File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_37b444848c36a' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_37b444848c36a' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_37b444848c36a' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_dl_37b44433f4834d' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_lay_mock_37b4445d877de9/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 18.7s ETA ETA: 19s curl: (78) The file does not exist ==============================> 2/2 32.4s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_test_37b4447a804bea' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_test_37b4447a804bea' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_test_37b4447a804bea' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/novo_dir_3650628' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/novo_dir_3650628' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/novo_dir_3650628' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' [ 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 `/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_load_mock_37b44475db8659.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 `/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_adj_mock_37b4444dbc9484.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-fedora-clang

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [11s/35s] 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 /data/localhost/ripley/.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 '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e4771e44a160.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e4775a0222cf.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e4775ab50ac2.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e47765668193.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e4777d99711e.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e4772b962ea8.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 - '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e47769093cd4.duckdb File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 [1.3s] ETA: ETA: 3s ==============================> 3/3 [2.2s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 - '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/file29e477ee6434a.duckdb' File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_29e4774deca137' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_29e4774deca137' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_29e4774deca137' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/caged_dl_29e477500c2b7a' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/caged_lay_mock_29e4779fbee56/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 11.5s ETA ETA: 11s curl: (78) The file does not exist ==============================> 2/2 21.9s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_test_29e477683fff7a' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_test_29e477683fff7a' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_test_29e477683fff7a' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/novo_dir_2745463' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/novo_dir_2745463' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/novo_dir_2745463' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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 /data/localhost/ripley/.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 /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_ow_29e4771a1cec33' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_ow_29e4771a1cec33' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_ow_29e4771a1cec33' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.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: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_ow_29e4771a1cec33' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/parquet_ow_29e4771a1cec33' [ 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 `/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/caged_load_mock_29e477139efaed.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 `/tmp/RtmpUQNCk6/working_dir/RtmpEjOy7v/caged_adj_mock_29e477799c481e.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-fedora-gcc

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [16s/62s] 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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec7680eb1f.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec76609482.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173eca6325e4.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec3b014daa.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec6ec597dd.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec48e7812f.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 - '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec30dc9ed4.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 [2s] ETA: ETA: 4s ====================>---------- 2/3 [2.6s] ETA: ETA: 1s ==============================> 3/3 [3.2s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 - '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec1bc74a78.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_1173ec3c34ef11' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_1173ec3c34ef11' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_1173ec3c34ef11' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/RtmpQ9Nfli/caged_dl_1173ec77010bc9' 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/RtmpQ9Nfli/caged_lay_mock_1173ec3a4612af/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 29.1s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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 /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_test_1173ec40ce0359' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_test_1173ec40ce0359' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_test_1173ec40ce0359' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/novo_dir_1143788' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/novo_dir_1143788' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/novo_dir_1143788' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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 /home/hornik/.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 /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.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: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' [ 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/RtmpQ9Nfli/caged_load_mock_1173ec28108d0b.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/RtmpQ9Nfli/caged_adj_mock_1173ec31326179.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' [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

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.