* using log directory 'd:/Rcompile/CRANpkg/local/4.4/pool.Rcheck' * using R version 4.4.1 (2024-06-14 ucrt) * using platform: x86_64-w64-mingw32 * R was compiled by gcc.exe (GCC) 13.2.0 GNU Fortran (GCC) 13.2.0 * running under: Windows Server 2022 x64 (build 20348) * 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 hidden files and directories ... OK * checking for portable file names ... OK * checking whether package 'pool' can be installed ... OK * checking installed package size ... OK * checking package directory ... 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] OK * checking whether the package can be loaded with stated dependencies ... [1s] OK * checking whether the package can be unloaded cleanly ... [1s] OK * checking whether the namespace can be loaded with stated dependencies ... [1s] OK * checking whether the namespace can be unloaded cleanly ... [1s] OK * checking loading without being on the library search path ... [1s] OK * checking whether startup messages can be suppressed ... [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 ... [4s] OK * checking Rd files ... [1s] OK * checking Rd metadata ... 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] 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 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 ... -> dbConnect -> dbConnect -> .local -> .Call Execution halted * checking for unstated dependencies in 'tests' ... OK * checking tests ... [6s] OK Running 'testthat.R' [6s] * checking for unstated dependencies in vignettes ... OK * checking package vignettes ... OK * checking re-building of vignette outputs ... [2s] 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 * checking PDF version of manual ... [28s] OK * checking HTML version of manual ... [2s] OK * DONE Status: 2 ERRORs