Hi,
I am working in Maintainance & support project. DS jobs are getting failed often because of Phantom error & mutex error. Few jobs are not able to start running in seq level and not showing any error messages in logs but the seq will be aborted. Please advice
Phantom / timeout waiting for mutex error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Phantom / timeout waiting for mutex error
Vignesh Kumar N
Re: Phatom error
please provide us with more details on error messages you receive.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ignore "phantom", that's just another word for a background process. Your errors are on mutex locks, probably timing out while waiting. You should find solutions by searching DSXchange.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 14
- Joined: Mon Mar 23, 2009 12:57 am
- Location: INDIA
Re: Phatom error
Hi,
Mutex error mainly occures while link collector stage waits for data arrival and finally fails.increase the Timeout value in job properites and re-run it
Regards
Boss
Mutex error mainly occures while link collector stage waits for data arrival and finally fails.increase the Timeout value in job properites and re-run it
Regards
Boss
vikibemech wrote:Hi,
I am working in Maintainance & support project. DS jobs are getting failed often because of Phantom error & mutex error. Few jobs are not able to start running in seq level and not showing any error messages in logs but the seq will be aborted. Please advice
DS Info
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
Here is information from my support provider -
"Your issue "timeout waiting for mutex" is most often caused by a timeout for your project or job that is set too low.
If you see this error, the suggested setting to start with is 300.
To set this at the Project level: From the DataStage Administrator, select Project -> Properties -> Tunables and set the timeout value to 300.
To set this at the Job level: From the DataStage Designer for the job, select Properties -> Performance and set the timeout value to 300.
Another thing to look for is database errors. In the case that you cite, you had already adjusted several parameters and you showed one of the many DB errors that occurred.
If the above adjustments to the timeout value do not help, it may be useful to begin the job and look for the first DBMS error that occurs. Sometimes these can cascade and cause errors like the mutex error."
"Your issue "timeout waiting for mutex" is most often caused by a timeout for your project or job that is set too low.
If you see this error, the suggested setting to start with is 300.
To set this at the Project level: From the DataStage Administrator, select Project -> Properties -> Tunables and set the timeout value to 300.
To set this at the Job level: From the DataStage Designer for the job, select Properties -> Performance and set the timeout value to 300.
Another thing to look for is database errors. In the case that you cite, you had already adjusted several parameters and you showed one of the many DB errors that occurred.
If the above adjustments to the timeout value do not help, it may be useful to begin the job and look for the first DBMS error that occurs. Sometimes these can cascade and cause errors like the mutex error."
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray - Just FYI. I tried to pursue this with IBM - to get recommendations for settings for these tunables. I even pursued it to the level of forcing engineering to reply and this is what I got from engineering:ray.wurlod wrote:Search for SPINTRIES and SPINSLEEP also. Your processor may be too fast for its own good.
They only recommended using larger IPC buffers with increased timeout values - even though we were on an HP system.The InformationServer engine uses regular semaphore locking by default (ie SPINTRIES 0). Spinlocks can be used if the customer decides to enable the SPINTRIES tunable in uvconfig, but I hesitate to suggest that as a resolution for the "Timeout waiting for mutex" as we've seen this error at customer sites and the resolution has never been via a uvconfig tunable.
The uvconfig file makes references to these parameters being HP specific. It's not clear from what I've found on this problem (which we are experiencing on Solaris 10) whether they pertain to other machinery.ray.wurlod wrote:Search for SPINTRIES and SPINSLEEP also. Your processor may be too fast for its own good. ...
Having said that, the Project/Tunables timeout setting was the default value of 10, so we are trying the recommendation above of increasing that to 300.
Can anyone shed any light on whether these parameters are relevant on Solaris?
cheers
RET