Page MenuHomePhabricator

Periodic database connection error in Wiki labels
Closed, DuplicatePublic

Description

May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: 2016-05-29 16:06:34,639 ERROR:wikilabels -- Exception on /users/6877667/4/ [GET]
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: Traceback (most recent call last):
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1817, in wsgi_app
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: response = self.full_dispatch_request()
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1477, in full_dispatch_request
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: rv = self.handle_user_exception(e)
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1381, in handle_user_exception
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: reraise(exc_type, exc_value, tb)
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: raise value
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1475, in full_dispatch_request
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: rv = self.dispatch_request()
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1461, in dispatch_request
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: return self.view_functions[rule.endpoint](**req.view_args)
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "./wikilabels/wsgi/routes/users.py", line 56, in get_user_campaign
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: stats=stats)
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "./wikilabels/database/worksets.py", line 99, in for_user
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: row['stats'] = self.stats_for(row['id'])
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: File "./wikilabels/database/worksets.py", line 48, in stats_for
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: return next(cursor)
May 29 16:06:34 wikilabels-01 uwsgi-wikilabels-web[8825]: psycopg2.ProgrammingError: no results to fetch[pid: 8830|app: 0|req: 3158/23603] 10.68.21.68 ()

This error appears in the logs intermittently.

Related Objects

Event Timeline

Halfak renamed this task from Period database connection error in Wiki labels to Periodic database connection error in Wiki labels.May 29 2016, 4:10 PM

Looks like this related error happens too

May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: Traceback (most recent call last):
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1817, in wsg
i_app
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: response = self.full_dispatch_request()
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1477, in full_dispatch_request
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: rv = self.handle_user_exception(e)
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1381, in handle_user_exception
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: reraise(exc_type, exc_value, tb)
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: raise value
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1475, in full_dispatch_request
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: rv = self.dispatch_request()
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1461, in dispatch_request
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: return self.view_functions[rule.endpoint](**req.view_args)
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "./wikilabels/wsgi/routes/users.py", line 48, in get_user_campaign
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: doc['campaign'] = db.campaigns.get(campaign_id, stats=stats)
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "./wikilabels/database/campaigns.py", line 67, in get
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: raise NotFoundError("campaign_id={0}".format(campaign_id))
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "/usr/lib/python3.4/contextlib.py", line 77, in __exit__
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: self.gen.throw(type, value, traceback)
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: File "./wikilabels/database/db.py", line 38, in transaction
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: conn.rollback()
May 29 16:07:38 wikilabels-staging-01 uwsgi-wikilabels-web[16077]: psycopg2.DatabaseError: error with no message from the libpq
This comment was removed by Halfak.
This comment was removed by Halfak.

Woops! These comments should have been on T136520