crash on multiple queries to postgresql db
Dylan Beaudette wrote:
Subsequent calls to: conn <- dbConnect(PgSQL(), host="localhost", dbname="xxx", user="xxx") query <- dbSendQuery(conn, query_text) res <- dbGetResult(query) are resulting in this: *** glibc detected *** /usr/local/lib/R/bin/exec/R: realloc(): invalid
other attached packages: [1] RdbiPgSQL_1.8.0 Rdbi_1.8.0 lattice_0.17-20 Any ideas?
Well, first off, since you are apparently using RdbiPgSQL from bioconductor, you should probably try asking there. But in any case, you might try the latest release from bioconductor: http://www.bioconductor.org/packages/release/bioc/src/contrib/RdbiPgSQL_1.16.0.tar.gz or else try the recently released PostgreSQL DBI package on CRAN: http://cran.stat.ucla.edu/src/contrib/RPostgreSQL_0.1-3.tar.gz HTH, Joe