Can't View Devices After Upgrading to 2.2.2 #1345

Closed
opened 2025-12-29 16:31:38 +01:00 by adam · 2 comments
Owner

Originally created by @robduffy2010 on GitHub (Oct 23, 2017).

Issue type

[ ] Feature request
[ X ] Bug report
[ ] Documentation

Environment

  • Python version: 3.5.2
  • NetBox version: 2.2.2

Description

After updating to version 2.2.2, I receive the following error message when attempting to view or edit any device.

<class 'django.db.utils.ProgrammingError'>

column ipam_service.virtual_machine_id does not exist
LINE 1: ...vice"."last_updated", "ipam_service"."device_id", "ipam_serv...
Originally created by @robduffy2010 on GitHub (Oct 23, 2017). <!-- Before opening a new issue, please search through the existing issues to see if your topic has already been addressed. Note that you may need to remove the "is:open" filter from the search bar to include closed issues. Check the appropriate type for your issue below by placing an x between the brackets. If none of the below apply, please raise your issue for discussion on our mailing list: https://groups.google.com/forum/#!forum/netbox-discuss Please note that issues which do not fall under any of the below categories will be closed. ---> ### Issue type [ ] Feature request <!-- Requesting the implementation of a new feature --> [ X ] Bug report <!-- Reporting unexpected or erroneous behavior --> [ ] Documentation <!-- Proposing a modification to the documentation --> <!-- Please describe the environment in which you are running NetBox. (Be sure to verify that you are running the latest stable release of NetBox before submitting a bug report.) --> ### Environment * Python version: 3.5.2 * NetBox version: 2.2.2 <!-- BUG REPORTS must include: * A list of the steps needed to reproduce the bug * A description of the expected behavior * Any relevant error messages (screenshots may also help) FEATURE REQUESTS must include: * A detailed description of the proposed functionality * A use case for the new feature * A rough description of any necessary changes to the database schema * Any relevant third-party libraries which would be needed --> ### Description After updating to version 2.2.2, I receive the following error message when attempting to view or edit any device. ``` <class 'django.db.utils.ProgrammingError'> column ipam_service.virtual_machine_id does not exist LINE 1: ...vice"."last_updated", "ipam_service"."device_id", "ipam_serv... ```
adam closed this issue 2025-12-29 16:31:38 +01:00
Author
Owner

@darkstar commented on GitHub (Oct 23, 2017):

Are you sure you ran the upgrade.sh script? From which version did you upgrade? This is probably the same problem as reported in #1635

You might need to upgrade your PostgreSQL installation

@darkstar commented on GitHub (Oct 23, 2017): Are you sure you ran the upgrade.sh script? From which version did you upgrade? This is probably the same problem as reported in #1635 You might need to upgrade your PostgreSQL installation
Author
Owner

@robduffy2010 commented on GitHub (Oct 23, 2017):

It turned out I had two Postgres versions running and Netbox was using the old one (9.3). I configured it to use the new version and everything is working now. Thanks for the quick response and sorry for the noise!

@robduffy2010 commented on GitHub (Oct 23, 2017): It turned out I had two Postgres versions running and Netbox was using the old one (9.3). I configured it to use the new version and everything is working now. Thanks for the quick response and sorry for the noise!
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#1345