Exception while executing dotnet run --migrate-database #4508

13 Answer(s)

• 

  0

  liangshiwei created 3 years ago

  Fullstack Developer

  Hi,

  I could not reproduce the problem, could you share the full steps to reproduce it? thanks.

  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  Sraman created 3 years ago

  Hi, Even I tried with a new project and it works fine. But my existing project throws such exception and not sure why does that happens. Any idea what could be the issue?

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  Sraman created 3 years ago

  And also this is another exception I'm facing while executing Add-Migration command.

  PM> Add-Migration 'Initial' Build started... Build succeeded. [08:20:54 FTL] Pentapack.MRS terminated unexpectedly! Microsoft.Extensions.Hosting.HostAbortedException: The host was aborted. at Microsoft.Extensions.Hosting.HostFactoryResolver.HostingListener.ThrowHostAborted() at Microsoft.Extensions.Hosting.HostFactoryResolver.HostingListener.OnNext(KeyValuePair`2 value) at System.Diagnostics.DiagnosticListener.Write(String name, Object value) at Microsoft.Extensions.Hosting.HostBuilder.ResolveHost(IServiceProvider serviceProvider, DiagnosticListener diagnosticListener) at Microsoft.Extensions.Hosting.HostApplicationBuilder.Build() at Microsoft.AspNetCore.Builder.WebApplicationBuilder.Build() at Pentapack.MRS.Program.Main(String[] args) in D:\Source\Repos\Pentapack.MRS\Pentapack.MRS\Program.cs:line 41

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 3 years ago

  Fullstack Developer

  It's a DI problem, looks like one of your services is not registered with the container.

  Some possible reasons:

  • You didn't add the DbSet to the database context for your entity.
  • You miss the Dependency Interfaces for your own service

  Dependency Injection document: https://docs.abp.io/en/abp/latest/Dependency-Injection

  You can share the project with me if you still not found the problem, I will check it. shiwei.liang@volosoft.com

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  Sraman created 3 years ago

  Hi,

  I could resolve this exception "Microsoft.Extensions.Hosting.HostAbortedException". But couldn't find any clue on "Autofac.Core.DependencyResolutionException: An exception was thrown while activating Pentapack.MRS.Data.MRSDbMigrationService."

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  Sraman created 3 years ago

  Can you please check you mail box

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 3 years ago

  Fullstack Developer

  Hi,

  Please add these module dependencies to MRSModule

  // Saas Management module packages
  typeof(SaasHostWebModule),
  typeof(SaasHostHttpApiModule),
  typeof(SaasHostApplicationModule),
  typeof(SaasEntityFrameworkCoreModule)
  

  BTW, I guess you don't want to include the SaasModule in your project. if so, you don't need to add module dependencies. but you should remove all ITenantRepository uses.

  Update the MRSDbMigrationService class.

  public class MRSDbMigrationService : ITransientDependency
  {
      public ILogger<MRSDbMigrationService> Logger { get; set; }
  
      private readonly IDataSeeder _dataSeeder;
      private readonly MRSEFCoreDbSchemaMigrator _dbSchemaMigrator;
  
      public MRSDbMigrationService(
          IDataSeeder dataSeeder,
          MRSEFCoreDbSchemaMigrator dbSchemaMigrator)
      {
          _dataSeeder = dataSeeder;
          _dbSchemaMigrator = dbSchemaMigrator;
  
          Logger = NullLogger<MRSDbMigrationService>.Instance;
      }
  
      public async Task MigrateAsync()
      {
          var initialMigrationAdded = AddInitialMigrationIfNotExist();
  
          if (initialMigrationAdded)
          {
              return;
          }
  
          Logger.LogInformation("Started database migrations...");
  
          await MigrateDatabaseSchemaAsync();
          await SeedDataAsync();
  
          Logger.LogInformation($"Successfully completed host database migrations.");
  
          Logger.LogInformation("You can safely end this process...");
      }
      
      .........
   }
  

  Add the following code to Program class

  if (IsMigrateDatabase(args))
  {
      builder.Services.AddDataMigrationEnvironment();
  }
  

  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  Sraman created 3 years ago

  Hi, Thanks it fixed that issue and now I'm able to migrate.

  But I have one issue while migration, that is I'm trying to create db and tables with default data on deployment by implementing the below code on OnApplicationInitialization in module file,

  var dbContext = serviceScope.ServiceProvider.GetRequiredService<MRSDbContext>(); dbContext.Database.EnsureCreated();

  It is creating db and their respective tables, but data seeding is not happening. User table looks empty.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 3 years ago

  Fullstack Developer

  Hi,

  You need to use the data seeding system to initial data: https://docs.abp.io/en/abp/latest/Data-Seeding

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  Sraman created 3 years ago

  I have implemented data seeding using IDataSeedContributor and it is working fine with ./migrate-database.

  But I'm looking to migrate on runtime while deploying using the below code,

  var dbContext = serviceScope.ServiceProvider.GetRequiredService<MRSDbContext>(); dbContext.Database.EnsureCreated();

  It is creating db and table, but not data.

  Any suggestions on this?

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 3 years ago

  Fullstack Developer

  Hi,

  Try await serviceScope.ServiceProvider.GetRequiredService<MRSDbMigrationService>().MigrateAsync();

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  Sraman created 3 years ago

  That worked. But after deployment post requests are not working. Throwing below error.

  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  liangshiwei created 3 years ago

  Fullstack Developer

  Hi,

  I think your main problem has been solved and the new problem is not related to this.

  Could you create a new question? thanks.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel