Back to Multiple platform build/check report for BioC 3.24:   simplified   long
ABCDEFGHIJKL[M]NOPQRSTUVWXYZ

This page was generated on 2026-05-23 11:36 -0400 (Sat, 23 May 2026).

HostnameOSArch (*)R versionInstalled pkgs
nebbiolo2Linux (Ubuntu 24.04.4 LTS)x86_644.6.0 RC (2026-04-17 r89917) -- "Because it was There" 4937
kjohnson3macOS 13.7.7 Venturaarm644.6.0 Patched (2026-05-01 r89994) -- "Because it was There" 4639
Click on any hostname to see more info about the system (e.g. compilers)      (*) as reported by 'uname -p', except on Windows and Mac OS X

Package 1391/2379HostnameOS / ArchINSTALLBUILDCHECKBUILD BIN
MsBackendSql 1.13.0  (landing page)
Johannes Rainer
Snapshot Date: 2026-05-22 13:45 -0400 (Fri, 22 May 2026)
git_url: https://git.bioconductor.org/packages/MsBackendSql
git_branch: devel
git_last_commit: 596d363
git_last_commit_date: 2026-04-28 08:59:36 -0400 (Tue, 28 Apr 2026)
nebbiolo2Linux (Ubuntu 24.04.4 LTS) / x86_64  OK    OK    OK  UNNEEDED, same version is already published
kjohnson3macOS 13.7.7 Ventura / arm64  OK    OK    OK  UNNEEDED, same version is already published
See other builds for MsBackendSql in R Universe.


CHECK results for MsBackendSql on kjohnson3

To the developers/maintainers of the MsBackendSql package:
- Allow up to 24 hours (and sometimes 48 hours) for your latest push to git@git.bioconductor.org:packages/MsBackendSql.git to reflect on this report. See Troubleshooting Build Report for more information.
- Use the following Renviron settings to reproduce errors and warnings.
- If 'R CMD check' started to fail recently on the Linux builder(s) over a missing dependency, add the missing dependency to 'Suggests:' in your DESCRIPTION file. See Renviron.bioc for more information.

raw results


Summary

Package: MsBackendSql
Version: 1.13.0
Command: /Library/Frameworks/R.framework/Resources/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/Library/Frameworks/R.framework/Resources/library --no-vignettes --timings MsBackendSql_1.13.0.tar.gz
StartedAt: 2026-05-22 20:42:19 -0400 (Fri, 22 May 2026)
EndedAt: 2026-05-22 20:46:13 -0400 (Fri, 22 May 2026)
EllapsedTime: 233.9 seconds
RetCode: 0
Status:   OK  
CheckDir: MsBackendSql.Rcheck
Warnings: 0

Command output

##############################################################################
##############################################################################
###
### Running command:
###
###   /Library/Frameworks/R.framework/Resources/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/Library/Frameworks/R.framework/Resources/library --no-vignettes --timings MsBackendSql_1.13.0.tar.gz
###
##############################################################################
##############################################################################


* using log directory ‘/Users/biocbuild/bbs-3.24-bioc/meat/MsBackendSql.Rcheck’
* using R version 4.6.0 Patched (2026-05-01 r89994)
* using platform: aarch64-apple-darwin23
* R was compiled by
    Apple clang version 17.0.0 (clang-1700.3.19.1)
    GNU Fortran (GCC) 14.2.0
* running under: macOS Tahoe 26.3.1
* using session charset: UTF-8
* current time: 2026-05-23 00:42:20 UTC
* using option ‘--no-vignettes’
* checking for file ‘MsBackendSql/DESCRIPTION’ ... OK
* this is package ‘MsBackendSql’ version ‘1.13.0’
* 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 for sufficient/correct file permissions ... OK
* checking whether package ‘MsBackendSql’ 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 ... 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 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 ... 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 files in ‘vignettes’ ... OK
* checking examples ... OK
* checking for unstated dependencies in ‘tests’ ... OK
* checking tests ...
  Running ‘testthat.R’
 OK
* checking for unstated dependencies in vignettes ... OK
* checking package vignettes ... OK
* checking running R code from vignettes ... SKIPPED
* checking re-building of vignette outputs ... SKIPPED
* checking PDF version of manual ... OK
* DONE

Status: OK


Installation output

MsBackendSql.Rcheck/00install.out

##############################################################################
##############################################################################
###
### Running command:
###
###   /Library/Frameworks/R.framework/Resources/bin/R CMD INSTALL MsBackendSql
###
##############################################################################
##############################################################################


* installing to library ‘/Library/Frameworks/R.framework/Versions/4.6/Resources/library’
* installing *source* package ‘MsBackendSql’ ...
** this is package ‘MsBackendSql’ version ‘1.13.0’
** using staged installation
** R
** byte-compile and prepare package for lazy loading
** help
*** installing help indices
*** copying figures
** building package indices
** installing vignettes
** testing if installed package can be loaded from temporary location
** testing if installed package can be loaded from final location
** testing if installed package keeps a record of temporary installation path
* DONE (MsBackendSql)

Tests output

MsBackendSql.Rcheck/tests/testthat.Rout


R version 4.6.0 Patched (2026-05-01 r89994) -- "Because it was There"
Copyright (C) 2026 The R Foundation for Statistical Computing
Platform: aarch64-apple-darwin23

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> library(testthat)
> library(MsBackendSql)
Loading required package: Spectra
Loading required package: S4Vectors
Loading required package: stats4
Loading required package: BiocGenerics
Loading required package: generics

Attaching package: 'generics'

The following objects are masked from 'package:base':

    as.difftime, as.factor, as.ordered, intersect, is.element, setdiff,
    setequal, union


Attaching package: 'BiocGenerics'

The following objects are masked from 'package:stats':

    IQR, mad, sd, var, xtabs

The following object is masked from 'package:utils':

    data

The following objects are masked from 'package:base':

    Filter, Find, Map, Position, Reduce, anyDuplicated, aperm, append,
    as.data.frame, basename, cbind, colnames, dirname, do.call,
    duplicated, eval, evalq, get, grep, grepl, is.unsorted, lapply,
    mapply, match, mget, order, paste, pmax, pmax.int, pmin, pmin.int,
    rank, rbind, rownames, sapply, saveRDS, table, tapply, unique,
    unsplit, which.max, which.min


Attaching package: 'S4Vectors'

The following object is masked from 'package:utils':

    findMatches

The following objects are masked from 'package:base':

    I, expand.grid, unname

Loading required package: BiocParallel
> library(Spectra)
> library(RSQLite)
> library(MsDataHub)
> 
> setClass("DummySQL",
+          contains = "SQLiteConnection")
> 
> setMethod("dbExecute", c("DummySQL", "character"),
+           function(conn, statement, ...) {
+               TRUE
+           })
> 
> a_file <- MsDataHub::X20171016_POOL_POS_1_105.134.mzML()
see ?MsDataHub and browseVignettes('MsDataHub') for documentation
loading from cache
> a_sps <- Spectra(a_file)
> a_db_long <- dbConnect(SQLite(), tempfile())
> createMsBackendSqlDatabase(a_db_long, a_file, blob = FALSE,
+                            peaksStorageMode = "long")
Importing data ... 

[==========================================================] 1/1 (100%) in  1s
Creating indices .... Done
[1] TRUE
> a_be_long <- backendInitialize(MsBackendSql(), a_db_long)
> 
> a_db_blob <- dbConnect(SQLite(), tempfile())
> createMsBackendSqlDatabase(a_db_blob, a_file, blob = TRUE,
+                            peaksStorageMode = "blob")
Importing data ... 

[==========================================================] 1/1 (100%) in  1s
Creating indices .... Done
[1] TRUE
> a_be_blob <- backendInitialize(MsBackendSql(), a_db_blob)
> 
> a_db_blob2 <- dbConnect(SQLite(), tempfile())
> createMsBackendSqlDatabase(a_db_blob2, a_file, blob = TRUE,
+                            peaksStorageMode = "blob2")
Importing data ... 

[==========================================================] 1/1 (100%) in  1s
Creating indices .... Done
[1] TRUE
> a_be_blob2 <- backendInitialize(MsBackendSql(), a_db_blob2)
> 
> ################################################################################
> ##
> ##  OPTIONAL TESTS WITH duckdb
> ## library(duckdb)
> ## mm8_db_long <- dbConnect(duckdb(), tempfile())
> ## createMsBackendSqlDatabase(mm8_db_long, mm8_file, blob = FALSE,
> ##                            peaksStorageMode = "long")
> ## mm8_be_long <- backendInitialize(MsBackendSql(), mm8_db_long)
> 
> ## mm8_db_blob <- dbConnect(duckdb(), tempfile())
> ## createMsBackendSqlDatabase(mm8_db_blob, mm8_file, blob = TRUE,
> ##                            peaksStorageMode = "blob")
> ## mm8_be_blob <- backendInitialize(MsBackendSql(), mm8_db_blob)
> 
> ## mm8_db_blob2 <- dbConnect(duckdb(), tempfile())
> ## createMsBackendSqlDatabase(mm8_db_blob2, mm8_file, blob = TRUE,
> ##                            peaksStorageMode = "blob2")
> ## mm8_be_blob2 <- backendInitialize(MsBackendSql(), mm8_db_blob2)
> ##
> ################################################################################
> 
> b_file <- MsDataHub::X20171016_POOL_POS_3_105.134.mzML()
see ?MsDataHub and browseVignettes('MsDataHub') for documentation
loading from cache
> mm_db <- dbConnect(SQLite(), tempfile())
> createMsBackendSqlDatabase(mm_db, c(a_file, b_file), blob = FALSE)
Importing data ... 

[==========================================================] 1/1 (100%) in  2s
Creating indices .... Done
[1] TRUE
> mm_be <- backendInitialize(MsBackendSql(), mm_db)
> 
> tmt_file <- MsDataHub::TMT_Erwinia_1uLSike_Top10HCD_isol2_45stepped_60min_01.20141210.mzML.gz()
see ?MsDataHub and browseVignettes('MsDataHub') for documentation
loading from cache
> tmt_mzr <- backendInitialize(MsBackendMzR(), tmt_file)
> tmt_db <- dbConnect(SQLite(), tempfile())
> createMsBackendSqlDatabase(tmt_db, tmt_file, blob = FALSE)
Importing data ... 

[==========================================================] 1/1 (100%) in 23s
Creating indices .... Done
[1] TRUE
> tmt_be <- backendInitialize(MsBackendSql(), tmt_db)
> 
> test_check("MsBackendSql")
[ FAIL 0 | WARN 3 | SKIP 0 | PASS 640 ]

[ FAIL 0 | WARN 3 | SKIP 0 | PASS 640 ]
Warning message:
call dbDisconnect() when finished working with a connection 
> 
> test_suite <- system.file("test_backends", "test_MsBackend",
+                           package = "Spectra")
> 
> be <- a_be_blob
> test_dir(test_suite, stop_on_failure = TRUE)
✔ | F W  S  OK | Context

⠏ |          0 | peaks_variables                                                
✔ |          4 | peaks_variables

⠏ |          0 | spectra_subsetting                                             
⠏ |         40 | spectra_subsetting                                             
⠙ |        132 | spectra_subsetting                                             
⠦ |        217 | spectra_subsetting                                             
⠧ |        308 | spectra_subsetting                                             
⠦ |        397 | spectra_subsetting                                             
⠧ |        478 | spectra_subsetting                                             
⠏ |        570 | spectra_subsetting                                             
⠙ |        662 | spectra_subsetting                                             
⠦ |        757 | spectra_subsetting                                             
⠹ |        853 | spectra_subsetting                                             
⠇ |        949 | spectra_subsetting                                             
⠇ |        1049 | spectra_subsetting                                            
⠇ |        1139 | spectra_subsetting                                            
⠧ |        1228 | spectra_subsetting                                            
⠧ |        1318 | spectra_subsetting                                            
⠋ |        1411 | spectra_subsetting                                            
⠹ |        1483 | spectra_subsetting                                            
⠇ |        1579 | spectra_subsetting                                            
⠹ |        1673 | spectra_subsetting                                            
⠧ |        1768 | spectra_subsetting                                            
⠧ |        1868 | spectra_subsetting                                            
⠴ |        1966 | spectra_subsetting                                            
⠏ |        2050 | spectra_subsetting                                            
⠹ |        2143 | spectra_subsetting                                            
⠇ |        2239 | spectra_subsetting                                            
⠏ |        2320 | spectra_subsetting                                            
⠼ |        2405 | spectra_subsetting                                            
⠸ |        2494 | spectra_subsetting                                            
⠼ |        2575 | spectra_subsetting                                            
⠼ |        2665 | spectra_subsetting                                            
⠇ |        2759 | spectra_subsetting                                            
⠏ |        2800 | spectra_subsetting                                            
⠼ |        2805 | spectra_subsetting                                            
⠏ |        2810 | spectra_subsetting                                            
⠼ |        2815 | spectra_subsetting                                            
⠏ |        2820 | spectra_subsetting                                            
⠼ |        2825 | spectra_subsetting                                            
⠏ |        2830 | spectra_subsetting                                            
⠼ |        2835 | spectra_subsetting                                            
⠏ |        2840 | spectra_subsetting                                            
⠼ |        2845 | spectra_subsetting                                            
⠇ |        2849 | spectra_subsetting                                            
⠸ |        2854 | spectra_subsetting                                            
⠇ |        2859 | spectra_subsetting                                            
⠸ |        2864 | spectra_subsetting                                            
⠇ |        2869 | spectra_subsetting                                            
⠸ |        2874 | spectra_subsetting                                            
⠇ |        2879 | spectra_subsetting                                            
⠸ |        2884 | spectra_subsetting                                            
⠇ |        2889 | spectra_subsetting                                            
⠸ |        2894 | spectra_subsetting                                            
⠇ |        2899 | spectra_subsetting                                            
⠸ |        2904 | spectra_subsetting                                            
⠇ |        2909 | spectra_subsetting                                            
⠸ |        2914 | spectra_subsetting                                            
⠇ |        2919 | spectra_subsetting                                            
⠸ |        2924 | spectra_subsetting                                            
⠇ |        2929 | spectra_subsetting                                            
⠸ |        2934 | spectra_subsetting                                            
⠇ |        2939 | spectra_subsetting                                            
⠸ |        2944 | spectra_subsetting                                            
⠇ |        2949 | spectra_subsetting                                            
⠸ |        2954 | spectra_subsetting                                            
⠇ |        2959 | spectra_subsetting                                            
⠸ |        2964 | spectra_subsetting                                            
⠇ |        2969 | spectra_subsetting                                            
⠸ |        2974 | spectra_subsetting                                            
⠇ |        2979 | spectra_subsetting                                            
⠸ |        2984 | spectra_subsetting                                            
⠇ |        2989 | spectra_subsetting                                            
⠸ |        2994 | spectra_subsetting                                            
⠇ |        2999 | spectra_subsetting                                            
⠸ |        3004 | spectra_subsetting                                            
⠇ |        3009 | spectra_subsetting                                            
⠸ |        3014 | spectra_subsetting                                            
⠇ |        3019 | spectra_subsetting                                            
⠸ |        3024 | spectra_subsetting                                            
⠇ |        3029 | spectra_subsetting                                            
⠸ |        3034 | spectra_subsetting                                            
⠇ |        3039 | spectra_subsetting                                            
⠸ |        3044 | spectra_subsetting                                            
⠇ |        3049 | spectra_subsetting                                            
⠸ |        3054 | spectra_subsetting                                            
⠇ |        3059 | spectra_subsetting                                            
⠸ |        3064 | spectra_subsetting                                            
⠇ |        3069 | spectra_subsetting                                            
⠸ |        3074 | spectra_subsetting                                            
⠇ |        3079 | spectra_subsetting                                            
⠸ |        3084 | spectra_subsetting                                            
⠇ |        3089 | spectra_subsetting                                            
⠸ |        3094 | spectra_subsetting                                            
⠇ |        3099 | spectra_subsetting                                            
⠸ |        3104 | spectra_subsetting                                            
⠇ |        3109 | spectra_subsetting                                            
⠸ |        3114 | spectra_subsetting                                            
⠇ |        3119 | spectra_subsetting                                            
⠸ |        3124 | spectra_subsetting                                            
⠇ |        3129 | spectra_subsetting                                            
⠸ |        3134 | spectra_subsetting                                            
⠇ |        3139 | spectra_subsetting                                            
⠸ |        3144 | spectra_subsetting                                            
⠇ |        3149 | spectra_subsetting                                            
⠸ |        3154 | spectra_subsetting                                            
⠇ |        3159 | spectra_subsetting                                            
⠸ |        3164 | spectra_subsetting                                            
⠇ |        3169 | spectra_subsetting                                            
⠸ |        3174 | spectra_subsetting                                            
⠇ |        3179 | spectra_subsetting                                            
⠸ |        3184 | spectra_subsetting                                            
⠇ |        3189 | spectra_subsetting                                            
⠸ |        3194 | spectra_subsetting                                            
⠇ |        3199 | spectra_subsetting                                            
⠸ |        3204 | spectra_subsetting                                            
⠇ |        3209 | spectra_subsetting                                            
⠸ |        3214 | spectra_subsetting                                            
⠇ |        3219 | spectra_subsetting                                            
⠸ |        3224 | spectra_subsetting                                            
⠇ |        3229 | spectra_subsetting                                            
⠸ |        3234 | spectra_subsetting                                            
⠇ |        3239 | spectra_subsetting                                            
⠸ |        3244 | spectra_subsetting                                            
⠇ |        3249 | spectra_subsetting                                            
⠸ |        3254 | spectra_subsetting                                            
⠇ |        3259 | spectra_subsetting                                            
⠸ |        3264 | spectra_subsetting                                            
⠇ |        3269 | spectra_subsetting                                            
⠸ |        3274 | spectra_subsetting                                            
⠇ |        3279 | spectra_subsetting                                            
⠸ |        3284 | spectra_subsetting                                            
⠇ |        3289 | spectra_subsetting                                            
⠸ |        3294 | spectra_subsetting                                            
⠇ |        3299 | spectra_subsetting                                            
⠸ |        3304 | spectra_subsetting                                            
⠇ |        3309 | spectra_subsetting                                            
⠸ |        3314 | spectra_subsetting                                            
⠇ |        3319 | spectra_subsetting                                            
⠸ |        3324 | spectra_subsetting                                            
⠇ |        3329 | spectra_subsetting                                            
⠸ |        3334 | spectra_subsetting                                            
⠇ |        3339 | spectra_subsetting                                            
⠸ |        3344 | spectra_subsetting                                            
⠇ |        3349 | spectra_subsetting                                            
⠸ |        3354 | spectra_subsetting                                            
⠇ |        3359 | spectra_subsetting                                            
⠸ |        3364 | spectra_subsetting                                            
⠇ |        3369 | spectra_subsetting                                            
⠸ |        3374 | spectra_subsetting                                            
⠇ |        3379 | spectra_subsetting                                            
⠸ |        3384 | spectra_subsetting                                            
⠇ |        3389 | spectra_subsetting                                            
⠸ |        3394 | spectra_subsetting                                            
⠇ |        3399 | spectra_subsetting                                            
⠸ |        3404 | spectra_subsetting                                            
⠇ |        3409 | spectra_subsetting                                            
⠸ |        3414 | spectra_subsetting                                            
⠇ |        3419 | spectra_subsetting                                            
⠸ |        3424 | spectra_subsetting                                            
⠇ |        3429 | spectra_subsetting                                            
⠸ |        3434 | spectra_subsetting                                            
⠇ |        3439 | spectra_subsetting                                            
⠸ |        3444 | spectra_subsetting                                            
⠇ |        3449 | spectra_subsetting                                            
⠸ |        3454 | spectra_subsetting                                            
⠇ |        3459 | spectra_subsetting                                            
⠹ |        3463 | spectra_subsetting                                            
⠧ |        3468 | spectra_subsetting                                            
⠹ |        3473 | spectra_subsetting                                            
⠧ |        3478 | spectra_subsetting                                            
⠹ |        3483 | spectra_subsetting                                            
⠧ |        3488 | spectra_subsetting                                            
⠹ |        3493 | spectra_subsetting                                            
⠧ |        3498 | spectra_subsetting                                            
⠹ |        3503 | spectra_subsetting                                            
⠧ |        3508 | spectra_subsetting                                            
⠹ |        3513 | spectra_subsetting                                            
⠧ |        3518 | spectra_subsetting                                            
⠹ |        3523 | spectra_subsetting                                            
⠧ |        3528 | spectra_subsetting                                            
⠹ |        3533 | spectra_subsetting                                            
⠧ |        3538 | spectra_subsetting                                            
⠹ |        3543 | spectra_subsetting                                            
⠧ |        3548 | spectra_subsetting                                            
⠹ |        3553 | spectra_subsetting                                            
⠧ |        3558 | spectra_subsetting                                            
⠸ |        3564 | spectra_subsetting                                            
⠇ |        3569 | spectra_subsetting                                            
⠸ |        3574 | spectra_subsetting                                            
⠇ |        3579 | spectra_subsetting                                            
⠸ |        3584 | spectra_subsetting                                            
⠇ |        3589 | spectra_subsetting                                            
⠸ |        3594 | spectra_subsetting                                            
⠇ |        3599 | spectra_subsetting                                            
⠸ |        3604 | spectra_subsetting                                            
⠇ |        3609 | spectra_subsetting                                            
⠸ |        3614 | spectra_subsetting                                            
⠇ |        3619 | spectra_subsetting                                            
⠸ |        3624 | spectra_subsetting                                            
⠇ |        3629 | spectra_subsetting                                            
⠸ |        3634 | spectra_subsetting                                            
⠇ |        3639 | spectra_subsetting                                            
⠸ |        3644 | spectra_subsetting                                            
⠇ |        3649 | spectra_subsetting                                            
⠸ |        3654 | spectra_subsetting                                            
⠇ |        3659 | spectra_subsetting                                            
⠸ |        3664 | spectra_subsetting                                            
⠇ |        3669 | spectra_subsetting                                            
⠸ |        3674 | spectra_subsetting                                            
⠇ |        3679 | spectra_subsetting                                            
⠼ |        3685 | spectra_subsetting                                            
⠏ |        3690 | spectra_subsetting                                            
⠼ |        3695 | spectra_subsetting                                            
⠏ |        3700 | spectra_subsetting                                            
⠼ |        3705 | spectra_subsetting                                            
⠏ |        3710 | spectra_subsetting                                            
⠼ |        3715 | spectra_subsetting                                            
⠏ |        3720 | spectra_subsetting                                            
⠼ |        3725 | spectra_subsetting                                            
⠹ |        3733 | spectra_subsetting                                            
⠦ |        3747 | spectra_subsetting                                            
⠙ |        3762 | spectra_subsetting                                            
✔ |        3770 | spectra_subsetting [24.2s]

⠏ |          0 | spectra_variables                                              
⠸ |         14 | spectra_variables                                              
⠹ |         43 | spectra_variables                                              
✔ |         64 | spectra_variables

══ Results ═════════════════════════════════════════════════════════════════════
Duration: 24.6 s

[ FAIL 0 | WARN 0 | SKIP 0 | PASS 3838 ]
> 
> be <- tmt_be[sample(seq_along(tmt_be), 300)]
> test_dir(test_suite, stop_on_failure = TRUE)
✔ | F W  S  OK | Context

⠏ |          0 | peaks_variables                                                
⠙ |          2 | peaks_variables                                                
⠸ |          4 | peaks_variables                                                
✔ |          4 | peaks_variables [1.1s]

⠏ |          0 | spectra_subsetting                                             
⠼ |         75 | spectra_subsetting                                             
⠇ |        169 | spectra_subsetting                                             
⠙ |        262 | spectra_subsetting                                             
⠼ |        355 | spectra_subsetting                                             
⠹ |        443 | spectra_subsetting                                             
⠋ |        491 | spectra_subsetting                                             
⠦ |        587 | spectra_subsetting                                             
⠇ |        679 | spectra_subsetting                                             
⠼ |        775 | spectra_subsetting                                             
⠼ |        865 | spectra_subsetting                                             
⠦ |        907 | spectra_subsetting                                             
⠏ |        910 | spectra_subsetting                                             
⠹ |        913 | spectra_subsetting                                             
⠧ |        918 | spectra_subsetting                                             
⠋ |        921 | spectra_subsetting                                             
⠴ |        926 | spectra_subsetting                                             
⠋ |        931 | spectra_subsetting                                             
⠴ |        936 | spectra_subsetting                                             
⠋ |        941 | spectra_subsetting                                             
⠴ |        946 | spectra_subsetting                                             
⠋ |        951 | spectra_subsetting                                             
⠴ |        956 | spectra_subsetting                                             
⠋ |        961 | spectra_subsetting                                             
⠸ |        964 | spectra_subsetting                                             
⠴ |        966 | spectra_subsetting                                             
⠋ |        971 | spectra_subsetting                                             
⠴ |        976 | spectra_subsetting                                             
⠧ |        978 | spectra_subsetting                                             
⠹ |        983 | spectra_subsetting                                             
⠴ |        986 | spectra_subsetting                                             
⠏ |        990 | spectra_subsetting                                             
⠼ |        995 | spectra_subsetting                                             
⠦ |        997 | spectra_subsetting                                             
⠏ |        1000 | spectra_subsetting                                            
⠹ |        1003 | spectra_subsetting                                            
⠦ |        1007 | spectra_subsetting                                            
⠙ |        1012 | spectra_subsetting                                            
⠦ |        1017 | spectra_subsetting                                            
⠙ |        1022 | spectra_subsetting                                            
⠼ |        1025 | spectra_subsetting                                            
⠏ |        1030 | spectra_subsetting                                            
⠹ |        1033 | spectra_subsetting                                            
⠧ |        1038 | spectra_subsetting                                            
⠹ |        1043 | spectra_subsetting                                            
⠧ |        1048 | spectra_subsetting                                            
⠋ |        1051 | spectra_subsetting                                            
⠼ |        1055 | spectra_subsetting                                            
⠏ |        1060 | spectra_subsetting                                            
⠹ |        1063 | spectra_subsetting                                            
⠼ |        1065 | spectra_subsetting                                            
⠏ |        1070 | spectra_subsetting                                            
⠼ |        1075 | spectra_subsetting                                            
⠏ |        1080 | spectra_subsetting                                            
⠹ |        1083 | spectra_subsetting                                            
⠴ |        1086 | spectra_subsetting                                            
⠏ |        1090 | spectra_subsetting                                            
⠸ |        1094 | spectra_subsetting                                            
⠇ |        1099 | spectra_subsetting                                            
⠹ |        1103 | spectra_subsetting                                            
⠧ |        1108 | spectra_subsetting                                            
⠹ |        1113 | spectra_subsetting                                            
⠧ |        1118 | spectra_subsetting                                            
⠹ |        1123 | spectra_subsetting                                            
⠦ |        1127 | spectra_subsetting                                            
⠙ |        1132 | spectra_subsetting                                            
⠴ |        1136 | spectra_subsetting                                            
⠧ |        1138 | spectra_subsetting                                            
⠋ |        1141 | spectra_subsetting                                            
⠼ |        1145 | spectra_subsetting                                            
⠇ |        1149 | spectra_subsetting                                            
⠸ |        1154 | spectra_subsetting                                            
⠇ |        1159 | spectra_subsetting                                            
⠹ |        1163 | spectra_subsetting                                            
⠧ |        1168 | spectra_subsetting                                            
⠹ |        1173 | spectra_subsetting                                            
⠴ |        1176 | spectra_subsetting                                            
⠏ |        1180 | spectra_subsetting                                            
⠼ |        1185 | spectra_subsetting                                            
⠏ |        1190 | spectra_subsetting                                            
⠹ |        1193 | spectra_subsetting                                            
⠧ |        1198 | spectra_subsetting                                            
⠹ |        1203 | spectra_subsetting                                            
⠦ |        1217 | spectra_subsetting                                            
⠹ |        1223 | spectra_subsetting                                            
⠧ |        1238 | spectra_subsetting                                            
✔ |        1246 | spectra_subsetting [12.6s]

⠏ |          0 | spectra_variables                                              
⠙ |         12 | spectra_variables                                              
⠸ |         14 | spectra_variables                                              
⠴ |         16 | spectra_variables                                              
⠦ |         27 | spectra_variables                                              
⠇ |         29 | spectra_variables                                              
⠋ |         31 | spectra_variables                                              
⠹ |         43 | spectra_variables                                              
⠸ |         54 | spectra_variables                                              
✔ |         64 | spectra_variables [4.2s]

══ Results ═════════════════════════════════════════════════════════════════════
Duration: 17.9 s

[ FAIL 0 | WARN 0 | SKIP 0 | PASS 1314 ]
> 
> dbDisconnect(a_db_long)
> dbDisconnect(a_db_blob)
> dbDisconnect(a_db_blob2)
> dbDisconnect(mm_db)
> dbDisconnect(tmt_db)
> 
> proc.time()
   user  system elapsed 
177.635  19.906 195.681 

Example timings

MsBackendSql.Rcheck/MsBackendSql-Ex.timings

nameusersystemelapsed
MsBackendSql3.3440.4554.232