Hi all I'm seeing this below error in both nodes on my Gateway. Could you please suggest any solution for this.

[Prem]

Error 'Duplicate entry '0971799962f14d20ab48f7f95d72d398-\x00\x00\x00\x00\x00\x00\x00\x0' for key 'nodeid'' on query. Default database: 'ssg'. Query: 'insert into service_metrics (nodeid, end_time, interval_size, back_max, front_max, back_min, front_min, attempted, authorized, completed, period_start, resolution, published_service_goid, service_state, start_time, back_sum, front_sum, goid) values ('0971799962f14d20ab48f7f95d72d398', 1518019565000, 5000, null, null, null, null, 0, 0, 0, 1518019560000, 0, x'0000000000000000FFFFFFFFFFFFFFFF', null, 1518019560000, 0, 0, x'2C993BE8FD2512B6191D0C975F4F77D4')'

[Joe Dascole]

Hi Prem,

 

These types of errors can occur when there is network latency between the nodes. I would recommend following this doc to reinitialize replication.

 

Reinitialize replication in a multi-node cluster 

 

Regards,

Joe

[Prem]

Hi Joe,

Thanks for your reply. We did replication like three weeks before after that it was working fine. But now I'm again seeing the same error.. Do I have to the replication process again. Could please provide any suggestion while we are even seeing after replication. 

[Joe Dascole]

These types of errors can occur with network latency or if the nodes are communicating with different databases (primary vs secondary).

 

You can verify the cluster config by looking at the /opt/SecureSpan/Gateway/node/default/etc/conf/node.properties to confirm they are all pointing to the correct location.

 

Also, when you reinitialize it is important to clone the database to avoid any discrepancy in the data.

 

Regards,

Joe