tested this out on 3.2.0, 3.2.1, and 3.2.2 -- only happens on 3.2.3, so i
assume it was an R bug not a DBI bug. submitted here:
https://bugs.r-project.org/bugzilla/show_bug.cgi?id=16734
On Sat, Feb 27, 2016 at 6:20 PM, Anthony Damico <ajdamico at gmail.com>
wrote:
> this happens with both SQLite and MonetDBLite, so i assume it is not an
> RSQLite bug.
>
> notice the gc() in the no-crash version..
>
> thanks
>
>
> # initiate R with "C:\Program
Files\R\R-3.2.3\bin\x64\Rterm.exe"
> --max-mem-size=35M
> library(RSQLite)
> db <- dbConnect( SQLite() )
> for( i in 1:1000 ) { dbWriteTable( db , 'x' , mtcars , append =
TRUE )
> }
> # CRASH
>
>
> # initiate R with "C:\Program
Files\R\R-3.2.3\bin\x64\Rterm.exe"
> --max-mem-size=35M
> library(RSQLite)
> db <- dbConnect( SQLite() )
> for( i in 1:1000 ) { dbWriteTable( db , 'x' , mtcars , append =
TRUE )
> ; gc() }
> # no crash
>
>
>
>
> ===============>
>
> > sessionInfo()
> R version 3.2.3 (2015-12-10)
> Platform: x86_64-w64-mingw32/x64 (64-bit)
> Running under: Windows 7 x64 (build 7601) Service Pack 1
>
> locale:
> [1] LC_COLLATE=English_United States.1252
> [2] LC_CTYPE=English_United States.1252
> [3] LC_MONETARY=English_United States.1252
> [4] LC_NUMERIC=C
> [5] LC_TIME=English_United States.1252
>
> attached base packages:
> [1] stats graphics grDevices utils datasets methods base
>
> other attached packages:
> [1] RSQLite_1.0.0 DBI_0.3.1
>
>
[[alternative HTML version deleted]]