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] [email protected]
[w] http://www.skidata.com
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
