exceeded the 'max_user_connections' resource (current value: 100),Source=mscorlib,'

Ramakrishna, Konakanchi 0 Reputation points
2024-03-23T17:17:41.8733333+00:00

From ADF :

ErrorCode=UserErrorAzureMysqlNetConnectionError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=connection exception:User 'proreg_adf_svc' has exceeded the 'max_user_connections' resource (current value: 100),Source=Microsoft.DataTransfer.Runtime.AzureMySqlNetConnector,''Type=MySql.Data.MySqlClient.MySqlException,Message=User 'proreg_adf_svc' has exceeded the 'max_user_connections' resource (current value: 100),Source=mscorlib,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,464 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vahid Ghafarpour 17,700 Reputation points
    2024-03-23T21:31:24.9066667+00:00

    You can increase the 'max_user_connections' limit for the 'proreg_adf_svc' user in your Azure MySQL server settings. This can be done through the Azure portal or using MySQL commands.

    ALTER USER 'proreg_adf_svc'@'%' WITH MAX_USER_CONNECTIONS 200;
    

    But it is better to avoid keeping connections open for longer than necessary and consider using connection pooling to manage connections more efficiently.

    https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-performance-features

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

    0 comments No comments