Dear All,
I haven't seen any further comments about the problem that John Marsland
first noted and that I also have:
> library(DBI)
> library(RMySQL)
Warning message:
DLL attempted to change FPU control word from 8001f to 9001f
> mgr <- dbDriver("MySQL")
> con <- dbConnect(mgr, host="localhost", dbname="marketing")
upon which R dies...
Dr. Mingw says:
Rgui.exe caused an Access Violation at location 77c13730 in module
msvcrt.dll Reading from location 00000000.
Registers:
eax=10e501a0 ebx=00000000 ecx=00000000 edx=10e51fe0 esi=00000000 edi=003e3d08
eip=77c13730 esp=0022d5ac ebp=0022d7f8 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246
Call stack:
77C13730 msvcrt.dll:77C13730 strlen
004C799D R.dll:004C799D do_dotcall
004DA35F R.dll:004DA35F Rf_eval
004DC2D5 R.dll:004DC2D5 do_set
004DA3C8 R.dll:004DA3C8 Rf_eval
004DBA52 R.dll:004DBA52 do_begin
004DA3C8 R.dll:004DA3C8 Rf_eval
004DA6B5 R.dll:004DA6B5 Rf_applyClosure
004DA1D7 R.dll:004DA1D7 Rf_eval
004DA949 R.dll:004DA949 Rf_applyClosure
004DAC5A R.dll:004DAC5A R_execMethod
10DA2B43 methods.dll:10DA2B43 R_standardGeneric
0050C059 R.dll:0050C059 do_standardGeneric
004DA35F R.dll:004DA35F Rf_eval
004DA0F6 R.dll:004DA0F6 Rf_eval
004DA03E R.dll:004DA03E Rf_eval
004DA0F6 R.dll:004DA0F6 Rf_eval
004DA03E R.dll:004DA03E Rf_eval
004DA0F6 R.dll:004DA0F6 Rf_eval
004DA03E R.dll:004DA03E Rf_eval
004DC4BB R.dll:004DC4BB Rf_evalList
004DA2F0 R.dll:004DA2F0 Rf_eval
004DD2F3 R.dll:004DD2F3 Rf_DispatchOrEval
0056941B R.dll:0056941B do_subset2
004DA3C8 R.dll:004DA3C8 Rf_eval
004DA6B5 R.dll:004DA6B5 Rf_applyClosure
004DA1D7 R.dll:004DA1D7 Rf_eval
004DC2D5 R.dll:004DC2D5 do_set
004DA3C8 R.dll:004DA3C8 Rf_eval
004DBA52 R.dll:004DBA52 do_begin
004DA3C8 R.dll:004DA3C8 Rf_eval
004DA6B5 R.dll:004DA6B5 Rf_applyClosure
004DA1D7 R.dll:004DA1D7 Rf_eval
004DB0DC R.dll:004DB0DC do_if
004DA3C8 R.dll:004DA3C8 Rf_eval
004DB427 R.dll:004DB427 do_for
004DA3C8 R.dll:004DA3C8 Rf_eval
004DBA52 R.dll:004DBA52 do_begin
004DA3C8 R.dll:004DA3C8 Rf_eval
004DA3C8 R.dll:004DA3C8 Rf_eval
004DBA52 R.dll:004DBA52 do_begin
004DA3C8 R.dll:004DA3C8 Rf_eval
004DA6B5 R.dll:004DA6B5 Rf_applyClosure
004DA1D7 R.dll:004DA1D7 Rf_eval
004DA6B5 R.dll:004DA6B5 Rf_applyClosure
004DA1D7 R.dll:004DA1D7 Rf_eval
004DC2D5 R.dll:004DC2D5 do_set
004DA3C8 R.dll:004DA3C8 Rf_eval
004F996E R.dll:004F996E Rf_ReplIteration
004F9F72 R.dll:004F9F72 Rf_ReplIteration
004FAA76 R.dll:004FAA76 run_Rmainloop
004014D7 Rgui.exe:004014D7
0040141E Rgui.exe:0040141E
00401603 Rgui.exe:00401603
00401165 Rgui.exe:00401165
00401013 Rgui.exe:00401013
77E5EB69 kernel32.dll:77E5EB69 CreateProcessInternalW
But then, again, I never did speak Chinese...
Thanks for your help.
David Tudor
-------------- next part --------------
---
abrupt end to R
4 messages · David Tudor, Brian Ripley, Duncan Murdoch +1 more
Please do use an informative subject line. The comment was that he was using code compiled against MySQL 4.0.x on MySQL 3.2.x, and had not read the readmes. A further comment is that you are asked *not* to report problems with pre-compiled packages on R-help, but to re-compile them yourself. He had ignored that, and I suspect you have too.
On Thu, 15 May 2003, David Tudor wrote:
I haven't seen any further comments about the problem that John Marsland first noted and that I also have:
> library(DBI) > library(RMySQL)
Warning message: DLL attempted to change FPU control word from 8001f to 9001f
> mgr <- dbDriver("MySQL")
> con <- dbConnect(mgr, host="localhost", dbname="marketing")
upon which R dies...
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
On Thu, 15 May 2003 00:27:26 +0200, you wrote:
Dear All, I haven't seen any further comments about the problem that John Marsland first noted and that I also have:
library(DBI) library(RMySQL)
Warning message: DLL attempted to change FPU control word from 8001f to 9001f
It's a bad idea to ignore warnings! This says that there's a problem with the DLL that RMySQL is loading. It is attempting to change the rounding behaviour, and R is fighting back. I don't know if that would cause the error below, but it's a possibility.
mgr <- dbDriver("MySQL")
con <- dbConnect(mgr, host="localhost", dbname="marketing")
upon which R dies... Dr. Mingw says: Rgui.exe caused an Access Violation at location 77c13730 in module msvcrt.dll Reading from location 00000000. Registers: eax=10e501a0 ebx=00000000 ecx=00000000 edx=10e51fe0 esi=00000000 edi=003e3d08 eip=77c13730 esp=0022d5ac ebp=0022d7f8 iopl=0 nv up ei pl zr na po nc cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246 Call stack: 77C13730 msvcrt.dll:77C13730 strlen 004C799D R.dll:004C799D do_dotcall
... I've cc'd this to the RMySQL maintainer David James; David J, if you don't know what I'm talking about regarding rounding, I'd be happy to expand on it. Duncan Murdoch
On Thursday 15 May 2003 14:43, Duncan Murdoch wrote:
On Thu, 15 May 2003 00:27:26 +0200, you wrote:
Dear All, I haven't seen any further comments about the problem that John Marsland first noted and that I also have:
library(DBI) library(RMySQL)
Warning message: DLL attempted to change FPU control word from 8001f to 9001f
It's a bad idea to ignore warnings! This says that there's a problem
In general, I agree ...of course. However, I have a similar experience even without warnings:
library(DBI)
library(RMySQL)
handle<-dbDriver("MySQL")
handle
<MySQLDriver:(958)>
con<-dbConnect(handle, dbname="xxxx", host="tango", user="aa")
Segmentation fault
The actual dbname has been replaced by "xxxx", but it does not matter
what I write there; the outcome is the same. Also, changing the host="tango"
to host="localhost" or to the full computer name makes no difference.
The environment is as follows: _
platform i686-pc-linux-gnu
arch i686
os linux-gnu
system i686, linux-gnu
status
major 1
minor 6.1
year 2002
month 11
day 01
language R
DBI version 0.1-4
RMySQL version 0.5-0
[tango:aa:~/SW] mysql --version
mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686)
The fanny thing is that my students can connect to my computer and use
the database from the computer lab (with R 1.6.1 for Windows) without problems!
Regards,
Adelchi Azzalini
Adelchi Azzalini <azzalini at stat.unipd.it> Dipart.Scienze Statistiche, Universit? di Padova, Italia http://azzalini.stat.unipd.it/