After Update to 23.1, eGroupware floods MySQL with queries.
Client running Windows + Thunderbird 102.9.0 starts to sync eGroupware Calendar + eGroupware Infolog via GroupDAV. Calendar sync is successful (once), Infolog sync will start an endless loop in eGroupware. The MySQL backend reports queries:
SELECT SQL_CALC_FOUND_ROWS main.info_id AS info_id,info_datemodified,info_uid,caldav_name,info_subject,info_status,info_owner,GROUP_CONCAT(attendees.account_id) AS info_responsible,GROUP_CONCAT(attendees.info_res_attendee) AS info_cc FROM egw_infolog main LEFT JOIN egw_infolog_users ON main.info_id=egw_infolog_users.info_id LEFT JOIN egw_infolog_users attendees ON main.info_id=attendees.info_id AND attendees.info_res_deleted IS NULL WHERE ( (info_owner=17 OR (egw_infolog_users.account_id IN (’-1’,‘17’)) OR (egw_infolog_users.account_id IN (’-1’,‘17’) OR info_status = ‘offer’ AND info_owner=17) AND (info_access=‘public’ OR info_owner=17)) AND NOT (info_status IN (‘template’,‘nonactive’,‘archive’)) AND info_type=‘task’ AND info_datemodified>1678956815 ) GROUP BY main.info_id ORDER BY info_datemodified DESC LIMIT 0,500
SELECT FOUND_ROWS()
(repeat ad infinitum with 100% CPU usage, until eGroupware is stopped with “sudo systemctl restart docker”).
User #17 is unable to sync any calendar until eGroupware is restarted.
When any other user starts to sync his/her infolog, eGroupware enters the same endless loop, with different user ID and different info_datemodified.
When I submit the SQL query manually, there is an empty result set (i.e. no recent changes).
I tried to track the error down to Thunderbird, but eGroupware does not send any infolog-related HTTP reply to Thunderbird at all, only calendar-related requests and replies are logged in the log which I have enabled in eGroupware-Preferences-CalDAV/CardDAV Sync-Logging.
