Add transaction_isolation=READ-COMMITTED to MySQL configuration

[RodBruce]

After installing there is a Warning in the Drupal Status Report related to the Database Isolation Level

We have encountered problems related to this. For example, while the thumbnail image for a PDF gets generated by Houdini there is an SQL deadlock error when Drupal tries to update the database so the thumbnail does not get added to the node's media in Drupal.

It looks like there are several different ways to resolve this. The one that I have implemented is to add:
transaction_isolation=READ-COMMITTED
to the [mysqld] section of the file:
/etc/mysql/my.cnf

[dannylamb]

I've also seen bad behaviour where writing to the Drupal cache gets deadlocked. If you're experiencing 'transaction timeout' type errors with Drupal, this will also work. I've been setting it in settings.php with $databases['default']['default']['init_commands'] = ['isolation' => "SET SESSION tx_isolation='READ-COMMITTED'"];

…

On Fri, Jan 13, 2023 at 5:22 PM Rod Bruce ***@***.***> wrote: After installing there is a Warning in the Drupal Status Report related to the *Database Isolation Level* We have encountered problems related to this. For example, while the thumbnail image for a PDF gets generated by Houdini there is an SQL deadlock error when Drupal tries to update the database so the thumbnail does not get added to the node's media in Drupal. It looks like there are several different ways to resolve this. The one that I have implemented is to add: transaction_isolation=READ-COMMITTED to the [mysqld] section of the file: /etc/mysql/my.cnf — Reply to this email directly, view it on GitHub <#250>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AE6PSHZRH5M4DQYGXTL5PC3WSHBQZANCNFSM6AAAAAAT22RU5U> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>