Event Log

(psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_leave_balance_user_year_month"
DETAIL:  Key (user_id, year, month)=(2, 2025, 1) already exists.

[SQL: INSERT INTO leave_balances (user_id, year, month, credited, used, carry_forward_in, created_at, updated_at) VALUES (%(user_id)s, %(year)s, %(month)s, %(credited)s, %(used)s, %(carry_forward_in)s, %(created_at)s, %(updated_at)s) RETURNING leave_balances.id]
[parameters: {'user_id': 2, 'year': 2025, 'month': 1, 'credited': 1.0, 'used': 0.0, 'carry_forward_in': 0.0, 'created_at': datetime.datetime(2026, 7, 21, 11, 3, 5, 368095), 'updated_at': datetime.datetime(2026, 7, 21, 11, 3, 5, 368104)}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)

Traceback (most recent call last):
  File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
    self.dialect.do_execute(
  File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "uq_leave_balance_user_year_month"
DETAIL:  Key (user_id, year, month)=(2, 2025, 1) already exists.


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 917, in full_dispatch_request
    rv = self.dispatch_request()
         ^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/flask/app.py", line 902, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/flask_login/uti

{
  "method": "GET",
  "path": "/approvals/",
  "ref": "ER-NXEGSR"
}