Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Organization view fail: Unknown column 'p.Gateway' in 'field list' #4207

Closed
1 task done
holow29 opened this issue Jun 20, 2024 · 1 comment
Closed
1 task done

Organization view fail: Unknown column 'p.Gateway' in 'field list' #4207

holow29 opened this issue Jun 20, 2024 · 1 comment
Labels
bug bw-unified-deploy An Issue related to Bitwarden unified deployment

Comments

@holow29
Copy link
Contributor

holow29 commented Jun 20, 2024

Steps To Reproduce

  1. Go into admin portal
  2. Click 'Organizations' at the top
  3. Click an organization

Expected Result

I would expect the organization details to load

Actual Result

Nginx 404 page and when going back, an error stating Unknown column 'p.Gateway' in 'field list'

Screenshots or Videos

No response

Additional Context

Admin.log:

fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
      => SpanId:4eaed1c933ea2306, TraceId:4ca1c439da42208a053d05bd15d84082, ParentId:xxxxxxxxxxxxxxxx => ConnectionId:0HN4H6D74D29G => RequestPath:/admin/organizations/view/7823390c-o65d-4f1e-a1d6-af8e015a278a RequestId:0HN4H6D74D29G:00000001 => Bit.Admin.AdminConsole.Controllers.OrganizationsController.View (Admin)
      Failed executing DbCommand (108ms) [Parameters=[@__organizationId_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
      SELECT `p`.`Id`, `p`.`BillingEmail`, `p`.`BillingPhone`, `p`.`BusinessAddress1`, `p`.`BusinessAddress2`, `p`.`BusinessAddress3`, `p`.`BusinessCountry`, `p`.`BusinessName`, `p`.`BusinessTaxNumber`, `p`.`CreationDate`, `p`.`Enabled`, `p`.`Gateway`, `p`.`GatewayCustomerId`, `p`.`GatewaySubscriptionId`, `p`.`Name`, `p`.`RevisionDate`, `p`.`Status`, `p`.`Type`, `p`.`UseEvents`
      FROM `Provider` AS `p`
      INNER JOIN `ProviderOrganization` AS `p0` ON `p`.`Id` = `p0`.`ProviderId`
      WHERE `p0`.`OrganizationId` = @__organizationId_0
      LIMIT 1
fail: Microsoft.EntityFrameworkCore.Query[10100]
      => SpanId:4eaed1c933ea2306, TraceId:4ca1c439da42208a053d05bd15d84082, ParentId:xxxxxxxxxxxxxxxx => ConnectionId:0HN4H6D74D29G => RequestPath:/admin/organizations/view/7823390c-o65d-4f1e-a1d6-af8e015a278a RequestId:0HN4H6D74D29G:00000001 => Bit.Admin.AdminConsole.Controllers.OrganizationsController.View (Admin)
      An exception occurred while iterating over the results of a query for context type 'Bit.Infrastructure.EntityFramework.Repositories.DatabaseContext'.
      MySqlConnector.MySqlException (0x80004005): Unknown column 'p.Gateway' in 'field list'
         at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 962
         at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
         at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
         at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
         at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, 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 344
         at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337
         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.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
         at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
      MySqlConnector.MySqlException (0x80004005): Unknown column 'p.Gateway' in 'field list'
         at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 962
         at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
         at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
         at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
         at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, 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 344
         at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337
         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.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
         at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
         at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()

Api.log:

fail: Bit.Core.Billing.Queries.Implementations.SubscriberQueries[0]
      => SpanId:17125e3facb67119, TraceId:00df5f9a718d017c6192bd33191f5cd5, ParentId:xxxxxxxxxxxxxxxx => ConnectionId:0HN3K7IG135PL => RequestPath:/organizations/7823390c-o65d-4f1e-a1d6-af8e015a278a/billing/metadata RequestId:0HN3K7IG135PL:00000001 => Bit.Api.Billing.Controllers.OrganizationBillingController.GetMetadataAsync (Api)
      Cannot retrieve subscription for subscriber (7823390c-o65d-4f1e-a1d6-af8e015a278a) with no GatewaySubscriptionId

Certain IDs edited for privacy

Githash Version

8e1ad16-dirty

Environment Details

Docker bitwarden-unified self-host:beta 2024.6.1-beta
Server: 2024.6.1
Web: 2024.6.0

Database Image

MariaDB 11.4.2

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.
@holow29 holow29 added bug bw-unified-deploy An Issue related to Bitwarden unified deployment labels Jun 20, 2024
@holow29
Copy link
Contributor Author

holow29 commented Aug 15, 2024

Appears to be resolved now. I am not sure when it was fixed, but working on 2024.7.2-beta

@holow29 holow29 closed this as completed Aug 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug bw-unified-deploy An Issue related to Bitwarden unified deployment
Projects
None yet
Development

No branches or pull requests

1 participant