Issue 74 in rpostgresql: Large dbGetQuery/dbSendQuery on CentOS 6.5 Failing

[rpost...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 74 by ky...@brandeis.edu: Large dbGetQuery/dbSendQuery on CentOS
6.5 Failing
https://code.google.com/p/rpostgresql/issues/detail?id=74

What steps will reproduce the problem?
1. Create large character string to be sent to the DB (nchar 10000+)
2. dbSendQuery(con, string)
3. R hangs

What is the expected output? What do you see instead?
Expected the query to execute on server, instead R hangs and cannot be quit
using CTRL+C, must use CTRL+Z and kill PID.

What version of the product are you using? On what operating system?
Strangely enough, the exact same string works on my Windows 7 x64
However, it fails on CentOS 2.6.32-504.1.3.el6.x86_64

Please provide any additional information below.



--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[rpost...@googlecode.com]

Comment #1 on issue 74 by ky...@brandeis.edu: Large dbGetQuery/dbSendQuery

on CentOS 6.5 Failing
https://code.google.com/p/rpostgresql/issues/detail?id=74

Forgot to mention that both instances of R (on Unix & Windows) are R
version 3.1.2 (2014-10-31) -- "Pumpkin Helmet"

Both are on version 0.4 of RPostgreSQL and 0.3.1 of DBI.

Additionally, the CentOS 6.5 box has Postgres 9.4 installed (recently
upgraded from 8.x trying to debug).

[rpost...@googlecode.com]

Comment #2 on issue 74 by ky...@brandeis.edu: Large dbGetQuery/dbSendQuery

on CentOS 6.5 Failing
https://code.google.com/p/rpostgresql/issues/detail?id=74

Actually, it turns out the command actually does error out :
Error in postgresqlExecStatement(conn, statement, ...) :
RS-DBI driver: (could not Retrieve the result : SSL SYSCALL error:
Connection timed out