[R] RMySQL works inside function, but prints Error output when executed outside a function

Brent yhbrent at yahoo.com
Sat Feb 14 23:06:02 CET 2015


On my computer, if I execute this R code inside the console of Rgui.exe

    execInsideFunction = function() {
        dbc = dbcLocal
        conn <- dbConnect(MySQL(), host = dbc$host, dbname = "xxx", user=dbc$user, password=dbc$password)
        dbSendQuery(conn, "delete from yyy")
        dbDisconnect(conn)
    }
    execInsideFunction()

It seems to work fine, printing

    [1] TRUE

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

However, if I copy the body of that function

    dbc = dbcLocal
    conn <- dbConnect(MySQL(), host = dbc$host, dbname = "goral", user=dbc$user, password=dbc$password)
    dbSendQuery(conn, "delete from archive_batches")
    dbDisconnect(conn)

and paste it the console to execute it, then it prints the Error output

    Error: evaluation nested too deeply: infinite recursion / options(expressions=)?
    Error during wrapup: evaluation nested too deeply: infinite recursion / options(expressions=)?

What the heck is happening?!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I note that that Error output appears to be bogus: the database action (delete all rows from a table above) is actually carried out.  Indeed, the 2nd line ("Error during wrapup") indicates that the error only occurred later on.

Still, it is disturbing.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Note: I am using Revolution R Open 8.01-Beta 64 bit.

Below is the output when I execute sessionInfo():

    R version 3.1.2 (2014-10-31)

    Platform: x86_64-w64-mingw32/x64 (64-bit)

    locale:
    [1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United States.1252    LC_MONETARY=English_United States.1252 LC_NUMERIC=C               LC_TIME=English_United States.1252   

    attached base packages:
    [1] grDevices datasets  tcltk     stats     tools     utils     graphics  methods   base    

    other attached packages:
    [1] timeDate_3011.99 stringr_0.6.2    RODBC_1.3-10     quantmod_0.4-3   quadprog_1.5-5   gWidgets_0.0-54  debug_1.3.1      goralSpeedUp_1.0 RMySQL_0.9-3     DBI_0.3.1        bitops_1.0-6     caTools_1.17.1   lattice_0.20-29  TTR_0.22-0       xts_0.9-7        zoo_1.7-11       Rcpp_0.11.3      mvbutils_2.7.4.1
    [19] Matrix_1.1-4     inline_0.3.13  

    loaded via a namespace (and not attached):
    [1] grid_3.1.2



	[[alternative HTML version deleted]]



More information about the R-help mailing list