Error updating JDBC_PING table

[Former Member]

Hi All,

We are getting below error from JGROUPS. Sometimes we see that there are duplicate entries for a node in JGROUPSPING table.

Do we need to do any changes in the configuration?

[Timer-4,hybris-broadcast,hybrisnode-6] [JDBC_PING] JGRP000145: Error updating JDBC_PING table com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '' for key 'PRIMARY'

[geffchang]

What Hybris version (a.b.c.d) are you using? What mySQL version?

[Former Member]

We are using hybris 6.5 version and MySQL 5.6.35

[9999999]

In our case it happened during deployments.

After Cleanup the JGROUPSPING table, the issue was resolved.

{"instant":{"epochSecond":1688978210,"nanoOfSecond":408231646},
"thread":"jgroups-109,hybris-broadcast,hybrisnode-2","level":"ERROR",
"loggerName":"org.jgroups.protocols.JDBC_PING",
"message":"JGRP000145: Error updating JDBC_PING table",
"thrown":{"commonElementCount":0,"localizedMessage":
"Violation of PRIMARY KEY constraint 'PK__JGROUPSP__777382E1B94D3482'. 
Cannot insert duplicate key in object 'dbo.JGROUPSPING'. 
The duplicate key value is (3ec046f5-2216-02d9-713d-ce8346bca82f, 
hybris-broadcast).","message":"Violation of PRIMARY KEY constraint 
'PK__JGROUPSP__777382E1B94D3482'. Cannot insert duplicate key in object '
dbo.JGROUPSPING'. The duplicate key value is 
(3ec046f5-2216-02d9-713d-ce8346bca82f, hybris-broadcast).
","name":"com.microsoft.sqlserver.jdbc.SQLServerException",
"extendedStackTrace":[{"class":"com.microsoft.sqlserver.jdbc.SQLServerException",
"method":"makeFromDatabaseError","file":"SQLServerException.java",
"line":265,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"