Upgrade from 1.10 to 1.13 directly

Yeti installation and upgrade
1

Hello,

I am reaching out for assistance with an issue I encountered while upgrading Yeti Switch from version 1.10 to version 1.13.

Description of the issue:
I am trying to upgrade the system from version 1.10 to version 1.13. However, during the database migration process, I am encountering errors that prevent the upgrade from completing successfully.

Errors I am facing:

  1. When attempting to add the column "is_shared" to the table "import_gateways", I receive an error stating that the column already exists.
  2. When attempting to add the column "min_dst_number_length" to the table "import_customers_auth", I receive an error stating that the column already exists.
  3. Similarly, when attempting to add the column "max_dst_number_length" to the table "import_customers_auth", I receive an error stating that the column already exists.
  4. Additionally, I encounter the error: ERROR: schema "switch12" does not exist.

Questions:

  1. Is it possible to upgrade directly from version 1.10 to version 1.13?
  2. What steps should I take to resolve the errors mentioned above?
  3. Is it necessary to perform intermediate upgrades (e.g., to version 1.11 or 1.12) before upgrading to version 1.13?

I would greatly appreciate detailed instructions and assistance in resolving this issue.

2

Theoretically it should be possible but nobody tested it in practice. Could you provide raw output of db:migrate command? Usually it failing after first error so it is not clear how you see multiple errors. Have you changed database manually?

3

Error during execution of ./db/migrate/20170822151442_sql_114_and_115.rb
To bypass these errors with columns, I modified the SQL commands in the migration file to include the IF NOT EXISTS clause

No changes in DB

Last error PG::InvalidSchemaName: ERROR: schema “switch12” does not exist

Raw output is too big

4

I am suspecting you are from russia. If you think I am wrong - you could send me proves in DM.