-
Notifications
You must be signed in to change notification settings - Fork 107
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Crash when querying non-existent table #493
Comments
I've been having this same issue with Postgres and SQL server connections. Anytime an invalid query is sent to the database it terminates the R session and closes the project. E.g. If I forget to unlist a character vector and try to pass it to a query or reference a non-existent table. |
#bump. Anyone able to take a look at this? It really stinks to have waited for a bunch of queries and preprocessing to run, then to have the session completely crash due to a typo and have to start over :( |
We had this exact same problem with odbc 1.3.3. Our organisation is currently locked into an older version of R (3.6.3) on Windows and it came down to if we installed the odbc package from the win binary which had been compiled at R 4.2 we had the problem, but if installed odbc 1.3.3 from source then no problem - i.e. get errors, not R crashes querying non-existent tables. |
I do have the same issue. By choosing a different R Version this issue does not occoure any more. Working Version: Not Working Versions: My system: |
I had the same issue. After quite a lot of time debugging, I updated the dependencies of odbc: i.e. "rlang", "vctrs", "Rcpp" and "cli". And this has fixed the issue. I'm going to guess that it was Rcpp not being up to date that was causing R to have a conniption
|
I'm not able to reproduce on R 4.3.1 + odbc 1.4.1. As a more recent commenter found that updating package dependencies did the trick, I'm going to go ahead and close. |
Issue Description and Expected Result
I think this is essentially #386, but the solution there was a higher
odbc
version (1.2.2 -> 1.2.3, but I'm on 1.3.3). I kept getting RStudio crashes when trying to query an MS SQL database, finally figuring out I'd remembered the name of the db incorrectly.Database
It's an Azure hosted Microsoft SQL databse.
Reproducible Example
I can't share the real example, and took some time to try and find a public SQL db for testing purposes, but 10min of googling just pointed me to websites oriented toward query training, or databases one can unpack locally. I'm too busy for that right now. Hopefully someone can reproduce on their own db.
That crashes RStudio as well as my R terminal.
Thanks for taking a look.
The text was updated successfully, but these errors were encountered: