I have tickets with several hundred articles (on the order of 500 in some cases), they do take a few moments to load; but it does load. I'm on very similar hardware, VMWare with Intel CPUs, 8 CPU, 16gb RAM and 10k RPM spinning storage using CentOS 7.7, apache2, and mod_perl with MariaDB. However, I'm on the latest version of OTRS. I'd suggest running the database check/repair from otrs.Console.pl and upgrading to the latest v6 release. On 1/3/2020 8:30 PM, Jeff Johnson wrote:
Greetings,
I have (had) a well functioning OTRS6 system until a ticket hit 120+ articles. Now when that ticket is opened by an agent the browser becomes unresponsive and the server otrs/cgi process hits 100% CPU and stays there.
Ver: 6.0.11 OS: CentOS 7.7 x86_64, Apache2, mod_perl DB: mariadb Host: 4CPU(2.4GHz) 12GB RAM VMWare VM on quad socket Opteron host. SSD storage. Backend mail: IMAP
In an attempt to fix this I have archived many old closed tickets. Optimized the tables in mariadb, used mod_perl. Even tried dialing down Ticket::Frontend::MaxArticlesPerPage and Ticket::Frontend::MaxArticlesZoomExpand down to 10 in hopes of limiting the amount of articles opened or indexed when the ticket was zoomed (or looked at from agent view).
None of that worked. Throwing hardware (cores, ram) doesn't fix it.
Do I split the ticket? Is there a setting where it won't try and open all 122 articles just to display the most recent article?
Thanks!
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
-- --------------- Email Signature Nick Bright - VICE PRESIDENT OF TECHNOLOGY P: 888.332.1616 W: valnet.net https://valnet.net F: Facebook https://www.facebook.com/ValnetISP/ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.