We are using abp framework microservice template and we already have about 20 microservices. Postgresql is our db system. When there are 1000+ active users, microservices loses connection to administration db. We face db timeouts on administration db, and microservices stops responding when connection to administration db fails. We have optimized the indexes on tables so that cpu, ram etc. compsumptions seem stable on db server, still we could not fix the timeout on administration db. The index usage on db seems fine (especially on administration db), and table scan on queries almost never occur. Queries takes the advantage of indexes on tables. There are more than 500K users on identity users table. OpenIdTokens, AuditLogs, PermissionGrants tables have almost 1.5M rows (each).
Do you have any suggestions to optimize the application on high load? Especially authserver and administration services fails to respond on high load. Because the identity, saas and administration microservices and databases are core essential part of the framework, we are somehow can not figure out why this core elements stuck on high load. We are also ready to purchase a detailed technical assistance from Abp team if possible.
We will be glad for any assistance.
Thanks Murat Gürer
Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.
If you're creating a bug/problem report, please include followings:
I need to access payment menu on blazor app and I can't figure out what is the difference between two startup templates. I dont understand why mvc template does not show any security log line.
Can you help? Regards
ABP Framework version: v7.0.1
UI type: MVC
DB provider: EF Core
Tiered (MVC) or Identity Server Separated (Angular): yes
Exception message and stack trace:
Steps to reproduce the issue:" Hi I have just updated abp cli to v7.0.1
Hi, I have created a new micro-service solution. abp new Demo -t microservice-pro -u mvc.
When I try to restore packages using command "dotnet restore" in the solution root folder, no commercial package can be restored successfully.
I have checked the nuget package sources, and following entry exists; source:https://nuget.abp.io/{my_private_key}/v3/index.json name:ABP Commercial NuGet Source
Here are some error messages I get;
PS F:\Abp\Demo> dotnet restore Determining projects to restore... F:\Abp\Demo\services\product\src\Demo.ProductService.Domain.Shared\Demo.ProductService.Domain.Shared.csproj : error NU1101: Unable to find package Volo.Abp.Commercial.SuiteTemplates. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Visual St udio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\product\src\Demo.ProductService.Application\Demo.ProductService.Application.csproj : error NU1101: Unable to find package Volo.Abp.Commercial.SuiteTemplates. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Visual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\saas\src\Demo.SaasService.Domain.Shared\Demo.SaasService.Domain.Shared.csproj : error NU1101: Unable to find package Volo.Saas.Domain.Shared. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Visual Studio Offline Package s, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\product\src\Demo.ProductService.Domain\Demo.ProductService.Domain.csproj : error NU1101: Unable to find package Volo.Abp.Commercial.SuiteTemplates. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Visual Studio Offline P ackages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\saas\src\Demo.SaasService.Domain.Shared\Demo.SaasService.Domain.Shared.csproj : error NU1101: Unable to find package Volo.Payment.Domain.Shared. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Visual Studio Offline Pack ages, nuget.org [F:\Abp\Demo\Demo.sln] Failed to restore F:\Abp\Demo\services\product\src\Demo.ProductService.Domain.Shared\Demo.ProductService.Domain.Shared.csproj (in 1.49 sec). Failed to restore F:\Abp\Demo\services\saas\src\Demo.SaasService.Domain.Shared\Demo.SaasService.Domain.Shared.csproj (in 1.49 sec). Failed to restore F:\Abp\Demo\services\product\src\Demo.ProductService.Domain\Demo.ProductService.Domain.csproj (in 1.49 sec). Failed to restore F:\Abp\Demo\services\product\src\Demo.ProductService.Application\Demo.ProductService.Application.csproj (in 1.49 sec). F:\Abp\Demo\services\identity\src\Demo.IdentityService.HttpApi.Client\Demo.IdentityService.HttpApi.Client.csproj : error NU1101: Unable to find package Volo.Abp.Identity.Pro.HttpApi.Client. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Vi sual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\identity\src\Demo.IdentityService.HttpApi.Client\Demo.IdentityService.HttpApi.Client.csproj : error NU1101: Unable to find package Volo.Abp.OpenIddict.Pro.HttpApi.Client. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Visual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\identity\src\Demo.IdentityService.HttpApi.Client\Demo.IdentityService.HttpApi.Client.csproj : error NU1101: Unable to find package Volo.Abp.Account.Pro.Admin.HttpApi.Client. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microso ft Visual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\identity\src\Demo.IdentityService.HttpApi.Client\Demo.IdentityService.HttpApi.Client.csproj : error NU1101: Unable to find package Volo.Abp.Identity.Pro.Application.Contracts. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Micro soft Visual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\identity\src\Demo.IdentityService.HttpApi.Client\Demo.IdentityService.HttpApi.Client.csproj : error NU1101: Unable to find package Volo.Abp.OpenIddict.Pro.Application.Contracts. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Mic rosoft Visual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\identity\src\Demo.IdentityService.HttpApi.Client\Demo.IdentityService.HttpApi.Client.csproj : error NU1101: Unable to find package Volo.Abp.Account.Pro.Admin.Application.Contracts. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Visual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] F:\Abp\Demo\services\identity\src\Demo.IdentityService.HttpApi.Client\Demo.IdentityService.HttpApi.Client.csproj : error NU1101: Unable to find package Volo.Abp.Identity.Pro.Domain.Shared. No packages exist with this id in source(s): ABP Commercial NuGet Source, C:\Program Files\dotnet\library-packs, Microsoft Vis ual Studio Offline Packages, nuget.org [F:\Abp\Demo\Demo.sln] . . .
Regards Murat Gürer
I have created a new demo app with following command; abp new CoMed -t microservice-pro -u blazor
I added a new openid application named demo with password 123456 and enabled all scopes. I altered demo application to accept passwrod, clientcredentials and refresh token flows.
I finally tried https://localhost:44322/connect/token end point with password flow. I used demo as client id and admin as username. I typed client password wrong to see the error message. I got "Invalid username or password!" error. I added "Accept-Language" header with value "tr". I tried again and error message is not localized.
Token endpoint ignores the accept-language header.
I tested same flow with version 5.X, header worked as expected.
Any suggestions?
1 - Create new project: abp new Demo -t microservice-pro -u blazor 2 - go to (solution_root)/etc/docker 3 - run .\up1.sh 4 - go to (solution_root)/shared/Demo.DbMigrator 5- run: dotnet run --environment "Development" 6- open sql management studio, configure connection; Server=localhost,1434, User Id=sa, password=myPassw0rd 7- open Demo_Identity/OpenIddictApplications table 8- check for the value in Persmissions column of clientId=Demo_Blazor row. Here is the initial value; ["ept:logout","gt:authorization_code","rst:code","ept:authorization","ept:token","ept:revocation","ept:introspection","scp:address","scp:email","scp:phone","scp:profile","scp:roles","scp:AccountService","scp:IdentityService","scp:AdministrationService","scp:SaasService","scp:ProductService"] 9- go to solution root folder 10- run solution: .\run-tye.ps1 (note: first run sometimes fails, so I kill the process and run it again when working on a brand-new project) 11- open blazor site: https://localhost:44307/ 12- login: admin 1q2w3E* 13- go to /administration/openid/applications tab 14- edit Demo_Blazor application 15- click save button without changing any data. 16- follow the steps 6,7,8 and check for the persmissions data on the table. 17- built-in scopes are gone; ["ept:logout","gt:authorization_code","rst:code","ept:authorization","ept:token","ept:revocation","ept:introspection","scp:ProductService","scp:SaasService","scp:AdministrationService","scp:IdentityService","scp:AccountService"] 18- scp:address","scp:email","scp:phone","scp:profile","scp:roles are missing after update. 19- if you logout from blazor app, you cant login back because of the missing data. here is the error message you get when you try to login back; error:invalid_request error_description:This client application is not allowed to use the specified scope. error_uri:https://documentation.openiddict.com/errors/ID2051
Can you help me for this issue?
Thanks.