An irrecoverable exception occurred. R is aborting now ... Segmentation fault (core dumped)

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)

Long shot guess


view_data <- tbl(cc_dw, in_schema(db$schema, "VW_PERSON"))
collect(view_data)

based on a vague feeling that somehow the pipe isn’t picking up the or passing on the argument. If that isn’t it, I’d next try

in_schema(db$schema, "VW_PERSON")

On its own.

Thank you, technocrat! Your first suggestion works!!

1 Like

This topic was automatically closed 21 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.