Error 500s due to missing column support_bot
Sentry is behind, but when I look at production.log
on canary I see lots of these errors:
ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR: column users.support_bot does not exist
LINE 1: ...roup_id" AS t1_r78, "users"."bot_type" AS t1_r79, "users"."s...
^
: SELECT "namespaces"."id" AS t0_r0, "namespaces"."name" AS t0_r1, "namespaces"."path" AS t0_r2, "namespaces"."owner_id" AS t0_r3, "namespaces"."created_at" AS t0_r4, "namespaces"."updated_at" AS t0_r5, "namespaces"."type" AS t0_r6, "namespaces"."description" AS t0_r7, "namespaces"."avatar" AS t0_r8, "namespaces"."membership_lock" AS t0_r9, "namespaces"."share_with_group_lock" AS t0_r10, "namespaces"."visibility_level" AS t0_r11, "namespaces"."request_access_enabled" AS t0_r12, "namespaces"."ldap_sync_status" AS t0_r13, "namespaces"."ldap_sync_error" AS t0_r14, "namespaces"."ldap_sync_last_update_at" AS t0_r15, "namespaces"."ldap_sync_last_successful_update_at" AS t0_r16, "namespaces"."ldap_sync_last_sync_at" AS t0_r17, "namespaces"."lfs_enabled" AS t0_r18, "namespaces"."description_html" AS t0_r19, "namespaces"."parent_id" AS t0_r20, "namespaces"."shared_runners_minutes_limit" AS t0_r21, "namespaces"."repository_size_limit" AS t0_r22, "namespaces"."require_two_factor_authentication" AS t0_r23, "namespaces"."two_factor_grace_period" AS t0_r24, "namespaces"."cached_markdown_version" AS t0_r25, "namespaces"."plan_id" AS t0_r26, "namespaces"."project_creation_level" AS t0_r27, "namespaces"."runners_token" AS t0_r28, "namespaces"."trial_ends_on" AS t0_r29, "namespaces"."file_template_project_id" AS t0_r30, "namespaces"."saml_discovery_token" AS t0_r31, "namespaces"."runners_token_encrypted" AS t0_r32, "namespaces"."custom_project_templates_group_id" AS t0_r33, "namespaces"."auto_devops_enabled" AS t0_r34, "namespaces"."extra_shared_runners_minutes_limit" AS t0_r35, "namespaces"."last_ci_minutes_notification_at" AS t0_r36, "namespaces"."last_ci_minutes_usage_notification_level" AS t0_r37, "namespaces"."subgroup_creation_level" AS t0_r38, "namespaces"."emails_disabled" AS t0_r39, "users"."id" AS t1_r0, "users"."email" AS t1_r1, "users"."encrypted_password" AS t1_r2, "users"."reset_password_token" AS t1_r3, "users"."reset_password_sent_at" AS t1_r4, "users"."remember_created_at" AS t1_r5, "users"."sign_in_count" AS t1_r6, "users"."current_sign_in_at" AS t1_r7, "users"."last_sign_in_at" AS t1_r8, "users"."current_sign_in_ip" AS t1_r9, "users"."last_sign_in_ip" AS t1_r10, "users"."created_at" AS t1_r11, "users"."updated_at" AS t1_r12, "users"."name" AS t1_r13, "users"."admin" AS t1_r14, "users"."projects_limit" AS t1_r15, "users"."skype" AS t1_r16, "users"."linkedin" AS t1_r17, "users"."twitter" AS t1_r18, "users"."bio" AS t1_r19, "users"."failed_attempts" AS t1_r20, "users"."locked_at" AS t1_r21, "users"."username" AS t1_r22, "users"."can_create_group" AS t1_r23, "users"."can_create_team" AS t1_r24, "users"."state" AS t1_r25, "users"."color_scheme_id" AS t1_r26, "users"."password_expires_at" AS t1_r27, "users"."created_by_id" AS t1_r28, "users"."avatar" AS t1_r29, "users"."confirmation_token" AS t1_r30, "users"."confirmed_at" AS t1_r31, "users"."confirmation_sent_at" AS t1_r32, "users"."unconfirmed_email" AS t1_r33, "users"."hide_no_ssh_key" AS t1_r34, "users"."website_url" AS t1_r35, "users"."last_credential_check_at" AS t1_r36, "users"."admin_email_unsubscribed_at" AS t1_r37, "users"."notification_email" AS t1_r38, "users"."hide_no_password" AS t1_r39, "users"."password_automatically_set" AS t1_r40, "users"."location" AS t1_r41, "users"."public_email" AS t1_r42, "users"."encrypted_otp_secret" AS t1_r43, "users"."encrypted_otp_secret_iv" AS t1_r44, "users"."encrypted_otp_secret_salt" AS t1_r45, "users"."otp_required_for_login" AS t1_r46, "users"."otp_backup_codes" AS t1_r47, "users"."dashboard" AS t1_r48, "users"."project_view" AS t1_r49, "users"."consumed_timestep" AS t1_r50, "users"."layout" AS t1_r51, "users"."hide_project_limit" AS t1_r52, "users"."unlock_token" AS t1_r53, "users"."note" AS t1_r54, "users"."otp_grace_period_started_at" AS t1_r55, "users"."external" AS t1_r56, "users"."organization" AS t1_r57, "users"."incoming_email_token" AS t1_r58, "users"."auditor" AS t1_r59, "users"."ghost" AS t1_r60, "users"."require_two_factor_authentication_from_group" AS t1_r61, "users"."two_factor_grace_period" AS t1_r62, "users"."notified_of_own_activity" AS t1_r63, "users"."last_activity_on" AS t1_r64, "users"."preferred_language" AS t1_r65, "users"."email_opted_in" AS t1_r66, "users"."email_opted_in_ip" AS t1_r67, "users"."email_opted_in_source_id" AS t1_r68, "users"."email_opted_in_at" AS t1_r69, "users"."theme_id" AS t1_r70, "users"."accepted_term_id" AS t1_r71, "users"."feed_token" AS t1_r72, "users"."private_profile" AS t1_r73, "users"."roadmap_layout" AS t1_r74, "users"."include_private_contributions" AS t1_r75, "users"."commit_email" AS t1_r76, "users"."group_view" AS t1_r77, "users"."managing_group_id" AS t1_r78, "users"."bot_type" AS t1_r79, "users"."support_bot" AS t1_r80, "users"."first_name" AS t1_r81, "users"."last_name" AS t1_r82, "routes"."id" AS t2_r0, "routes"."source_id" AS t2_r1, "routes"."source_type" AS t2_r2, "routes"."path" AS t2_r3, "routes"."created_at" AS t2_r4, "routes"."updated_at" AS t2_r5, "routes"."name" AS t2_r6 FROM "namespaces" LEFT OUTER JOIN "users" ON "users"."id" = "namespaces"."owner_id" LEFT OUTER JOIN "routes" ON "routes"."source_id" = "namespaces"."id" AND "routes"."source_type" = 'Namespace' WHERE ((LOWER(routes.path) = LOWER('rkothur')))):
ee/lib/gitlab/database/load_balancing/connection_proxy.rb:63:in `block in read_using_load_balancer'
ee/lib/gitlab/database/load_balancing/load_balancer.rb:84:in `block in read_write'
ee/lib/gitlab/database/load_balancing/load_balancer.rb:134:in `retry_with_backoff'
ee/lib/gitlab/database/load_balancing/load_balancer.rb:83:in `read_write'
ee/lib/gitlab/database/load_balancing/connection_proxy.rb:62:in `read_using_load_balancer'
ee/lib/gitlab/database/load_balancing/connection_proxy.rb:41:in `select_all'
lib/banzai/filter/user_reference_filter.rb:85:in `namespaces'
lib/banzai/filter/user_reference_filter.rb:67:in `block (2 levels) in user_link_filter'
lib/banzai/request_store_reference_cache.rb:13:in `block in cached_call'
lib/banzai/request_store_reference_cache.rb:23:in `get_or_set_cache'
lib/banzai/request_store_reference_cache.rb:13:in `cached_call'
lib/banzai/filter/user_reference_filter.rb:66:in `block in user_link_filter'
lib/banzai/filter/user_reference_filter.rb:24:in `block in references_in'
lib/banzai/filter/user_reference_filter.rb:23:in `gsub'
lib/banzai/filter/user_reference_filter.rb:23:in `references_in'
lib/banzai/filter/user_reference_filter.rb:62:in `user_link_filter'
lib/banzai/filter/user_reference_filter.rb:37:in `block (2 levels) in call'
lib/banzai/filter/reference_filter.rb:120:in `replace_text_when_pattern_matches'
lib/banzai/filter/user_reference_filter.rb:36:in `block in call'
lib/banzai/filter/user_reference_filter.rb:34:in `each'
lib/banzai/filter/user_reference_filter.rb:34:in `call'
Affecting the ability to add @
mentions in issues. Any mention of a user or a group in an issue results in a 500 error on preview or submit.
See
2 / 24 requests
13.8 KB / 32.2 KB transferred
75.9 KB / 4.7 MB resources
Finish: 3.93 s
Request URL: https://gitlab.com/gitlab-org/quality/triage-ops/preview_markdown?target_type=Issue
Request Method: POST
Status Code: 500 Internal Server Error
Remote Address: 35.231.145.151:443
Referrer Policy: origin-when-cross-origin
Edited by Mek Stittri