Message-ID: <496824E9.7070500@joeconway.com>
Date: 2009-01-10T04:32:41Z
From: Joe Conway
Subject: crash on multiple queries to postgresql db
In-Reply-To: <200901091452.26137.dylan.beaudette@gmail.com>
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