Page MenuHomePhabricator
Paste P3188

Wikilabels db connection errors
ActivePublic

Authored by Ladsgroup on May 28 2016, 10:28 PM.
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: 2016-05-28 22:17:01,461 ERROR:wikilabels -- Exception on /campaigns/enwiki/32/ [GET]
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: Traceback (most recent call last):
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1817, in wsgi_app
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: response = self.full_dispatch_request()
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1477, in full_dispatch_request
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: rv = self.handle_user_exception(e)
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1381, in handle_user_exception
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: reraise(exc_type, exc_value, tb)
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: raise value
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1475, in full_dispatch_request
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: rv = self.dispatch_request()
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1461, in dispatch_request
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: return self.view_functions[rule.endpoint](**req.view_args)
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/wsgi/routes/campaigns.py", line 67, in get_campaign
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: doc['campaign'] = db.campaigns.get(campaign_id, stats)
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/campaigns.py", line 59, in get
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: """, {'campaign_id': campaign_id})
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/psycopg2/extras.py", line 223, in execute
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: return super(RealDictCursor, self).execute(query, vars)
May 28 22:17:01 wikilabels-01 uwsgi-wikilabels-web[7698]: psycopg2.DatabaseError: error with no message from the libpq
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: 2016-05-28 22:18:32,771 ERROR:wikilabels -- Exception on /users/43599777/4/ [GET]
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: Traceback (most recent call last):
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/db.py", line 34, in transaction
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: yield conn
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/campaigns.py", line 62, in get
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: row = next(cursor)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: psycopg2.ProgrammingError: no results to fetch
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: During handling of the above exception, another exception occurred:
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: Traceback (most recent call last):
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1817, in wsgi_app
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: response = self.full_dispatch_request()
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1477, in full_dispatch_request
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: rv = self.handle_user_exception(e)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1381, in handle_user_exception
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: reraise(exc_type, exc_value, tb)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: raise value
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1475, in full_dispatch_request
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: rv = self.dispatch_request()
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1461, in dispatch_request
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: return self.view_functions[rule.endpoint](**req.view_args)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/wsgi/routes/users.py", line 48, in get_user_campaign
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: doc['campaign'] = db.campaigns.get(campaign_id, stats=stats)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/campaigns.py", line 67, in get
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: raise NotFoundError("campaign_id={0}".format(campaign_id))
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/usr/lib/python3.4/contextlib.py", line 77, in __exit__
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: self.gen.throw(type, value, traceback)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/db.py", line 37, in transaction
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: conn.rollback()
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: psycopg2.DatabaseError: error with no message from the libpq
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: [pid: 7710|app: 0|req: 79/250] 10.68.21.68 () {38 vars in 847 bytes} [Sat May 28 22:18:32 2016] GET /users/43599777/4/?callback=jQuery111309026084179710605_1464473911772&worksets=stats&_=1464473911775 => generated 291 bytes in 5 msecs (HTTP/1.1 500) 2 headers in 84 bytes (1 switches on core 0)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: 2016-05-28 22:18:32,770 ERROR:wikilabels -- Exception on /users/43599777/31/ [GET]
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: Traceback (most recent call last):
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/db.py", line 34, in transaction
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: yield conn
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/campaigns.py", line 62, in get
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: row = next(cursor)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: psycopg2.ProgrammingError: no results to fetch
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: During handling of the above exception, another exception occurred:
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: Traceback (most recent call last):
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1817, in wsgi_app
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: response = self.full_dispatch_request()
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1477, in full_dispatch_request
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: rv = self.handle_user_exception(e)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1381, in handle_user_exception
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: reraise(exc_type, exc_value, tb)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/_compat.py", line 33, in reraise
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: raise value
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1475, in full_dispatch_request
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: rv = self.dispatch_request()
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/srv/wikilabels/venv/lib/python3.4/site-packages/flask/app.py", line 1461, in dispatch_request
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: return self.view_functions[rule.endpoint](**req.view_args)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/wsgi/routes/users.py", line 48, in get_user_campaign
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: doc['campaign'] = db.campaigns.get(campaign_id, stats=stats)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/campaigns.py", line 67, in get
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: raise NotFoundError("campaign_id={0}".format(campaign_id))
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "/usr/lib/python3.4/contextlib.py", line 77, in __exit__
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: self.gen.throw(type, value, traceback)
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: File "./wikilabels/database/db.py", line 37, in transaction
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: conn.rollback()
May 28 22:18:32 wikilabels-01 uwsgi-wikilabels-web[7698]: psycopg2.DatabaseError: error with no message from the libpq