#30431: Migration hangs on non default database
-------------------------------------+-------------------------------------
Reporter: mandm | Owner: nobody
Type: Bug | Status: new
Component: Migrations | Version: 1.11
Severity: Normal | Resolution:
Keywords: migrations, uuid, | Triage Stage:
uuidfield, database router, | Unreviewed
multiple database |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by mandm:
Old description:
> I'm trying to add a UUIDField in an existing user model following this
> method (with unique=True & default=uuid.uuid4).
> https://docs.djangoproject.com/en/1.11/howto/writing-migrations
> /#migrations-that-add-unique-fields
>
> This works with a single database but hangs in the following scenarios
> with multiple databases :
>
> - Hangs ! Migration with option `--database=foobar`
> - Hangs ! Migration without option `--database=foobar`, but with
> `using('foobar')` in the query in gen_uuid function
> - Works ! Migration without option `--database=foobar`
>
> Here's a snippet of the code I've used. I would be glad to provide
> additional information to reproduce the issue.
>
> User model :
>
> {{{
> class CustomUser(AbstractUser):
> address = models.TextField()
> uniq_id = models.UUIDField(unique=True, default=uuid.uuid4)
>
> class Meta:
> db_table = 'customuser'
> }}}
>
> Migration file
>
> {{{
> def gen_uuid(apps, schema_editor):
> UserModel = apps.get_model('myapp', 'customuser')
> for row in UserModel.objects.all(): #
> .objects.using('foobar').all(): -- HANGS !
> row.uniq_id = uuid.uuid4()
> row.save(update_fields=['uniq_id']) # .save(using='foobar', ...)
> -- HANGS with database routers !
>
> class Migration(migrations.Migration):
> dependencies = [
> ('myapp', '003_previous_migration'),
> ]
>
> operations = [
> migrations.AddField(
> model_name='customuser',
> name='uniq_id',
> field=models.UUIDField(default=uuid.uuid4, null=True),
> ),
> migrations.RunPython(gen_uuid,
> reverse_code=migrations.RunPython.noop),
> migrations.AlterField(
> model_name='customuser',
> name='uniq_id',
> field=models.UUIDField(default=uuid.uuid4, unique=True),
> ),
> ]
> }}}
New description:
I'm trying to add a UUIDField in an existing user model following this
method (with unique=True & default=uuid.uuid4).
https://docs.djangoproject.com/en/1.11/howto/writing-migrations
/#migrations-that-add-unique-fields
This works with a single database but hangs in the following scenarios
with multiple databases :
- Hangs
- python manage.py migrate --database=nondefault
- also hangs with `.using('nondefault')` in the query in gen_uuid
function
- Works
- python manage.py migrate
- python manage.py migrate --database=default
It seems to always hang at this statement `UserModel.objects.all()` when a
non-default database is used either via `--database` option in migrate or
via `.using('nondefault')` in query.
Here's a snippet of the code I've used. I would be glad to provide
additional information to reproduce the issue.
User model :
{{{
class CustomUser(AbstractUser):
address = models.TextField()
uniq_id = models.UUIDField(unique=True, default=uuid.uuid4)
class Meta:
db_table = 'customuser'
}}}
Migration file
{{{
def gen_uuid(apps, schema_editor):
UserModel = apps.get_model('myapp', 'customuser')
for row in UserModel.objects.all(): #
.objects.using('foobar').all(): -- HANGS !
row.uniq_id = uuid.uuid4()
row.save(update_fields=['uniq_id']) # .save(using='foobar', ...)
-- HANGS with database routers !
class Migration(migrations.Migration):
dependencies = [
('myapp', '003_previous_migration'),
]
operations = [
migrations.AddField(
model_name='customuser',
name='uniq_id',
field=models.UUIDField(default=uuid.uuid4, null=True),
),
migrations.RunPython(gen_uuid,
reverse_code=migrations.RunPython.noop),
migrations.AlterField(
model_name='customuser',
name='uniq_id',
field=models.UUIDField(default=uuid.uuid4, unique=True),
),
]
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/30431#comment:2>
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/063.823e4096eefdae6164008d0b5e53e80f%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
