CRAN Package Check Results for Package pool

Last updated on 2024-09-27 03:49:53 CEST.

Flavor Version Tinstall Tcheck Ttotal Status Flags
r-devel-linux-x86_64-debian-clang 1.0.3 5.42 48.00 53.42 ERROR
r-devel-linux-x86_64-debian-gcc 1.0.3 3.71 35.91 39.62 ERROR
r-devel-linux-x86_64-fedora-clang 1.0.3 47.31 ERROR
r-devel-linux-x86_64-fedora-gcc 1.0.3 52.86 ERROR
r-devel-windows-x86_64 1.0.3 6.00 74.00 80.00 ERROR
r-patched-linux-x86_64 1.0.3 5.60 45.52 51.12 ERROR
r-release-linux-x86_64 1.0.3 3.57 45.69 49.26 ERROR
r-release-macos-arm64 1.0.3 38.00 OK
r-release-macos-x86_64 1.0.3 56.00 OK
r-release-windows-x86_64 1.0.3 6.00 71.00 77.00 ERROR
r-oldrel-macos-arm64 1.0.3 40.00 OK
r-oldrel-macos-x86_64 1.0.3 67.00 OK
r-oldrel-windows-x86_64 1.0.3 8.00 80.00 88.00 ERROR

Check Details

Version: 1.0.3
Check: examples
Result: ERROR Running examples in ‘pool-Ex.R’ failed The error most likely occurred in: > base::assign(".ptime", proc.time(), pos = "CheckExEnv") > ### Name: dbPool > ### Title: Create a pool of database connections > ### Aliases: dbPool > > ### ** Examples > > # You use a dbPool in the same way as a standard DBI connection > pool <- dbPool(RSQLite::SQLite()) > pool <Pool> of SQLiteConnection objects Objects checked out: 0 Available in pool: 1 Max size: Inf Valid: TRUE > > DBI::dbWriteTable(pool, "mtcars", mtcars) > dbGetQuery(pool, "SELECT * FROM mtcars LIMIT 4") mpg cyl disp hp drat wt qsec vs am gear carb 1 21.0 6 160 110 3.90 2.620 16.46 0 1 4 4 2 21.0 6 160 110 3.90 2.875 17.02 0 1 4 4 3 22.8 4 108 93 3.85 2.320 18.61 1 1 4 1 4 21.4 6 258 110 3.08 3.215 19.44 1 0 3 1 > > # Always close a pool when you're done using it > poolClose(pool) > > # Using the RMySQL package > if (requireNamespace("RMySQL", quietly = TRUE)) { + pool <- dbPool( + drv = RMySQL::MySQL(), + dbname = "shinydemo", + host = "shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com", + username = "guest", + password = "guest" + ) + + dbGetQuery(pool, "SELECT * from City LIMIT 5;") + + poolClose(pool) + } Error in .local(drv, ...) : Failed to connect to database: Error: Unknown server host 'shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com' (-2) Calls: dbPool ... <Anonymous> -> dbConnect -> dbConnect -> .local -> .Call Execution halted Flavors: r-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-patched-linux-x86_64, r-release-linux-x86_64

Version: 1.0.3
Check: re-building of vignette outputs
Result: ERROR Error(s) in re-building vignettes: ... --- re-building ‘why-pool.Rmd’ using rmarkdown Quitting from lines 34-75 [unnamed-chunk-2] (why-pool.Rmd) Error: processing vignette 'why-pool.Rmd' failed with diagnostics: Failed to connect to database: Error: Unknown server host 'shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com' (-2) --- failed re-building ‘why-pool.Rmd’ SUMMARY: processing the following file failed: ‘why-pool.Rmd’ Error: Vignette re-building failed. Execution halted Flavors: r-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-patched-linux-x86_64, r-release-linux-x86_64

Version: 1.0.3
Check: examples
Result: ERROR Running examples in ‘pool-Ex.R’ failed The error most likely occurred in: > ### Name: dbPool > ### Title: Create a pool of database connections > ### Aliases: dbPool > > ### ** Examples > > # You use a dbPool in the same way as a standard DBI connection > pool <- dbPool(RSQLite::SQLite()) > pool <Pool> of SQLiteConnection objects Objects checked out: 0 Available in pool: 1 Max size: Inf Valid: TRUE > > DBI::dbWriteTable(pool, "mtcars", mtcars) > dbGetQuery(pool, "SELECT * FROM mtcars LIMIT 4") mpg cyl disp hp drat wt qsec vs am gear carb 1 21.0 6 160 110 3.90 2.620 16.46 0 1 4 4 2 21.0 6 160 110 3.90 2.875 17.02 0 1 4 4 3 22.8 4 108 93 3.85 2.320 18.61 1 1 4 1 4 21.4 6 258 110 3.08 3.215 19.44 1 0 3 1 > > # Always close a pool when you're done using it > poolClose(pool) > > # Using the RMySQL package > if (requireNamespace("RMySQL", quietly = TRUE)) { + pool <- dbPool( + drv = RMySQL::MySQL(), + dbname = "shinydemo", + host = "shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com", + username = "guest", + password = "guest" + ) + + dbGetQuery(pool, "SELECT * from City LIMIT 5;") + + poolClose(pool) + } Error in .local(drv, ...) : Failed to connect to database: Error: Unknown server host 'shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com' (-2) Calls: dbPool ... <Anonymous> -> dbConnect -> dbConnect -> .local -> .Call Execution halted Flavors: r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc

Version: 1.0.3
Check: re-building of vignette outputs
Result: ERROR Error(s) in re-building vignettes: --- re-building ‘why-pool.Rmd’ using rmarkdown Quitting from lines 34-75 [unnamed-chunk-2] (why-pool.Rmd) Error: processing vignette 'why-pool.Rmd' failed with diagnostics: Failed to connect to database: Error: Unknown server host 'shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com' (-2) --- failed re-building ‘why-pool.Rmd’ SUMMARY: processing the following file failed: ‘why-pool.Rmd’ Error: Vignette re-building failed. Execution halted Flavors: r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc

Version: 1.0.3
Check: examples
Result: ERROR Running examples in 'pool-Ex.R' failed The error most likely occurred in: > ### Name: dbPool > ### Title: Create a pool of database connections > ### Aliases: dbPool > > ### ** Examples > > # You use a dbPool in the same way as a standard DBI connection > pool <- dbPool(RSQLite::SQLite()) > pool <Pool> of SQLiteConnection objects Objects checked out: 0 Available in pool: 1 Max size: Inf Valid: TRUE > > DBI::dbWriteTable(pool, "mtcars", mtcars) > dbGetQuery(pool, "SELECT * FROM mtcars LIMIT 4") mpg cyl disp hp drat wt qsec vs am gear carb 1 21.0 6 160 110 3.90 2.620 16.46 0 1 4 4 2 21.0 6 160 110 3.90 2.875 17.02 0 1 4 4 3 22.8 4 108 93 3.85 2.320 18.61 1 1 4 1 4 21.4 6 258 110 3.08 3.215 19.44 1 0 3 1 > > # Always close a pool when you're done using it > poolClose(pool) > > # Using the RMySQL package > if (requireNamespace("RMySQL", quietly = TRUE)) { + pool <- dbPool( + drv = RMySQL::MySQL(), + dbname = "shinydemo", + host = "shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com", + username = "guest", + password = "guest" + ) + + dbGetQuery(pool, "SELECT * from City LIMIT 5;") + + poolClose(pool) + } Error in .local(drv, ...) : Failed to connect to database: Error: Unknown server host 'shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com' (11001) Calls: dbPool ... <Anonymous> -> dbConnect -> dbConnect -> .local -> .Call Execution halted Flavors: r-devel-windows-x86_64, r-release-windows-x86_64, r-oldrel-windows-x86_64

Version: 1.0.3
Check: re-building of vignette outputs
Result: ERROR Error(s) in re-building vignettes: --- re-building 'why-pool.Rmd' using rmarkdown Quitting from lines 34-75 [unnamed-chunk-2] (why-pool.Rmd) Error: processing vignette 'why-pool.Rmd' failed with diagnostics: Failed to connect to database: Error: Unknown server host 'shiny-demo.csa7qlmguqrf.us-east-1.rds.amazonaws.com' (11001) --- failed re-building 'why-pool.Rmd' SUMMARY: processing the following file failed: 'why-pool.Rmd' Error: Vignette re-building failed. Execution halted Flavors: r-devel-windows-x86_64, r-release-windows-x86_64, r-oldrel-windows-x86_64