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

Question

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,'

Answer 1

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 **