Slow performance (only when opening a tickets)

[jkoolen]

Dear all,

I just installed the lates version of OTRS (3.0.3) on a virtual server (2 Processors, 4GB RAM, 150GB HDD) running Windows Server Standard 2008 R2 64-bit.

The application works fine, but is verry slow from time to time. httpd.exe uses a lot of CPU power at those moments.

All checks in Admin\Support Assessment are green, zo it seems like the configuration is ok.

Has someone experienced this kind of problem before?

Kind regards,

Jeroen Koolen

[Mothra]

Yes, I have found the same on a virtual server of the same spec, but running SLES 10. I get pages partially loading, with all of the links and fields deactivated. I'm afraid I haven't found a solution to it, but forcing a page refresh in the browser sometimes helps to reload the page into a fully working state.

[jkoolen]

At first it looked like it had something to do with one of the Apache modules included with the new version, since we have been running the previous version of OTRS on the same configuration without a problem.

I searched the web fo known problems regarding Apache on a WIndows Server 2008 R2 64bit but couldn't find any.

Then I started clicking around in OTRS 3.0 and noticed that the problem allmost only occures when I try to open a ticket. All other pages (including the normally slow Admin\Support Assessment) run ok.

Could there be a problem in the "ViewTicket" code?

[appieheijn]

I'm having the same problem.
I installed OTRS 3.0.2 on a fresh CentOS 5.5 x86_64 machine.
When i click around in OTRS, opening and closing tickets, my server load goes skyhigh (Load average of 40).

If I run top, it displays only httpd processes on the first 20 lines.

top - 16:46:01 up 1 day, 4:43, 2 users, load average: 22.33, 20.53, 15.69
Tasks: 142 total, 24 running, 118 sleeping, 0 stopped, 0 zombie
Cpu(s): 99.8%us, 0.2%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1024768k total, 950124k used, 74644k free, 59224k buffers
Swap: 2064376k total, 14448k used, 2049928k free, 553360k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25392 apache 25 0 248m 7444 1836 R 10.3 0.7 1:15.83 httpd
25393 apache 25 0 248m 7676 1892 R 10.3 0.7 1:15.76 httpd
25394 apache 25 0 248m 7604 1904 R 10.3 0.7 1:15.64 httpd
25398 apache 25 0 247m 7140 1724 R 10.3 0.7 1:19.87 httpd
25399 apache 25 0 248m 7788 1896 R 10.3 0.8 1:17.70 httpd
25405 apache 25 0 248m 7236 1776 R 10.3 0.7 1:15.69 httpd
25406 apache 25 0 248m 7568 1836 R 10.3 0.7 1:12.49 httpd
25433 apache 25 0 248m 7480 1832 R 10.3 0.7 1:12.88 httpd
25434 apache 25 0 247m 6652 1284 R 10.3 0.6 1:12.68 httpd
25435 apache 25 0 247m 6652 1284 R 10.3 0.6 1:12.38 httpd
25438 apache 25 0 247m 6652 1284 R 10.3 0.6 1:15.03 httpd
25441 apache 25 0 248m 6944 1460 R 10.3 0.7 1:12.28 httpd
25456 apache 25 0 247m 6652 1284 R 10.3 0.6 1:11.79 httpd
25468 apache 25 0 248m 7264 1804 R 10.3 0.7 0:30.55 httpd
25469 apache 25 0 248m 7552 1900 R 10.3 0.7 0:30.09 httpd
25447 apache 25 0 248m 7484 1848 R 10.0 0.7 1:11.12 httpd

If I have a look at the server-status page (mod_status) it shows a lot of unknown "Reading" processes
Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
0-0 25392 0/7/7 R 0.72 743 1 0.0 0.01 0.01 ? ? ..reading..
1-0 25393 0/6/6 R 1.88 743 1 0.0 0.10 0.10 ? ? ..reading..
2-0 25394 0/5/5 R 1.26 743 2 0.0 0.13 0.13 ? ? ..reading..
3-0 25395 0/5/5 R 0.63 743 1 0.0 0.38 0.38 ? ? ..reading..
4-0 25396 0/7/7 R 1.96 743 74 0.0 0.11 0.11 ? ? ..reading..
5-0 25397 0/4/4 R 1.32 743 1 0.0 0.31 0.31 ? ? ..reading..
6-0 25398 0/3/3 R 0.38 748 1 0.0 0.00 0.00 ? ? ..reading..
7-0 25399 0/4/4 R 0.48 743 3737 0.0 0.09 0.09 ? ? ..reading..
8-0 25405 0/4/4 R 1.19 744 74 0.0 0.02 0.02 ? ? ..reading..
9-0 25406 0/5/5 R 0.64 743 174 0.0 0.32 0.32 ? ? ..reading..

I'm using the default otrs configuration file included in a virtual host.
I'm also using mod_perl.


I have'nt got a clue where to look for a solution. Anyone here does?