Django: loaddata not working

Question

I generated a fixture:

python manage.py dumpdata --all > ./mydump.json

I emptied all my databases using:

python manage.py sqlflush | psql mydatabase -U mydbuser

But when i try to use loaddata:

python manage.py loaddata ./mydump.json

I'm recieving this error:

IntegrityError: Could not load tastypie.ApiKey(pk=1): duplicate key 
value violates unique constraint "tastypie_apikey_user_id_key" 
DETAIL:  Key (user_id)=(2) already exists.

I'm having this problem on production and i'm out of ideas. Someone had a similar problem?

I modified my answer to point out the fact that you need to make sure that django is stopped before trying to load in the new data. i.e. if you are running a webserver with django in the stack, make sure to stop that webserver. — Jeff Sheffield, Feb 20 '14 at 18:26

Jan Kaifer · Answer 1 · 2020-03-04T14:44:13.163

12

Run loaddata with all @recievers commented out because they will be fired when loaddata loads your data. If @recievers create other objects as a sideeffect it will cause collisions.

edited Mar 04 '20 at 14:44

answered Feb 28 '20 at 20:50

Jan Kaifer

664
4
18

2

This actually helped, so genius. – Paaksing Sep 11 '20 at 11:42
1

Was getting a very opaque error message. This solved the problem. – Dan Swain Sep 29 '21 at 20:41

Jeff Sheffield · Answer 2 · 2014-02-20T18:25:58.157

First: I believe your unix pipe is incorrectly written.

# 1: Dump your json
$ python manage.py dumpdata --all > ./mydump.json

# 2: dump your schema
$ python manage.py sqlflush > schema.sql

# 3: launch psql
# this is how I launch psql ( seems to be more portable between rhel/ubuntu )
# you might use a bit different technique, and that is ok.

Edited: (very important) Make sure you do not have any active django connections running on your server. Then:

$ sudo -u myuser psql mydatabase

# 4: read in schema
mydatabase=# \i schema.sql
mydatabase=# ctrl-d

# 5: load back in your fixture. 
$ python manage.py loaddata ./mydump.json

Second: If your pipe is ok.. and it might be. Depending on your schema/data you may need to use natural-keys.

# 1: Dump your json using ( -n ) natural keys.
$ python manage.py dumpdata -n --all > ./mydump.json

# followed by steps 2-5 above.

Adrian Lopez · Accepted Answer · 2015-03-17T18:06:07.150

3

Jeff Sheffield's solution is correct, but now I find that a solution like django-dbbackup is by far the most generic and simplier way to do it with any database.

python manage.py dbbackup

edited Mar 17 '15 at 18:06

answered Apr 04 '14 at 04:12

Adrian Lopez

2,601
5
31
48

Django: loaddata not working

3 Answers3