[10.5.x] test DB transaction isolation set to read-committed breaks tests

HEAD is broken due to 🐛 Set default transaction isolation level to READ-COMMITTED in MySQL/MariaDB Active

I think this is the issue to resolve it.

Yes it needs to fix

    Installer Isolation Level Existing Settings (Drupal\Tests\mysql\Functional\InstallerIsolationLevelExistingSettings)
     ✘ Installer
       ┐
       ├ Failed asserting that two strings are equal.
       ┊ ---·Expected
       ┊ +++·Actual
       ┊ @@ @@
       ┊ -'REPEATABLE-READ'
       ┊ +'READ-COMMITTED'
       │
       │ /builds/issue/drupal-3539366/core/modules/mysql/tests/src/Functional/InstallerIsolationLevelExistingSettingsTest.php:58
       ┴

better title for https://git.drupalcode.org/project/drupal/-/blob/11.x/core/modules/mysql...

Replaced comparison with session vs global isolation level

dimitriskr → changed the visibility of the branch 3539366-11.x-tx-isolation-mysql to hidden.

dimitriskr → changed the visibility of the branch 3539366-10.5.x-tx-isolation-mysql to hidden.

I think it's fine for me to RTBC !13038 as not an author

Moreover it needs backport to 10.x

This is affecting MRs now https://git.drupalcode.org/issue/drupal-3015152/-/jobs/6259156

mondrake → changed the visibility of the branch 3539366-fix-tx-isolation to hidden.