Syntax error or access violation 1305 savepoint level1 does not exist

What steps will reproduce the problem?

create functional test with

class_name: FunctionalTester
modules:
    enabled:
        - Yii2

.codecept/src/Codeception/Lib/Connector/Yii2.php

create backend/tests/functional/CreateUserCest.php used Yii inner browser
https://github.com/bscheshirwork/yii2-app-advanced-rbac/blob/8ab2bfdae8cd30d1b09931aaeb931ce07880b7ab/backend/tests/functional/CreateUserCest.php

create nested transaction (MySQL 5.6.35 | 5.7.17 | 8.0.0)
just like transactional save vendor/dektrium/yii2-user/models/User.php

        $transaction = $this->getDb()->beginTransaction();

        try {
            $this->password = $this->password == null ? Password::generate(8) : $this->password;

            $this->trigger(self::BEFORE_CREATE);

            if (!$this->save()) {
                $transaction->rollBack();
                return false;
            }

            $this->confirm();

            $this->mailer->sendWelcomeMessage($this, null, true);
            $this->trigger(self::AFTER_CREATE);

            $transaction->commit();

            return true;
        } catch (Exception $e) {
            $transaction->rollBack();
            Yii::warning($e->getMessage());
            throw $e;
        }

What is the expected result?

created next _level savepoint / release last _level savepoint

What do you get instead?

execute savepoint
but no execute release
rise error
SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT LEVEL1 does not exist

Additional info

Exaggerating
releaseSavepoint raise error
https://github.com/yiisoft/yii2/blob/master/framework/db/Transaction.php#L137

        $schema = $this->db->getSchema();
        if ($schema->supportsSavepoint()) {
            Yii::trace('Set savepoint ' . $this->_level, __METHOD__);
            $schema->createSavepoint('LEVEL' . $this->_level);
            $schema->releaseSavepoint('LEVEL' . $this->_level);
        } else {
            Yii::info('Transaction not started: nested transaction not supported', __METHOD__);
        }

Data should be cleaned up in two associated tables

I’ll take an example from the textbook, and I’ll make some changes.

    $transaction = $this->connection->beginTransaction();
    try {
        // $this->connection->createCommand()->truncateTable($this->sectionLangTable)->execute();
        // $this->connection->createCommand()->truncateTable($this->sectionTable)->execute();
        $this->connection->createCommand('SET foreign_key_checks = 0')->execute();
        $this->connection->createCommand('DELETE FROM '.$this->sectionLangTable)->execute();
        $this->connection->createCommand('DELETE FROM '.$this->sectionTable)->execute();
        $this->connection->createCommand('ALTER TABLE '.$this->sectionTable.' AUTO_INCREMENT=1')->execute();
        $this->connection->createCommand('SET foreign_key_checks = 1')->execute();
        $transaction->commit();
        return true;
    } catch (Exception $e) {
        $error = $e->getMessage();
        $transaction->rollBack();
        return false;
    }

It ends with the exception.

Syntax error or access violation: 1305 SAVEPOINT LEVEL1 does not exist
The SQL being executed was: RELEASE SAVEPOINT LEVEL1

The exception arises at the time commit or rollback.

First, I tried what was buried, too.

The Google mostly results from the Codeception and its configurations.
Then there’s talk about not keeping mysql intact.

But according to the logs, there’s one transaction.

2018-02-27 12:04:05 [-][-][-][trace][yiibaseApplication::bootstrap] Bootstrap with yiilogDispatcher
2018-02-27 12:04:05 [-][-][-][trace][yiibaseModule::getModule] Loading module: gii
2018-02-27 12:04:05 [-][-][-][trace][yiibaseApplication::bootstrap] Bootstrap with yiigiiModule::bootstrap()
2018-02-27 12:04:05 [-][-][-][trace][yiibaseController::runAction] Route to run: migrate/up
2018-02-27 12:04:05 [-][-][-][trace][yiibaseInlineAction::runWithParams] Running action: yiiconsolecontrollersMigrateController::actionUp()
2018-02-27 12:04:05 [-][-][-][trace][yiidbTransaction::begin] Begin transaction
2018-02-27 12:04:05 [-][-][-][trace][yiidbTransaction::begin] Set savepoint 1
in D:wwwedusiteshtdocscommoncomponentssitemaprepositorySitemapRepository.php:156
in D:wwwedusiteshtdocsconsolecomponentsmigrationhandlersInitialInfoHandler.php:32
in D:wwwedusiteshtdocsconsolemigrationsdatam180214_092839_menu_initial.php:18
2018-02-27 12:04:05 [-][-][-][trace][yiidbTransaction::commit] Release savepoint 1
in D:wwwedusiteshtdocscommoncomponentssitemaprepositorySitemapRepository.php:165
in D:wwwedusiteshtdocsconsolecomponentsmigrationhandlersInitialInfoHandler.php:32
in D:wwwedusiteshtdocsconsolemigrationsdatam180214_092839_menu_initial.php:18
2018-02-27 12:04:05 [-][-][-][trace][yiidbTransaction::rollBack] Roll back transaction
in D:wwwedusiteshtdocscommoncomponentssitemaprepositorySitemapRepository.php:170
in D:wwwedusiteshtdocsconsolecomponentsmigrationhandlersInitialInfoHandler.php:32
in D:wwwedusiteshtdocsconsolemigrationsdatam180214_092839_menu_initial.php:18


The data from the tables are still clean.

Please help.

P.S. While rereading the post, he saw that there was no word LEVEL in the slogan and there was an exception. It might be a problem, but it’s kind of weird.

P.S.2 is the same, but instead of removal, insert works well.

2018-02-27 12:24:51 [-][-][-][trace][yiibaseApplication::bootstrap] Bootstrap with yiilogDispatcher
2018-02-27 12:24:51 [-][-][-][trace][yiibaseModule::getModule] Loading module: gii
2018-02-27 12:24:51 [-][-][-][trace][yiibaseApplication::bootstrap] Bootstrap with yiigiiModule::bootstrap()
2018-02-27 12:24:51 [-][-][-][trace][yiibaseController::runAction] Route to run: migrate/up
2018-02-27 12:24:51 [-][-][-][trace][yiibaseInlineAction::runWithParams] Running action: yiiconsolecontrollersMigrateController::actionUp()
2018-02-27 12:24:52 [-][-][-][trace][yiidbTransaction::begin] Begin transaction
2018-02-27 12:24:52 [-][-][-][trace][yiidbTransaction::begin] Set savepoint 1
in D:wwwedusiteshtdocscommoncomponentssitemaprepositorySitemapRepository.php:155
in D:wwwedusiteshtdocsconsolecomponentsmigrationhandlersInitialInfoHandler.php:32
in D:wwwedusiteshtdocsconsolemigrationsdatam180214_092839_menu_initial.php:18
2018-02-27 12:24:52 [-][-][-][trace][yiidbTransaction::commit] Release savepoint 1
in D:wwwedusiteshtdocscommoncomponentssitemaprepositorySitemapRepository.php:165
in D:wwwedusiteshtdocsconsolecomponentsmigrationhandlersInitialInfoHandler.php:32
in D:wwwedusiteshtdocsconsolemigrationsdatam180214_092839_menu_initial.php:18
2018-02-27 12:24:52 [-][-][-][trace][yiidbTransaction::commit] Commit transaction