[SOLVED] OTRS Agent Ticket Status View slow

[skullz]

Hi,

After upgrade to latest OTRS 5 from OTRS 4.07, Agent Ticket Status View running slow..its take almost a few minute to load it.
we dont have this issue when on 4.0.7. It has almost 2000 open ticket (as admin).

OS : Centos 7
DB: Postgresql (remote)
Both server on 8gb ram each

As per here https://bugs.otrs.org/show_bug.cgi?id=13940, this query may be the solution, but its for otrs 6.

Code: Select all

create index concurrently idx_article_data_mime_article_id on
article_data_mime(article_id);

any opinion on this ? Thanks

UPDATE:

So, im tested these and the screen view go fast again..at least for now.

1. rebuild index

Code: Select all

su -m otrs -c "/opt/otrs/bin/otrs.Console.pl Maint::Ticket::FulltextIndex --rebuild"
su -m otrs -c "/opt/otrs/bin/otrs.Console.pl Maint::Ticket::FulltextIndexRebuildWorker"
su -m otrs -c "/opt/otrs/bin/otrs.Console.pl Maint::Ticket::QueueIndexRebuild"

2. Force the Status view, queue view in Medium mode at sysconfig (this one do the trick)

[skullz]

Look like the small view is the culprit..
Eventhough I can force the Medium view, now im missing availability to filter a ticket in status view, queue view..

[skullz]

Solved by vacuum few tables in DB

[Greg]

Hi skullz,
We have the same issue after upgrading to OTRS 6.
Medium view is a workaround, but it preferable to fix Small view.
Could you please provide list of tables which we should vacuum?

[skullz]

Hi skullz,
We have the same issue after upgrading to OTRS 6.
Medium view is a workaround, but it preferable to fix Small view.
Could you please provide list of tables which we should vacuum?

ticket, ticket_history, article_data_mime

good luck