<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face="Courier New" color=#800000 size=2><SPAN
class=911462507-06092006>i'd also like to draw your attention to the massive
amount of memory the processes are using.</SPAN></FONT></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #800000 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Byron
Jones<BR><B>Sent:</B> Wednesday, 6 September 2006 3:23 PM<BR><B>To:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> [rt-users] RT using 100%
cpu when opening some tickets<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>when we open some tickets on RT 3.6.0 (plan to upgrade to 3.6.1 when i
can) the httpd process uses 100% CPU and never stops.</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>here's what top looks like with two requests to open the same
ticket:</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2> PID USER PR NI
VIRT RES SHR S %CPU %MEM TIME+
COMMAND<BR>17556 httpdnin 25 0 423m 406m 2760 R 99.9
26.8 8:20.84 httpd<BR>20343 httpdnin 25 0
391m 372m 2624 R 99.6 24.6 2:51.43 httpd<BR>20429
root 16 0 1968 1108 828
R 0.3 0.1 0:00.04 top</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>here's the mysql process list:</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>| 3 | rt_nintek | localhost | rt_nintek | Query
| 290 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 5 | rt_nintek | localhost | rt_nintek | Query
| 280 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 6 | rt_nintek | localhost | rt_nintek | Query
| 290 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 7 | rt_nintek | localhost | rt_nintek | Query
| 203 | User lock | SELECT
GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600)
|<BR>| 8 | rt_nintek | localhost | rt_nintek | Sleep
| 193 | |
NULL
|<BR>| 9 | rt_nintek | localhost | rt_nintek | Query
| 379 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) |<BR>|
10 | rt_nintek | localhost | rt_nintek | Query | 413 | User
lock | SELECT GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613',
3600) |<BR>| 11 | rt_nintek | localhost | rt_nintek | Sleep
| 193 | |
NULL
|<BR>| 13 | rt_nintek | localhost | rt_nintek | Query
| 203 | User lock | SELECT
GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600) |<BR>| 399 |
rt_nintek | localhost | rt_nintek | Query | 236 | User lock
| SELECT GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 400 | rt_nintek | localhost | rt_nintek | Query | 234
| User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) |<BR>| 401 |
rt_nintek | localhost | rt_nintek | Query | 230 | User lock
| SELECT GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 402 | rt_nintek | localhost | rt_nintek | Query | 203
| User lock | SELECT
GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600) |<BR>| 403 |
rt_nintek | localhost | rt_nintek | Sleep | 2
| |
NULL
|<BR>| 411 | rt_nintek | localhost | rt_nintek | Sleep | 127
| |
NULL
|<BR>| 413 | rt_nintek | localhost | rt_nintek | Sleep | 127
| |
NULL
|<BR>| 415 | rt_nintek | localhost | rt_nintek | Sleep
| 47 |
|
NULL
|<BR>| 416 | rt_nintek | localhost | rt_nintek | Sleep
| 0
| |
NULL
|<BR>| 417 | rt_nintek | localhost | rt_nintek | Sleep
| 1
| |
NULL
|<BR>| 418 | rt_nintek | localhost | rt_nintek | Sleep
| 1
| |
NULL
|<BR></FONT></DIV>
<DIV><SPAN class=363051107-06092006></SPAN><FONT face="Courier New"
color=#800000 size=2>h<SPAN class=363051107-06092006>elp!</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#800000 size=2><SPAN
class=363051107-06092006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" color=#800000 size=2><SPAN
class=363051107-06092006>it's at the point now where i have a script that runs
every minute killing httpd processes that have been running for a long time
with high cpu usage.</SPAN></DIV>
<DIV><BR></DIV></FONT></SPAN>
<DIV><FONT face="Courier New" color=#800000 size=2></FONT> </DIV>
<DIV class=Section1 align=left>
<P class=MsoNormal><SPAN class=GramE><SPAN
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: 'Courier New'">[
byron</SPAN></SPAN><SPAN
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: 'Courier New'"> <SPAN
class=SpellE>jones</SPAN><BR>[ zoom <SPAN
class=SpellE>itg</SPAN>
"In 3010, the potatoes triumphed"<BR>[ phone +61 8 9389
5235
- N. <SPAN class=SpellE>Gertler</SPAN><BR
style="mso-special-character: line-break"><BR
style="mso-special-character: line-break"><o:p></o:p></SPAN></P></DIV>
<DIV><FONT face="Courier New" color=#800000
size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>