XF 2.2 Page takes long time to load or times out, after admin or moderator logs in.

[hoks]

After an administrator or moderator logs in, the resulting page will take a very long time to load, and usually caused time out.
But no issues for regular users.

I notice this SQL that is stuck in executing for several minutes

SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_User_5`.*
            FROM `xf_post`
            LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '364')
LEFT JOIN `xf_user` AS `xf_user_User_5` ON (`xf_user_User_5`.`user_id` = `xf_post`.`user_id`)
            WHERE (`xf_post`.`post_id` IN ( `<A really long list of post IDs>` ))

Is this rebuilding some permission cache?
Why does it run only when an admin or moderator logs in?

Any workarounds?

 

[BrettC]

Are you using any addons that allow user-thread moderation permissions? For example, a resource like this: https://xenforo.com/community/resources/collaborative-threads.6600/ ?

Do you have caches set correctly (Redis, Memcache, etc.)?