RT using 100% cpu when opening some tickets

Byron_Jones · September 6, 2006, 7:23am

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.

here’s what top looks like with two requests to open the same ticket:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17556 httpdnin 25 0 423m 406m 2760 R 99.9 26.8 8:20.84 httpd
20343 httpdnin 25 0 391m 372m 2624 R 99.6 24.6 2:51.43 httpd
20429 root 16 0 1968 1108 828 R 0.3 0.1 0:00.04 top
…

here’s the mysql process list:

help!

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.

[ byron jones
[ zoom itg “In 3010, the potatoes triumphed”
[ phone +61 8 9389 5235 - N. Gertler

Byron_Jones · September 6, 2006, 7:26am

i’d also like to draw your attention to the massive amount of memory the
processes are using.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Byron
Jones
Sent: Wednesday, 6 September 2006 3:23 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT using 100% cpu when opening some tickets

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.

here's what top looks like with two requests to open the same

ticket:

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+

COMMAND
17556 httpdnin 25 0 423m 406m 2760 R 99.9 26.8 8:20.84
httpd
20343 httpdnin 25 0 391m 372m 2624 R 99.6 24.6 2:51.43
httpd
20429 root 16 0 1968 1108 828 R 0.3 0.1 0:00.04 top
…

here's the mysql process list:
 
|   3 | rt_nintek | localhost | rt_nintek | Query   |  290 |

help!
 
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.

[ byron jones
[ zoom itg                 "In 3010, the potatoes triumphed"
[ phone +61 8 9389 5235                        - N. Gertler

Jesse_Vincent · September 6, 2006, 2:42pm

i’d also like to draw your attention to the massive amount of memory the
processes are using.

Byron,

Can you tell us a bit more about the hardware and operating system
configuration you’re running with?

Byron_Jones · September 7, 2006, 12:45am

Can you tell us a bit more about the hardware and operating
system configuration you’re running with?

3g dual core p4 cpu
1g ram
80g disk (1.6g free)

gentoo linux 1.6.13 (2.6.14-gentoo-r4)
mysql 4.1.14
apache 1.3.33

Byron_Jones · September 8, 2006, 12:47am

as i know the ticket that causes this problem, is there some way to get
a dump of all the information relating to the ticket?

is there a database sanity check?

i’m thinking there’s some sort of database corruption, maybe a circular
link or something. shrugs

-byron

Byron_Jones · September 12, 2006, 1:04am

tap tap is this thing on?

as i know the ticket that causes this problem, is there some
way to get a dump of all the information relating to the ticket?

is there a database sanity check?

i’m thinking there’s some sort of database corruption, maybe
a circular link or something. shrugs

[ byron jones
[ zoom itg “In 3010, the potatoes triumphed”
[ phone +61 8 9389 5235 - N. Gertler

Jesse_Vincent · September 12, 2006, 1:10am

tap tap is this thing on?

If you’re curious if your message got through to the list, the URL at
the bottom of each posting will take you to the list archives.

However, you should bear in mind that everybody on rt-users is
volunteering their time toward free support of RT. Not every question
will get answered, nor will every answer be timely.

PGP.sig (186 Bytes)