Add testing wtih Maria DB 10.6

Second commit can be removed after testing of the image

image pushed so removing testing commit and using new image https://git.drupalcode.org/project/drupalci_environments/-/jobs/808648

maybe the new job should be added to daily ones?

Reviewed 6586, had test failures.

It was testing MR

Tests are green for 10.6

Committed/pushed to 11.x and cherry-picked to 10.2.x, thanks!

Removing the 'major version only' tag because it's fine to test with this combination on 10.x too.

MariaDB 10.6: https://git.drupalcode.org/issue/drupal-2015121/-/pipelines/95023
MySQL 8: https://git.drupalcode.org/issue/drupal-2015121/-/pipelines/95019

There's something going on with Drupal\FunctionalTests\Bootstrap\UncaughtExceptionTest test

Those look like real failures. Reverted from both branches.

Well, after the 3rd consecutive retry, the previously failed test passed.. Random? Connected with infrastructure issues?
https://git.drupalcode.org/issue/drupal-2015121/-/jobs/818007

@dimitriskr maybe we should revert https://git.drupalcode.org/project/drupalci_environments/-/commit/fc58a0...

I ran again the jobs and got the same error as before

Original phpunit error: https://git.drupalcode.org/issue/drupal-2015121/-/jobs/817769
Latest phpunit error: https://git.drupalcode.org/issue/drupal-2015121/-/jobs/918319

I re-ran the job only once (comparing to last time which passed at the 4th try) and it passed. Upon checking the browser output, I noticed it throwed different exception for the same reason. Is it something in the mysql driver?

Failing:

PDOException: SQLSTATE[HY000] [1698] Access denied for user 'cij44wcj6ozuljp5'@'127.0.0.1' in Drupal\Component\DependencyInjection\PhpArrayContainer->createService() (line 79 of /builds/issue/drupal-2015121/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php).

Drupal\Component\DependencyInjection\PhpArrayContainer->createService(Array, 'database') (Line: 177)
Drupal\Component\DependencyInjection\Container->get('database', 1) (Line: 219)
Drupal\Component\DependencyInjection\PhpArrayContainer->resolveServicesAndParameters(Array) (Line: 62)
Drupal\Component\DependencyInjection\PhpArrayContainer->createService(Array, 'cache.container') (Line: 177)
Drupal\Component\DependencyInjection\Container->get('cache.container') (Line: 574)
Drupal\Core\DrupalKernel->getCachedContainerDefinition() (Line: 960)
Drupal\Core\DrupalKernel->initializeContainer() (Line: 514)
Drupal\Core\DrupalKernel->boot() (Line: 734)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)

Passing:

Drupal\Core\Database\DatabaseAccessDeniedException: SQLSTATE[HY000] [1045] Access denied for user 'w7oihw6z5qupbfy5'@'127.0.0.1' (using password: YES) in Drupal\mysql\Driver\Database\mysql\Connection::open() (line 207 of /builds/issue/drupal-2015121/core/modules/mysql/src/Driver/Database/mysql/Connection.php).

Drupal\mysql\Driver\Database\mysql\Connection::open(Array) (Line: 460)
Drupal\Core\Database\Database::openConnection('default', 'default') (Line: 191)
Drupal\Core\Database\Database::getConnection('default')
call_user_func_array('Drupal\Core\Database\Database::getConnection', Array) (Line: 79)
Drupal\Component\DependencyInjection\PhpArrayContainer->createService(Array, 'database') (Line: 177)
Drupal\Component\DependencyInjection\Container->get('database', 1) (Line: 219)
Drupal\Component\DependencyInjection\PhpArrayContainer->resolveServicesAndParameters(Array) (Line: 62)
Drupal\Component\DependencyInjection\PhpArrayContainer->createService(Array, 'cache.container') (Line: 177)
Drupal\Component\DependencyInjection\Container->get('cache.container') (Line: 574)
Drupal\Core\DrupalKernel->getCachedContainerDefinition() (Line: 960)
Drupal\Core\DrupalKernel->initializeContainer() (Line: 514)
Drupal\Core\DrupalKernel->boot() (Line: 734)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)

What's the status of #3401846: Add supported mariadb container images - are we missing something that was fixed in there maybe?

The differences in my.cnf is that #3401846: Add supported mariadb container images has extra transaction_isolation = READ-COMMITTED and innodb_thread_concurrency = 0, while the committed my.cnf only has innodb_use_native_aio = 0

Yeah it looks fine to me too :)

We'll need another 11.x-specific issue to remove environments on the older database versions.

Committed f1515fb and pushed to 11.x. Thanks!

Didn't backport cleanly to 10.3 and I don;t think we need it there as long as we have in 11.x