RE: Runaway Informix SQL Processes. Need Help!!
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_000_01BCBC39.A5278680
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
I run into a related problem on a fairly regular basis. The user
kills the terminal emulation on the pc (either by closing it or by
power failure) without first closing the application. Most of the
time when this happens, our server (an RS/6000) still thinks the
connection is open.
We reboot all our servers every night as a part of our backup routine
so the CPU problem you encountered never becomes an issue with us.
Hope this adds at least a little insight into your problem.
-Todd
ps: we run SE 5.02.
tbernhardt@wii.com
----------
From: paynesys@aol.com[SMTP:paynesys@aol.com]
Sent: Friday, September 05, 1997 9:13 PM
To: informix-list@rmy.emory.edu
Subject: Runaway Informix SQL Processes. Need Help!!
I ran the UNIX vmstat & sar commands and discovered that our
system's CPU idle time was at 0%. I then did a ps -ef and
discovered two processes ( SQL queries via dbaccess ) that
where started weeks ago where eating up CPU time. The users who
started these processes used the interrupt key to halt the queries.
For some reason, the SQL processes that where aborted using
the intrrupt key remained in the queue for weeks. After killing
these processes ( kill -9 ), our CPU idle percentage returned to
normal.
Can someone please explain to me why SQL processes that are
aborted via the interrupt key continue to hog CPU time?
Please email your responses to:
paynesys@aol.com
------ =_NextPart_000_01BCBC39.A5278680
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IgMQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQmAAQAhAAAAQURGQTA5NkUxRjI4RDExMUJENTAwMDgwNUZCQ0JE
M0QAWAcBIIADAA4AAADNBwkACAAJAB0AAAABAAwBAQWAAwAOAAAAzQcJAAgACQAUADsAAQA+AQEN
gAQAAgAAAAIAAgABBIABADEAAABSRTogUnVuYXdheSBJbmZvcm1peCBTUUwgUHJvY2Vzc2VzLiAg
TmVlZCBIZWxwISEAABABA5AGAGQHAAAYAAAAAwAuAAAAAABAADkAgG6XMXO8vAEeAHAAAQAAADEA
AABSRTogUnVuYXdheSBJbmZvcm1peCBTUUwgUHJvY2Vzc2VzLiAgTmVlZCBIZWxwISEAAAAAAgFx
AAEAAAAWAAAAAby8czGGbgn6rigfEdG9UACAX7y9PQAAAwAGEJ1MHaUDAAcQYwQAAB4ACBABAAAA
ZQAAAElSVU5JTlRPQVJFTEFURURQUk9CTEVNT05BRkFJUkxZUkVHVUxBUkJBU0lTVEhFVVNFUktJ
TExTVEhFVEVSTUlOQUxFTVVMQVRJT05PTlRIRVBDKEVJVEhFUkJZQ0xPU0lOR0kAAAAAAwAQEAAA
AAADABEQAAAAAAIBCRABAAAA2wQAANcEAACdCAAATFpGdT1j5l3/AAoBDwIVAqQD5AXrAoMAUBMD
VAIAY2gKwHNldO4yBgAGwwKDMgPGBxMCg7ozEw19CoAIzwnZOxX/eDI1NQKACoENsQtgbvBnMTAz
FCALChLyDAGCYwBAIEkgcnUDoKELgHRvIGEa8GULYDJ0CYAgcANgAmBlbRYgAiAbgWYLcHJseZkb
oWd1C2AFwGJhAJAAcy4gIFRoZSBWdRHwBcBrAxBsBCB0sx6BG/BybQuAB0AgHIA5HaF0aRyxHLEf
YnBjcCAoZWkfYR3RHVBjfxWQAJAZABswBUAFsSHxcDxvdx7RHQEKQBYAKSCvA/AfYAhgBUBmHSBz
BUCTIiYfYmFwC1BpYyBz7R5BTSJAIrFmH1QHcSQQdx6AIOIEACARwCXQCfBzViwcoAhwIB7Bdh7R
KMEDkVJTLzYwKhAkAGck0B8RJ/Juax9EBaBurm4FkCCDKCFvKIEuCoXdCoVXHpAWAAbgbwVAB0B3
AyAo6AQgZSlRHVADAGf+aC4BBCAbkAqxJtMo4h3w8GNrdXAa8CRhC4AekEZzG3AfYkNQVRwnefsI
YCAgbgWgGxAfoRwBK6D9KVJiBZEHggORBAEKUCQTGx6hLJ1ILFEn9GFkZH8v8QVAHHAeAC4BN/Ah
kHT/HHAbMQCQL6IbQzMRBcAcNSksnS1UBHBkLKxwcw46HlAjUBrzU0UgNXguMDIsnQJQBJERwWTk
dEAD8GkuNJEsrAqLGSXwMTgqEAIAaS0xPDQ0DfAM0EIzC1kxNv8KoANgG/ArwDtgRFcKh0ML+www
Q9ZGA2E8wELvQ/QMggUwIXkroHN5c0BhAwbwP6JbU01UUDr9SR5dRP9GDQZgAjBHP0hL+UbwaWRJ
ICjABmAFMByAET7RIDA1KMAxOTkANyA5OjEzIFD+TUuPRg07gE3PSEsLgAIQWR/BeC0l8CTQQB/A
ec4uHIAFsFbBZHVRz0yeuHViaiuxU+9IS1IbEDxhd0kgGtBV1QYAUUz7UZADYGMHkBHwHjIHwBwB
YkgbwHAhIUBfQWMz/yoAC0YUIgwBQ9YKhRrSA5EBH2JVTklYIHZt+yTQN9EmKRAKwTSRA4E3ovlk
ECBkBAAFoClRHAEfYN830QhhYYZJYVBRJwQgMlKfT8A4wSdkL+IFQDAlHkF/GuAfYQOgZJAcEDAR
BCAt7w3AZENhhmSadxtwHDFdRLshYFzDcQpQCIEEIHYHMPdkgDDxXUIgJABlQ2GGJ7FfFgAqUTBB
HAEjUGUrAWH+ZxtwbqQ4EDGRIoAxMTJS7ydiHkkEICewb2XHbxUfYf8R8GtZHrFzgxsyBJAbAAUx
3GtlHVAbYRHAbAVAH2L/bGUslkbgBbEx4CeBFgAeAP8CICjAH2Jc0mtoZUNupAGg/xWhHAEesCJh
YYZ09XV4FgD/AMAxoRwQC4B2hjVRVeFvdP0eQUEBgB7VImJ7iXPbbAB7HwI7YDltoCjEZtcogHLv
XUACMG/gLZJ0CHB9Yhth/WGGblXxB0AeQSysMkADkd94EgIgISE4AnBheAtTdgL/J4MdUHkvLgEW
AGGGerZs4t90/ytiMZE1UXYSbyKAcSb2Pz/vYbNQh3V9MQMgOcP9FgBzIzAAgHnSU9CFvUkeX17/
QtcaNWENFSEAlsAAAwA2AAAAAAADACYAAAAAAAIB+T8BAAAAHgAAAAAAAADcp0DIwEIQGrS5CAAr
L+GCAQAAAAAAAAAuAAAAHgD4PwEAAAAVAAAAU3lzdGVtIEFkbWluaXN0cmF0b3IAAAAAAgH7PwEA
AAAeAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC4AAAAeAPo/AQAAABUAAABTeXN0ZW0g
QWRtaW5pc3RyYXRvcgAAAABAAAcwQPAkZHG8vAFAAAgwEJxIUHS8vAEDAA00/T8AAAIBFDQBAAAA
EAAAAFSUocApfxAbpYcIACsqJRceAD0AAQAAAAUAAABSRTogAAAAAAsAKQAAAAAACwAjAAAAAAAC
AX8AAQAAAE8AAAA8Yz1VUyVhPV8lcD1XaWxsYW1ldHRlX0luZHVzJWw9V0lMTEFNRVRURS9JU0RP
TUFJTi8wMDA4OEU5N0BwZC1leGNoLTEud2lpLmNvbT4AAG8n
------ =_NextPart_000_01BCBC39.A5278680--