RMySQL crash under R 1.7.0, but not 1.6.2

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

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