Package check result: OK Changes to worse in reverse depends: Package: BIEN Check: re-building of vignette outputs New result: ERROR Error(s) in re-building vignettes: ... --- re-building ‘BIEN.Rmd’ using rmarkdown [WARNING] Deprecated: --highlight-style. Use --syntax-highlighting instead. --- finished re-building ‘BIEN.Rmd’ --- re-building ‘BIEN_tutorial.Rmd’ using rmarkdown Quitting from BIEN_tutorial.Rmd:101-105 [xs-occurrences] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error in `postgresqlNewConnection()`: ! RPosgreSQL error: could not connect public_bien@vegbiendev.nceas.ucsb.edu:5432 on dbname "public_vegbien": connection to server at "vegbiendev.nceas.ucsb.edu" (128.111.85.31), port 5432 failed: Connection timed out Is the server running on that host and accepting TCP/IP connections? --- Backtrace: ▆ 1. └─BIEN::BIEN_occurrence_species(species = "Xanthium strumarium") 2. └─BIEN:::.BIEN_sql(query, ...) 3. ├─DBI::dbConnect(...) 4. └─RPostgreSQL::dbConnect(...) 5. └─RPostgreSQL::postgresqlNewConnection(drv, ...) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: processing vignette 'BIEN_tutorial.Rmd' failed with diagnostics: RPosgreSQL error: could not connect public_bien@vegbiendev.nceas.ucsb.edu:5432 on dbname "public_vegbien": connection to server at "vegbiendev.nceas.ucsb.edu" (128.111.85.31), port 5432 failed: Connection timed out Is the server running on that host and accepting TCP/IP connections? --- failed re-building ‘BIEN_tutorial.Rmd’ SUMMARY: processing the following file failed: ‘BIEN_tutorial.Rmd’ Error: Vignette re-building failed. Execution halted Package: dittodb Check: examples New result: ERROR Running examples in ‘dittodb-Ex.R’ failed The error most likely occurred in: > base::assign(".ptime", proc.time(), pos = "CheckExEnv") > ### Name: nycflights_sqlite > ### Title: An SQLite connection to a subset of nycflights13 > ### Aliases: nycflights_sqlite > > ### ** Examples > > if (check_for_pkg("RSQLite", message)) { + con <- nycflights_sqlite() + + DBI::dbGetQuery(con, "SELECT flight, tailnum, origin, dest FROM flights LIMIT 10") + DBI::dbGetQuery(con, "SELECT faa, name, lat, lon, alt, tz FROM airports") + + DBI::dbDisconnect(con) + } Error in find_file(path) : Couldn't find the file _home_hornik_tmp_CRAN_recheck_dittodb.Rcheck_dittodb_nycflights.sqlite/SELECT-c36080.R in any of the mock directories. Calls: ... dbFetch -> dbFetch -> read_file -> source -> find_file Execution halted Package: dittodb Check: tests New result: ERROR Running ‘spelling.R’ [0s/0s] Running ‘testthat.R’ [14s/14s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > test_check("dittodb") Loading required package: dittodb Loading required package: DBI Saving _problems/test-a-recording-9.R Saving _problems/test-a-recording-38.R Saving _problems/test-a-recording-49.R Saving _problems/test-connection-13.R There is no mock database being used. Saving _problems/test-dbi-sqlite-integration-2.R Saving _problems/test-dbplyr-integration-7.R There is no mock database being used. There is no mock database being used. Saving _problems/test-nycflights13-4.R Saving _problems/test-nycflights13-137.R There is no mock database being used. [ FAIL 10 | WARN 0 | SKIP 7 | PASS 174 ] ══ Skipped tests (7) ═══════════════════════════════════════════════════════════ • Skipping tests that need functioning MariaDB. (1): 'test-dbi-generic-integration.R:49:5' • Skipping tests that need functioning Postgres. (6): 'test-dbi-generic-integration.R:49:5', 'test-dbi-generic-integration.R:49:5', 'test-dbi-generic-integration.R:49:5', 'test-nycflights13.R:16:3', 'test-nycflights13.R:57:3', 'test-nycflights13.R:97:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-a-recording.R:9:3'): We can capture db interactions ──────────── Error in `get_dbname(list(...), drv = drv)`: unused argument (drv = drv) Backtrace: ▆ 1. ├─base::suppressMessages(con <- nycflights13_create_sqlite(verbose = FALSE)) at test-a-recording.R:9:3 2. │ └─base::withCallingHandlers(...) 3. └─dittodb::nycflights13_create_sqlite(verbose = FALSE) 4. └─DBI::dbConnect(RSQLite::SQLite(), location) 5. ├─base::.doTrace(...) 6. │ └─base::eval.parent(exprObj) 7. │ └─base::eval(expr, p) 8. │ └─base::eval(expr, p) 9. └─base::file.path(db_mock_paths()[1], get_dbname(list(...), drv = drv)) ── Error ('test-a-recording.R:38:3'): We can specify the path when starting capture ── Error in `get_dbname(list(...), drv = drv)`: unused argument (drv = drv) Backtrace: ▆ 1. ├─base::suppressMessages(con <- nycflights13_create_sqlite()) at test-a-recording.R:38:3 2. │ └─base::withCallingHandlers(...) 3. └─dittodb::nycflights13_create_sqlite() 4. └─DBI::dbConnect(RSQLite::SQLite(), location) 5. ├─base::.doTrace(...) 6. │ └─base::eval.parent(exprObj) 7. │ └─base::eval(expr, p) 8. │ └─base::eval(expr, p) 9. └─base::file.path(db_mock_paths()[1], get_dbname(list(...), drv = drv)) ── Error ('test-a-recording.R:49:3'): dbGetQuery error checking ──────────────── Error in `get_dbname(list(...), drv = drv)`: unused argument (drv = drv) Backtrace: ▆ 1. ├─base::suppressMessages(con <- nycflights13_create_sqlite(verbose = FALSE)) at test-a-recording.R:49:3 2. │ └─base::withCallingHandlers(...) 3. └─dittodb::nycflights13_create_sqlite(verbose = FALSE) 4. └─DBI::dbConnect(RSQLite::SQLite(), location) 5. ├─base::.doTrace(...) 6. │ └─base::eval.parent(exprObj) 7. │ └─base::eval(expr, p) 8. │ └─base::eval(expr, p) 9. └─base::file.path(db_mock_paths()[1], get_dbname(list(...), drv = drv)) ── Error ('test-connection.R:13:7'): And that RSQLite, without anything captures ── Error in `get_dbname(list(...), drv = drv)`: unused argument (drv = drv) Backtrace: ▆ 1. ├─dittodb::capture_db_requests(...) at test-connection.R:11:3 2. │ ├─dittodb::with_mock_path(path, eval(expr, where)) 3. │ │ └─base::eval.parent(expr) 4. │ │ └─base::eval(expr, p) 5. │ └─base::eval(expr, where) 6. └─DBI::dbConnect(RSQLite::SQLite()) at test-connection.R:13:7 7. ├─base::.doTrace(...) 8. │ └─base::eval.parent(exprObj) 9. │ └─base::eval(expr, p) 10. │ └─base::eval(expr, p) 11. └─base::file.path(db_mock_paths()[1], get_dbname(list(...), drv = drv)) ── Error ('test-dbi-sqlite-integration.R:2:1'): (code run outside of `test_that()`) ── Error in `find_file(path)`: Couldn't find the file _memory_/dbListTables.R in any of the mock directories. Backtrace: ▆ 1. ├─base::suppressMessages(con <- nycflights13_create_sqlite()) at test-dbi-sqlite-integration.R:2:1 2. │ └─base::withCallingHandlers(...) 3. └─dittodb::nycflights13_create_sqlite() 4. └─dittodb::nycflights13_create_sql(sqlite_con, schema = "", ...) 5. ├─DBI::dbListTables(con) 6. └─dittodb::dbListTables(con) 7. └─dittodb:::list_helper("dbListTables", conn, ...) 8. ├─dittodb:::read_file(find_file(path)) 9. │ └─base::source(file_path, keep.source = FALSE) 10. └─dittodb:::find_file(path) ── Error ('test-dbplyr-integration.R:7:1'): (code run outside of `test_that()`) ── Error in `find_file(path)`: Couldn't find the file _home_hornik_tmp_scratch_RtmpteZM8D_dbplyr_integration/dbListTables.R in any of the mock directories. Backtrace: ▆ 1. ├─base::suppressMessages(con <- nycflights13_create_sqlite(temp_path)) at test-dbplyr-integration.R:7:1 2. │ └─base::withCallingHandlers(...) 3. └─dittodb::nycflights13_create_sqlite(temp_path) 4. └─dittodb::nycflights13_create_sql(sqlite_con, schema = "", ...) 5. ├─DBI::dbListTables(con) 6. └─dittodb::dbListTables(con) 7. └─dittodb:::list_helper("dbListTables", conn, ...) 8. ├─dittodb:::read_file(find_file(path)) 9. │ └─base::source(file_path, keep.source = FALSE) 10. └─dittodb:::find_file(path) ── Error ('test-nycflights13.R:4:3'): nycflights sqlite can be created ───────── Error in `find_file(path)`: Couldn't find the file _memory_/dbListTables.R in any of the mock directories. Backtrace: ▆ 1. ├─base::suppressMessages(con <- nycflights13_create_sqlite()) at test-nycflights13.R:4:3 2. │ └─base::withCallingHandlers(...) 3. └─dittodb::nycflights13_create_sqlite() 4. └─dittodb::nycflights13_create_sql(sqlite_con, schema = "", ...) 5. ├─DBI::dbListTables(con) 6. └─dittodb::dbListTables(con) 7. └─dittodb:::list_helper("dbListTables", conn, ...) 8. ├─dittodb:::read_file(find_file(path)) 9. │ └─base::source(file_path, keep.source = FALSE) 10. └─dittodb:::find_file(path) ── Error ('test-nycflights13.R:137:3'): nycflights_db() test databes ─────────── Error in `find_file(path)`: Couldn't find the file _home_hornik_tmp_CRAN_recheck_dittodb.Rcheck_dittodb_nycflights.sqlite/SELECT-4013df.R in any of the mock directories. Backtrace: ▆ 1. ├─DBI::dbGetQuery(con, "SELECT * FROM flights LIMIT 10;") at test-nycflights13.R:137:3 2. └─DBI::dbGetQuery(con, "SELECT * FROM flights LIMIT 10;") 3. └─DBI (local) .local(conn, statement, ...) 4. ├─DBI::dbFetch(rs, n = n, ...) 5. └─dittodb::dbFetch(rs, n = n, ...) 6. ├─dittodb:::read_file(find_file(path)) 7. │ └─base::source(file_path, keep.source = FALSE) 8. └─dittodb:::find_file(path) ── Error ('test-verbosity.R:9:7'): level 1 includes statements and hashes ────── Error in `get_dbname(list(...), drv = drv)`: unused argument (drv = drv) Backtrace: ▆ 1. ├─withr::with_options(...) at test-verbosity.R:4:5 2. │ └─base::force(code) 3. ├─base::suppressMessages(con <- nycflights13_create_sqlite()) at test-verbosity.R:9:7 4. │ └─base::withCallingHandlers(...) 5. └─dittodb::nycflights13_create_sqlite() 6. └─DBI::dbConnect(RSQLite::SQLite(), location) 7. ├─base::.doTrace(...) 8. │ └─base::eval.parent(exprObj) 9. │ └─base::eval(expr, p) 10. │ └─base::eval(expr, p) 11. └─base::file.path(db_mock_paths()[1], get_dbname(list(...), drv = drv)) ── Error ('test-verbosity.R:59:11'): level 2 includes more ───────────────────── Error in `get_dbname(list(...), drv = drv)`: unused argument (drv = drv) Backtrace: ▆ 1. ├─withr::with_options(...) at test-verbosity.R:52:5 2. │ └─base::force(code) 3. ├─base::suppressMessages(...) at test-verbosity.R:56:7 4. │ └─base::withCallingHandlers(...) 5. ├─testthat::expect_message(...) 6. │ └─testthat:::expect_condition_matching_(...) 7. │ └─testthat:::quasi_capture(...) 8. │ ├─testthat (local) .capture(...) 9. │ │ └─base::withCallingHandlers(...) 10. │ └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo)) 11. └─dittodb::nycflights13_create_sqlite() at test-verbosity.R:59:11 12. └─DBI::dbConnect(RSQLite::SQLite(), location) 13. ├─base::.doTrace(...) 14. │ └─base::eval.parent(exprObj) 15. │ └─base::eval(expr, p) 16. │ └─base::eval(expr, p) 17. └─base::file.path(db_mock_paths()[1], get_dbname(list(...), drv = drv)) [ FAIL 10 | WARN 0 | SKIP 7 | PASS 174 ] Error: ! Test failures. Execution halted Package: OpenRange Check: re-building of vignette outputs New result: ERROR Error(s) in re-building vignettes: ... --- re-building ‘OpenRange.rmd’ using rmarkdown Quitting from OpenRange.rmd:22-31 [load species] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error in `postgresqlNewConnection()`: ! RPosgreSQL error: could not connect public_bien@vegbiendev.nceas.ucsb.edu:5432 on dbname "vegbien": connection to server at "vegbiendev.nceas.ucsb.edu" (128.111.85.31), port 5432 failed: Connection timed out Is the server running on that host and accepting TCP/IP connections? --- Backtrace: ▆ 1. └─OpenRange::OpenRange_load_species(species = "Pinus contorta") 2. └─OpenRange:::ranges_sql(query) 3. ├─DBI::dbConnect(...) 4. └─DBI::dbConnect(...) 5. └─RPostgreSQL::postgresqlNewConnection(drv, ...) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: processing vignette 'OpenRange.rmd' failed with diagnostics: RPosgreSQL error: could not connect public_bien@vegbiendev.nceas.ucsb.edu:5432 on dbname "vegbien": connection to server at "vegbiendev.nceas.ucsb.edu" (128.111.85.31), port 5432 failed: Connection timed out Is the server running on that host and accepting TCP/IP connections? --- failed re-building ‘OpenRange.rmd’ SUMMARY: processing the following file failed: ‘OpenRange.rmd’ Error: Vignette re-building failed. Execution halted