Slow after upgrade OTRS 4 to 5 / 6
Moderator: crythias
-
- Znuny newbie
- Posts: 78
- Joined: 30 Jan 2014, 15:27
- Znuny Version: 4.0.19
- Location: Poland
- Contact:
Slow after upgrade OTRS 4 to 5 / 6
I've made an OTRS system update from 4.0.19 to 5.0.41
There are no errors in the system logs, but unfortunately the queue preview (AgentTicketQueue) is now much slower.
The longest queue loading time on version 4 is 9s. and on version 5 it is 22s.
Why such a significant drop in performance?
There are no errors in the system logs, but unfortunately the queue preview (AgentTicketQueue) is now much slower.
The longest queue loading time on version 4 is 9s. and on version 5 it is 22s.
Why such a significant drop in performance?
Last edited by andy17d on 13 Feb 2021, 18:12, edited 1 time in total.
OTRS 4.0.19/6.0.26, openSUSE 12, MySQL 5.5
KodIT Usługi Informatyczne - Odzyskiwanie danych Poznań - Serwis Komputerowy
KodIT Usługi Informatyczne - Odzyskiwanie danych Poznań - Serwis Komputerowy
-
- Administrator
- Posts: 4002
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Slow after upgrade OTRS 4 to 5.
Hi,
I would not invest a single minute to search for this issue until the system is upgraded to 6. Version 5 is end-of-life for a long time.
Maybe your issue is solved after you move to the next version.
- Roy
I would not invest a single minute to search for this issue until the system is upgraded to 6. Version 5 is end-of-life for a long time.
Maybe your issue is solved after you move to the next version.
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny superhero
- Posts: 635
- Joined: 24 Feb 2012, 03:58
- Znuny Version: LTS and Features
- Real Name: Mo Azfar
- Location: Kuala Lumpur, MY
- Contact:
Re: Slow after upgrade OTRS 4 to 5.
1. Go for latest version 1st.
2. If still happen, you may try to optimize the table.
https://doc.otrs.com/doc/manual/admin/6 ... base-mysql
For postgresql, try to use vacuum.
good luck
2. If still happen, you may try to optimize the table.
https://doc.otrs.com/doc/manual/admin/6 ... base-mysql
For postgresql, try to use vacuum.
good luck
My Github
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This
Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This
Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
-
- Znuny newbie
- Posts: 78
- Joined: 30 Jan 2014, 15:27
- Znuny Version: 4.0.19
- Location: Poland
- Contact:
Re: Slow after upgrade OTRS 4 to 5.
Following your advice, I made next upgrade to version 6.0.26.
I also optimized mysql tables.
Unfortunately, it gets even worse
Loading my largest queue view takes accordingly:
ver. 4 - 9 sec, ver. 5 - 22 sec, ver. 6 - 40 sec.
I also optimized mysql tables.
Unfortunately, it gets even worse
Loading my largest queue view takes accordingly:
ver. 4 - 9 sec, ver. 5 - 22 sec, ver. 6 - 40 sec.
OTRS 4.0.19/6.0.26, openSUSE 12, MySQL 5.5
KodIT Usługi Informatyczne - Odzyskiwanie danych Poznań - Serwis Komputerowy
KodIT Usługi Informatyczne - Odzyskiwanie danych Poznań - Serwis Komputerowy
-
- Znuny superhero
- Posts: 890
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: Slow after upgrade OTRS 4 to 5 / 6
Any errors/messages in the support data collector (admin area)?
Are other pages working fine?
Do you have a lot of escalated tickets?
— Emin
Are other pages working fine?
Do you have a lot of escalated tickets?
— Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Znuny superhero
- Posts: 635
- Joined: 24 Feb 2012, 03:58
- Znuny Version: LTS and Features
- Real Name: Mo Azfar
- Location: Kuala Lumpur, MY
- Contact:
Re: Slow after upgrade OTRS 4 to 5.
try on article_data_mime or maybe any table start with article* and ticket*
EDIT: additionally, also check the performance tuning url in TicketIndexModule section
Last edited by skullz on 14 Feb 2021, 16:10, edited 1 time in total.
My Github
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This
Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This
Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
-
- Administrator
- Posts: 4002
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Slow after upgrade OTRS 4 to 5 / 6
Hi,
Do you move to a new server? Do you use the S, M or L view?
- Roy
Do you move to a new server? Do you use the S, M or L view?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 78
- Joined: 30 Jan 2014, 15:27
- Znuny Version: 4.0.19
- Location: Poland
- Contact:
Re: Slow after upgrade OTRS 4 to 5 / 6
Honestly, I've never used a data collector. I'll check it.
Other pages works fine - only queue view are very slow.
Escalation is enabled.
There are many ticket that should be escalated. This is a test machine and there is a copy of the production database from 2 years ago and no one is closing tickets there.
Everything is on the same server (virtual machine)
S view.
Edit:
After disabling escalation in individual queues, their preview loads instantly.
However, productively escalation must be enabled.
OTRS 4.0.19/6.0.26, openSUSE 12, MySQL 5.5
KodIT Usługi Informatyczne - Odzyskiwanie danych Poznań - Serwis Komputerowy
KodIT Usługi Informatyczne - Odzyskiwanie danych Poznań - Serwis Komputerowy
-
- Znuny superhero
- Posts: 890
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: Slow after upgrade OTRS 4 to 5 / 6
That sounds familiar.
There was a bug that caused long loading times on the ticket overview if too many tickets escalated (with long escalation times).
I guess that one didn't get fixed entirely.
I can't validate that but it might be a case for https://github.com/znuny/Znuny/issues
— Emin
There was a bug that caused long loading times on the ticket overview if too many tickets escalated (with long escalation times).
I guess that one didn't get fixed entirely.
I can't validate that but it might be a case for https://github.com/znuny/Znuny/issues
— Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Znuny wizard
- Posts: 381
- Joined: 20 Sep 2010, 16:54
- Znuny Version: OTRS 6 CE
- Real Name: Alexey Yusov
- Company: Radiant System Group s.r.o
- Location: Prague
- Contact:
Re: Slow after upgrade OTRS 4 to 5 / 6
Try to rebuild Ticket Index - https://doc.radiantsd.com/doc/manual/ad ... otrs-index
Alexey Yusov
Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal
Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal
Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
-
- Administrator
- Posts: 4002
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Slow after upgrade OTRS 4 to 5 / 6
The calculation of escalations can be very slow and increases with
a) the amount of escalated tickets and
b) with the duration of the escalation.
I guess you have many, old tickets on your test system which are escalated. If this is the same in production it looks more like an organizational issue to me
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?