Mobile versionIch habe die Datenbank auch mit Render (Postgres) in der kostenlosen Version bereitgestellt und die API in C# bereitgestellt.
API GitHub: https://github.com/LucasAPessoa/DevBrecho
Ich habe versucht, die Datenbank erneut zu generieren und den Block unten in Program.cs hinzuzufügen, aber es hat immer noch nicht funktioniert:
Code: Select all
using (var scope = app.Services.CreateScope())
{
var dbContext = scope.ServiceProvider.GetRequiredService();
dbContext.Database.Migrate();
}
Code: Select all
2025-10-14T22:30:12.089010337Z at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
2025-10-14T22:30:12.089016777Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
2025-10-14T22:30:12.089020998Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2025-10-14T22:30:12.089023438Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
2025-10-14T22:30:12.089025658Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
2025-10-14T22:30:12.089028488Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
2025-10-14T22:30:12.089030978Z --- End of stack trace from previous location ---
2025-10-14T22:30:12.089033228Z at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2025-10-14T22:30:12.089047318Z at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
2025-10-14T22:30:12.089049958Z at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
2025-10-14T22:30:12.089052318Z at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
2025-10-14T22:30:12.089054538Z at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
2025-10-14T22:30:12.089056689Z at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)
2025-10-14T22:35:04.74167339Z ==> Detected service running on port 8080
2025-10-14T22:35:05.02634937Z ==> Docs on specifying a port: https://render.com/docs/web-services#port-binding
2025-10-14T22:45:15.937154421Z info: Microsoft.Hosting.Lifetime[0]
2025-10-14T22:45:15.937175902Z Application is shutting down...
2025-10-15T01:09:09.171057962Z ==> Deploying...
2025-10-15T01:09:17.161668653Z info: Microsoft.Hosting.Lifetime[0]
2025-10-15T01:09:17.161671273Z Hosting environment: Production
2025-10-15T01:09:17.161673194Z info: Microsoft.Hosting.Lifetime[0]
2025-10-15T01:09:17.161675584Z Content root path: /app
2025-10-15T01:09:19.760952775Z warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3]
2025-10-15T01:09:19.760977157Z Failed to determine the https port for redirect.
2025-10-15T01:09:21.427105884Z ==> Your service is live 🎉
2025-10-15T01:09:21.50083954Z ==>
2025-10-15T01:09:22.548193828Z ==> ///////////////////////////////////////////////////////////
2025-10-15T01:09:23.662334813Z ==>
2025-10-15T01:09:23.745357108Z ==> Available at your primary URL https://devbrecho.onrender.com
2025-10-15T01:09:23.827619213Z ==>
2025-10-15T01:09:24.974357276Z ==> ///////////////////////////////////////////////////////////
2025-10-15T01:10:16.864438819Z fail: Microsoft.EntityFrameworkCore.Query[10100]
2025-10-15T01:10:16.864467121Z An exception occurred while iterating over the results of a query for context type 'DevBrecho.Data.AppDbContext'.
2025-10-15T01:10:16.864476442Z System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
2025-10-15T01:10:16.864481842Z at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
2025-10-15T01:10:16.864486312Z at System.Data.Common.DbConnectionOptions.ParseInternal(Dictionary`2 parsetable, String connectionString, Boolean buildChain, Dictionary`2 synonyms, Boolean firstKey)
2025-10-15T01:10:16.864489042Z at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Dictionary`2 synonyms, Boolean useOdbcRules)
2025-10-15T01:10:16.864492292Z at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
2025-10-15T01:10:16.864495383Z at Npgsql.NpgsqlConnectionStringBuilder..ctor(String connectionString)
2025-10-15T01:10:16.864498793Z at Npgsql.NpgsqlConnection.SetupDataSource()
2025-10-15T01:10:16.864501453Z at Npgsql.NpgsqlConnection.set_ConnectionString(String value)
2025-10-15T01:10:16.864504073Z at Npgsql.NpgsqlConnection..ctor(String connectionString)
2025-10-15T01:10:16.864506653Z at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlRelationalConnection.CreateDbConnection()
2025-10-15T01:10:16.864509204Z at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
2025-10-15T01:10:16.864512324Z at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
2025-10-15T01:10:16.864514944Z at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
2025-10-15T01:10:16.864553086Z at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
2025-10-15T01:10:16.864561047Z at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
2025-10-15T01:10:16.864564887Z at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
2025-10-15T01:10:16.864568797Z System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
2025-10-15T01:10:16.864573007Z at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
2025-10-15T01:10:16.864587668Z at System.Data.Common.DbConnectionOptions.ParseInternal(Dictionary`2 parsetable, String connectionString, Boolean buildChain, Dictionary`2 synonyms, Boolean firstKey)
2025-10-15T01:10:16.864589378Z at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Dictionary`2 synonyms, Boolean useOdbcRules)
2025-10-15T01:10:16.864591069Z at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
2025-10-15T01:10:16.864592638Z at Npgsql.NpgsqlConnectionStringBuilder..ctor(String connectionString)
2025-10-15T01:10:16.864594189Z at Npgsql.NpgsqlConnection.SetupDataSource()
2025-10-15T01:10:16.864595769Z at Npgsql.NpgsqlConnection.set_ConnectionString(String value)
2025-10-15T01:10:16.864597279Z at Npgsql.NpgsqlConnection..ctor(String connectionString)
2025-10-15T01:10:16.864598919Z at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlRelationalConnection.CreateDbConnection()
2025-10-15T01:10:16.864600399Z at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
2025-10-15T01:10:16.864602019Z at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
2025-10-15T01:10:16.864603619Z at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
2025-10-15T01:10:16.864605269Z at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
2025-10-15T01:10:16.864606779Z at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
2025-10-15T01:10:16.86462125Z at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
2025-10-15T01:10:16.959699068Z fail: Microsoft.AspNetCore.Server.Kestrel[13]
2025-10-15T01:10:16.959720529Z Connection id "0HNGBGTRVAR7Q", Request id "0HNGBGTRVAR7Q:00000002": An unhandled exception was thrown by the application.
2025-10-15T01:10:16.959723459Z System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
2025-10-15T01:10:16.959726089Z at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
2025-10-15T01:10:16.95972865Z at System.Data.Common.DbConnectionOptions.ParseInternal(Dictionary`2 parsetable, String connectionString, Boolean buildChain, Dictionary`2 synonyms, Boolean firstKey)
2025-10-15T01:10:16.9597309Z at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Dictionary`2 synonyms, Boolean useOdbcRules)
2025-10-15T01:10:16.95973356Z at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
2025-10-15T01:10:16.95973613Z at Npgsql.NpgsqlConnectionStringBuilder..ctor(String connectionString)
2025-10-15T01:10:16.95973897Z at Npgsql.NpgsqlConnection.SetupDataSource()
2025-10-15T01:10:16.959741201Z at Npgsql.NpgsqlConnection.set_ConnectionString(String value)
2025-10-15T01:10:16.95974327Z at Npgsql.NpgsqlConnection..ctor(String connectionString)
2025-10-15T01:10:16.959745251Z at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlRelationalConnection.CreateDbConnection()
2025-10-15T01:10:16.959747201Z at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
2025-10-15T01:10:16.959759922Z at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
2025-10-15T01:10:16.959762362Z at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
2025-10-15T01:10:16.959764762Z at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
2025-10-15T01:10:16.959767392Z at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
2025-10-15T01:10:16.959769312Z at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
2025-10-15T01:10:16.959771712Z at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
2025-10-15T01:10:16.959773532Z at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
2025-10-15T01:10:16.959775352Z at DevBrecho.Controllers.SetorController.GetSetores() in /source/DevBrecho/Controllers/SetorController.cs:line 23
2025-10-15T01:10:16.959777273Z at lambda_method4(Closure, Object)
2025-10-15T01:10:16.959779583Z at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
2025-10-15T01:10:16.959785073Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
2025-10-15T01:10:16.959787573Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2025-10-15T01:10:16.959789383Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
2025-10-15T01:10:16.959791193Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
2025-10-15T01:10:16.959793733Z at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
2025-10-15T01:10:16.959795584Z --- End of stack trace from previous location ---
2025-10-15T01:10:16.959797454Z at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
2025-10-15T01:10:16.959813275Z at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
2025-10-15T01:10:16.959815775Z at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
2025-10-15T01:10:16.959817655Z at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
2025-10-15T01:10:16.959819435Z at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
2025-10-15T01:10:16.959821415Z at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)
2025-10-15T01:18:37.923913346Z ==> Detected service running on port 8080
2025-10-15T01:18:38.226328702Z ==> Docs on specifying a port: https://render.com/docs/web-services#port-binding
