An exception occurred while iterating over the results of a query for context type '"Volo.Chat.EntityFrameworkCore.ChatDbContext"'." #6985

it is working fine in local environment and but in production and stagging it is throwing the given error

An exception occurred while iterating over the results of a query for context type '"Volo.Chat.EntityFrameworkCore.ChatDbContext"'." ""System.InvalidOperationException: A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext. For more information on how to avoid threading issues with DbContext, see https://go.microsoft.com/fwlink/?linkid=2097913. at Microsoft.EntityFrameworkCore.Infrastructure.Internal.ConcurrencyDetector.EnterCriticalSection() at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext()"

• ABP Framework version: v7.3.2
• UI Type: Angular
• Database System: EF Core (SQL Server)
• Exception message and full stack trace:An exception occurred while iterating over the results of a query for context type '"Volo.Chat.EntityFrameworkCore.ChatDbContext"'." ""System.InvalidOperationException: A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext. For more information on how to avoid threading issues with DbContext, see https://go.microsoft.com/fwlink/?linkid=2097913. at Microsoft.EntityFrameworkCore.Infrastructure.Internal.ConcurrencyDetector.EnterCriticalSection() at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext()"

An exception occurred while iterating over the results of a query for context type '"Volo.Chat.EntityFrameworkCore.ChatDbContext"'." ""System.InvalidOperationException: A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext. For more information on how to avoid threading issues with DbContext, see https://go.microsoft.com/fwlink/?linkid=2097913. at Microsoft.EntityFrameworkCore.Infrastructure.Internal.ConcurrencyDetector.EnterCriticalSection() at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.Enumerator.MoveNext()" contextType "Volo.Chat.EntityFrameworkCore.ChatDbContext" newline " " error "System.InvalidOperationException: A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext. For more information on how to avoid threading issues with DbContext, see https://go.microsoft.com/fwlink/?linkid=2097913. at Microsoft.EntityFrameworkCore.Infrastructure.Internal.ConcurrencyDetector.EnterCriticalSection() at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.Enumerator.MoveNext()" EventId { Id: 10100, Name: "Microsoft.EntityFrameworkCore.Query.QueryIterationFailed" } SourceContext "Microsoft.EntityFrameworkCore.Query" ActionId "b5744e44-c69c-4106-9e58-9f71fcc56002" ActionName "v3.spathios.Controllers.Orders.OrderController.GetOrderWithEventOrderChatUserByEventId (v3.spathios.HttpApi)" RequestId "0HN2JFH8O0JGI:0000001F" RequestPath "/api/app/orders/get-order-with-event-order-chat-user" ConnectionId "0HN2JFH8O0JGI" CorrelationId "dfe15bc3346c46c0a84453c591eac9be" ClientId "spathios_st_App" UserId d2644af0-0dec-eeca-e726-3a11b4f15376 TenantId e28e00ff-6a0c-81cb-a190-3a11b4f1508f Exception Message A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext. For more information on how to avoid threading issues with DbContext, see https://go.microsoft.com/fwlink/?linkid=2097913. Type InvalidOperationException Exception A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext. For more information on how to avoid threading issues with DbContext, see https://go.microsoft.com/fwlink/?linkid=2097913. Stack Trace at Microsoft.EntityFrameworkCore.Infrastructure.Internal.ConcurrencyDetector.EnterCriticalSection() at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable1.Enumerator.MoveNext() at System.Linq.Enumerable.TryGetSingle[TSource](IEnumerable1 source, Boolean& found) at lambda_method8378(Closure, QueryContext) at EventOrderChatUserRepository.GetLastMessageDetails(Nullable1 eventOrderChatUserId, Nullable1 orderId, Nullable1 eventId, Nullable1 chatGroupId) in /home/runner/work/v3.backend/v3.backend/modules/Volo.Chat/src/Volo.Chat.EntityFrameworkCore/Volo/Chat/EntityFrameworkCore/EventOrderChatUsers/EventOrderChatUserRepository.cs:line 48 at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocat...

• Steps to reproduce the issue: while opening chat on staging and production