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?

Markdown is supported
Copy & paste or drag & drop images (max 30 MB per image)

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

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)