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

This page was generated on 2025-10-24 10:06 -0400 (Fri, 24 Oct 2025).

HostnameOSArch (*)R versionInstalled pkgs
teran2Linux (Ubuntu 24.04.3 LTS)x86_644.5.1 (2025-06-13) -- "Great Square Root" 926
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 147/229HostnameOS / ArchINSTALLBUILDCHECK
MsBackendSql 1.9.4  (landing page)
Johannes Rainer
Snapshot Date: 2025-10-24 06:00 -0400 (Fri, 24 Oct 2025)
git_url: https://git.bioconductor.org/packages/MsBackendSql
git_branch: devel
git_last_commit: d3bb395
git_last_commit_date: 2025-10-20 02:19:09 -0400 (Mon, 20 Oct 2025)
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.9.4
Command: /home/rapidbuild/bbs-3.22-bioc-rapid/R/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/home/rapidbuild/bbs-3.22-bioc-rapid/R/site-library --timings MsBackendSql_1.9.4.tar.gz
StartedAt: 2025-10-24 08:59:13 -0400 (Fri, 24 Oct 2025)
EndedAt: 2025-10-24 09:03:16 -0400 (Fri, 24 Oct 2025)
EllapsedTime: 242.9 seconds
RetCode: 0
Status:   OK  
CheckDir: MsBackendSql.Rcheck
Warnings: 0

Command output

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


* using log directory ‘/media/volume/teran2_disk/rapidbuild/bbs-3.22-bioc-rapid/meat/MsBackendSql.Rcheck’
* using R version 4.5.1 (2025-06-13)
* using platform: x86_64-pc-linux-gnu
* R was compiled by
    gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0
    GNU Fortran (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0
* running under: Ubuntu 24.04.3 LTS
* using session charset: UTF-8
* checking for file ‘MsBackendSql/DESCRIPTION’ ... OK
* this is package ‘MsBackendSql’ version ‘1.9.4’
* 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 loading without being on the library search path ... 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 re-building of vignette outputs ... OK
* checking PDF version of manual ... OK
* DONE

Status: OK


Installation output

MsBackendSql.Rcheck/00install.out

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


* installing to library ‘/media/volume/teran2_disk/rapidbuild/bbs-3.22-bioc-rapid/R/site-library’
* installing *source* package ‘MsBackendSql’ ...
** this is package ‘MsBackendSql’ version ‘1.9.4’
** 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.5.1 (2025-06-13) -- "Great Square Root"
Copyright (C) 2025 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(msdata)
> 
> setClass("DummySQL",
+          contains = "SQLiteConnection")
> 
> setMethod("dbExecute", c("DummySQL", "character"),
+           function(conn, statement, ...) {
+               TRUE
+           })
> 
> mm8_file <- system.file("microtofq", "MM8.mzML", package = "msdata")
> mm8_sps <- Spectra(mm8_file)
> mm8_db_long <- dbConnect(SQLite(), tempfile())
> createMsBackendSqlDatabase(mm8_db_long, mm8_file, blob = FALSE,
+                            peaksStorageMode = "long")
Importing data ... 

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

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

[==========================================================] 1/1 (100%) in  1s
Creating indices .... Done
[1] TRUE
> mm8_be_blob2 <- backendInitialize(MsBackendSql(), mm8_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)
> ##
> ################################################################################
> 
> mm14_file <- system.file("microtofq", "MM14.mzML", package = "msdata")
> mm_db <- dbConnect(SQLite(), tempfile())
> createMsBackendSqlDatabase(mm_db, c(mm8_file, mm14_file), blob = FALSE)
Importing data ... 

[==========================================================] 1/1 (100%) in  1s
Creating indices .... Done
[1] TRUE
> mm_be <- backendInitialize(MsBackendSql(), mm_db)
> 
> tmt_file <- proteomics(full.names = TRUE)[4L]
> 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 1 | SKIP 2 | PASS 595 ]

══ Skipped tests (2) ═══════════════════════════════════════════════════════════
• empty test (2): 'test_MsBackendSql-functions.R:426:1',
  'test_MsBackendSql-functions.R:670:1'

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

⠏ |          0 | peaks_variables                                                
✔ |          4 | peaks_variables

⠏ |          0 | spectra_subsetting                                             
⠼ |         35 | spectra_subsetting                                             
⠼ |         85 | spectra_subsetting                                             
⠏ |        130 | spectra_subsetting                                             
⠏ |        180 | spectra_subsetting                                             
⠏ |        230 | spectra_subsetting                                             
⠼ |        275 | spectra_subsetting                                             
⠴ |        326 | spectra_subsetting                                             
⠦ |        377 | spectra_subsetting                                             
⠦ |        427 | spectra_subsetting                                             
⠦ |        477 | spectra_subsetting                                             
⠦ |        527 | spectra_subsetting                                             
⠧ |        578 | spectra_subsetting                                             
⠇ |        599 | spectra_subsetting                                             
⠙ |        602 | spectra_subsetting                                             
⠼ |        605 | spectra_subsetting                                             
⠧ |        608 | spectra_subsetting                                             
⠋ |        611 | spectra_subsetting                                             
⠸ |        614 | spectra_subsetting                                             
⠦ |        617 | spectra_subsetting                                             
⠏ |        620 | spectra_subsetting                                             
⠹ |        623 | spectra_subsetting                                             
⠴ |        626 | spectra_subsetting                                             
⠇ |        629 | spectra_subsetting                                             
⠙ |        632 | spectra_subsetting                                             
⠼ |        635 | spectra_subsetting                                             
⠧ |        638 | spectra_subsetting                                             
⠋ |        641 | spectra_subsetting                                             
⠸ |        644 | spectra_subsetting                                             
⠦ |        647 | spectra_subsetting                                             
⠏ |        650 | spectra_subsetting                                             
⠹ |        653 | spectra_subsetting                                             
⠴ |        656 | spectra_subsetting                                             
⠇ |        659 | spectra_subsetting                                             
⠙ |        662 | spectra_subsetting                                             
⠼ |        665 | spectra_subsetting                                             
⠧ |        668 | spectra_subsetting                                             
⠋ |        671 | spectra_subsetting                                             
⠸ |        674 | spectra_subsetting                                             
⠴ |        676 | spectra_subsetting                                             
⠇ |        679 | spectra_subsetting                                             
⠋ |        681 | spectra_subsetting                                             
⠸ |        684 | spectra_subsetting                                             
⠦ |        687 | spectra_subsetting                                             
⠏ |        690 | spectra_subsetting                                             
⠹ |        693 | spectra_subsetting                                             
⠴ |        696 | spectra_subsetting                                             
⠇ |        699 | spectra_subsetting                                             
⠙ |        702 | spectra_subsetting                                             
⠼ |        705 | spectra_subsetting                                             
⠧ |        708 | spectra_subsetting                                             
⠋ |        711 | spectra_subsetting                                             
⠸ |        714 | spectra_subsetting                                             
⠦ |        717 | spectra_subsetting                                             
⠏ |        720 | spectra_subsetting                                             
⠹ |        723 | spectra_subsetting                                             
⠴ |        726 | spectra_subsetting                                             
⠇ |        729 | spectra_subsetting                                             
⠙ |        732 | spectra_subsetting                                             
⠼ |        735 | spectra_subsetting                                             
⠧ |        738 | spectra_subsetting                                             
⠋ |        741 | spectra_subsetting                                             
⠸ |        744 | spectra_subsetting                                             
⠦ |        747 | spectra_subsetting                                             
⠏ |        750 | spectra_subsetting                                             
⠹ |        753 | spectra_subsetting                                             
⠴ |        756 | spectra_subsetting                                             
⠇ |        759 | spectra_subsetting                                             
⠙ |        762 | spectra_subsetting                                             
⠼ |        765 | spectra_subsetting                                             
⠧ |        768 | spectra_subsetting                                             
⠋ |        771 | spectra_subsetting                                             
⠸ |        774 | spectra_subsetting                                             
⠴ |        776 | spectra_subsetting                                             
⠇ |        779 | spectra_subsetting                                             
⠋ |        781 | spectra_subsetting                                             
⠸ |        784 | spectra_subsetting                                             
⠴ |        786 | spectra_subsetting                                             
⠇ |        789 | spectra_subsetting                                             
⠋ |        791 | spectra_subsetting                                             
⠸ |        794 | spectra_subsetting                                             
⠇ |        799 | spectra_subsetting                                             
⠇ |        809 | spectra_subsetting                                             
⠹ |        823 | spectra_subsetting                                             
⠏ |        830 | spectra_subsetting                                             
✔ |        838 | spectra_subsetting [10.9s]

⠏ |          0 | spectra_variables                                              
⠸ |         14 | spectra_variables                                              
⠼ |         35 | spectra_variables                                              
⠸ |         54 | spectra_variables                                              
✔ |         64 | spectra_variables

══ Results ═════════════════════════════════════════════════════════════════════
Duration: 11.4 s

[ FAIL 0 | WARN 0 | SKIP 0 | PASS 906 ]

🌈 Your tests are over the rainbow 🌈
> 
> 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.0s]

⠏ |          0 | spectra_subsetting                                             
⠹ |         23 | spectra_subsetting                                             
⠏ |         70 | spectra_subsetting                                             
⠦ |        117 | spectra_subsetting                                             
⠏ |        160 | spectra_subsetting                                             
⠇ |        209 | spectra_subsetting                                             
⠧ |        258 | spectra_subsetting                                             
⠇ |        299 | spectra_subsetting                                             
⠦ |        347 | spectra_subsetting                                             
⠴ |        396 | spectra_subsetting                                             
⠦ |        437 | spectra_subsetting                                             
⠼ |        485 | spectra_subsetting                                             
⠹ |        533 | spectra_subsetting                                             
⠦ |        577 | spectra_subsetting                                             
⠼ |        625 | spectra_subsetting                                             
⠸ |        674 | spectra_subsetting                                             
⠹ |        723 | spectra_subsetting                                             
⠸ |        764 | spectra_subsetting                                             
⠙ |        812 | spectra_subsetting                                             
⠋ |        861 | spectra_subsetting                                             
⠙ |        902 | spectra_subsetting                                             
⠴ |        906 | spectra_subsetting                                             
⠧ |        908 | spectra_subsetting                                             
⠏ |        910 | spectra_subsetting                                             
⠙ |        912 | spectra_subsetting                                             
⠸ |        914 | spectra_subsetting                                             
⠴ |        916 | spectra_subsetting                                             
⠇ |        919 | spectra_subsetting                                             
⠏ |        920 | spectra_subsetting                                             
⠙ |        922 | spectra_subsetting                                             
⠸ |        924 | spectra_subsetting                                             
⠴ |        926 | spectra_subsetting                                             
⠇ |        929 | spectra_subsetting                                             
⠋ |        931 | spectra_subsetting                                             
⠸ |        934 | spectra_subsetting                                             
⠴ |        936 | spectra_subsetting                                             
⠇ |        939 | spectra_subsetting                                             
⠋ |        941 | spectra_subsetting                                             
⠹ |        943 | spectra_subsetting                                             
⠼ |        945 | spectra_subsetting                                             
⠦ |        947 | spectra_subsetting                                             
⠏ |        950 | spectra_subsetting                                             
⠹ |        953 | spectra_subsetting                                             
⠴ |        956 | spectra_subsetting                                             
⠦ |        957 | spectra_subsetting                                             
⠇ |        959 | spectra_subsetting                                             
⠙ |        962 | spectra_subsetting                                             
⠸ |        964 | spectra_subsetting                                             
⠼ |        965 | spectra_subsetting                                             
⠧ |        968 | spectra_subsetting                                             
⠏ |        970 | spectra_subsetting                                             
⠙ |        972 | spectra_subsetting                                             
⠸ |        974 | spectra_subsetting                                             
⠴ |        976 | spectra_subsetting                                             
⠇ |        979 | spectra_subsetting                                             
⠋ |        981 | spectra_subsetting                                             
⠹ |        983 | spectra_subsetting                                             
⠴ |        986 | spectra_subsetting                                             
⠧ |        988 | spectra_subsetting                                             
⠋ |        991 | spectra_subsetting                                             
⠹ |        993 | spectra_subsetting                                             
⠴ |        996 | spectra_subsetting                                             
⠧ |        998 | spectra_subsetting                                             
⠋ |        1001 | spectra_subsetting                                            
⠸ |        1004 | spectra_subsetting                                            
⠦ |        1007 | spectra_subsetting                                            
⠇ |        1009 | spectra_subsetting                                            
⠙ |        1012 | spectra_subsetting                                            
⠼ |        1015 | spectra_subsetting                                            
⠧ |        1018 | spectra_subsetting                                            
⠏ |        1020 | spectra_subsetting                                            
⠹ |        1023 | spectra_subsetting                                            
⠼ |        1025 | spectra_subsetting                                            
⠦ |        1027 | spectra_subsetting                                            
⠏ |        1030 | spectra_subsetting                                            
⠙ |        1032 | spectra_subsetting                                            
⠹ |        1033 | spectra_subsetting                                            
⠼ |        1035 | spectra_subsetting                                            
⠦ |        1037 | spectra_subsetting                                            
⠏ |        1040 | spectra_subsetting                                            
⠙ |        1042 | spectra_subsetting                                            
⠸ |        1044 | spectra_subsetting                                            
⠦ |        1047 | spectra_subsetting                                            
⠇ |        1049 | spectra_subsetting                                            
⠙ |        1052 | spectra_subsetting                                            
⠸ |        1054 | spectra_subsetting                                            
⠦ |        1057 | spectra_subsetting                                            
⠏ |        1060 | spectra_subsetting                                            
⠹ |        1063 | spectra_subsetting                                            
⠼ |        1065 | spectra_subsetting                                            
⠧ |        1068 | spectra_subsetting                                            
⠋ |        1071 | spectra_subsetting                                            
⠸ |        1074 | spectra_subsetting                                            
⠴ |        1076 | spectra_subsetting                                            
⠧ |        1078 | spectra_subsetting                                            
⠏ |        1080 | spectra_subsetting                                            
⠙ |        1082 | spectra_subsetting                                            
⠸ |        1084 | spectra_subsetting                                            
⠴ |        1086 | spectra_subsetting                                            
⠦ |        1087 | spectra_subsetting                                            
⠇ |        1089 | spectra_subsetting                                            
⠙ |        1092 | spectra_subsetting                                            
⠸ |        1094 | spectra_subsetting                                            
⠦ |        1097 | spectra_subsetting                                            
⠇ |        1099 | spectra_subsetting                                            
⠋ |        1101 | spectra_subsetting                                            
⠹ |        1103 | spectra_subsetting                                            
⠸ |        1104 | spectra_subsetting                                            
⠴ |        1106 | spectra_subsetting                                            
⠇ |        1109 | spectra_subsetting                                            
⠋ |        1111 | spectra_subsetting                                            
⠸ |        1114 | spectra_subsetting                                            
⠴ |        1116 | spectra_subsetting                                            
⠇ |        1119 | spectra_subsetting                                            
⠙ |        1122 | spectra_subsetting                                            
⠹ |        1123 | spectra_subsetting                                            
⠴ |        1126 | spectra_subsetting                                            
⠧ |        1128 | spectra_subsetting                                            
⠋ |        1131 | spectra_subsetting                                            
⠹ |        1133 | spectra_subsetting                                            
⠼ |        1135 | spectra_subsetting                                            
⠧ |        1138 | spectra_subsetting                                            
⠏ |        1140 | spectra_subsetting                                            
⠹ |        1143 | spectra_subsetting                                            
⠼ |        1145 | spectra_subsetting                                            
⠧ |        1148 | spectra_subsetting                                            
⠏ |        1150 | spectra_subsetting                                            
⠙ |        1152 | spectra_subsetting                                            
⠼ |        1155 | spectra_subsetting                                            
⠦ |        1157 | spectra_subsetting                                            
⠏ |        1160 | spectra_subsetting                                            
⠙ |        1162 | spectra_subsetting                                            
⠼ |        1165 | spectra_subsetting                                            
⠦ |        1167 | spectra_subsetting                                            
⠏ |        1170 | spectra_subsetting                                            
⠙ |        1172 | spectra_subsetting                                            
⠸ |        1174 | spectra_subsetting                                            
⠦ |        1177 | spectra_subsetting                                            
⠇ |        1179 | spectra_subsetting                                            
⠙ |        1182 | spectra_subsetting                                            
⠹ |        1183 | spectra_subsetting                                            
⠼ |        1185 | spectra_subsetting                                            
⠧ |        1188 | spectra_subsetting                                            
⠏ |        1190 | spectra_subsetting                                            
⠹ |        1193 | spectra_subsetting                                            
⠼ |        1195 | spectra_subsetting                                            
⠧ |        1198 | spectra_subsetting                                            
⠏ |        1200 | spectra_subsetting                                            
⠙ |        1202 | spectra_subsetting                                            
⠴ |        1206 | spectra_subsetting                                            
⠇ |        1209 | spectra_subsetting                                            
⠦ |        1217 | spectra_subsetting                                            
⠹ |        1223 | spectra_subsetting                                            
⠧ |        1238 | spectra_subsetting                                            
⠴ |        1246 | spectra_subsetting                                            
✔ |        1246 | spectra_subsetting [27.2s]

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

══ Results ═════════════════════════════════════════════════════════════════════
Duration: 38.0 s

[ FAIL 0 | WARN 0 | SKIP 0 | PASS 1314 ]
> 
> dbDisconnect(mm8_db_long)
> dbDisconnect(mm8_db_blob)
> dbDisconnect(mm8_db_blob2)
> dbDisconnect(mm_db)
> dbDisconnect(tmt_db)
> 
> proc.time()
   user  system elapsed 
138.121  15.879 149.721 

Example timings

MsBackendSql.Rcheck/MsBackendSql-Ex.timings

nameusersystemelapsed
MsBackendSql2.2870.3642.740