ITPub博客

首页 > 数据库 > Oracle > th_select_w_f_r: smwait error [1]

th_select_w_f_r: smwait error [1]

原创 Oracle 作者:parknkjun 时间:2015-11-30 16:01:08 0 删除 编辑
近日在检查crsd.log文件时,发现大量的th_select_w_f_r: smwait error [1]错误,如下:
2015-11-21 07:12:47.432: [  OCRSRV][1235589440]th_select_handler: Retrieved procctx from ht. constr = [-1338774512] retval lht [1] Wait for disconnect processing to complete on prev client.
2015-11-21 07:12:47.444: [  OCRSRV][1235589440]th_select_handler: Retrieved procctx from ht. constr = [-1338774512] retval lht [1] Wait for disconnect processing to complete on prev client.
2015-11-22 02:36:35.947: [  OCRSRV][1267059008]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1298528576]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1277548864]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1329998144]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1361467712]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRRAW][1109711168]pr_io_wait: Error in smwait. retry.
2015-11-22 02:36:35.948: [  OCRSRV][1382447424]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1340488000]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1350977856]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1371957568]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.948: [  OCRSRV][1392937280]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1288038720]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1256569152]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1309018432]th_select_w_f_r: smwait error [1]
2015-11-22 02:36:35.947: [  OCRSRV][1319508288]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1350977856]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1392937280]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1309018432]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1361467712]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1382447424]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1288038720]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1267059008]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1319508288]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1277548864]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1329998144]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRSRV][1298528576]th_select_w_f_r: smwait error [1]
2015-11-23 17:50:32.303: [  OCRRAW][1109711168]pr_io_wait: Error in smwait. retry.

metalink找到一篇文章Bug 6850110 : TH_SELECT_HANDLER MESSAGES IN CRSD.LOG ON BOTH NODES
PROBLEM:
--------
- Although turn off this messaging as user root on both nodes using the 
following syntax "crsctl debug log crs OCRSRV:0 " as recommended in Note 
338693.1 
提示根据文档ID 338693.1使用crsctl debug log crs OCRSRV:0处理
crsd.log: th_select_handler message repeated (文档 ID 338693.1)

SYMPTOMS

In the Oracle10gR2 crsd-logfile ($CRS_HOME/log/<nodename>/crsd/crsd.log) you will find messages like this:

2005-10-21 13:08:05.702: [  OCRSRV][3736]th_select_handler: Failed to retrieve procctx from ht. constr = [15299816] retval lht [-27] Signal CV.

CAUSE

This is an informational message for development.

SOLUTION

This message can be ignored as described in unpublished bug 4494370. Schedule a maintenance window and turn off this messaging as user root on one of the clusternodes: # crsctl debug log crs OCRSRV:0  Stop and start CRS after changing the tracing level to pick up the change.
该错误只是development的一个message,该错误可以忽略,如果看着不爽,可以在两点节点以root用户执行如下命令解决:
 

# crsctl debug log crs OCRSRV:0


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

请登录后发表评论 登录
全部评论
DBA攻城狮

注册时间:2008-02-11

  • 博文量
    115
  • 访问量
    519566