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

[Jeffrey Horner]

Prof Brian Ripley wrote on 12/11/2008 07:53 AM:
> 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.

Do you have a recommendation for me as the maintainer going forward for 
supporting current and future MySQL releases? It seems like Peter's case 
won't be last as MySQL 5.1.30 is now the recommended download (at least 
when you click the "Download" button on mysql.com).

Jeff
-- 
http://biostat.mc.vanderbilt.edu/JeffreyHorner