Hi,
Thanks @bojan.
The issue definitely “prevents normal/typical use of MainWP” (as mentioned in the “Bugs” category).
@josklever, it’s the other way around. We managed a lot of sites (thousands), which as you can imagine use all kinds of different plugins. And yes, the issue is with the amount of plugins listed on the page, not the number of available updates.
I’m sharing some more technical details that might help the dev team to narrow down the exact root of the issue. This is an “strace” of the running PHP process that loads the page.
sendto(14, "\1\0\0\0\16", 5, MSG_DONTWAIT, NULL, 0) = 5
poll([{fd=14, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=14, revents=POLLIN}])
recvfrom(14, "\7\0\0\1\0\0\0\2\0\0\0", 32768, MSG_DONTWAIT, NULL, NULL) = 11
sendto(14, "d\0\0\0\3SELECT name, value FROM wp_options WHERE wpid = 497 AND name IN ('rollback_updates_data')", 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=14, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=14, revents=POLLIN}])
recvfrom(14, "\1\0\0\1\2S\0\0\2\3def\rmanage2_2_wp1\24wp_options\24wp_options\4name\4name\f\366\0\374\377\3\0\374\21\20\0\0\0U\0\0\3\3def\rmanage2_2_wp1\24wp_options\24wp_options\5value\5value\f\366\0\377\377\377\377\374\21\20\0\0\0\5\0\0\4\376\0\0\2\0\5\0\0\5\376\0\0\2\0", 32768, MSG_DONTWAIT, NULL, NULL) = 199
sendto(14, "\1\0\0\0\16", 5, MSG_DONTWAIT, NULL, 0) = 5
poll([{fd=14, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=14, revents=POLLIN}])
recvfrom(14, "\7\0\0\1\0\0\0\2\0\0\0", 32768, MSG_DONTWAIT, NULL, NULL) = 11
sendto(14, "d\0\0\0\3SELECT name, value FROM wp_options WHERE wpid = 993 AND name IN ('rollback_updates_data')", 104, MSG_DONTWAIT, NULL, 0) = 104
poll([{fd=14, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=14, revents=POLLIN}])
recvfrom(14, "\1\0\0\1\2S\0\0\2\3def\rmanage2_2_wp1\24wp_options\24wp_options\4name\4name\f\366\0\374\377\3\0\374\21\20\0\0\0U\0\0\3\3def\rmanage2_2_wp1\24wp_options\24wp_options\5value\5value\f\366\0\377\377\377\377\374\21\20\0\0\0\5\0\0\4\376\0\0\2\0\5\0\0\5\376\0\0\2\0", 32768, MSG_DONTWAIT, NULL, NULL) = 199
sendto(14, "\1\0\0\0\16", 5, MSG_DONTWAIT, NULL, 0) = 5
poll([{fd=14, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=14, revents=POLLIN}])
recvfrom(14, "\7\0\0\1\0\0\0\2\0\0\0", 32768, MSG_DONTWAIT, NULL, NULL) = 11
sendto(14, "e\0\0\0\3SELECT name, value FROM wp_options WHERE wpid = 1253 AND name IN ('rollback_updates_data')", 105, MSG_DONTWAIT, NULL, 0) = 105
poll([{fd=14, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=14, revents=POLLIN}])
recvfrom(14, "\1\0\0\1\2S\0\0\2\3def\rmanage2_2_wp1\24wp_options\24wp_options\4name\4name\f\366\0\374\377\3\0\374\21\20\0\0\0U\0\0\3\3def\rmanage2_2_wp1\24wp_options\24wp_options\5value\5value\f\366\0\377\377\377\377\374\21\20\0\0\0\5\0\0\4\376\0\0\2\0\5\0\0\5\376\0\0\2\0", 32768, MSG_DONTWAIT, NULL, NULL) = 199
sendto(14, "\1\0\0\0\16", 5, MSG_DONTWAIT, NULL, 0) = 5
This keeps running for about ~5 min which looks to loop over all the sites (wipd) in the “rollback_updates_data” row (wp_options) table. In the row, there was only 1 mentioned plugin which I suspected was causing the issue - we removed the site using it and re-tested the menu. It still struggling the same and the strace is also the same (going over the “rollback_updates_data” row, however it doesn’t exist anymore?), so not quite sure what it does exactly but it runs for very long.
It looks to be used in quite a few functions but my guess would be it’s from (could be wrong):
mainwp/pages/page-mainwp-plugins.php
mainwp/pages/page-mainwp-updates-handler.php
Thanks again!
Martin G.