R and RStudio crashing when using DBI

I have a PostgreSQL database on my machine that I routinely connect to through R. I have had no issues reading, writing, or appending data to the database in the past. Recently I upgraded to 4.2.1 and since then any time I try to read data from the database with DBI::dbGetQuery() or to write data using DBI::dbWriteTable(append = TRUE) RStudio crashed.

Any help would be appreciated!

Here is the code I am running:


pg <- dbDriver("PostgreSQL")

db_connection <- dbConnect(pg, dbname = "williampetti", 
                         user = "williampetti", 
                         password = "",
                         host = "localhost", 
                         port = 5432)


# create a table using the mtcars dataset
# there is no issue writing to create a brand new table

                  , name = 'mtcars_test'
                  , value = mtcars
                  , overwrite = TRUE)

# view the fields in the new table
# no error here

DBI::dbListFields(db_connection, 'mtcars_test')

# attempt to read data from the table
# this crashes RStudio, but processes fine when using R directly

                , 'select * from mtcars_test')

# Trying to append the table results in a crash in both RStudio and R directly 

                  , name = 'mtcars_test'
                  , value = mtcars
                  , append = TRUE)

My session info is below:

PostgresSQL 12
RStudio 2022.07.1 (Build 554)

R version 4.2.1 (2022-06-23)
Platform: x86_64-apple-darwin17.0 (64-bit)
Running under: macOS Monterey 12.2.1

Matrix products: default
LAPACK: /Library/Frameworks/R.framework/Versions/4.2/Resources/lib/libRlapack.dylib

Random number generation:
 RNG:     Mersenne-Twister 
 Normal:  Inversion 
 Sample:  Rounding 
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

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

other attached packages:
 [1] RPostgreSQL_0.7-3 RMySQL_0.10.23    DBI_1.1.3         forcats_0.5.1     stringr_1.4.0    
 [6] dplyr_1.0.9       purrr_0.3.4       readr_2.1.2       tidyr_1.2.0       tibble_3.1.8     
[11] ggplot2_3.3.6     tidyverse_1.3.2  

loaded via a namespace (and not attached):
 [1] bitops_1.0-7          fs_1.5.2              usethis_2.1.6         lubridate_1.8.0      
 [5] devtools_2.4.4        webshot_0.5.3         httr_1.4.3            tools_4.2.1          
 [9] profvis_0.3.7         backports_1.4.1       utf8_1.2.2            R6_2.5.1             
[13] colorspace_2.0-3      urlchecker_1.0.1      withr_2.5.0           tidyselect_1.1.2     
[17] prettyunits_1.1.1     processx_3.7.0        curl_4.3.2            compiler_4.2.1       
[21] cli_3.3.0             rvest_1.0.2           xml2_1.3.3            triebeard_0.3.0      
[25] myDBconnections_0.1.0 scales_1.2.0          callr_3.7.1           systemfonts_1.0.4    
[29] commonmark_1.8.0      digest_0.6.29         svglite_2.1.0         rmarkdown_2.14       
[33] base64enc_0.1-3       pkgconfig_2.0.3       htmltools_0.5.3       bpettir_0.1.0        
[37] sessioninfo_1.2.2     dbplyr_2.2.1          fastmap_1.1.0         htmlwidgets_1.5.4    
[41] rlang_1.0.4           readxl_1.4.0          rstudioapi_0.13       shiny_1.7.2          
[45] generics_0.1.3        jsonlite_1.8.0        googlesheets4_1.0.0   RCurl_1.98-1.8       
[49] magrittr_2.0.3        kableExtra_1.3.4      emayili_0.7.10        Rcpp_1.0.9           
[53] munsell_0.5.0         fansi_1.0.3           logger_0.2.2          lifecycle_1.0.1      
[57] stringi_1.7.8         pkgbuild_1.3.1        grid_4.2.1            promises_1.2.0.1     
[61] crayon_1.5.1          miniUI_0.1.1.1        haven_2.5.0           hms_1.1.1            
[65] knitr_1.39            ps_1.7.1              pillar_1.8.0          pkgload_1.3.0        
[69] reprex_2.0.1          glue_1.6.2            evaluate_0.15         remotes_2.4.2        
[73] BiocManager_1.30.18   modelr_0.1.8          urltools_1.7.3        vctrs_0.4.1          
[77] tzdb_0.3.0            httpuv_1.6.5          cellranger_1.1.0      gtable_0.3.0         
[81] assertthat_0.2.1      cachem_1.0.6          xfun_0.31             mime_0.12            
[85] h2o_3.36.1.2          xtable_1.8-4          broom_1.0.0           later_1.3.0          
[89] viridisLite_0.4.0     googledrive_2.0.0     gargle_1.2.0          memoise_2.0.1        
[93] ellipsis_0.3.2       

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.