Bug 1962047

A patch that is not yet consulted with upstream, but makes mariadb to compile with openssl 3.x:
https://gitlab.com/redhat/centos-stream/rpms/mariadb/-/merge_requests/4

https://kojihub.stream.rdu2.redhat.com/koji/taskinfo?taskID=271496

An incomplete patch (some tests still fail) merged in git now to unblock the OpenSSL rebuild:
https://gitlab.com/redhat/centos-stream/rpms/mariadb/-/commit/0a14bc58a27d6c396c11c77d1ca6cb06ec8c1d82

The current status is that many tests (mostly from binlog_encryption suite) fail. The fail usually looks similarly to this one:

$> perl ./mysql-test-run.pl --parallel=auto --force --retry=2 --suite-timeout=900 --testcase-timeout=1 --mysqld=--binlog-format=mixed --force-restart --shutdown-timeout=60 --max-test-fail=0 --ssl --suite=binlog_encryption --mem --skip-test-list=unstable-tests

<snipped>

binlog_encryption.rpl_temporal_format_mariadb53_to_mysql56 'mix' w8 [ retry-fail ]  timeout after 60 seconds
        Test ended at 2021-06-17 14:11:01

Test case timeout after 60 seconds

== /home/cloud-user/rpmbuild/BUILD/mariadb-10.5.9/x86_64-redhat-linux-gnu/mysql-test/var/8/log/rpl_temporal_format_mariadb53_to_mysql56.log == 
include/master-slave.inc

 == /home/cloud-user/rpmbuild/BUILD/mariadb-10.5.9/x86_64-redhat-linux-gnu/mysql-test/var/8/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/tmp/YKWP3Bteib/8/mysqld.1.sock' (111)

 == /home/cloud-user/rpmbuild/BUILD/mariadb-10.5.9/x86_64-redhat-linux-gnu/mysql-test/var/8/tmp/analyze-timeout-mysqld.2.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/tmp/YKWP3Bteib/8/mysqld.2.sock' (111)


 - saving '/home/cloud-user/rpmbuild/BUILD/mariadb-10.5.9/x86_64-redhat-linux-gnu/mysql-test/var/8/log/binlog_encryption.rpl_temporal_format_mariadb53_to_mysql56-mix/' to '/home/cloud-user/rpmbuild/BUILD/mariadb-10.5.9/x86_64-redhat-linux-gnu/mysql-test/var/log/binlog_encryption.rpl_temporal_format_mariadb53_to_mysql56-mix/'
***Warnings generated in error logs during shutdown after running tests: binlog_encryption.rpl_temporal_format_mariadb53_to_mysql56

Attempting backtrace. You can use the following information to find out
2021-06-17 14:09:07 8 [ERROR] Replication event checksum verification failed while reading from a log file
2021-06-17 14:09:07 8 [ERROR] Error in Log_event::read_log_event(): 'Replication event checksum verification failed while reading from a log file', data_len: 53, event_type: 4
2021-06-17 14:09:07 7 [ERROR] Slave I/O: Replication event checksum verification failed while reading from network, Internal MariaDB error code: 1743
2021-06-17 14:09:07 7 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
Attempting backtrace. You can use the following information to find out

worker[1] Trying to dump core for [mysqltest - pid: 396562, winpid: 396562]
worker[1] Trying to dump core for [mysqld.1 - pid: 396522, winpid: 396522]
worker[4] Trying to dump core for [mysqltest - pid: 396608, winpid: 396608]
worker[4] Trying to dump core for [mysqld.1 - pid: 396567, winpid: 396567]
worker[1] Trying to dump core for [mysqld.2 - pid: 396524, winpid: 396524]
worker[4] Trying to dump core for [mysqld.2 - pid: 396572, winpid: 396572]

Moving ITM as this is likely not finished in the upcoming week.

Also moving to ASSIGNED to signal clearly that there is still some work to be done (concretely: fix the pieces when server crashes during tests -- see comment #7)