netbox-dns failed after upgrade to 3.4.0

[niask11]

Hello. I could not finish the upgrade to 3.4.0 without disabling DNS plugin:
Indexing models netbox_dns.nameserver... 6 entries cached. netbox_dns.zone... 5 entries cached. netbox_dns.record... Traceback (most recent call last): File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) psycopg2.errors.UndefinedColumn: column netbox_dns_record.ip_address does not exist LINE 1: ..."disable_ptr", "netbox_dns_record"."description", "netbox_dn... ^
and following:
The above exception was the direct cause of the following exception: Traceback (most recent call last): File "netbox/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 446, in execute_from_command_line utility.execute() File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 440, 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 402, in run_from_argv self.execute(*args, **cmd_options) File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/base.py", line 448, in execute output = self.handle(*args, **options) File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/base.py", line 96, in wrapped res = handle_func(*args, **kwargs) File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/commands/migrate.py", line 349, in handle post_migrate_state = executor.migrate( File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 135, in migrate state = self._migrate_all_forwards( File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards state = self.apply_migration( File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 252, in apply_migration state = migration.apply(state, schema_editor) File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/migrations/migration.py", line 130, in apply operation.database_forwards( File "/opt/netbox/venv/lib/python3.8/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/0083_search.py", line 13, in reindex management.call_command('reindex') File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 198, in call_command return command.execute(*args, **defaults) File "/opt/netbox/venv/lib/python3.8/site-packages/django/core/management/base.py", line 448, in execute output = self.handle(*args, **options) File "/opt/netbox/netbox/extras/management/commands/reindex.py", line 68, in handle i = search_backend.cache(model.objects.iterator(), remove_existing=False) File "/opt/netbox/netbox/netbox/search/backends.py", line 148, in cache for instance in instances: File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/models/query.py", line 512, in _iterator yield from iterable File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/models/query.py", line 87, in __iter__ results = compiler.execute_sql( File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/models/sql/compiler.py", line 1398, in execute_sql cursor.execute(sql, params) File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers( File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 80, 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 89, in _execute return self.cursor.execute(sql, params) File "/opt/netbox/venv/lib/python3.8/site-packages/django/db/utils.py", line 91, 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 89, in _execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: column netbox_dns_record.ip_address does not exist LINE 1: ..."disable_ptr", "netbox_dns_record"."description", "netbox_dn... ^
In Netbox when I got to "Other - Change Log" even without DNS plugin in shows:

Same story with the plugin enabled when I go here:
/plugins/netbox-dns/records/
/plugins/netbox-dns/managedrecords/

I upgrade the plugin to the latest version but still no luck.
Any ideas?

[peteeckel]

Correction: Your screenshot shows the problem:

Unsupported PostgreSQL version - Ensure that PostgreSQL version 10 or later is in use. You can check this by connecting to the database
using NetBox's credentials and issuing a query for SELECT VERSION().

NetBox 3.4 does not support PostgreSQL 10 anymore, you need to upgrade to at least PostgreSQL 11.

[niask11]

Nope, Netbox uses Postgres 14 in my config.
psql (15.1 (Ubuntu 15.1-1.pgdg20.04+1), server 14.6 (Ubuntu 14.6-1.pgdg20.04+1))

[peteeckel]

OK, I just saw that it's a possible cause listed by Django, sorry.

It is correct that the NetBox upgrade to 3.4.x does not work as long as NetBox DNS is enabled. You need to disable it, run the NetBox migration, then re-enable it and re-run migrations again. This is a one-off workaround, after you did that once and the NetBox extras.0083_search has run it won't happen again. This has already been reported as #261.

This is a general problem with NetBox and plugins using SearchIndex, and I also opened netbox-community/netbox#11248 with the NetBox project for it.

[niask11]

Thanks. I followed your instructions, upgraded to 3.4.2 and did the reindex. Works like a charm!

[peteeckel]

Thanks for your feedback!