Better caching and indexing of broadcast messages

Closes #31706

See merge request !13429

Include the `is_admin` field in the `GET /users/:id` API when current user is an admin

Closes #36213

See merge request !13501

Make Git revision dropdown style consistent

See merge request !13116

Pending delete projects no longer return 500 error in Admins projects view

Closes #35435

See merge request !13389

Detect and keep track of flaky specs

See merge request !13021

Delete correct key from `session` after authenticating using U2F

Closes #36096

See merge request !13499

Caching of BroadcastMessage instances has been changed so a cache stays
valid as long as the default cache expiration time permits, instead of
the cache being expired after 1 minute. When modifying broadcast
messages the cache is flushed automatically.

To remove the need for performing sequence scans on the
"broadcast_messages" table we also add an index on (starts_at, ends_at,
id), permitting PostgreSQL to use an index scan to get all necessary
data.

Finally this commit adds a few NOT NULL constraints to the table to
match the Rails validations.

Fixes gitlab-org/gitlab-ce#31706

Use a separate table for storing push events

See merge request !12463

Cache Appearance instances in Redis

Closes #36066 and #31698

See merge request !13433

Show error message for API 500 error in tests

Closes #36174

See merge request !13502

Do not run the `ee_compat_check` job for stableish branches

Closes #35131

See merge request !13497

Signed-off-by: Rémy Coutable <remy@rymai.me>

Signed-off-by: Rémy Coutable <remy@rymai.me>

Signed-off-by: Rémy Coutable <remy@rymai.me>

Signed-off-by: Rémy Coutable <remy@rymai.me>

Signed-off-by: Rémy Coutable <remy@rymai.me>

document have_gitlab_http_status

Merge branch '36328-deserializemergerequestdiffsandcommits-fails-due-to-null-too_large-column-9-5-rc1' into 'master'

Fix merge request diff deserialisation when too_large was absent

Closes #36328

See merge request !13500

Enable the RSpec/HookArgument cop and auto-correct offenses

See merge request !13484

Remove an unnecessary `let` in spec/features/projects/user_edits_files_spec.rb

Closes #36308

See merge request !13488

Bumps omniauth-ldap gem version to 2.0.4

Closes #25637

See merge request !13465

Not all diffs in st_diffs had the too_large attribute set at all, but the column
is non-nullable. Explicitly cast to boolean to avoid that problem.

Fix 404 on jobs details page

See merge request !13459

Signed-off-by: Rémy Coutable <remy@rymai.me>

French Translation - Missing "r" in "Fouché" word. It comes from "fourcher" verb.

See merge request !13491

Expose the raw_log method

See merge request !13434

Remove horizontal scroll on collapsed sidebar

Closes #36270

See merge request !13458

Fix minor typos in views

Closes #36317

See merge request !13487

Docs: update user docs index

See merge request !13471

It closes #36308

Closes #36317.

Resolve "Change HA docs to update using EFS as NFS"

Closes #36192

See merge request !13400

RuboCop is _living_ documentation! ✨

[ci skip]