error after database restore

[jpnielsen]

Hi,

I tried doing a restore to a PartDB 2.2.1
from a backup done on a 2.0.2 (master/a6be786)

jpn@ubuntu-server:/var/www/partdb$ sudo -u www-data php bin/console cache:clear

 // Clearing the cache for the prod environment with debug false

 [OK] Cache for the "prod" environment (debug=false) was successfully cleared.

jpn@ubuntu-server:/var/www/partdb$ sudo -u www-data php bin/console doctrine:migrations:up-to-date

 [ERROR] Out-of-date! 1 migration is available to execute.

jpn@ubuntu-server:/var/www/partdb$ sudo -u www-data php bin/console doctrine:migrations:migrate

 WARNING! You are about to execute a migration in database "partdb" that could result in schema changes and data loss. Are y                               ou sure you wish to continue? (yes/no) [yes]:
 > yes

[notice] Migrating up to DoctrineMigrations\Version20250813214628
[error] Migration DoctrineMigrations\Version20250802205143 failed during Execution. Error: "An exception occurred while exec                               uting a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'bulk_info_provider_import_jobs' already exist                               s"
22:49:28 CRITICAL  [console] Error thrown while running command "doctrine:migrations:migrate". Message: "An exception occurr                               ed while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'bulk_info_provider_import_jobs'                                already exists" ["exception" => Doctrine\DBAL\Exception\TableExistsException^ { …},"command" => "doctrine:migrations:migrate                               ","message" => "An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Tabl                               e 'bulk_info_provider_import_jobs' already exists"] ["token" => null,"command" => ["name" => "doctrine:migrations:migrate","                               arguments" => ["command" => "doctrine:migrations:migrate","version" => "latest"]]]

In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'bulk_inf
  o_provider_import_jobs' already exists

In Exception.php line 24:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'bulk_info_provider_import_jobs' already exists

In Connection.php line 57:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'bulk_info_provider_import_jobs' already exists

doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [A                               LL-OR-NOTHING]] [--no-all-or-nothing] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]

How to proceed ?

[jpnielsen]

#1107