最近,我在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是一个配置文件,而不是证书。