wxm245 opened a new issue #10055:
URL: https://github.com/apache/airflow/issues/10055
when i use command "airflow scheduler -D", I found process can not started.
And in files airflow-scheduler.err, airflow-scheduler.out have error info.
airflow-scheduler.err
Traceback (most recent call last):
File "/usr/local/bin/airflow", line 37, in <module>
args.func(args)
File "/usr/local/lib/python3.6/site-packages/airflow/utils/cli.py", line
76, in wrapper
return f(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/airflow/bin/cli.py", line
1213, in scheduler
job.run()
File "/usr/local/lib/python3.6/site-packages/airflow/jobs/base_job.py",
line 212, in run
session.commit()
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 1042, in commit
self.transaction.commit()
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 504, in commit
self._prepare_impl()
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 483, in _prepare_impl
self.session.flush()
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2523, in flush
self._flush(objects)
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2664, in _flush
transaction.rollback(_capture_exception=True)
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line
69, in __exit__
exc_value, with_traceback=exc_tb,
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/util/compat.py",
line 178, in raise_
raise exception
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2624, in _flush
flush_context.execute()
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line
422, in execute
rec.execute(self)
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line
589, in execute
uow,
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line
213, in save_obj
) in _organize_states_for_save(base_mapper, states, uowtransaction):
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line
374, in _organize_states_for_save
base_mapper, uowtransaction, states
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line
1602, in _connections_for_states
connection = uowtransaction.transaction.connection(base_mapper)
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 314, in connection
return self._connection_for_bind(bind, execution_options)
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 421, in _connection_for_bind
conn = self._parent._connection_for_bind(bind, execution_options)
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/session.py",
line 433, in _connection_for_bind
conn = bind._contextual_connect()
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 2305, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/engine/base.py",
line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/pool/base.py",
line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/pool/base.py",
line 809, in _checkout
result = pool._dialect.do_ping(fairy.connection)
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/mysqldb.py",
line 138, in do_ping
dbapi_connection.ping(False)
File "/usr/local/lib64/python3.6/site-packages/pymysql/connections.py",
line 534, in ping
self._execute_command(COMMAND.COM_PING, "")
File "/usr/local/lib64/python3.6/site-packages/pymysql/connections.py",
line 763, in _execute_command
self._write_bytes(packet)
File "/usr/local/lib64/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 0x7f4c393a6ea0>
Traceback (most recent call last):
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/pool/base.py",
line 506, in <lambda>
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/pool/base.py",
line 706, in _finalize_fairy
File "/usr/lib64/python3.6/logging/__init__.py", line 1337, in error
File "/usr/lib64/python3.6/logging/__init__.py", line 1444, in _log
File "/usr/lib64/python3.6/logging/__init__.py", line 1454, in handle
File "/usr/lib64/python3.6/logging/__init__.py", line 1516, in callHandlers
File "/usr/lib64/python3.6/logging/__init__.py", line 865, in handle
File "/usr/lib64/python3.6/logging/__init__.py", line 1071, in emit
File "/usr/lib64/python3.6/logging/__init__.py", line 1061, in _open
airflow-scheduler.out
Traceback (most recent call last):
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/pool/base.py",
line 697, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/pool/base.py",
line 893, in _reset
pool._dialect.do_rollback(self)
File
"/usr/local/lib64/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py",
line 2374, in do_rollback
dbapi_connection.rollback()
File "/usr/local/lib64/python3.6/site-packages/pymysql/connections.py",
line 431, in rollback
self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
File "/usr/local/lib64/python3.6/site-packages/pymysql/connections.py",
line 763, in _execute_command
self._write_bytes(packet)
File "/usr/local/lib64/python3.6/site-packages/pymysql/connections.py",
line 703, in _write_bytes
self._sock.settimeout(self._write_timeout)
OSError: [Errno 9] Bad file descriptor
----------------------------------------------------------------
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:
[email protected]
