Re: Runaway dbaccess process
Ron,
I've experienced this kind of thing also on my SCO 3.2.4.2 box but
with users making a sockets connection to sqlexecd and to online. Somehow
when they exit, even in an orderly fashion from their workstation, the
sqlexec process is still running as reported by ps and by netstat.
Could that be your situation? I'm beginning to think the tcp software
is not releasing the connection. In other words, though my environment
picture is radically different from yours, there may be similar complicating
factors.
Yours,
Nick
*********************************
Nick Nobbe, Library of Congress
NLS/BPH
mail: nnob@loc.gov
*********************************
On Tue, 7 Oct 1997, Ron M. Flannery wrote:
}
} On our current application, users start dbaccess and sometimes disconnect
} without properly exiting (turning off terminal, etc.). The dbaccess
} process hangs and proceeds to take over ALL of CPU 1 or 2. When I do a top
} or sar, one of the CPUs is pegged by the dbaccess process! I was able to
} easily reproduce this by starting dbaccess, doing "select * from customer"
} and disconnecting.
}
} The process is eating CPU time but not Informix time. Neither the session
} nor the thread was accruing any reads or writes, but the process was
} chewing CPU like crazy.
}
} Here's the config: We're running HP-UX 10.20 with ODS 7.20. We have three
} CPUs and the following settings:
} NUMCPUVPS=1,SINGLE_CPU_VP=1,MULTIPROCESSOR=0 (I'm basing these settings on
} the rule of thumb about pretending like there's one CPU for anything less
} than 4. I'll tweak when I can get offline time). We're not currently
} using KAIO (waiting for HP patches). Nothing else exciting I can think of.
}
} My theory is that it relates to the Informix version and processor settings.
}
} Has anyone else experienced such a thing? Any ideas?
}
} Thanks,
} Ron
}
}
}
}
} Ron Flannery | President,
} rflanner@one-point.com | Michigan Informix User Group
} President, One Point Solutions| http://www.zenacomp.com/miug/
} http://www.one-point.com
} voice=248.887.8470
}