unicefuganda/rapidsms-ureport

Error in migration: ureport:0031_add_timestamps_to_contact_and_connection

fly2wind opened this issue · 0 comments

python manage.py migrate --noinput --verbosity=1 --settings=settings_production
Running migrations for ureport:

  • Migrating forwards to 0036_auto__add_exportedpoll.

    ureport:0031_add_timestamps_to_contact_and_connection
    FATAL ERROR - The following SQL query failed: ALTER TABLE "rapidsms_contact" ADD COLUMN "created_on" timestamp with time zone NULL;
    The error was: column "created_on" of relation "rapidsms_contact" already exists

Error in migration: ureport:0031_add_timestamps_to_contact_and_connection
Traceback (most recent call last):
File "manage.py", line 7, in
execute_manager(settings)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/init.py", line 438, in execute_manager
utility.execute()
File "/usr/local/lib/python2.7/dist-packages/django/core/management/init.py", line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 191, in run_from_argv
self.execute(_args, *_options.dict)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 220, in execute
output = self.handle(_args, *_options)
File "/usr/local/lib ignore_ghosts = ignore_ghosts,
File "/usr/local/lib/python2.7/dist-packages/south/migration/init.py", line 220, in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 256, in migrate_many
result = migrator.class.migrate_many(migrator, target, migrations, database)
File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 331, in migrate_many
result = self.migrate(migration, database)
File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 133, in migrate
result = self.run(migration, database)
File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 114, in run
return self.run_migration(migration, database)
File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 89, in run_migration
self.record(migration, database)
File "/usr/local/lib/python2.7/dist-packages/south/migration/migrators.py", line 291, in record
record = MigrationHistory.for_migration(migration, database)
File "/usr/local/lib/python2.7/dist-packages/south/models.py", line 27, in for_migration
migration=migration.name(),
File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 132, in get
return self.get_query_set().get(_args, *_kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 344, in get
num = len(clone)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 82, in len
self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 273, in iterator
for row in compiler.results_iter():
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 680, in results_iter
for rows in self.execute_sql(MULTI):
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute
return self.cursor.execute(query, args)
django.db.utils.DatabaseError: current transaction is aborted, commands ignored until end of transaction block