Share via

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

Yorozuya 1 Reputation point
2021-07-20T08:29:26.363+00:00

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 Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator
    2021-07-22T22:36:57.6+00:00

    Hi @Yorozuya ,

    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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.