From: SMTP%"MACRO32%WKUVX1.BITNET@uu7.psi.com" 25-JUN-1993 08:57:40.83 To: EVERHART CC: Subj: Re: Question: Process in MUTEX state X-Listname: "VMS Internals, MACRO, & BLISS Discussions" Warnings-To: <> Errors-To: MacroMan%WKUVX1.BITNET@uu7.psi.com Sender: MacroMan%WKUVX1.BITNET@uu7.psi.com From: Reply-To: MACRO32%WKUVX1.BITNET@uu7.psi.com X-Newsgroups: vmsnet.internals Subject: Re: Question: Process in MUTEX state Message-Id: <1993Jun24.121003.17732@montagar.com> Date: 24 Jun 93 12:10:03 CDT Organization: Montagar Software Concepts, Plano TX Lines: 42 To: MACRO32@WKUVX1.BITNET X-Gateway-Source-Info: USENET In article <1993Jun17.092923.1@cc.uab.es>, g_carles@cc.uab.es (Carles Blas (UAB)) writes: > Our site has several VAXes (6610,6610,6410) in a cluster running VMS 5.5 and > INGRES 6.4. > > In then 6410, the II_DBMS process has hunged three times in MUTEX state. > The only way I could unhang it was doing a SHUTDOWN. Is there any way to > kill the process without stopping the system? > > Any comments will be very valuable. Thanks in advance. > > > Carles Blas > System Analyst > Centre de Processament de Dades > Universitat Autonoma de Barcelona > Internet: g_carles@cc.uab.es > Bitnet: g_carles@ebccuab1 You need to find out who is holding the MUTEX, which is not always easy. You might want to get the session notes I did in the Atlanta DECUS off my file server. Just send mail to fileserv@montagar.com, and place the words: SEND RWASTED in the body (not the subject!) of the mail message. It will mail you a VMS_SHARE of the session notes in Postscript format. The best way to find the person who owns the mutex, is to go through ANALYZE/SYSTEM, and for each process (picking only likely prospects), do a "SHOW PROCESS". Look for the field "Mutex Count" for a non-zero value. This process holds a mutex, unfortunately you can't easily determine which one. For the process that is MUTEX'd, do a "SHOW PROCESS", and then do a "EVAL xxxxxxx" where 'xxxxxx' is the number that appears in the Event Flag Wait Mask (this is the MUTEX address), and see if it resolves to a known MUTEX in VMS. Since this is a database, they may provide there own mutexes. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - David L. Cathey |INET: davidc@montagar.com Montagar Software Concepts |UUCP: ...!montagar!davidc P. O. Box 260772, Plano TX 75026-0772 |Fone: (214)-618-2117