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

[Philippe Grosjean]

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