[Users] Zimbra extemely slow when accessing mounted folder - shared mailbox toolkit?

[Lorenzo Milesi]

Hi. 

I'm experiencing a weird situation: userA has info@ mounted in his mailbox. When accessing the mounted Inbox folder it takes minutes to load, killing MySQL. If I open info@ directly (a rather huge mailbox) inbox loads instantly. 

I found in mysql processlist a query running several times with the same parameters: 
SELECT [ http://mi.id/ | mi.id ] , mi.type, mi.parent_id, mi.folder_id, mi.prev_folders, mi.index_id,mi.imap_id, mi.date, mi.size, mi.locator, mi.blob_digest, mi.unread, mi.flags, mi.tag_names, mi.subject, [ http://mi.name/ | mi.name ] , mi.metadata, mi.mod_metadata, mi.change_date, mi.mod_content, mi.uuid, mi.unread AS sortcol 
FROM mboxgroup19.mail_item AS mi 
WHERE mi.mailbox_id = 19 AND ((mi.type = 0x05 OR mi.type = 0x10) AND mi.folder_id = 2) 
ORDER BY sortcol DESC, [ http://mi.id/ | mi.id ] DESC LIMIT 9045,2000 

It's run with different LIMIT values, but what it's weird when it reaches a certain value it starts again from 0, looping through this for several times. 

This is a newly installed server migrated from an old one with Zextras migration tool. No such problem was reported on the old installation (8.0.5). 

I don't know if it was a coincidence, but it has been reported after installing shared-mailbox-toolkit extension. These shares were implemented before this extension's installation and were migrated by the tool. I tried removing s-m-t extensions and restarting Zimbra but the problem still persists so it can be unrelated. 

Any other hint is welcome. 
thanks 
-- 
Lorenzo Milesi - lorenzo.milesi at yetopen.it 




YetOpen S.r.l. - https://www.yetopen.it/
Via Salerno 18 - 23900 Lecco - ITALY -
Tel +39 0341 220 205 - Fax +39 178 6070 222

Think green - Non stampare questa e-mail se non necessario / Don't print this email unless necessary

-------- D.Lgs. 196/2003 e GDPR 679/2016 --------
Tutte le informazioni contenute in questo messaggio sono riservate ed a uso esclusivo del destinatario.
Tutte le informazioni ivi contenute, compresi eventuali allegati, sono da ritenere confidenziali e riservate secondo i termini
del vigente D.Lgs. 196/2003 in materia di privacy e del Regolamento europeo 679/2016 - GDPR - e quindi ne e' proibita l'utilizzazione ulteriore non autorizzata.
Nel caso in cui questo messaggio Le fosse pervenuto per errore, La invitiamo ad eliminarlo senza copiarlo, stamparlo, a non inoltrarlo a terzi e ad avvertirci non appena possibile.
Grazie.

Confidentiality notice: this email message including any attachment is for the sole use of the intended recipient and may contain confidential and privileged information;
pursuant to Legislative Decree 196/2003 and the European General Data Protection Regulation 679/2016 - GDPR - any unauthorized review, use, disclosure or distribution
is prohibited. If you are not the intended recepient please delete this message without copying, printing or forwarding it to others, and alert us as soon as possible.
Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.zetalliance.org/pipermail/users_lists.zetalliance.org/attachments/20200521/590cb1e7/attachment.html>