[R] RMySQL crash under R 1.7.0, but not 1.6.2

[Prof Brian Ripley]

Did you read the ReadMe in the download area, or the rw-FAQ?  Please do
so, and don't send bug reports on contributed packages you have not
compiled yourself.

Let me give you a hint: the rw1062 version is comnpiled for MySQL 3.x 
and the rw1070 version for MySQL 4.0: AS IT SAYS in the INSTALL.win file.
The client DLLs do not interwork, so there is no way both could work on 
the same machine.

Now, do you understand how annoying you have been?


On Thu, 24 Apr 2003, Philippe Grosjean wrote:

> Hi,
> 
> I was able to connect to a MySQL database (called "zooscan" and with a table
> "serie" under Win XP with R 1.6.2 using:
> 
> > library(DBI)
> > library(RMySQL)
> Warning message:
> DLL attempted to change FPU control word from 8001f to 9001f
> > drv <- dbDriver("MySQL")
> > con <- dbConnect(drv, dbname="zooscan")
> > dbExistsTable(con, "serie")
> [1] TRUE
> > dbDisconnect(con)
> [1] TRUE
> 
> Notice the warning message, but apparently without other incidence.
> 
> Now, when I try this with R 1.7.0, R crashes at the line:
> > con <- dbConnect(drv, dbname="zooscan")
> 
> with the error report containing:
> AppName: rgui.exe  AppVer: 1.70.30416.0   ModName: msvcrt.dll
> ModVer: 7.0.2600.0  Offser: 00033730
> 
> indicating that the error occurs in a call to msvcrt.dll, which is the
> following:
> msvcrt.dll
> Image Base: 0x77c10000   Image Size: 0x00053000
> CheckSum: 0x00055a85     Time Stamp: 0x3b7dfe0e
> Version Information
>  Signature:       feef04bd
>  StrucVer:        000100000
>  FileVer:         (7.0:2600.0)
>  ProdVer:         (6.1:8638.0)
>  FlagMask:        0000003f
>  Flags:           00000000
>  OS:              00040004
>  FileType:        00000001
>  SubType:         00000000
>  FileDate:        00000000:00000000
> 
> I have also:
> > version
> platform i386-pc-mingw32
> arch     i386
> os       mingw32
> system   i386, mingw32
> status
> major    1
> minor    7.0
> year     2003
> month    04
> day      16
> language R
> 
> and:
> C:\Program Files\\mysql\bin>mysqladmin --user=root version
> mysqladmin  Ver 8.23 Distrib 3.23.49, for Win95/Win98 on i32
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
> 
> Server version          3.23.49-max-nt
> Protocol version        10
> Connection              . via named pipe
> UNIX socket             MySQL
> Uptime:                 2 hours 7 min 30 sec
> 
> Threads: 1  Questions: 18  Slow queries: 0  Opens: 6  Flush tables: 1  Open
> tabl
> es: 0 Queries per second avg: 0.002
> 
> 
> 
> 
> Notice also that I've got the same crash in R 1.7.0 under Windows 98 using:
> > ....
> > con <- dbConnect(drv, dbname="zooscan", port=3306)
> 
> I tested this on various machines with either Win XP or Win 98, and it
> consistently succeed in R 1.6.2 and crashes in R 1.7.0. So, it seems that
> some changes made in R itself is involved. By the way, do I have to
> recompile RMySQL for R 1.7.0 (I used the compiled version on CRAN at
> /windows/contrib/1.7).
> Best,
> 
> Philippe Grosjean
> 
> ...........]<(({°<...............<°}))><...............................
>  ) ) ) ) )
> ( ( ( ( (       Dr. Philippe Grosjean
>  ) ) ) ) )
> ( ( ( ( (       LOV, UMR 7093
>  ) ) ) ) )      Station Zoologique
> ( ( ( ( (       Observatoire Océanologique
>  ) ) ) ) )      BP 28
> ( ( ( ( (       06234 Villefranche sur mer cedex
>  ) ) ) ) )      France
> ( ( ( ( (
>  ) ) ) ) )      tel: +33.4.93.76.38.18, fax: +33.4.93.76.38.34
> ( ( ( ( (
>  ) ) ) ) )      e-mail: phgrosjean at sciviews.org
> ( ( ( ( (       SciViews project coordinator (http://www.sciviews.org)
>  ) ) ) ) )
> .......................................................................
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 
> 

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