[Spacewalk-list] Daily Oracle errors

BUPE(Peter Burgstaller) Peter.Burgstaller at skidata.com
Tue Mar 29 14:34:13 UTC 2011


Dear all,

I have spacewalk 1.3 running on a Oracle 11R2 and receive a daily error from my DBMS:

ORA-7445[kokscfac()+232][SIGSEGV][ADDR:0x10][PC:0x1110922][Address not mapped to object]

SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery") */ 1 AS C1 FROM (SELECT SYS_OP_NOEXPAND("NP_PE"."EVR") "ITEM_1","NP_PE"."SYS_NC00006$" "ITEM_2","NP_PE"."SYS_NC00007$" "ITEM_3","NP_PE"."SYS_NC00008$" "ITEM_4","NP_NP"."NAME_ID" "ITEM_5","NP_NP"."PACKAGE_ARCH_ID" "ITEM_6","NP_NP"."CHANNEL_ID" "ITEM_7",MAX("NP_PE"."EVR") "ITEM_8" FROM "RHNPACKAGEEVR" "NP_PE","RHNCHANNELNEWESTPACKAGE" "NP_NP" WHERE "NP_PE"."ID"="NP_NP"."EVR_ID" GROUP BY SYS_OP_NOEXPAND("NP_PE"."EVR"),"NP_PE"."SYS_NC00006$","NP_PE"."SYS_NC00007$","NP_PE"."SYS_NC00008$","NP_NP"."NAME_ID","NP_NP"."PACKAGE_ARCH_ID","NP_NP"."CHANNEL_ID") "VW_GBC_13#3", (SELECT "SP_SP"."SERVER_ID" "SERVER_ID","SP_SP"."NAME_ID" "NAME_ID","SP_SP"."PACKAGE_ARCH_ID" "PACKAGE_ARCH_ID",MAX("SP_PE"."EVR") "MAX_EVR" FROM "RHNSERVERPACKAGE" "SP_SP","RHNPACKAGEEVR" "SP_PE" WHERE "SP_PE"."ID"="SP_SP"."EVR_ID" GROUP BY "S!
P_SP"."SERVER_ID","SP_SP"."NAME_ID","SP_SP"."PACKAGE_ARCH_ID") "SP#2" WHERE ("SP#2"."NAME_ID"="VW_GBC_13#3"."ITEM_5") AND ("SPACEWALK"."EVR_T"."COMPARE"("SP#2"."MAX_EVR","VW_GBC_13#3"."ITEM_1")<0)) innerQuery

Has anybody already encountered this issue and if so, what is the cause of it?
Is there a fix for this?

Thank you very much, Peter
--
DI Peter Burgstaller
-----------------------------------
Head of Hosted Services

SKIDATA AG
Untersbergstraße 40
A-5083 Grödig, Salzburg
[p] +43 (0) 6246 888-4155
[f] +43 (0) 6246 888-7
[e] peter.burgstaller at skidata.com
[w] http://www.skidata.com





More information about the Spacewalk-list mailing list