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/12/17 07:41:42 UTC
[GitHub] [airflow] dongle94 commented on issue #10055: Can not started scheduler when use command "airflow scheduler -D"
dongle94 commented on issue #10055:
URL: https://github.com/apache/airflow/issues/10055#issuecomment-747270583
```
Traceback (most recent call last):
File "/home/smarteye/anaconda3/envs/workflow/bin/airflow", line 37, in <module>
args.func(args)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/airflow/utils/cli.py", line 81, in wrapper
return f(*args, **kwargs)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/airflow/bin/cli.py", line 1316, in scheduler
job.run()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/airflow/jobs/base_job.py", line 212, in run
session.commit()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1042, in commit
self.transaction.commit()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 504, in commit
self._prepare_impl()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 483, in _prepare_impl
self.session.flush()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2536, in flush
self._flush(objects)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2678, in _flush
transaction.rollback(_capture_exception=True)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
with_traceback=exc_tb,
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2638, in _flush
flush_context.execute()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
rec.execute(self)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
uow,
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 213, in save_obj
) in _organize_states_for_save(base_mapper, states, uowtransaction):
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 374, in _organize_states_for_save
base_mapper, uowtransaction, states
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1602, in _connections_for_states
connection = uowtransaction.transaction.connection(base_mapper)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 314, in connection
return self._connection_for_bind(bind, execution_options)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 421, in _connection_for_bind
conn = self._parent._connection_for_bind(bind, execution_options)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 433, in _connection_for_bind
conn = bind._contextual_connect()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2302, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
return fn()
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 809, in _checkout
result = pool._dialect.do_ping(fairy.connection)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 138, in do_ping
dbapi_connection.ping(False)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/pymysql/connections.py", line 534, in ping
self._execute_command(COMMAND.COM_PING, "")
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/pymysql/connections.py", line 763, in _execute_command
self._write_bytes(packet)
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/pymysql/connections.py", line 703, in _write_bytes
self._sock.settimeout(self._write_timeout)
OSError: [Errno 9] Bad file descriptor
Exception ignored in: <function _ConnectionRecord.checkout.<locals>.<lambda> at 0x7f6bff0fd950>
Traceback (most recent call last):
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 506, in <lambda>
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 706, in _finalize_fairy
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/logging/__init__.py", line 1337, in error
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/logging/__init__.py", line 1444, in _log
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/logging/__init__.py", line 1454, in handle
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/logging/__init__.py", line 1516, in callHandlers
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/logging/__init__.py", line 865, in handle
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/logging/__init__.py", line 1071, in emit
File "/home/smarteye/anaconda3/envs/workflow/lib/python3.6/logging/__init__.py", line 1061, in _open
NameError: name 'open' is not defined
```
Hello. I have same issue when use comman "airflow scheduler -D".
who can solve this problem...?
----------------------------------------------------------------
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