Update 2025.1.3 to 2025.2.0

[Nixxeee]

Steps To Reproduce

1. Update bitwarden/self-host:2025.1.3-beta to bitwarden/self-host:2025.2.0-beta

Expected Result

2025-04-22 23:30:11.190 +02:00 [ERR] Failed executing DbCommand (2ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
SELECT o.Enabled, o.Id, o.Use2fa, o.UseEvents, o.UsersGetPremium, o.Use2fa AND (o.TwoFactorProviders IS NOT NULL) AS Using2fa, o.UseSso, o.UseKeyConnector, o.UseResetPassword, o.UseScim, o.UseCustomPermissions, o.UsePolicies, o.LimitCollectionCreation, o.LimitCollectionDeletion, o.LimitItemDeletion, o.AllowAdminAccessToAllCollectionItems, o.UseRiskInsights
FROM Organization AS o
2025-04-22 23:30:11.212 +02:00 [ERR] An exception occurred while iterating over the results of a query for context type 'Bit.Infrastructure.EntityFramework.Repositories.DatabaseContext'.
MySqlConnector.MySqlException (0x80004005): Unknown column 'o.LimitItemDeletion' in 'SELECT'
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in //src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in //src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483 at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56 at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357 at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() MySqlConnector.MySqlException (0x80004005): Unknown column 'o.LimitItemDeletion' in 'SELECT' at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130 at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in //src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync()

Actual Result

I can't connect via the web interface: An error has occurred. An unexpected error has occurred.

Screenshots or Videos

No response

Additional Context

No response

Githash Version

12673f0-dirty

Environment Details

• Docker engine on Unraid OS
• MariaDB

Database Image

mariadb:10

Issue-Link

#2480

Issue Tracking Info

• I understand that work is tracked outside of Github. A PR will be linked to this issue should one be opened to address it, but Bitwarden doesn't use fields like "assigned", "milestone", or "project" to track progress.

[daniellbw]

Hi there,

I am unable to reproduce this issue, it has been escalated for further investigation. If you have more information that can help us, please add it below.

Thanks!

[Nixxeee]

The “__EFMigrationsHistory” table contains :
+-----------------------------------------------------------------------+----------------+
| MigrationId | ProductVersion |
+-----------------------------------------------------------------------+----------------+
| 20210617183900_Init | 6.0.12 |
| 20210709095522_RemoveProviderOrganizationProviderUser | 6.0.12 |
| 20210716142145_UserForcePasswordReset | 6.0.12 |
| 20210921132418_AddMaxAutoscaleSeatsToOrganization | 6.0.12 |
| 20211011144835_SplitManageCollectionsPermissions2 | 6.0.12 |
| 20211021201150_SetMaxAutoscaleSeatsToCurrentSeatCount | 6.0.12 |
| 20211108041911_KeyConnector | 6.0.12 |
| 20211108225243_OrganizationSponsorship | 6.0.12 |
| 20211115145402_KeyConnectorFlag | 6.0.12 |
| 20220121092546_RemoveU2F | 6.0.12 |
| 20220301215315_FailedLoginCaptcha | 6.0.12 |
| 20220322191314_SelfHostF4E | 6.0.12 |
| 20220411191518_SponsorshipBulkActions | 6.0.12 |
| 20220420170738_AddInstallationIdToEvents | 6.0.12 |
| 20220524171600_DeviceUnknownVerification | 6.0.12 |
| 20220608191914_DeactivatedUserStatus | 6.0.12 |
| 20220707163017_UseScimFlag | 6.0.12 |
| 20220912144222_PasswordlessAuthRequests | 6.0.12 |
| 20220927142038_EventsSystemUser | 6.0.12 |
| 20221020154432_UseCustomPermissionsFlag | 6.0.12 |
| 20221024210500_PasswordlessAuthRequestAddApprovedColumn | 6.0.12 |
| 20221114202829_OrganizationDomainClaim | 6.0.12 |
| 20221115030843_AvatarColor | 6.0.12 |
| 20221129004644_OrganizationDomainClaimRenameNextRunCount | 6.0.12 |
| 20221209015017_EventsDomainName | 6.0.12 |
| 20221209192355_OrganizationDomainLastCheckedDate | 6.0.12 |
| 20221226164641_ProviderAddProviderTypeBillingPhone | 6.0.12 |
| 20230106122006_SecretsManager | 6.0.12 |
| 20230113175447_Fix Navigation Properties | 6.0.12 |
| 20230118225349_RemoveDeviceUnknownVerification | 6.0.12 |
| 20230120160248_OrganizationStatus | 6.0.12 |
| 20230124132226_KDFOptions | 6.0.12 |
| 20230201175203_SecretsManagerOrganizationUser | 6.0.12 |
| 20230201192610_LastUserDates | 6.0.12 |
| 20230208212115_CipherKeyUpdate | 7.0.5 |
| 20230213133250_SecretsManagerEvent | 6.0.12 |
| 20230428130731_EFUpdate | 6.0.12 |
| 20230522030836_AddKeysToDevice | 6.0.12 |
| 20230523223530_ClientSecretHash | 6.0.12 |
| 20230530114306_AddSecretsManagerBillingFieldToOrganization | 6.0.12 |
| 20230605183142_TdeAdminApproval | 6.0.12 |
| 20230720203306_2023-07-11_00_CollectionManagePermission.sql | 7.0.5 |
| 20230726191551_SecretsManagerBetaColumn | 7.0.5 |
| 20230807181649_LimitCollectionCreateDelete | 7.0.5 |
| 20230824202452_ACCESSPOLICY_ADD_DELETE_CASCADE | 7.0.5 |
| 20231025225542_AdminCollectionItemAccess | 7.0.14 |
| 20231213032050_WebAuthnLoginCredentials | 7.0.14 |
| 20231214162533_GrantIdWithIndexes | 7.0.15 |
| 20231229202309_AddToolsTableIndexes | 7.0.15 |
| 20240104034851_OrganizationFlexibleCollectionsColumn | 7.0.15 |
| 20240104162658_AddCipherIdToSend | 7.0.20 |
| 20240109215348_AddTableIndexes | 7.0.15 |
| 20240112180622_AddAuthTableIndexes | 7.0.15 |
| 20240131215347_RemoveSMBetaFromOrganization | 7.0.20 |
| 20240216170327_AddSecretAccessPolicies | 7.0.20 |
| 20240308141726_SetupProviderBilling | 7.0.20 |
| 20240425111441_EnableOrgsCollectionEnhancements | 7.0.20 |
| 20240507185445_UpdateProviderGatewayType | 7.0.20 |
| 20240606152409_ProviderInvoiceItem | 7.0.20 |
| 20240701175219_Net8Sync | 8.0.7 |
| 20240702142224_DistributedCache | 8.0.7 |
| 20240703182722_AddClientIdToProviderInvoiceItem | 8.0.7 |
| 20240703192754_UpdateNullConstraints | 8.0.7 |
| 20240703205907_UpdateNullConstraintsAdminConsole | 8.0.7 |
| 20240723011515_DropOrganizationFlexibleCollections | 8.0.7 |
| 20240724001641_MakeBlobNonNull | 8.0.7 |
| 20240811224843_GroupAccessAllDefaultValue | 8.0.8 |
| 20240826231342_OrganizationUserAccessAllDefaultValue | 8.0.8 |
| 20240828101433_FinalFlexibleCollectionsDataMigrations | 8.0.8 |
| 20240902034915_DropGroupAccessAll | 8.0.8 |
| 20240909133252_NotificationCenter | 8.0.8 |
| 20240909181805_GenerateDuoSDKVersion4TwoFactorMetadata | 8.0.8 |
| 20240924010535_DropOrganizationUserAccessAll | 8.0.8 |
| 20240925201836_SplitOrganizationLimitCollectionCreationDeletionColumn | 8.0.8 |
| 20240925202356_SyncOrganizationLimitCollectionCreationDeletionColumn | 8.0.8 |
| 20241004154527_AddClientOrganizationMigrationRecordTable | 8.0.8 |
| 20241031154652_PasswordHealthReportApplication | 8.0.8 |
| 20241031170511_DeviceActivation | 8.0.8 |
| 20241105195202_FixPasswordHealthReportApplication | 8.0.8 |
| 20241112001902_SecurityTasks | 8.0.8 |
| 20241125185627_AddUseRiskInsightsFlag | 8.0.8 |
| 20241126185456_AddTable_OrganizationInstallation | 8.0.8 |
| 20241202201938_AddInstallationLastActivityDateColumn | 8.0.8 |
| 20241219035803_AlterUser_AddVerifyDevice | 8.0.8 |
+-----------------------------------------------------------------------+----------------+

You can see it's stuck at 20241219035803_AlterUser_AddVerifyDevice. I've tried reverting versions one by one since 2024.12.1 presented here https://hub.docker.com/r/bitwarden/self-host/tags but it doesn't work ...
How can I migrate these basic fixes manually?

Thanks :)

[Nixxeee]

BW_ENABLE_ADMIN=false in my docker run......
sorry for the inconvenience.😱​🥲​