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

[Prof Brian Ripley]

On Thu, 11 Dec 2008, Jeffrey Horner wrote:

> 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).

Not really, especially as Uwe controls the Windows binaries.  (When I did, 
I had a ReadMe with the tested version information.)

For a long time we did not distribute Windows binaries because of these 
version-incompatibility issues.

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

-- 
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