Uploaded image for project: 'Traffic Control'
  1. Traffic Control
  2. TC-126

Seeded data represented as a migration was lost

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0
    • 2.0.0
    • Traffic Ops
    • None

    Description

      The move from 1.8.x (mysql) to 2.0.x (postgres) involved rolling all the changes represented in the migration files into the create_tables.sql file and removing the migration files leaving only migration files that reflect schema changes after 1.8.

      However, some of these migration files included "seed data" or inserts which would not be captured in create_tables.sql.

      For example, the "ANY_MAP" delivery service type was lost as well as job agent and job status entries required for content invalidation.

      Need to go thru each deleted migration file to find seed data and move it to seeds.sql

      Attachments

        Issue Links

          Activity

            People

              mitchell852@apache.org Jeremy Mitchell
              mitchell852@apache.org Jeremy Mitchell
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: