NetXMS Support Forum

After deleting these 2 DCI tables I don't see this error anymore.

edit:
thanks!

How can I find the name or ID of this table?

edit:
I suppose '1466' of 'tdata_1466' is the ID of the node. I see 2 test tables collected every minute. I just deleted both.

We see from time to time this error in server log:

[ERROR] SQL query failed (Query = "INSERT INTO tdata_1466 (item_id,tdata_timestamp,record_id) VALUES (?,?,?)"): 23505 ERROR:  duplicate key value violates unique constraint "tdata_1466_record_id_key "
DETAIL:  Key (record_id)=(1558995887784001536) already exists.

We are on NetXMS V2.0 on PostgreSQL.

How can we fix this?

I will update today!

Happy new year to all

In my opinion I would say yes! (11h of test)

The SNMP_AUTH_FAILURE events are gone!
For the other problems I need more time to test.

thanks for the fixes
Dani

Thanks Alex for the fast fix

Now downloading the snapshot from download site on website, './reconf', 'configure...', 'make',... works!

Thanks Tomas.

I tried to compile hourly snapshot from git repo. But I get this error:

make[3]: Entering directory `/usr/src/netxms-2.0-dev-2015-12-14/src/libstrophe'
  CC       libstrophe_la-auth.lo
In file included from ../../include/nms_common.h:78:0,
                 from auth.c:19:
../../include/netxms-version.h:27:30: fatal error: netxms-build-tag.h: No such file or directory
#include <netxms-build-tag.h>
                              ^
compilation terminated.
make[3]: *** [libstrophe_la-auth.lo] Error 1
make[3]: Leaving directory `/usr/src/netxms-2.0-dev-2015-12-14/src/libstrophe'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/src/netxms-2.0-dev-2015-12-14/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/netxms-2.0-dev-2015-12-14'
make: *** [all] Error 2


autoconf, flex, bison, libtool are installed.
What can I do?

Hi Tomas

I normaly compile from 'official' sources (at the moment V2.0-RC2) on Linux, but I have never built from develop branch.
Do you mean compiling only the server from sources from hourly Snapshot of GIT repository?

Thanks
Dani

I found a hint about this problem in the local log file of the affected node. There is a system protection function which blocks the SNMP get requests from the NetXMS server because of requests with null community string (CVE-1999-0517). In the communication settings of this NetXMS node there are valid SNMPv3 credentials of course.
So maybe this problem has the same reason as the 'SNMP auth. failures'.

I will try it with a support case at the vendor of the APs.

Another problem on other SNMP enabled nodes:
Suddenly no SNMP data is possible to poll. But the SNMP agent on these nodes are fine (test by snmpwalk on command line).
When I restart netxmsd everything is fine again. It's also with SNMPv3.

Hi Victor

I made these tests:
- reenabled routing table poll, waiting 20h -> SNMP agent on node still replying
- reenable topology polling, waiting about 20h -> SNMP agent dead

But what can we do? Is it a problem in NetXMS or in SNMP implementation on node? If it is the second I need good arguments for there support ;-)

edit:
A later test with disabled topology poll -> SNMP agent dead again
So the problem is not fixed to topology poll :-(

thanks
Dani

I know the other issue. But I'm not so sure it is the same. One test node only with deactivated topology and routing table polling is stable for 24h.

Hi Victor

The test AP is now stable for 18h. I only have tested with one of the affected APs because of some other APs I do not have credentials to reboot. I have to contact my customer each time.
Do you have a suspicion?


thanks
Dani

Ok I will try on one AP.
So only NetXMS agent-, routing table- and topology-polling are disabled, everything else is enabled again. I will check and report.

Beside I also have SNMP_AUTH_FAILURE events on these nodes (since V2.0-RC2)