Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2017-08-23 10:47:29,194 ERROR { 'category': 'LOG_ERR',
- 'correlationId': '006-055766EC6BB97F25225D688DAA',
- 'data': { 'action': 'ApiHandleException',
- 'body': 'Traceback (most recent call last):\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", '
- 'line 1139, in _execute_context\n'
- ' context)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/default.py", '
- 'line 450, in do_execute\n'
- ' cursor.execute(statement, parameters)\n'
- 'psycopg2.ProgrammingError: more than one row '
- 'returned by a subquery used as an expression\n'
- '\n'
- '\n'
- 'The above exception was the direct cause of '
- 'the following exception:\n'
- '\n'
- 'Traceback (most recent call last):\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/qps/api/handler.py", '
- 'line 25, in __call__\n'
- ' result = getattr(self, method)(**data)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/qps/util.py", '
- 'line 420, in wrap\n'
- ' result = func(*args, **kwargs)\n'
- ' File '
- '"/home/anshik/Projects/qiwi/qps/distr/wevents/application/handler.py", '
- 'line 553, in get_postamat_encloses\n'
- ' a = query.all()\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/orm/query.py", '
- 'line 2588, in all\n'
- ' return list(self)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/orm/query.py", '
- 'line 2736, in __iter__\n'
- ' return '
- 'self._execute_and_instances(context)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/orm/query.py", '
- 'line 2751, in _execute_and_instances\n'
- ' result = '
- 'conn.execute(querycontext.statement, '
- 'self._params)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", '
- 'line 914, in execute\n'
- ' return meth(self, multiparams, params)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/sql/elements.py", '
- 'line 323, in _execute_on_connection\n'
- ' return '
- 'connection._execute_clauseelement(self, '
- 'multiparams, params)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", '
- 'line 1010, in _execute_clauseelement\n'
- ' compiled_sql, distilled_params\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", '
- 'line 1146, in _execute_context\n'
- ' context)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", '
- 'line 1341, in _handle_dbapi_exception\n'
- ' exc_info\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/util/compat.py", '
- 'line 200, in raise_from_cause\n'
- ' reraise(type(exception), exception, '
- 'tb=exc_tb, cause=cause)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/util/compat.py", '
- 'line 183, in reraise\n'
- ' raise value.with_traceback(tb)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/base.py", '
- 'line 1139, in _execute_context\n'
- ' context)\n'
- ' File '
- '"/home/anshik/Projects/wevents_venv/lib/python3.5/site-packages/sqlalchemy/engine/default.py", '
- 'line 450, in do_execute\n'
- ' cursor.execute(statement, parameters)\n'
- 'sqlalchemy.exc.ProgrammingError: '
- '(psycopg2.ProgrammingError) more than one row '
- 'returned by a subquery used as an expression\n'
- " [SQL: 'SELECT enclose._id AS enclose_id, "
- 'enclose.event_status AS enclose_event_status, '
- 'enclose.parcel_id AS parcel_id, '
- 'enclose.barcode AS enclose_barcode, '
- 'enclose.priority AS enclose_priority, '
- 'enclose.size AS enclose_size, enclose.cell_id '
- 'AS enclose_cell_id, parcel.external_id AS '
- 'parcel_external_id, parcel.code AS '
- 'parcel_code, parcel.amount_to_pay AS '
- 'parcel_amount_to_pay, CASE '
- 'enclose.event_status WHEN %(param_1)s THEN '
- '(SELECT to_char(event.reg_time, '
- '%(to_char_1)s) AS reg_time \\nFROM event '
- '\\nWHERE event.actual = true AND event.event '
- '= %(event_1)s AND event.enclose_id = '
- 'enclose._id ORDER BY event.reg_time DESC) '
- 'WHEN %(param_2)s THEN (SELECT '
- 'to_char(event.reg_time, %(to_char_1)s) AS '
- 'reg_time \\nFROM event \\nWHERE event.actual '
- '= true AND event.event = %(event_2)s AND '
- 'event.enclose_id = enclose._id ORDER BY '
- 'event.reg_time DESC) WHEN %(param_3)s THEN '
- '(SELECT to_char(event.reg_time, '
- '%(to_char_1)s) AS reg_time \\nFROM event '
- '\\nWHERE event.actual = true AND event.event '
- '= %(event_3)s AND event.enclose_id = '
- 'enclose._id ORDER BY event.reg_time DESC) '
- 'WHEN %(param_4)s THEN (SELECT '
- 'to_char(event.reg_time, %(to_char_1)s) AS '
- 'reg_time \\nFROM event \\nWHERE event.actual '
- '= true AND event.event = %(event_4)s AND '
- 'event.enclose_id = enclose._id ORDER BY '
- 'event.reg_time DESC) END AS event_reg_time '
- '\\nFROM enclose JOIN parcel ON '
- 'enclose.parcel_id = parcel._id \\nWHERE '
- 'enclose.postamat_id = %(postamat_id_1)s AND '
- 'enclose.event_status IN (%(event_status_1)s, '
- '%(event_status_2)s, %(event_status_3)s, '
- "%(event_status_4)s)'] [parameters: "
- "{'param_1': 1, 'event_3': 4, "
- "'event_status_3': 4, 'event_status_1': 1, "
- "'param_2': 2, 'to_char_1': 'YYYY-MM-DD "
- "HH24:MI:SS', 'event_status_4': 10, 'event_2': "
- "2, 'param_3': 4, 'postamat_id_1': '7700-004', "
- "'event_4': 10, 'event_1': 1, 'param_4': 10, "
- "'event_status_2': 2}]\n",
- 'context': {},
- 'method': None,
- 'parcelId': None,
- 'result': None},
- 'module': 'WORKER_EVENTS',
- 'timestamp': '2017-08-23T07:47:29Z',
- 'type': 'activity',
- 'version': '0.1'}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
