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:49:26 UTC
[GitHub] [airflow] carb1 commented on issue #10055: Can not started scheduler when use command "airflow scheduler -D"
carb1 commented on issue #10055:
URL: https://github.com/apache/airflow/issues/10055#issuecomment-747273684
> ```
> 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 command "airflow scheduler -D".
> who can solve this problem...?
i dont solve this problem too.i use docker now,and it doesnt need 'airflow scheduler',if you only want to set a simple dag, you can try to use docker too
----------------------------------------------------------------
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