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

[Gabor Grothendieck]

There is a SystemRequirements: line that can be put into the DESCRIPTION
file which can then be checked by your package via:

packageDescription("Ryacas")$SystemRequirements

On Thu, Dec 11, 2008 at 10:17 AM, Jeffrey Horner
<jeff.horner using vanderbilt.edu> 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).
>
> 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
>