RSession通过RMariaDB连接do MySQL数据库时发生的致命错误

Question

最近，我在Windows 10上的R在试图使用MySQL连接到RMariaDB数据库时崩溃了。在使用RMySQL驱动程序时也会发生同样的错误。刚才出现了错误。大约一年前，完全相同的代码运行得完美无缺。

我使用以下代码：

mydb <- DBI::dbConnect(drv     = RMariaDB::MariaDB(),
                  default.file = "path/rds-combined-ca-bundle.pem",
                  username     = "some_username", 
                  password     = "some_password", 
                  host         = "some_host", 
                  port         = 3306)

第二次运行dbConnect命令时，R会崩溃，并出现以下错误：

RSession Aborted
R encountered a fatal error.
The session was terminated.

执行该命令之前的sessionInfo如下所示：

R version 3.6.1 (2019-07-05)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 17134)

Matrix products: default

locale:
[1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United States.1252   
[3] LC_MONETARY=English_United States.1252 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] data.table_1.12.8 RMariaDB_1.0.9   

loaded via a namespace (and not attached):
 [1] Rcpp_1.0.3       zeallot_0.1.0    crayon_1.3.4     checkpoint_0.4.7 DBI_1.1.0        backports_1.1.5 
 [7] pillar_1.4.3     rlang_0.4.2      vctrs_0.2.1      tools_3.6.1      bit64_0.9-7      bit_1.1-15.2    
[13] hms_0.5.2        compiler_3.6.1   pkgconfig_2.0.3  tibble_2.1.3

我的RStudio诊断文件显示了以下问题：

17 Jul 2020 22:27:28 [rsession-XXX] ERROR system error 10053 (An established connection was aborted by the software in your host machine) [request-uri=/events/get_events]; OCCURRED AT: void __cdecl rstudio::session::HttpConnectionImpl<class rstudio_boost::asio::ip::tcp>::sendResponse(const class rstudio::core::http::Response &) c:\jenkins\workspace\ide\windows-v1.2\src\cpp\session\http\SessionHttpConnectionImpl.hpp:111; LOGGED FROM: void __cdecl rstudio::session::HttpConnectionImpl<class rstudio_boost::asio::ip::tcp>::sendResponse(const class rstudio::core::http::Response &) c:\jenkins\workspace\ide\windows-v1.2\src\cpp\session\http\SessionHttpConnectionImpl.hpp:116

因此，似乎在R之外有一些问题，可能是防火墙或反病毒软件。因此，我将RStudio和列表中的所有RSessions添加到Windows“允许应用程序”列表中，并尝试禁用Windows和Symantec保护。但是，错误不断发生。如有任何建议，将不胜感激。

Answer 1

default.file是一个配置文件，而不是证书。