Johannes Rainer
| Snapshot Date: 2025-03-20 13:40 -0400 (Thu, 20 Mar 2025) |
| git_url: https://git.bioconductor.org/packages/MsBackendSql |
| git_branch: devel |
| git_last_commit: a5f890a |
| git_last_commit_date: 2025-03-17 03:23:42 -0400 (Mon, 17 Mar 2025) |
| Back to Multiple platform build/check report for BioC 3.21: simplified long |
|
This page was generated on 2025-03-21 11:45 -0400 (Fri, 21 Mar 2025).
| Hostname | OS | Arch (*) | R version | Installed pkgs |
|---|---|---|---|---|
| nebbiolo1 | Linux (Ubuntu 24.04.1 LTS) | x86_64 | R Under development (unstable) (2025-03-13 r87965) -- "Unsuffered Consequences" | 4777 |
| palomino7 | Windows Server 2022 Datacenter | x64 | R Under development (unstable) (2025-03-01 r87860 ucrt) -- "Unsuffered Consequences" | 4545 |
| lconway | macOS 12.7.1 Monterey | x86_64 | R Under development (unstable) (2025-03-02 r87868) -- "Unsuffered Consequences" | 4576 |
| kjohnson3 | macOS 13.7.1 Ventura | arm64 | R Under development (unstable) (2025-03-02 r87868) -- "Unsuffered Consequences" | 4528 |
| kunpeng2 | Linux (openEuler 24.03 LTS) | aarch64 | R Under development (unstable) (2025-02-19 r87757) -- "Unsuffered Consequences" | 4458 |
| 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 1347/2313 | Hostname | OS / Arch | INSTALL | BUILD | CHECK | BUILD BIN | ||||||||
| MsBackendSql 1.7.4 (landing page) Johannes Rainer
| nebbiolo1 | Linux (Ubuntu 24.04.1 LTS) / x86_64 | OK | OK | OK | | ||||||||
| palomino7 | Windows Server 2022 Datacenter / x64 | OK | OK | OK | OK | | ||||||||
| lconway | macOS 12.7.1 Monterey / x86_64 | OK | OK | OK | OK | | ||||||||
| kjohnson3 | macOS 13.7.1 Ventura / arm64 | OK | OK | OK | OK | | ||||||||
| kunpeng2 | Linux (openEuler 24.03 LTS) / aarch64 | OK | OK | OK | ||||||||||
|
To the developers/maintainers of the MsBackendSql package: - Allow up to 24 hours (and sometimes 48 hours) for your latest push to git@git.bioconductor.org:packages/MsBackendSql.git to reflect on this report. See Troubleshooting Build Report for more information. - Use the following Renviron settings to reproduce errors and warnings. - If 'R CMD check' started to fail recently on the Linux builder(s) over a missing dependency, add the missing dependency to 'Suggests:' in your DESCRIPTION file. See Renviron.bioc for more information. |
| Package: MsBackendSql |
| Version: 1.7.4 |
| Command: /Library/Frameworks/R.framework/Resources/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/Library/Frameworks/R.framework/Resources/library --no-vignettes --timings MsBackendSql_1.7.4.tar.gz |
| StartedAt: 2025-03-20 20:26:18 -0400 (Thu, 20 Mar 2025) |
| EndedAt: 2025-03-20 20:28:30 -0400 (Thu, 20 Mar 2025) |
| EllapsedTime: 131.6 seconds |
| RetCode: 0 |
| Status: OK |
| CheckDir: MsBackendSql.Rcheck |
| Warnings: 0 |
##############################################################################
##############################################################################
###
### Running command:
###
### /Library/Frameworks/R.framework/Resources/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/Library/Frameworks/R.framework/Resources/library --no-vignettes --timings MsBackendSql_1.7.4.tar.gz
###
##############################################################################
##############################################################################
* using log directory ‘/Users/biocbuild/bbs-3.21-bioc/meat/MsBackendSql.Rcheck’
* using R Under development (unstable) (2025-03-02 r87868)
* using platform: aarch64-apple-darwin20
* R was compiled by
Apple clang version 14.0.0 (clang-1400.0.29.202)
GNU Fortran (GCC) 14.2.0
* running under: macOS Ventura 13.7.1
* using session charset: UTF-8
* using option ‘--no-vignettes’
* checking for file ‘MsBackendSql/DESCRIPTION’ ... OK
* this is package ‘MsBackendSql’ version ‘1.7.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 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 ... NOTE
filterRt,MsBackendSql: no visible global function definition for
‘msLevel’
filterRt,MsBackendSql: no visible global function definition for
‘rtime’
Undefined global functions or variables:
msLevel rtime
* checking Rd files ... OK
* checking Rd metadata ... OK
* checking Rd cross-references ... OK
* checking for missing documentation entries ... OK
* checking for code/documentation mismatches ... OK
* checking Rd \usage sections ... OK
* checking Rd contents ... OK
* checking for unstated dependencies in examples ... OK
* checking files in ‘vignettes’ ... OK
* checking examples ... OK
* checking for unstated dependencies in ‘tests’ ... OK
* checking tests ...
Running ‘testthat.R’
OK
* checking for unstated dependencies in vignettes ... OK
* checking package vignettes ... OK
* checking running R code from vignettes ... SKIPPED
* checking re-building of vignette outputs ... SKIPPED
* checking PDF version of manual ... OK
* DONE
Status: 1 NOTE
See
‘/Users/biocbuild/bbs-3.21-bioc/meat/MsBackendSql.Rcheck/00check.log’
for details.
MsBackendSql.Rcheck/00install.out
############################################################################## ############################################################################## ### ### Running command: ### ### /Library/Frameworks/R.framework/Resources/bin/R CMD INSTALL MsBackendSql ### ############################################################################## ############################################################################## * installing to library ‘/Library/Frameworks/R.framework/Versions/4.5-arm64/Resources/library’ * installing *source* package ‘MsBackendSql’ ... ** this is package ‘MsBackendSql’ version ‘1.7.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)
MsBackendSql.Rcheck/tests/testthat.Rout
R Under development (unstable) (2025-03-02 r87868) -- "Unsuffered Consequences"
Copyright (C) 2025 The R Foundation for Statistical Computing
Platform: aarch64-apple-darwin20
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 0s
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 0s
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 0s
Creating indices .... Done
[1] TRUE
> 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 28s
Creating indices .... Done
[1] TRUE
> tmt_be <- backendInitialize(MsBackendSql(), tmt_db)
>
> test_check("MsBackendSql")
[ FAIL 0 | WARN 1 | SKIP 1 | PASS 455 ]
══ Skipped tests (1) ═══════════════════════════════════════════════════════════
• empty test (1): 'test_MsBackendSql-functions.R:414:1'
[ FAIL 0 | WARN 1 | SKIP 1 | PASS 455 ]
>
> 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
⠇ | 79 | spectra_subsetting
⠴ | 166 | spectra_subsetting
⠹ | 263 | spectra_subsetting
⠸ | 364 | spectra_subsetting
⠙ | 462 | spectra_subsetting
⠇ | 559 | spectra_subsetting
⠋ | 601 | spectra_subsetting
⠼ | 605 | spectra_subsetting
⠇ | 609 | spectra_subsetting
⠹ | 613 | spectra_subsetting
⠦ | 617 | spectra_subsetting
⠋ | 621 | spectra_subsetting
⠼ | 625 | spectra_subsetting
⠇ | 629 | spectra_subsetting
⠹ | 633 | spectra_subsetting
⠦ | 637 | spectra_subsetting
⠋ | 641 | spectra_subsetting
⠼ | 645 | spectra_subsetting
⠇ | 649 | spectra_subsetting
⠹ | 653 | spectra_subsetting
⠦ | 657 | spectra_subsetting
⠋ | 661 | spectra_subsetting
⠼ | 665 | spectra_subsetting
⠇ | 669 | spectra_subsetting
⠹ | 673 | spectra_subsetting
⠦ | 677 | spectra_subsetting
⠋ | 681 | spectra_subsetting
⠼ | 685 | spectra_subsetting
⠇ | 689 | spectra_subsetting
⠹ | 693 | spectra_subsetting
⠦ | 697 | spectra_subsetting
⠋ | 701 | spectra_subsetting
⠼ | 705 | spectra_subsetting
⠇ | 709 | spectra_subsetting
⠹ | 713 | spectra_subsetting
⠦ | 717 | spectra_subsetting
⠋ | 721 | spectra_subsetting
⠼ | 725 | spectra_subsetting
⠇ | 729 | spectra_subsetting
⠹ | 733 | spectra_subsetting
⠦ | 737 | spectra_subsetting
⠋ | 741 | spectra_subsetting
⠼ | 745 | spectra_subsetting
⠇ | 749 | spectra_subsetting
⠹ | 753 | spectra_subsetting
⠦ | 757 | spectra_subsetting
⠋ | 761 | spectra_subsetting
⠼ | 765 | spectra_subsetting
⠇ | 769 | spectra_subsetting
⠹ | 773 | spectra_subsetting
⠦ | 777 | spectra_subsetting
⠋ | 781 | spectra_subsetting
⠼ | 785 | spectra_subsetting
⠇ | 789 | spectra_subsetting
⠹ | 793 | spectra_subsetting
⠇ | 799 | spectra_subsetting
⠼ | 815 | spectra_subsetting
⠏ | 830 | spectra_subsetting
✔ | 838 | spectra_subsetting [6.5s]
⠏ | 0 | spectra_variables
⠋ | 31 | spectra_variables
✔ | 64 | spectra_variables
══ Results ═════════════════════════════════════════════════════════════════════
Duration: 6.8 s
[ FAIL 0 | WARN 0 | SKIP 0 | PASS 906 ]
🌈 Your tests are over the rainbow 🌈
Warning message:
call dbDisconnect() when finished working with a connection
>
> be <- tmt_be[sample(seq_along(tmt_be), 300)]
> test_dir(test_suite, stop_on_failure = TRUE)
✔ | F W S OK | Context
⠏ | 0 | peaks_variables
⠙ | 2 | peaks_variables
⠸ | 4 | peaks_variables
✔ | 4 | peaks_variables [1.5s]
⠏ | 0 | spectra_subsetting
⠇ | 79 | spectra_subsetting
⠇ | 119 | spectra_subsetting
⠏ | 220 | spectra_subsetting
⠇ | 319 | spectra_subsetting
⠙ | 422 | spectra_subsetting
⠸ | 514 | spectra_subsetting
⠦ | 607 | spectra_subsetting
⠼ | 715 | spectra_subsetting
⠦ | 817 | spectra_subsetting
⠼ | 905 | spectra_subsetting
⠧ | 908 | spectra_subsetting
⠙ | 912 | spectra_subsetting
⠴ | 916 | spectra_subsetting
⠏ | 920 | spectra_subsetting
⠙ | 922 | spectra_subsetting
⠼ | 925 | spectra_subsetting
⠇ | 929 | spectra_subsetting
⠹ | 933 | spectra_subsetting
⠴ | 936 | spectra_subsetting
⠏ | 940 | spectra_subsetting
⠹ | 943 | spectra_subsetting
⠼ | 945 | spectra_subsetting
⠇ | 949 | spectra_subsetting
⠹ | 953 | spectra_subsetting
⠦ | 957 | spectra_subsetting
⠋ | 961 | spectra_subsetting
⠼ | 965 | spectra_subsetting
⠇ | 969 | spectra_subsetting
⠙ | 972 | spectra_subsetting
⠼ | 975 | spectra_subsetting
⠇ | 979 | spectra_subsetting
⠋ | 981 | spectra_subsetting
⠸ | 984 | spectra_subsetting
⠦ | 987 | spectra_subsetting
⠋ | 991 | spectra_subsetting
⠹ | 993 | spectra_subsetting
⠦ | 997 | spectra_subsetting
⠇ | 999 | spectra_subsetting
⠙ | 1002 | spectra_subsetting
⠴ | 1006 | spectra_subsetting
⠏ | 1010 | spectra_subsetting
⠸ | 1014 | spectra_subsetting
⠧ | 1018 | spectra_subsetting
⠙ | 1022 | spectra_subsetting
⠼ | 1025 | spectra_subsetting
⠇ | 1029 | spectra_subsetting
⠹ | 1033 | spectra_subsetting
⠴ | 1036 | spectra_subsetting
⠏ | 1040 | spectra_subsetting
⠙ | 1042 | spectra_subsetting
⠼ | 1045 | spectra_subsetting
⠇ | 1049 | spectra_subsetting
⠙ | 1052 | spectra_subsetting
⠼ | 1055 | spectra_subsetting
⠇ | 1059 | spectra_subsetting
⠹ | 1063 | spectra_subsetting
⠦ | 1067 | spectra_subsetting
⠇ | 1069 | spectra_subsetting
⠹ | 1073 | spectra_subsetting
⠴ | 1076 | spectra_subsetting
⠏ | 1080 | spectra_subsetting
⠸ | 1084 | spectra_subsetting
⠴ | 1086 | spectra_subsetting
⠧ | 1088 | spectra_subsetting
⠙ | 1092 | spectra_subsetting
⠴ | 1096 | spectra_subsetting
⠏ | 1100 | spectra_subsetting
⠙ | 1102 | spectra_subsetting
⠸ | 1104 | spectra_subsetting
⠧ | 1108 | spectra_subsetting
⠋ | 1111 | spectra_subsetting
⠼ | 1115 | spectra_subsetting
⠇ | 1119 | spectra_subsetting
⠹ | 1123 | spectra_subsetting
⠦ | 1127 | spectra_subsetting
⠋ | 1131 | spectra_subsetting
⠸ | 1134 | spectra_subsetting
⠧ | 1138 | spectra_subsetting
⠙ | 1142 | spectra_subsetting
⠴ | 1146 | spectra_subsetting
⠇ | 1149 | spectra_subsetting
⠙ | 1152 | spectra_subsetting
⠴ | 1156 | spectra_subsetting
⠏ | 1160 | spectra_subsetting
⠸ | 1164 | spectra_subsetting
⠧ | 1168 | spectra_subsetting
⠙ | 1172 | spectra_subsetting
⠸ | 1174 | spectra_subsetting
⠧ | 1178 | spectra_subsetting
⠙ | 1182 | spectra_subsetting
⠸ | 1184 | spectra_subsetting
⠧ | 1188 | spectra_subsetting
⠙ | 1192 | spectra_subsetting
⠼ | 1195 | spectra_subsetting
⠇ | 1199 | spectra_subsetting
⠙ | 1202 | spectra_subsetting
⠧ | 1208 | spectra_subsetting
⠦ | 1217 | spectra_subsetting
⠹ | 1223 | spectra_subsetting
⠧ | 1238 | spectra_subsetting
✔ | 1246 | spectra_subsetting [17.0s]
⠏ | 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 [5.9s]
══ Results ═════════════════════════════════════════════════════════════════════
Duration: 24.4 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
89.041 9.618 98.217
MsBackendSql.Rcheck/MsBackendSql-Ex.timings
| name | user | system | elapsed | |
| MsBackendSql | 1.181 | 0.167 | 1.358 | |