Layer7 API Management

  • 1.  Troubleshoot CA API Gateway Replication errors

    Posted Mar 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

    Broadcom Employee
    Posted Mar 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 Mar 06, 2017 01:34 PM

    Thank you Mark !

    I will try the recommended steps in the note.