[v8.0.10] 42P07: relation "__EFMigrationsHistory" already exists

[ilmnsrett]

As part of an upgrade from .net 6 to .net 8, we are seeing the following error when applying migrations:

42P07: relation "__EFMigrationsHistory" already exists

We're using version 8.0.10.

Issue #2878 (comment) says that this is fixed is 9.0.0-rc.2.

Couple of questions:

• I see that .net 9 will be released next week. Can we expect 9.0.0 of your library to be released at the same time?
• Is .net 9 runtime required for this version and fix? Our preference is to run on .net 8 due to LTS.

[vikasillumina]

@roji please can you guide us with above questions? Thanks for your help in advance.

[roji]

I see that .net 9 will be released next week. Can we expect 9.0.0 of your library to be released at the same time?

Yes, at most a few days later.

Is .net 9 runtime required for this version and fix? Our preference is to run on .net 8 due to LTS.

You'd need to run EF Core 9.0, which is not LTS - does it make sense for you to run a non-LTS EF while insisting on an LTS .NET? I'm asking out of curiosity, because it so happens that EF Core 9.0 does support .NET 8.0 (you can see that for yourself by checking the supported TFMs on the nuget package).