This is quite easy to do -- I can make a report across all of the wikis and leave it for @Trizek-WMF and communities to handle it.

There's a significant number of mentors who are not listed, see https://docs.google.com/spreadsheets/d/16vMJzoxF_OyxAFtTtEx70hadU8MDbFdOpeNNNUMJmAc/edit?usp=sharing.

@Trizek-WMF I feel it would be nice to do something about the mentors who are not listed, but I'm not sure what. Perhaps inform affected communities only?

In T323031#8416631, @Urbanecm_WMF wrote:

@Trizek-WMF I feel it would be nice to do something about the mentors who are not listed, but I'm not sure what. Perhaps inform affected communities only?

Mentors who are "not listed" have mentees, but aren't visible on the structured mentors list, right? Are they the ones tagged as "Not a mentor" on your spreadsheet?

In T323031#8417731, @Trizek-WMF wrote:

In T323031#8416631, @Urbanecm_WMF wrote:

@Trizek-WMF I feel it would be nice to do something about the mentors who are not listed, but I'm not sure what. Perhaps inform affected communities only?

Mentors who are "not listed" have mentees, but aren't visible on the structured mentors list, right? Are they the ones tagged as "Not a mentor" on your spreadsheet?

Correct. Sorry for not making that more clear.

Also, as a reminder, this is how you can see the list of someone's mentees: https://en.wikipedia.org/w/api.php?action=query&format=xml&list=growthmentormentee&gemmmentor=Martin_Urbanec_(WMF).

We discussed about this in the Growth Ambassadors meeting, and the agreement goes along the following plan:

1. send a message to these users, asking them to properly sign-up, with a deadline
2. when the deadline passes, then we reassign the mentees for the non-signed-up mentors.

@Urbanecm_WMF - the api call (and db query) still show that a mentor has some mentees assigned even though a mentor was removed from the list of mentor. Is there supposed to be a way to find mentees that still have un-listed mentors? Should we keep a track of mentors' status - like removed or something?

The example below from cswiki betalabs to illustrate that a mentor who was removed (manually from Special:ManageMentors or from MediaWiki:GrowthMentors.json) is still presented to mentees.

1. ET27 (user_id=30) is a mentor and is displayed as a mentor on Special:ManageMentors
2. One of ET27 mentees - ET73(user_id=214) logs in and sees ET27 as the mentor (CORRECT)
3. ET13 (as an admin) removes ET27 as a mentor (this revision of MediaWiki:GrowthMentors.json shows that id=30 (ET27) was removed. Special:ManageMentors doesn't display ET27 anymore (CORRECT)
4. After more than 24 hours, ET73(user_id=214) still sees ET27 as an assigned mentor (INCORRECT)

The api call shows ET27is still listed as a mentor with ET73 as a mentee (INCORRECT)
https://cs.wikipedia.beta.wmflabs.org/w/api.php?action=query&format=json&prop=&list=growthmentormentee&formatversion=2&gemmmentor=ET27

(cswiki)> select * from growthexperiments_mentor_mentee where gemm_mentor_id=30\G
*************************** 1. row ***************************
       gemm_mentee_id: 214
     gemm_mentor_role: primary
       gemm_mentor_id: 30
gemm_mentee_is_active: 0
*************************** 2. row ***************************
       gemm_mentee_id: 345
     gemm_mentor_role: backup
       gemm_mentor_id: 30
gemm_mentee_is_active: 1
2 rows in set (0.001 sec)

The same scenario happens on testwiki wmf13.

Hi @Etonkovidova,

Thanks for the report. I've followed the instructions at test.wikipedia, and I didn't manage to reproduce this issue. First, I enrolled as a mentor via my test account. Then, I claimed two user accounts:

21:06, 21 December 2022 Martin Urbanec (test) talk contribs block claimed Martin Urbanec (public) as their mentee (previous mentor NGC 54)
21:06, 21 December 2022 Martin Urbanec (test) talk contribs block claimed Martin Urbanec (WMF) as their mentee (previous mentor Martin Urbanec (WMF))

Then, I removed my test account as a mentor via my staff account. After a couple of seconds, both my mentees were reassigned to someone else (with a message explaining the removal):

21:07, 21 December 2022 Martin Urbanec (WMF) talk contribs block set Etonkovidova as the mentor of Martin Urbanec (public) (previous mentor Martin Urbanec (test)) (Martin Urbanec (WMF) removed Martin Urbanec (test) from mentorship)
21:07, 21 December 2022 Martin Urbanec (WMF) talk contribs block set NMW03 as the mentor of Martin Urbanec (WMF) (previous mentor Martin Urbanec (test)) (Martin Urbanec (WMF) removed Martin Urbanec (test) from mentorship)

My test account now no longer has any (primary) mentees:

mysql:[email protected] [testwiki]> select * from actor where actor_name='Martin Urbanec (test)';
+----------+------------+-----------------------+
| actor_id | actor_user | actor_name            |
+----------+------------+-----------------------+
|    36210 |      35167 | Martin Urbanec (test) |
+----------+------------+-----------------------+
1 row in set (0.002 sec)
mysql:[email protected] [testwiki]> select * from growthexperiments_mentor_mentee where gemm_mentor_id=35167 and gemm_mentor_role='primary';
Empty set (0.001 sec)

mysql:[email protected] [testwiki]>

My guess is that beta cluster has or had some issues with the job queue, resulting in the reassignment not happening. Can you please try this in production, and fill a new task if you can reproduce it there as well? Thanks!