Hi,
I have a project, which works on server for some time, but:
I need to develop it, so I want to run in docker locally. That is easy. But
i cannot just copy DB from production, because it contains sensitive
informations. OK, I just deleted DB and want to start app. Migrations
should work everything... but -> they do not.
I can look at migrations and:
django_app
[X] 0001_initial
[X] 0002_auto_20240416_1029
[X] 0003_auto_20240416_1041
[X] 0004_auto_20240422_2057
[X] 0005_auto_20240423_1347
[X] 0006_auto_20240425_2154
[ ] 0007_auto_20240602_1132
[ ] 0008_auto_20240623_1917
[ ] 0009_auto_20240701_1125
as you can see, onli migrations 1~6 were done.
I can see in logs:
django-1 | File
"/usr/local/lib/python3.8/site-packages/django/db/backends/utils.py", line
84, in _execute
django-1 | return self.cursor.execute(sql, params)
django-1 | django.db.utils.OperationalError: cannot ALTER TABLE
"xxx" because it has pending trigger events
django-1 |
django-1 | Applying django_app.0007_auto_20240602_1132...
If someone want to look on 007 migrasion:
operations = [
migrations.RemoveField(
model_name='submission',
name='author',
),
migrations.RemoveField(
model_name='submission',
name='user_id',
),
migrations.CreateModel(
name='Member',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False,
verbose_name='ID')),
('user_id', models.CharField(max_length=255, verbose_name='Идентификатор')),
('name', models.CharField(max_length=255, verbose_name='Наименование')),
('email', models.EmailField(blank=True, max_length=254, null=True,
verbose_name='Email')),
('platform', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='members', to='core.platform', verbose_name='Платформа')),
],
options={
'verbose_name': 'участник',
'verbose_name_plural': 'участники',
'db_table': 'members',
'unique_together': {('platform', 'user_id')},
},
),
migrations.AddField(
model_name='submission',
name='member',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT,
related_name='submissions', to='core.member', verbose_name='Участник
(Автор)'),
),
]
I do not have an idea, what can be responsible for that "pending trigger
events" - maybe someone will give me some advise, whre to look for?
Thi repository is complex (about 15 branches) - I thind database was build
in time, and maybe in production environemnt works, and maybedb designing
process was different in time, and all migrations merged by branch merging
gives such efect.
If someone will have an idea... I will be greatefull.
Adam
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/django-users/b6b8ee19-abd9-4ef4-850b-ee9ce100d28bn%40googlegroups.com.
