OTRS slow after upgrade to 3.3.4

Moderator: crythias

Post Reply
cacamontes
Znuny newbie
Posts: 4
Joined: 25 Feb 2014, 13:59
Znuny Version: 3.3.4

OTRS slow after upgrade to 3.3.4

Post by cacamontes »

Hello,

I have upgraded my OTRS Helpdesk from 3.2.6 to 3.3.4.
I have notice that the OTRS is slower now. In the server I get a perl.exe process with 20%-25% CPU usage during 4sec-5sec for each activity. Some times we have several perl.exe processes leading to a 100% CPU usage.

Is there anything we must take in consideration after upgrading to 3.3.4.

We have a Windows 2003 64bit server, with Apache and mySql.
We have upgraded using the installer.

Best regards.
Wolfgangf
Znuny ninja
Posts: 1029
Joined: 13 Apr 2009, 12:26
Znuny Version: 6.0.13
Real Name: Wolfgang Fürtbauer
Company: PBS Logitek GmbH
Location: Pinsdorf

Re: OTRS slow after upgrade to 3.3.4

Post by Wolfgangf »

Did you already run the support assessment in order to check where are potential performance optimizations are possible?
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
cacamontes
Znuny newbie
Posts: 4
Joined: 25 Feb 2014, 13:59
Znuny Version: 3.3.4

Re: OTRS slow after upgrade to 3.3.4

Post by cacamontes »

Hello Wolfgangf,

Thank you for your help.
Running the support assessment I've noticed that "LoadModule perl_module modules/mod_perl.so" is commented in the httpd.conf file. I've tryed to uncoment and the Apache doesn't start. The Apache error is:

Code: Select all

httpd.exe: Syntax error on line 503 of E:/OTRS/Apache/conf/httpd.conf: Cannot load E:/OTRS/Apache/modules/mod_perl.so into server: The specified module could not be found
the mod_perl.so is in the "E:/OTRS/Apache/modules" directory.

I've look into the viewtopic.php?f=62&t=5324 in order to install the mod_perl again, but when searching for a mod_perl build to install I've found this link http://code.activestate.com/ppm/mod_perl/ saying the there is no mod_perl build for perl 5.16.

I do not know what to do now.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS slow after upgrade to 3.3.4

Post by jojo »

switch to Linux
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Rotyn
Znuny newbie
Posts: 68
Joined: 21 Aug 2012, 17:11
Znuny Version: 3.3.5
Real Name: Rudy

Re: OTRS slow after upgrade to 3.3.4

Post by Rotyn »

"Switch to Linux" is a useless remark but not dealing with the problem

To solve your mod_perl problem, check out this: http://blogs.perl.org/users/phred/2012/ ... ility.html
Testing & Productive: OTRS::ITSM 3.3.5 on CentOS 6.5 and MySQL
Packages: All included
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS slow after upgrade to 3.3.4

Post by jojo »

Windows is not a safe platform for the future of using PERL based webapplications so the answer is not useless.

I strongly advice not to use Windows as a server for OTRS
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Andre Bauer
Znuny guru
Posts: 2189
Joined: 08 Dec 2005, 17:01
Znuny Version: 5.0.x
Real Name: André Bauer
Company: Magix Software GmbH
Location: Dresden
Contact:

Re: OTRS slow after upgrade to 3.3.4

Post by Andre Bauer »

so maybe it would be a good idea to remove the windows installer from otrs.com's download area?

http://ftp.otrs.org/pub/otrs/otrs-3.3.5 ... -3.0.4.exe
Prod: Ubuntu Server 16.04 / Zammad 1.2

DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!

OtterHub.org
cacamontes
Znuny newbie
Posts: 4
Joined: 25 Feb 2014, 13:59
Znuny Version: 3.3.4

Re: OTRS slow after upgrade to 3.3.4

Post by cacamontes »

Hello all,

The problem is solved now. The link Rotyn sent helped (thank you Rotyn). There is a new mod_perl compiled in this link http://people.apache.org/~stevehay/

Please update the OTRS windows installer with the correct mod_perl

Best regards
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS slow after upgrade to 3.3.4

Post by jojo »

actuall mod_perl will not run stable on windows. That's why it is not included in the installer
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
cacamontes
Znuny newbie
Posts: 4
Joined: 25 Feb 2014, 13:59
Znuny Version: 3.3.4

Re: OTRS slow after upgrade to 3.3.4

Post by cacamontes »

Yes Jojo, it is very unstable.. I've got several errors including "Can't connect to MySQL server on 'localhost' (10049)".

I'm going do deactivate the mod_perl load in the apache httpd.conf. Going for a slower solution, instead of a faulty one.

I'm thinking in installing a Suse Linux for OTRS and upload all the configurations and database from old version.
Post Reply