C
C#2mo ago
IcEiE

Entity Framework Core Migration to Supabase Hangs Indefinitely

I'm trying to apply an Entity Framework Core migration to a Supabase PostgreSQL database, but the process hangs indefinitely. Here are the key details: - Using .NET 8 and EF Core 8.0.8 - Initial database connection succeeds (confirmed by console output) - dotnet ef database update command never completes - No error messages or exceptions are thrown - Command timeout is set to 500 seconds in both connection string and DbContext configuration - No logs found in supabase to indicate the migration has reached the db I've verified the connection works, as the application prints "Successfully connected to the database" on startup. However, when trying to apply the migration, it simply hangs without any progress or error messages. Has anyone encountered this issue with Supabase? Any suggestions for troubleshooting or resolving this problem would be greatly appreciated.
No description
4 Replies
IcEiE
IcEiE2mo ago
As you see it's a really simple application because couldn't get it to work on a bigger one so wanted to test it out with minimal overhead.
FusedQyou
FusedQyou2mo ago
update updates the database so it has nothing to do with this code Might be that the connection to your database was not established because of a wrong connection string
Unknown User
Unknown User2mo ago
Message Not Public
Sign In & Join Server To View
IcEiE
IcEiE2mo ago
I tested the connection string with this code when starting the project: using (var scope = app.Services.CreateScope()) { var services = scope.ServiceProvider; try { var context = services.GetRequiredService<ApplicationDbContext>(); using (var connection = (NpgsqlConnection)context.Database.GetDbConnection()) { connection.Open(); Console.WriteLine("Successfully connected to the database."); } } catch (Exception ex) { Console.WriteLine($"An error occurred while connecting to the database: {ex.Message}"); } } Yea will do, just wanted to check if I missed something Just to add, when I run a local postgres database the migration works as intended.
Want results from more Discord servers?
Add your server