“Django_迁移”关系已存在

2024-05-26 21:51:47 发布

您现在位置:Python中文网/ 问答频道 /正文

我使用Django租户模式将租户分配到他们自己的模式。不久前我遇到了一个迁移问题,现在在它自己的模式上创建租户失败后,还剩下一些东西。此模式称为tiger

给出如何设置的想法;有些数据是公共的,存在于公共模式(如用户和公司)上,但其他所有数据都是特定于租户的,并且存在于自己的模式中

这是我运行迁移的方式:

(venv) david@clearpath:~/clearpath_project$ python manage.py migrate_schemas

[standard:public] === Starting migration
[standard:public] Operations to perform:
[standard:public]   Apply all migrations: admin, auth, categories, companies, contenttypes, employees, invite, memos, notifications, phone_verify, quiz, sessions, videos
[standard:public] Running migrations:
[standard:public]   No migrations to apply.

[1/5 (20%) standard:clearpath] === Starting migration
[1/5 (20%) standard:clearpath] Operations to perform:
[1/5 (20%) standard:clearpath]   Apply all migrations: admin, auth, categories, companies, contenttypes, employees, invite, memos, notifications, phone_verify, quiz, sessions, videos
[1/5 (20%) standard:clearpath] Running migrations:
[1/5 (20%) standard:clearpath]   No migrations to apply.
[2/5 (40%) standard:c1] === Starting migration
[2/5 (40%) standard:c1] Operations to perform:
[2/5 (40%) standard:c1]   Apply all migrations: admin, auth, categories, companies, contenttypes, employees, invite, memos, notifications, phone_verify, quiz, sessions, videos
[2/5 (40%) standard:c1] Running migrations:
[2/5 (40%) standard:c1]   No migrations to apply.
[3/5 (60%) standard:aces] === Starting migration
[3/5 (60%) standard:aces] Operations to perform:
[3/5 (60%) standard:aces]   Apply all migrations: admin, auth, categories, companies, contenttypes, employees, invite, memos, notifications, phone_verify, quiz, sessions, videos
[3/5 (60%) standard:aces] Running migrations:
[3/5 (60%) standard:aces]   No migrations to apply.
[4/5 (80%) standard:tiger] === Starting migration
[4/5 (80%) standard:tiger] Operations to perform:
[4/5 (80%) standard:tiger]   Apply all migrations: admin, auth, categories, companies, contenttypes, employees, invite, memos, notifications, phone_verify, quiz, sessions, videos
[4/5 (80%) standard:tiger] Running migrations:

在schematiger中,它失败并显示:

注意:这只是回溯的开始部分

Traceback (most recent call last):
  File "/home/david/clearpath_project/venv/lib/python3.7/site-packages/django/db/backends/utils.py", line 82, in _execute
    return self.cursor.execute(sql)
psycopg2.errors.DuplicateTable: relation "django_migrations" already exists

我尝试过使用psql{}删除模式,但这没有帮助。我相信问题是因为租户仍然存在于public模式中,但我可能错了

我需要保留数据,所以不能删除数据库

有没有想过我该如何解决这个问题


Tags: toadminmigrations模式publicallmigrationperform

热门问题