function TransactionTest::testRootTransactionEndCallbackFailureUponDdlAndRollbackForNonTransactionalDdlDatabase

Tests post-transaction rollback failure after a DDL statement.

For database servers that support transactional DDL, a rollback of a transaction including DDL statements is not possible, since a commit happened already. We cannot decide what should be the status of the callback, an exception is thrown.

File

core/tests/Drupal/KernelTests/Core/Database/TransactionTest.php, line 1185

Class

TransactionTest

Tests the transactions, using the explicit ::commitOrRelease method.

Namespace

Code

public function testRootTransactionEndCallbackFailureUponDdlAndRollbackForNonTransactionalDdlDatabase() : void {
  if ($this->connection
    ->supportsTransactionalDDL()) {
    $this->markTestSkipped('This test only works for database that do not support transactional DDL.');
  }
  $transaction = $this->createRootTransaction('', FALSE);
  $this->connection
    ->transactionManager()
    ->addPostTransactionCallback([
    $this,
    'rootTransactionCallback',
  ]);
  $this->insertRow('row');
  $this->assertNull($this->postTransactionCallbackAction);
  // Callbacks are processed only when destructing the transaction.
  // Executing a DDL statement is not sufficient itself.
  // We cannot use truncate here, since it has protective code to fall back
  // to a transactional delete when in transaction. We drop an unrelated
  // table instead.
  $this->connection
    ->schema()
    ->dropTable('test_people');
  $this->assertNull($this->postTransactionCallbackAction);
  $this->assertRowAbsent('rtcCommit');
  $this->assertRowAbsent('rtcRollback');
  $this->assertRowPresent('row');
  set_error_handler(static function (int $errno, string $errstr) : bool {
    throw new \ErrorException($errstr);
  });
  try {
    $transaction->rollBack();
  } catch (\ErrorException $e) {
    $this->assertSame('Transaction::rollBack() failed because of a prior execution of a DDL statement.', $e->getMessage());
  } finally {
    restore_error_handler();
  }
  unset($transaction);
  // The post-transaction callback should now have inserted a 'rtcRollback'
  // row.
  $this->assertSame('rtcRollback', $this->postTransactionCallbackAction);
  $this->assertRowAbsent('rtcCommit');
  $this->assertRowPresent('rtcRollback');
  $manager = $this->connection
    ->transactionManager();
  $this->assertSame(0, $manager->stackDepth());
  $reflectedTransactionState = new \ReflectionMethod($manager, 'getConnectionTransactionState');
  $this->assertSame(ClientConnectionTransactionState::RollbackFailed, $reflectedTransactionState->invoke($manager));
  $this->assertRowPresent('row');
}