Intermittent Connection Issues with Azure MySQL Flexible Server

33151609 1 Reputation point
2024-10-24T10:44:26.2433333+00:00

Hello since yesterday evening we are experiences Intermittent connection with our MySQL Flexible Server where all front ends are having issues , PowerBI , Synapse Pipeline runs , Mysql front end , in resume all tools that connect with this server are experience errors as bellow
We already reboot the server and same issue , no changes have been made in the server so we wonder if this is central issue with the network.

Appreciate your help
Thanks
Paulo

Synapse Pipeline runs :
Common error :
Failure happened on 'Sink' side. 'Type=MySql.Data.MySqlClient.MySqlException,Message=Failed to read the result set.,Source=MySqlConnector,''Type=System.IO.EndOfStreamException,Message=Expected to read 4 header bytes but only received 0.,Source=mscorlib,'

Power BI :
Common error:

|An
error occurred while processing the data in the semantic model.
Refresh failed:

Conversao_Marketing
has failed to refresh.

Failure details: The last refresh attempt failed because of an internal
service error. This is usually a transient issue. If you try again later and
still see this message, contact support.
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":""}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":""}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}
Table: Produto.
Next refresh for
Conversao_Marketing is scheduled for October 24, 2024 12:00 UTC.|| | -------- | -------- | |An error occurred while processing the data in the semantic model. Refresh failed: Conversao_Marketing has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":""}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":""}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Produto. Next refresh for Conversao_Marketing is scheduled for October 24, 2024 12:00 UTC.||

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.
4,974 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 16,640 Reputation points Microsoft Vendor
    2024-10-24T21:12:28.2133333+00:00

    Hi @33151609

    Thanks for posting your query in Q&A platform.

    I’m sorry to hear about the intermittent connection issues you’ve been facing with your MySQL Flexible Server. I understand how disruptive this can be, especially when it’s affecting multiple tools like Power BI, Synapse pipelines, and your front-end applications.

    It’s good that you’ve already tried rebooting the server, but since the issue persists across all connections, it might indicate a deeper problem. Here are a few suggestions that could help resolve the issue:

    • Sometimes, service disruptions can occur at the regional level. Have you checked the Azure Service Health dashboard to ensure there are no ongoing issues in your region?
    • Since all tools are affected, there could be a network-related issue. Please review your network configurations to ensure there aren’t any firewall or DNS problems affecting the connection to the MySQL Flexible Server.
    • I recommend enabling diagnostic logging for your MySQL server. This should provide more details on any errors that may be occurring under the hood.
    • The error in your Synapse pipeline suggests there might be a connection timeout issue. It could help to review and adjust your connection timeout settings for both Synapse and Power BI to ensure they can handle larger or longer-running queries.
    • Sometimes, high resource utilization on the server can lead to intermittent failures. It might be worth checking if your server needs scaling to handle the current load.

    I hope these steps provide some direction, but if the issue continues, I’d recommend reaching out to Azure Support for further assistance. Please let me know if you need any more details..


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.