Closed Bug 913629 Opened 11 years ago Closed 11 years ago

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

Categories

(Participation Infrastructure :: Phonebook, defect)

Product:
Participation Infrastructure
Component:
Phonebook
Platform:
x86
macOS
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: bburton, Unassigned)

References

Details

(Whiteboard: [qa-])

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.
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
Closed: 11 years ago
Resolution: --- → FIXED
Depends on: 913361
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.