[Rails5] ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at end of input
Note: add
rails5
to a branch name to trigger rails5 specific CI jobs.
https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/67731995
1) Labels Hierarchy creating boards lists on project boards creates lists from all ancestor labels
Failure/Error:
issues.each do |issue|
issue.move_to_end && issue.save unless issue.relative_position
end
ActiveRecord::StatementInvalid:
PG::SyntaxError: ERROR: syntax error at end of input
LINE 1: ...ST, highest_priority ASC NULLS LAST, id DESC LIMIT 0 OFFSET
^
: SELECT issues.*, (SELECT MIN("label_priorities"."priority") FROM "labels" INNER JOIN "label_links" ON "label_links"."label_id" = "labels"."id" LEFT OUTER JOIN "label_priorities" ON "labels"."id" = "label_priorities"."label_id" WHERE (label_priorities.project_id = issues.project_id) AND (label_links.target_id = issues.id) AND "label_links"."target_type" = 'Issue') AS highest_priority FROM "issues" WHERE ("issues"."state" IN ('opened')) AND "issues"."project_id" = 35 AND (EXISTS (SELECT "label_links".* FROM "label_links" WHERE (label_links.target_type = 'Issue' AND label_links.target_id = issues.id) AND (label_links.label_id = 107) LIMIT 20)) GROUP BY "issues"."id" ORDER BY relative_position ASC NULLS LAST, highest_priority ASC NULLS LAST, id DESC LIMIT 0 OFFSET
# ./app/controllers/boards/issues_controller.rb:55:in `make_sure_position_is_set'
# ./app/controllers/boards/issues_controller.rb:17:in `index'
# ./lib/gitlab/i18n.rb:50:in `with_locale'
# ./lib/gitlab/i18n.rb:56:in `with_user_locale'
# ./app/controllers/application_controller.rb:351:in `set_locale'
# ./lib/gitlab/middleware/multipart.rb:95:in `call'
# ./lib/gitlab/request_profiler/middleware.rb:14:in `call'
# ./lib/gitlab/query_limiting/middleware.rb:17:in `block in call'
# ./lib/gitlab/query_limiting/transaction.rb:37:in `run'
# ./lib/gitlab/query_limiting/middleware.rb:16:in `call'
# ./lib/gitlab/middleware/go.rb:17:in `call'
# ./lib/gitlab/etag_caching/middleware.rb:11:in `call'
# ./lib/gitlab/middleware/read_only/controller.rb:28:in `call'
# ./lib/gitlab/middleware/read_only.rb:16: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_inspector_middleware.rb:31:in `call'
# ./lib/gitlab/testing/request_blocker_middleware.rb:45:in `call'
# ./lib/gitlab/metrics/requests_rack_middleware.rb:27:in `call'
# ------------------
# --- Caused by: ---
# PG::SyntaxError:
# ERROR: syntax error at end of input
# LINE 1: ...ST, highest_priority ASC NULLS LAST, id DESC LIMIT 0 OFFSET
# ^
# ./app/controllers/boards/issues_controller.rb:55:in `make_sure_position_is_set'