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

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

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:
            rafsilva Rafael Ferreira Da Silva (Inactive)
            Reporter:
            vahi Karan Vahi
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: