We are going to add missing 'user' payload field for ACCESS_DENIED error
which will break current tests. Let rewrite tests to allow adding
new payload fields for this error.

Need for tarantool/tarantool#9108

We are going to add 'name' payload field for every client error. So
we need to tweak more test to handle this.

Need for tarantool/tarantool#9875

After resent update, codespell started to treat assertIn as a typo, and
CI started to fail.

It seems that something has been changed in the package dependencies
and `install` no longer works here without `update`.

Versions of actions/download-artifact before 4.1.7 are vulnerable to
arbitrary file write when downloading and extracting a specifically
crafted artifact that contains path traversal filenames [1].

1. https://github.com/tarantool/tarantool-python/security/dependabot/4

After this patch, current PR pipeline runs will be cancelled if new
commits/force push triggers new pipelines.

Python 3.6 EOL is 2021-12-23 [1]. Current build script no longer
supports Python 3.6 due to `packaging` Python dependency bump.
(And fixing the issue is more than just fixating older `packaging`
version as a dependency.)

https://devguide.python.org/versions/

Pylint 3.3.0 includes a new warning: too-many-positional-arguments [1].
We already ignore a similar too-many-arguments warning in several places
since "fixing" it is backward-incompatible.

1. pylint-dev/pylint#9099

Disabling any new pylint warnings per-entity results in older pylint
failing due to unknown option. Since we support several pylint versions
due to Python version restrictions, we need to support multiple pylint
versions as well.

Any new linter release, including bugfix ones, may result in failing CI.
Since tarantool-python CI is included in several integration pipelines,
such things may block work on repos like tarantool/tarantool and
tarantool/luajit. On the other hand, if CI will start to fail due to a
new linter release, it is unlikely that something user-critical will be
discovered. So for now let's stick to the following approach: one will
bump linters manually from time to time and fix/disable emerging issues.

Bump actions to use ubuntu-24.04 for fixing the following GitHub
warning:

    The Ubuntu 20.04 Actions runner image will begin deprecation
    on 2025-02-01.

Additionally this patch updates test requirements, list of OS
to test, forces `xz` compression type to support older OS versions,
hot-fixes to solve `CMake` 3.5 problem on latest Ubuntu and Debian.

Part of #TNTP-1918