I migrate last week an OTRS server 3.1 on RedHat EL5 to another server on Centos 6.5. After this, update to version 3.2 (can't update to 3.3 actually because of some computers with outdated browsers...).
All is ok, people can see tickets and work on them... Faster than before for users, but not when creating new tickets.
When someone try to create a ticket, complete fields and send it : browser nead at least 15-20 secondes to create ticket, and many times we got "The gateway did not receive a timely response from the upstream server or application."
Having a look on var/log/httpd/error_log...
(URL address is fine, I just can't give it on Internet...)Timeout waiting for output from CGI script /opt/otrs/bin/cgi-bin/index.pl, referer: http://xxx/otrs/index.pl?Action=AgentTicketPhone
Script timed out before returning headers: index.pl, referer: http://xxx/otrs/index.pl?Action=AgentTicketPhone
I read many posts about it, seems to be an MySQL workload problem... Application is on use since 2010 so much articles on database.
I can't purge all database, and I try to use archive option on generic jobs... no result, seems to fail (always same number of tickets marked for archive)
Someone know a tip for that? Before I had to copy and manually purge database...
Thanks.