[R-sig-DB] RSQLite memory leak?

[Seth Falcon]

Hi Bill,

Bill Northcott <w.northcott using unsw.edu.au> writes:

> I am using RSQLite 0.4-19 with R 2.4.1 on MacOS X 10.4.8.  Both R and  
> RSQLite are compiled from source using Apple's compilers.
>
> The following simple script:
> library(DBI)
> library(RSQLite)
>
> drv <- dbDriver("SQLite")
> con <- dbConnect(drv,trad_db)
>
> dbDisconnect(con)
> dbUnloadDriver(drv)
>
> gives the output:
> Warning message:
> RS-DBI driver warning: (mgr->drvData was not freed (some memory leaked))
>
> This seems to be a meaningful warning as when I run a real script  
> with the same beginning and end a number of time R seems to get into  
> trouble.

Thanks for the report.  I can reproduce the warning and will see if I
can find out what's going on.  

In the meantime, a workaround might be to simply not unload the
driver.  I'm not sure why you would want to unload and reload it in
the first place -- you can reuse the drv object for different
connections.

+ seth