Track and troubleshoot MySQL source Log stream target disconnects

GT_SrDBA — Thu, 19 Aug 2021 15:50:34 GMT

Hello,

I am seeing where our task is disconnecting from MySQL which is the source. The target is a log stream.

I am seeing this error message.

00001304: 2021-08-18T05:24:52 [SOURCE_CAPTURE ]E: Error 2002 (Can't connect to MySQL server on

I've checked with our network team and they said it isn't the firewall dropping the connection. The platform team says there isn't an issue with the server itself.

The tasks recovers and continues to process the data. I am just seeing intermittent disconnects happening.

Anyone experience this? Is there a way to track and/or troubleshoot disconnections from the source?

Thanks.

Re: Track and troubleshoot MySQL source Log stream target disconnects

john_wang — Thu, 19 Aug 2021 23:04:03 GMT

Hello @GT_SrDBA ,

Thanks for you contacting Qlik Support.

In general this is MySQL environment relevant issue. Qlik Replicate connects to MySQL Server thru MySQL Client/Server mode. If you config an ODBC DSN (it's irrelevant to Replicate but a pure C/S connectivity) and try to access it by standard ODBC tools, you probably get the same issue.

MySQL website provides a troubleshooting list for ERROR 2002:

https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html

Hope it helps.

Regards,

John.

topic Track and troubleshoot MySQL source Log stream target disconnects in Qlik Replicate

Track and troubleshoot MySQL source Log stream target disconnects

Re: Track and troubleshoot MySQL source Log stream target disconnects