Fix mysql error 1005 when running django tests

django_error_test_database_1005.md

#Django Test Database Error 1005 8/1/2015

Environment

• Django 1.8.3
• MySQL 5.5

When running python manage.py test I was receiving the following error

django.db.utils.OperationalError: (1005, "Can't create table 'test_xxx.#sql-####_##' (errno: 150)")

However this database error was unique to the test runner and was not occurring when running python manage.py migrate.

Research showed that MySQL error 1005 is an InnoDB specific error related to a malformed foreign key constraint (http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html)

I investigated and found this in the logs

mysql -u user -p
use test_xxx;
show engine innodb status;
...
------------------------
LATEST FOREIGN KEY ERROR
------------------------
150801 19:43:38 Error in foreign key constraint of table test_xxx/#sql-####_##:
FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`):
Cannot resolve table name close to:
(`id`)
...

Solution

The conclusion is that the auth_user table never gets created but a model has a foreign key field that references id from that table. This is a side effect of migrations being implemented into django 1.8. The solution is to make sure you have migrations for every app that has a foreign key field, good practice to have migrations for all apps.

python manage.py makemigrations <app_name>

That worked !!, thank very much for looking into it.

Saved me a lot of time! Thanks!

I'd been reading this was a generic error, and your tip of using show engine innodb status actually shows what the issue is... thanks!

Given analysis show us a good track of thought. but good practice is not work for me, I try:
python manage.py makemigrations auth
the output is
No changes detected in app 'auth'

but this works:

python manage.py migrate auth
python manage.py migrate

my env:

• python 2.7.10
• django: 1.8
• mariadb: 5.5.49

It works!!!!!