Layer7 API Management

Expand all | Collapse all

Troubleshoot CA API Gateway Replication errors

Jump to Best Answer
  • 1.  Troubleshoot CA API Gateway Replication errors

    Posted 03-04-2017 06:23 PM

    Hello,

    I am seeing replication errors on both nodes (show slave status\G;).

    The replication was working fine when configured, but seeing error recently.

    The IO thread is not running on primary and SQL thread not running on secondary.

    The primary node shows Last_IO_error (could not find first log file name in binary log index file) and the secondary node shows Last_SQL_error (duplicate entry when inserting into service_metrics)

    What is the best way to resolve these errors.

     

    I am not finding any documentation.

    Please help.

     

    Thank you,

    Rajya



  • 2.  Re: Troubleshoot CA API Gateway Replication errors
    Best Answer

    Posted 03-05-2017 06:19 PM

    Hi Rajya,

    You may need to re-init the replication, please refer to KB article,

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1122741.html 

     

    Regards,

    Mark



  • 3.  Re: Troubleshoot CA API Gateway Replication errors

    Posted 03-06-2017 01:34 PM

    Thank you Mark !

    I will try the recommended steps in the note.