R devel - Jan 2009 - [Win] Hangup RGui with RMySQL (PR#13453)

Full_Name: Apfel Schmied
Version:  2.8.1 (2008-12-22)
OS: WinXP SP2
Submission from: (NULL) (134.106.122.139)


RMySQL Version: 0.7-2
DBI Version: 0.2-4
MySQL Version: 5.1.30 (Enviroment Variable MYSQL_HOME is set)

Updated R from 2.60 to 2.8.1. Now Gui.exe hangs up (100% CPU Useage) when
requesting data from a mysql database. 

Example Code:
---------------------------------------------------------------
library(RMySQL) #ok
drv = dbDriver("MySQL") # ok
conn <-
mysqlNewConnection(drv,"table","user","pass") #ok
dbListTables(conn) #ok
resu <- dbGetQuery(conn, "Select * From example WHERE id < 13")
# HANG UP!

Errorcode:
---------------------------------------------------------------
RGui: Rgui.exe - Fehler in Anwendung: Die Anweisung in "0x77c178c0"
verweist auf
Speicher in "0x00000000". Der Vorgang
"read" konnte nicht auf dem Speicher durchgef?hrt werden.
---------------------------------------------------------------
Command in "0x77c178c0" refers to adress "0x00000000",
can't "read" from memory.

Did you build RMySQL yourself?  You need to for MySQL 5.1.  That has 
been reported on R-sig-db, and even on R-help, and looks like your 
mistake.

In any case, RMySQL is not part of R, so this was a misuse of R-bugs 
(please DO read the FAQ).  Now someone has to clean up after you ....


On Mon, 19 Jan 2009, apfel.schmied at emaildienst.de wrote:
> Full_Name: Apfel Schmied
> Version:  2.8.1 (2008-12-22)
> OS: WinXP SP2
> Submission from: (NULL) (134.106.122.139)
>
>
> RMySQL Version: 0.7-2
> DBI Version: 0.2-4
> MySQL Version: 5.1.30 (Enviroment Variable MYSQL_HOME is set)
>
> Updated R from 2.60 to 2.8.1. Now Gui.exe hangs up (100% CPU Useage) when
> requesting data from a mysql database.
>
> Example Code:
> ---------------------------------------------------------------
> library(RMySQL) #ok
> drv = dbDriver("MySQL") # ok
> conn <-
mysqlNewConnection(drv,"table","user","pass") #ok
> dbListTables(conn) #ok
> resu <- dbGetQuery(conn, "Select * From example WHERE id <
13") # HANG UP!
>
> Errorcode:
> ---------------------------------------------------------------
> RGui: Rgui.exe - Fehler in Anwendung: Die Anweisung in
"0x77c178c0" verweist auf
> Speicher in "0x00000000". Der Vorgang
> "read" konnte nicht auf dem Speicher durchgef?hrt werden.
> ---------------------------------------------------------------
> Command in "0x77c178c0" refers to adress "0x00000000",
can't "read" from memory.
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>
-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595