lunkwill42
commented
5 years ago Well, it seems NAV did not get a pethMainPsePower value from the device. This value represents the nominal power of the PSE (Power Sourcing Equipment) in Watts.
It appears the code does not anticipate that this value would ever be missing once it actually gets information about a POE group from a device, but NAV's data model requires the value to be present. I'm not sure what the point of registering POE groups would be if there was no power data attached to it, which is why I guess null values aren't allowed in the model.
There are at leaste a couple of options for a solution, as I see it, but I'm not sure which one would be best - so maybe you have a suggestion:
If no power value could be retrieved from the device:
- Log a warning and just store the value as
0in the database. or - Log a warning and ignore the entire power group, as though it didn't exist.
xorr0
myroom:10.0.51.2:myorg:SW:SNMP v1 read-only profile|public SNMP v1 read-only profile:/var/log/nav/ipdevpoll.logI see the statuscheck job fails with the following log entries (note that the inventory job succeeded on this device):The above exception was the direct cause of the following exception:
Traceback (most recent call last): File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/jobs.py", line 442, in _perform_save manager.save() File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/storage.py", line 87, in save obj.save(self.containers) File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/storage.py", line 482, in save obj.save() File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 808, in save force_update=force_update, update_fields=update_fields) File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 838, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 924, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 963, in _do_insert using=using, raw=raw) File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/query.py", line 1079, in _insert return query.get_compiler(using=using).execute_sql(return_id) File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1112, in execute_sql cursor.execute(sql, params) File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: null value in column "power" violates not-null constraint DETAIL: Failing row contains (23, 492, null, 1, 1, null).
2019-11-07 16:29:56,222 [ERROR jobs.jobhandler] [statuscheck 10.0.51.2] Save stage failed with unhandled error Traceback (most recent call last): File "/usr/lib/python3.7/threading.py", line 917, in _bootstrap_inner self.run() File "/usr/lib/python3.7/threading.py", line 865, in run self._target(*self._args, self._kwargs) File "/opt/venvs/nav/lib/python3.7/site-packages/twisted/_threads/_threadworker.py", line 46, in work task() File "/opt/venvs/nav/lib/python3.7/site-packages/twisted/_threads/_team.py", line 190, in doWork task() --- ---
File "/opt/venvs/nav/lib/python3.7/site-packages/twisted/python/threadpool.py", line 250, in inContext
result = inContext.theWork()
File "/opt/venvs/nav/lib/python3.7/site-packages/twisted/python/threadpool.py", line 266, in
inContext.theWork = lambda: context.call(ctx, func, *args, *kw)
File "/opt/venvs/nav/lib/python3.7/site-packages/twisted/python/context.py", line 122, in callWithContext
return self.currentContext().callWithContext(ctx, func, args, kw)
File "/opt/venvs/nav/lib/python3.7/site-packages/twisted/python/context.py", line 85, in callWithContext
return func(*args,kw)
File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/db.py", line 100, in _reset
return func(*args, *kwargs)
File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/db.py", line 78, in _cleanup
return func(args, kwargs)
File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/jobs.py", line 397, in complete_save_cycle
result = self._perform_save()
File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/jobs.py", line 442, in _perform_save
manager.save()
File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/storage.py", line 87, in save
obj.save(self.containers)
File "/opt/venvs/nav/lib/python3.7/site-packages/nav/ipdevpoll/storage.py", line 482, in save
obj.save()
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 808, in save
force_update=force_update, update_fields=update_fields)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 838, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 924, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/base.py", line 963, in _do_insert
using=using, raw=raw)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/query.py", line 1079, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1112, in execute_sql
cursor.execute(sql, params)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/utils.py", line 94, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/utils/six.py", line 685, in reraise
raise value.with_traceback(tb)
File "/opt/venvs/nav/lib/python3.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
django.db.utils.IntegrityError: null value in column "power" violates not-null constraint
DETAIL: Failing row contains (23, 492, null, 1, 1, null).
2019-11-07 16:29:56,222 [ERROR jobs.jobhandler] [statuscheck 10.0.51.2] Job 'statuscheck' for 10.0.51.2 aborted: Job aborted due to save failure (cause=IntegrityError('null value in column "power" violates not-null constraint\nDETAIL: Failing row contains (23, 492, null, 1, 1, null).\n')) 2019-11-07 16:29:56,224 [INFO schedule.netboxjobscheduler] [statuscheck 10.0.51.2] statuscheck for 10.0.51.2 failed in 0:02:03.310821. next run in 0:04:59.999983.
root@navappliance:/var/log/nav# grep -i "psycopg2.errors.NotNullViolation: null value in column \"power\" violates not-null constraint" ipdevpoll.log | wc -l 27