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 > -----Original Message----- > From: Jesse Vincent [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 6 September 2006 10:43 PM > To: Byron Jones > Cc: [email protected] > Subject: Re: [rt-users] RT using 100% cpu when opening some tickets > > > > > On Wed, Sep 06, 2006 at 03:26:12PM +0800, Byron Jones wrote: > > 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? > > > > > > ________________________________ > > > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf > Of Byron > > Jones > > Sent: Wednesday, 6 September 2006 3:23 PM > > To: [email protected] > > 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 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 5 | rt_nintek | localhost | rt_nintek | Query | 280 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 6 | rt_nintek | localhost | rt_nintek | Query | 290 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 7 | rt_nintek | localhost | rt_nintek | Query | 203 | > > User lock | SELECT > > GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600) | > > | 8 | rt_nintek | localhost | rt_nintek | Sleep | 193 | > > | NULL > > | > > | 9 | rt_nintek | localhost | rt_nintek | Query | 379 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 10 | rt_nintek | localhost | rt_nintek | Query | 413 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 11 | rt_nintek | localhost | rt_nintek | Sleep | 193 | > > | NULL > > | > > | 13 | rt_nintek | localhost | rt_nintek | Query | 203 | > > User lock | SELECT > > GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600) | > > | 399 | rt_nintek | localhost | rt_nintek | Query | 236 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 400 | rt_nintek | localhost | rt_nintek | Query | 234 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 401 | rt_nintek | localhost | rt_nintek | Query | 230 | > > User lock | SELECT > > GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) | > > | 402 | rt_nintek | localhost | rt_nintek | Query | 203 | > > User lock | SELECT > > GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600) | > > | 403 | rt_nintek | localhost | rt_nintek | Sleep | 2 | > > | NULL > > | > > | 411 | rt_nintek | localhost | rt_nintek | Sleep | 127 | > > | NULL > > | > > | 413 | rt_nintek | localhost | rt_nintek | Sleep | 127 | > > | NULL > > | > > | 415 | rt_nintek | localhost | rt_nintek | Sleep | 47 | > > | NULL > > | > > | 416 | rt_nintek | localhost | rt_nintek | Sleep | 0 | > > | NULL > > | > > | 417 | rt_nintek | localhost | rt_nintek | Sleep | 1 | > > | NULL > > | > > | 418 | rt_nintek | localhost | rt_nintek | Sleep | 1 | > > | NULL > > | > > > > 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 > > > > > > > > > > > > > _______________________________________________ > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > Community help: http://wiki.bestpractical.com Commercial support: > > [EMAIL PROTECTED] > > > > > > Discover RT's hidden secrets with RT Essentials from > O'Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com > > -- > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
