Grokbase Groups R r-devel March 2009
FAQ
Dear list.

Has anybody had any issues with ROracle, namely consistently leading to
a segmentation fault? One of our oracle databases seems to have certain
issues at the moment (do not know what exactly though) and if that one
is queried ROracle definitely fails with a segmentation fault. Any
ideas? Here is the trace and below is also a type of query that crashes
it:

*** caught segfault ***
address 0x1, cause 'memory not mapped'

Traceback:
1: .Call("RS_Ora_exec", ps = as(ps, "integer"), data = data,
data.classes = df.classes, buf.size = as.integer(ora.buf.size),
PACKAGE = .OraPkgName)
2: oraExecStatement(ps, ora.buf.size = as(ora.buf.size, "integer"))
3: doTryCatch(return(expr), name, parentenv, handler)
4: tryCatchOne(expr, names, parentenv, handlers[[1L]])
5: tryCatchList(expr, classes, parentenv, handlers)
6: tryCatch(expr, error = function(e) { call <- conditionCall(e)
if (!is.null(call)) { if (identical(call[[1L]],
quote(doTryCatch))) call <- sys.call(-4L) dcall <-
deparse(call)[1L] prefix <- paste("Error in", dcall, ": ")
LONG <- 75L msg <- conditionMessage(e) sm <- strsplit(msg,
"\n")[[1L]] if (14L + nchar(dcall, type = "w") + nchar(sm[1L],
type = "w") > LONG) prefix <- paste(prefix, "\n
", sep = "") } else prefix <- "Error : " msg <- paste(prefix,
conditionMessage(e), "\n", sep = "")
.Internal(seterrmessage(msg[1L])) if (!silent &&
identical(getOption("show.error.messages"), TRUE)) {
cat(msg, file = stderr()) .Internal(printDeferredWarnings()) }
invisible(structure(msg, class = "try-error"))})
7: try({ ps <- oraPrepareStatement(con, statement, bind = NULL)
rs <- oraExecStatement(ps, ora.buf.size = as(ora.buf.size,
"integer"))})
8: oraExecDirect(con, statement, ...)
9: oraQuickSQL(conn, statement, ...)
10: dbGetQuery(dotsConnection(), qry)

--
This is the type of query (template) that crashes it, I know this is not
too helpful as you cannot run it, but maybe someone spots a certain
pattern in it:

SELECT TIMESTAMP, VALUE, VM FROM
(WITH ev AS
(SELECT audit_key_new key, audit_date dt, audit_batch_nbr,
audit_date
FROM dots_audit.audit_event
WHERE table_name='VALUE_PROPERTY_MAP'),
jfsm AS
(SELECT audit_key, fund_id, fund_mult
FROM dots_audit.value_property_map WHERE property_id='%s'
UNION SELECT audit_key, value_id, value_mult
FROM dots.value_property_map WHERE property_id='%s')
SELECT DISTINCT
ev.dt - to_date('01011970','ddmmyyyy') TIMESTAMP,
jfsm.value_id VALUE,
jfsm.value_mult VM,
RANK() OVER (PARTITION BY audit_batch_nbr, value_id ORDER BY dt
DESC) r
FROM jfsm, ev WHERE audit_key=ev.key)
WHERE r=1 ORDER BY TIMESTAMP DESC

--
library(ROracle)
Loading required package: DBI
sessionInfo()
R version 2.9.0 Under development (unstable) (2009-02-02 r47821)
x86_64-unknown-linux-gnu

locale:
LC_CTYPE=en_GB;LC_NUMERIC=C;LC_TIME=en_GB;LC_COLLATE=C;LC_MONETARY=C;LC_
MESSAGES=en_GB;LC_PAPER=en_GB;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_M
EASUREMENT=en_GB;LC_IDENTIFICATION=C

attached base packages:
[1] stats graphics utils datasets grDevices methods base


other attached packages:
[1] ROracle_0.5-9 DBI_0.2-4

--

Dr Oleg Sklyar
Research Technologist
AHL / Man Investments Ltd
+44 (0)20 7144 3107
osklyar at maninvestments.com

**********************************************************************
Please consider the environment before printing this email or its attachments.
The contents of this email are for the named addressees ...{{dropped:19}}

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupr-devel @
categoriesr
postedMar 27, '09 at 4:54p
activeMar 27, '09 at 4:54p
posts1
users1
websiter-project.org
irc#r

1 user in discussion

Sklyar, Oleg (London): 1 post

People

Translate

site design / logo © 2022 Grokbase