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":"?"

[former_member1085063]

Today I got into a situation in which "updatesystem" was being interrupted with the following exception:

 org.apache.ddlutils.DatabaseOperationException: java.sql.SQLSyntaxErrorException: Table 'jgroupsping' doesn't exist
 ...
 Caused by: java.sql.SQLSyntaxErrorException: Table 'jgroupsping' doesn't exist
 ...

By mistake I had installed mysql connector 8.0 (Hybris 1808.2 with MySQL 5.6.36) .
I just installed a much older version (5.0.8) and it all started working again.

Hope it helps somehow (even though it's a bit late 🙂

Cheeers,
Carlos

[former_member1320010]

Did you try to go to hac and ping the nodes (in cluster tab) usually it tries to refresh itself

[Former Member]

Yes, we did but no change after that