Nicolas PHILIPPE

thanks for the reproducer > sorry it took so long no problem :) I'll have a look soon

hello @henryfoster sorry for the delay of my answer 😅 Doctrine does not understand `options: ['DEFERRABLE' => 'INITIALLY DEFERRED']`. Thus, I believe that you've added maunally the statement `DEFERRABLE INITIALLY...

hey @petermanders89 if using MySQL, you should try to declare your migrations as "non transactional". In MySQL, "ALTER TABLE" statements, and all other statements which modify the db structure implicitly...

Hi @morozov here it is: https://github.com/nikophil/dbal-repro you can run it by: - set the DSN of a MySQL connection in `src/create-connection.php` - run `composer install` - run `php ./src/create-deadlock.php` I've...

hey @morozov by any chance, did you check the reproducer I gave? Do you think we can fix this? I'd be willing to provide a PR, but I'd prefer that...

In my understanding, the underlying error (the deadlock) is hidden by the savepoint error, so it's quite hard to reason about the problem.

Yeah that's were I'd like to go :) But what should we do if a save point error occurs? My opinion would be to totally ignore the savepoint error. The...

> If a savepoint error occurs due to a deadlock I'm wondering how this can be achieved, there is no way to know what was the reason why `rollback()` was...

well, it seems that it can't be fixed directly in the DBAL without a BC break 🤔 but maybe this can be mitigated in the callers. In my case, the...

> Should the function isTransactionActive check in the native driver if the transaction is still open? yeah maybe this could be a nice alternative 👍 Another problem with this issue...