Track and troubleshoot MySQL source Log stream target disconnects

[GT_SrDBA]

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.

[john_wang · Accepted solution]

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.