arnoldasgudas / Hangfire.MySqlStorage

MySql storage for Hangfire - fire-and-forget, delayed and recurring tasks runner
GNU Lesser General Public License v3.0
175 stars 114 forks source link

MySql.Data.MySqlClient.MySqlException (0x80004005): Too many connections #56

Open LucasFarley opened 5 years ago

LucasFarley commented 5 years ago

I am using Hangifre Hangfire 1.6.21 with Hangfire.MySql.Core 2.1.8 and i am facing the problem [Too many connections]. However, I just have 20 work process in Linux server that accept more process.
Due this error the DOTNET Application is shutting down.

Could you help me?

  Too many connections

MySql.Data.MySqlClient.MySqlException (0x80004005): Too many connections at MySqlConnector.Core.ServerSession.ConnectAsync(ConnectionSettings cs, ILoadBalancer loadBalancer, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ServerSession.cs:line 288 at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ConnectionPool.cs:line 112 at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ConnectionPool.cs:line 141 at MySql.Data.MySqlClient.MySqlConnection.CreateSessionAsync(Nullable1 ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlConnection.cs:line 405 at MySql.Data.MySqlClient.MySqlConnection.OpenAsync(Nullable1 ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlConnection.cs:line 175 at MySql.Data.MySqlClient.MySqlConnection.Open() in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlConnection.cs:line 161 at Hangfire.MySql.Core.MySqlStorage.CreateAndOpenConnection() at Hangfire.MySql.Core.JobQueue.MySqlJobQueue.Dequeue(String[] queues, CancellationToken cancellationToken) ^CApplication is shutting down...