Upgrade to 3.4.0 killed my Netbox :`(

[niask11]

Hello.

So the problem is that the upgrade script first gave me this error message:
django.db.utils.DataError: Unable to proceed with deleting contact fields from Provider model: Found 7 providers with legacy contact data. Please ensure all legacy provider contact data has been migrated to contact objects before proceeding. Or, set the NETBOX_DELETE_LEGACY_DATA environment variable to bypass this safeguard and delete all legacy provider contact data.
I checked Providers, there were really 7 of them, buy contact information was missing.

Just to be sure I manually copied this info, set export NETBOX_DELETE_LEGACY_DATA=1 and reran the script. But things got worse :(
Applying virtualization.0033_unique_constraints... OK Applying virtualization.0034_standardize_description_comments... OK Applying extras.0083_search...Reindexing 67 models. Clearing cached values... 0 entries deleted. 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... ^

Webserver shows this:

Where did the column netbox_dns_record.ip_address go and is there a way to recreate it?

The worst is that I don't have any backup((( Any help will be appreciated.

[kkthxbye-code]

Where did the column netbox_dns_record.ip_address go and is there a way to recreate it?

A better place to ask is probably here https://github.com/auroraresearchlab/netbox-dns

That being said you could try disabling netbox-dns, it shouldn't mess anything up, but since you didn't seem aware of it being installed I'm hesitant giving that advice.

[niask11]

You're right, the pb was with this plug-in, disabling it solves the upgrade procedure. It wasn't me who installed it that's why I forgot about it...
I'll try to upgrade it first, if it doesn't help, I'll ask there.
Thanks again!

[kkthxbye-code]

No problem. Also, please configure backup for production systems :)