django.db.utils.IntegrityError when adding multiple notes to the same maintenance with the same title

[glennmatthews]

Environment

• Python version:
• Nautobot version: 1.1.4
• nautobot-circuit-maintenance version: 0.2.5

Expected Behavior

Circuit maintenance job to run to completion

Observed Behavior

django.db.utils.IntegrityError: duplicate key value violates unique constraint "nautobot_circuit_mainten_maintenance_id_title_f955987f_uniq"
DETAIL:  Key (maintenance_id, title)=(646c824b-d576-4e4c-ba19-19eb307e8d1c, Nonexistent circuit ID _) already exists.

Steps to Reproduce

1. Receive and process an email notification that references the same nonexistent circuit ID more than once - in this case this appears to be due to the parser not recognizing that "Alternate Circuit ID" needs to be used instead of "Circuit ID", and so mistakenly thinking that the circuit ID _ is being referenced twice:
   
2. Job errors out.

Either we should remove the uniqueness constraint that requires that each Note on a CircuitMaintenance must have a unique title, or else we need to explicitly detect and handle the case where a duplicate note would be created and avoid this exception.

[glennmatthews]

The specific parser issue is addressed in networktocode/circuit-maintenance-parser#98

[chadell]

sorry, I missed the notification for the parser PR :) Missatge de Glenn Matthews ***@***.***> del dia dj., 21 d’oct. 2021 a les 15:13:

…

The specific parser issue is addressed in networktocode/circuit-maintenance-parser#98 <networktocode/circuit-maintenance-parser#98> — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub <#140 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AD2BZH6B2WGDHKNKOQZQVVDUIAGXHANCNFSM5GL6BJTA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.