r-尝试通过RMariaDB连接do MySQL数据库时出现RSession致命错误



最近,我在Windows 10上的R在尝试使用RMariaDB连接到MySQL数据库时出现故障。使用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.

执行命令前的会话信息如下:

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:jenkinsworkspaceidewindows-v1.2srccppsessionhttpSessionHttpConnectionImpl.hpp:111; LOGGED FROM: void __cdecl rstudio::session::HttpConnectionImpl<class rstudio_boost::asio::ip::tcp>::sendResponse(const class rstudio::core::http::Response &) c:jenkinsworkspaceidewindows-v1.2srccppsessionhttpSessionHttpConnectionImpl.hpp:116

因此,在R之外似乎存在一些问题,可能与防火墙或防病毒软件有关。因此,我已将RStudio和列表中的所有RSessions添加到Windows Defender";允许的应用程序";列出并尝试禁用Windows Defender和Symantec Endpoint Protection。然而,错误不断发生。任何建议都将不胜感激。

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

相关内容

最新更新