Django and "get() returned more than one Model name" error in multi-threaded program

Question

Django's get_or_create function always cause "get() returned more than one Model name" error in a multi-threaded program.

I even tried to put get_or_create statement inside a lock.acquire() and lock.release() block but still didn't work.

The program only works when I set thread_count=1

The database is on InnoDB engine. How to fix this kind of problem?

Answer 1

This is not caused by multithreading, but because there are more than one object in database, that satisfies your query. You must select exactly one object from the database using get, otherwise it will raise an exception.