#24972: Removing unique_together constraint makes migration fail on Django 1.8.2
with MySQL
-------------------------------------+-------------------------------------
Reporter: adambrenecki | Owner:
| adambrenecki
Type: Bug | Status: closed
Component: Migrations | Version: 1.9
Severity: Release blocker | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by adamn):
* version: 1.8 => 1.9
Comment:
This still seems to be a problem.
MySQL 5.6
Django 1.9.4
Python 3.5
In this case I'm dropping a unique_with constraint on a table called
"stream_streamaccess"
{{{
class Migration(migrations.Migration):
dependencies = [
('stream', '0002_auto_20160406_1501'),
]
operations = [
migrations.AlterUniqueTogether(
name='streamaccess',
unique_together=set([]),
),
]
}}}
{{{
Running migrations:
Rendering model states... DONE
Applying stream.0003_auto_20160406_2130...Traceback (most recent call
last):
File "/var/www/centr/manage.py", line 13, in <module>
execute_from_command_line(sys.argv)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/core/management/__init__.py", line 353, in
execute_from_command_line
utility.execute()
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/core/management/__init__.py", line 345, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/core/management/base.py", line 348, in run_from_argv
self.execute(*args, **cmd_options)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/core/management/base.py", line 399, in execute
output = self.handle(*args, **options)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/core/management/commands/migrate.py", line 200, in handle
executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/migrations/executor.py", line 92, in migrate
self._migrate_all_forwards(plan, full_plan, fake=fake,
fake_initial=fake_initial)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/migrations/executor.py", line 121, in
_migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake,
fake_initial=fake_initial)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/migrations/executor.py", line 198, in apply_migration
state = migration.apply(state, schema_editor)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/migrations/migration.py", line 123, in apply
operation.database_forwards(self.app_label, schema_editor, old_state,
project_state)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/migrations/operations/models.py", line 359, in
database_forwards
getattr(new_model._meta, self.option_name, set()),
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/backends/base/schema.py", line 318, in
alter_unique_together
self._delete_composed_index(model, fields, {'unique': True},
self.sql_delete_unique)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/backends/mysql/schema.py", line 87, in
_delete_composed_index
return super(DatabaseSchemaEditor, self)._delete_composed_index(model,
fields, *args)
File "/var/virtualenvs/centr/lib/python3.5/site-
packages/django/db/backends/base/schema.py", line 347, in
_delete_composed_index
", ".join(columns),
ValueError: Found wrong number (0) of constraints for
stream_streamaccess(stream_id, user_id, role)
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/24972#comment:9>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/070.b6d421d6613fe92b506595007616233b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
