umbraco migration suddenly not working

Jeroen Breuer 4908 posts 12265 karma points MVP 4x admin c-trib

Jan 29, 2016 @ 16:23

API Questions

Umbraco 7

Hello,

We're using Umbraco migrations for creating custom database tables. This has always worked without any issues until now. When I try to run a migration the creation of the table works, but I get this exception afterwards:

    Request is not available in this context

at System.Web.HttpContextWrapper.get_Request()
   at Umbraco.Web.HttpCookieExtensions.ExpireCookie(HttpContextBase http, String cookieName)
   at Umbraco.Web.Strategies.Migrations.ClearCsrfCookiesAfterUpgrade.AfterMigration(MigrationRunner sender, MigrationEventArgs e)
   at Umbraco.Web.Strategies.Migrations.MigrationStartupHander.MigrationRunner_Migrated(MigrationRunner sender, MigrationEventArgs e)
   at Umbraco.Core.Events.TypedEventHandler`2.Invoke(TSender sender, TEventArgs e)
   at Umbraco.Core.Events.EventExtensions.RaiseEvent[TSender,TArgs](TypedEventHandler`2 eventHandler, TArgs args, TSender sender)
   at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
   at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade)
   at Project.Data.PetaPoco.DbConfiguration.InstallOrUpgrade() in d:\data\inetpub\project\Sources\Project.Data.PetaPoco\DbConfiguration.cs:line 69

So after the migration is completed it tries to delete a cookie. Because this doesn't work the version in the umbracoMigration doesn't go up. The table does exist in the database afterwards. Any idea what could cause this problem?

This is the migration:

/// <summary>
/// Runs on upgrade
/// </summary>
public override void Up()
{
    this.Create.Table("paymentLog")
        .WithColumn("Id").AsInt32().Identity().PrimaryKey("PK_paymentLog")
        .WithColumn("Date").AsDateTime().NotNullable()
        .WithColumn("Status").AsString(100).Nullable()
        .WithColumn("Request").AsCustom("nvarchar(MAX)").Nullable()
        .WithColumn("Response").AsCustom("nvarchar(MAX)").Nullable();
}

Jeroen

Copy Link

Jeroen Breuer 4908 posts 12265 karma points MVP 4x admin c-trib

Jan 29, 2016 @ 16:36

I see in our DbConfiguration we do the following

try
{
    migrationsRunner.Execute(this.db, true);
}
catch (HttpException e)
{
    // because umbraco runs some other migrations after the migration runner is executed we get httpexception
    // we cacht this error, but don't do anything
}
catch (Exception e)
{
    // we catch all other errors
    LogHelper.Error<DbConfiguration>("Error running migrations", e);
}

So we catch that httpexception. But still the version number in the table doesn't go up.

Jeroen

Copy Link

Shannon Deminick 1524 posts 5270 karma points MVP 2x

Jan 29, 2016 @ 21:09

Please log an issue with steps to reproduce and we can determine what is happening and where things are going wrong and why.

Copy Link

Dave Woestenborghs 3504 posts 12133 karma points MVP 8x admin c-trib

Jan 30, 2016 @ 08:58

Hi Shannon,

This is the code we have for running the migrations :

public class DbConfiguration : IDbConfiguration
    {
        private readonly Database db;

        /// <summary>
        /// Initializes a new instance of the <see cref="DbConfiguration"/> class.
        /// </summary>
        public DbConfiguration()
        {
            this.db = DatabaseHelper.GetDatabase();
        }

        /// <summary>
        /// Installs or upgrades db tables when needed
        /// </summary>
        public void InstallOrUpgrade()
        {
            var currentVersion = new SemVersion(0, 0, 0);

            var migrations = ApplicationContext.Current.Services.MigrationEntryService.GetAll(Constants.ProductName);

            var latestRunMigration = migrations.OrderByDescending(x => x.Version).FirstOrDefault();

            if (latestRunMigration != null)
            {
                currentVersion = latestRunMigration.Version;
            }

            var targetVersion = new SemVersion(Constants.Version);

            if (currentVersion == targetVersion)
            {
                // we do no need to run migrations
                return;
            }

            var migrationsRunner = new MigrationRunner(
                ApplicationContext.Current.Services.MigrationEntryService, 
                ApplicationContext.Current.ProfilingLogger.Logger, 
                currentVersion, 
                targetVersion, 
                Constants.ProductName);

            try
            {
                migrationsRunner.Execute(this.db, true);
            }
            catch (HttpException e)
            {
                // because umbraco runs some other migrations after the migration runner is executed we get httpexception
                // we cacht this error, but don't do anything
            }
            catch (Exception e)
            {
                // we catch all other errors
                LogHelper.Error<DbConfiguration>("Error running migrations", e);
            }
        }
    }

It's the first migration that we have the error with. We already did more than 50 succesfully. I personnaly think it's a edge case.

Will look further into it with Jeroen on Monday.

Dave

Copy Link

Shannon Deminick 1524 posts 5270 karma points MVP 2x

Jan 31, 2016 @ 11:51

yeah but how/when is this executing?

Copy Link

Dave Woestenborghs 3504 posts 12133 karma points MVP 8x admin c-trib

Feb 01, 2016 @ 09:40

On startup of the application. Trying to reproduce this today.

Dave