[Rd] calloc bug in RODBC 1.1-7 and later?

From: Earl F. Glynn <efg_at_stowers-institute.org>
Date: Tue 30 Jan 2007 - 17:23:03 GMT


I'm trying to load Affy Annotation data from an Access database into R using RODBC. This has worked fine for quite some time. The bug seems to be correlated to RODBC versions 1.1-7 and later.

Works fine: R 2.2.0 with RODBC 1.1-4; R 2.3.0 or R 2.4.1 with RODBC 1.1-6 Fails: R 2.3.1 with RDOBC 1.1-7; R 2.4.1 with RODC 1.1-7 or 1.1-8

Details



This works fine:

Version 2.2.0 (2005-10-06 r35749)

Package: RODBC

Version: 1.1-4

Date:                 2005-08-04



R Version 2.3.0 (2006-04-24) or R version 2.4.1 (2006-12-18)

Package: RODBC

Version: 1.1-6

Date:                 2006-04-04



> library("RODBC")

> channel <-
> odbcConnectAccess("S:/Bioinformatics/Software/Affy/Data/MOE430A/MOE430A.mdb")

> moe430a <- sqlFetch(channel,"Annotation", as.is=TRUE)

> odbcClose(channel)

> dim(moe430a)

[1] 22690 43

calloc bug in RODBC 1.1-7 and later?

R Version 2.3.1 (2006-06-01)

Package: RODBC

Version: 1.1-7

Date:                 2006-05-24



> library("RODBC")

> channel <-
> odbcConnectAccess("S:/Bioinformatics/Software/Affy/Data/MOE430A/MOE430A.mdb")

> moe430a <- sqlFetch(channel,"Annotation", as.is=TRUE)

Error in odbcQuery(channel, query, rows_at_time) :

        Calloc could not allocate (67108864 of 1) memory

In addition: Warning message:

Reached total allocation of 1024Mb: see help(memory.size)

R version 2.4.1 (2006-12-18)

Package: RODBC

Version: 1.1-8

Date:                 2007-01-02



> library("RODBC")

> channel <-
> odbcConnectAccess("S:/Bioinformatics/Software/Affy/Data/MOE430A/MOE430A.mdb")

> moe430a <- sqlFetch(channel,"Annotation", as.is=TRUE)

Error in odbcQuery(channel, query, rows_at_time) :

        Calloc could not allocate (67108864 of 1) memory

The Access table is the MOE430A Affy Chip data from a CSV format from NetAffx

http://www.affymetrix.com/Auth/analysis/downloads/na21/ivt/MOE430A.na21.annot.csv.zip

loaded into Access:

http://research.stowers-institute.org/efg/ScientificSoftware/Applications/Affy/Annotations/index.htm

Is there a change I missed in RODBC 1.1-7? What else should I do to troubleshoot this other than reverting to the older version of RODBC?

Thanks for any help with this.

Earl F. Glynn
Scientific Programmer
Stowers Institute for Medical Research



R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel Received on Wed Jan 31 04:25:12 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 30 Jan 2007 - 21:31:13 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.