@Tonyrealzy use this template
add your slackID in the comment

Description

Fixing the Unique constraint violation bug that occurs when inserting records into the org_roles table.

Acceptance Criteria

• Analyze the database logic to determine where and why the constraint violation occurs.

• Verify if the application logic correctly handles duplicate entries before insertion.

• Propose and implement fixes, which may include:
  1. Adding proper uniqueness checks.
  2. Handling conflicts gracefully.
  3. Ensuring idempotent/unique inserts.

• Conduct testing to confirm that the issue no longer occurs under normal and concurrent operations.
  This would be handled by tonyrealzy

Purpose

The purpose of this task is to identify and resolve the unique constraint violation issue occurring in the org_roles table. This will ensure that duplicate entries are prevented, data integrity is maintained, and the application logic correctly handles record insertions. By addressing this issue, I aim to enhance system reliability, improve error handling, and optimize database performance.

Expected Outcome

• The application should no longer attempt duplicate insertions that violate the unique constraint.
• Proper error handling and logging should be in place to capture and manage conflicts.
• The database integrity should be maintained, ensuring that roles are inserted only when necessary.
• Performance and concurrency should remain stable without introducing additional bottlenecks.

@omotomiwa26
This correction has been effected. Thank you