From apfel.schmied at emaildienst.de  Mon Jan 19 12:35:05 2009
From: apfel.schmied at emaildienst.de (apfel.schmied at emaildienst.de)
Date: Mon, 19 Jan 2009 12:35:05 +0100 (CET)
Subject: [Rd] [Win] Hangup RGui with RMySQL (PR#13453)
Message-ID: <20090119113505.47D26282EFC1@mail.pubhealth.ku.dk>

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.



[Rd] [Win] Hangup RGui with RMySQL (PR#13453)
apfel.schmied at emaildienst.de