You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2020/11/28 11:14:34 UTC

[GitHub] [airflow] c-hui commented on issue #10055: Can not started scheduler when use command "airflow scheduler -D"

c-hui commented on issue #10055:
URL: https://github.com/apache/airflow/issues/10055#issuecomment-735218327


   I have the same err:
   ```
   Traceback (most recent call last):
     File "/home/datastem/pyenv/airflow/bin/airflow", line 37, in <module>
       args.func(args)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/airflow/utils/cli.py", line 80, in wrapper
       return f(*args, **kwargs)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/airflow/bin/cli.py", line 1214, in scheduler
       job.run()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/airflow/jobs/base_job.py", line 212, in run
       session.commit()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1036, in commit
       self.transaction.commit()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 503, in commit
       self._prepare_impl()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 482, in _prepare_impl
       self.session.flush()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 2496, in flush
       self._flush(objects)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 2637, in _flush
       transaction.rollback(_capture_exception=True)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
       compat.raise_(
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
       raise exception
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 2597, in _flush
       flush_context.execute()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
       rec.execute(self)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py", line 586, in execute
       persistence.save_obj(
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py", line 205, in save_obj
       for (
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py", line 373, in _organize_states_for_save
       for state, dict_, mapper, connection in _connections_for_states(
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py", line 1602, in _connections_for_states
       connection = uowtransaction.transaction.connection(base_mapper)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 313, in connection
       return self._connection_for_bind(bind, execution_options)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 420, in _connection_for_bind
       conn = self._parent._connection_for_bind(bind, execution_options)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 432, in _connection_for_bind
       conn = bind._contextual_connect()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2251, in _contextual_connect
       self._wrap_pool_connect(self.pool.connect, None),
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2285, in _wrap_pool_connect
       return fn()
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 363, in connect
       return _ConnectionFairy._checkout(self)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 804, in _checkout
       result = pool._dialect.do_ping(fairy.connection)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 138, in do_ping
       dbapi_connection.ping(False)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/pymysql/connections.py", line 546, in ping
       self._execute_command(COMMAND.COM_PING, "")
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/pymysql/connections.py", line 771, in _execute_command
       self._write_bytes(packet)
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/pymysql/connections.py", line 711, in _write_bytes
       self._sock.settimeout(self._write_timeout)
   OSError: [Errno 9] Bad file descriptor
   Exception ignored in: <function _ConnectionRecord.checkout.<locals>.<lambda> at 0x7fde26ffa1f0>
   Traceback (most recent call last):
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 503, in <lambda>
     File "/home/datastem/pyenv/airflow/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 701, in _finalize_fairy
     File "/usr/local/python38/lib/python3.8/logging/__init__.py", line 1463, in error
     File "/usr/local/python38/lib/python3.8/logging/__init__.py", line 1577, in _log
     File "/usr/local/python38/lib/python3.8/logging/__init__.py", line 1587, in handle
     File "/usr/local/python38/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
     File "/usr/local/python38/lib/python3.8/logging/__init__.py", line 950, in handle
     File "/usr/local/python38/lib/python3.8/logging/__init__.py", line 1182, in emit
     File "/usr/local/python38/lib/python3.8/logging/__init__.py", line 1172, in _open
   NameError: name 'open' is not defined
   ```
   apache-airflow         1.10.13
   Python 3.8.6
   Centos 7


----------------------------------------------------------------
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