Base solution for your next web application
Open Closed

Background Jobs & notification queries executing in background and blocking #10269


User avatar
0
razkhan78 created

AspNetZero (Paid) Product version --> 4.0 Product type --> MVC Product framework type --> .net core 2.1

Right now we don't have any background job using worker but we see some queries in log which are blocking

(@p9 bigint,@p0 datetime2(7),@p1 bigint,@p2 bit,@p3 nvarchar(4000),@p4 nvarchar(512),@p5 datetime2(7),@p6 datetime2(7),@p7 tinyint,@p8 smallint)UPDATE [AbpBackgroundJobs] SET [CreationTime] = @p0, [CreatorUserId] = @p1, [IsAbandoned] = @p2, [JobArgs] = @p3, [JobType] = @p4, [LastTryTime] = @p5, [NextTryTime] = @p6, [Priority] = @p7, [TryCount] = @p8 WHERE [Id] = @p9

and also some queries deleting logs (@p0 uniqueidentifier)DELETE FROM [AbpNotifications] WHERE [Id] = @p0

We haven't configured so far for it, so we need to know when and at what interval these queries are getting executed? And is there any way we can disable it?


1 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @razkhan78

    AspNet Zero automatically tries to execute background jobs. If you don't have any background jobs, it will query AbpBackgroundJobs and will not execute any job.

    For Notifications, a notification is deleted automatically when the notification is sent to a user.

    You can disable job execution as shown here