The following log messages may be seen within the gateways ssg_0_0.log file:
com.l7tech.server.service.ServiceMetricsServicesImpl: Failed to save a MetricsBin due to constraint violation
org.hibernate.util.JDBCExceptionReporter: SQL Error: 1062, SQLState: 23000
org.hibernate.util.JDBCExceptionReporter: Duplicate entry 'xxxxxxxxxxxxxxx' for key 'nodeid'
This situation has been seen on the 8.x and 9.x release of the gateway
There is a known defect in the 8.x release of the gateway where restarting the gateway by executing:
service ssg restart
might not bring down the gateway processes gracefully resulting in multiple gateway processes
running which lead to the messages in question being seen.
This can be resolved in the interim by performing the following procedure:
1. Stop the Gateway service: service ssg stop
2. Kill all remaining Gateway processes: ps awwx | grep [G]ateway.jar | awk $'{print $1}' | xargs kill -9
3. Start the Gateway service: service ssg start
We would suggest to stop the gateway going forward by executing:
service ssg stop
We would suggest to start the gateway going forward by executing:
service ssg start