Error after updating to latest Netbox Image

[Wasca]

Hi Guys

I use Watchtower to simply tell me when there is a new image to update. Watchtower reported the following

Found new netboxcommunity/netbox:latest image (5c7d396d7af5)

So I pulled the new image and recreated my stack, now I'm getting the following when starting up the netboxdocker_netbox_1

⏳ Waiting on DB... (6s / 30s)


🧬 loaded config '/etc/netbox/config/configuration.py'


🧬 loaded config '/etc/netbox/config/extra.py'


Operations to perform:


  Apply all migrations: admin, auth, circuits, contenttypes, dcim, extras, ipam, secrets, sessions, taggit, tenancy, users, virtualization


Running migrations:


  Applying extras.0054_standardize_models...Traceback (most recent call last):


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute


    return self.cursor.execute(sql, params)


psycopg2.errors.ObjectNotInPrerequisiteState: sequence must be in same schema as table it is linked to




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



Traceback (most recent call last):


  File "./manage.py", line 10, in <module>


    execute_from_command_line(sys.argv)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line


    utility.execute()


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 413, in execute


    self.fetch_command(subcommand).run_from_argv(self.argv)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/base.py", line 354, in run_from_argv


    self.execute(*args, **cmd_options)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/base.py", line 398, in execute


    output = self.handle(*args, **options)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/base.py", line 89, in wrapped


    res = handle_func(*args, **kwargs)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/commands/migrate.py", line 244, in handle


    post_migrate_state = executor.migrate(


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 117, in migrate


    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards


    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 227, in apply_migration


    state = migration.apply(state, schema_editor)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/migration.py", line 126, in apply


    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/operations/fields.py", line 244, in database_forwards


    schema_editor.alter_field(from_model, from_field, to_field)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 594, in alter_field


    self._alter_field(model, old_field, new_field, old_type, new_type,


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/postgresql/schema.py", line 196, in _alter_field


    super()._alter_field(


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 780, in _alter_field


    self.execute(sql, params)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 145, in execute


    cursor.execute(sql, params)


  File "/opt/netbox/venv/lib/python3.8/site-packages/cacheops/transaction.py", line 93, in execute


    result = self._no_monkey.execute(self, sql, params)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 66, in execute


    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers


    return executor(sql, params, many, context)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute


    return self.cursor.execute(sql, params)


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/utils.py", line 90, in __exit__


    raise dj_exc_value.with_traceback(traceback) from exc_value


  File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute


    return self.cursor.execute(sql, params)


django.db.utils.OperationalError: sequence must be in same schema as table it is linked to

The netboxdocker_postgres_1 container is saying this in the logs.

2021-04-28 00:34:11.469 UTC [1] LOG:  starting PostgreSQL 12.6 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.2.1_pre1) 10.2.1 20201203, 64-bit


2021-04-28 00:34:11.470 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432


2021-04-28 00:34:11.470 UTC [1] LOG:  listening on IPv6 address "::", port 5432


2021-04-28 00:34:11.470 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"


2021-04-28 00:34:11.491 UTC [21] LOG:  database system was shut down at 2021-04-28 00:27:12 UTC


2021-04-28 00:34:11.494 UTC [1] LOG:  database system is ready to accept connections


2021-04-28 00:34:16.326 UTC [29] ERROR:  sequence must be in same schema as table it is linked to


2021-04-28 00:34:16.326 UTC [29] STATEMENT:  ALTER SEQUENCE "extras_configcontext_id_seq" OWNED BY "extras_configcontext"."id"

Can some one help me get this working, at the moment my Netbox is not running and I just get a 502 Bag gateway error when trying to get to it.

[Wasca]

I reverted back to using the previous netbox image with this id (sha256:f2df81a43b0aa916d9e39a1c0bc489f2aceb46524f8466d5b0c997d67ec1bcdf) and I was able to successfully start my netbox stack again.

I'd still like to keep my netbox images up to date, so if anyone can suggest why the latest netbox image failed that would be great.

[Wasca]

I'm still having this issue and cannot update netbox for docker to version 2.12.

I've tried to follow this upgrade guide https://github.com/netbox-community/netbox-docker/wiki/Updating but it seemed to just make things worse.

I'm running this stack inside portainer if that's any help, here are the details.

docker-compose.yml

`version: '3.4'

networks:
nginxproxymanager_frontend: # Needed to connect to the NGINX Proxy manager network
external: true
default: # Needed by default

services:
netbox: &netbox
restart: unless-stopped
image: netboxcommunity/netbox:${VERSION-v2.10}
depends_on:
- postgres
- redis
- redis-cache
- netbox-worker
env_file: ../../netbox/env/netbox.env
user: '101'
volumes:
- /var/lib/docker/volumes/portainer_data/_data/netbox/startup_scripts:/opt/netbox/startup_scripts:z,ro
- /var/lib/docker/volumes/portainer_data/_data/netbox/initializers:/opt/netbox/initializers:z,ro
- /var/lib/docker/volumes/portainer_data/_data/netbox/configuration:/etc/netbox/config:z,ro
- /var/lib/docker/volumes/portainer_data/_data/netbox/reports:/etc/netbox/reports:z,ro
- /var/lib/docker/volumes/portainer_data/_data/netbox/scripts:/etc/netbox/scripts:z,ro
- netbox-media-files:/opt/netbox/netbox/media:z
ports:
- 8001:8080
networks:
- default
- nginxproxymanager_frontend
netbox-worker:
restart: unless-stopped
<<: *netbox
depends_on:
- redis
entrypoint:
- /opt/netbox/venv/bin/python
- /opt/netbox/netbox/manage.py
command:
- rqworker
ports: []

postgres

postgres:
restart: unless-stopped
image: postgres:12-alpine
env_file: ../../netbox/env/postgres.env
volumes:
- netbox-postgres-data:/var/lib/postgresql/data

redis

redis:
restart: unless-stopped
image: redis:6-alpine
command:
- sh
- -c # this is to evaluate the $REDIS_PASSWORD from the env
- redis-server --appendonly yes --requirepass $$REDIS_PASSWORD ## $$ because of docker-compose
env_file: ../../netbox/env/redis.env
volumes:
- netbox-redis-data:/data
redis-cache:
restart: unless-stopped
image: redis:6-alpine
command:
- sh
- -c # this is to evaluate the $REDIS_PASSWORD from the env
- redis-server --requirepass $$REDIS_PASSWORD ## $$ because of docker-compose
env_file: ../../netbox/env/redis-cache.env

volumes:
netbox-media-files:
driver: local
netbox-postgres-data:
driver: local
netbox-redis-data:
driver: local`

[ChandranshuRao14]

Hi @Wasca I'm having this same problem trying to upgrade from an old version of netbox. Do you remember if you were able to figure this out?

[Wasca]

Hi @Wasca I'm having this same problem trying to upgrade from an old version of netbox. Do you remember if you were able to figure this out?

Sorry no, I never figured it out. Ended up starting fresh. I'm no longer using Netbox now.