Mysql2::Error: Unknown column 'award_emoji.count' on master
It looks like https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/12962 caused some mysql failures on master:
1) AutocompleteController GET award_emojis unauthorized user returns empty json
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` IS NULL GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./spec/controllers/autocomplete_controller_spec.rb:352:in `block (4 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
2) AutocompleteController GET award_emojis sign in as user without award emoji returns empty json
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 156 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./spec/controllers/autocomplete_controller_spec.rb:361:in `block (4 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
3) AutocompleteController GET award_emojis sign in as user with award emoji returns json sorted by name count
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 205 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./spec/controllers/autocomplete_controller_spec.rb:370:in `block (4 levels) in <top (required)>'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/30712527
1) Dropdown label input has existing content opens label dropdown with existing my-reaction
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/30712531
1) Dropdown emoji when user loggged in behavior opens when the search bar has my-reaction:
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
2) Dropdown emoji when user loggged in behavior should show loading indicator when opened
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
3) Dropdown emoji when user loggged in behavior should hide loading indicator when loaded
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
4) Dropdown emoji when user loggged in behavior should load all the emojis when opened
Got 1 failure and 1 other error:
4.1) Failure/Error: expect(dropdown_emoji_size).to eq(4)
expected: 4
got: 0
(compared using ==)
# ./spec/features/issues/filtered_search/dropdown_emoji_spec.rb:87:in `block (4 levels) in <top (required)>'
4.2) Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
5) Dropdown emoji when user loggged in behavior shows the most populated emoji at top of dropdown
Got 1 failure and 1 other error:
5.1) Failure/Error: expect(first('#js-dropdown-my-reaction li')).to have_content(award_emoji_star.name)
expected to find text "star" in ""
# ./spec/features/issues/filtered_search/dropdown_emoji_spec.rb:93:in `block (4 levels) in <top (required)>'
5.2) Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
6) Dropdown emoji when user loggged in filtering filters by name
Got 1 failure and 1 other error:
6.1) Failure/Error: expect(dropdown_emoji_size).to eq(1)
expected: 1
got: 0
(compared using ==)
# ./spec/features/issues/filtered_search/dropdown_emoji_spec.rb:106:in `block (4 levels) in <top (required)>'
6.2) Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
7) Dropdown emoji when user loggged in filtering filters by case insensitive name
Got 1 failure and 1 other error:
7.1) Failure/Error: expect(dropdown_emoji_size).to eq(1)
expected: 1
got: 0
(compared using ==)
# ./spec/features/issues/filtered_search/dropdown_emoji_spec.rb:112:in `block (4 levels) in <top (required)>'
7.2) Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
8) Dropdown emoji when user loggged in selecting from dropdown fills in the my-reaction name
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
9) Dropdown emoji when user loggged in input has existing content opens my-reaction dropdown with existing search term
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
10) Dropdown emoji when user loggged in input has existing content opens my-reaction dropdown with existing assignee
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
11) Dropdown emoji when user loggged in input has existing content opens my-reaction dropdown with existing label
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
12) Dropdown emoji when user loggged in input has existing content opens my-reaction dropdown with existing milestone
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
13) Dropdown emoji when user loggged in input has existing content opens my-reaction dropdown with existing my-reaction
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
14) Dropdown emoji when user loggged in caching requests caches requests after the first load
Got 1 failure and 1 other error:
14.1) Failure/Error: expect(initial_size).to be > 0
expected: > 0
got: 0
# ./spec/features/issues/filtered_search/dropdown_emoji_spec.rb:171:in `block (4 levels) in <top (required)>'
14.2) Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/30712506
1) Dropdown assignee input has existing content opens assignee dropdown with existing my-reaction
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/30712521
1) Dropdown hint when user logged in selecting from dropdown with no input opens the emoji dropdown when you click on my-reaction
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
2) Dropdown hint when user logged in selecting from dropdown with some input opens the emoji dropdown when you click on my-reaction
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
3) Dropdown hint when user logged in reselecting from dropdown reuses existing emoji text
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'
https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/30712547
1) Dropdown milestone input has existing content opens milestone dropdown with existing my-reaction
Failure/Error:
emoji_with_count = AwardEmoji
.limit(AWARD_EMOJI_MAX)
.where(user: current_user)
.group(:name)
.order(count: :desc, name: :asc)
.count
ActiveRecord::StatementInvalid:
Mysql2::Error: Unknown column 'award_emoji.count' in 'order clause': SELECT COUNT(*) AS count_all, `award_emoji`.`name` AS award_emoji_name FROM `award_emoji` WHERE `award_emoji`.`user_id` = 2 GROUP BY `award_emoji`.`name` ORDER BY `award_emoji`.`count` DESC, `award_emoji`.`name` ASC LIMIT 100
# ./config/initializers/connection_fix.rb:20:in `execute'
# ./app/controllers/autocomplete_controller.rb:59:in `award_emojis'
# ./lib/gitlab/i18n.rb:46:in `with_locale'
# ./lib/gitlab/i18n.rb:52:in `with_user_locale'
# ./app/controllers/application_controller.rb:326:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:93:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/middleware/go.rb:16:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/request_context.rb:18:in `call'
# ./config/initializers/fix_local_cache_middleware.rb:9:in `call'
# ./lib/gitlab/middleware/static.rb:9:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:36:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# Mysql2::Error:
# Unknown column 'award_emoji.count' in 'order clause'
# ./config/initializers/connection_fix.rb:20:in `execute'