[R] is this an R bug or a DBI bug?

Anthony Damico ajdamico at gmail.com
Sun Feb 28 00:20:35 CET 2016


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]]



More information about the R-help mailing list