Troubleshooting postgres issues with hook_node_grants + workbench moderation

I am getting this exact same issue as well, whenever trying to add a content type. Seems to be consistent with postgres environments.

Edited see https://www.drupal.org/node/2848345#comment-12254271

Edited see https://www.drupal.org/node/2848345#comment-12254271

Edited see https://www.drupal.org/node/2848345#comment-12254271

Edited see https://www.drupal.org/node/2848345#comment-12254271

Same here. Drupal 8.3.7, PostgreSQL 9.6

Reproduction Steps

1) Install Drupal (v8.3.5+)
2) Install Workbench Moderation (v1.2)
3) Add just the following hook which can be empty:

use Drupal\Core\Session\AccountInterface;
function modulename_node_grants(AccountInterface $account, $op) {
}

Now whenever I run a behat test or even a migration import on a postgres db I always get "mimic_implicit_commit". I did manage to fix the migration issues by just disabling all workbench moderation hooks via migrate booster.

Migrate Booster

$config['migrate_booster.settings']['hooks'] = [
  # Entity insert
  'entity_insert' => [
    'workbench_moderation',
  ],
  # Entity update
  'entity_update' => [
    'workbench_moderation',
  ],
  # Entity presave
  'entity_presave' => ['workbench_moderation'],
];

Behat

  @breadcrumb @javascript
  Scenario: User leveraging the breadcrumbs to navigate to landing page content type
    Given I am logged in as a user with the "administrator" role
    And landing_page content:                                                        # Drupal\DrupalExtension\Context\DrupalContext::createNodes()
      | title  | path    | moderation_state |
      | Foobar | /foobar | published       |
      Drupal\Core\Database\TransactionNameNonUniqueException: mimic_implicit_commit is already in use. in /var/www/html/core/lib/Drupal/Core/Database/Connection.php:1147

This simple Behat test highlights the `mimic_implicit_commit` issue I am having on postgreSQL databases. The full stack trace is attached as a subsequent file upload.

I also should note that content moderation (in Drupal core) also has this same problem.