RStudio crashes when running Sys.getlocale("LC_MESSAGES") but RGui and Rscript work fine

ldlt · 2022-05-10T15:21:14.712Z

I recently installed R 4.2.0 and RStudio 2022.02.2 Build 485 on Windows.

Every time I run the RJDBC::JDBC function in RStudio, the R session aborts with "R encountered a fatal error. The session was terminated". In RGui, the function runs fine.

I debugged the JDBC function and have isolated the problem to Sys.getlocale("LC_MESSAGES"). Without fail, in RStudio, when I run Sys.getlocale("LC_MESSAGES"), the R session aborts.

I have tried:

Installing older versions of RStudio (same error with the last four releases)
Verified that RStudio and RGui are using the same R executable, using R.home()
Restarting the machine
Checking that Sys.getenv() returns (almost) the same results, as suggested in this stackoverflow answer for a similar question

How do I fix this?

nirgrahamuk · 2022-05-10T15:27:29.836Z

What happens when you run Sys.getlocale() i.e. without any params ?

nirgrahamuk · 2022-05-10T15:35:26.909Z

The documentation at ?locale says LC_MESSAGES is invalid for windows, however i can query it without crashing R, i just get an empty string returned.
It makes me wonder about the database driver you have, if its is OS independent or might perhaps be good for unix only where LC_MESSAGES might be relevant ?

P.s. i dont work with databases in R myself hardly ever so im probably not the best person to help you.

ldlt · 2022-05-10T15:42:16.231Z

"LC_COLLATE=English_United States.1252;LC_CTYPE=English_United States.1252;LC_MONETARY=English_United States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252"

Same result in both RStudio and RGui

andresrcs · 2022-05-10T15:42:56.993Z

I think this related to this issue with R 4.2

github.com/rstudio/rstudio

rJava::.jinit() terminates R session of RStudio when using R 4.2.0

opened 11:12AM - 27 Apr 22 UTC

closed 05:53PM - 09 May 22 UTC

gk-crop

bug

When calling rJava::.jinit() in the RStudio console then RStudio shows the dialo…g "R Session Aborted" (R encountered a fatal error). This happens with R 4.2.0, but not with previous R versions. In plain R or when sourcing the command as local job in RStudio there is no error. ### System details RStudio Edition : Desktop RStudio Version : 2022.02.1 Build 461 OS Version : Windows 10 Pro, 21H2, 64 bit R Version : 4.2.0 (2022-04-22 ucrt, x86_64-w64-mingw32/x64) Java Version : 11.0.12 (Temurin - Eclipse Foundation amd64) ### Steps to reproduce the problem Start RStudio execute in the console: ``` install.packages("rJava") # if rJava is not installed yet rJava::.jinit() ``` Alternatives: - create a file `checkJava.R` that contains `rJava::.jinit()` - type `source("checkJava.R")` ### Describe the problem in detail When executing the code or sourcing it, RStudio reports that the R session aborted. ### Describe the behavior you expected R session should not crash. - [x] I have read the guide for [submitting good bug reports](https://github.com/rstudio/rstudio/wiki/Writing-Good-Bug-Reports). - [x] I have installed the latest version of RStudio, and confirmed that the issue still persists. - [x] If I am reporting an RStudio crash, I have included a [diagnostics report](https://support.rstudio.com/hc/en-us/articles/200321257-Running-a-Diagnostics-Report). - [x] I have done my best to include a minimal, self-contained set of instructions for consistently reproducing the issue. [diagnostics-report.txt](https://github.com/rstudio/rstudio/files/8571445/diagnostics-report.txt)

You can try with the patched version of R 4.2

ldlt · 2022-05-10T15:57:53.764Z

Thank you! That did it. Next time I know to search github directly instead of just googling.

system · 2022-05-17T15:58:18.875Z

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.