* using log directory 'd:/Rcompile/CRANpkg/local/3.4/mdsr.Rcheck' * using R version 3.4.4 (2018-03-15) * using platform: x86_64-w64-mingw32 (64-bit) * using session charset: ISO8859-1 * checking for file 'mdsr/DESCRIPTION' ... OK * this is package 'mdsr' version '0.1.6' * 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 'mdsr' can be installed ... OK * checking installed package size ... NOTE installed size is 5.5Mb sub-directories of 1Mb or more: data 5.4Mb * checking package 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 R files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... OK * checking whether the package can be loaded with stated dependencies ... OK * checking whether the package can be unloaded cleanly ... OK * checking whether the namespace can be loaded with stated dependencies ... OK * checking whether the namespace can be unloaded cleanly ... OK * checking loading without being on the library search path ... WARNING Loading required package: dplyr Attaching package: 'dplyr' The following objects are masked from 'package:stats': filter, lag The following objects are masked from 'package:base': intersect, setdiff, setequal, union Loading required package: lattice Error: package or namespace load failed for 'mdsr': .onAttach failed in attachNamespace() for 'mdsr', details: call: value[[3L]](cond) error: Package 'lattice' version 0.20.38 cannot be unloaded: Error in unloadNamespace(package) : namespace 'lattice' is imported by 'nlme', 'Matrix', 'mosaic' so cannot be unloaded Execution halted It looks like this package has a loading problem when not on .libPaths: see the messages for details. * 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 ... [10s] OK * checking Rd files ... 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 contents of 'data' directory ... OK * checking data for non-ASCII characters ... OK * checking data for ASCII and uncompressed saves ... OK * checking examples ... ERROR Running examples in 'mdsr-Ex.R' failed The error most likely occurred in: > ### Name: src_scidb > ### Title: src_scidb > ### Aliases: src_scidb dbConnect_scidb mysql_scidb > > ### ** Examples > > > dbAir <- src_scidb("airlines") Error in .local(drv, ...) : Failed to connect to database: Error: Too many connections Calls: src_scidb ... dbConnect_scidb -> -> -> .local -> .Call Execution halted * checking for unstated dependencies in 'tests' ... OK * checking tests ... [5s] ERROR Running 'testthat.R' [5s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(mdsr) Loading required package: dplyr Attaching package: 'dplyr' The following object is masked from 'package:testthat': matches The following objects are masked from 'package:stats': filter, lag The following objects are masked from 'package:base': intersect, setdiff, setequal, union Loading required package: lattice Loading required package: ggformula Loading required package: ggplot2 Loading required package: ggstance Attaching package: 'ggstance' The following objects are masked from 'package:ggplot2': GeomErrorbarh, geom_errorbarh New to ggformula? Try the tutorials: learnr::run_tutorial("introduction", package = "ggformula") learnr::run_tutorial("refining", package = "ggformula") Loading required package: mosaicData Loading required package: Matrix The 'mosaic' package masks several functions from core packages in order to add additional features. The original behavior of these functions should not be affected by this. Note: If you use the Matrix package, be sure to load it BEFORE loading mosaic. In accordance with CRAN policy, the 'mdsr' package no longer attaches the 'tidyverse' package automatically. You may need to 'library(tidyverse)' in order to use certain functions. > > test_check("mdsr") -- 1. Error: scidb works (@tests.R#4) ----------------------------------------- Failed to connect to database: Too many connections 1: src_scidb("airlines") at testthat/tests.R:4 2: dbplyr::src_dbi(dbConnect_scidb(dbname, ...)) 3: paste0("src_", class(con)[[1]]) 4: dbConnect_scidb(dbname, ...) 5: DBI::dbConnect(RMySQL::MySQL(), dbname = dbname, host = "mdsr.cdc7tgkkqd0n.us-east-1.rds.amazonaws.com", user = "mdsr_public", password = "ImhsmflMDSwR") 6: DBI::dbConnect(RMySQL::MySQL(), dbname = dbname, host = "mdsr.cdc7tgkkqd0n.us-east-1.rds.amazonaws.com", user = "mdsr_public", password = "ImhsmflMDSwR") 7: .local(drv, ...) == testthat results =========================================================== OK: 0 SKIPPED: 0 WARNINGS: 0 FAILED: 1 1. Error: scidb works (@tests.R#4) Error: testthat unit tests failed Execution halted * checking PDF version of manual ... OK * DONE Status: 2 ERRORs, 1 WARNING, 1 NOTE