sudipto9 commented on issue #17120:
URL: https://github.com/apache/airflow/issues/17120#issuecomment-889663324
@potiuk I have copied the code in the external Libraries's
dist-packages/airflow/cli/commands folder. After that Iran below commands to
start airflow again.
airflow db init
airflow webserver -D
airflow scheduler -D
but the problem still exists. Please do find the err log below.
raceback (most recent call last):
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py",
line 2336, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py",
line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py",
line 809, in _checkout
result = pool._dialect.do_ping(fairy.connection)
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line
575, in do_ping
cursor.execute(self._dialect_specific_select_one)
psycopg2.OperationalError: SSL SYSCALL error: Socket operation on non-socket
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/bin/airflow", line 8, in <module>
sys.exit(main())
File "/usr/local/lib/python3.8/dist-packages/airflow/__main__.py", line
40, in main
args.func(args)
File "/usr/local/lib/python3.8/dist-packages/airflow/cli/cli_parser.py",
line 48, in command
return func(*args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/airflow/utils/cli.py", line
91, in wrapper
return f(*args, **kwargs)
File
"/usr/local/lib/python3.8/dist-packages/airflow/cli/commands/scheduler_command.py",
line 54, in scheduler
job.run()
File "/usr/local/lib/python3.8/dist-packages/airflow/jobs/base_job.py",
line 241, in run
session.commit()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 1046, in commit
self.transaction.commit()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 504, in commit
self._prepare_impl()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 483, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 2540, in flush
self._flush(objects)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 2682, in _flush
transaction.rollback(_capture_exception=True)
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/langhelpers.py", line
68, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py",
line 182, in raise_
raise exception
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 2642, in _flush
flush_context.execute()
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/unitofwork.py", line
422, in execute
rec.execute(self)
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/unitofwork.py", line
586, in execute
persistence.save_obj(
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/persistence.py", line
205, in save_obj
for (
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/persistence.py", line
373, in _organize_states_for_save
for state, dict_, mapper, connection in _connections_for_states(
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/persistence.py", line
1602, in _connections_for_states
connection = uowtransaction.transaction.connection(base_mapper)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 314, in connection
return self._connection_for_bind(bind, execution_options)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 421, in _connection_for_bind
conn = self._parent._connection_for_bind(bind, execution_options)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py",
line 433, in _connection_for_bind
conn = bind._contextual_connect()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py",
line 2302, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py",
line 2339, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py",
line 1583, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py",
line 182, in raise_
raise exception
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py",
line 2336, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py",
line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py",
line 809, in _checkout
result = pool._dialect.do_ping(fairy.connection)
File
"/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line
575, in do_ping
cursor.execute(self._dialect_specific_select_one)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL SYSCALL
error: Socket operation on non-socket
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Also when I use SUDO airflow webserver -D, it is not starting the webserver
though getting webserver start msg.
2021-07-30 10:40:45,893] {backend.py:193} INFO - Loading KWallet
[2021-07-30 10:40:45,900] {backend.py:193} INFO - Loading SecretService
[2021-07-30 10:40:45,902] {backend.py:193} INFO - Loading Windows
[2021-07-30 10:40:45,903] {backend.py:193} INFO - Loading chainer
[2021-07-30 10:40:45,903] {backend.py:193} INFO - Loading macOS
[2021-07-30 10:40:47,022] {arrow_result.pyx:0} INFO - Failed to import
optional packages, pyarrow
____________ _____________
____ |__( )_________ __/__ /________ __
____ /| |_ /__ ___/_ /_ __ /_ __ \_ | /| / /
___ ___ | / _ / _ __/ _ / / /_/ /_ |/ |/ /
_/_/ |_/_/ /_/ /_/ /_/ \____/____/|__/
[2021-07-30 10:40:47,087] {dagbag.py:496} INFO - Filling up the DagBag from
/dev/null
[2021-07-30 10:40:47,155] {manager.py:788} WARNING - No user yet created,
use flask fab command to do it.
Running the Gunicorn Server with:
Workers: 4 sync
Host: 0.0.0.0:8080
Timeout: 120
Logfiles: - -
Access Logformat:
On the contrary when using scheduler -D, not start the scheduler.
I am not sure if I am making any mistake.
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
