Oracle12,1,2,0版本中遇到bug25211209
现象描述:12.1.0.2 集群进程ocssd.bin占用较高的CPU:
PIDUSERPRNIVIRTRESSHRS%CPU%MEMTIME+COMMAND27647gridRT05002m2.8g86mS117.60.6209825:27ocssd.bin
系统总体CPU使用并不高,造成以上单个线程的CPU使用率较高是由clsdadr_bucketThread线程。
#50x00007f0b76feb0bcinclsdadr_process_bucket()from/u01/app/12.1.0.2/grid/lib/libhasgen12.so#60x00007f0b76feac23inclsdadr_bucketThread()from/u01/app/12.1.0.2/grid/lib/libhasgen12.so
同时,查看ocssd.trc文件中,可以发现大量以下的提示信息:
2018-10-1214:33:04.342374:CSSD:3886925568:clssgmMemberPublicInfo:groupOSM_ALLmember1notfound2018-10-1214:33:04.435152:CSSD:3886925568:clssgmMbrDataUpdt:Processingmemberdatachangetype1,size4forgroupHB+ASM,memberID11:2:12018-10-1214:33:04.435164:CSSD:3886925568:clssgmMbrDataUpdt:SendingmemberdatachangetoGMPforgroupHB+ASM,memberID11:2:12018-10-1214:33:04.437429:CSSD:3889161984:clssgmpcMemberDataUpdt:grockNameHB+ASMmemberID11:2:1,datatype1datasize42018-10-1214:33:04.442236:CSSD:3883771648:clssgmcpDataUpdtCmpl:Status0mbrdataupdtmemberID11:2:1fromclientID1:160:42018-10-1214:33:04.552308:CSSD:3848582912:clssnmSendingThread:sendingstatusmsgtoallnodes2018-10-1214:33:04.553123:CSSD:3848582912:clssnmSendingThread:sent4statusmsgstoallnodes2018-10-1214:33:05.353496:CSSD:3886925568:clssgmMemberPublicInfo:groupOSM_ALLmember1notfound2018-10-1214:33:06.346352:CSSD:3886925568:clssgmMemberPublicInfo:groupOSM_ALLmember1notfound2018-10-1214:33:06.488828:CSSD:3886925568:clssgmMbrDataUpdt:Processingmemberdatachangetype1,size4forgroupHB+ASM,memberID11:2:12018-10-1214:33:06.488842:CSSD:3886925568:clssgmMbrDataUpdt:SendingmemberdatachangetoGMPforgroupHB+ASM,memberID11:2:12018-10-1214:33:06.492775:CSSD:3889161984:clssgmpcMemberDataUpdt:grockNameHB+ASMmemberID11:2:1,datatype1datasize42018-10-1214:33:06.499862:CSSD:3883771648:clssgmcpDataUpdtCmpl:Status0mbrdataupdtmemberID11:2:1fromclientID1:160:42018-10-1214:33:07.233537:GIPCHTHR:3878508288:gipchaDaemonWork:DaemonThreadheartbeat,timeintervalsincelastheartBeat30020loopCount372018-10-1214:33:07.349067:CSSD:3886925568:clssgmMemberPublicInfo:groupOSM_ALLmember1notfound2018-10-1214:33:08.351711:CSSD:3886925568:clssgmMemberPublicInfo:groupOSM_ALLmember1notfound2018-10-1214:33:08.548780:CSSD:3886925568:clssgmMbrDataUpdt:Processingmemberdatachangetype1,size4forgroupHB+ASM,memberID11:2:12018-10-1214:33:08.548794:CSSD:3886925568:clssgmMbrDataUpdt:SendingmemberdatachangetoGMPforgroupHB+ASM,memberID11:2:12018-10-1214:33:08.551894:CSSD:3889161984:clssgmpcMemberDataUpdt:grockNameHB+ASMmemberID11:2:1,datatype1datasize42018-10-1214:33:08.558731:CSSD:3883771648:clssgmcpDataUpdtCmpl:Status0mbrdataupdtmemberID11:2:1fromclientID1:160:4
通过查询MOS,查到类似的情况,详细参考MOS文档 ID 2235698.1,该问题是由Bug 26513709造成,可通过应用补丁20302006与25211209避免,同时,官方宣布在12.2.0.2中已经将该bug修复。
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。