[GitHub] [airflow] feluelle commented on issue #5530: [AIRFLOW-1740] Fix xcom creation and update via UI

[GitBox <gi...@apache.org>]

feluelle commented on issue #5530: [AIRFLOW-1740] Fix xcom creation and update via UI
URL: https://github.com/apache/airflow/pull/5530#issuecomment-508503339
 
 
   I get the following error in 1.10.2 RBAC
   ```
   Traceback (most recent call last):
     File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/models/sqla/interface.py", line 308, in add
       self.session.commit()
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py", line 162, in do
       return getattr(self.registry(), name)(*args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1023, in commit
       self.transaction.commit()
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 487, in commit
       self._prepare_impl()
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 466, in _prepare_impl
       self.session.flush()
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2446, in flush
       self._flush(objects)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2584, in _flush
       transaction.rollback(_capture_exception=True)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
       compat.reraise(exc_type, exc_value, exc_tb)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
       raise value
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2544, in _flush
       flush_context.execute()
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 416, in execute
       rec.execute(self)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 583, in execute
       uow,
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
       insert,
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1116, in _emit_insert_statements
       statement, params
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 980, in execute
       return meth(self, multiparams, params)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection
       return connection._execute_clauseelement(self, multiparams, params)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
       distilled_params,
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1174, in _execute_context
       e, util.text_type(statement), parameters, None, None
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1458, in _handle_dbapi_exception
       util.raise_from_cause(sqlalchemy_exception, exc_info)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 296, 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 276, in reraise
       raise value.with_traceback(tb)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1171, in _execute_context
       context = constructor(dialect, self, conn, *args)
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 729, in _init_compiled
       for key in compiled_params
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 729, in <genexpr>
       for key in compiled_params
     File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/type_api.py", line 1194, in process
       return process_param(value, dialect)
     File "/usr/local/lib/python3.6/site-packages/airflow/utils/sqlalchemy.py", line 153, in process_bind_param
       raise ValueError('naive datetime is disallowed')
   sqlalchemy.exc.StatementError: (builtins.ValueError) naive datetime is disallowed [SQL: 'INSERT INTO xcom (key, value, timestamp, execution_date, task_id, dag_id) VALUES (%(key)s, %(value)s, %(timestamp)s, %(execution_date)s, %(task_id)s, %(dag_id)s) RETURNING xcom.id'] [parameters: [{'task_id': 'run_me_0', 'value': 'value1', 'dag_id': 'example_bash_operator', 'key': 'key1', 'execution_date': datetime.datetime(2019, 7, 4, 16, 30, 54)}]]
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services