Issue 67 in rpostgresql: [Memory overflow] Access Vioaltion - application crash

[rpost...@googlecode.com]

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

New issue 67 by SieuT...@gmail.com: [Memory overflow] Access Vioaltion -
application crash
https://code.google.com/p/rpostgresql/issues/detail?id=67

What steps will reproduce the problem?
1. Create a table that contains "unknown" type
For ex:
create table foobar as select 'a string' as astring, null as anull;

2.IN Rgui, launch the following script

library(RPostgreSQL)
condb=dbConnect(PostgreSQL(),user="...",password="...",dbname="test",host="...",port="5432")

for (counter in 1:1500) {
foobar=dbGetQuery(condb,statement="select * from foobar")
}


What is the expected output?
the application terminates without any problem , but it will have 1500
warnings
( unrecognized PostgreSQL field type unknown (id:750) in column 0)

What do you see instead?
Rgui is crashed .


What version of the product are you using? On what operating system?
R 3.0.2 (64), RPostgresql 0.4, windows 7 64b

Please provide any additional information below.
i have debugged with windbg and voila the result:the attached file




Attachments:
debug.txt 6.8 KB

--
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 67 by ne...@neiltiffin.com: [Memory overflow] Access

Vioaltion - application crash
https://code.google.com/p/rpostgresql/issues/detail?id=67

Just a note that the reported example does not cause any unexpected problem
with recent mac versions as noted below.


-------------- write version info ----------------------
ProductName: Mac OS X
ProductVersion: 10.9.5
BuildVersion: 13F34

RPostgreSQL svn version: 273

psql (PostgreSQL) 9.4rc1

R version 3.1.2 (2014-10-31)
Platform: x86_64-apple-darwin13.4.0 (64-bit)

> library(RPostgreSQL)
Loading required package: DBI

> condb=dbConnect(PostgreSQL(),user="...",dbname="RPostgreSQL_Test",host="localhost",port="5432")

> foobar=dbGetQuery(condb,statement="select * from foobar")

Warning messages:
1: In postgresqlExecStatement(conn, statement, ...) :
RS-DBI driver warning: (unrecognized PostgreSQL field type unknown
(id:705) in column 0)
2: In postgresqlExecStatement(conn, statement, ...) :
RS-DBI driver warning: (unrecognized PostgreSQL field type unknown
(id:705) in column 1)

> for (counter in 1:1500) {

+ foobar=dbGetQuery(condb,statement="select * from foobar")
+ }
There were 50 or more warnings (use warnings() to see the first 50)

> print(foobar)
astring anull
1 a string <NA>

[rpost...@googlecode.com]

Comment #2 on issue 67 by SieuT...@gmail.com: [Memory overflow] Access

Vioaltion - application crash
https://code.google.com/p/rpostgresql/issues/detail?id=67

I ran it on Debian 7 and got the same error:
segmentation fault
.

Regards,
Truc