Symfony 4.4 - Postgresql 9.6 doctrine migrating down error SQLSTATE[42P06]:

Question

I can't migrating down with commande line php bin/console doctrine:migrations:migrate DoctrineMigrations\Version20220713135119

PS C:\_EnvTest\my_project_composer2> php bin/console doctrine:migrations:migrate  DoctrineMigrations\Version20220713135119     

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

[notice] Migrating down to DoctrineMigrations\Version20220713135119
[error] Migration DoctrineMigrations\Version20220718131542 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[42P06]: Duplicate schema: 7 ERROR:  le schema « public » already exist"

In ExceptionConverter.php line 91:

  An exception occurred while executing a query: SQLSTATE[42P06]: Duplicate schema: 7 ERROR:  schema « public » already exist


In Exception.php line 30:

  SQLSTATE[42P06]: Duplicate schema: 7 ERROR:  le schema « public » already exist  


In Connection.php line 72:

  SQLSTATE[42P06]: Duplicate schema: 7 ERROR:  le schema « public » already exist

My migration :

        $this->addSql('CREATE SCHEMA public');
        $this->addSql('ALTER TABLE option_property DROP CONSTRAINT FK_AB856D7AA7C41D6F');
        $this->addSql('DROP SEQUENCE option_id_seq CASCADE');
        $this->addSql('DROP TABLE option');
        $this->addSql('DROP TABLE option_property');

Please share more details. CREATE SCHEMA does not look like something from a DOWN migration — Nico Haase
– Nico Haase, Commented Jul 18, 2022 at 15:28

buddemat · Accepted Answer · 2022-07-19 21:40:16Z

1

I just commented :

$this->addSql('CREATE SCHEMA public');

And run the command again and it seems to work.

github.com/doctrine/migrations/issues/494

edited Jul 19, 2022 at 21:40

buddemat

5,33016 gold badges37 silver badges61 bronze badges

answered Jul 18, 2022 at 15:31

Manon

6610 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vinceAmstoutz Over a year ago

Ok then please close your question! -

Collectives™ on Stack Overflow

Symfony 4.4 - Postgresql 9.6 doctrine migrating down error SQLSTATE[42P06]:

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related