The cron script on batcave01 that runs:
Cron apache@batcave01 cd /srv/web/repo/json && /usr/bin/python /srv/web/infra/ansible/roles/repo2json/files/rhel_to_json.py > /dev/null
it failing (not sure for how long). The traceback is:
Traceback (most recent call last): File "/srv/web/infra/ansible/roles/repo2json/files/rhel_to_json.py", line 238, in <module> main() File "/srv/web/infra/ansible/roles/repo2json/files/rhel_to_json.py", line 195, in main for pkg in session.query(Package).all(): File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2320, in all return list(self) File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2438, in iter return self._execute_and_instances(context) File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute return meth(self, multiparams, params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context context) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception exc_info File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context context) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.DatabaseError: (DatabaseError) file is encrypted or is not a database u'SELECT packages."pkgKey" AS "packages_pkgKey", packages.name AS packages_name, packages.rpm_sourcerpm AS packages_rpm_sourcerpm, packages.version AS packages_version, packages.epoch AS packages_epoch, packages.release AS packages_release, packages.arch AS packages_arch \nFROM packages' ()
Note that batcave01 is frozen, so any fix will need a freeze break request.
@pingou / @puiterwijk This might be something one of you could look into...
Metadata Update from @pingou: - Issue assigned to pingou
I just did a manual run in my home dir, it worked fine. Do you know if it crashed again since this one?
It has not.
So, perhaps this was some kind of one-off failure. Sorry about that... will close this now.
:racehorse:
Metadata Update from @kevin: - Issue close_status updated to: Fixed - Issue status updated to: Closed (was: Open)
No problem, glad you're keep an eye on it :)
Metadata Update from @pingou: - Issue status updated to: Open (was: Closed)
Metadata Update from @pingou: - Issue close_status updated to: Fixed - Issue status updated to: Closed (was: Open)
Login to comment on this ticket.