Failed DB Query count

Started by Egert143, January 08, 2021, 10:29:58 AM

Previous topic - Next topic

Egert143

Hello

I was testing different DCi options for internal server monitoring, and i found parameter "Server.DB.Queries.Failed" that returns 2164256 failed querys, that surely cant be good number?
After that i checked event monitor and there are multiple entries about: 08.01.2021 10:25:33 NetXms Critical SYS_DB_QUERY_FAILED Database query failed (Query: INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?); Error: 23505 ERROR:  duplicate key value violates unique constraint "interface_vlan_list_pkey"
DETAIL:  Key (iface_id, vlan_id)=(104256, 1) already exists.)


How to fix that ?

Egert

Alex Kirhenshtein

Which version you are currently using?

Egert143

Version is 3.7.95 and database is PostgreSQL.

Egert

Filipp Sudanov

Do you monitor Cisco Nexus devices?
If yes, this could be related to a bug with recent changes in Nexus driver. That bug is fixed, fix will be included in next patch release.

Egert143

Nexus devices are monitored yes.