#5894 rhel2json cron on batcave01 broken
Closed: Fixed 7 years ago Opened 7 years ago by kevin.

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

7 years ago

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)

7 years ago

No problem, glad you're keep an eye on it :)

No problem, glad you're keep an eye on it :)

Metadata Update from @pingou:
- Issue status updated to: Open (was: Closed)

7 years ago

Metadata Update from @pingou:
- Issue close_status updated to: Fixed
- Issue status updated to: Closed (was: Open)

7 years ago

Login to comment on this ticket.

Metadata