Migration is completed but the history recording failed.

[Tigrov]

There are cases when the migration was successful, but writing the history record was failed.

After this, the migration can be rolled back or corrected manually only, since there is no the history record.

Possible solution for a transactional migration run the migration and add the history record in the one transaction.

db-migration/src/Migrator.php

Line 37 in c4daa61

true => $this->db->transaction(fn () => $migration->up($this->createBuilder())),

db-migration/src/Migrator.php

Line 41 in c4daa61

$this->addMigrationToHistory($migration);

[vjik]

It's real case? Under what conditions did this happen?

[Tigrov]

During migration the table prefix was changed using $db->setTablePrefix(), after the migration was completed the prefix_migration history table was not exist.

Actually this is a configuration problem (set migration table without prefix) or a code problem ($db->setTablePrefix()).
But after fixing it I cannot re-run the migration and need to add a record to migration table manually.

[samdark]

Note that MySQL doesn't support transactions for schema changes.