Print Page - Failed DB Query count

Title: Failed DB Query count
Post by: Egert143 on January 08, 2021, 10:29:58 AM

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:

Code Select

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

Title: Re: Failed DB Query count
Post by: Alex Kirhenshtein on January 08, 2021, 11:09:59 AM

Which version you are currently using?

Title: Re: Failed DB Query count
Post by: Egert143 on January 08, 2021, 11:13:18 AM

Version is 3.7.95 and database is PostgreSQL.

Egert

Title: Re: Failed DB Query count
Post by: Filipp Sudanov on January 08, 2021, 12:44:50 PM

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.

Title: Re: Failed DB Query count
Post by: Egert143 on January 08, 2021, 03:07:02 PM

Nexus devices are monitored yes.

NetXMS Support Forum

English Support => General Support => Topic started by: Egert143 on January 08, 2021, 10:29:58 AM