Running ‘testthat.R’ [19s/32s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test configuration?
  > # Learn more about the roles of various files in:
  > # * https://r-pkgs.org/tests.html
  > # * https://testthat.r-lib.org/reference/test_package.html#special-files
  > 
  > library(testthat)
  > library(CDMConnector)
  > 
  > test_check("CDMConnector")
  [ FAIL 9 | WARN 0 | SKIP 26 | PASS 11 ]
  
  ══ Skipped tests ═══════════════════════════════════════════════════════════════
  • CirceR cannot be loaded (1)
  • Sys.getenv("CDM5_POSTGRESQL_USER") == "" is TRUE (7)
  • Sys.getenv("CDM5_REDSHIFT_USER") == "" is TRUE (7)
  • Sys.getenv("CDM5_SQL_SERVER_USER") == "" is TRUE (7)
  • Sys.getenv("LOCAL_POSTGRESQL_USER") == "" is TRUE (3)
  • Sys.getenv("REDSHIFT_USER") == "" is TRUE (1)
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error ('test-cdm.R:140'): cdm reference works on duckdb ─────────────────────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir()) at test-cdm.R:140:2
   2. └─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-cdm.R:162'): inclusion of cohort tables ────────────────────────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir()) at test-cdm.R:162:2
   2. └─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-cdm.R:192'): collect a cdm ─────────────────────────────────────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir()) at test-cdm.R:192:2
   2. └─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-cdm.R:217'): stow and cdm_from_files works ─────────────────────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir()) at test-cdm.R:217:2
   2. └─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-cdm.R:374'): autodetect cdm version works ──────────────────────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir()) at test-cdm.R:374:2
   2. └─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-computePermanent.R:7'): computePermanent works on duckdb ───────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir()) at test-computePermanent.R:7:2
   2. └─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-dbConnectDetails.R:81'): dbConnectDetails works on duckdb ──────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
       ▆
    1. └─CDMConnector (local) self_contained_query(details, "main") at test-dbConnectDetails.R:81:2
    2.   ├─base::suppressMessages(...) at test-dbConnectDetails.R:6:2
    3.   │ └─base::withCallingHandlers(...)
    4.   ├─DBI::dbConnect(connection_details) at test-dbConnectDetails.R:7:4
    5.   └─DBI::dbConnect(connection_details)
    6.     └─CDMConnector (local) .local(drv, ...)
    7.       ├─rlang::inject(DBI::dbConnect(!!!l))
    8.       ├─DBI::dbConnect(`<dckdb_dr>`, dbdir = "/home/hornik/tmp/scratch/RtmpJM3U3V/fiaunysw/cdm.duckdb")
    9.       └─DBI::dbConnect(`<dckdb_dr>`, dbdir = "/home/hornik/tmp/scratch/RtmpJM3U3V/fiaunysw/cdm.duckdb")
   10.         └─duckdb (local) .local(drv, ...)
   11.           └─duckdb::duckdb(dbdir, read_only, bigint, config)
   12.             ├─methods::new(...)
   13.             │ ├─methods::initialize(value, ...)
   14.             │ └─methods::initialize(value, ...)
   15.             └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-validate.R:5'): validate cdm works ─────────────────────────────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), eunomia_dir()) at test-validate.R:5:2
   2. └─DBI::dbConnect(duckdb::duckdb(), eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  ── Error ('test-validate.R:20'): assert_tables works ───────────────────────────
  Error: rapi_startup: Failed to open database: IO Error: Trying to read a database file with version number 39, but we can only read version 41.
  The database file was created with DuckDB version v0.6.0 or v0.6.1.
  
  The storage of DuckDB is not yet stable; newer versions of DuckDB cannot read old database files and vice versa.
  The storage will be stabilized when version 1.0 releases.
  
  For now, we recommend that you load the database file in a supported version of DuckDB, and use the EXPORT DATABASE command followed by IMPORT DATABASE on the current version of DuckDB.
  
  See the storage page for more information: https://duckdb.org/internals/storage
  Backtrace:
      ▆
   1. ├─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir()) at test-validate.R:20:2
   2. └─DBI::dbConnect(duckdb::duckdb(), dbdir = eunomia_dir())
   3.   └─duckdb (local) .local(drv, ...)
   4.     └─duckdb::duckdb(dbdir, read_only, bigint, config)
   5.       ├─methods::new(...)
   6.       │ ├─methods::initialize(value, ...)
   7.       │ └─methods::initialize(value, ...)
   8.       └─duckdb:::rapi_startup(dbdir, read_only, config)
  
  [ FAIL 9 | WARN 0 | SKIP 26 | PASS 11 ]
  Error: Test failures
  Execution halted
  Warning messages:
  1: Connection is garbage-collected, use dbDisconnect() to avoid this. 
  2: Database is garbage-collected, use dbDisconnect(con, shutdown=TRUE) or duckdb::duckdb_shutdown(drv) to avoid this.