SYS_DB_QUERY_FAILED in table ap_common

Started by Dani@M3T, October 26, 2017, 09:04:24 PM

Previous topic - Next topic

Dani@M3T

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

Ēriks Jenkēvics

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

Dani@M3T

Hi Eriks

Ok thanks for your quick reply.

thanks
Dani