Unable to serialize database. Django 1.5 hasn't been. Django dumpdata Unable to serialize database: Could not decode to UTF-8 column. February 20, 2017, at 3:33 PM. Unable to serialize database. Unable to serialize database. Django dumpdata unable to serialize existing column. Unable to serialize database. Django dumpdata output is. /opt/cloudera/parcels/CDH-5.4.4-1.cdh5.4.4.p0.4/lib/hue/build/env/bin/hue dumpdata >Baixar Filmes Grátis No Celular. hue_dumpdata.2015-07-20.json CommandError: Unable to serialize database: no such table: desktop_document2. When I use sqlite to display the list of tables, I can see it there: $ sqlite3 /var/hadoop/data/hue/desktop. Using Django 1.5, running./manage.py dumpdata gives me: CommandError: Unable to serialize database: relation 'django_logtail_log' does not exist LINE 1: SELECT.

I'm getting an error when I'm trying to dump data to a JSON fixture in Djanog 1.2.1 on my live server. On the live server it's running MySQL Server version 5.0.77 and I imported a lot of data to my tables using the phpMyAdmin interface. The website works fine and Django admin responds as normal. But when I try and actually dump the data of the application that corresponds to the tables I get this error: $ python manage.py dumpdata --indent=2 gigs >fixtures/gigs_100914.json /usr/local/lib/python2.6/site-packages/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated from sets import ImmutableSet Error: Unable to serialize database: Location matching query does not exist. I once ran in a similar problem where the error message was as mesmerizing as yours.

The cause was a lack of memory on my server. It seems that generating dumps in json is quite memory expensive.

I had only 60meg of memory (at djangohosting.ch) and it was not enough to get a dump for a mysql DB for which the mysql dump was only 1meg. I was able to find out by watching the python process hit the 60meg limit using the top command in a second command line while running manage.py dumpdata in a first one.

My solution: get the mysql dump and then load it on my desktop pc, before generating the json dump. That said, for backup purposes, the mysql dumps are enough. The command to get a mysql dump is the following: mysqldump -p [password] -u [username] [database_name] >[dump_file_name].sql That said, your problem could be completely different. You should really look at every table that has a foreign key to your Location table, and check if there is no field pointing to a previously deleted location. Unfortunately MySQL is very bad at maintaining Referential integrity, and you cannot count on it.

Import warnings from collections import OrderedDict from django.apps import apps from django.core import serializers from django.core.management.base import BaseCommand, CommandError from django.core.management.utils import parse_apps_and_model_labels from django.db import DEFAULT_DB_ALIAS, router class ProxyModelWarning( Warning): pass class Command( BaseCommand): help = ( 'Output the contents of the database as a fixture of the given format ' '(using each model's default manager unless --all is specified). ' ) def add_arguments( self, parser): parser.add_argument( 'args ', metavar = 'app_label[.ModelName] ', nargs = '* ', help = 'Restricts dumped data to the specified app_label or app_label.ModelName.

', ) parser.add_argument( '--format ', default = 'json ', dest = 'format ', help = 'Specifies the output serialization format for fixtures. ', ) parser.add_argument( '--indent ', default = None, dest = 'indent ', type = int, help = 'Specifies the indent level to use when pretty-printing output. ', ) parser.add_argument( '--database ', action = 'store ', dest = 'database ', default = DEFAULT_DB_ALIAS, help = 'Nominates a specific database to dump fixtures from. ' 'Defaults to the 'default' database. ', ) parser.add_argument( '-e ', '--exclude ', dest = 'exclude ', action = 'append ', default =[], help = 'An app_label or app_label.ModelName to exclude ' '(use multiple --exclude to exclude multiple apps/models). ', ) parser.add_argument( '--natural-foreign ', action = 'store_true ', dest = 'use_natural_foreign_keys ', help = 'Use natural foreign keys if they are available. ', ) parser.add_argument( '--natural-primary ', action = 'store_true ', dest = 'use_natural_primary_keys ', help = 'Use natural primary keys if they are available.