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