Hello,
I've check my logs on ipdevpoll and I found this :
2019-01-28 17:37:28,698 [ERROR jobs.jobhandler] [statuscheck
PAL-SW-R1-13.res.iogs] Caught exception during save. Last manager =
DefaultManager(<class 'nav.ipdevpoll.shadows.POEPort'>,
'ContainerRepository'(...)). Last model = <class
'nav.ipdevpoll.shadows.POEPort'>
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/nav/ipdevpoll/jobs.py", line
442, in _perform_save
manager.save()
File "/usr/lib/python2.7/dist-packages/nav/ipdevpoll/storage.py",
line 87, in save
obj.save(self.containers)
File "/usr/lib/python2.7/dist-packages/nav/ipdevpoll/storage.py",
line 476, in save
obj.save()
File "/usr/lib/python2.7/dist-packages/django/db/models/base.py",
line 589, in save
force_update=force_update, update_fields=update_fields)
File "/usr/lib/python2.7/dist-packages/django/db/models/base.py",
line 617, in save_base
updated = self._save_table(raw, cls, force_insert, force_update,
using, update_fields)
File "/usr/lib/python2.7/dist-packages/django/db/models/base.py",
line 698, in _save_table
result = self._do_insert(cls._base_manager, using, fields,
update_pk, raw)
File "/usr/lib/python2.7/dist-packages/django/db/models/base.py",
line 731, in _do_insert
using=using, raw=raw)
File "/usr/lib/python2.7/dist-packages/django/db/models/manager.py",
line 92, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/django/db/models/query.py",
line 921, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File
"/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py",
line 921, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/python2.7/dist-packages/django/db/backends/utils.py",
line 65, in execute
return self.cursor.execute(sql, params)
File "/usr/lib/python2.7/dist-packages/django/db/utils.py", line 94,
in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/lib/python2.7/dist-packages/django/db/backends/utils.py",
line 65, in execute
return self.cursor.execute(sql, params)
IntegrityError: ERREUR: une valeur NULL viole la contrainte NOT NULL de
la colonne « classification »
DETAIL: La ligne en échec contient (599034, 49, 66, null, 34, t, 2, 4,
null)
2019-01-28 17:37:28,701 [ERROR jobs.jobhandler] [statuscheck
PAL-SW-R1-13.res.iogs] Job 'statuscheck' for PAL-SW-R1-13.res.iogs
aborted: Job aborted due to save failure (cause=IntegrityError('ERREUR:
une valeur NULL viole la contrainte NOT NULL de la colonne \xc2\xab
classification \xc2\xbb\nDETAIL: La ligne en \xc3\xa9chec contient
(599034, 49, 66, null, 34, t, 2, 4, null)\n',))
2019-01-28 17:37:28,703 [INFO schedule.netboxjobscheduler] [statuscheck
PAL-SW-R1-13.res.iogs] statuscheck for PAL-SW-R1-13.res.iogs failed in
0:00:14.603465. next run in 0:04:59.999955.
It seems it doesn't like the PoE on my Dell N2048P because of a NULL
value in "classification" column.
Do you have an idea ?
Regards
--
Cordialement,
IOGS Logo <https://www.institutoptique.fr>
*Ludovic Vinsonnaud * - Ingénieur Réseau
basé à Bordeaux, bureau F108 (IOA, Rue François Mitterrand, 33400 Talence)
*Institut Optique Graduate School*
2 Avenue Augustin Fresnel - 91127 PALAISEAU Cedex
Tel. +33 5 57 01 71 52 - Mob. +33 6 08 08 41 05
Hi,
we have a 3850 Stack with 3x ES-C3850-48T-S and 5x WS-C3850-12X48U. When
we try to PortAdmin and edit a Port we get (see also attached Jpg):
„IP device found but has no type“
Any ideas?
Cheers,
Mischa
--
Mischa Diehm | Network Team (NINS)
UniBasel | IT-Services (ITS)
Klingebergstr. 70 | CH-4056 Basel
Tel. +41 61 267 1574 | https://its.unibas.ch
The fourth maintenance release of the 5.0 series of NAV is now out!
The source code is available for download at GitHub [1].
New packages for Debian 9/10 (Stretch/Buster) are available in our APT
repository [2] as usual.
Please also be extra aware of config file changes. Look out for
`*.dpkg-dist` files in /etc/nav and make sure to update your running
config.
The virtual appliance will be updated shortly.
Deprecation warning
===================
Python 2 reached its end-of-life on **January 1, 2020**. NAV 5.0
therefore moves to Python 3, and as such, you will need at least Python
3.5 to run NAV.
Most of NAV will still run on Python 2 as of the 5.0 release, but from
this point, Python 2 will be deprecated and we will start removing code
that exists solely to keep compatibility with Python 2.
Changes
=======
Fixed GitHub issues in this release:
* #2074 ([BUG] ipdevpoll inventory job crashes for many devices with
an AttributeError)
* #2075 ([BUG] Editing existing API tokens shows no enabled endpoints)
* #2076 ([BUG] Missing Javascript multiselect library used by
Useradmin API token form)
* #2077 ([BUG] string handling in snmptrapd is broken on Python 3)
* #2081 ([BUG] Bulk importing netboxes without a managment profile
raises an exception)
* #2083 ([BUG] TypeError is raised when creating a csv for download
from a room-search)
* #2085 ([BUG] TypeError is raised when getting navlet)
* #2087 ([BUG] Reports with many pages crash once page 4 is visited)
* #2090 ([BUG] Marking machine as disabled in arnold raises TypeError)
* #2092 ([BUG] ipdevinfo sensor tab produces too large Graphite
request)
* #2093 ([BUG] PortAdmin crashes when viewing a switch with non-ASCII
port descriptions)
* #2097 ([BUG] Adding a manual detention without a number of days
until autoenable crashes Arnold)
Please see the release notes [3] for more details. Happy NAVing
everyone!
Links
=====
[1] https://github.com/UNINETT/nav/releases
[2] https://nav.uninett.no/install-instructions/#debian
[3] https://nav.uninett.no/doc/latest/release-notes.html#nav-5.0
--
Sincerely,
Morten Brekkevold
Uninett