-
Type: Bug
-
Resolution: Fixed
-
Priority: Major
-
Affects Version/s: 4.5.4
-
Component/s: CLI: pegasus-db-admin
-
None
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')