Back to Rapid builds (Linux only) of a subset of BioC 3.23
Report updated every 6 hours

This page was generated on 2026-03-15 04:15 -0400 (Sun, 15 Mar 2026).

HostnameOSArch (*)R versionInstalled pkgs
teran2Linux (Ubuntu 24.04.3 LTS)x86_64R Under development (unstable) (2026-03-12 r89611) -- "Unsuffered Consequences" 920
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 148/230HostnameOS / ArchINSTALLBUILDCHECK
MsBackendSql 1.11.3  (landing page)
Johannes Rainer
Snapshot Date: 2026-03-15 00:00 -0400 (Sun, 15 Mar 2026)
git_url: https://git.bioconductor.org/packages/MsBackendSql
git_branch: devel
git_last_commit: 9b5f2fe
git_last_commit_date: 2026-02-05 04:55:08 -0400 (Thu, 05 Feb 2026)
teran2Linux (Ubuntu 24.04.3 LTS) / x86_64  OK    OK    OK  


CHECK results for MsBackendSql on teran2

To the developers/maintainers of the MsBackendSql package:
- 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.11.3
Command: /home/rapidbuild/bbs-3.23-bioc-rapid/R/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/home/rapidbuild/bbs-3.23-bioc-rapid/R/site-library --timings MsBackendSql_1.11.3.tar.gz
StartedAt: 2026-03-15 03:07:10 -0400 (Sun, 15 Mar 2026)
EndedAt: 2026-03-15 03:14:35 -0400 (Sun, 15 Mar 2026)
EllapsedTime: 445.6 seconds
RetCode: 0
Status:   OK  
CheckDir: MsBackendSql.Rcheck
Warnings: 0

Command output

##############################################################################
##############################################################################
###
### Running command:
###
###   /home/rapidbuild/bbs-3.23-bioc-rapid/R/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/home/rapidbuild/bbs-3.23-bioc-rapid/R/site-library --timings MsBackendSql_1.11.3.tar.gz
###
##############################################################################
##############################################################################


* using log directory ‘/media/volume/teran2_disk/rapidbuild/bbs-3.23-bioc-rapid/meat/MsBackendSql.Rcheck’
* using R Under development (unstable) (2026-03-12 r89611)
* using platform: x86_64-pc-linux-gnu
* R was compiled by
    gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0
    GNU Fortran (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0
* running under: Ubuntu 24.04.3 LTS
* using session charset: UTF-8
* current time: 2026-03-15 07:07:10 UTC
* checking for file ‘MsBackendSql/DESCRIPTION’ ... OK
* this is package ‘MsBackendSql’ version ‘1.11.3’
* package encoding: UTF-8
* checking CRAN incoming feasibility ... NOTE
Maintainer: ‘Johannes Rainer <Johannes.Rainer@eurac.edu>’

Unknown, possibly misspelled, fields in DESCRIPTION:
  ‘git_url’ ‘git_branch’ ‘git_last_commit’ ‘git_last_commit_date’

Uses the non-portable package: ‘mzR’

The Title field should be in title case. Current version is:
  ‘SQL-based Mass Spectrometry Data Backend’
In title case that is:
  ‘SQL-Based Mass Spectrometry Data Backend’
* 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 loading without being on the library search path ... 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 ... 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 ... NOTE
Examples with CPU (user + system) or elapsed time > 5s
              user system elapsed
MsBackendSql 7.643   0.73   8.707
* 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 re-building of vignette outputs ... OK
* checking PDF version of manual ... OK
* DONE

Status: 2 NOTEs
See
  ‘/media/volume/teran2_disk/rapidbuild/bbs-3.23-bioc-rapid/meat/MsBackendSql.Rcheck/00check.log’
for details.


Installation output

MsBackendSql.Rcheck/00install.out

##############################################################################
##############################################################################
###
### Running command:
###
###   /home/rapidbuild/bbs-3.23-bioc-rapid/R/bin/R CMD INSTALL MsBackendSql
###
##############################################################################
##############################################################################


* installing to library ‘/media/volume/teran2_disk/rapidbuild/bbs-3.23-bioc-rapid/R/site-library’
* installing *source* package ‘MsBackendSql’ ...
** this is package ‘MsBackendSql’ version ‘1.11.3’
** 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 Under development (unstable) (2026-03-12 r89611) -- "Unsuffered Consequences"
Copyright (C) 2026 The R Foundation for Statistical Computing
Platform: x86_64-pc-linux-gnu

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 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  2s
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  4s
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 39s
Creating indices .... Done
[1] TRUE
> tmt_be <- backendInitialize(MsBackendSql(), tmt_db)
> 
> test_check("MsBackendSql")
[ FAIL 0 | WARN 3 | SKIP 1 | PASS 628 ]

══ Skipped tests (1) ═══════════════════════════════════════════════════════════
• empty test (1): 'test_MsBackendSql-functions.R:764:1'

[ FAIL 0 | WARN 3 | SKIP 1 | PASS 628 ]
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                                                
⠙ |          2 | peaks_variables                                                
✔ |          4 | peaks_variables

⠏ |          0 | spectra_subsetting                                             
⠋ |          1 | spectra_subsetting                                             
⠇ |         49 | spectra_subsetting                                             
⠦ |         97 | spectra_subsetting                                             
⠼ |        145 | spectra_subsetting                                             
⠸ |        194 | spectra_subsetting                                             
⠴ |        236 | spectra_subsetting                                             
⠦ |        277 | spectra_subsetting                                             
⠸ |        314 | spectra_subsetting                                             
⠼ |        355 | spectra_subsetting                                             
⠦ |        397 | spectra_subsetting                                             
⠙ |        432 | spectra_subsetting                                             
⠋ |        481 | spectra_subsetting                                             
⠏ |        530 | spectra_subsetting                                             
⠧ |        578 | spectra_subsetting                                             
⠦ |        627 | spectra_subsetting                                             
⠸ |        674 | spectra_subsetting                                             
⠙ |        722 | spectra_subsetting                                             
⠏ |        770 | spectra_subsetting                                             
⠧ |        818 | spectra_subsetting                                             
⠴ |        866 | spectra_subsetting                                             
⠼ |        915 | spectra_subsetting                                             
⠹ |        953 | spectra_subsetting                                             
⠙ |        1002 | spectra_subsetting                                            
⠇ |        1049 | spectra_subsetting                                            
⠴ |        1096 | spectra_subsetting                                            
⠇ |        1139 | spectra_subsetting                                            
⠸ |        1184 | spectra_subsetting                                            
⠙ |        1232 | spectra_subsetting                                            
⠏ |        1280 | spectra_subsetting                                            
⠧ |        1328 | spectra_subsetting                                            
⠼ |        1375 | spectra_subsetting                                            
⠹ |        1423 | spectra_subsetting                                            
⠇ |        1469 | spectra_subsetting                                            
⠙ |        1502 | spectra_subsetting                                            
⠇ |        1549 | spectra_subsetting                                            
⠸ |        1594 | spectra_subsetting                                            
⠏ |        1640 | spectra_subsetting                                            
⠦ |        1687 | spectra_subsetting                                            
⠸ |        1734 | spectra_subsetting                                            
⠦ |        1777 | spectra_subsetting                                            
⠙ |        1822 | spectra_subsetting                                            
⠏ |        1870 | spectra_subsetting                                            
⠴ |        1916 | spectra_subsetting                                            
⠙ |        1962 | spectra_subsetting                                            
⠦ |        1997 | spectra_subsetting                                            
⠸ |        2044 | spectra_subsetting                                            
⠋ |        2091 | spectra_subsetting                                            
⠦ |        2137 | spectra_subsetting                                            
⠸ |        2184 | spectra_subsetting                                            
⠋ |        2231 | spectra_subsetting                                            
⠧ |        2278 | spectra_subsetting                                            
⠸ |        2324 | spectra_subsetting                                            
⠋ |        2371 | spectra_subsetting                                            
⠧ |        2418 | spectra_subsetting                                            
⠸ |        2464 | spectra_subsetting                                            
⠋ |        2511 | spectra_subsetting                                            
⠼ |        2545 | spectra_subsetting                                            
⠹ |        2593 | spectra_subsetting                                            
⠇ |        2639 | spectra_subsetting                                            
⠴ |        2686 | spectra_subsetting                                            
⠹ |        2733 | spectra_subsetting                                            
⠹ |        2773 | spectra_subsetting                                            
⠧ |        2798 | spectra_subsetting                                            
⠋ |        2801 | spectra_subsetting                                            
⠹ |        2803 | spectra_subsetting                                            
⠼ |        2805 | spectra_subsetting                                            
⠦ |        2807 | spectra_subsetting                                            
⠏ |        2810 | spectra_subsetting                                            
⠹ |        2813 | spectra_subsetting                                            
⠴ |        2816 | spectra_subsetting                                            
⠇ |        2819 | spectra_subsetting                                            
⠙ |        2822 | spectra_subsetting                                            
⠼ |        2825 | spectra_subsetting                                            
⠦ |        2827 | spectra_subsetting                                            
⠏ |        2830 | spectra_subsetting                                            
⠹ |        2833 | spectra_subsetting                                            
⠴ |        2836 | spectra_subsetting                                            
⠇ |        2839 | spectra_subsetting                                            
⠙ |        2842 | spectra_subsetting                                            
⠼ |        2845 | spectra_subsetting                                            
⠧ |        2848 | spectra_subsetting                                            
⠋ |        2851 | spectra_subsetting                                            
⠸ |        2854 | spectra_subsetting                                            
⠦ |        2857 | spectra_subsetting                                            
⠏ |        2860 | spectra_subsetting                                            
⠹ |        2863 | spectra_subsetting                                            
⠼ |        2865 | spectra_subsetting                                            
⠧ |        2868 | spectra_subsetting                                            
⠋ |        2871 | spectra_subsetting                                            
⠸ |        2874 | spectra_subsetting                                            
⠴ |        2876 | spectra_subsetting                                            
⠇ |        2879 | spectra_subsetting                                            
⠙ |        2882 | spectra_subsetting                                            
⠸ |        2884 | spectra_subsetting                                            
⠦ |        2887 | spectra_subsetting                                            
⠏ |        2890 | spectra_subsetting                                            
⠹ |        2893 | spectra_subsetting                                            
⠴ |        2896 | spectra_subsetting                                            
⠇ |        2899 | spectra_subsetting                                            
⠙ |        2902 | spectra_subsetting                                            
⠸ |        2904 | spectra_subsetting                                            
⠦ |        2907 | spectra_subsetting                                            
⠏ |        2910 | spectra_subsetting                                            
⠹ |        2913 | spectra_subsetting                                            
⠴ |        2916 | spectra_subsetting                                            
⠇ |        2919 | spectra_subsetting                                            
⠙ |        2922 | spectra_subsetting                                            
⠼ |        2925 | spectra_subsetting                                            
⠧ |        2928 | spectra_subsetting                                            
⠋ |        2931 | spectra_subsetting                                            
⠸ |        2934 | spectra_subsetting                                            
⠦ |        2937 | spectra_subsetting                                            
⠏ |        2940 | spectra_subsetting                                            
⠙ |        2942 | spectra_subsetting                                            
⠼ |        2945 | spectra_subsetting                                            
⠦ |        2947 | spectra_subsetting                                            
⠏ |        2950 | spectra_subsetting                                            
⠹ |        2953 | spectra_subsetting                                            
⠴ |        2956 | spectra_subsetting                                            
⠇ |        2959 | spectra_subsetting                                            
⠋ |        2961 | spectra_subsetting                                            
⠸ |        2964 | spectra_subsetting                                            
⠦ |        2967 | spectra_subsetting                                            
⠏ |        2970 | spectra_subsetting                                            
⠙ |        2972 | spectra_subsetting                                            
⠸ |        2974 | spectra_subsetting                                            
⠦ |        2977 | spectra_subsetting                                            
⠏ |        2980 | spectra_subsetting                                            
⠹ |        2983 | spectra_subsetting                                            
⠴ |        2986 | spectra_subsetting                                            
⠇ |        2989 | spectra_subsetting                                            
⠙ |        2992 | spectra_subsetting                                            
⠼ |        2995 | spectra_subsetting                                            
⠧ |        2998 | spectra_subsetting                                            
⠏ |        3000 | spectra_subsetting                                            
⠹ |        3003 | spectra_subsetting                                            
⠴ |        3006 | spectra_subsetting                                            
⠧ |        3008 | spectra_subsetting                                            
⠏ |        3010 | spectra_subsetting                                            
⠹ |        3013 | spectra_subsetting                                            
⠴ |        3016 | spectra_subsetting                                            
⠧ |        3018 | spectra_subsetting                                            
⠋ |        3021 | spectra_subsetting                                            
⠹ |        3023 | spectra_subsetting                                            
⠴ |        3026 | spectra_subsetting                                            
⠇ |        3029 | spectra_subsetting                                            
⠙ |        3032 | spectra_subsetting                                            
⠼ |        3035 | spectra_subsetting                                            
⠦ |        3037 | spectra_subsetting                                            
⠏ |        3040 | spectra_subsetting                                            
⠹ |        3043 | spectra_subsetting                                            
⠴ |        3046 | spectra_subsetting                                            
⠇ |        3049 | spectra_subsetting                                            
⠙ |        3052 | spectra_subsetting                                            
⠼ |        3055 | spectra_subsetting                                            
⠦ |        3057 | spectra_subsetting                                            
⠏ |        3060 | spectra_subsetting                                            
⠹ |        3063 | spectra_subsetting                                            
⠴ |        3066 | spectra_subsetting                                            
⠇ |        3069 | spectra_subsetting                                            
⠙ |        3072 | spectra_subsetting                                            
⠼ |        3075 | spectra_subsetting                                            
⠦ |        3077 | spectra_subsetting                                            
⠏ |        3080 | spectra_subsetting                                            
⠹ |        3083 | spectra_subsetting                                            
⠴ |        3086 | spectra_subsetting                                            
⠇ |        3089 | spectra_subsetting                                            
⠙ |        3092 | spectra_subsetting                                            
⠼ |        3095 | spectra_subsetting                                            
⠧ |        3098 | spectra_subsetting                                            
⠋ |        3101 | spectra_subsetting                                            
⠸ |        3104 | spectra_subsetting                                            
⠦ |        3107 | spectra_subsetting                                            
⠏ |        3110 | spectra_subsetting                                            
⠹ |        3113 | spectra_subsetting                                            
⠼ |        3115 | spectra_subsetting                                            
⠧ |        3118 | spectra_subsetting                                            
⠋ |        3121 | spectra_subsetting                                            
⠸ |        3124 | spectra_subsetting                                            
⠦ |        3127 | spectra_subsetting                                            
⠏ |        3130 | spectra_subsetting                                            
⠹ |        3133 | spectra_subsetting                                            
⠼ |        3135 | spectra_subsetting                                            
⠧ |        3138 | spectra_subsetting                                            
⠋ |        3141 | spectra_subsetting                                            
⠸ |        3144 | spectra_subsetting                                            
⠦ |        3147 | spectra_subsetting                                            
⠏ |        3150 | spectra_subsetting                                            
⠹ |        3153 | spectra_subsetting                                            
⠴ |        3156 | spectra_subsetting                                            
⠇ |        3159 | spectra_subsetting                                            
⠙ |        3162 | spectra_subsetting                                            
⠸ |        3164 | spectra_subsetting                                            
⠴ |        3166 | spectra_subsetting                                            
⠧ |        3168 | spectra_subsetting                                            
⠋ |        3171 | spectra_subsetting                                            
⠹ |        3173 | spectra_subsetting                                            
⠴ |        3176 | spectra_subsetting                                            
⠇ |        3179 | spectra_subsetting                                            
⠙ |        3182 | spectra_subsetting                                            
⠸ |        3184 | spectra_subsetting                                            
⠦ |        3187 | spectra_subsetting                                            
⠏ |        3190 | spectra_subsetting                                            
⠙ |        3192 | spectra_subsetting                                            
⠼ |        3195 | spectra_subsetting                                            
⠧ |        3198 | spectra_subsetting                                            
⠋ |        3201 | spectra_subsetting                                            
⠸ |        3204 | spectra_subsetting                                            
⠦ |        3207 | spectra_subsetting                                            
⠏ |        3210 | spectra_subsetting                                            
⠹ |        3213 | spectra_subsetting                                            
⠴ |        3216 | spectra_subsetting                                            
⠇ |        3219 | spectra_subsetting                                            
⠙ |        3222 | spectra_subsetting                                            
⠼ |        3225 | spectra_subsetting                                            
⠧ |        3228 | spectra_subsetting                                            
⠏ |        3230 | spectra_subsetting                                            
⠹ |        3233 | spectra_subsetting                                            
⠴ |        3236 | spectra_subsetting                                            
⠇ |        3239 | spectra_subsetting                                            
⠙ |        3242 | spectra_subsetting                                            
⠼ |        3245 | spectra_subsetting                                            
⠧ |        3248 | spectra_subsetting                                            
⠏ |        3250 | spectra_subsetting                                            
⠹ |        3253 | spectra_subsetting                                            
⠼ |        3255 | spectra_subsetting                                            
⠧ |        3258 | spectra_subsetting                                            
⠋ |        3261 | spectra_subsetting                                            
⠸ |        3264 | spectra_subsetting                                            
⠦ |        3267 | spectra_subsetting                                            
⠇ |        3269 | spectra_subsetting                                            
⠙ |        3272 | spectra_subsetting                                            
⠼ |        3275 | spectra_subsetting                                            
⠧ |        3278 | spectra_subsetting                                            
⠋ |        3281 | spectra_subsetting                                            
⠸ |        3284 | spectra_subsetting                                            
⠦ |        3287 | spectra_subsetting                                            
⠏ |        3290 | spectra_subsetting                                            
⠹ |        3293 | spectra_subsetting                                            
⠴ |        3296 | spectra_subsetting                                            
⠇ |        3299 | spectra_subsetting                                            
⠙ |        3302 | spectra_subsetting                                            
⠼ |        3305 | spectra_subsetting                                            
⠦ |        3307 | spectra_subsetting                                            
⠏ |        3310 | spectra_subsetting                                            
⠹ |        3313 | spectra_subsetting                                            
⠴ |        3316 | spectra_subsetting                                            
⠇ |        3319 | spectra_subsetting                                            
⠙ |        3322 | spectra_subsetting                                            
⠼ |        3325 | spectra_subsetting                                            
⠦ |        3327 | spectra_subsetting                                            
⠏ |        3330 | spectra_subsetting                                            
⠹ |        3333 | spectra_subsetting                                            
⠴ |        3336 | spectra_subsetting                                            
⠇ |        3339 | spectra_subsetting                                            
⠙ |        3342 | spectra_subsetting                                            
⠼ |        3345 | spectra_subsetting                                            
⠧ |        3348 | spectra_subsetting                                            
⠋ |        3351 | spectra_subsetting                                            
⠸ |        3354 | spectra_subsetting                                            
⠦ |        3357 | spectra_subsetting                                            
⠏ |        3360 | spectra_subsetting                                            
⠹ |        3363 | spectra_subsetting                                            
⠼ |        3365 | spectra_subsetting                                            
⠧ |        3368 | spectra_subsetting                                            
⠋ |        3371 | spectra_subsetting                                            
⠸ |        3374 | spectra_subsetting                                            
⠦ |        3377 | spectra_subsetting                                            
⠏ |        3380 | spectra_subsetting                                            
⠹ |        3383 | spectra_subsetting                                            
⠴ |        3386 | spectra_subsetting                                            
⠇ |        3389 | spectra_subsetting                                            
⠋ |        3391 | spectra_subsetting                                            
⠸ |        3394 | spectra_subsetting                                            
⠦ |        3397 | spectra_subsetting                                            
⠏ |        3400 | spectra_subsetting                                            
⠹ |        3403 | spectra_subsetting                                            
⠴ |        3406 | spectra_subsetting                                            
⠇ |        3409 | spectra_subsetting                                            
⠙ |        3412 | spectra_subsetting                                            
⠼ |        3415 | spectra_subsetting                                            
⠧ |        3418 | spectra_subsetting                                            
⠋ |        3421 | spectra_subsetting                                            
⠹ |        3423 | spectra_subsetting                                            
⠴ |        3426 | spectra_subsetting                                            
⠇ |        3429 | spectra_subsetting                                            
⠙ |        3432 | spectra_subsetting                                            
⠼ |        3435 | spectra_subsetting                                            
⠧ |        3438 | spectra_subsetting                                            
⠋ |        3441 | spectra_subsetting                                            
⠸ |        3444 | spectra_subsetting                                            
⠦ |        3447 | spectra_subsetting                                            
⠏ |        3450 | spectra_subsetting                                            
⠹ |        3453 | spectra_subsetting                                            
⠴ |        3456 | spectra_subsetting                                            
⠇ |        3459 | spectra_subsetting                                            
⠋ |        3461 | spectra_subsetting                                            
⠹ |        3463 | spectra_subsetting                                            
⠴ |        3466 | spectra_subsetting                                            
⠇ |        3469 | spectra_subsetting                                            
⠙ |        3472 | spectra_subsetting                                            
⠸ |        3474 | spectra_subsetting                                            
⠦ |        3477 | spectra_subsetting                                            
⠇ |        3479 | spectra_subsetting                                            
⠙ |        3482 | spectra_subsetting                                            
⠼ |        3485 | spectra_subsetting                                            
⠧ |        3488 | spectra_subsetting                                            
⠋ |        3491 | spectra_subsetting                                            
⠸ |        3494 | spectra_subsetting                                            
⠦ |        3497 | spectra_subsetting                                            
⠇ |        3499 | spectra_subsetting                                            
⠙ |        3502 | spectra_subsetting                                            
⠼ |        3505 | spectra_subsetting                                            
⠧ |        3508 | spectra_subsetting                                            
⠋ |        3511 | spectra_subsetting                                            
⠸ |        3514 | spectra_subsetting                                            
⠦ |        3517 | spectra_subsetting                                            
⠇ |        3519 | spectra_subsetting                                            
⠙ |        3522 | spectra_subsetting                                            
⠼ |        3525 | spectra_subsetting                                            
⠧ |        3528 | spectra_subsetting                                            
⠋ |        3531 | spectra_subsetting                                            
⠸ |        3534 | spectra_subsetting                                            
⠴ |        3536 | spectra_subsetting                                            
⠧ |        3538 | spectra_subsetting                                            
⠋ |        3541 | spectra_subsetting                                            
⠸ |        3544 | spectra_subsetting                                            
⠦ |        3547 | spectra_subsetting                                            
⠏ |        3550 | spectra_subsetting                                            
⠹ |        3553 | spectra_subsetting                                            
⠴ |        3556 | spectra_subsetting                                            
⠇ |        3559 | spectra_subsetting                                            
⠋ |        3561 | spectra_subsetting                                            
⠸ |        3564 | spectra_subsetting                                            
⠦ |        3567 | spectra_subsetting                                            
⠏ |        3570 | spectra_subsetting                                            
⠹ |        3573 | spectra_subsetting                                            
⠼ |        3575 | spectra_subsetting                                            
⠧ |        3578 | spectra_subsetting                                            
⠋ |        3581 | spectra_subsetting                                            
⠸ |        3584 | spectra_subsetting                                            
⠦ |        3587 | spectra_subsetting                                            
⠏ |        3590 | spectra_subsetting                                            
⠹ |        3593 | spectra_subsetting                                            
⠼ |        3595 | spectra_subsetting                                            
⠧ |        3598 | spectra_subsetting                                            
⠋ |        3601 | spectra_subsetting                                            
⠹ |        3603 | spectra_subsetting                                            
⠼ |        3605 | spectra_subsetting                                            
⠧ |        3608 | spectra_subsetting                                            
⠋ |        3611 | spectra_subsetting                                            
⠸ |        3614 | spectra_subsetting                                            
⠦ |        3617 | spectra_subsetting                                            
⠏ |        3620 | spectra_subsetting                                            
⠹ |        3623 | spectra_subsetting                                            
⠴ |        3626 | spectra_subsetting                                            
⠇ |        3629 | spectra_subsetting                                            
⠙ |        3632 | spectra_subsetting                                            
⠸ |        3634 | spectra_subsetting                                            
⠦ |        3637 | spectra_subsetting                                            
⠏ |        3640 | spectra_subsetting                                            
⠹ |        3643 | spectra_subsetting                                            
⠴ |        3646 | spectra_subsetting                                            
⠇ |        3649 | spectra_subsetting                                            
⠙ |        3652 | spectra_subsetting                                            
⠼ |        3655 | spectra_subsetting                                            
⠧ |        3658 | spectra_subsetting                                            
⠋ |        3661 | spectra_subsetting                                            
⠸ |        3664 | spectra_subsetting                                            
⠦ |        3667 | spectra_subsetting                                            
⠏ |        3670 | spectra_subsetting                                            
⠙ |        3672 | spectra_subsetting                                            
⠼ |        3675 | spectra_subsetting                                            
⠧ |        3678 | spectra_subsetting                                            
⠏ |        3680 | spectra_subsetting                                            
⠹ |        3683 | spectra_subsetting                                            
⠴ |        3686 | spectra_subsetting                                            
⠇ |        3689 | spectra_subsetting                                            
⠋ |        3691 | spectra_subsetting                                            
⠸ |        3694 | spectra_subsetting                                            
⠦ |        3697 | spectra_subsetting                                            
⠏ |        3700 | spectra_subsetting                                            
⠹ |        3703 | spectra_subsetting                                            
⠴ |        3706 | spectra_subsetting                                            
⠧ |        3708 | spectra_subsetting                                            
⠏ |        3710 | spectra_subsetting                                            
⠹ |        3713 | spectra_subsetting                                            
⠴ |        3716 | spectra_subsetting                                            
⠇ |        3719 | spectra_subsetting                                            
⠙ |        3722 | spectra_subsetting                                            
⠼ |        3725 | spectra_subsetting                                            
⠧ |        3728 | spectra_subsetting                                            
⠙ |        3732 | spectra_subsetting                                            
⠋ |        3741 | spectra_subsetting                                            
⠦ |        3747 | spectra_subsetting                                            
⠙ |        3762 | spectra_subsetting                                            
⠇ |        3769 | spectra_subsetting                                            
✔ |        3770 | spectra_subsetting [53.3s]

⠏ |          0 | spectra_variables                                              
⠸ |         14 | spectra_variables                                              
⠦ |         27 | spectra_variables                                              
⠋ |         41 | spectra_variables                                              
⠹ |         53 | spectra_variables                                              
⠸ |         54 | spectra_variables                                              
✔ |         64 | spectra_variables [1.1s]

══ Results ═════════════════════════════════════════════════════════════════════
Duration: 54.5 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 [2.2s]

⠏ |          0 | spectra_subsetting                                             
⠧ |         28 | spectra_subsetting                                             
⠴ |         76 | spectra_subsetting                                             
⠸ |        124 | spectra_subsetting                                             
⠙ |        172 | spectra_subsetting                                             
⠇ |        219 | spectra_subsetting                                             
⠴ |        266 | spectra_subsetting                                             
⠹ |        313 | spectra_subsetting                                             
⠧ |        358 | spectra_subsetting                                             
⠸ |        404 | spectra_subsetting                                             
⠙ |        452 | spectra_subsetting                                             
⠸ |        494 | spectra_subsetting                                             
⠹ |        543 | spectra_subsetting                                             
⠙ |        592 | spectra_subsetting                                             
⠹ |        633 | spectra_subsetting                                             
⠴ |        676 | spectra_subsetting                                             
⠋ |        721 | spectra_subsetting                                             
⠴ |        766 | spectra_subsetting                                             
⠏ |        810 | spectra_subsetting                                             
⠼ |        855 | spectra_subsetting                                             
⠙ |        902 | spectra_subsetting                                             
⠴ |        906 | spectra_subsetting                                             
⠇ |        909 | spectra_subsetting                                             
⠏ |        910 | spectra_subsetting                                             
⠋ |        911 | spectra_subsetting                                             
⠸ |        914 | spectra_subsetting                                             
⠦ |        917 | spectra_subsetting                                             
⠏ |        920 | spectra_subsetting                                             
⠙ |        922 | spectra_subsetting                                             
⠼ |        925 | spectra_subsetting                                             
⠧ |        928 | spectra_subsetting                                             
⠋ |        931 | spectra_subsetting                                             
⠸ |        934 | spectra_subsetting                                             
⠦ |        937 | spectra_subsetting                                             
⠏ |        940 | spectra_subsetting                                             
⠋ |        941 | spectra_subsetting                                             
⠸ |        944 | spectra_subsetting                                             
⠦ |        947 | spectra_subsetting                                             
⠇ |        949 | spectra_subsetting                                             
⠙ |        952 | spectra_subsetting                                             
⠼ |        955 | spectra_subsetting                                             
⠦ |        957 | spectra_subsetting                                             
⠇ |        959 | spectra_subsetting                                             
⠙ |        962 | spectra_subsetting                                             
⠼ |        965 | spectra_subsetting                                             
⠦ |        967 | spectra_subsetting                                             
⠏ |        970 | spectra_subsetting                                             
⠹ |        973 | spectra_subsetting                                             
⠴ |        976 | spectra_subsetting                                             
⠦ |        977 | spectra_subsetting                                             
⠏ |        980 | spectra_subsetting                                             
⠹ |        983 | spectra_subsetting                                             
⠸ |        984 | spectra_subsetting                                             
⠴ |        986 | spectra_subsetting                                             
⠇ |        989 | spectra_subsetting                                             
⠏ |        990 | spectra_subsetting                                             
⠹ |        993 | spectra_subsetting                                             
⠴ |        996 | spectra_subsetting                                             
⠦ |        997 | spectra_subsetting                                             
⠇ |        999 | spectra_subsetting                                             
⠋ |        1001 | spectra_subsetting                                            
⠸ |        1004 | spectra_subsetting                                            
⠴ |        1006 | spectra_subsetting                                            
⠇ |        1009 | spectra_subsetting                                            
⠙ |        1012 | spectra_subsetting                                            
⠼ |        1015 | spectra_subsetting                                            
⠧ |        1018 | spectra_subsetting                                            
⠏ |        1020 | spectra_subsetting                                            
⠹ |        1023 | spectra_subsetting                                            
⠼ |        1025 | spectra_subsetting                                            
⠧ |        1028 | spectra_subsetting                                            
⠋ |        1031 | spectra_subsetting                                            
⠸ |        1034 | spectra_subsetting                                            
⠦ |        1037 | spectra_subsetting                                            
⠏ |        1040 | spectra_subsetting                                            
⠹ |        1043 | spectra_subsetting                                            
⠼ |        1045 | spectra_subsetting                                            
⠧ |        1048 | spectra_subsetting                                            
⠋ |        1051 | spectra_subsetting                                            
⠹ |        1053 | spectra_subsetting                                            
⠴ |        1056 | spectra_subsetting                                            
⠇ |        1059 | spectra_subsetting                                            
⠋ |        1061 | spectra_subsetting                                            
⠸ |        1064 | spectra_subsetting                                            
⠦ |        1067 | spectra_subsetting                                            
⠏ |        1070 | spectra_subsetting                                            
⠹ |        1073 | spectra_subsetting                                            
⠴ |        1076 | spectra_subsetting                                            
⠇ |        1079 | spectra_subsetting                                            
⠋ |        1081 | spectra_subsetting                                            
⠹ |        1083 | spectra_subsetting                                            
⠼ |        1085 | spectra_subsetting                                            
⠧ |        1088 | spectra_subsetting                                            
⠋ |        1091 | spectra_subsetting                                            
⠸ |        1094 | spectra_subsetting                                            
⠦ |        1097 | spectra_subsetting                                            
⠏ |        1100 | spectra_subsetting                                            
⠙ |        1102 | spectra_subsetting                                            
⠼ |        1105 | spectra_subsetting                                            
⠧ |        1108 | spectra_subsetting                                            
⠋ |        1111 | spectra_subsetting                                            
⠸ |        1114 | spectra_subsetting                                            
⠦ |        1117 | spectra_subsetting                                            
⠏ |        1120 | spectra_subsetting                                            
⠙ |        1122 | spectra_subsetting                                            
⠼ |        1125 | spectra_subsetting                                            
⠦ |        1127 | spectra_subsetting                                            
⠏ |        1130 | spectra_subsetting                                            
⠹ |        1133 | spectra_subsetting                                            
⠸ |        1134 | spectra_subsetting                                            
⠦ |        1137 | spectra_subsetting                                            
⠧ |        1138 | spectra_subsetting                                            
⠇ |        1139 | spectra_subsetting                                            
⠋ |        1141 | spectra_subsetting                                            
⠹ |        1143 | spectra_subsetting                                            
⠴ |        1146 | spectra_subsetting                                            
⠧ |        1148 | spectra_subsetting                                            
⠋ |        1151 | spectra_subsetting                                            
⠸ |        1154 | spectra_subsetting                                            
⠦ |        1157 | spectra_subsetting                                            
⠏ |        1160 | spectra_subsetting                                            
⠙ |        1162 | spectra_subsetting                                            
⠹ |        1163 | spectra_subsetting                                            
⠼ |        1165 | spectra_subsetting                                            
⠧ |        1168 | spectra_subsetting                                            
⠋ |        1171 | spectra_subsetting                                            
⠸ |        1174 | spectra_subsetting                                            
⠼ |        1175 | spectra_subsetting                                            
⠧ |        1178 | spectra_subsetting                                            
⠏ |        1180 | spectra_subsetting                                            
⠙ |        1182 | spectra_subsetting                                            
⠸ |        1184 | spectra_subsetting                                            
⠦ |        1187 | spectra_subsetting                                            
⠏ |        1190 | spectra_subsetting                                            
⠙ |        1192 | spectra_subsetting                                            
⠼ |        1195 | spectra_subsetting                                            
⠧ |        1198 | spectra_subsetting                                            
⠏ |        1200 | spectra_subsetting                                            
⠹ |        1203 | spectra_subsetting                                            
⠧ |        1208 | spectra_subsetting                                            
⠦ |        1217 | spectra_subsetting                                            
⠹ |        1223 | spectra_subsetting                                            
⠧ |        1238 | spectra_subsetting                                            
⠴ |        1246 | spectra_subsetting                                            
✔ |        1246 | spectra_subsetting [24.1s]

⠏ |          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 [6.5s]

══ Results ═════════════════════════════════════════════════════════════════════
Duration: 32.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 
308.639  35.061 331.756 

Example timings

MsBackendSql.Rcheck/MsBackendSql-Ex.timings

nameusersystemelapsed
MsBackendSql7.6430.7308.707