Created
August 18, 2017 09:12
-
-
Save Birne94/e6e7ba91d44a680ba09419f7aa9f5705 to your computer and use it in GitHub Desktop.
exception log
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[2017-08-17 23:46:40,414] ERROR in app: Exception on /webviews/style_rec_feedback_api [GET] | |
Traceback (most recent call last): | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context | |
context) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 469, in do_execute | |
cursor.execute(statement, parameters) | |
psycopg2.OperationalError: terminating connection due to administrator command | |
SSL connection has been closed unexpectedly | |
The above exception was the direct cause of the following exception: | |
Traceback (most recent call last): | |
[SNAP: Stacktrace leading up to simple select query through ORM] | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2645, in all | |
return list(self) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2797, in __iter__ | |
return self._execute_and_instances(context) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2820, in _execute_and_instances | |
result = conn.execute(querycontext.statement, self._params) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 945, in execute | |
return meth(self, multiparams, params) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection | |
return connection._execute_clauseelement(self, multiparams, params) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement | |
compiled_sql, distilled_params | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context | |
context) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1393, in _handle_dbapi_exception | |
exc_info | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause | |
reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 185, in reraise | |
raise value.with_traceback(tb) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context | |
context) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/default.py", line 469, in do_execute | |
cursor.execute(statement, parameters) | |
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) terminating connection due to administrator command | |
SSL connection has been closed unexpectedly | |
[SQL: 'SELECT outfit_recommendation.id AS outfit_recommendation_id, outfit_recommendation.created_on AS outfit_recommendation_created_on, outfit_recommendation.updated_on AS outfit_recommendation_updated_on, outfit_recommendation.user_id AS outfit_recommendation_user_id, outfit_recommendation.outfit_id AS outfit_recommendation_outfit_id, outfit_recommendation.distance AS outfit_recommendation_distance \nFROM outfit_recommendation JOIN "user" ON "user".id = outfit_recommendation.user_id \nWHERE "user".legacy_id = %(legacy_id_1)s AND outfit_recommendation.distance < %(distance_1)s AND outfit_recommendation.created_on > %(created_on_1)s'] [parameters: {'created_on_1': datetime.datetime(2017, 8, 15, 21, 46, 40, 247321), 'distance_1': 0.25, 'legacy_id_1': '59'}] | |
[pid: 26554|app: 0|req: 38/38] 2a03:2880:1020:6fea:face:b00c:0:8000 () {40 vars in 896 bytes} [Thu Aug 17 23:46:40 2017] GET /webviews/style_rec_feedback_api?user=1482768118483315 => generated 291 bytes in 176 msecs (HTTP/1.1 500) 2 headers in 84 bytes (1 switches on core 0) | |
./botface/ext/flask.py:91: UserWarning: Rolling back database session because of exception (psycopg2.OperationalError) terminating connection due to administrator command | |
SSL connection has been closed unexpectedly | |
[SQL: 'SELECT outfit_recommendation.id AS outfit_recommendation_id, outfit_recommendation.created_on AS outfit_recommendation_created_on, outfit_recommendation.updated_on AS outfit_recommendation_updated_on, outfit_recommendation.user_id AS outfit_recommendation_user_id, outfit_recommendation.outfit_id AS outfit_recommendation_outfit_id, outfit_recommendation.distance AS outfit_recommendation_distance \nFROM outfit_recommendation JOIN "user" ON "user".id = outfit_recommendation.user_id \nWHERE "user".legacy_id = %(legacy_id_1)s AND outfit_recommendation.distance < %(distance_1)s AND outfit_recommendation.created_on > %(created_on_1)s'] [parameters: {'created_on_1': datetime.datetime(2017, 8, 15, 21, 46, 40, 247321), 'distance_1': 0.25, 'legacy_id_1': '59'}] | |
"exception {}".format(exception)) | |
[2017-08-17 23:46:44,064] ERROR in app: Exception on /webviews/style_rec_feedback_api [GET] | |
Traceback (most recent call last): | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1112, in _execute_context | |
conn = self.__connection | |
AttributeError: 'Connection' object has no attribute '_Connection__connection' | |
During handling of the above exception, another exception occurred: | |
Traceback (most recent call last): | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1114, in _execute_context | |
conn = self._revalidate_connection() | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 424, in _revalidate_connection | |
"Can't reconnect until invalid " | |
sqlalchemy.exc.InvalidRequestError: Can't reconnect until invalid transaction is rolled back | |
The above exception was the direct cause of the following exception: | |
Traceback (most recent call last): | |
[SNAP: Stacktrace leading up to simple select query through ORM] | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2645, in all | |
return list(self) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2797, in __iter__ | |
return self._execute_and_instances(context) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/orm/query.py", line 2820, in _execute_and_instances | |
result = conn.execute(querycontext.statement, self._params) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 945, in execute | |
return meth(self, multiparams, params) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection | |
return connection._execute_clauseelement(self, multiparams, params) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement | |
compiled_sql, distilled_params | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1121, in _execute_context | |
None, None) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1393, in _handle_dbapi_exception | |
exc_info | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause | |
reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/util/compat.py", line 185, in reraise | |
raise value.with_traceback(tb) | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 1114, in _execute_context | |
conn = self._revalidate_connection() | |
File "/www/PROJECT_NAME/venv/lib/python3.4/site-packages/sqlalchemy/engine/base.py", line 424, in _revalidate_connection | |
"Can't reconnect until invalid " | |
sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: 'SELECT outfit_recommendation.id AS outfit_recommendation_id, outfit_recommendation.created_on AS outfit_recommendation_created_on, outfit_recommendation.updated_on AS outfit_recommendation_updated_on, outfit_recommendation.user_id AS outfit_recommendation_user_id, outfit_recommendation.outfit_id AS outfit_recommendation_outfit_id, outfit_recommendation.distance AS outfit_recommendation_distance \nFROM outfit_recommendation JOIN "user" ON "user".id = outfit_recommendation.user_id \nWHERE "user".legacy_id = %(legacy_id_1)s AND outfit_recommendation.distance < %(distance_1)s AND outfit_recommendation.created_on > %(created_on_1)s'] [parameters: [{}]] | |
[pid: 26554|app: 0|req: 41/41] 2601:248:c200:b930:cc5d:c6fe:d2ce:fd78 () {42 vars in 1002 bytes} [Thu Aug 17 23:46:43 2017] GET /webviews/style_rec_feedback_api?user=1482768118483315 => generated 291 bytes in 82 msecs (HTTP/1.1 500) 2 headers in 84 bytes (1 switches on core 0) | |
./botface/ext/flask.py:91: UserWarning: Rolling back database session because of exception (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: 'SELECT outfit_recommendation.id AS outfit_recommendation_id, outfit_recommendation.created_on AS outfit_recommendation_created_on, outfit_recommendation.updated_on AS outfit_recommendation_updated_on, outfit_recommendation.user_id AS outfit_recommendation_user_id, outfit_recommendation.outfit_id AS outfit_recommendation_outfit_id, outfit_recommendation.distance AS outfit_recommendation_distance \nFROM outfit_recommendation JOIN "user" ON "user".id = outfit_recommendation.user_id \nWHERE "user".legacy_id = %(legacy_id_1)s AND outfit_recommendation.distance < %(distance_1)s AND outfit_recommendation.created_on > %(created_on_1)s'] [parameters: [{}]] | |
"exception {}".format(exception)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment