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 in 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
view_data <- tbl(cc_dw, in_schema(db$schema, "VW_PERSON")) %>%
collect()
The error:
*** caught segfault ***
address (nil), cause 'memory not mapped'
Traceback:
1: result_fetch(res@ptr, n)
2: dbFetch(res, n = n)
3: dbFetch(res, n = n)
4: tryCatchList(expr, classes, parentenv, handlers)
5: tryCatch({ out <- dbFetch(res, n = n) if (warn_incomplete) { res_warn_incomplete(res, "n = Inf") }}, finally = { dbClearResult(res)})
6: db_collect.DBIConnection(x$src$con, sql, n = n, warn_incomplete = warn_incomplete)
7: db_collect(x$src$con, sql, n = n, warn_incomplete = warn_incomplete)
8: doTryCatch(return(expr), name, parentenv, handler)
9: tryCatchOne(expr, names, parentenv, handlers[[1L]])
10: tryCatchList(expr, classes, parentenv, handlers)
11: tryCatch(out <- db_collect(x$src$con, sql, n = n, warn_incomplete = warn_incomplete), error = function(cnd) { cli_abort("Failed to collect lazy table.", parent = cnd) })
12: collect.tbl_sql(.)
13: collect(.)
14: tbl(cc_dw, in_schema(db$schema, "VW_PERSON")) %>% collect()
An irrecoverable exception occurred. R is aborting now ...
*** caught segfault ***
address (nil), cause 'memory not mapped'
*** caught segfault ***
address (nil), cause 'memory not mapped'
Traceback:
1: result_fetch(res@ptr, n)
2: dbFetch(res, n = n)
3: dbFetch(res, n = n)
4: tryCatchList(expr, classes, parentenv, handlers)
5: tryCatch({ out <- dbFetch(res, n = n) if (warn_incomplete) { res_warn_incomplete(res, "n = Inf") }}, finally = { dbClearResult(res)})
6: db_collect.DBIConnection(x$src$con, sql, n = n, warn_incomplete = warn_incomplete)
7: db_collect(x$src$con, sql, n = n, warn_incomplete = warn_incomplete)
8: doTryCatch(return(expr), name, parentenv, handler)
Traceback:
1: result_fetch(res@ptr, n)
2: dbFetch(res, n = n)
3: dbFetch(res, n = n)
4: tryCatchList(expr, classes, parentenv, handlers)
5: tryCatch({ out <- dbFetch(res, n = n) 9: tryCatchOne(expr, names, parentenv, handlers[[1L]])
10: tryCatchList(expr, classes, parentenv, handlers)
11: tryCatch(out <- db_collect(x$src$con, sql, n = n, warn_incomplete = warn_incomplete), error = function(cnd) { cli_abort("Failed to collect lazy table.", parent = cnd) })
12: collect.tbl_sql(.)
13: collect(.)
if (warn_incomplete) { res_warn_incomplete(res, "n = Inf") }}, finally = { dbClearResult(res)})
6: db_collect.DBIConnection(x$src$con, sql, n = n, warn_incomplete = warn_incomplete)14: tbl(cc_dw, in_schema(db$schema, "VW_PERSON")) %>% collect()
An irrecoverable exception occurred. R is aborting now ...
7: db_collect(x$src$con, sql, n = n, warn_incomplete = warn_incomplete)
8: doTryCatch(return(expr), name, parentenv, handler)
9: tryCatchOne(expr, names, parentenv, handlers[[1L]])
10: tryCatchList(expr, classes, parentenv, handlers)
11: tryCatch(out <- db_collect(x$src$con, sql, n = n, warn_incomplete = warn_incomplete), error = function(cnd) { cli_abort("Failed to collect lazy table.", parent = cnd) })
12: collect.tbl_sql(.)
13: collect(.)
14: tbl(cc_dw, in_schema(db$schema, "VW_PERSON")) %>% collect()
An irrecoverable exception occurred. R is aborting now ...
Segmentation fault (core dumped)