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

[usmansuleman]

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]

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