[mozillians-dev] Dev push is failing on database migrations

VERIFIED FIXED

Status

VERIFIED FIXED
5 years ago
5 years ago

People

(Reporter: bburton, Unassigned)

Tracking

Details

(Whiteboard: [qa-])

(Reporter)

Description

5 years ago
mozillians-dev.allizom.org has been failing to push for a while, I noticed the error when investigating bug 906840

You can see the full log at http://genericadm.private.phx1.mozilla.com/chief/mozillians.dev/logs/origin.master.1378495701

But the relevant error is

[localhost] out: Syncing...
[localhost] out: Creating tables ...
[localhost] out: Installing custom SQL ...
[localhost] out: Installing indexes ...
[localhost] out: 
[localhost] out: Synced:
[localhost] out: > funfactory
[localhost] out: > compressor
[localhost] out: > django.contrib.auth
[localhost] out: > django.contrib.contenttypes
[localhost] out: > django.contrib.sessions
[localhost] out: > django.contrib.staticfiles
[localhost] out: > commonware.response.cookies
[localhost] out: > session_csrf
[localhost] out: > sorl.thumbnail
[localhost] out: > autocomplete_light
[localhost] out: > django.contrib.admin
[localhost] out: > bootstrapform
[localhost] out: > south
[localhost] out: 
[localhost] out: Not synced (use migrations):
[localhost] out: - djcelery
[localhost] out: - mozillians.users
[localhost] out: - mozillians.phonebook
[localhost] out: - mozillians.groups
[localhost] out: - mozillians.api
[localhost] out: - mozillians.mozspaces
[localhost] out: - mozillians.funfacts
[localhost] out: - mozillians.announcements
[localhost] out: (use ./manage.py migrate to migrate these)
[localhost] err: Problem installing fixture './fixtures-dev/initial_data.json': Traceback (most recent call last):
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/management/commands/loaddata.py", line 196, in handle
[localhost] err: obj.save(using=using)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/serializers/base.py", line 165, in save
[localhost] err: models.Model.save_base(self.object, using=using, raw=True)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/base.py", line 529, in save_base
[localhost] err: rows = manager.using(using).filter(pk=pk_val)._update(values)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/query.py", line 560, in _update
[localhost] err: return query.get_compiler(self.db).execute_sql(None)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/sql/compiler.py", line 988, in execute_sql
[localhost] err: cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/sql/compiler.py", line 818, in execute_sql
[localhost] err: cursor.execute(sql, params)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/backends/mysql/base.py", line 114, in execute
[localhost] err: return self.cursor.execute(query, args)
[localhost] err: File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
[localhost] err: self.errorhandler(self, exc, value)
[localhost] err: File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
[localhost] err: raise errorclass, errorvalue
[localhost] err: DatabaseError: Could not load users.UserProfile(pk=1): (1054, "Unknown column 'privacy_title' in 'field list'")
[localhost] err: 
[2013-09-06 12:28:31] [localhost] running: cd /data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians && python2.6 manage.py migrate
[2013-09-06 12:28:32] [localhost] failed: cd /data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians && python2.6 manage.py migrate (1.007s)
[localhost] out: Running migrations for djcelery:
[localhost] out: - Nothing to migrate.
[localhost] out: - Loading initial data for djcelery.
[localhost] out: Running migrations for users:
[localhost] out: ! Migration users:0036_auto__add_field_userprofile_privacy_tshirt__add_field_userprofile_tshi should not have been applied before users:0036_auto__add_field_userprofile_privacy_title__add_field_userprofile_title but was.
[localhost] out: ! Migration users:0036_auto__add_field_userprofile_privacy_tshirt__add_field_userprofile_tshi should not have been applied before users:0036_auto__add_field_userprofile_privacy_title__add_field_userprofile_title but was.
[localhost] err: Problem installing fixture './fixtures-dev/initial_data.json': Traceback (most recent call last):
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/management/commands/loaddata.py", line 196, in handle
[localhost] err: obj.save(using=using)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/serializers/base.py", line 165, in save
[localhost] err: models.Model.save_base(self.object, using=using, raw=True)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/base.py", line 529, in save_base
[localhost] err: rows = manager.using(using).filter(pk=pk_val)._update(values)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/query.py", line 560, in _update
[localhost] err: return query.get_compiler(self.db).execute_sql(None)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/sql/compiler.py", line 988, in execute_sql
[localhost] err: cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/models/sql/compiler.py", line 818, in execute_sql
[localhost] err: cursor.execute(sql, params)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/db/backends/mysql/base.py", line 114, in execute
[localhost] err: return self.cursor.execute(query, args)
[localhost] err: File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
[localhost] err: self.errorhandler(self, exc, value)
[localhost] err: File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
[localhost] err: raise errorclass, errorvalue
[localhost] err: DatabaseError: Could not load users.UserProfile(pk=1): (1054, "Unknown column 'privacy_title' in 'field list'")
[localhost] err: 
[localhost] err: Traceback (most recent call last):
[localhost] err: File "manage.py", line 23, in <module>
[localhost] err: manage.main()
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/src/funfactory/funfactory/manage.py", line 143, in main
[localhost] err: execute_manager(current_settings)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/management/__init__.py", line 459, in execute_manager
[localhost] err: utility.execute()
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/management/__init__.py", line 382, in execute
[localhost] err: self.fetch_command(subcommand).run_from_argv(self.argv)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/management/base.py", line 196, in run_from_argv
[localhost] err: self.execute(*args, **options.__dict__)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor/lib/python/django/core/management/base.py", line 232, in execute
[localhost] err: output = self.handle(*args, **options)
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor-local/lib/python/south/management/commands/migrate.py", line 111, in handle
[localhost] err: ignore_ghosts = ignore_ghosts,
[localhost] err: File "/data/genericrhel6-dev/src/mozillians-dev.allizom.org/mozillians/vendor-local/lib/python/south/migration/__init__.py", line 214, in migrate_app
[localhost] err: raise exceptions.InconsistentMigrationHistory(problems)
[localhost] err: south.exceptions.InconsistentMigrationHistory: Inconsistent migration history
[localhost] err: The following options are available:
[localhost] err: --merge: will just attempt the migration ignoring any potential dependency conflicts.

Comment 1

5 years ago
Commits pushed to master at https://github.com/mozilla/mozillians

https://github.com/mozilla/mozillians/commit/692f651f255507f02a3b592132e912c4f473d172
[bug 913629] Fix south migration history.

https://github.com/mozilla/mozillians/commit/15242b9bc2f0b21f89875078a8e8293accdcc0f1
Merge pull request #604 from glogiotatidis/fix-south-2

[bug 913629] Fix south migration history.
We had to move around some migration files, everything is back to normal. Thanks for the heads up solarce.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
Depends on: 913361

Updated

5 years ago
Whiteboard: [qa-]
Bumping to verified as [qa-] and per comment 2. Thanks all for getting this remedied.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.