- using R Under development (unstable) (2024-09-28 r87201)
- using platform: x86_64-pc-linux-gnu
- R was compiled by
Debian clang version 19.1.0 (4)
Debian flang-new version 19.1.0 (4)
- running under: Debian GNU/Linux trixie/sid
- using session charset: UTF-8
- checking for file ‘pool/DESCRIPTION’ ... OK
- checking extension type ... Package
- this is package ‘pool’ version ‘1.0.3’
- package encoding: UTF-8
- checking package namespace information ... OK
- checking package dependencies ... OK
- checking if this is a source package ... OK
- checking if there is a namespace ... OK
- checking for executable files ... OK
- checking for hidden files and directories ... OK
- checking for portable file names ... OK
- checking for sufficient/correct file permissions ... OK
- checking whether package ‘pool’ can be installed ... OK
See the install log for details.
- checking package directory ... OK
- checking for future file timestamps ... OK
- checking ‘build’ directory ... OK
- checking DESCRIPTION meta-information ... OK
- checking top-level files ... OK
- checking for left-over files ... OK
- checking index information ... OK
- checking package subdirectories ... OK
- checking code files for non-ASCII characters ... OK
- checking R files for syntax errors ... OK
- checking whether the package can be loaded ... [1s/1s] OK
- checking whether the package can be loaded with stated dependencies ... [1s/1s] OK
- checking whether the package can be unloaded cleanly ... [1s/1s] OK
- checking whether the namespace can be loaded with stated dependencies ... [1s/1s] OK
- checking whether the namespace can be unloaded cleanly ... [1s/1s] OK
- checking loading without being on the library search path ... [1s/1s] OK
- checking whether startup messages can be suppressed ... [1s/1s] OK
- checking use of S3 registration ... OK
- checking dependencies in R code ... OK
- checking S3 generic/method consistency ... OK
- checking replacement functions ... OK
- checking foreign function calls ... OK
- checking R code for possible problems ... [7s/9s] OK
- checking Rd files ... [0s/1s] OK
- checking Rd metadata ... OK
- checking Rd line widths ... OK
- checking Rd cross-references ... OK
- checking for missing documentation entries ... OK
- checking for code/documentation mismatches ... OK
- checking Rd \usage sections ... OK
- checking Rd contents ... OK
- checking for unstated dependencies in examples ... OK
- checking installed files from ‘inst/doc’ ... OK
- checking files in ‘vignettes’ ... OK
- checking examples ... [2s/2s] 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
- checking for unstated dependencies in ‘tests’ ... OK
- checking tests ... [7s/9s] OK
Running ‘testthat.R’ [6s/8s]
- checking for unstated dependencies in vignettes ... OK
- checking package vignettes ... OK
- checking re-building of vignette outputs ... [2s/3s] 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
- checking PDF version of manual ... [6s/8s] OK
- checking HTML version of manual ... [1s/1s] OK
- checking for non-standard things in the check directory ... OK
- DONE
Status: 2 ERRORs