QA » openQA Project » openQA Tests

Do you think this ticket needs to be regarded with "High" prio though? The issue I have seen and reported in https://bugzilla.suse.com/show_bug.cgi?id=1165151#c15 is that we already have good integration tests but the post_fail_hook is not providing specific log files. "More tests!" isn't always the best solution ;)

Just keep in mind that we already have multiple test modules with "mysql" in name where for recent versions of SLE/openSUSE "mysql" is a backward-compatible alias for "mariadb":

$ git ls-files | grep mysql
data/console/test_mysql_connector.php
tests/console/mysql_odbc.pm
tests/console/mysql_srv.pm
tests/console/php7_mysql.pm

Maybe it's about time to rename these test modules and change to install mariadb directly instead of mysql.

yeah, sorry I was way too fast with this, didn't check anything before. thanks for closing

Mariadb can take a long time when plugins are enabled (rocksdb)

(493/606) Installing: mariadb-10.4.12-3.2.x86_64 .................................................................................................................[done]                                                                     
Additional rpm output:                                                                                                                                                                                                                       
usermod: no changes                                                                                                                                                                                                                          
Job for mariadb.service failed because a timeout was exceeded.                                                                                                                                                                               
See "systemctl  status mariadb.service" and "journalctl  -xe" for details.

INSTALL SONAME 'ha_rocksdb';

May 14 11:44:30 localhost.localdomain mysql-systemd-helper[5617]: mysql.time_zone_transition_type                    OK
May 14 11:44:30 localhost.localdomain mysql-systemd-helper[5617]: mysql.transaction_registry                         OK
May 14 11:44:30 localhost.localdomain mysql-systemd-helper[5617]: Phase 2/7: Installing used storage engines... Skipped
May 14 11:44:30 localhost.localdomain mysql-systemd-helper[5617]: Phase 3/7: Fixing views
May 14 11:44:30 localhost.localdomain mysql-systemd-helper[5617]: mysql.user                                         OK
May 14 11:44:30 localhost.localdomain mysql-systemd-helper[5617]: Phase 4/7: Running 'mysql_fix_privilege_tables'
May 14 11:49:23 localhost.localdomain systemd[1]: mariadb.service: Start-pre operation timed out. Terminating.
May 14 11:49:23 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
May 14 11:49:23 localhost.localdomain systemd[1]: mariadb.service: Unit entered failed state.
May 14 11:49:23 localhost.localdomain systemd[1]: mariadb.service: Failed with result 'timeout'.

So possibly testing with oqgraph and rocksdb plugins should be also done (including migration)

In Mariadb 10.5
The S3 storage engine allows one to archive MariaDB tables in Amazon S3, or any third-party public or private cloud that implements S3 API ( MDEV-22606)

We mainly cover Mariadb in two places:

tests/console/mysql_odbc
tests/console/mysql_srv

https://openqa.suse.de/tests/overview?arch=&machine=&modules=mysql_srv&distri=sle&version=15-SP3&build=183.1&groupid=110
https://github.com/os-autoinst/os-autoinst-distri-opensuse/search?p=3&q=console%2F%2Amysql

There's coverage and usage within other modules, including PHP7, I would first target the mariadb stuff directly and then after that's done, improve the coverage of php7 to match the testing done over the CLI