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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.5.4
    • Fix Version/s: master, 4.6.0, 4.5.4
    • Component/s: pegasus-db-admin
    • Labels:
      None

      Description

      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')

        Attachments

          Activity

            People

            • Assignee:
              rafsilva Rafael Ferreira da Silva
              Reporter:
              vahi Karan Vahi
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: