ERROR:flask.app:Exception on /v1/tasks/ [POST]
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
    cursor.execute(statement, parameters)
psycopg2.IntegrityError: insert or update on table "tasks" violates foreign key constraint "tasks_category_id_fkey"
DETAIL:  Key (category_id)=(4) is not present in table "categories".


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
    raise value
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python3.6/site-packages/webargs/core.py", line 446, in wrapper
    return func(*args, **kwargs)
  File "/var/www/app/v1/app/tasks/views.py", line 96, in add_task_view
    db.session.commit()
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py", line 153, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 943, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 467, in commit
    self._prepare_impl()
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 447, in _prepare_impl
    self.session.flush()
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2254, in flush
    self._flush(objects)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2380, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 249, in reraise
    raise value
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2344, in _flush
    flush_context.execute()
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute
    rec.execute(self)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 556, in execute
    uow
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
    mapper, table, insert)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 866, in _emit_insert_statements
    execute(statement, params)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
    context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
    exc_info
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) insert or update on table "tasks" violates foreign key constraint "tasks_category_id_fkey"
DETAIL:  Key (category_id)=(4) is not present in table "categories".
 [SQL: 'INSERT INTO tasks (created_on, updated_on, title, category_id, description, type, state, complete_until, duration, periodicity, starts_from, ends_on, divisions, clusters, supervisors, shops, users, pictures, created_by, modified_by, generated_at) VALUES (%(created_on)s, %(updated_on)s, %(title)s, %(category_id)s, %(description)s, %(type)s, %(state)s, %(complete_until)s, %(duration)s, %(periodicity)s, %(starts_from)s, %(ends_on)s, %(divisions)s, %(clusters)s, %(supervisors)s, %(shops)s, %(users)s, %(pictures)s, %(created_by)s, %(modified_by)s, %(generated_at)s) RETURNING tasks.id'] [parameters: {'created_on': datetime.datetime(2019, 7, 16, 6, 53, 21, 272924), 'updated_on': None, 'title': 'test_1563270801', 'category_id': 4, 'description': 'test', 'type': 'assignable', 'state': 'active', 'complete_until': datetime.time(0, 0), 'duration': datetime.time(0, 0), 'periodicity': 'string', 'starts_from': datetime.date(2019, 7, 16), 'ends_on': datetime.date(2019, 7, 16), 'divisions': ['VO'], 'clusters': ['D_VO34'], 'supervisors': ['natalia.barysheva'], 'shops': ['L200'], 'users': [0], 'pictures': None, 'created_by': 0, 'modified_by': None, 'generated_at': None}] (Background on this error at: http://sqlalche.me/e/gkpj)
INFO:auth:Signature has expired
INFO:auth:Getting request from {'jti': '6b5830e5-c9d7-4b7d-b58c-82b4e2cff41c', 'exp': 1563261752, 'nbf': 0, 'iat': 1563261452, 'iss': 'https://keycloak.os-dev.x5.ru/auth/realms/BeelineTest', 'aud': 'account', 'sub': '5ccd013e-d1d8-414b-bdbf-71cc8f90e4a7', 'typ': 'Bearer', 'azp': 'for-tests', 'auth_time': 0, 'session_state': '45f39ded-7926-4ba7-be3d-861cb43d655b', 'acr': '1', 'realm_access': {'roles': ['offline_access', 'uma_authorization']}, 'resource_access': {'account': {'roles': ['manage-account', 'manage-account-links', 'view-profile']}}, 'scope': 'email profile', 'division_ids': ['NG'], 'email_verified': True, 'role': 'ДД', 'identity': 'X5\\pavel.kirsanov', 'name': 'Agent Admin', 'preferred_username': 'test_admin', 'given_name': 'Agent', 'family_name': 'Admin', 'email': 'ff@ff.ru'}
ERROR:flask.app:Exception on /v1/tasks/ [POST]
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
    cursor.execute(statement, parameters)
psycopg2.OperationalError: terminating connection due to administrator command
SSL connection has been closed unexpectedly