ITPub博客

首页 > 数据库 > Oracle > clssnmPollingThread: node

clssnmPollingThread: node

原创 Oracle 作者:spectre2 时间:2011-04-12 14:39:45 0 删除 编辑

新接手数据库,在Oracle10.2 RAC节点中,查看 ocssd.log的时候发现有很多

clssnmPollingThread: node

[    CSSD]2011-04-12 14:31:47.126 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100b1ffe0) proc(100ae9bf0) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:31:47.360 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100b2e740) proc(100b2b470) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:31:59.449 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:33:00.065 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:33:05.652 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:34:00.740 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100b2ebd0) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:35:01.368 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:35:07.435 [13] >TRACE:   clssnmPollingThread: node db1 (1) missed(2) checkin(s)
[    CSSD]2011-04-12 14:36:01.965 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:36:48.144 [13] >TRACE:   clssnmPollingThread: node db2 (2) missed(2) checkin(s)
[    CSSD]2011-04-12 14:37:02.651 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:38:03.323 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:39:03.974 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)
[    CSSD]2011-04-12 14:39:42.941 [9] >TRACE:   clssgmClientConnectMsg: Connect from con(100afdb80) proc(100ae9b40) pid() proto(10:2:1:1)

 

google一下,找到:

应该是heartbeat失败。

在metalink查了一下

Irregular ClssnmPollingThread Missed Checkins Messages in CSSD log [ID 372463.1]

——————————————————————————–

Modified 06-JUN-2006 Type PROBLEM Status MODERATED

In this Document
Symptoms
Changes
Cause
Solution
References

——————————————————————————–

This document is being delivered to you via Oracle Support’s Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.2
This problem can occur on any platform.

Symptoms
The ocssd.log contains irregular messages about missed checkins from the remote nodes(s) or the local node. The missed checkins are not increasing.

Extract from ocssd.log:

[ CSSD]2006-06-01 14:10:25.138 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100aca070) proc(100acd0f0) pid() proto(10:2:1:1)
[ CSSD]2006-06-01 14:11:24.288 [14] >TRACE: clssnmPollingThread: node myrac2 (2) missed(2) checkin(s)
[ CSSD]2006-06-01 14:11:25.547 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100aca070) proc(100ae74e0) pid() proto(10:2:1:1)
[ CSSD]2006-06-01 14:11:50.468 [14] >TRACE: clssnmPollingThread: node myrac1 (1) missed(2) checkin(s)
[ CSSD]2006-06-01 14:12:25.960 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100acd800) proc(100acd0f0) pid() proto(10:2:1:1)

Changes
Install/upgrade to 10.2.

Cause
The missed checkins are printed for diagnostic purpose only.

Solution
The harmless messages can be ignored. It has been removed with the patch for bug 5037871, which will be included in 10.2.0.3.

oracle的metalink里的提示可以忽略这个问题。不过担心的是如果这里的miss出现问题累积起来,如果超过了misscount的话,节点将会被evict出来,这真是让人放心么。

说的我不放心了。。。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14184018/viewspace-692314/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-02-27

  • 博文量
    196
  • 访问量
    1868686