Layer7 API Management

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  Hi all I'm seeing this below error in both nodes on my Gateway. Could you please suggest any solution for this.

    Posted 02-15-2018 09:59 AM

    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')'



  • 2.  Re: Hi all I'm seeing this below error in both nodes on my Gateway. Could you please suggest any solution for this.
    Best Answer

    Posted 02-15-2018 01:24 PM

    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



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

    Posted 02-15-2018 02:02 PM

    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. 



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

    Posted 02-15-2018 03:32 PM

    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