Other index have also been wrong, including showing ZERO tickets when there are actually tickets, making the folder not appear in the normal view - leading agents to not know there is help requests open

permissions-en shows 4, when there are actually only 3

Is this still occurring?

I'm seeing at least off-by-one errors on multiple queues, stewards queue right now is off by 2

still occurring. permissions-en shows 2 and it's only one
permissions-commons shows 174 but it's 176

I'm not sure how to remedy this issue. I see we switched to StaticDB in T355979, perhaps we need to rebuild the StaticDB index?

$ sudo -u otrs /opt/otrs/bin/otrs.Console.pl|grep Index
 Dev::Package::RepositoryIndex                                     - Generate an index file (otrs.xml) for a package repository.
 Maint::Ticket::EscalationIndexRebuild                             - Completely rebuild the ticket escalation index.
 Maint::Ticket::FulltextIndex                                      - Flag articles to automatically rebuild the article search index or displays the index status.
 Maint::Ticket::FulltextIndexRebuildWorker                         - Rebuild the article search index for needed articles.
 Maint::Ticket::QueueIndexCleanup                                  - Cleanup unneeded entries from StaticDB queue index.
 Maint::Ticket::QueueIndexRebuild                                  - Rebuild the ticket index for AgentTicketQueue.

@Xaosflux Perhaps this is a bug... From what I can see, some counts are accurate while others aren't. Also, is it possible that some queues are configured differently? Maybe the count you see is influenced by the permissions you have in relation to the queue?

Please provide actual examples which counts are not accurate. I cannot reproduce it.

My screenshot in the description shows it (185 vs 134) . Also, it was intermittently jumping all around, including down to zero; perhaps related to other processes crashing from T408632?

The off-by-one issue seems to be different.

Cannot reproduce that, looks good to me currently.

Iv' checked som:
permission-commons ok
permission-en (2 vs 1)
permission-nl (5 vs 4)
permission-zh (13 vs 4)
wm-br (5 vs 3)
wm-fr (12 vs 6)

All provided examples appear correct to me. The number for the main queue is always including the numbers for it's sub-queues.