rcconsult / rpostgresql

Automatically exported from code.google.com/p/rpostgresql
0 stars 0 forks source link

Large dbGetQuery/dbSendQuery on CentOS 6.5 Failing #74

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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.

Original issue reported on code.google.com by ky...@brandeis.edu on 21 Jan 2015 at 3:43

GoogleCodeExporter commented 9 years ago
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).

Original comment by ky...@brandeis.edu on 21 Jan 2015 at 5:31

GoogleCodeExporter commented 9 years ago
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

Original comment by ky...@brandeis.edu on 21 Jan 2015 at 6:08