Uploaded image for project: 'Pegasus'
  1. Pegasus
  2. PM-872

pegasus-db-admin upgrade does not work with empty dbversion

XMLWordPrintable

      I had a workflow.db with a missing dbversion table.

      the semantics seem to be wrong.

      corbusier:.pegasus vahi$ sqlite3 workflow.db
      SQLite version 3.8.7.1 2014-10-29 13:59:56
      Enter ".help" for usage hints.
      sqlite> select * from dbversion;

      Above is empty. nothing in the dbversion table.

      now when i ran pegasus-db-admin check on the database

      corbusier:.pegasus vahi$ pegasus-db-admin check sqlite:////Users/vahi/.pegasus/workflow.db
      Created Pegasus database in: sqlite:////Users/vahi/.pegasus/workflow.db
      Your database is compatible with version 4.5.0.

      sqlite> select * from dbversion;
      1|4|1427929900

      However, in this case the master workflow table was never updated. it is missing the new column archived !!!

            Assignee:
            rafsilva Rafael Ferreira Da Silva (Inactive)
            Reporter:
            vahi Karan Vahi
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: