Activities of "mpineiro"

Hi ismcagdas,

Yes, we have configured the sticky sessions and the redis backplane, before we configured it we had some errors in the console about the signalR connection, but those have been resolved.

A few days ago we added a test button on the frontend to test the notifications and it works fine, the problem we have now is when the worker sends the request to the backend, so we think it might be something related to the sessions or cache.

Setup Details: Product version: v10.3.0 Product type: ASP.NET CORE & Angular ABP Framework version: 6.3.0

First off, I'd like to provide some context about our project. Before our recent changes, we had our ASP.NET Zero project deployed on a Windows server. However, we've recently decided to modernize our stack, dockerizing the application and migrating it to Azure. Alongside Docker, we're also utilizing Kubernetes for container orchestration. In addition, we've integrated Redis, which runs without any hitches.

The main challenge we're facing relates to real-time notifications using SignalR. When we test the functionality directly from the frontend through a button that triggers an endpoint in our backend, the notifications are generated and received in real-time regardless of the number of backend instances in operation.

However, we've encountered an issue with another flow within our system. We have a worker setup for background jobs that, upon completing certain processes, sends a request to the backend to generate and dispatch a notification. While the notification gets correctly generated in the database, we've noticed inconsistencies in its delivery via SignalR when initiated from the worker. This specific problem only arises in the flow between the worker and the backend when we operate with multiple backend instances. We're wondering if this issue might be tied to backend cache or session management, which could potentially impact notification transmission. Could sessions or cache be interfering?

Has anyone encountered similar challenges or has suggestions on how to approach this?

Any guidance or assistance would be greatly appreciated. Thank you.

Thank you very much for your reply. Greetings!

Thank you. What I mainly need to know is if, when creating a new microservice, it should include all the Abp Zero libraries in order to generate the microservice project.

Hello,

I wanted to know if to generate a microservice with ASP.NET ZERO, I need to have all the structure of ABP ZERO in my code. If you have a simple example, it would be very helpful.

Thank you so much Greetings

Thank you, I already sent the logs of our application to the indicated email. We look forward to a prompt response to solve this problem.

Hi @ismcagdas

Thanks for your answer. We do not use SingleAsync and the queries shown in the shared log are NET ZERO's own, they are not our queries. I ask you to follow the case and give us a prompt solution because it is very critical for our business.

Hello, Any update ? Is critical for us. Please, We need help !

Hello, Any update ? Is critical for us

In my web application, the following query throws an error and causes my application to stop seeing the database server, which causes me to have to restart my application server. Then I put the whole log so you can analyze the case:

ERROR 2023-03-17 12:38:00,638 [210 ] oft.EntityFrameworkCore.Database.Command - Failed executing DbCommand (0ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean), @__ef_filter__p_1='?' (DbType = Boolean), @__ef_filter__CurrentTenantId_2='?' (DbType = Int32), @__p_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[AuthenticationSource], [a].[ConcurrencyStamp], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[EmailAddress], [a].[EmailConfirmationCode], [a].[GoogleAuthenticatorKey], [a].[IsActive], [a].[IsDeleted], [a].[IsEmailConfirmed], [a].[IsExternalUser], [a].[IsLockoutEnabled], [a].[IsPhoneNumberConfirmed], [a].[IsTwoFactorEnabled], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[LockoutEndDateUtc], [a].[Name], [a].[NormalizedEmailAddress], [a].[NormalizedUserName], [a].[Password], [a].[PasswordResetCode], [a].[PhoneNumber], [a].[ProfilePictureId], [a].[SecurityStamp], [a].[ShouldChangePasswordOnNextLogin], [a].[SignInToken], [a].[SignInTokenExpireTimeUtc], [a].[Surname], [a].[TenantId], [a].[UserName] FROM [AbpUsers] AS [a] WHERE (((@__ef_filter__p_0 = CAST(1 AS bit)) OR ([a].[IsDeleted] <> CAST(1 AS bit))) AND ((@__ef_filter__p_1 = CAST(1 AS bit)) OR ([a].[TenantId] = @__ef_filter__CurrentTenantId_2))) AND ([a].[Id] = @__p_0) ERROR 2023-03-17 12:38:00,639 [210 ] Microsoft.EntityFrameworkCore.Query - An exception occurred while iterating over the results of a query for context type 'Worldsys.Compliance.EntityFrameworkCore.ComplianceDbContext'. System.Threading.Tasks.TaskCanceledException: A task was canceled. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() System.Threading.Tasks.TaskCanceledException: A task was canceled. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() ERROR 2023-03-17 12:38:10,144 [142 ] .EntityFrameworkCore.Database.Connection - An error occurred using the connection to database 'ComplianceProd' on server 'xxx.xx.xxx.xxx'. ERROR 2023-03-17 12:38:10,144 [204 ] .EntityFrameworkCore.Database.Connection - An error occurred using the connection to database 'ComplianceProd' on server 'xxx.xx.xxx.xxx'.

Where I put the x, is our database server IP

I would appreciate any help you can give me.