search

r-dbi / RMySQL

Legacy DBI interface for MySQL
http://cran.r-project.org/package=RMySQL
208 stars 111 forks source link

R abends: dbWriteTable - new table with overwrite=T, append=F #187

Open usmansuleman opened 7 years ago

usmansuleman commented 7 years ago

I was creating a new table in MySQL database. Without too much thought, I tried to create the table with dbWriteTable and used overwrite = TRUE, append = FALSE. The table got created but R got tied into all kinds of knots ... On my RStudioServer (free ed), ... RStudio IDE would just hang. On the log (kept in /var/log/syslog), I would see a message: Mar 23 03:02:25 ip-172-30-0-237 rsession-username[4500]: ERROR session hadabend; LOGGED FROM: rstudio::core::Error {anonymous}:: rInit(const rstudio::r::session:: RInitInfo&) /home/ubuntu/rstudio/src/cpp/session/SessionMain.cpp:1934 Scratched my head ... Finally figured out and took out the overwrite and append clauses from dbWriteTable. All works fine now.

krlmlr commented 7 years ago

Thanks. Have you installed RMySQL from CRAN or from GitHub?