805592 - [AirMozilla] syncdb needs to be run on deploying airmozilla

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task, P3)

Description

[Peter Bengtsson [:peterbe]]

When we deploy dev, stage and prod airmozilla we should run `./manage.py syncdb`
This adds the SQL stuff needed for new models installed. 

Can you please do this first for dev. That'll solve this error:
https://air-dev.allizom.org/media/emails/20121025-130310-140552638885968.log

Comment 1

[Brandon Burton [:solarce]]

I added 'syncdb' to -dev and run a push, syncdb seems happy but the migrate command threw out an error

+ /usr/bin/env python /data/genericrhel6-dev/src/air-dev.allizom.org/air/manage.py syncdb
/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/pytz/__init__.py:35: UserWarning: Module south was already imported from /data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/south/__init__.py, but /usr/lib/python2.6/site-packages is being added to sys.path
  from pkg_resources import resource_stream
/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/lib/python/django/utils/translation/__init__.py:63: DeprecationWarning: Translations in the project directory aren't supported anymore. Use the LOCALE_PATHS setting instead.
  DeprecationWarning)
Syncing...
Creating tables ...
Creating table django_site
Creating table django_flatpage_sites
Creating table django_flatpage
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)

Synced:
 > funfactory
 > compressor
 > django.contrib.auth
 > django.contrib.contenttypes
 > django.contrib.sessions
 > django.contrib.staticfiles
 > commonware.response.cookies
 > djcelery
 > session_csrf
 > airmozilla.base
 > airmozilla.auth
 > bootstrapform
 > sorl.thumbnail
 > south
 > django.contrib.messages
 > django.contrib.sites
 > django.contrib.flatpages

Not synced (use migrations):
 - airmozilla.main
(use ./manage.py migrate to migrate these)
+ /usr/bin/env python /data/genericrhel6-dev/src/air-dev.allizom.org/air/manage.py migrate airmozilla.main
/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/pytz/__init__.py:35: UserWarning: Module south was already imported from /data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/south/__init__.pyc, but /usr/lib/python2.6/site-packages is being added to sys.path
  from pkg_resources import resource_stream
/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/lib/python/django/utils/translation/__init__.py:63: DeprecationWarning: Translations in the project directory aren't supported anymore. Use the LOCALE_PATHS setting instead.
  DeprecationWarning)
Traceback (most recent call last):
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/manage.py", line 27, in <module>
    manage.main()
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/src/funfactory/funfactory/manage.py", line 143, in main
    execute_manager(current_settings)
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/lib/python/django/core/management/__init__.py", line 459, in execute_manager
    utility.execute()
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/lib/python/django/core/management/__init__.py", line 382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/lib/python/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/lib/python/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/south/management/commands/migrate.py", line 107, in handle
    ignore_ghosts = ignore_ghosts,
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/south/migration/__init__.py", line 199, in migrate_app
    applied_all = check_migration_histories(applied_all, delete_ghosts, ignore_ghosts)
  File "/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/south/migration/__init__.py", line 88, in check_migration_histories
    raise exceptions.GhostMigrations(ghosts)
south.exceptions.GhostMigrations: 

 ! These migrations are in the database but not on disk:
    <main: 0005_initial_groups>
 ! I'm not trusting myself; either fix this yourself by fiddling
 ! with the south_migrationhistory table, or pass --delete-ghost-migrations
 ! to South to have it delete ALL of these records (this may not be good).
+ /usr/bin/env python /data/genericrhel6-dev/src/air-dev.allizom.org/air/manage.py collectstatic --noinput
/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor/lib/python/django/utils/translation/__init__.py:63: DeprecationWarning: Translations in the project directory aren't supported anymore. Use the LOCALE_PATHS setting instead.
  DeprecationWarning)
/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/pytz/__init__.py:35: UserWarning: Module memcache was already imported from /data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/memcache.pyc, but /usr/lib/python2.6/site-packages is being added to sys.path
  from pkg_resources import resource_stream
/data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/pytz/__init__.py:35: UserWarning: Module south was already imported from /data/genericrhel6-dev/src/air-dev.allizom.org/air/vendor-local/lib/python/south/__init__.pyc, but /usr/lib/python2.6/site-packages is being added to sys.path
  from pkg_resources import resource_stream

Comment 2

[Brandon Burton [:solarce]]

Added syncdb to stage and prod, will be run in the next push