get_or_create for lesson documentations and personal notes doesn't work correctly because of missing unique index #151

New issue

Closed

opened 2021-03-21 11:42:33 +01:00 by hansegucker · 3 comments

hansegucker commented

2021-03-21 11:42:33 +01:00

Owner

Opening a single lesson (or event or extra lesson) often causes an Internal Server Error. Internally, using get_or_create sometimes raise a MultipleObjectsReturned exception. The reasons for this behavior are described here:

A working solution is adding an unique index for the fields lesson_period, week, year, event and extra_lesson. This combination will always be unique.

Opening a single lesson (or event or extra lesson) often causes an Internal Server Error. Internally, using get_or_create sometimes raise a `MultipleObjectsReturned` exception. The reasons for this behavior are described here: 1. https://stackoverflow.com/a/29521117 2. https://adriennedomingus.com/blog/the-perils-of-getorcreate-race-conditions A working solution is adding an unique index for the fields `lesson_period`, `week`, `year`, `event` and `extra_lesson`. This combination will always be unique.

Rows
Columns