In a project we hit this error while saving/updating a menu link content:
Drupal\Core\Entity\EntityStorageException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: DELETE FROM "babel_source" WHERE hash NOT IN (SELECT DISTINCT hash FROM "babel_source_instance"); Array ( ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 817 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Drupal\Core\Database\StatementWrapperIterator->execute() (Line: 851)
Drupal\Core\Database\Connection->query() (Line: 200)
Drupal\babel\BabelStorage->updateStatusTable() (Line: 99)
Drupal\babel\BabelStorage->delete() (Line: 47)
Drupal\babel_menu_link_content\BabelMenuLinkContentService->updateSourcesForLink() (Line: 47)
Drupal\babel_menu_link_content\Hook\BabelMenuLinkContentHook->updateMenuLinkContent() (Line: 32)
babel_menu_link_content_menu_link_content_update()
call_user_func_array() (Line: 416)
It seems that the SQL statement needs some attention
Active
1.0
Code
This is fixing the error in our project. I think it would be overkill to add a test. Ready to be reviewed