作者dreler1 (....)
看板R_Language
标题[问题] RMySQL in a function不正常
时间Wed Jan 9 00:49:44 2019
[问题类型]:
程式谘询(我想用R 做某件事情，但是我不知道要怎麽用R 写出来)
[软体熟悉度]:
开发者(有撰写R 的套件经验)
[问题叙述]:
我使用RMySQL 写了一个回圈
其中已经用了
all_cons <- dbListConnections(MySQL())
for (con in all_cons)
dbDisconnect(con)
去关闭connection
如果我不做成function跑起来没问题
我做成function 之後
Error in .local(dbObj, ...) :
internal error in RS_DBI_getConnection: corrupt connection handle
In addition: There were 50 or more warnings (use warnings() to see the first
50)
我尝试把找出错误发生的地点 (ERRORfile)
但是他整个loop其实跑完了
write("finished all data",ERRORfile,append = TRUE)
这条都跑完了
详情请见
http://0rz.tw/ooC9n
[环境叙述]:
> sessionInfo()
R version 3.4.3 (2017-11-30)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
Matrix products: default
locale:
[1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United
States.1252 LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C LC_TIME=English_United
States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] MOVESdata_0.0.0.9000 tidyr_0.8.2 stringi_1.2.4
readr_1.1.1 readxl_1.1.0
[6] RMySQL_0.10.15 DBI_1.0.0 roxygen2_6.1.1
usethis_1.4.0 devtools_2.0.1
loaded via a namespace (and not attached):
[1] Rcpp_1.0.0 pillar_1.3.0 compiler_3.4.3 cellranger_1.1.0
prettyunits_1.0.2 base64enc_0.1-3
[7] remotes_2.0.2 tools_3.4.3 testthat_2.0.1 digest_0.6.18
pkgbuild_1.0.2 pkgload_1.0.2
[13] tibble_1.4.2 memoise_1.1.0 pkgconfig_2.0.2 rlang_0.3.0.1
cli_1.0.1 rstudioapi_0.8
[19] commonmark_1.7 yaml_2.2.0 withr_2.1.2 stringr_1.3.1
xml2_1.2.0 hms_0.4.2
[25] desc_1.2.0 fs_1.2.6 rprojroot_1.3-2 glue_1.3.0
R6_2.3.0 processx_3.2.1
[31] sessioninfo_1.1.1 callr_3.0.0 purrr_0.2.5 magrittr_1.5
backports_1.1.3 ps_1.2.1
[37] assertthat_0.2.0 crayon_1.3.4
谢谢大家
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 149.168.204.10
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/R_Language/M.1546966187.A.375.html
※ 编辑: dreler1 (149.168.204.10), 01/09/2019 00:52:11