Hi, 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 pointer: 0x0a605de4 *** ======= Backtrace: ========/lib/i686/cmov/libc.so.6[0xb7cd16b4] /lib/i686/cmov/libc.so.6(realloc+0x242)[0xb7cd5d12] /usr/local/pgsql/lib/libpq.so.4(pqCheckOutBufferSpace+0x7c)[0xb780edfe] # R info sessionInfo() R version 2.8.0 (2008-10-20) i686-pc-linux-gnu locale: LC_CTYPE=en_US.UTF-8;LC_NUMERIC=C;LC_TIME=en_US.UTF-8;LC_COLLATE=en_US.UTF-8;LC_MONETARY=C;LC_MESSAGES=en_US.UTF-8;LC_PAPER=en_US.UTF-8;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=en_US.UTF-8;LC_IDENTIFICATION=C attached base packages: [1] grid stats graphics grDevices utils datasets methods [8] base other attached packages: [1] RdbiPgSQL_1.8.0 Rdbi_1.8.0 lattice_0.17-20 Any ideas? -- Dylan Beaudette Soil Resource Laboratory http://casoilresource.lawr.ucdavis.edu/ University of California at Davis 530.754.7341
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