Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed

2018-01-19 Thread Ludwig Geistlinger
ary 19, 2018 4:10 PM To: Ludwig Geistlinger; Gabe Becker; Vincent Carey Cc: bioc-devel@r-project.org Subject: Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed On 01/19/2018 02:24 PM, Ludwig Geistlinger wrote: > I apologize if I haven't been specific enough - h

Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed

2018-01-19 Thread Martin Morgan
Public Health From: Bioc-devel <bioc-devel-boun...@r-project.org> on behalf of Martin Morgan <martin.mor...@roswellpark.org> Sent: Friday, January 19, 2018 1:54 PM To: Gabe Becker; Vincent Carey Cc: bioc-devel@r-project.org Subject: Re: [Bioc-

Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed

2018-01-19 Thread Ludwig Geistlinger
.@roswellpark.org> Sent: Friday, January 19, 2018 1:54 PM To: Gabe Becker; Vincent Carey Cc: bioc-devel@r-project.org Subject: Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed On 01/19/2018 12:37 PM, Gabe Becker wrote: > IT seems like you could also force a copy

Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed

2018-01-19 Thread Martin Morgan
On 01/19/2018 12:23 PM, Vincent Carey wrote: good question some of the discussion on http://sqlite.1065341.n5.nabble.com/Parallel-access-to-read-only-in-memory-database-td91814.html seems relevant. converting the relatively small annotation package content to pure R read-only tables on the

Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed

2018-01-19 Thread Gabe Becker
IT seems like you could also force a copy of the reference object via $copy() and then force a refresh of the conn slot by assigning a new db connection into it. I'm having trouble confirming that this would work, however, because I actually can't reproduce the error. The naive way works for me

Re: [Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed

2018-01-19 Thread Vincent Carey
good question some of the discussion on http://sqlite.1065341.n5.nabble.com/Parallel-access-to-read-only-in-memory-database-td91814.html seems relevant. converting the relatively small annotation package content to pure R read-only tables on the master before parallelizing might be very

[Bioc-devel] BiocParallel and AnnotationDbi: database disk image is malformed

2018-01-19 Thread Ludwig Geistlinger
Hi, Within a package I am developing, I would like to enable parallel probe to gene mapping for a compendium of microarray datasets. This accordingly makes use of annotation packages such as hgu133a.db, which in turn connect to the SQLite database via AnnotationDbi. When running in multi-core