Re: Weirdness: HPUX 10.20/IDS 7.30.UC6

I have had the same problem since January on SCO 5.0.4 IDS 7.30.UC2 It happens about every 10 to 14 days. The only thing I have been ablr to determine about this is that there is a connection that shows in onstat -g ses and ntt but not with any other onstat command. Also before the hanging occurs I have found out that my checkpoints increase dramatically. From 3 or less seconds to 100 to 700 seconds. I have opened a case with tech support but they don't have a clue as to why yet. My work around is to bounce the engine once a week. I do this about 1AM on Sunday which is our least busiest time. Joe ------------------------------------------------------------------------- Joseph Cullipher <joseph@cannonexpress.com> Standard Disclaimers Apply ------------------------------------------------------------------------- On Fri, 30 Apr 1999, David Coburn wrote: > Odd thing happened last night. At some point one instance (of several on > the machine) decided to stop accepting any connections. There was one user > thread returning data and several others (including an oncheck) that had > finished and were sitting around waiting for something to do. I mention > the oncheck because the pid in onstat -g ses didn't exist; the person who > ran oncheck earlier did a ^C to terminate it. onmode -yuck hung, as did > onmode -z tid. Anything that required a connection to the database, in> fact, would hang indefinately. There was nothing in the log file to > indicate any problems, and in fact checkpoints were still occuring every 5 > minutes, right on schedule. ipcs output looked entirely normal, as did > netstat. > > About the only way to clean this up was to either reboot the computer, or > whacking shared memory segments until the engine realized that something > was wrong and terminated itself. We chose the reboot because this is > production and that was the fastest most reliable way to clean it up. > > OK, so has anybody else ever seen this kind of problem? Rebooting a > computer to solve a problem with connections seems a tad drastic. > > Thanks, > > David > >