Hi,
thanks to antonios, I solved the problem for hops::ndb .
I am doing a fresh installation.
I am installing hopswork by launching on my own ./bin/karamel for on-premises platform.
Now I have a problem on hops_airflow::default . The log gives me that:
[sudo] password for nikokks: Starting Chef Infra Client, version 15.7.32e[0m
resolving cookbooks for run list: ["hops_airflow::default"]e[0m
Synchronizing Cookbooks:e[0m
-
…
e[0m MySQLdb._exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'nikokks' (111)")
e[0m
e[0m The above exception was the direct cause of the following exception:
e[0m
e[0m Traceback (most recent call last):
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/bin/airflow", line 32, in <module>
e[0m args.func(args)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/utils/cli.py", line 74, in wrapper
e[0m return f(*args, **kwargs)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/bin/cli.py", line 1091, in upgradedb
e[0m db.upgradedb()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/utils/db.py", line 346, in upgradedb
e[0m command.upgrade(config, 'heads')
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/command.py", line 174, in upgrade
e[0m script.run_env()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/script/base.py", line 416, in run_env
e[0m util.load_python_file(self.dir, 'env.py')
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
e[0m module = load_module_py(module_id, path)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/util/compat.py", line 68, in load_module_py
e[0m module_id, path).load_module(module_id)
e[0m File "<frozen importlib._bootstrap_external>", line 399, in _check_name_wrapper
e[0m File "<frozen importlib._bootstrap_external>", line 823, in load_module
e[0m File "<frozen importlib._bootstrap_external>", line 682, in load_module
e[0m File "<frozen importlib._bootstrap>", line 265, in _load_module_shim
e[0m File "<frozen importlib._bootstrap>", line 684, in _load
e[0m File "<frozen importlib._bootstrap>", line 665, in _load_unlocked
e[0m File "<frozen importlib._bootstrap_external>", line 678, in exec_module
e[0m File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/migrations/env.py", line 92, in <module>
e[0m run_migrations_online()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/migrations/env.py", line 78, in run_migrations_online
e[0m with connectable.connect() as connection:
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2171, in connect
e[0m return self._connection_cls(self, **kwargs)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 103, in __init__
e[0m else engine.raw_connection()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2259, in raw_connection
e[0m self.pool.unique_connection, _connection
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2232, in _wrap_pool_connect
e[0m e, dialect, self
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1528, in _handle_dbapi_exception_noconnection
e[0m util.raise_from_cause(sqlalchemy_exception, exc_info)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
e[0m reraise(type(exception), exception, tb=exc_tb, cause=cause)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
e[0m raise value.with_traceback(tb)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2228, in _wrap_pool_connect
e[0m return fn()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 374, in unique_connection
e[0m return _ConnectionFairy._checkout(self)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 831, in _checkout
e[0m fairy = _ConnectionRecord.checkout(pool)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 563, in checkout
e[0m rec = pool._do_get()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1259, in _do_get
e[0m self._dec_overflow()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
e[0m compat.reraise(exc_type, exc_value, exc_tb)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
e[0m raise value
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1256, in _do_get
e[0m return self._create_connection()
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 379, in _create_connection
e[0m return _ConnectionRecord(self)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 508, in __init__
e[0m self.__connect(first_connect_check=True)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 710, in __connect
e[0m connection = pool._invoke_creator(self)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
e[0m return dialect.connect(*cargs, **cparams)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 437, in connect
e[0m return self.dbapi.connect(*cargs, **cparams)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/__init__.py", line 84, in Connect
e[0m return Connection(*args, **kwargs)
e[0m File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/connections.py", line 179, in __init__
e[0m super(Connection, self).__init__(*args, **kwargs2)
e[0m sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, "Can't connect to MySQL server on 'nikokks' (111)") (Background on this error at: http://sqlalche.me/e/e3q8)
e[0m ---- End output of "bash" "/tmp/chef-script20200420-13403-37y520" ----
e[0m Ran "bash" "/tmp/chef-script20200420-13403-37y520" returned 1e[0m
e[0m Resource Declaration:e[0m
---------------------e[0m
# In /tmp/chef-solo/cookbooks/hops_airflow/recipes/default.rb
e[0m
e[0m 65: bash 'init_airflow_db' do
e[0m 66: user node['airflow']['user']
e[0m 67: code <<-EOF
e[0m 68: set -e
e[0m 69: export AIRFLOW_HOME=#{node['airflow']['base_dir']}
e[0m 70: #{node['airflow']['bin_path']}/airflow upgradedb
e[0m 71: EOF
e[0m 72: end
e[0m 73:
e[0m
e[0m Compiled Resource:e[0m
------------------e[0m
# Declared in /tmp/chef-solo/cookbooks/hops_airflow/recipes/default.rb:65:in `from_file'
e[0m
e[0m bash("init_airflow_db") do
e[0m action [:run]
e[0m default_guard_interpreter :default
e[0m command nil
e[0m backup 5
e[0m interpreter "bash"
e[0m declared_type :bash
e[0m cookbook_name "hops_airflow"
e[0m recipe_name "default"
e[0m user "airflow"
e[0m code " set -e\n export AIRFLOW_HOME=/srv/hops/airflow\n /srv/hops/anaconda/anaconda/envs/airflow/bin/airflow upgradedb\n"
e[0m domain nil
e[0m end
e[0m
e[0m System Info:e[0m
------------e[0m
chef_version=15.7.32
e[0m platform=ubuntu
e[0m platform_version=18.04
e[0m ruby=ruby 2.6.5p114 (2019-10-01 revision 67812) [x86_64-linux]
e[0m program_name=/usr/bin/chef-solo
e[0m executable=/opt/chefdk/bin/chef-soloe[0m
e[0me[0m
Running handlers:e[0m
[2020-04-20T12:42:49+02:00] ERROR: Running exception handlers
Running handlers complete
e[0m[2020-04-20T12:42:49+02:00] ERROR: Exception handlers complete
Chef Infra Client failed. 54 resources updated in 05 minutes 30 secondse[0m
[2020-04-20T12:42:49+02:00] FATAL: Stacktrace dumped to /tmp/chef-solo/chef-stacktrace.out
[2020-04-20T12:42:49+02:00] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
[2020-04-20T12:42:49+02:00] FATAL: Mixlib::ShellOut::ShellCommandFailed: bash[init_airflow_db] (hops_airflow::default line 65) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash" "/tmp/chef-script20200420-13403-37y520" ----
STDOUT: [2020-04-20 12:42:47,726] {settings.py:174} INFO - settings.configure_orm(): Using pool settings. pool_size=5, pool_recycle=3600, pid=14766
[2020-04-20 12:42:48,343] {__init__.py:51} INFO - Using executor LocalExecutor
[2020-04-20 12:42:49,012] {cli_action_loggers.py:69} ERROR - Failed on pre-execution callback using <function default_action_log at 0x7fccac3849d8>
Traceback (most recent call last):
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2228, in _wrap_pool_connect
return fn()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 434, in connect
return _ConnectionFairy._checkout(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 831, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 563, in checkout
rec = pool._do_get()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1259, in _do_get
self._dec_overflow()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
raise value
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1256, in _do_get
return self._create_connection()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 379, in _create_connection
return _ConnectionRecord(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 508, in __init__
self.__connect(first_connect_check=True)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 710, in __connect
connection = pool._invoke_creator(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 437, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/__init__.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/connections.py", line 179, in __init__
super(Connection, self).__init__(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'nikokks' (111)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/utils/cli_action_loggers.py", line 67, in on_pre_execution
cb(**kwargs)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/utils/cli_action_loggers.py", line 98, in default_action_log
session.add(log)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/contextlib.py", line 88, in __exit__
next(self.gen)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/utils/db.py", line 44, in create_session
session.commit()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1023, in commit
self.transaction.commit()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 487, in commit
self._prepare_impl()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 466, in _prepare_impl
self.session.flush()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2446, in flush
self._flush(objects)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2584, in _flush
transaction.rollback(_capture_exception=True)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
raise value
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2544, in _flush
flush_context.execute()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 416, in execute
rec.execute(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 583, in execute
uow,
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 213, in save_obj
) in _organize_states_for_save(base_mapper, states, uowtransaction):
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 374, in _organize_states_for_save
base_mapper, uowtransaction, states
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1558, in _connections_for_states
connection = uowtransaction.transaction.connection(base_mapper)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 306, in connection
return self._connection_for_bind(bind, execution_options)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 412, in _connection_for_bind
conn = self._parent._connection_for_bind(bind, execution_options)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 424, in _connection_for_bind
conn = bind.contextual_connect()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2192, in contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2232, in _wrap_pool_connect
e, dialect, self
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1528, in _handle_dbapi_exception_noconnection
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2228, in _wrap_pool_connect
return fn()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 434, in connect
return _ConnectionFairy._checkout(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 831, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 563, in checkout
rec = pool._do_get()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1259, in _do_get
self._dec_overflow()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
raise value
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1256, in _do_get
return self._create_connection()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 379, in _create_connection
return _ConnectionRecord(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 508, in __init__
self.__connect(first_connect_check=True)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 710, in __connect
connection = pool._invoke_creator(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 437, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/__init__.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/connections.py", line 179, in __init__
super(Connection, self).__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, "Can't connect to MySQL server on 'nikokks' (111)") (Background on this error at: http://sqlalche.me/e/e3q8)
DB: mysql://airflow_db:***@nikokks:3306/airflow
[2020-04-20 12:42:49,265] {db.py:338} INFO - Creating tables
STDERR: Traceback (most recent call last):
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2228, in _wrap_pool_connect
return fn()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 374, in unique_connection
return _ConnectionFairy._checkout(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 831, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 563, in checkout
rec = pool._do_get()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1259, in _do_get
self._dec_overflow()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
raise value
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1256, in _do_get
return self._create_connection()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 379, in _create_connection
return _ConnectionRecord(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 508, in __init__
self.__connect(first_connect_check=True)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 710, in __connect
connection = pool._invoke_creator(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 437, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/__init__.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/connections.py", line 179, in __init__
super(Connection, self).__init__(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'nikokks' (111)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/srv/hops/anaconda/anaconda/envs/airflow/bin/airflow", line 32, in <module>
args.func(args)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/utils/cli.py", line 74, in wrapper
return f(*args, **kwargs)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/bin/cli.py", line 1091, in upgradedb
db.upgradedb()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/utils/db.py", line 346, in upgradedb
command.upgrade(config, 'heads')
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/command.py", line 174, in upgrade
script.run_env()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/script/base.py", line 416, in run_env
util.load_python_file(self.dir, 'env.py')
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
module = load_module_py(module_id, path)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/alembic/util/compat.py", line 68, in load_module_py
module_id, path).load_module(module_id)
File "<frozen importlib._bootstrap_external>", line 399, in _check_name_wrapper
File "<frozen importlib._bootstrap_external>", line 823, in load_module
File "<frozen importlib._bootstrap_external>", line 682, in load_module
File "<frozen importlib._bootstrap>", line 265, in _load_module_shim
File "<frozen importlib._bootstrap>", line 684, in _load
File "<frozen importlib._bootstrap>", line 665, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 678, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/migrations/env.py", line 92, in <module>
run_migrations_online()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/airflow/migrations/env.py", line 78, in run_migrations_online
with connectable.connect() as connection:
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2171, in connect
return self._connection_cls(self, **kwargs)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 103, in __init__
else engine.raw_connection()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2259, in raw_connection
self.pool.unique_connection, _connection
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2232, in _wrap_pool_connect
e, dialect, self
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1528, in _handle_dbapi_exception_noconnection
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 276, in reraise
raise value.with_traceback(tb)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2228, in _wrap_pool_connect
return fn()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 374, in unique_connection
return _ConnectionFairy._checkout(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 831, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 563, in checkout
rec = pool._do_get()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1259, in _do_get
self._dec_overflow()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 67, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 277, in reraise
raise value
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 1256, in _do_get
return self._create_connection()
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 379, in _create_connection
return _ConnectionRecord(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 508, in __init__
self.__connect(first_connect_check=True)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/pool.py", line 710, in __connect
connection = pool._invoke_creator(self)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 437, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/__init__.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/srv/hops/anaconda/anaconda/envs/airflow/lib/python3.6/site-packages/MySQLdb/connections.py", line 179, in __init__
super(Connection, self).__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, "Can't connect to MySQL server on 'nikokks' (111)") (Background on this error at: http://sqlalche.me/e/e3q8)
---- End output of "bash" "/tmp/chef-script20200420-13403-37y520" ----
Ran "bash" "/tmp/chef-script20200420-13403-37y520" returned 1