Prepare upload to MariaDB 10.11.9 to Ubuntu 24.04 "Noble"

Similar to !106 (merged), !85 (merged), !93 (merged), !69 (merged) and !59 (merged), this Merge Request contains the import of a new upstream version of MariaDB.

Do not review merge commits or upstream commits, but focus on the ones that are made only on the proposed ubuntu/24.04-noble branch update in this MR:

git log --first-parent --reverse --format='format:* %C(yellow)%h%C(reset) %s' origin/ubuntu/24.04-noble...

• d854be42 Update changelog and refresh patches after 10.11.11 import
• 733e5b54 Update mariadb-client.NEWS to match final version in Debian unstable
• caca4491 Add some info on getting back to passwordless root (Closes: #1088133)
• 6e6fd63c Skip test main.mysqld--help-aria due to MDEV-34733
• 3afc27e3 Update configuration traces to match changes done in MDEV-35785
• 509152ff Update configuration traces with new query allocator values from MDEV-35750
• 172c7d3f Set CAP_IPC_LOCK capability if possible
• 1505bb18 MDEV-35907 debian-start script fails when using non-standard socket path
• 090b7209 When shutting down 'mariadbd', fallback to 'mysqld'
• fc2c7ba8 Update changelog for 1:10.11.11-0ubuntu0.24.04.1 release
• 1066bd3f Apply wrap-and-sort -va with latest devscripts 2.24.8
• 4a8251d3 Make d/watch more specific to circumvent bug in .10 vs .11 detection
• 575ffcaf Update changelog and refresh patches after 10.11.11 import
• 8e042042 Update mariadb-client.NEWS to match final version in Debian unstable
• fb4a7762 Add some info on getting back to passwordless root (Closes: #1088133)
• 11e61c72 Skip test main.mysqld--help-aria due to MDEV-34733
• 4f91bca7 Update configuration traces to match changes done in MDEV-35785
• 7d3920e5 Update configuration traces with new query allocator values from MDEV-35750
• 3cdd8bec Set CAP_IPC_LOCK capability if possible
• 6d0f1a6d MDEV-35907 debian-start script fails when using non-standard socket path
• 9db225d0 When shutting down 'mariadbd', fallback to 'mysqld'
• 6c2f9ca1 Make d/watch more specific to circumvent bug in .10 vs .11 detection
• eb5bdf71 Apply wrap-and-sort -va with latest devscripts 2.24.8
• aeee72da Add Lintian overrides for new issues that are not relevant for maintenance
• 5212ec2d Update server trace to include new parameter 'quick-max-column-width'
• 1fe3e4d3 Update server trace to include new parameters and values
• d5cc1739 Reverse backticks change in commit 0300a915 (LP: #2085554)
• 6fb023d1 Salsa CI: Use minimal Ubuntu pipeline for Ubuntu stable release updates
• bfc1cc1d Update changelog for 1:10.11.11-0ubuntu0.24.04.1 release

Changelog:

mariadb (1:10.11.11-0ubuntu0.24.04.1) noble-security; urgency=medium

[ Otto Kekäläinen ]
* SECURITY UPDATE: New upstream version 10.11.11. Includes fixes for several defects
  as noted at https://mariadb.com/kb/en/mariadb-10-11-11-release-notes/ as
  well the following security issues (LP: #2099785):
  - CVE-2025-21490
* This release includes upstream version 10.11.10, with fixes for regressions
  as noted at https://mariadb.com/kb/en/mariadb-10-11-10-release-notes/
* This release includes upstream version 10.11.9, with fixes for regressions
  as noted at https://mariadb.com/kb/en/mariadb-10-11-9-release-notes/
* Update server trace to include new parameters and values
* Add main.having_cond_pushdown to MTR skiplist on s390x
* Skip test main.mysqld--help-aria due to MDEV-34733
* Update configuration traces to match changes done in MDEV-35785
* Update configuration traces with new query allocator values from MDEV-35750
* Update server trace to include new parameter 'quick-max-column-width'
* Include Debian packaging bugfixes done upstream:
  - MDEV-35907: debian-start script fails when using non-standard socket path
  - Set CAP_IPC_LOCK capability if possible
* Include several restart/shutdown related fixes that have been in Debian
  unstable in MariaDB 11.4 for a long time, and which are likely needed to
  avoid occasional shutdown issues, in particular on upgrades (LP: #2034125)
  in both Debian and Ubuntu
  - Make SysV init more verbose in case of MariaDB start failures (Related: #1033234)
  - Limit check of running mysqld/mariadbd to system users (Related: #1032047)
  - When shutting down 'mariadbd', fallback to 'mysqld'
* Make d/watch more specific to circumvent bug in .10 vs .11 detection
* Add Lintian overrides for new upstream documentation JavaScript files
* Apply `wrap-and-sort -va` with latest devscripts 2.24.8
* Add NEWS item to explain new `mariadb-dump` option `--sandbox`

[ Phil Dibowitz ]
* Add some info on getting back to passwordless root (Related: #1088133)

[ Joe Bliss ]
* Revert backticks change in commit 0300a915 to be compatible with databases
  containing hyphenated table names (LP: #2085554)

 -- Otto Kekäläinen <otto@debian.org>  Sat, 22 Feb 2025 19:33:49 -0800

Test builds visible at https://launchpad.net/~mysql-ubuntu/+archive/ubuntu/mariadb/+builds?build_text=&build_state=all

Unfortunately riscv64 is failing on unclear reason:

[ 21%] Building C object mysys/CMakeFiles/mysys.dir/lf_dynarray.c.o
cd /<<PKGBUILDDIR>>/builddir/mysys && /usr/bin/cc -DHAVE_CONFIG_H -D_FILE_OFFSET_BITS=64 -I/<<PKGBUILDDIR>>/wsrep-lib/include -I/<<PKGBUILDDIR>>/wsrep-lib/wsrep-API/v26 -I/<<PKGBUILDDIR>>/builddir/include -I/<<PKGBUILDDIR>>/include/providers -I/<<PKGBUILDDIR>>/include -I/<<PKGBUILDDIR>>/mysys -g -O2 -fno-omit-frame-pointer -ffile-prefix-map=/<<PKGBUILDDIR>>=. -fstack-protector-strong -Wformat -Werror=format-security -fno-stack-clash-protection -fdebug-prefix-map=/<<PKGBUILDDIR>>=/usr/src/mariadb-1:10.11.11-0ubuntu0.24.04.1~bpo24.04.1~1740347493.46fa5fabeb2+ubuntu.24.04.noble -Wdate-time -D_FORTIFY_SOURCE=3 -Wdate-time -D_FORTIFY_SOURCE=3 -pie -fPIC -fstack-protector --param=ssp-buffer-size=4 -O3 -g -DNDEBUG -g -fno-omit-frame-pointer -fno-strict-aliasing  -Wno-uninitialized -fno-omit-frame-pointer -DDBUG_OFF -Wall -Wdeclaration-after-statement -Wenum-compare -Wenum-conversion -Wextra -Wformat-security -Wmissing-braces -Wno-format-truncation -Wno-init-self -Wno-nonnull-compare -Wno-unused-parameter -Wvla -Wwrite-strings -std=gnu99   -Wdate-time -D_FORTIFY_SOURCE=3 -fPIC -MD -MT mysys/CMakeFiles/mysys.dir/lf_dynarray.c.o -MF CMakeFiles/mysys.dir/lf_dynarray.c.o.d -o CMakeFiles/mysys.dir/lf_dynarray.c.o -c /<<PKGBUILDDIR>>/mysys/lf_dynarray.c
/tmp/ccVzJkOE.s: Assembler messages:
/tmp/ccVzJkOE.s:265: Error: unrecognized opcode `pause', extension `zihintpause' required
/tmp/ccVzJkOE.s:1168: Error: unrecognized opcode `pause', extension `zihintpause' required
make[4]: *** [mysys/CMakeFiles/mysys.dir/build.make:1367: mysys/CMakeFiles/mysys.dir/lf_alloc-pin.c.o] Error 1