#27826 closed Uncategorized (duplicate)
Django migration can not find existing constraint
| Reported by: | Michal Čihař | Owned by: | nobody |
|---|---|---|---|
| Component: | Uncategorized | Version: | 1.10 |
| Severity: | Normal | Keywords: | |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
I've a project with long history. The databases were originally migrated by South and then it has moved to Django migrations.
Now when I've made changes to unique_together constraint, I got migration failure:
ValueError: Found wrong number (0) of constraints for trans_check(contentsum, project_id, language_id, check)
This seems to be caused by the constraing being created in different order in past. I think it has been created by South, but I'm not 100% sure. But anyway I've ended up with half applied migration what is not really a pleasant state.
I've fixed this for me by comparing fields as set not as lists (see attached patch), what is certainly okay for unique constraints, but is probably bad idea for general indexes.
Attachments (1)
Change History (3)
by , 7 years ago
| Attachment: | columns-ordering.patch added |
|---|
comment:1 by , 7 years ago
| Resolution: | → duplicate |
|---|---|
| Status: | new → closed |
This looks like a duplicate of #23906. The conclusion there is that you must fix your database. Django ignoring the order of columns in an index isn't correct.
comment:2 by , 7 years ago
Okay, the thing is that the database has been created by Django this way...
workaround patch