Base solution for your next web application
Open Closed

AbpConfiguration/GetAll Issue with MySQL server. #4767

User avatar
0
gunpal5 created

Hello,

I am facing a strange issue.I am using Pomelo.EntityFrameworkCore.MySql connector for my app. Its a single tenant app.

Scenario 1 (Host without debugging): When I run the application host without debugging, the login page loads fine but when i enter the admin username and password. it sticks to loading page and pops up an error message after few minutes (see screenshots).

On network tab on chrome's dev tools, It looks like it is waiting for <a class="postlink" href="http://localhost:22742/AbpUserConfiguration/GetAll">http://localhost:22742/AbpUserConfiguration/GetAll</a>. which never returns any value and after few minutes the request is getting timeout.

but if I try to load directly on browser <a class="postlink" href="http://localhost:22742/AbpUserConfiguration/GetAll">http://localhost:22742/AbpUserConfiguration/GetAll</a>, it loads fine without any issue.

Scenario 2 (Host with debugger attached): When I run the host in debugging mode. The app is running without any issue.

After I run the application in debugging mode and load the frontend on browser it loads fine. after loading the frontend for few times. if I stop the debugging session on host and run the host again without debugging. then again it loads fine. I believe it's due to caching of some configuration.

Is there any explanation for this? any suggestion to fix the issue?

Regards, Gunpal Jain

Screenshots:

Go to accepted answer
16 Answer(s)
  • User Avatar
    0
    alper created
    Support Team

    What's log.txt saying?

  • User Avatar
    0
    gunpal5 created

    Here it is, seems to be frozen at AbpConfiguration/GetAll.

    DEBUG 2018-03-02 22:05:25,628 [1    ] Abp.Modules.AbpModuleManager             - Loading Abp modules...
DEBUG 2018-03-02 22:05:25,656 [1    ] Abp.Modules.AbpModuleManager             - Found 23 ABP modules in total.
DEBUG 2018-03-02 22:05:25,677 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: GunMantra.CryptoExchange.Web.Startup.CryptoExchangeWebHostModule, GunMantra.CryptoExchange.Web.Host, Version=5.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,679 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: GunMantra.CryptoExchange.Web.CryptoExchangeWebCoreModule, GunMantra.CryptoExchange.Web.Core, Version=5.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,680 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: GunMantra.CryptoExchange.CryptoExchangeApplicationModule, GunMantra.CryptoExchange.Application, Version=5.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,680 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: GunMantra.CryptoExchange.CryptoExchangeCoreModule, GunMantra.CryptoExchange.Core, Version=5.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,680 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Zero.AbpZeroCoreModule, Abp.ZeroCore, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,680 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Zero.AbpZeroCommonModule, Abp.Zero.Common, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,681 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AbpKernelModule, Abp, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,681 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Zero.Ldap.AbpZeroLdapModule, Abp.Zero.Ldap, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,681 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AutoMapper.AbpAutoMapperModule, Abp.AutoMapper, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,682 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AspNetZeroCore.AbpAspNetZeroCoreModule, Abp.AspNetZeroCore, Version=1.1.1.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,682 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.MailKit.AbpMailKitModule, Abp.MailKit, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,682 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: GunMantra.CryptoExchange.CryptoExchangeCoreFundsModule, GunMantra.CryptoExchange.Core.Funds, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,682 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: GunMantra.CryptoExchange.EntityFrameworkCore.CryptoExchangeEntityFrameworkCoreModule, GunMantra.CryptoExchange.EntityFrameworkCore, Version=5.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,683 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Zero.EntityFrameworkCore.AbpZeroCoreEntityFrameworkCoreModule, Abp.ZeroCore.EntityFrameworkCore, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,683 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.EntityFrameworkCore.AbpEntityFrameworkCoreModule, Abp.EntityFrameworkCore, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,683 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.EntityFramework.AbpEntityFrameworkCommonModule, Abp.EntityFramework.Common, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,683 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.IdentityServer4.AbpZeroCoreIdentityServerEntityFrameworkCoreModule, Abp.ZeroCore.IdentityServer4.EntityFrameworkCore, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,683 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.IdentityServer4.AbpZeroCoreIdentityServerModule, Abp.ZeroCore.IdentityServer4, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,684 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AspNetZeroCore.Web.AbpAspNetZeroCoreWebModule, Abp.AspNetZeroCore.Web, Version=1.1.1.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,684 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AspNetCore.AbpAspNetCoreModule, Abp.AspNetCore, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,684 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Web.AbpWebCommonModule, Abp.Web.Common, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,684 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Web.SignalR.AbpWebSignalRModule, Abp.Web.SignalR, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,684 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Hangfire.AbpHangfireAspNetCoreModule, Abp.HangFire.AspNetCore, Version=3.4.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:25,689 [1    ] Abp.Modules.AbpModuleManager             - 23 modules loaded.
DEBUG 2018-03-02 22:05:25,788 [1    ] o.Configuration.LanguageManagementConfig - Converted Abp (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2018-03-02 22:05:25,788 [1    ] o.Configuration.LanguageManagementConfig - Converted AbpZero (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2018-03-02 22:05:25,788 [1    ] o.Configuration.LanguageManagementConfig - Converted CryptoExchange (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2018-03-02 22:05:25,788 [1    ] o.Configuration.LanguageManagementConfig - Converted AbpWeb (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2018-03-02 22:05:26,393 [1    ] ameworkCore.AbpEntityFrameworkCoreModule - Registering DbContext: GunMantra.CryptoExchange.EntityFrameworkCore.CryptoExchangeDbContext, GunMantra.CryptoExchange.EntityFrameworkCore, Version=5.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2018-03-02 22:05:27,031 [1    ] Abp.Localization.LocalizationManager     - Initializing 4 localization sources.
DEBUG 2018-03-02 22:05:27,038 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: Abp
DEBUG 2018-03-02 22:05:27,046 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: AbpZero
DEBUG 2018-03-02 22:05:27,064 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: CryptoExchange
DEBUG 2018-03-02 22:05:27,066 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: AbpWeb
DEBUG 2018-03-02 22:05:27,118 [1    ] Abp.BackgroundJobs.BackgroundJobManager  - Start background worker: Abp.BackgroundJobs.BackgroundJobManager
DEBUG 2018-03-02 22:05:27,180 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - Found 2 classes define auto mapping attributes
DEBUG 2018-03-02 22:05:27,180 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - GunMantra.CryptoExchange.Web.Models.TokenAuth.ExternalLoginProviderInfoModel
DEBUG 2018-03-02 22:05:27,184 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - GunMantra.CryptoExchange.Friendships.Cache.FriendCacheItem
INFO  2018-03-02 22:05:31,673 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/  
INFO  2018-03-02 22:05:32,160 [4    ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method GunMantra.CryptoExchange.Web.Controllers.HomeController.Index (GunMantra.CryptoExchange.Web.Host) with arguments ((null)) - ModelState is Valid
INFO  2018-03-02 22:05:32,171 [4    ] Core.Mvc.Internal.RedirectResultExecutor - Executing RedirectResult, redirecting to /swagger.
INFO  2018-03-02 22:05:32,180 [4    ] ore.Mvc.Internal.ControllerActionInvoker - Executed action GunMantra.CryptoExchange.Web.Controllers.HomeController.Index (GunMantra.CryptoExchange.Web.Host) in 75.9555ms
INFO  2018-03-02 22:05:32,214 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 548.0359ms 302 
INFO  2018-03-02 22:05:32,221 [9    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/  
INFO  2018-03-02 22:05:32,258 [9    ] NetCore.StaticFiles.StaticFileMiddleware - Sending file. Request path: '/index.html'. Physical path: 'N/A'
INFO  2018-03-02 22:05:32,277 [9    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 56.0174ms 200 text/html
INFO  2018-03-02 22:05:32,291 [13   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/css/reset.css  
INFO  2018-03-02 22:05:32,293 [8    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/css/typography.css  
INFO  2018-03-02 22:05:32,293 [8    ] NetCore.StaticFiles.StaticFileMiddleware - The file /css/typography.css was not modified
INFO  2018-03-02 22:05:32,293 [13   ] NetCore.StaticFiles.StaticFileMiddleware - The file /css/reset.css was not modified
INFO  2018-03-02 22:05:32,294 [8    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 1.7084ms 304 text/css
INFO  2018-03-02 22:05:32,295 [13   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 3.0523ms 304 text/css
INFO  2018-03-02 22:05:32,295 [11   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/css/screen.css  
INFO  2018-03-02 22:05:32,295 [8    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/object-assign-pollyfill.js  
INFO  2018-03-02 22:05:32,296 [8    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/object-assign-pollyfill.js was not modified
INFO  2018-03-02 22:05:32,296 [8    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.6447ms 304 application/javascript
INFO  2018-03-02 22:05:32,297 [11   ] NetCore.StaticFiles.StaticFileMiddleware - The file /css/screen.css was not modified
INFO  2018-03-02 22:05:32,297 [11   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 2.2ms 304 text/css
INFO  2018-03-02 22:05:32,300 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/jquery-1.8.0.min.js  
INFO  2018-03-02 22:05:32,300 [4    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/jquery-1.8.0.min.js was not modified
INFO  2018-03-02 22:05:32,300 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.6939ms 304 application/javascript
INFO  2018-03-02 22:05:32,301 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/jquery.slideto.min.js  
INFO  2018-03-02 22:05:32,304 [12   ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/jquery.slideto.min.js was not modified
INFO  2018-03-02 22:05:32,304 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 2.7022ms 304 application/javascript
INFO  2018-03-02 22:05:32,315 [10   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/jquery.ba-bbq.min.js  
INFO  2018-03-02 22:05:32,315 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/jquery.wiggle.min.js  
INFO  2018-03-02 22:05:32,315 [3    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/jquery.wiggle.min.js was not modified
INFO  2018-03-02 22:05:32,315 [10   ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/jquery.ba-bbq.min.js was not modified
INFO  2018-03-02 22:05:32,315 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.6341ms 304 application/javascript
INFO  2018-03-02 22:05:32,318 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/lodash.min.js  
INFO  2018-03-02 22:05:32,319 [3    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/lodash.min.js was not modified
INFO  2018-03-02 22:05:32,319 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.7362ms 304 application/javascript
INFO  2018-03-02 22:05:32,321 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/highlight.9.1.0.pack_extended.js  
INFO  2018-03-02 22:05:32,315 [13   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/handlebars-4.0.5.js  
INFO  2018-03-02 22:05:32,315 [10   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.7494ms 304 application/javascript
INFO  2018-03-02 22:05:32,323 [10   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/swagger-ui.min.js  
INFO  2018-03-02 22:05:32,323 [13   ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/handlebars-4.0.5.js was not modified
INFO  2018-03-02 22:05:32,323 [10   ] NetCore.StaticFiles.StaticFileMiddleware - The file /swagger-ui.min.js was not modified
INFO  2018-03-02 22:05:32,323 [13   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 7.9783ms 304 application/javascript
INFO  2018-03-02 22:05:32,323 [10   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.485ms 304 application/javascript
INFO  2018-03-02 22:05:32,323 [4    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/highlight.9.1.0.pack_extended.js was not modified
INFO  2018-03-02 22:05:32,323 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 2.4633ms 304 application/javascript
INFO  2018-03-02 22:05:32,324 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/highlight.9.1.0.pack.js  
INFO  2018-03-02 22:05:32,324 [4    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/highlight.9.1.0.pack.js was not modified
INFO  2018-03-02 22:05:32,324 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.6443ms 304 application/javascript
INFO  2018-03-02 22:05:32,316 [8    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/backbone-min.js  
INFO  2018-03-02 22:05:32,326 [8    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/backbone-min.js was not modified
INFO  2018-03-02 22:05:32,326 [8    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 10.1411ms 304 application/javascript
INFO  2018-03-02 22:05:32,327 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/swagger-oauth.js  
INFO  2018-03-02 22:05:32,328 [9    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/jsoneditor.min.js  
INFO  2018-03-02 22:05:32,328 [12   ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/swagger-oauth.js was not modified
INFO  2018-03-02 22:05:32,328 [9    ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/jsoneditor.min.js was not modified
INFO  2018-03-02 22:05:32,328 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 1.0163ms 304 application/javascript
INFO  2018-03-02 22:05:32,328 [9    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.4996ms 304 application/javascript
INFO  2018-03-02 22:05:32,328 [11   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/lib/marked.js  
INFO  2018-03-02 22:05:32,329 [11   ] NetCore.StaticFiles.StaticFileMiddleware - The file /lib/marked.js was not modified
INFO  2018-03-02 22:05:32,330 [11   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 1.4258ms 304 application/javascript
INFO  2018-03-02 22:05:32,336 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/images/logo_small.png  
INFO  2018-03-02 22:05:32,337 [3    ] NetCore.StaticFiles.StaticFileMiddleware - The file /images/logo_small.png was not modified
INFO  2018-03-02 22:05:32,337 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.6954ms 304 image/png
INFO  2018-03-02 22:05:32,341 [13   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/css/print.css  
INFO  2018-03-02 22:05:32,342 [13   ] NetCore.StaticFiles.StaticFileMiddleware - The file /css/print.css was not modified
INFO  2018-03-02 22:05:32,342 [13   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.6348ms 304 text/css
INFO  2018-03-02 22:05:32,474 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/swagger/v1/swagger.json  
INFO  2018-03-02 22:05:32,940 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 465.5936ms 200 application/json
INFO  2018-03-02 22:08:32,338 [11   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 OPTIONS http://localhost:22742/AbpUserConfiguration/GetAll  
INFO  2018-03-02 22:08:32,348 [11   ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:32,352 [11   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 13.9804ms 204 
INFO  2018-03-02 22:08:32,381 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/AbpUserConfiguration/GetAll application/json 
INFO  2018-03-02 22:08:32,381 [4    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:32,399 [4    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:32,402 [4    ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Abp.AspNetCore.Mvc.Controllers.AbpUserConfigurationController.GetAll (Abp.AspNetCore) with arguments ((null)) - ModelState is Valid
INFO  2018-03-02 22:08:32,788 [6    ] matters.Json.Internal.JsonResultExecutor - Executing JsonResult, writing value Abp.Web.Models.AjaxResponse.
INFO  2018-03-02 22:08:32,837 [6    ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Abp.AspNetCore.Mvc.Controllers.AbpUserConfigurationController.GetAll (Abp.AspNetCore) in 438.1013ms
INFO  2018-03-02 22:08:32,838 [6    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 457.4308ms 200 application/json; charset=utf-8
INFO  2018-03-02 22:08:32,851 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 OPTIONS http://localhost:22742/api/services/app/Session/GetCurrentLoginInformations  
INFO  2018-03-02 22:08:32,851 [3    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:32,851 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.1469ms 204 
INFO  2018-03-02 22:08:32,855 [10   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/api/services/app/Session/GetCurrentLoginInformations application/json 
INFO  2018-03-02 22:08:32,855 [10   ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:32,864 [10   ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:33,594 [10   ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method GunMantra.CryptoExchange.Sessions.SessionAppService.GetCurrentLoginInformations (GunMantra.CryptoExchange.Application) with arguments ((null)) - ModelState is Valid
INFO  2018-03-02 22:08:33,719 [14   ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
INFO  2018-03-02 22:08:33,731 [14   ] ore.Mvc.Internal.ControllerActionInvoker - Executed action GunMantra.CryptoExchange.Sessions.SessionAppService.GetCurrentLoginInformations (GunMantra.CryptoExchange.Application) in 866.5311ms
INFO  2018-03-02 22:08:33,731 [14   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 875.3876ms 200 application/json; charset=utf-8
INFO  2018-03-02 22:08:34,948 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 OPTIONS http://localhost:22742/api/TokenAuth/GetExternalAuthenticationProviders  
INFO  2018-03-02 22:08:34,948 [3    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:34,948 [3    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.1644ms 204 
INFO  2018-03-02 22:08:35,003 [9    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/api/TokenAuth/GetExternalAuthenticationProviders application/json 
INFO  2018-03-02 22:08:35,003 [9    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:35,007 [9    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:35,236 [9    ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method GunMantra.CryptoExchange.Web.Controllers.TokenAuthController.GetExternalAuthenticationProviders (GunMantra.CryptoExchange.Web.Core) with arguments ((null)) - ModelState is Valid
INFO  2018-03-02 22:08:35,253 [6    ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
INFO  2018-03-02 22:08:35,253 [6    ] ore.Mvc.Internal.ControllerActionInvoker - Executed action GunMantra.CryptoExchange.Web.Controllers.TokenAuthController.GetExternalAuthenticationProviders (GunMantra.CryptoExchange.Web.Core) in 246.7012ms
INFO  2018-03-02 22:08:35,253 [6    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 250.8264ms 200 application/json; charset=utf-8
INFO  2018-03-02 22:08:40,159 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 OPTIONS http://localhost:22742/api/TokenAuth/Authenticate  
INFO  2018-03-02 22:08:40,159 [12   ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:40,159 [12   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.1502ms 204 
INFO  2018-03-02 22:08:40,163 [8    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 POST http://localhost:22742/api/TokenAuth/Authenticate application/json 151
INFO  2018-03-02 22:08:40,163 [8    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:40,182 [8    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:40,301 [8    ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method GunMantra.CryptoExchange.Web.Controllers.TokenAuthController.Authenticate (GunMantra.CryptoExchange.Web.Core) with arguments (GunMantra.CryptoExchange.Web.Models.TokenAuth.AuthenticateModel) - ModelState is Valid
INFO  2018-03-02 22:08:40,650 [23   ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
INFO  2018-03-02 22:08:40,652 [23   ] ore.Mvc.Internal.ControllerActionInvoker - Executed action GunMantra.CryptoExchange.Web.Controllers.TokenAuthController.Authenticate (GunMantra.CryptoExchange.Web.Core) in 470.5572ms
INFO  2018-03-02 22:08:40,656 [23   ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 493.9043ms 200 application/json; charset=utf-8
INFO  2018-03-02 22:08:43,248 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 OPTIONS http://localhost:22742/AbpUserConfiguration/GetAll  
INFO  2018-03-02 22:08:43,248 [4    ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:43,248 [4    ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 0.1958ms 204 
INFO  2018-03-02 22:08:43,267 [11   ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET http://localhost:22742/AbpUserConfiguration/GetAll application/json 
INFO  2018-03-02 22:08:43,268 [11   ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:43,299 [11   ] uthentication.JwtBearer.JwtBearerHandler - Successfully validated the token.
INFO  2018-03-02 22:08:43,303 [11   ] uthentication.JwtBearer.JwtBearerHandler - AuthenticationScheme: Bearer was successfully authenticated.
INFO  2018-03-02 22:08:43,339 [23   ] pNetCore.Cors.Infrastructure.CorsService - Policy execution successful.
INFO  2018-03-02 22:08:43,340 [23   ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Abp.AspNetCore.Mvc.Controllers.AbpUserConfigurationController.GetAll (Abp.AspNetCore) with arguments ((null)) - ModelState is Valid
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @gunpal5,

    This seems to be a database connection problem to me. When you run your app in release mode, a different appsettings.json is used. Can you check the connection strings in appsettings.Staging.json ?

  • User Avatar
    0
    gunpal5 created

    Hi,

    I am not running the application in Release mode. it's in debug mode, when I run application without debugger attached application freezes after logging in, but works when debugger is attached.

    Regards, Gunpal Jain

  • User Avatar
    0
    alper created
    Support Team

    there might be left some outdated DLLs in the output folders. you can delete all BIN & OBJ folders in the solution. This is a time consuming thing. I created a batch file that removes all BIN & OBJ folders automatically. [attachment=0:pywrd7p1]Delete BIN OBJ Folders.zip[/attachment:pywrd7p1] Delete BIN OBJ Folders.zip

  • User Avatar
    0
    gunpal5 created

    Hello,

    I will try with that, thank you very much.

    Regards, Gunpal Jain

  • User Avatar
    0
    cangunaydin created

    Hello, Is this problem solved. I am having the same issue sometimes. The strange thing about my problem is i have multitenancy enabled, if i log in as host then it loads the page but when i try to log in as Default tenant then can not get the AbpConfiguration/GetAll and it stucks over there for a long time.

  • User Avatar
    0
    ismcagdas created
    Support Team

    @cangunaydin,

    Did you have a chance to try with SQL Server ? I'm not sure if it is related to MySql or any client side library.

  • User Avatar
    0
    cangunaydin created

    Hello @ismcagdas, I am still looking for this issue, i will write the details when i found out but i don't think it is doing it in sql server it is difficult to understand cause i think when i rebuild it or waits too long also mysql provider works. But my betfor the issue definitely related with tenantid settings, or when it tries to get some settings about the tenant from db. I will post more when i found out more.

  • User Avatar
    0
    cangunaydin created

    Hello @ismcagdas, Here is my findings. In this test i have connected my application to SqlServer Express Local, Mysql Server Local and Mysql Server Remote I created the databases from the scratch for every test. I tried to log in with host admin account all the time when i come to login page. And i always use the incognito mode of chrome to not use cache,session or cookie that is stored.

    First of all there is no problem with sql server express, all the things are lightning fast over there so it gets the AbpUserConfiguration/GetAll response very quickly. This is the method that is always pending with mysql server. So i think the focus needs to be in this method.

    When i tried with mysql server local, it has some strange behavior, i don't think it is directly related with mysql cause it query the database for ex if i give wrong credentials it gives me the error which means it can connect to db. When i pass the login phase, most of the time it is stucking in AbpUserConfiguration/GetAll method but also i can say that mysql connection with db is slow if i compare it with sql server express. So what i have done after is i have restarted mysql server. Then when i tried it was the same then i cleaned my project before the new build and run it again then bingo it logged in and get the response.

    Then at the last stage i have tried to do the same with remote but no luck i have tried it multiple times but i couldn't get a response from AbpUserConfiguration/GetAll method it is always pending not even one time i can succeed. So what i think is if it takes longer time to connect to db and query then the problem is occuring, that's what i have observed so far. I hope you can find the cause of this. I can zip my project and send it if you need it also.

    Thank you for the assistance

  • User Avatar
    0
    alper created
    Support Team

    weird issue. waiting your feedback

  • User Avatar
    0
    cangunaydin created

    Hi, I wonder can't you recreate the issue on your side? Or no such behavior that i am getting if you do it? Cause it is little bit difficult for me to understand what is happening inside the AbpUserConfiguration/GetAll method.

  • User Avatar
    0
    alper created
    Support Team

    we couldn't reproduce the problem.

    Here's the content of GetAll()

    public async Task<JsonResult> GetAll()
{
            var userConfig = await _abpUserConfigurationBuilder.GetAll();
            return Json(userConfig, JsonRequestBehavior.AllowGet);
}

    <a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate/blob/ae947393fd8d7af71ccc3486e31143f0ba112814/src/Abp.Web.Mvc/Web/Mvc/Controllers/AbpUserConfigurationController.cs#L16">https://github.com/aspnetboilerplate/as ... ler.cs#L16</a>

  • User Avatar
    0
    cangunaydin created

    Hello again, Here is how i solve it. I got a new template from download section and install it from the scratch for ui and server. Then i have implemented pomelo mysql provider. Then i have changed the related lines and with my first build it works ok then afterwards i have added mysql provider for hangfire Hangfire.Mysql.Storage and it is stucked in AbpConfiguration/GetAll. Then i thought that this package is causing the problem, But when i remove the package it is stucked again so i was banging my head to wall, then i fork the github abp project abp.aspnetcore then i decided to debug it on my own. i remove the nuget package and added abp.aspnetcore project to the references then i was expecting it to stuck somewhere on the code but nothing happened it started smoothly. When i go to the nuget package manager i realized that i was using version abp.aspnetcore 3.4.0 when i updated to v3.5.0 it started to work. So i couldn't find out what was causing the problem but what i know is it works with abp.aspnetcore 3.5.0

  • User Avatar
    0
    cangunaydin created

    Okay here is another thing. I thought that i fixed it but it is not totally fixed so i tried couple of times with the debug then i found where it stucks. If you look at this line in abp.aspnetcore project

    <a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate/blob/ae947393fd8d7af71ccc3486e31143f0ba112814/src/Abp.Web.Common/Web/Configuration/AbpUserConfigurationBuilder.cs#L187">https://github.com/aspnetboilerplate/as ... er.cs#L187</a>

    it is stucking in uow when it tries to open a unit of work in the above line. I think this happens when you add the nuget package Hangfire.MySqlStorage

    <a class="postlink" href="https://github.com/arnoldasgudas/Hangfire.MySqlStorage">https://github.com/arnoldasgudas/Hangfire.MySqlStorage</a>

    I can send the project that does not work. This package uses MySql.Data maybe that's why it makes a problem i am not sure. Could you also check it out? and see if you can reproduce the error at that line?

  • User Avatar
    0
    alper created
    Support Team

    send it to <a href="mailto:[email protected]">[email protected]</a> with your topic link.

Assignee
No one
Labels
Non yet