Skip to content

sql-migrate status fails with "Could not create constraint or index" #211

Open

Description

@esetnik
$ go get -v github.com/rubenv/sql-migrate/...@v1.1.1
$ sql-migrate status -env="dev"
mssql: Could not create constraint or index. See previous errors.

How can I see previous errors as nothing else is output in the terminal. Also why is a constraint or index attempting to be created when running the status command?

Activity

  1. esetnik commented on Mar 1, 2022

    @esetnik
    Author

    Relates to #117

  2. esetnik commented on Mar 2, 2022

    @esetnik
    Author

    FYI this is only happening after upgrading to v1.1.0+. v1.0.0 is working fine.

    $ go get -v github.com/rubenv/sql-migrate/...@v1.0.0
    $ sql-migrate status -env="dev"
    Getting migration status
    +-----------------------------------------------------------------------------------------------+-----------------------------------+
    |                                           MIGRATION                                           |              APPLIED              |
    +-----------------------------------------------------------------------------------------------+-----------------------------------+
    ...
    
    
  3. esetnik commented on Dec 19, 2023

    @esetnik
    Author

    I think this is being caused by go-gorp/gorp#450

  4. caioparazzi commented on Mar 28, 2024

    @caioparazzi

    This happens on my stack as well, I have a mssql database set up on a docker container and I'm able to connect my application and create tables through raw queries, however, even after setting up an empty database and running sql-migrate status, I have the constraint error :/

  5. Pompedup commented on Apr 16, 2024

    @Pompedup

    Hello, I reproduce the same issue.

    I try with the last version of sql-migration and it gave me Migration failed: mssql: Could not create constraint or index. See previous errors.

    After downgrading as suggested by @esetnik in 1.0.0, it worked.

    My config:

    development:
      dialect: mssql
      datasource: sqlserver://sa:password@localhost:1433
      dir: migrations
      table: migrations
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions