RMySQL crash under R 1.7.0, but not 1.6.2
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