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 <ajdam...@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]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
