RE: [U2] Universe Database Hang (login hang)
Dear All, I encountered this problem and have use UNLOCK SEMAPHORE base on the analyze.shm -s result to solve it We are now tracing which backend program causing the lock. Thanks Charles Thanks and Regards Ang -Original Message- From: Stevenson, Charles [SMTP:[EMAIL PROTECTED] Sent: Tuesday, 22 June, 2004 12:07 AM To: [EMAIL PROTECTED] Cc: Ang Suan Yong Subject: RE: [U2] Universe Database Hang (login hang) Do anyone having experience on Universe Database hang. ( note that existing user process still able to run the process and access the database only user which using new session log to the database will hang over there ? ) The system file is not full . When i LIST.READU EVERY (using existing session) found that no much record locking / The database daemon is still alive during the situation of database hang Are you saying that users hang as they try to log in? That is, invoking the UV shell hangs the user, but not the database itself, right? Do ANALYZE.SHM -s to list semaphores. Something may have locked the login semaphore, which each login process should set briefly, then release. Toward the bottom you will see : Login State Netnode Owner Collisions Retries Semaphore # 1 1016 1 859086 ^ If State is 1, not 0, that is your problem. The equivalent unix command is [uvhome dir]/bin/smat -s Solution: As superuser, already at uv command prompt, type UNLOCK LOGINLOCK SEMAPHORE. (Look up UNLOCK SEMAPHORE in User ref manual, the online HELP UNLOCK is incomplete.) If superuser is not already in UV, you won't be able to login, to run these commands. I don't know the best way to unlock the semaphore in that case. Anyone? Moral: !!! !! !! !! ALWAYS LEAVE A ROOT SESSION AT UV TCL PROMPT. !! !! (e.g. in data center, system console) !! !! !! !!! One possible cause: I had the problem where I tried to pipe the output of uv/bin/uvlictool -report_lic to gerp instead of grep: $/dbms/uv/bin/uvlictool report_lic | gerp UVCS uvlictool apparently sets the login semaphore while it takes its snapshot. The subsequent error caused uvlictool to leave it locked. My solution: a little script uvlicr that does: /dbms/uv/bin/uvlictool report_lic /tmp/uvlicr.txt ; cat /tmp/uvlicr.txt Piping that to gerp won't cause havoc. Same for script uvlicc uvlictool clean_lic -a. - cds DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Database Hang
Ang Suan Yong wrote: Do anyone having experience on Universe Database hang. ( note that existing user process still able to run the process and access the database only user which using new session log to the database will hang over there ? Not UniVerse, but UniData was doing that to us intermittently. Nobody new could log in, but users who were already in didn't experience any problems. I don't think we ever figured out what the issue was, but we moved up to UD6 and it hasn't happened again. -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Database Hang (login hang)
Do anyone having experience on Universe Database hang. ( note that existing user process still able to run the process and access the database only user which using new session log to the database will hang over there ? ) The system file is not full . When i LIST.READU EVERY (using existing session) found that no much record locking / The database daemon is still alive during the situation of database hang Are you saying that users hang as they try to log in? That is, invoking the UV shell hangs the user, but not the database itself, right? Do ANALYZE.SHM -s to list semaphores. Something may have locked the login semaphore, which each login process should set briefly, then release. Toward the bottom you will see : Login State Netnode Owner Collisions Retries Semaphore # 1 1016 1 859086 ^ If State is 1, not 0, that is your problem. The equivalent unix command is [uvhome dir]/bin/smat -s Solution: As superuser, already at uv command prompt, type UNLOCK LOGINLOCK SEMAPHORE. (Look up UNLOCK SEMAPHORE in User ref manual, the online HELP UNLOCK is incomplete.) If superuser is not already in UV, you won't be able to login, to run these commands. I don't know the best way to unlock the semaphore in that case. Anyone? Moral: !!! !! !! !! ALWAYS LEAVE A ROOT SESSION AT UV TCL PROMPT. !! !! (e.g. in data center, system console) !! !! !! !!! One possible cause: I had the problem where I tried to pipe the output of uv/bin/uvlictool -report_lic to gerp instead of grep: $/dbms/uv/bin/uvlictool report_lic | gerp UVCS uvlictool apparently sets the login semaphore while it takes its snapshot. The subsequent error caused uvlictool to leave it locked. My solution: a little script uvlicr that does: /dbms/uv/bin/uvlictool report_lic /tmp/uvlicr.txt ; cat /tmp/uvlicr.txt Piping that to gerp won't cause havoc. Same for script uvlicc uvlictool clean_lic -a. - cds --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Database Hang
We had this problem but it was related to Vertias Replication software. Are you by chance running Vertias on HPUX? Sorry deleted the original post if that had the OS info in it. Don Verhagen Tandem Staffing Solutions, Inc. [EMAIL PROTECTED] 11:56:10 AM 06/21/2004 Ang Suan Yong wrote: Do anyone having experience on Universe Database hang. ( note that existing user process still able to run the process and access the database only user which using new session log to the database will hang over there ? Not UniVerse, but UniData was doing that to us intermittently. Nobody new could log in, but users who were already in didn't experience any problems. I don't think we ever figured out what the issue was, but we moved up to UD6 and it hasn't happened again. -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/