Print Page - SYS_DB_QUERY_FAILED in table ap

Title: SYS_DB_QUERY_FAILED in table ap_common
Post by: Dani@M3T on October 26, 2017, 09:04:24 PM

Hi

We see frequent critical events like this:


Database query failed (Query: INSERT INTO ap_common (policy_type,version,id) VALUES (?,?,?); Error: 23505 ERROR: duplicate key value violates unique constraint "ap_common_pkey"DETAIL: Key (id)=(1816) already exists.)

where ids are different. I checked all affected ids are really existing in db table.

Install is NetXMS 2.1.2 on linux, db is PostgreSQL

thanks for any help
Dani

Title: Re: SYS_DB_QUERY_FAILED in table ap_common
Post by: Ēriks Jenkēvics on October 27, 2017, 10:39:48 AM

Hi!

This is a known bug which is fixed in our development branch. Once the next release is ready, it will include the fix also.

Regards,
Eriks

Title: Re: SYS_DB_QUERY_FAILED in table ap_common
Post by: Dani@M3T on October 27, 2017, 10:42:32 AM

Hi Eriks

Ok thanks for your quick reply.

thanks
Dani

NetXMS Support Forum

English Support => General Support => Topic started by: Dani@M3T on October 26, 2017, 09:04:24 PM