500 error when registering account or logging in
This appears to impact newly created accounts.
https://sentry.gitlab.net/gitlab/gitlabcom/issues/1049988/
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
active_record/connection_adapters/postgresql_adapter.rb:611:in `async_exec_params'
@connection.exec_params(sql, type_casted_binds)
active_record/connection_adapters/postgresql_adapter.rb:611:in `block (2 levels) in exec_no_cache'
@connection.exec_params(sql, type_casted_binds)
active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
yield
active_support/concurrency/share_lock.rb:187:in `yield_shares'
yield
active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
@lock.yield_shares(compatible: [:load]) do
...
(218 additional frame(s) were not displayed)
ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT COUNT(*) FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 4994693 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20))
ActionView::Template::Error: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT COUNT(*) FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 4994693 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20))
ActionView::Template::Error: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT COUNT(*) FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 4994693 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20))
Workaround
The exception affects the RootController
. Navigate to another page, such as https://gitlab.com/explore.
Related Support Tickets (internal)
- https://gitlab.zendesk.com/agent/tickets/139321
- https://gitlab.zendesk.com/agent/tickets/139293
- https://gitlab.zendesk.com/agent/tickets/139261
- https://gitlab.zendesk.com/agent/tickets/139340
- https://gitlab.zendesk.com/agent/tickets/139288
- https://gitlab.zendesk.com/agent/tickets/139263
- https://gitlab.zendesk.com/agent/tickets/139314
- https://gitlab.zendesk.com/agent/tickets/139354
- https://gitlab.zendesk.com/agent/tickets/139312
- https://gitlab.zendesk.com/agent/tickets/139353
- https://gitlab.zendesk.com/agent/tickets/139361
- https://gitlab.zendesk.com/agent/tickets/139371
- https://gitlab.zendesk.com/agent/tickets/139385
- https://gitlab.zendesk.com/agent/tickets/139400
Edited by Cynthia "Arty" Ng