Created
October 16, 2018 17:56
-
-
Save wbamberg/ec00fa1e6a3b8b3c8f04979f9e65e197 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ docker-compose exec web ./manage.py migrate | |
System check identified some issues: | |
WARNINGS: | |
?: (django_mysql.W001) MySQL Strict Mode is not set for database connection 'default' | |
HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://django-mysql.readthedocs.io/en/latest/checks.html#django-mysql-w001-strict-mode | |
?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default' | |
HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoproject.com/en/1.11/ref/databases/#mysql-sql-mode | |
Operations to perform: | |
Apply all migrations: account, admin, attachments, auth, authkeys, contenttypes, core, database, djcelery, feeder, search, sessions, sites, soapbox, socialaccount, taggit, tidings, users, waffle, wiki | |
Running migrations: | |
Applying soapbox.0001_initial...Traceback (most recent call last): | |
File "./manage.py", line 10, in <module> | |
execute_from_command_line(sys.argv) | |
File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 364, in execute_from_command_line | |
utility.execute() | |
File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 356, in execute | |
self.fetch_command(subcommand).run_from_argv(self.argv) | |
File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 283, in run_from_argv | |
self.execute(*args, **cmd_options) | |
File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 330, in execute | |
output = self.handle(*args, **options) | |
File "/usr/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 204, in handle | |
fake_initial=fake_initial, | |
File "/usr/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 115, in migrate | |
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial) | |
File "/usr/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 145, in _migrate_all_forwards | |
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial) | |
File "/usr/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 244, in apply_migration | |
state = migration.apply(state, schema_editor) | |
File "/usr/local/lib/python2.7/site-packages/django/db/migrations/migration.py", line 129, in apply | |
operation.database_forwards(self.app_label, schema_editor, old_state, project_state) | |
File "/usr/local/lib/python2.7/site-packages/django/db/migrations/operations/models.py", line 97, in database_forwards | |
schema_editor.create_model(model) | |
File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/schema.py", line 319, in create_model | |
self.execute(sql, params or None) | |
File "/usr/local/lib/python2.7/site-packages/django/db/backends/base/schema.py", line 136, in execute | |
cursor.execute(sql, params) | |
File "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute | |
return super(CursorDebugWrapper, self).execute(sql, params) | |
File "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute | |
return self.cursor.execute(sql, params) | |
File "/usr/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__ | |
six.reraise(dj_exc_type, dj_exc_value, traceback) | |
File "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 62, in execute | |
return self.cursor.execute(sql) | |
File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 101, in execute | |
return self.cursor.execute(query, args) | |
File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute | |
self.errorhandler(self, exc, value) | |
File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler | |
raise errorvalue | |
django.db.utils.OperationalError: (1050, "Table 'soapbox_message' already exists") | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hm, the fact that the
soapbox_message
table already exists tells me that your local dev sample database is different fromwget -N https://mdn-downloads.s3-us-west-2.amazonaws.com/mdn_sample_db.sql.gz
, which may be because you've scraped documents into it that you needed. If you actually wanted a fresh sample database, then I think if you download a fresh one and load it, thedocker-compose exec web ./manage.py migrate
should work without error.However, if you didn't want to lose the current state of your sample database, I think the following migrate command should work for you instead: