Change record status: 
Project: 
Introduced in branch: 
10.2.x
Introduced in version: 
10.2.0
Description: 

A non-transactional database service is required to deal with "Race conditions with lock/cache using non-database storage"

Example:

    /** @var \Drupal\Core\Database\Connection $connection_nontransactional */
    $connection_nontransactional = \Drupal::service('database.nontransactional');
    $count = count($connection_nontransactional->select('test')
      ->fields('test')
      ->execute()
      ->fetchAllAssoc('name')));
Impacts: 
Module developers
Site templates, recipes and distribution developers