#6746 freshmaker01 wsgi errors
Closed 6 years ago Opened 6 years ago by kevin.

freshmaker01.phx2.fedoraproject.org is spewing to the logs:

Feb 26 19:56:13 freshmaker-frontend01.phx2.fedoraproject.org mod_wsgi: Internal server error: (ProgrammingError) relation "artifact_builds" does not exist#012LINE 2: FROM artifact_builds ORDER BY artifact_builds.id #012             ^#012 'SELECT artifact_builds.id AS artifact_builds_id, artifact_builds.name AS artifact_builds_name, artifact_builds.original_nvr AS artifact_builds_original_nvr, artifact_builds.rebuilt_nvr AS artifact_builds_rebuilt_nvr, artifact_builds.type AS artifact_builds_type, artifact_builds.state AS artifact_builds_state, artifact_builds.state_reason AS artifact_builds_state_reason, artifact_builds.time_submitted AS artifact_builds_time_submitted, artifact_builds.time_completed AS artifact_builds_time_completed, artifact_builds.dep_on_id AS artifact_builds_dep_on_id, artifact_builds.event_id AS artifact_builds_event_id, artifact_builds.build_id AS artifact_builds_build_id, artifact_builds.build_args AS artifact_builds_build_args \nFROM artifact_builds ORDER BY artifact_builds.id \n LIMIT %(param_1)s OFFSET %(param_2)s' {'param_1': 10, 'param_2': 0}#012Traceback (most recent call last):#012  File "/usr/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request#012    rv = self.dispatch_request()#012  File "/usr/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request#012    return self.view_functions[rule.endpoint](**req.view_args)#012  File "/usr/lib/python2.7/site-packages/flask/views.py", line 84, in view#012    return self.dispatch_request(*args, **kwargs)#012  File "/usr/lib/python2.7/site-packages/flask/views.py", line 149, in dispatch_request#012    return meth(*args, **kwargs)#012  File "/usr/lib/python2.7/site-packages/freshmaker/views.py", line 210, in get#012    p_query = filter_artifact_builds(request)#012  File "/usr/lib/python2.7/site-packages/freshmaker/api_utils.py", line 114, in filter_artifact_builds#012    return query.paginate(page, per_page, False)#012  File "/usr/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py", line 431, in paginate#012    items = self.limit(per_page).offset((page - 1) * per_page).all()#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2320, in all#012    return list(self)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2438, in __iter__#012    return self._execute_and_instances(context)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in _execute_and_instances#012    result = conn.execute(querycontext.statement, self._params)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute#012    return meth(self, multiparams, params)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection#012    return connection._execute_clauseelement(self, multiparams, params)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement#012    compiled_sql, distilled_params#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context#012    context)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception#012    exc_info#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause#012    reraise(type(exception), exception, tb=exc_tb)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context#012    context)#012  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute#012    cursor.execute(statement, parameters)#012ProgrammingError: (ProgrammingError) relation "artifact_builds" does not exist#012LINE 2: FROM artifact_builds ORDER BY artifact_builds.id #012             ^#012 'SELECT artifact_builds.id AS artifact_builds_id, artifact_builds.name AS artifact_builds_name, artifact_builds.original_nvr AS artifact_builds_original_nvr, artifact_builds.rebuilt_nvr AS artifact_builds_rebuilt_nvr, artifact_builds.type AS artifact_builds_type, artifact_builds.state AS artifact_builds_state, artifact_builds.state_reason AS artifact_builds_state_reason, artifact_builds.time_submitted AS artifact_builds_time_submitted, artifact_builds.time_completed AS artifact_builds_time_completed, artifact_builds.dep_on_id AS artifact_builds_dep_on_id, artifact_builds.event_id AS artifact_builds_event_id, artifact_builds.build_id AS artifact_builds_build_id, artifact_builds.build_args AS artifact_builds_build_args \nFROM artifact_builds ORDER BY artifact_builds.id \n LIMIT %(param_1)s OFFSET %(param_2)s' {'param_1': 10, 'param_2': 0}

It's logged this...

grep freshmaker /var/log/merged/messages.log | grep mod_wsgi | grep Traceback | wc -l

42645
times today.


Metadata Update from @ralph:
- Issue assigned to ralph

6 years ago

I ran freshmaker-upgradedb which created the database.

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

6 years ago

Login to comment on this ticket.

Metadata