##############################################################################
##############################################################################
###
### Running command:
###
###   /home/biocbuild/bbs-3.24-bioc/R/bin/R CMD check --install=check:MsBackendSql.install-out.txt --library=/home/biocbuild/bbs-3.24-bioc/R/site-library --timings MsBackendSql_1.13.0.tar.gz
###
##############################################################################
##############################################################################


* using log directory ‘/home/biocbuild/bbs-3.24-bioc/meat/MsBackendSql.Rcheck’
* using R version 4.6.0 RC (2026-04-17 r89917)
* 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.4 LTS
* using session charset: UTF-8
* current time: 2026-05-04 06:02:25 UTC
* checking for file ‘MsBackendSql/DESCRIPTION’ ... OK
* this is package ‘MsBackendSql’ version ‘1.13.0’
* package encoding: UTF-8
* checking package namespace information ... OK
* checking package dependencies ... OK
* checking if this is a source package ... OK
* checking if there is a namespace ... OK
* checking for hidden files and directories ... OK
* checking for portable file names ... OK
* checking for sufficient/correct file permissions ... OK
* checking whether package ‘MsBackendSql’ can be installed ... OK
* checking installed package size ... OK
* checking package directory ... OK
* checking ‘build’ directory ... OK
* checking DESCRIPTION meta-information ... OK
* checking top-level files ... OK
* checking for left-over files ... OK
* checking index information ... OK
* checking package subdirectories ... OK
* checking code files for non-ASCII characters ... OK
* checking R files for syntax errors ... OK
* checking whether the package can be loaded ... OK
* checking whether the package can be loaded with stated dependencies ... OK
* checking whether the package can be unloaded cleanly ... OK
* checking whether the namespace can be loaded with stated dependencies ... OK
* checking whether the namespace can be unloaded cleanly ... OK
* checking 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
Examples with CPU (user + system) or elapsed time > 5s
              user system elapsed
MsBackendSql 8.796  1.263  10.369
* checking for unstated dependencies in ‘tests’ ... OK
* checking tests ...
  Running ‘testthat.R’
 ERROR
Running the tests in ‘tests/testthat.R’ failed.
Last 13 lines of output:
  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  1m
  Creating indices Error: database or disk is full
  Execution halted
* 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: 1 ERROR
See
  ‘/home/biocbuild/bbs-3.24-bioc/meat/MsBackendSql.Rcheck/00check.log’
for details.

##############################################################################
##############################################################################
###
### Running command:
###
###   /home/biocbuild/bbs-3.24-bioc/R/bin/R CMD INSTALL MsBackendSql
###
##############################################################################
##############################################################################


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

R version 4.6.0 RC (2026-04-17 r89917) -- "Because it was There"
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  3s
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  5s
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  1m
Creating indices Error: database or disk is full
Execution halted