[R-sig-DB] [R] RMySQL crashes R

[Krzysztof Sakrejda]

Hi,

I've had great experiences with the RMySQL library and MySQL from windows XP
and Gentoo/Linux environments with R-2.7.2 so I'm happy to test solutions or
to try to find out more about the problem.  I've (unfortunately) had the
same (previous report appended) experience with a new install of Vista on a
Vaio/VGN-NS255J laptop, running R (I checked 2.7.2 and 2.8 both exhibit the
same behavior).  My MySQL binaries are from a fresh install of MySQL server
(32bit) 5.1. The MySQL server is separate and plays well with other
Windows/Linux R installations.

The download/install is clean, I can connect and run dbGetQuery(conn, "SHOW
TABLES;") at least a few times, but when I run a query against any table,
even one which returns limited data (conn, "SELECT * FROM blah LIMIT 6;")
Vista says "there has been a problem with R and it needs to close"
(paraphrased).  The message is completely uninformative.  It then proceeds
to close R with no further comment.  I will let you know if I find any more
information but I don't know if there are better error logs somewhere on
Vista.... any suggestions would be appreciated in dealing with this.

Best regards,

Krzysztof Sakrejda-Leavitt

-----------------------------------------------
Krzysztof Sakrejda-Leavitt

Organismic and Evolutionary Biology
University of Massachusetts, Amherst
319 Morrill Science Center South
611 N. Pleasant Street
Amherst, MA 01003

work #: 413-325-6555
email: sakrejda using nsm.umass.edu
-----------------------------------------------

On Mon, Jan 12, 2009 at 1:02 PM, auburneconomics
<nathan_forczyk using yahoo.com>wrote:

>
> This is similar to another current post about RMySQL crashing R, except on
> the other post it crashed on connection to the database.  I can
> successfully
> connect, and even can do dbListTables().  But, if I send a query or
> anything
> to actually see the data, R crashes to desktop.
>
> I have tried this on two computers, one Vista, one XP.  Both crashed.  I am
> running 2.8.1, and am using the correct version of DBI and RMySQL.  They
> are
> both loaded with the library() function beforehand.  Versions of MySQL that
> it was tried are 5.1 and 6.0a.
>
> I have searched on the internet and haven't found any answers, and would be
> grateful for any help,
>
> Nathan Forczyk
> Auburn University
> --
> View this message in context:
> http://www.nabble.com/RMySQL-crashes-R-tp21419908p21419908.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help using r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



--

	[[alternative HTML version deleted]]