有關在/var/log/messages 中出現SIGCHLD set to SIG_IGN的問題

orchidllh發表於2005-03-17
GC

今天檢查我的10g的資料庫，發現其中兩臺的dmesg：
application bug: sqlplus(26693) has SIGCHLD set to SIG_IGN but calls wait().
(see the NOTES section of 'man 2 wait'). Workaround activated.


在metalink上查了半天：
提到這個BUG：
Bug 號 3985530
已歸檔 01-NOV-2004 已更新 10-NOV-2004
產品 SQL*Plus 產品版本  10.1.0.2
平臺 Linux x86 平臺版本 3.0
資料庫版本 10.1.0.2 影響平臺  Port-Specific
優先順序 Severe Loss of Service 狀態 Duplicate Bug. To Filer
基本 Bug 3662585 修復產品版本 無資料

問題陳述:

HOST COMMAND FROM SQL*PLUS OUTPUTS "SIGCHLD SET TO SIG_IGN BUT CALLS WAIT()"
--------------------------------------------------------------------------------


***
11/01/04 10:50 pm
***
TAR:
====
. .
PROBLEM:
==========
From SQL*Plus, when executing "host" command, next messages appear in messages (/var/log/messages) . 
------------------------------------------------------------------------ 
Nov2 13:41:17 jpdel1380 kernel:application bug: sqlplus(14197) has                                
SIGCHLD set to SIG_IGN but calls wait(). 
Nov2 13:41:17 jpdel1380 kernel:(see the NOTES section of 'man 2 wait').                                
Workaround activated. 
------------------------------------------------------------------------
. .
DIAGNOSTIC ANALYSIS: 
======================
We can reproduce this problem on only Linux platform and SQL*Plus 10.1.0.
And this problem doesn't reproduce on other platform or SQL*Plus version. .
Same problem is reported at BUG#3662585.
But this bug is not fixed by waiting for the fix of BUG#3801874.
BUG#3801874 is status 11 now and not fixed. . .
WORKAROUND: 
============
n/a
. .
RELATED BUGS: 
===============
BUG#3662585 . .
REPRODUCIBILITY: 
==================
this problem reproduces on only Linux and SQL*Plus 10.1.0. . .
TEST CASE: 
============
please execute next command from SQL*Plus .
SQL> host echo AAA
. .

這是在我的日誌檔案中出現的錯誤提示：
Mar 17 11:04:23 bj kernel: application bug: sqlplus(23819) has SIGCHLD set to SIG_IGN but calls wait().
Mar 17 11:04:23 bj kernel: (see the NOTES section of 'man 2 wait'). Workaround activated.

STACK TRACE: 
==============
n/a
. .
SUPPORTING INFORMATION: 
=========================
My ct keeps watching "/var/log/messages" and checking whether OS problem occures or not.
So unnecesary messages appearing in "/var/log/messages" is a problem for their system. . .
24 HOUR CONTACT INFORMATION FOR P1 BUGS: 
=========================================
n/a
. .
DIAL-IN INFORMATION: 
======================
n/a
. .
IMPACT DATE: 
============
n/a
*** 11/02/04 08:55 pm ***
*** 11/10/04 04:25 pm *** (CHG: Sta->36 G/P->P)
.

沒有相應的補丁可以下載，察看/var/log/messages檔案，產生的問題基本都是由於熱備份和crontab每天執行的一個排程任務導致的，跟前臺的應用沒什麼關係，暫時還沒有影響，關注有沒有對應的補丁出現。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/51862/viewspace-180609/，如需轉載，請註明出處，否則將追究法律責任。

相關文章