From ripley at stats.ox.ac.uk  Mon Jan 19 17:35:38 2009
From: ripley at stats.ox.ac.uk (Prof Brian Ripley)
Date: Mon, 19 Jan 2009 16:35:38 +0000 (GMT)
Subject: [Rd] [Win] Hangup RGui with RMySQL (PR#13453)
In-Reply-To: <20090119113505.47D26282EFC1@mail.pubhealth.ku.dk>
References: <20090119113505.47D26282EFC1@mail.pubhealth.ku.dk>
Message-ID: <alpine.OSX.1.00.0901191633070.89990@tystie.local>

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


[Rd] [Win] Hangup RGui with RMySQL (PR#13453)
Prof Brian Ripley