somehow the numbers shown in the groups overview for the trust levels 0-4 are wrong (too high)
We do only currently have 439 user (plus system and discobot). (we had more users in the past)
But the group overview does show:
well even after 12 hours they are still incorrect, all values from trust level 0 to trust level 4 were only reduced by 2 (for whatever reason). All other group counters seem to be correct.
no the last user delete had been already two days ago.
In the last 14 days I did only delete 7 users.
I did delete in the last 1,5 years more than 2000 users. We do have the plugin autosupend in place and are auto supending users that are more than 365 days without activity.These autosuspended users and all their data I do then delete at least once a week, so that we remain EU-GDPR compliant.
Sidekick is working fine, no dead jobs.
As far as I remember the number of jobs that did error out has also not changed in the last couple of days.
What is the queue 0f13eb003564dea87a7cc8f25560ba0e for?
Is that queue needed or should I delete it?
I think I found the problem, the table group_users does still have entries for user_id which do no longer exist and which are no longer in the table users. (in total 182 entries for 117 user_id which do not have a corresponding entry in users)
So somehow the database has some inconsistencies. I do not know how this has happened.
And now the question is, how I can solve it now?
Just manually delete with a sql statement the entries from group_users for which no entry does exist in users?