Part of Deploy.Migration fails with SQLite Error 1: ‘no such column: −800’ on MacOS

Questions
,
1

Hi,

I’m not really sure where to put this (Github issues, Support…) as it is part of Cloud and Deploy, but anyways. Maybe someone here has had the same experience.

Cloning the latest version of our repository with Cms 17.1.0 and Deploy 17.0.1, I get an error for a Deploy Migration, but ONLY on Mac. Windows works fine.

Steps to reproduce:
git clone [repository]
dotnet build
dotnet run

Macos 26.1, dotnet 10.0.102:

[13:02:57 INF] Execute AddTransferQueueLock
[13:02:57 INF] SQL [0]: INSERT INTO “umbracoLock” (“id”,“name”,“value”) VALUES (−800,‘DeployTransferQueue’,1);
[13:02:57 ERR] Exception (6661e7b2).
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: ‘no such column: −800’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Umbraco.Cms.Persistence.Sqlite.Services.SqlitePreferDeferredTransactionsConnection.CommandWrapper.ExecuteNonQuery()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 270
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.b__32_0()
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass38_01.<Execute>b__0() at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func1 f) at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery() at NPoco.Database.<>c__DisplayClass338_0.<ExecuteNonQueryHelper>b__0() at NPoco.Database.ExecutionHook[T](Func1 action)
at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)
at NPoco.Database.Execute(String sql, CommandType commandType, Object args)
at NPoco.Database.Execute(Sql Sql)
at NPoco.Database.Execute(String sql, Object args)
at Umbraco.Cms.Infrastructure.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)
at Umbraco.Cms.Infrastructure.Migrations.MigrationExpressionBase.Execute()
at Umbraco.Cms.Infrastructure.Migrations.Expressions.Insert.InsertIntoBuilder.Do()
at Umbraco.Deploy.Infrastructure.Persistence.Migrations.AddTransferQueueLock.Migrate()
at Umbraco.Cms.Infrastructure.Migrations.MigrationBase.MigrateAsync()
at Umbraco.Cms.Infrastructure.Migrations.AsyncMigrationBase.RunAsync()
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.RunMigrationAsync(Type migrationType, MigrationContext context)
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.RunScopedMigrationAsync(Transition transition, MigrationPlan plan)
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.RunMigrationPlanAsync(MigrationPlan plan, String fromState)
[13:02:57 ERR] Plan Deploy.Migration failed at step {6d9b2927-4b44-4ac4-ace7-2b3de2aecb49}
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: ‘no such column: −800’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Umbraco.Cms.Persistence.Sqlite.Services.SqlitePreferDeferredTransactionsConnection.CommandWrapper.ExecuteNonQuery()
at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 270
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.b__32_0()
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass38_01.<Execute>b__0() at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)
at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func1 f) at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery() at NPoco.Database.<>c__DisplayClass338_0.<ExecuteNonQueryHelper>b__0() at NPoco.Database.ExecutionHook[T](Func1 action)
at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)
at NPoco.Database.Execute(String sql, CommandType commandType, Object args)
at NPoco.Database.Execute(Sql Sql)
at NPoco.Database.Execute(String sql, Object args)
at Umbraco.Cms.Infrastructure.Migrations.MigrationExpressionBase.ExecuteStatement(StringBuilder stmtBuilder)
at Umbraco.Cms.Infrastructure.Migrations.MigrationExpressionBase.Execute()
at Umbraco.Cms.Infrastructure.Migrations.Expressions.Insert.InsertIntoBuilder.Do()
at Umbraco.Deploy.Infrastructure.Persistence.Migrations.AddTransferQueueLock.Migrate()
at Umbraco.Cms.Infrastructure.Migrations.MigrationBase.MigrateAsync()
at Umbraco.Cms.Infrastructure.Migrations.AsyncMigrationBase.RunAsync()
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.RunMigrationAsync(Type migrationType, MigrationContext context)
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.RunScopedMigrationAsync(Transition transition, MigrationPlan plan)
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.RunMigrationPlanAsync(MigrationPlan plan, String fromState)
[13:02:57 INF] Package migration completed for Deploy.Migration (33ms) [Timing 1206d25]
[13:02:57 INF] Starting package migration for UmbracoForms [Timing d5b334f]
[13:02:57 INF] Starting ‘UmbracoForms’…

Same section in Windows 11 25H2, dotnet 10.0.102:

[13:09:55 INF] Execute AddTransferQueueLock
[13:09:55 INF] SQL [0]: INSERT INTO “umbracoLock” (“id”,“name”,“value”) VALUES (-800,‘DeployTransferQueue’,1);
[13:09:55 INF] At {6d9b2927-4b44-4ac4-ace7-2b3de2aecb49}
[13:09:55 INF] Execute AlterUdiColumnLengths
[13:09:55 INF] At {d9767d18-5500-4db4-b024-639202dd0dcd}
[13:09:55 INF] Execute AssignDefaultPermissionsForImportExport
[13:09:55 INF] Assigned Deploy permission letter ‘Deploy.Import’ to user group ‘admin’
[13:09:55 INF] Assigned Deploy permission letter ‘Deploy.Export’ to user group ‘admin’
[13:09:55 INF] Deploy permissions updated and saved
[13:09:55 INF] At {baf16186-066a-45f2-93c5-382bb433d49f}
[13:09:55 INF] Execute ClearSignatures
[13:09:55 INF] At {8a9cee1e-6ee1-4760-a450-a2dfb41fee50}
[13:09:55 INF] Execute NoopMigration
[13:09:55 INF] At {0c141bcc-2d15-43e9-9729-5cc6b0f47565}
[13:09:55 INF] Execute MigrateCharPermissionsToStrings
[13:09:55 INF] At {f7ddae05-137b-4c91-8e36-e0f0cc7118ea}
[13:09:55 INF] Execute ClearSignatures
[13:09:55 INF] At {0959fb52-7543-402f-8c24-dd9f64161b21}
[13:09:55 INF] Done
[13:09:55 INF] Package migration completed for Deploy.Migration (172ms) [Timing e001a77]
[13:09:55 INF] Starting package migration for Umbraco.Licenses [Timing c19a286]
[13:09:55 INF] Starting ‘Umbraco.Licenses’…

2

Hey Rolf, i showed it to my friend, he says he sees a unicode minus (−800EN Dash U+2212) instead of a normal ASCII minus (-800U+002D), thats why It works on Windows but fails on macOS SQLite

did u try this changing that value to see if it works?

// original from ur log
Insert.IntoTable(“umbracoLock”).Row(new { id = −800, name = “DeployTransferQueue”, value = 1 });

// replace with this
Insert.IntoTable(“umbracoLock”).Row(new { id = -800, name = “DeployTransferQueue”, value = 1 });

3

@BishalTimalsina12 interesting observation! However, it’s a built in migration and I really don’t know where to edit any of the SQL.

However, I solved the problem. I was in the Packages section in Umbraco Backoffice because of another reason. Under Installed packages there was a yellow button next to Umbraco.Deploy titled “Run pending migration” or similar and I pressed it. The migration ran without errors! :smiley:

[16:37:07 INF] Starting package migration for Deploy.Migration [Timing 78a19a6]
[16:37:07 INF] Starting ‘Deploy.Migration’…
[16:37:07 INF] At {c757ab7e-a3d0-4533-8cd9-9ce457927a81}
[16:37:07 INF] Execute AddTransferQueueLock
[16:37:07 INF] SQL [0]: INSERT INTO “umbracoLock” (“id”,“name”,“value”) VALUES (-800,‘DeployTransferQueue’,1);
[16:37:07 INF] At {6d9b2927-4b44-4ac4-ace7-2b3de2aecb49}
[16:37:07 INF] Execute AlterUdiColumnLengths
[16:37:07 INF] At {d9767d18-5500-4db4-b024-639202dd0dcd}
[16:37:07 INF] Execute AssignDefaultPermissionsForImportExport
[16:37:07 INF] Assigned Deploy permission letter ‘Deploy.Import’ to user group ‘admin’
[16:37:07 INF] Assigned Deploy permission letter ‘Deploy.Export’ to user group ‘admin’
[16:37:07 INF] Deploy permissions updated and saved
[16:37:07 INF] At {baf16186-066a-45f2-93c5-382bb433d49f}
[16:37:07 INF] Execute ClearSignatures
[16:37:07 INF] At {8a9cee1e-6ee1-4760-a450-a2dfb41fee50}
[16:37:07 INF] Execute NoopMigration
[16:37:07 INF] At {0c141bcc-2d15-43e9-9729-5cc6b0f47565}
[16:37:07 INF] Execute MigrateCharPermissionsToStrings
[16:37:07 INF] At {f7ddae05-137b-4c91-8e36-e0f0cc7118ea}
[16:37:07 INF] Execute ClearSignatures
[16:37:07 INF] At {0959fb52-7543-402f-8c24-dd9f64161b21}
[16:37:07 INF] Done
[16:37:07 INF] Package migration completed for Deploy.Migration (28ms) [Timing 78a19a6]

4

yay!

happy for u ! :high-5-you-rock:

1 Like
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.