Hello, we've recently built a new RedHat 8 server and installed R 4.3.1 and RStudio Workbench and pro ODBC drivers. Our script is connecting to a Snowflake database instance and crashed when it tried to get table data with error below. We tried with R 4.2.3 and had the same error. I'm wondering if anyone has faced this issue before? The same script is working the similar server with CentOS 7 and R 4.2.3. Thanks, in advance.
OS: RedHat 8 RStudio Pro version: 2023.06.1 Build 524.pro1 Posit Professional Drivers version: 2023.05.0 R version: 4.3.1/4.2.3
The code that crashes R.
DBI::dbGetQuery(db_conn, "SELECT * FROM TABLE_A ")
When I tried to limit the results to under 100 rows, it ran fine.
Traceback:
1: result_fetch(res@ptr, n)
2: dbFetch(rs, n = n, ...)
3: dbFetch(rs, n = n, ...)
4: .local(conn, statement, ...)
5: DBI::dbGetQuery(db_conn, "SELECT * FROM TABLE_A ")
6: result_fetch(res@ptr, n)::dbFetch(rs, n = n, ...)(db_conn, "SELECT * FROM TABLE_A ")
7: res@ptr
8: eval(ei, envir)
9: withVisible(eval(ei, envir))
10:
Traceback:
1: source(paste0(libroot, "/odbc_iris.R"))
An irrecoverable exception occurred. R is aborting now ...
result_fetch(res@ptr, n)
2: dbFetch(rs, n = n, ...)
3: dbFetch(rs, n = n, ...)
4: .local(conn, statement, ...)
5: DBI::dbGetQuery(db_conn, "SELECT * FROM TABLE_A ")
6: DBI::dbGetQuery(db_conn, "SELECT * FROM TABLE_A ")
7: eval(ei, envir)
8: eval(ei, envir)
9: withVisible(eval(ei, envir))
10: source(paste0(libroot, "/odbc_iris.R"))
An irrecoverable exception occurred. R is aborting now ...