[R-sig-DB] [R] RMySQL Keeps crashing

[Prof Brian Ripley]

On Thu, 11 Dec 2008, Jeffrey Horner wrote:

> Peter Benjamin Volk wrote:
>> Hi Jeff,
>>>> Hi all,
>>>> 
>>>> I am working on MySQL 5.0 with RMySQL 0.7-2. All commands except for
>>>> Select
>>>> statements work. I can create tables, Truncate then etc. When I issue a
>>>> Select statement with dbSendQuery containing more than one column in the
>>>> selection then R crashes. I have been looking around but could not
>>>> find any
>>>> solution to this. Does anyone knows whats wrong?
>>> Can you send the output of sessionInfo() and also a small example that
>>> reproduces the crash? It would be nice to know which OS you are
>>> working on.
>> R version 2.8.0 (2008-10-20)
>> i386-pc-mingw32
>> 
>> locale:
>> LC_COLLATE=German_Germany.1252;LC_CTYPE=German_Germany.1252;LC_MONETARY=German_Germany.1252;LC_NUMERIC=C;LC_TIME=German_Germany.1252
>> 
>> attached base packages:
>> [1] stats     graphics  grDevices utils     datasets  methods   base 
>> other attached packages:
>> [1] MASS_7.2-44     RMySQL_0.7-2    DBI_0.2-4       lattice_0.17-17
>> 
>> loaded via a namespace (and not attached):
>> [1] grid_2.8.0
>> 
>> 
>> I'm Working on Windows XP with SP3. The MySQL Server resides on an
>> Ubuntu Server. The failure also happens when I have the server on the
>> same system as R.
>> 
>
> Okay, what's the output of the following R command readRegistry:
>
> readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
>
> I have a suspicion it's a version mismatch between the version of MySQL 
> client library with which the package was compiled and the version installed 
> and loaded by RMySQL on your machine. Your output will give us the latter 
> version, unless you have more than one installed.

More to the point, certain MySQL Windows releases have client DLLs that 
are known to crash RMySQL.  (It would be perverse if the API had changed 
at patch levels within the same MySQL version, 5.0, although it has 
changed between versions.)  As far as I recall, the deficient patch 
releases are within the range 5.0.21 to 5.0.44: I am pretty sure that 
5.0.45 and later (including 5.0.67) are unaffected.

Uwe Ligges and I built and tested RMySQL against 5.0.67, so the 
recommendation is to update your Windows client to that version.

>
> Jeff
> -- 
> http://biostat.mc.vanderbilt.edu/JeffreyHorner
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

-- 
Brian D. Ripley,                  ripley using 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