n-lavrenko/.log

## .log
nikita@MBP-Nikita gait-backend % docker-compose up
WARN[0000] The "RFook9WPRmDlk9rEOb" variable is not set. Defaulting to a blank string.
[+] Building 2.5s (15/15) FINISHED
 => [gait-backend-api internal] load build definition from Dockerfile                                                                                                                                                                                                    0.0s
 => => transferring dockerfile: 32B                                                                                                                                                                                                                                      0.0s
 => [gait-backend-db internal] load build definition from Dockerfile                                                                                                                                                                                                     0.0s
 => => transferring dockerfile: 31B                                                                                                                                                                                                                                      0.0s
 => [gait-backend-api internal] load .dockerignore                                                                                                                                                                                                                       0.0s
 => => transferring context: 2B                                                                                                                                                                                                                                          0.0s
 => [gait-backend-db internal] load .dockerignore                                                                                                                                                                                                                        0.0s
 => => transferring context: 2B                                                                                                                                                                                                                                          0.0s
 => [gait-backend-api internal] load metadata for docker.io/library/python:3.9                                                                                                                                                                                           0.7s
 => [gait-backend-db internal] load metadata for docker.io/library/postgres:15.1                                                                                                                                                                                         2.3s
 => [gait-backend-api internal] load build context                                                                                                                                                                                                                       0.0s
 => => transferring context: 281B                                                                                                                                                                                                                                        0.0s
 => [gait-backend-api 1/4] FROM docker.io/library/python:3.9@sha256:07aef4b700157bb87fa4cb80b1bb0f389c9557a83161d91521abb78d5d412e29                                                                                                                                     0.0s
 => CACHED [gait-backend-api 2/4] COPY . /app/api                                                                                                                                                                                                                        0.0s
 => CACHED [gait-backend-api 3/4] WORKDIR /app                                                                                                                                                                                                                           0.0s
 => CACHED [gait-backend-api 4/4] RUN pip install -r api/requirements.txt                                                                                                                                                                                                0.0s
 => [gait-backend-db] exporting to image                                                                                                                                                                                                                                 0.0s
 => => exporting layers                                                                                                                                                                                                                                                  0.0s
 => => writing image sha256:47b8ac4c3c71d70001d52b46ed3f2bb8342a4cc64e9b2567e81d37e920e00aed                                                                                                                                                                             0.0s
 => => naming to docker.io/library/gait-backend-api                                                                                                                                                                                                                      0.0s
 => => writing image sha256:57b25729f3f63e31b34a5e9e0a4692540770cdfed917eb970024a9a108ac2832                                                                                                                                                                             0.0s
 => => naming to docker.io/library/gait-backend-db                                                                                                                                                                                                                       0.0s
 => [gait-backend-db internal] load build context                                                                                                                                                                                                                        0.0s
 => => transferring context: 158B                                                                                                                                                                                                                                        0.0s
 => [gait-backend-db 1/2] FROM docker.io/library/postgres:15.1@sha256:8156b132fec14c313ab57b4e97e94ee5d347cc2c7d7f6d00f169b4c88f117190                                                                                                                                   0.0s
 => => resolve docker.io/library/postgres:15.1@sha256:8156b132fec14c313ab57b4e97e94ee5d347cc2c7d7f6d00f169b4c88f117190                                                                                                                                                   0.0s
 => CACHED [gait-backend-db 2/2] COPY ./init_db/ /docker-entrypoint-initdb.d/                                                                                                                                                                                            0.0s

Use 'docker scan' to run Snyk tests against images to find vulnerabilities and learn how to fix them
[+] Running 3/0
 ⠿ Network gait-backend_default  Created                                                                                                                                                                                                                                 0.0s
 ⠿ Container gaitdb              Created                                                                                                                                                                                                                                 0.0s
 ⠿ Container gaitapi             Created                                                                                                                                                                                                                                 0.0s
Attaching to gaitapi, gaitdb
gaitdb   | The files belonging to this database system will be owned by user "postgres".
gaitdb   | This user must also own the server process.
gaitdb   |
gaitdb   | The database cluster will be initialized with locale "en_US.utf8".
gaitdb   | The default database encoding has accordingly been set to "UTF8".
gaitdb   | The default text search configuration will be set to "english".
gaitdb   |
gaitdb   | Data page checksums are disabled.
gaitdb   |
gaitdb   | fixing permissions on existing directory /var/lib/postgresql/data ... ok
gaitdb   | creating subdirectories ... ok
gaitdb   | selecting dynamic shared memory implementation ... posix
gaitdb   | selecting default max_connections ... 100
gaitdb   | selecting default shared_buffers ... 128MB
gaitdb   | selecting default time zone ... Etc/UTC
gaitdb   | creating configuration files ... ok
gaitdb   | running bootstrap script ... ok
gaitdb   | performing post-bootstrap initialization ... ok
gaitapi  | Traceback (most recent call last):
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
gaitapi  |     return fn()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 325, in connect
gaitapi  |     return _ConnectionFairy._checkout(self)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 888, in _checkout
gaitapi  |     fairy = _ConnectionRecord.checkout(pool)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 491, in checkout
gaitapi  |     rec = pool._do_get()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
gaitapi  |     self._dec_overflow()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
gaitapi  |     compat.raise_(
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
gaitapi  |     raise exception
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
gaitapi  |     return self._create_connection()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 271, in _create_connection
gaitapi  |     return _ConnectionRecord(self)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 386, in __init__
gaitapi  |     self.__connect()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 685, in __connect
gaitapi  |     pool.logger.debug("Error on connect(): %s", e)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
gaitapi  |     compat.raise_(
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
gaitapi  |     raise exception
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 680, in __connect
gaitapi  |     self.dbapi_connection = connection = pool._invoke_creator(self)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
gaitapi  |     return dialect.connect(*cargs, **cparams)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
gaitapi  |     return self.dbapi.connect(*cargs, **cparams)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
gaitapi  |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
gaitapi  | psycopg2.OperationalError: could not connect to server: Connection refused
gaitapi  |      Is the server running on host "gaitdb" (172.18.0.2) and accepting
gaitapi  |      TCP/IP connections on port 5432?
gaitapi  |
gaitapi  |
gaitapi  | The above exception was the direct cause of the following exception:
gaitapi  |
gaitapi  | Traceback (most recent call last):
gaitapi  |   File "/app/./api/app.py", line 6, in <module>
gaitapi  |     db.reflect()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/flask_sqlalchemy/extension.py", line 903, in reflect
gaitapi  |     self._call_for_binds(bind_key, "reflect")
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/flask_sqlalchemy/extension.py", line 849, in _call_for_binds
gaitapi  |     getattr(metadata, op_name)(bind=engine)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/schema.py", line 4842, in reflect
gaitapi  |     with inspection.inspect(bind)._inspection_context() as insp:
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/inspection.py", line 64, in inspect
gaitapi  |     ret = reg(subject)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line 182, in _engine_insp
gaitapi  |     return Inspector._construct(Inspector._init_engine, bind)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line 117, in _construct
gaitapi  |     init(self, bind)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line 128, in _init_engine
gaitapi  |     engine.connect().close()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3315, in connect
gaitapi  |     return self._connection_cls(self, close_with_result=close_with_result)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
gaitapi  |     else engine.raw_connection()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3394, in raw_connection
gaitapi  |     return self._wrap_pool_connect(self.pool.connect, _connection)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3364, in _wrap_pool_connect
gaitapi  |     Connection._handle_dbapi_exception_noconnection(
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2198, in _handle_dbapi_exception_noconnection
gaitapi  |     util.raise_(
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
gaitapi  |     raise exception
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
gaitapi  |     return fn()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 325, in connect
gaitapi  |     return _ConnectionFairy._checkout(self)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 888, in _checkout
gaitapi  |     fairy = _ConnectionRecord.checkout(pool)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 491, in checkout
gaitapi  |     rec = pool._do_get()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
gaitapi  |     self._dec_overflow()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
gaitapi  |     compat.raise_(
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
gaitapi  |     raise exception
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
gaitapi  |     return self._create_connection()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 271, in _create_connection
gaitapi  |     return _ConnectionRecord(self)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 386, in __init__
gaitapi  |     self.__connect()
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 685, in __connect
gaitapi  |     pool.logger.debug("Error on connect(): %s", e)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
gaitapi  |     compat.raise_(
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
gaitapi  |     raise exception
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 680, in __connect
gaitapi  |     self.dbapi_connection = connection = pool._invoke_creator(self)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
gaitapi  |     return dialect.connect(*cargs, **cparams)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
gaitapi  |     return self.dbapi.connect(*cargs, **cparams)
gaitapi  |   File "/usr/local/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
gaitapi  |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
gaitapi  | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused
gaitapi  |      Is the server running on host "gaitdb" (172.18.0.2) and accepting
gaitapi  |      TCP/IP connections on port 5432?
gaitapi  |
gaitapi  | (Background on this error at: https://sqlalche.me/e/14/e3q8)
gaitdb   | syncing data to disk ... ok
gaitdb   |
gaitdb   | initdb: warning: enabling "trust" authentication for local connections
gaitdb   | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
gaitdb   |
gaitdb   | Success. You can now start the database server using:
gaitdb   |
gaitdb   |     pg_ctl -D /var/lib/postgresql/data -l logfile start
gaitdb   |
gaitdb   | waiting for server to start....2022-12-22 10:05:11.781 UTC [48] LOG:  starting PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
gaitdb   | 2022-12-22 10:05:11.782 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
gaitdb   | 2022-12-22 10:05:11.785 UTC [51] LOG:  database system was shut down at 2022-12-22 10:05:11 UTC
gaitdb   | 2022-12-22 10:05:11.788 UTC [48] LOG:  database system is ready to accept connections
gaitapi exited with code 1
gaitdb   |  done
gaitdb   | server started
gaitdb   | CREATE DATABASE
gaitdb   |
gaitdb   |
gaitdb   | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/001-init-user-db.sh
gaitdb   | CREATE ROLE
gaitdb   | ALTER ROLE
gaitdb   | GRANT
gaitdb   |
gaitdb   | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/002-ddl.sh
gaitdb   | CREATE SCHEMA
gaitdb   | CREATE TABLE
gaitdb   | CREATE TABLE
gaitdb   |
gaitdb   | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/003-init-data.sh
gaitdb   | INSERT 0 1
gaitdb   | INSERT 0 3
gaitdb   |
gaitdb   | waiting for server to shut down....2022-12-22 10:05:12.062 UTC [48] LOG:  received fast shutdown request
gaitdb   | 2022-12-22 10:05:12.063 UTC [48] LOG:  aborting any active transactions
gaitdb   | 2022-12-22 10:05:12.067 UTC [48] LOG:  background worker "logical replication launcher" (PID 54) exited with exit code 1
gaitdb   | 2022-12-22 10:05:12.068 UTC [49] LOG:  shutting down
gaitdb   | 2022-12-22 10:05:12.069 UTC [49] LOG:  checkpoint starting: shutdown immediate
gaitdb   | 2022-12-22 10:05:12.098 UTC [49] LOG:  checkpoint complete: wrote 944 buffers (5.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.012 s, sync=0.016 s, total=0.030 s; sync files=266, longest=0.004 s, average=0.001 s; distance=4260 kB, estimate=4260 kB
gaitdb   | 2022-12-22 10:05:12.107 UTC [48] LOG:  database system is shut down
gaitdb   |  done
gaitdb   | server stopped
gaitdb   |
gaitdb   | PostgreSQL init process complete; ready for start up.
gaitdb   |
gaitdb   | 2022-12-22 10:05:12.178 UTC [1] LOG:  starting PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
gaitdb   | 2022-12-22 10:05:12.178 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
gaitdb   | 2022-12-22 10:05:12.178 UTC [1] LOG:  listening on IPv6 address "::", port 5432
gaitdb   | 2022-12-22 10:05:12.179 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
gaitdb   | 2022-12-22 10:05:12.183 UTC [69] LOG:  database system was shut down at 2022-12-22 10:05:12 UTC
gaitdb   | 2022-12-22 10:05:12.186 UTC [1] LOG:  database system is ready to accept connections
gaitapi  |  * Serving Flask app 'api'
gaitapi  |  * Debug mode: off
gaitapi  | WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
gaitapi  |  * Running on all addresses (0.0.0.0)
gaitapi  |  * Running on http://127.0.0.1:5000
gaitapi  |  * Running on http://172.18.0.3:5000
gaitapi  | Press CTRL+C to quit
	nikita@MBP-Nikita gait-backend % docker-compose up
	WARN[0000] The "RFook9WPRmDlk9rEOb" variable is not set. Defaulting to a blank string.
	[+] Building 2.5s (15/15) FINISHED
	=> [gait-backend-api internal] load build definition from Dockerfile 0.0s
	=> => transferring dockerfile: 32B 0.0s
	=> [gait-backend-db internal] load build definition from Dockerfile 0.0s
	=> => transferring dockerfile: 31B 0.0s
	=> [gait-backend-api internal] load .dockerignore 0.0s
	=> => transferring context: 2B 0.0s
	=> [gait-backend-db internal] load .dockerignore 0.0s
	=> => transferring context: 2B 0.0s
	=> [gait-backend-api internal] load metadata for docker.io/library/python:3.9 0.7s
	=> [gait-backend-db internal] load metadata for docker.io/library/postgres:15.1 2.3s
	=> [gait-backend-api internal] load build context 0.0s
	=> => transferring context: 281B 0.0s
	=> [gait-backend-api 1/4] FROM docker.io/library/python:3.9@sha256:07aef4b700157bb87fa4cb80b1bb0f389c9557a83161d91521abb78d5d412e29 0.0s
	=> CACHED [gait-backend-api 2/4] COPY . /app/api 0.0s
	=> CACHED [gait-backend-api 3/4] WORKDIR /app 0.0s
	=> CACHED [gait-backend-api 4/4] RUN pip install -r api/requirements.txt 0.0s
	=> [gait-backend-db] exporting to image 0.0s
	=> => exporting layers 0.0s
	=> => writing image sha256:47b8ac4c3c71d70001d52b46ed3f2bb8342a4cc64e9b2567e81d37e920e00aed 0.0s
	=> => naming to docker.io/library/gait-backend-api 0.0s
	=> => writing image sha256:57b25729f3f63e31b34a5e9e0a4692540770cdfed917eb970024a9a108ac2832 0.0s
	=> => naming to docker.io/library/gait-backend-db 0.0s
	=> [gait-backend-db internal] load build context 0.0s
	=> => transferring context: 158B 0.0s
	=> [gait-backend-db 1/2] FROM docker.io/library/postgres:15.1@sha256:8156b132fec14c313ab57b4e97e94ee5d347cc2c7d7f6d00f169b4c88f117190 0.0s
	=> => resolve docker.io/library/postgres:15.1@sha256:8156b132fec14c313ab57b4e97e94ee5d347cc2c7d7f6d00f169b4c88f117190 0.0s
	=> CACHED [gait-backend-db 2/2] COPY ./init_db/ /docker-entrypoint-initdb.d/ 0.0s

	Use 'docker scan' to run Snyk tests against images to find vulnerabilities and learn how to fix them
	[+] Running 3/0
	⠿ Network gait-backend_default Created 0.0s
	⠿ Container gaitdb Created 0.0s
	⠿ Container gaitapi Created 0.0s
	Attaching to gaitapi, gaitdb
	gaitdb \| The files belonging to this database system will be owned by user "postgres".
	gaitdb \| This user must also own the server process.
	gaitdb \|
	gaitdb \| The database cluster will be initialized with locale "en_US.utf8".
	gaitdb \| The default database encoding has accordingly been set to "UTF8".
	gaitdb \| The default text search configuration will be set to "english".
	gaitdb \|
	gaitdb \| Data page checksums are disabled.
	gaitdb \|
	gaitdb \| fixing permissions on existing directory /var/lib/postgresql/data ... ok
	gaitdb \| creating subdirectories ... ok
	gaitdb \| selecting dynamic shared memory implementation ... posix
	gaitdb \| selecting default max_connections ... 100
	gaitdb \| selecting default shared_buffers ... 128MB
	gaitdb \| selecting default time zone ... Etc/UTC
	gaitdb \| creating configuration files ... ok
	gaitdb \| running bootstrap script ... ok
	gaitdb \| performing post-bootstrap initialization ... ok
	gaitapi \| Traceback (most recent call last):
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
	gaitapi \| return fn()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 325, in connect
	gaitapi \| return _ConnectionFairy._checkout(self)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 888, in _checkout
	gaitapi \| fairy = _ConnectionRecord.checkout(pool)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 491, in checkout
	gaitapi \| rec = pool._do_get()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
	gaitapi \| self._dec_overflow()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
	gaitapi \| compat.raise_(
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
	gaitapi \| raise exception
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
	gaitapi \| return self._create_connection()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 271, in _create_connection
	gaitapi \| return _ConnectionRecord(self)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 386, in __init__
	gaitapi \| self.__connect()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 685, in __connect
	gaitapi \| pool.logger.debug("Error on connect(): %s", e)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
	gaitapi \| compat.raise_(
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
	gaitapi \| raise exception
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 680, in __connect
	gaitapi \| self.dbapi_connection = connection = pool._invoke_creator(self)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
	gaitapi \| return dialect.connect(cargs, *cparams)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
	gaitapi \| return self.dbapi.connect(cargs, *cparams)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
	gaitapi \| conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
	gaitapi \| psycopg2.OperationalError: could not connect to server: Connection refused
	gaitapi \| Is the server running on host "gaitdb" (172.18.0.2) and accepting
	gaitapi \| TCP/IP connections on port 5432?
	gaitapi \|
	gaitapi \|
	gaitapi \| The above exception was the direct cause of the following exception:
	gaitapi \|
	gaitapi \| Traceback (most recent call last):
	gaitapi \| File "/app/./api/app.py", line 6, in <module>
	gaitapi \| db.reflect()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/flask_sqlalchemy/extension.py", line 903, in reflect
	gaitapi \| self._call_for_binds(bind_key, "reflect")
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/flask_sqlalchemy/extension.py", line 849, in _call_for_binds
	gaitapi \| getattr(metadata, op_name)(bind=engine)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/schema.py", line 4842, in reflect
	gaitapi \| with inspection.inspect(bind)._inspection_context() as insp:
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/inspection.py", line 64, in inspect
	gaitapi \| ret = reg(subject)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line 182, in _engine_insp
	gaitapi \| return Inspector._construct(Inspector._init_engine, bind)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line 117, in _construct
	gaitapi \| init(self, bind)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line 128, in _init_engine
	gaitapi \| engine.connect().close()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3315, in connect
	gaitapi \| return self._connection_cls(self, close_with_result=close_with_result)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
	gaitapi \| else engine.raw_connection()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3394, in raw_connection
	gaitapi \| return self._wrap_pool_connect(self.pool.connect, _connection)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3364, in _wrap_pool_connect
	gaitapi \| Connection._handle_dbapi_exception_noconnection(
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2198, in _handle_dbapi_exception_noconnection
	gaitapi \| util.raise_(
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
	gaitapi \| raise exception
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
	gaitapi \| return fn()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 325, in connect
	gaitapi \| return _ConnectionFairy._checkout(self)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 888, in _checkout
	gaitapi \| fairy = _ConnectionRecord.checkout(pool)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 491, in checkout
	gaitapi \| rec = pool._do_get()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
	gaitapi \| self._dec_overflow()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
	gaitapi \| compat.raise_(
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
	gaitapi \| raise exception
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
	gaitapi \| return self._create_connection()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 271, in _create_connection
	gaitapi \| return _ConnectionRecord(self)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 386, in __init__
	gaitapi \| self.__connect()
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 685, in __connect
	gaitapi \| pool.logger.debug("Error on connect(): %s", e)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
	gaitapi \| compat.raise_(
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
	gaitapi \| raise exception
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 680, in __connect
	gaitapi \| self.dbapi_connection = connection = pool._invoke_creator(self)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
	gaitapi \| return dialect.connect(cargs, *cparams)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
	gaitapi \| return self.dbapi.connect(cargs, *cparams)
	gaitapi \| File "/usr/local/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
	gaitapi \| conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
	gaitapi \| sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused
	gaitapi \| Is the server running on host "gaitdb" (172.18.0.2) and accepting
	gaitapi \| TCP/IP connections on port 5432?
	gaitapi \|
	gaitapi \| (Background on this error at: https://sqlalche.me/e/14/e3q8)
	gaitdb \| syncing data to disk ... ok
	gaitdb \|
	gaitdb \| initdb: warning: enabling "trust" authentication for local connections
	gaitdb \| initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
	gaitdb \|
	gaitdb \| Success. You can now start the database server using:
	gaitdb \|
	gaitdb \| pg_ctl -D /var/lib/postgresql/data -l logfile start
	gaitdb \|
	gaitdb \| waiting for server to start....2022-12-22 10:05:11.781 UTC [48] LOG: starting PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
	gaitdb \| 2022-12-22 10:05:11.782 UTC [48] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
	gaitdb \| 2022-12-22 10:05:11.785 UTC [51] LOG: database system was shut down at 2022-12-22 10:05:11 UTC
	gaitdb \| 2022-12-22 10:05:11.788 UTC [48] LOG: database system is ready to accept connections
	gaitapi exited with code 1
	gaitdb \| done
	gaitdb \| server started
	gaitdb \| CREATE DATABASE
	gaitdb \|
	gaitdb \|
	gaitdb \| /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/001-init-user-db.sh
	gaitdb \| CREATE ROLE
	gaitdb \| ALTER ROLE
	gaitdb \| GRANT
	gaitdb \|
	gaitdb \| /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/002-ddl.sh
	gaitdb \| CREATE SCHEMA
	gaitdb \| CREATE TABLE
	gaitdb \| CREATE TABLE
	gaitdb \|
	gaitdb \| /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/003-init-data.sh
	gaitdb \| INSERT 0 1
	gaitdb \| INSERT 0 3
	gaitdb \|
	gaitdb \| waiting for server to shut down....2022-12-22 10:05:12.062 UTC [48] LOG: received fast shutdown request
	gaitdb \| 2022-12-22 10:05:12.063 UTC [48] LOG: aborting any active transactions
	gaitdb \| 2022-12-22 10:05:12.067 UTC [48] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1
	gaitdb \| 2022-12-22 10:05:12.068 UTC [49] LOG: shutting down
	gaitdb \| 2022-12-22 10:05:12.069 UTC [49] LOG: checkpoint starting: shutdown immediate
	gaitdb \| 2022-12-22 10:05:12.098 UTC [49] LOG: checkpoint complete: wrote 944 buffers (5.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.012 s, sync=0.016 s, total=0.030 s; sync files=266, longest=0.004 s, average=0.001 s; distance=4260 kB, estimate=4260 kB
	gaitdb \| 2022-12-22 10:05:12.107 UTC [48] LOG: database system is shut down
	gaitdb \| done
	gaitdb \| server stopped
	gaitdb \|
	gaitdb \| PostgreSQL init process complete; ready for start up.
	gaitdb \|
	gaitdb \| 2022-12-22 10:05:12.178 UTC [1] LOG: starting PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
	gaitdb \| 2022-12-22 10:05:12.178 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
	gaitdb \| 2022-12-22 10:05:12.178 UTC [1] LOG: listening on IPv6 address "::", port 5432
	gaitdb \| 2022-12-22 10:05:12.179 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
	gaitdb \| 2022-12-22 10:05:12.183 UTC [69] LOG: database system was shut down at 2022-12-22 10:05:12 UTC
	gaitdb \| 2022-12-22 10:05:12.186 UTC [1] LOG: database system is ready to accept connections
	gaitapi \| * Serving Flask app 'api'
	gaitapi \| * Debug mode: off
	gaitapi \| WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
	gaitapi \| * Running on all addresses (0.0.0.0)
	gaitapi \| * Running on http://127.0.0.1:5000
	gaitapi \| * Running on http://172.18.0.3:5000
	gaitapi \| Press CTRL+C to quit