Migrations DOWN (Symfony 7.2)

[mathiasstocker]

It seems that the sensor for migrations does not work correctly in some cases (Project with PHP 8.3 and Symfony 7.2):

php8.3 bin/console doctrine:migrations:list

+------------------------------------------+----------+---------------------+----------------+-------------+
| Migration Versions                                                                         |             |
+------------------------------------------+----------+---------------------+----------------+-------------+
| Migration                                | Status   | Migrated At         | Execution Time | Description |
+------------------------------------------+----------+---------------------+----------------+-------------+
| DoctrineMigrations\Version20230313083031 | migrated | 2023-03-30 10:08:30 | 0.034s         |             |
| DoctrineMigrations\Version20230316082648 | migrated | 2023-03-30 10:08:30 | 0.002s         |             |
| DoctrineMigrations\Version20230322153006 | migrated | 2023-03-30 10:08:30 | 0.001s         |             |
+------------------------------------------+----------+---------------------+----------------+-------------+

Health endpoint output:

doctrine-migrations: {
    status: "DOWN",
    details: {
        executed: 0,
        executed unavailable: 0,
        available: 3,
        new: 3
},
error: "Not all migrations were executed"

[mathiasstocker]

MetaDataStorage::isInitialized is false:

[Doctrine\Migrations\Metadata\Storage\TableMetadataStorage](file:///home/mastocker/Code/UB/access/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.php#L38) {#647 ▼
  -isInitialized: false
  -schemaUpToDate: false
  -schemaManager: 
Doctrine\DBAL\Schema
\
PostgreSQLSchemaManager {#707 ▶}
  -platform: 
Doctrine\DBAL\Platforms
\
PostgreSQL120Platform {[#704 ▶](https://localhost:8000/_actuator/health#sf-dump-1729093748-ref2704)}
  -configuration: 
Doctrine\Migrations\Metadata\Storage
\
TableMetadataStorageConfiguration {#637 ▶}
  -connection: 
Doctrine\DBAL
\
Connection {[#626 ▶](https://localhost:8000/_actuator/health#sf-dump-1729093748-ref2626)}
  -comparator: 
Doctrine\Migrations\Version
\
AlphabeticalComparator {#705}
  -migrationRepository: 
Doctrine\Migrations
\
FilesystemMigrationsRepository {#706 ▶}
}

But the MetaDataStorage is initialized and MetaDataStorage::ensureInitialized() throws an exception when executed at this point:

An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "doctrine_migration_versions" already exists

[mathiasstocker]

See https://github.com/mathiasstocker/symsensor-migrations-bug on how to reproduce the bug.

[kreemer]

Tested with version doctrine-migrations-bundle 3.4.1 and works from my side
see https://github.com/doctrine/DoctrineMigrationsBundle/releases/tag/3.4.1