NetBox Database Migration Error when Updating to 4.0.2.9.0

[alemsas]

NetBox Database Migration Error when Updating to 4.0.2.9.0

Environment Details

• Current NetBox Version: 3.7.2.8.0
• Target NetBox Version: 4.0.2.9.0
• PostgreSQL Version: 16
• Docker Compose Version: 3.9

Error Description

When attempting to update NetBox, the migration process fails with the following error:

FileNotFoundError: [Errno 2] No such file or directory: '/opt/netbox/netbox/scripts/change_role.py'

Full Error:

⚙️ Applying database migrations
🧬 loaded config '/etc/netbox/config/configuration.py'
🧬 loaded config '/etc/netbox/config/extra.py'
🧬 loaded config '/etc/netbox/config/logging.py'
🧬 loaded config '/etc/netbox/config/plugins.py'
Operations to perform:
  Apply all migrations: account, auth, circuits, contenttypes, core, dcim, django_rq, extras, ipam, sessions, social_django, taggit, tenancy, users, virtualization, vpn, wireless
Running migrations:
Traceback (most recent call last):
  File "/opt/netbox/netbox/./manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/__init__.py", line 442, in execute_from_command_line
    utility.execute()
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/__init__.py", line 436, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/base.py", line 413, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/base.py", line 459, in execute
    output = self.handle(*args, **options)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/base.py", line 107, in wrapper
    res = handle_func(*args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/core/management/commands/migrate.py", line 356, in handle
    post_migrate_state = executor.migrate(
                         ^^^^^^^^^^^^^^^^^
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 135, in migrate
    state = self._migrate_all_forwards(
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
    state = self.apply_migration(
            ^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/executor.py", line 252, in apply_migration
    state = migration.apply(state, schema_editor)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/migration.py", line 132, in apply
    operation.database_forwards(
  File "/opt/netbox/venv/lib/python3.11/site-packages/django/db/migrations/operations/special.py", line 193, in database_forwards
    self.code(from_state.apps, schema_editor)
  File "/opt/netbox/netbox/extras/migrations/0109_script_model.py", line 93, in update_scripts
    for script_name in get_module_scripts(module):
                       ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/netbox/netbox/extras/migrations/0109_script_model.py", line 63, in get_module_scripts
    module = loader.load_module()
             ^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap_external>", line 605, in _check_name_wrapper
  File "<frozen importlib._bootstrap_external>", line 1120, in load_module
  File "<frozen importlib._bootstrap_external>", line 945, in load_module
  File "<frozen importlib._bootstrap>", line 290, in _load_module_shim
  File "<frozen importlib._bootstrap>", line 721, in _load
  File "<frozen importlib._bootstrap>", line 690, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 936, in exec_module
  File "<frozen importlib._bootstrap_external>", line 1073, in get_code
  File "<frozen importlib._bootstrap_external>", line 1130, in get_data
FileNotFoundError: [Errno 2] No such file or directory: '/opt/netbox/netbox/scripts/change_role.py'
  Applying extras.0109_script_model...#  

The error occurs during the database migration step, specifically in the extras.0109_script_model migration.

Steps to Reproduce

1. Stop existing NetBox containers
2. Remove existing volumes
3. Update Docker Compose file to version 4.0.2.9.0
4. Run docker compose up

Attempted Solutions

• Removed and recreated all volumes
• Verified Docker Compose configuration
• Confirmed PostgreSQL and other dependencies are compatible

Possible Causes

• Missing script file change_role.py
• Migration script inconsistency between versions
• Incomplete volume or configuration migration

Requested Assistance

• How can I successfully migrate from version 3.7.2.8.0 to 4.0.2.9.0?
• Are there any known migration issues with this version upgrade?

Additional Information

Docker Compose Configuration

version: '3.9'

services:
  netbox: &netbox
    image: docker.io/netboxcommunity/netbox:${VERSION-v4.0-2.9.0}
    depends_on:
      - postgres
      - redis
      - redis-cache
    env_file: env/netbox.env
    environment:
      - NETBOX_DELETE_LEGACY_DATA=1
#      - ALLOWED_HOSTS= ['172.31.63.4']
      - CSRF_TRUSTED_ORIGINS = ['*']
      - SSL_CERT_FILE=/opt/netbox/netbox/cert.crt
      - SSL_KEY_FILE=/opt/netbox/netbox/key.key
    user: 'unit:root'
    healthcheck:
      start_period: 60s
      timeout: 3s
      interval: 15s
      test: "curl -f http://localhost:8080/api/ || exit 1"
    volumes:
      - ./configuration:/etc/netbox/config:z,ro
      - netbox-media-files:/opt/netbox/netbox/media:rw
      - netbox-reports-files:/opt/netbox/netbox/reports:rw
      - netbox-scripts-files:/opt/netbox/netbox/scripts:rw
      - $PWD/nginx/certs/selfsigned.crt:/opt/netbox/netbox/cert.crt:ro,z
      - $PWD/nginx/certs/selfsigned.key:/opt/netbox/netbox/key.key:ro,z


  netbox-worker:
    <<: *netbox
    depends_on:
      netbox:
        condition: service_healthy
    command:
      - /opt/netbox/venv/bin/python
      - /opt/netbox/netbox/manage.py
      - rqworker
    healthcheck:
      start_period: 20s
      timeout: 3s
      interval: 15s
      test: "ps -aux | grep -v grep | grep -q rqworker || exit 1"

  netbox-housekeeping:
    <<: *netbox
    depends_on:
      netbox:
        condition: service_healthy
    command:
      - /opt/netbox/housekeeping.sh
    healthcheck:
      start_period: 20s
      timeout: 3s
      interval: 15s
      test: "ps -aux | grep -v grep | grep -q housekeeping || exit 1"

  postgres:
    image: docker.io/postgres:16-alpine
    env_file: env/postgres.env
    volumes:
      - netbox-postgres-data:/var/lib/postgresql/data
    ports:
      - "5432:5432"
  redis:
    image: docker.io/redis:7-alpine
    command:
      - sh
      - -c
      - redis-server --appendonly yes --requirepass $$REDIS_PASSWORD
    env_file: env/redis.env
    volumes:
      - netbox-redis-data:/data

  redis-cache:
    image: docker.io/redis:7-alpine
    command:
      - sh
      - -c
      - redis-server --requirepass $$REDIS_PASSWORD
    env_file: env/redis-cache.env
    volumes:
      - netbox-redis-cache-data:/data

  nginx:
    image: nginx:stable-alpine3.20
    depends_on:
      - netbox
    volumes:
      - $PWD/nginx/certs/selfsigned.crt:/etc/ssl/private/cert.crt:ro,z
      - $PWD/nginx/certs/selfsigned.key:/etc/ssl/private/key.key:ro,z
      - $PWD/nginx/nginx.conf:/etc/nginx/conf.d/default.conf:ro
    ports:
      - "8000:8000"
      - "8443:443"
    restart: always



volumes:
  netbox-media-files:
    driver: local
  netbox-postgres-data:
    driver: local
  netbox-redis-cache-data:
    driver: local
  netbox-redis-data:
    driver: local
  netbox-reports-files:
    driver: local
  netbox-scripts-files:
    driver: local

NetBox Community, your guidance is appreciated!

[alemsas]

I solved it,I had lost my scripts!