Backend container SQLAlchemy error with docker compose up -d

[fanpeng-kong]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched in the documentation/README.
• I already searched in Google "How to do X" and didn't find any information.
• I already read and followed all the tutorial in the docs/README and didn't find an answer.

Commit to Help

• I commit to help with one of those options 👆

Example Code

docker compose up -d

Description

I followed instructions on the master branch (commit) to modify the .env file and run the command docker compose up -d. However, the backend contained run into a SQLAlchemy error sqlalchemy.exc.OperationalError: (psycopg.OperationalError) [Errno -2] Name or service not known.

All the other containers run well and I can access them through the endpoints. I tried both the localhost and localhost with a custom domain url options and the problem persists.

Operating System

Linux

Operating System Details

Ubuntu 22.04

Python Version

3.11.9

Additional Context

Output from docker compose logs backend:

studio-backend-1  | Checking for script in /app/prestart.sh
studio-backend-1  | Running script /app/prestart.sh
studio-backend-1  | INFO:__main__:Initializing service
studio-backend-1  | INFO:__main__:Starting call to '__main__.init', this is the 1st time calling it.
studio-backend-1  | INFO:__main__:Service finished initializing
studio-backend-1  | Traceback (most recent call last):
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
studio-backend-1  |     self._dbapi_connection = engine.raw_connection()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3303, in raw_connection
studio-backend-1  |     return self.pool.connect()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 449, in connect
studio-backend-1  |     return _ConnectionFairy._checkout(self)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
studio-backend-1  |     fairy = _ConnectionRecord.checkout(pool)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
studio-backend-1  |     rec = pool._do_get()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 308, in _do_get
studio-backend-1  |     return self._create_connection()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
studio-backend-1  |     return _ConnectionRecord(self)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 674, in __init__
studio-backend-1  |     self.__connect()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
studio-backend-1  |     with util.safe_reraise():
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
studio-backend-1  |     raise exc_value.with_traceback(exc_tb)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
studio-backend-1  |     self.dbapi_connection = connection = pool._invoke_creator(self)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 643, in connect
studio-backend-1  |     return dialect.connect(*cargs, **cparams)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
studio-backend-1  |     return self.loaded_dbapi.connect(*cargs, **cparams)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/psycopg/connection.py", line 728, in connect
studio-backend-1  |     attempts = conninfo_attempts(params)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/psycopg/_conninfo_attempts.py", line 45, in conninfo_attempts
studio-backend-1  |     raise e.OperationalError(str(last_exc))
studio-backend-1  | psycopg.OperationalError: [Errno -2] Name or service not known
studio-backend-1  | 
studio-backend-1  | The above exception was the direct cause of the following exception:
studio-backend-1  | 
studio-backend-1  | Traceback (most recent call last):
studio-backend-1  |   File "/usr/local/bin/alembic", line 8, in <module>
studio-backend-1  |     sys.exit(main())
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 641, in main
studio-backend-1  |     CommandLine(prog=prog).main(argv=argv)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 631, in main
studio-backend-1  |     self.run_cmd(cfg, options)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/alembic/config.py", line 608, in run_cmd
studio-backend-1  |     fn(
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 403, in upgrade
studio-backend-1  |     script.run_env()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 583, in run_env
studio-backend-1  |     util.load_python_file(self.dir, "env.py")
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
studio-backend-1  |     module = load_module_py(module_id, path)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
studio-backend-1  |     spec.loader.exec_module(module)  # type: ignore
studio-backend-1  |   File "<frozen importlib._bootstrap_external>", line 883, in exec_module
studio-backend-1  |   File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
studio-backend-1  |   File "/app/app/alembic/env.py", line 88, in <module>
studio-backend-1  |     run_migrations_online()
studio-backend-1  |   File "/app/app/alembic/env.py", line 76, in run_migrations_online
studio-backend-1  |     with connectable.connect() as connection:
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3279, in connect
studio-backend-1  |     return self._connection_cls(self)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
studio-backend-1  |     Connection._handle_dbapi_exception_noconnection(
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2443, in _handle_dbapi_exception_noconnection
studio-backend-1  |     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
studio-backend-1  |     self._dbapi_connection = engine.raw_connection()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3303, in raw_connection
studio-backend-1  |     return self.pool.connect()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 449, in connect
studio-backend-1  |     return _ConnectionFairy._checkout(self)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
studio-backend-1  |     fairy = _ConnectionRecord.checkout(pool)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
studio-backend-1  |     rec = pool._do_get()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 308, in _do_get
studio-backend-1  |     return self._create_connection()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
studio-backend-1  |     return _ConnectionRecord(self)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 674, in __init__
studio-backend-1  |     self.__connect()
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
studio-backend-1  |     with util.safe_reraise():
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
studio-backend-1  |     raise exc_value.with_traceback(exc_tb)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
studio-backend-1  |     self.dbapi_connection = connection = pool._invoke_creator(self)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 643, in connect
studio-backend-1  |     return dialect.connect(*cargs, **cparams)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
studio-backend-1  |     return self.loaded_dbapi.connect(*cargs, **cparams)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/psycopg/connection.py", line 728, in connect
studio-backend-1  |     attempts = conninfo_attempts(params)
studio-backend-1  |   File "/usr/local/lib/python3.10/site-packages/psycopg/_conninfo_attempts.py", line 45, in conninfo_attempts
studio-backend-1  |     raise e.OperationalError(str(last_exc))
studio-backend-1  | sqlalchemy.exc.OperationalError: (psycopg.OperationalError) [Errno -2] Name or service not known
studio-backend-1  | (Background on this error at: https://sqlalche.me/e/20/e3q8)

[fanpeng-kong]

The problem was gone after I restarted the docker containers and this behavior was consistent on two machines. I suspect the causes is related to DB initialization but am not 100% sure. Closing this discussion for now!