Activities of "vincent.calaor"

I am planning to add Hangfire on our project. I just want to know which project should I use to install the hangfire?

Oh I found it under my Web.Mvc

I am using Abp 4.3.0 and now adapting to Aspnet.Zero

I dont want to migrate my application I just want to make the Hangfire work for now.

Any advice?

and by the way I need the hangfire to work with MySQL

I sorted out. Thanks!

I am able to setup the Hangfire and UseHangfire from the PreInitialize of my abpModule unfortunately I cant see the recurring task from the HangFire Dashboard, but I can see, by break point, that the background worker is hitting the DoWork of my PeriodicBackgroundWorkerBase

I just found out that PeriodicBackgroundWorkerBase is not using hangfire at all. its a standalone triggered by timer.

Anyway I was able to find a code using IRecurringJobManager and implement it with Hangfire.

I want to remove this feature. How can I turn this off permanently?

I want to permanently disable it from the Startup.cs is that possible? I dont want access to this from UI

Hi,

I am using MySQL as my database and running my web application on AWS Linux instance.

Every morning my site is down when I checked the logs it shows that the app cannot connect to MySQL (Command Time Out). I have to restart to make it run again.

Im not sure why is this occuring. I have hangfire running as well, I am not sure if its messing up with the MySQL after leaving it for a while. here are the error on my logs:

fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[1]
0|bars-app  |       An unhandled exception has occurred while executing the request.
0|bars-app  | MySql.Data.MySqlClient.MySqlException (0x80004005): Connect Timeout expired. ---> System.OperationCanceledException: The operation was canceled.
0|bars-app  |    at System.Threading.SemaphoreSlim.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
0|bars-app  |    at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ConnectionPool.cs:line 46
0|bars-app  |    at MySql.Data.MySqlClient.MySqlConnection.CreateSessionAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlConnection.cs:line 507
0|bars-app  |    at MySql.Data.MySqlClient.MySqlConnection.CreateSessionAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlConnection.cs:line 523
0|bars-app  |    at MySql.Data.MySqlClient.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlConnection.cs:line 232
0|bars-app  |    at MySql.Data.MySqlClient.MySqlConnection.Open() in C:\projects\mysqlconnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlConnection.cs:line 218
0|bars-app  |    at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected)
0|bars-app  |    at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
0|bars-app  |    at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransaction(IsolationLevel isolationLevel)
0|bars-app  |    at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)        
0|bars-app  |    at Abp.EntityFrameworkCore.Uow.DbContextEfCoreTransactionStrategy.CreateDbContext[TDbContext](String connectionString, IDbContextResolver dbContextResolver) in D:\Github\aspnetboilerplate\src\Abp.EntityFrameworkCore\EntityFrameworkCore\Uow\DbContextEfCoreTransactionStrategy.cs:line 38
0|bars-app  |    at Abp.EntityFrameworkCore.Uow.EfCoreUnitOfWork.GetOrCreateDbContext[TDbContext](Nullable`1 multiTenancySide, String name) in D:\Github\aspnetboilerplate\src\Abp.EntityFrameworkCore\EntityFrameworkCore\Uow\EfCoreUnitOfWork.cs:line 120

here are the dependencies to MySQL

I will check tomorrow your Query on MySQL when it hangs again. after that I will try to turn off hangfire and see result.

Thanks!