Types not being reloaded properly after adding extension and running Migrate()

[kusey]

Hi, I have installed the newest Npgsql.EntityFrameworkCore.PostgreSQL package in my project, and I added the 'hstore' extension like this:
modelBuilder.HasPostgresExtension("hstore");
The migration file content generated like this:
migrationBuilder.AlterDatabase().Annotation("Npgsql:PostgresExtension:hstore", "'hstore', '', ''");

After this, I have my own database initialize process in main function:

var host = BuildWebHost(args);

            var serviceProvider = host.Services;
            // initialize database
            using (var scope = serviceProvider.CreateScope())
            {
                var dbContext = scope.ServiceProvider.GetRequiredService<ISDbContext>();
                if (dbContext.Database.GetPendingMigrations().Any())
                {
                    dbContext.Database.Migrate();
                }
                StorageInitializer.Initialize(dbContext, BuilderContext.HostingEnvironment);
            }

I invoke the Migrate() function in order to update my database automatically, after this, I checked that the extension 'hstore' already added to my database, but when I insert records to table(which contains a field with data type Dictionary<string, string>) I got this exception: "NpgsqlException: The PostgreSQL type 'hstore', mapped to NpgsqlDbType 'Hstore' isn't present in your database. You may need to install an extension or upgrade to a newer version."

I'm not sure how to resolve this issue, can anybody help me?
Thanks.

[kusey]

In addition, if I do not invoke dbContext.Database.Migrate() function explicitly, just use common line: "dotnet ef database update" to update my database, everything is ok when inserting records to database.

[roji]

This is probably because after adding the extension in the database, Npgsql (the ADO layer) needs to reload the types to discover the newly-added hstore... This was supposed to be taken care of, but there may be an issue - I'll try to take a look soon.

The workaround is indeed to run the migration from a different process - if you simply restart your application everything should work fine.

[kusey]

Thanks for your reply.
If it's a bug I will find some workarounds temporary.

[myshon]

I create database in integration test, I use context.Database.Migrate() but it fails with same error. When I added ReloadTypes after database migration and it started working

using (var ctx = server.Host.Services.GetService<MyContext>())
using (var conn = new NpgsqlConnection(ctx.Database.GetDbConnection().ConnectionString))
{
   conn.Open();
   conn.ReloadTypes();
   conn.Close();
} 

[roji]

Oops, I ran into this today and fixed it as #313, forgetting that this issue was open.

Can you please test version 2.0.2-166 from the stable feed and confirm that the problem goes away?

[myshon]

Pulled 2.0.2-166 and unfortunetelty still not works, but an error is different, without explicit ReloadTypes I have:

System.NotSupportedException: The field 'Code' has a type currently unknown to Npgsql (OID 22894). You can retrieve it as a string by marking it as unknown, please see the FAQ

[roji]

@myshon what's the type of Code? Any chance you could post a small code sample reproducing the issue? Things seem to work well on my end.

[myshon]

@roji I use citext extension:
modelBuilder.HasPostgresExtension("citext");
Code has type citext
builder.Property(x => x.Code).HasColumnType("citext");
Give me some time, I will try to reproduce it later.

[roji]

Great, thanks - a simple small context with some minimal code would be ideal.

[kusey]

@roji I still got the same error using pkg 2.0.2-ci-00166.

[roji]

@kusey as I wrote above, a small code sample would be very helpful here. In my scenario it's OK, and I don't know what you're doing differently.

[kusey]

@roji Here is my code, executing pending migrations when website startup:

var host = BuildWebHost(args);
var serviceProvider = host.Services;
// initialize database
using (var scope = serviceProvider.CreateScope())
{
    var dbContext = scope.ServiceProvider.GetRequiredService<ISDbContext>();
    if (dbContext.Database.GetPendingMigrations().Any())
    {
        dbContext.Database.Migrate();
    }
    StorageInitializer.Initialize(dbContext);
}

and the database initialize code like this:

if (!dbContext.Set<TStorageModel>().Any())
{
    dbContext.AddRange(entities);
    dbContext.SaveChanges();
}

Sorry for the late reply, i'm going crazy that github always show error message 'You can't comment at this time'.