Django migrate エラー

Question

実現したいこと

Python Djangoで特定のテーブルのみ他のシステムと依存しているのでそこだけ分けて運用したい。

前提

Python Djangoでルーター機能を用いてデータベースを複数用意してマイグレートするとエラーが発生します。
Uploadモデルのみセカンダリーのデータベースに存在し定義されています。（すでに存在している）

syun1@syun1MacBook-Pro archive_system_django % python manage.py inspectdb --database secondary
class Upload(models.Model):
    file_id = models.AutoField(primary_key=True)
    title = models.TextField()
    file_name = models.CharField(max_length=255)
    file_path = models.CharField(max_length=255)
    comment = models.TextField(blank=True, null=True)
    insert_at = models.DateTimeField()
    update_at = models.DateTimeField()
    delete_flag = models.IntegerField()
    user_id = models.IntegerField()
    published = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'upload'

他のモデルはすべてデフォルトデータベースにマイグレーション時に作成します。

発生している問題・エラーメッセージ

syun1@syun1MacBook-Pro archive_system_django % python manage.py migrate ArchiveViewer
Operations to perform:
  Apply all migrations: ArchiveViewer
Running migrations:
  Applying ArchiveViewer.0001_initial...Traceback (most recent call last):
  MySQLdb.OperationalError: (1824, "Failed to open the referenced table 'upload'")

The above exception was the direct cause of the following exception:

django.db.utils.OperationalError: (1824, "Failed to open the referenced table 'upload'")

該当のソースコード

ArchiveViewer.models.py

from django.db import models
from os.path import basename, splitext
from ckeditor.fields import RichTextField
from django.utils import timezone
# 記事用モデル
class Report(models.Model):
    title = models.CharField(max_length=100, verbose_name="タイトル")
    description = RichTextField(verbose_name="説明")
    is_public = models.BooleanField(default=False, verbose_name="公開フラグ")
    is_recommend = models.BooleanField(default=False, verbose_name="おすすめフラグ")
    category = models.ForeignKey("ReportCategory", on_delete=models.CASCADE, verbose_name="カテゴリー", null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)
    created_by = models.ForeignKey("accounts.User", on_delete=models.CASCADE, related_name="created_reports")
    updated_by = models.ForeignKey("accounts.User", on_delete=models.CASCADE, related_name="updated_reports")
    deleted_by = models.ForeignKey("accounts.User", on_delete=models.CASCADE, related_name="deleted_reports", null=True)
    is_deleted = models.BooleanField(default=False)

# 記事のカテゴリー用モデル
class ReportCategory(models.Model):
    name = models.CharField(max_length=100, verbose_name="カテゴリー名")
    description = models.TextField(verbose_name="カテゴリーの説明")
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)
    created_by = models.ForeignKey("accounts.User", on_delete=models.CASCADE, related_name="created_categories")
    updated_by = models.ForeignKey("accounts.User", on_delete=models.CASCADE, related_name="updated_categories")
    deleted_by = models.ForeignKey("accounts.User", on_delete=models.CASCADE, related_name="deleted_categories", null=True)
    is_deleted = models.BooleanField(default=False)
    def save(self, *args, **kwargs):
        # 削除フラグが立っている場合
        if self.is_deleted:
            # このカテゴリーに関連する Report オブジェクトの category フィールドを null に設定
            Report.objects.filter(category=self).update(category=None)
        
        super().save(*args, **kwargs)

# 履歴とお気に入りの抽象モデル
class HistoryFavoriteBase(models.Model):
    user = models.ForeignKey("accounts.User", on_delete=models.CASCADE)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        # 抽象モデルとして扱うのでTrue
        abstract = True

# ユーザーが閲覧したアーカイブコンテンツを保存するテーブル
class UploadHistory(HistoryFavoriteBase):
    upload = models.ForeignKey("Upload", on_delete=models.CASCADE)
    class Meta:
        # 作成日時の昇順で並べる
        ordering = ['created_at']
    # ユーザーが閲覧したアーカイブコンテンツの履歴を100件まで保存する
    def clean_history(self):
        history_count = UploadHistory.objects.filter(user=self.user).count()
        if history_count >= 100:
            oldest_history = UploadHistory.objects.filter(user=self.user).order_by('created_at').first()
            oldest_history.delete()
    def save (self, *args, **kwargs):
        self.clean_history()
        super().save(*args, **kwargs)

# ユーザーが閲覧した記事を保存するテーブル
class ReportHistory(HistoryFavoriteBase):
    report = models.ForeignKey("Report", on_delete=models.CASCADE)

    class Meta:
        ordering = ['created_at']

    def clean_history(self):
        history_count = ReportHistory.objects.filter(user=self.user).count()
        if history_count >= 100:
            oldest_history = ReportHistory.objects.filter(user=self.user).order_by('created_at').first()
            oldest_history.delete()
    def save (self, *args, **kwargs):
        self.clean_history()
        super().save(*args, **kwargs)

# ユーザーのお気に入り記事を保存するテーブル
class ReportFavorite(HistoryFavoriteBase):
    report = models.ForeignKey("Report", on_delete=models.CASCADE)
    
    # 重複のないようにする
    def save(self, *args, **kwargs):
        if ReportFavorite.objects.filter(user=self.user, report=self.report).exists():
            return
        super().save(*args, **kwargs)

# ユーザーのお気に入りアーカイブを保存するテーブル
class UploadFavorite(HistoryFavoriteBase):
    upload = models.ForeignKey("Upload", on_delete=models.CASCADE)
    
    # 重複のないようにする
    def save(self, *args, **kwargs):
        if UploadFavorite.objects.filter(user=self.user, upload=self.upload).exists():
            return
        super().save(*args, **kwargs)
        
        
#このモデルはアーカイブ管理システムのグループが作成したテーブルで、セカンダリーのデータベースに保存されている。
# アーカイブコンテンツ用モデル
class Upload(models.Model):
    file_id = models.AutoField(primary_key=True)
    title = models.TextField()
    file_name = models.CharField(max_length=255)
    file_path = models.CharField(max_length=255)
    comment = models.TextField(blank=True, null=True)
    insert_at = models.DateTimeField(auto_now_add=True)
    update_at = models.DateTimeField(auto_now=True)
    delete_flag = models.BooleanField(default=False)
    user_id = models.IntegerField()
    published = models.BooleanField(default=False)

    class Meta:
        managed = False
        db_table = 'upload'

settings.py

DATABASES = {
    "default": {
        "ENGINE": "django.db.backends.mysql",
        "NAME": "archive_system",
        "USER": "***********",
        "PASSWORD": "***************",
        "HOST": "localhost",
        "PORT": "3306",
    },
    "secondary": {
        "ENGINE": "django.db.backends.mysql",
        "NAME": "archive_system_upload",
        "USER": "*******",
        "PASSWORD": "***********",
        "HOST": "localhost",
        "PORT": "3306",
    }
}
# DATABASE_ROUTERSの設定
DATABASE_ROUTERS = ['archive_system.dbrouter.ArchiveSystemRouter']

dbrouter.py

class ArchiveSystemRouter:
    """
    A router to control all database operations on models in the
    Archive System application.
    """

    def db_for_read(self, model, **hints):
        """
        Attempts to read upload models go to secondary.
        """
        if model._meta.app_label == 'ArchiveViewer' and model._meta.model_name == 'upload':
            return 'secondary'
        elif model._meta.app_label == 'accounts':
            return 'default'
        return 'default'

    def db_for_write(self, model, **hints):
        """
        Attempts to write upload models go to secondary.
        """
        if model._meta.app_label == 'ArchiveViewer' and model._meta.model_name == 'upload':
            return 'secondary'
        elif model._meta.app_label == 'accounts':
            return 'default'
        return 'default'

    def allow_relation(self, obj1, obj2, **hints):
        """
        Allow relations if a model in the ArchiveViewer or accounts app is involved.
        """
        if obj1._meta.app_label in ['ArchiveViewer', 'accounts'] or \
           obj2._meta.app_label in ['ArchiveViewer', 'accounts']:
           return True
        return None

    def allow_migrate(self, db, app_label, model_name=None, **hints):
        """
        Make sure the upload model only appears in the 'secondary'
        database.
        """
        if app_label == 'ArchiveViewer' and model_name == 'upload':
            return db == 'secondary'
        elif app_label == 'accounts':
            return db == 'default'
        return db == 'default'

補足情報（FW/ツールのバージョンなど）

Mac OS Apple Silicon
Python 3.11
Django 4.2.5
mysql Ver 8.0.33 for macos13.3 on arm64 (Homebrew)

Answer 1

migrateする際にオプションを使用することmigrate可能

python manage.py migrate --fake-initial