Activities of "mpineiro"

El problema que se describe a continuación está generando caídas constantes en la plataforma, necesitamso por favor nos guíen en la solución. Como podemos abordar este problema de múltiples conexiones abiertas?

Se observan cada tanto muchisimos queries del estilo

/* Params ( @__ef_filter__p_0 BIT ,@__ef_filter__CurrentTenantId_1 INT ,@__p_0 BIGINT ) */

SELECT [a].[Id] ,[a].[ExpireDate] ,[a].[LoginProvider] ,[a].[Name] ,[a].[TenantId] ,[a].[UserId] ,[a].[Value] FROM [AbpUserTokens] AS [a] WHERE ( (@__ef_filter__p_0 = CAST(1 AS BIT)) OR ([a].[TenantId] = @__ef_filter__CurrentTenantId_1) ) AND ([a].[UserId] = @__p_0)

Estas conexiones quedan en sleeping pero con transaccion abierta.O sea no haciendo nada del lado del SQL pero con transaccion abierta.

Similar tambien con

( @p0 DATETIME2(7) ,@p1 NVARCHAR(128) ,@p2 NVARCHAR(128) ,@p3 INT ,@p4 BIGINT ,@p5 NVARCHAR(512) )

SET NOCOUNT ON;

INSERT INTO [AbpUserTokens] ( [ExpireDate] ,[LoginProvider] ,[Name] ,[TenantId] ,[UserId] ,[Value] ) VALUES ( @p0 ,@p1 ,@p2 ,@p3 ,@p4 ,@p5 );

SELECT [Id] FROM [AbpUserTokens] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();

Pueden estar mas de 10 minutos en sleeping. Probablemente sea la transaccion con ese Nombre.Probablemente asignado por Entity Framework. De cualquier forma hay algun problema con el manejo de los AbpUserTokens.

Hi, The issue described previously is related to AbpUserTokens. A lot of connections keep "Sleeping" Status after authenticating method request. Requested Information about version is Attached.

Asp Net Zero version is Old because we purchase recent version recently (we did not update yet)

We need to know if is possible to solve this issue with actual version or is neccessary to update. In this case which steps we have to consider.

Thank you

REQUESTED FILES: https://workdrive.zohoexternal.com/external/3ea5c291564043a4afc2537793dcfd109351d3cb893ec6ae08b4badcc40acaf3

Hello, any update about this ? Thank you

Hello, thank you for your answer. We checked your github article but I am not sure if this milestone will FIX the issue related to "Sleeping" connections (mentioned before). I saw documentation related to Expired Tokens BUT NOT Sleeping connection.

Is the same issue ?

Thanks

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.

Hello, Any update ? Is critical for us

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

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.

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.

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