I have a sql constrain that is set up for one of my model. Recently, I have been getting duplication messages even though there is no duplication:
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "purchase_order_unique_mail_order"
DETAIL: Key (purcahse_shop_id, mail_id,mail_purcha_id)=(1, 5208, 65) already exists.
No such duplication exists. I ran queries to search for this and it does not exist.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
1
Odpowiedz
3309
Widoki
Hi,
You can trust the postgresql constrains, it wont raise without meeting the given condition. So here some how the constrains is triggered, may be the duplicate values get generated on the current commit/fly and on writing it to the db it is getting failed and as it roll backed to its original state you may not be able to find the duplicated value.
In order to trace it, you can try with api constrains and see by adding some print/logger inside it to trace it.
Thanks
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
5
sie 24
|
15738 | ||
|
2
lip 24
|
2168 | ||
|
4
lut 24
|
3315 | ||
|
1
lut 24
|
2290 | ||
|
0
sie 21
|
111 |
