Need someone help debug local host issue. API call gets stuck in pending state forever

[lichuhub]

I followed this example https://learn.microsoft.com/en-us/azure/data-api-builder/quickstart-nosql

Everything seems to be working until i run a query. it seems to be stuck in pending state forever.
2

does anyone know the reason? Is it because of http instead of https? if i got to https://localhost:5000/graphql/. it will said "This site can’t provide a secure connection"

Dab doesn't seem like start the https for me.
Here are some logs

PS C:\Repros\basicReact\books> dab start
Information: Microsoft.DataApiBuilder 1.4.35
Information: Config not provided. Trying to get default config based on DAB_ENVIRONMENT...
Information: Environment variable DAB_ENVIRONMENT is (null)
Loading config file from C:\Repros\basicReact\books\dab-config.json.
Information: Loaded config file: dab-config.json
Information: Setting default minimum LogLevel: Debug for Development mode.
Starting the runtime engine...
Loading config file from C:\Repros\basicReact\books\dab-config.json.
Monitoring config: dab-config.json for hot-reloading.
info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[63]
User profile is available. Using 'C:\Users\xxx\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
info: Azure.DataApiBuilder.Service.Startup[0]
Successfully completed runtime initialization.
info: Microsoft.Hosting.Lifetime[14]
Now listening on: http://localhost:5000
info: Microsoft.Hosting.Lifetime[0]
Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
Hosting environment: Production
info: Microsoft.Hosting.Lifetime[0]
Content root path: C:\Repros\basicReact\books
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/.well-known/appspecific/com.chrome.devtools.json - - -
warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3]
Failed to determine the https port for redirect.
dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
951eebd9-b8e2-477f-91ec-7633d3c8f599 AuthN state: Anonymous. Role: Anonymous. Scheme: StaticWebAppsAuthentication
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102]
Route matched with {action = "Find", controller = "Rest"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Find(System.String) on controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service).
fail: Azure.DataApiBuilder.Service.Controllers.RestController[0]
951eebd9-b8e2-477f-91ec-7633d3c8f599 Error handling REST request.
Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: Invalid Path for route: .well-known/appspecific/com.chrome.devtools.json.
at Azure.DataApiBuilder.Core.Services.RestService.GetRouteAfterPathBase(String route) in //src/Core/Services/RestService.cs:line 396
at Azure.DataApiBuilder.Service.Controllers.RestController.HandleOperation(String route, EntityActionOperation operationType) in //src/Service/Controllers/RestController.cs:line 199
in

[lichuhub]

i clone the source code and run it locally. now it works. I guess something is wrong with dab 1.5.50.

PS C:\test\data-api-builder> dotnet run --project src/Service/Azure.DataApiBuilder.Service.csproj --ConfigFileName C:\Repros\basicReact\graphqlServer\dab-config.json
Building...
Starting the runtime engine...
Loading config file from C:\Repros\basicReact\graphqlServer\dab-config.json.
Monitoring config: C:\Repros\basicReact\graphqlServer\dab-config.json for hot-reloading.
info: Microsoft.Hosting.Lifetime[14]
Now listening on: https://localhost:5001
info: Microsoft.Hosting.Lifetime[14]
Now listening on: http://localhost:5000
info: Microsoft.Hosting.Lifetime[0]
Application started. Press Ctrl+C to shut down.

[aaronburtle]

i clone the source code and run it locally. now it works. I guess something is wrong with dab 1.5.50.

Which version were you having issues this? From the logs in your first post, it looks like 1.4.35 was causing trouble, can you post the logs from 1.5.50 not working correctly?

[lichuhub]

here is the log. It could be just my machine issue.

PS C:\Repros\basicReact\books> dab start
Information: Microsoft.DataApiBuilder 1.5.50
Information: Config not provided. Trying to get default config based on DAB_ENVIRONMENT...
Information: Environment variable DAB_ENVIRONMENT is (null)
Loading config file from C:\Repros\basicReact\books\dab-config.json.
Information: Loaded config file: dab-config.json
Information: Setting default minimum LogLevel: Debug for Development mode.
Starting the runtime engine...
Loading config file from C:\Repros\basicReact\books\dab-config.json.
Monitoring config: dab-config.json for hot-reloading.
info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[63]
User profile is available. Using 'C:\Users\xxxxx\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
info: Azure.DataApiBuilder.Service.Startup[0]
Successfully completed runtime initialization.
info: Microsoft.Hosting.Lifetime[14]
Now listening on: http://localhost:5000
info: Microsoft.Hosting.Lifetime[0]
Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
Hosting environment: Production
info: Microsoft.Hosting.Lifetime[0]
Content root path: C:\Repros\basicReact\books
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/ - - -
warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3]
Failed to determine the https port for redirect.
dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
3121ce25-799c-404c-822a-1a560211abed AuthN state: Anonymous. Role: Anonymous. Scheme: StaticWebAppsAuthentication

[RubenCerna2079]

Hello @lichuhub, we have a new version of dab, which is 1.5.56, let us know if you keep getting the error or if it was solved.

[lichuhub]

thanks. it's working for me last after using the latest version