Attendances are duplicated for a session in a batch

[rathorevaibhav]

Describe the task
For batch 1106, there is a deleted session which has 52 entries for attendnaces, although the student in the batch are only 26. Somehow, a duplicate set of attendance has been created.
Run this query to get these attendances:

select * from attendances where session=23928 order by updated_by_frontend, program_enrollment;

Expected behavior
There seems to be a hidden bug in the system that is creating a duplicate set of attendances. Notice the result from the above query, the set of attendances are 10 seconds apart in their created_at field.

Identify the edge case and scenario when this is happening and find the root cause.

[Mariamraza15]

Same error occuring in this batch - https://sis-new.medha.org.in/batch/1116
This is closed but students have attendances more than 100%

[Kirtigour]

@rathorevaibhav, there is another same issue in the batch - https://sis-new.medha.org.in/batch/1096
Students have more than 100% attendance, and there is a session which has 160% attendance.