Cache issue after migrate on change database connexion iteration

[gbourgeat]

For multi worspaces usage with one database per workspace, I run a custom command for migrate worskaces databases who use command "doctrine:migration:migrate" in a loop with action to change database connexion between each iteration.

It seem not process change connexion (work for other tasks like other script who called "doctrine:schema:update --force" with changing database connexion between iterate) when have already execute a migration.

Exemple case with 3 worspaces so 3 databases with differente connexion configuration

• If no migration to exec, no problem
• If migration file for create a table exist:
  • migration was executed with sucess on first workspace
  • for 2nd and last, database error with error because table already exist

If I run one more time the script

• 1st: no migrate to execute
• 2nd: 1 migrate to execute and execute it with success
• 3rd: 1 migrate to execute, database error with error because table already exist (but in pgadmin I see that table not exist)

So I should call 3 times the script for passed all migrates.

Change connexion working for check migrate in table "migration_version" but when execute php script migration, execute it on last database connexion who have been migrate executed with success.

I tried to run cache:clear, same doctrine cache clear (metadata and other) before called to migrate command and no change.

Need help for solution thanks