Skip to content

[Win] Hangup RGui with RMySQL (PR#13453)

2 messages · apfel.schmied at emaildienst.de, Brian Ripley

Original
apfel.schmied at emaildienst.de
# 
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.
Brian Ripley
# 
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: