pegasus-db-admin 4.5.4 gives a stack trace when run on pegasus 4.6 workflow submit dir

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

      here is what we get in pegasus-analyzer

      pegasus-analyzer .
      2016-01-26 08:19:49,199:ERROR:pegasus-analyzer(1051): Failed to load the database.sqlite:////lfs1/work/monitord/bugs/PM-1039/20160125T152725-0800/blackdiamond-0.stampede.db
      2016-01-26 08:19:49,208:WARNING:pegasus-analyzer(1052): Traceback (most recent call last):
      File "/lfs1/software/install/pegasus/pegasus-4.5.4cvs/bin/pegasus-analyzer", line 1048, in analyze_db
      workflow_stats = stampede_statistics.StampedeStatistics(output_db_url, False)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/python/Pegasus/db/workflow/stampede_statistics.py", line 171, in _init_
      SQLAlchemyInit._init_(self, connString)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/python/Pegasus/db/modules/_init.py", line 39, in __init_
      self.session = connection.connect(dburi, create=True, props=props, db_type=db_type)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/python/Pegasus/db/connection.py", line 92, in connect
      db_create(dburi, engine, db, pegasus_version=pegasus_version, force=force)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/python/Pegasus/db/admin/admin_loader.py", line 67, in db_create
      v = _discover_version(db, pegasus_version=pegasus_version, force=force, verbose=False)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/python/Pegasus/db/admin/admin_loader.py", line 212, in _discover_version
      _update_version(db, i)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/python/Pegasus/db/admin/admin_loader.py", line 231, in _update_version
      db.commit()
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/scoping.py", line 149, in do
      return getattr(self.registry(), name)(*args, **kwargs)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/session.py", line 719, in commit
      self.transaction.commit()
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/session.py", line 352, in commit
      self._prepare_impl()
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/session.py", line 332, in _prepare_impl
      self.session.flush()
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/session.py", line 1814, in flush
      self._flush(objects)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/session.py", line 1896, in _flush
      flush_context.execute()
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/unitofwork.py", line 372, in execute
      rec.execute(self)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/unitofwork.py", line 525, in execute
      uow
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/persistence.py", line 63, in save_obj
      table, insert)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/orm/persistence.py", line 565, in _emit_insert_statements
      execute(statement, params)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/engine/base.py", line 664, in execute
      params)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/engine/base.py", line 764, in _execute_clauseelement
      compiled_sql, distilled_params
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/engine/base.py", line 878, in _execute_context
      context)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/engine/base.py", line 871, in _execute_context
      context)
      File "/Volumes/Work/lfs1/software/install/pegasus/pegasus-4.5.4cvs/lib/pegasus/externals/python/sqlalchemy/engine/default.py", line 320, in do_execute
      cursor.execute(statement, parameters)
      IntegrityError: (IntegrityError) NOT NULL constraint failed: dbversion.version u'INSERT INTO dbversion (version_number, version_timestamp) VALUES (?, ?)' (5, '1453825189')

            Assignee:
            Rafael Ferreira Da Silva [X] (Inactive)
            Reporter:
            Karan Vahi
            Archiver:
            Rajiv Mayani

              Created:
              Updated:
              Resolved:
              Archived: