[R-sig-DB] R crashes querying 64-bit MySQL

[Michael Styer]

Hello,

I've installed RMySQL on Windows Server 2008 64-bit, along with a 64-bit
MySQL 5.0 server and the 32-bit MySQL 5.1 client libraries. In testing
the installation, I find that the R GUI crashes when trying to execute 
simple queries. I have this table in my database:

   mysql> select * from bls_regions;
   +---------------+-----------------+
   | bls_region_id | bls_region_name |
   +---------------+-----------------+
   |             1 | Northeast       |
   |             2 | South           |
   |             3 | Midwest         |
   |             4 | West            |
   |             5 | Other           |
   +---------------+-----------------+

I set up the database connection as follows:

   library(RMySQL)
   m <- dbDriver("MySQL")
   conn <- dbConnect(m, username=user,
                        password=pass,
                        host=host,
                        dbname=dbname)

This query works:

   result <- dbGetQuery("SELECT 1")

But this query causes R to crash:

   result <- dbGetQuery("SELECT * FROM bls_regions")

By "crash" I mean, I get a Windows pop-up that says "R for Windows GUI
Front End has stopped working.", and my only option is to click the
button to close the program.

No other error message is produced in R. In the server application log,
this message appears:

   Faulting application Rgui.exe, version 2.80.46754.0, time stamp
   0x48fc7ccf, faulting module msvcrt.dll, version 7.0.6001.18000, time
   stamp 0x4791a727, exception code 0xc0000005, fault offset 0x0000cb8b,
   process id 0x6dc, application start time 0x01c96524bd51815a

If I understand that message, the error is occurring in the C runtime 
library, but I don't think that says very much. I can't find any other 
error messages that are generated.

Is there somewhere else I can look for information about what might be 
causing the problem? Any suggestions as to how I might be able to debug 
this issue? I'm at a loss myself but would be happy to pursue any 
suggestions.

Thanks for your time.

Michael