issue when testing with mysql server 9.6.0

See https://github.com/apache/pekko-persistence-jdbc/actions/runs/21298908745

This happens in numerous tests:
java.sql.SQLException: You can't combine write-locking of system tables with other tables or lock types

Doesn't happen with mysql server 9.5.0

Most of the issues happen in tests where we delete messages, eg
```
[info] java.lang.AssertionError: assertion failed: expected DeleteMessagesSuccess(3), found DeleteMessagesFailure(java.sql.SQLException: You can't combine write-locking of system tables with other tables or lock types,3)
```

Start with the linked GitHub Actions run and the tests that delete messages, where DeleteMessagesFailure is reported under MySQL 9.6.0. Compare the 9.6.0 and 9.5.0 test behavior, identify the compatibility issue behind the system-table locking error, and consider the work complete when the affected tests pass on the newer server.

Written by the indexing model from the issue text.