question

Yorozuya-1736 avatar image
0 Votes"
Yorozuya-1736 asked SaurabhSharma-msft answered

Communications link failure error in Synapse dataflow: com.mysql.cj.jdbc.exceptions.CommunicationsException

I'm getting a connection error in a Synapse dataflow while trying to debug or test source connection to an integration dataset linked to an Azure MySQL database.

116244-image.png

The MySQL server is working elsewhere and copy operations on the integration dataset in the pipeline are working too, and metadata like column names is appearing in operations in the dataflow, but Data flow debug is giving this error.

azure-synapse-analyticsazure-database-mysql
image.png (31.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @yorozuya-1736,
Thanks for using Microsoft Q&A !!
I am able to replicate this issue and getting the same error when trying to test the connection from DataFlow. I am checking internally with the products team on the same and update you as soon as I hear back them.
116865-image.png

Thanks
Saurabh


0 Votes 0 ·
image.png (21.6 KiB)

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered

Hi @yorozuya-1736,

I have received confirmation from the products team that this is a known issue and the fix is pending deployment in the production. I do not have any confirmed ETA for the same but tentatively it will be deployed in next 3-4 weeks.

Thanks
Saurabh

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.