docker-compose up fails on master

[jbauernberger]

Using the official instructions for recommended way to install:

$ wget https://raw.githubusercontent.com/infobyte/faraday/master/docker-compose.yaml
$ docker-compose up

results in:

Creating faraday_db    ... done
Creating faraday_redis ... done
Creating faraday_app   ... done
Attaching to faraday_db, faraday_redis, faraday_app
app_1    | Tue Aug  2 10:28:51 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 10:28:51 UTC 2022 Running migrations ...
db_1     |
db_1     | PostgreSQL Database directory appears to contain a database; Skipping initialization
db_1     |
db_1     | 2022-08-02 10:28:49.280 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1     | 2022-08-02 10:28:49.281 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1     | 2022-08-02 10:28:49.281 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1     | 2022-08-02 10:28:49.313 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-02 10:28:49.384 UTC [21] LOG:  database system was shut down at 2022-08-02 10:24:28 UTC
db_1     | 2022-08-02 10:28:49.398 UTC [1] LOG:  database system is ready to accept connections
redis_1  | 1:C 02 Aug 2022 10:28:49.374 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1  | 1:C 02 Aug 2022 10:28:49.374 # Redis version=6.2.7, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1  | 1:C 02 Aug 2022 10:28:49.374 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis_1  | 1:M 02 Aug 2022 10:28:49.375 * monotonic clock: POSIX clock_gettime
redis_1  | 1:M 02 Aug 2022 10:28:49.375 # A key '__redis__compare_helper' was added to Lua globals which is not on the globals allow list nor listed on the deny list.
redis_1  | 1:M 02 Aug 2022 10:28:49.376 * Running mode=standalone, port=6379.
redis_1  | 1:M 02 Aug 2022 10:28:49.376 # Server initialized
redis_1  | 1:M 02 Aug 2022 10:28:49.376 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1  | 1:M 02 Aug 2022 10:28:49.376 * Ready to accept connections
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 10:28:53.236 UTC [28] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 10:28:53.236 UTC [28] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 10:28:56.575 UTC [29] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 10:28:56.575 UTC [29] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
db_1     | 2022-08-02 10:29:00.276 UTC [30] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 10:29:00.276 UTC [30] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app exited with code 1
app_1    | Tue Aug  2 10:28:51 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 10:28:51 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 10:28:54 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 10:28:54 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 10:28:58 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 10:28:58 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |

[ezk06eer]

hi @jbauernberger if you are starting a fresh instance please cleanup all your volumes and delete /home/{your-user}/.faraday folder.

greets Faraday team!

[jbauernberger]

hi @ezk06eer actually this was on a fresh Debian install. Have removed ~/.faraday just in case and I can def reproduce this

[ezk06eer]

From the logs you shared we can see that this is using an existing server.ini, that means that faraday is seeing the mounted /home/faraday/.faraday/ that is in the host PC.

`app_1 | Tue Aug 2 10:28:51 UTC 2022 Using existing server.ini

`

I could reproduce the error when the connection string from a previous install is inside the users folder.

[jbauernberger]

thanks for the info. It must have been left over from a bare metal installation I tried earlier. And I did not expect that a docker container wouldn't look for things inside /home

anyway I removed everything again (docker container, the image, ~/.faraday and also /home/faraday

then running everything from scratch again:

 docker-compose up
Pulling redis (redis:6.2-alpine)...
6.2-alpine: Pulling from library/redis
530afca65e2e: Pull complete
c550a3118f41: Pull complete
9b28aced8b95: Pull complete
6b06fa84bb68: Pull complete
8a9eaf20067f: Pull complete
2d7046f40b15: Pull complete
Digest: sha256:74193d1b6277bc6d3f776ed3680c453c06b6089d6fc67eb8490b7ad45b5d7d98
Status: Downloaded newer image for redis:6.2-alpine
Pulling app (index.docker.io/faradaysec/faraday:)...
latest: Pulling from faradaysec/faraday
ac2fb615420c: Pull complete
64d0f1d7987a: Pull complete
b650c79550ec: Pull complete
d49a7ac5e6c0: Pull complete
ac10782b0843: Pull complete
b7445b0a7352: Pull complete
d3e784120811: Pull complete
9e233aad457c: Pull complete
ed4ec6d2ce48: Pull complete
0090ed00d86a: Pull complete
ea8b4388bb0e: Pull complete
f13ae5776e29: Pull complete
4ddcb70b8e41: Pull complete
b759439fd226: Pull complete
82d9837ea912: Pull complete
Digest: sha256:b72f2fc38b64e144cdf24ac252b8ca870261acc322caafa4e33137f8ae2cdecb
Status: Downloaded newer image for faradaysec/faraday:latest
Creating faraday_redis ... done
Creating faraday_db    ... done
Creating faraday_app   ... done
Attaching to faraday_db, faraday_redis, faraday_app
app_1    | Tue Aug  2 14:15:46 UTC 2022 Creating server.ini
db_1     |
db_1     | PostgreSQL Database directory appears to contain a database; Skipping initialization
db_1     |
db_1     | 2022-08-02 14:15:46.008 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1     | 2022-08-02 14:15:46.008 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1     | 2022-08-02 14:15:46.008 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1     | 2022-08-02 14:15:46.025 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-02 14:15:46.092 UTC [21] LOG:  database system was shut down at 2022-08-02 14:13:40 UTC
db_1     | 2022-08-02 14:15:46.105 UTC [1] LOG:  database system is ready to accept connections
redis_1  | 1:C 02 Aug 2022 14:15:45.994 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1  | 1:C 02 Aug 2022 14:15:45.994 # Redis version=6.2.7, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1  | 1:C 02 Aug 2022 14:15:45.994 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis_1  | 1:M 02 Aug 2022 14:15:45.994 * monotonic clock: POSIX clock_gettime
redis_1  | 1:M 02 Aug 2022 14:15:45.994 # A key '__redis__compare_helper' was added to Lua globals which is not on the globals allow list nor listed on the deny list.
redis_1  | 1:M 02 Aug 2022 14:15:45.995 * Running mode=standalone, port=6379.
redis_1  | 1:M 02 Aug 2022 14:15:45.995 # Server initialized
redis_1  | 1:M 02 Aug 2022 14:15:45.995 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1  | 1:M 02 Aug 2022 14:15:45.995 * Ready to accept connections
app_1    | Tue Aug  2 14:15:46 UTC 2022 Creating tables on database faraday...
app_1    | Creating tables
app_1    | Faraday tables already exist in the database. No tables will be created. If you want to ugprade the schema to the latest version, you should run "faraday-manage migrate".
app_1    | Tables created successfully!
app_1    | Tue Aug  2 14:15:49 UTC 2022 Creating superuser...
db_1     | 2022-08-02 14:15:50.950 UTC [29] ERROR:  relation "faraday_user" does not exist at character 923
db_1     | 2022-08-02 14:15:50.950 UTC [29] STATEMENT:  SELECT count(*) AS count_1
db_1     |  FROM (SELECT faraday_user.otp_secret AS faraday_user_otp_secret, faraday_user.id AS faraday_user_id, faraday_user.username AS faraday_user_username, faraday_user.password AS faraday_user_password, faraday_user.email AS faraday_user_email, faraday_user.name AS faraday_user_name, faraday_user.last_login_at AS faraday_user_last_login_at, faraday_user.current_login_at AS faraday_user_current_login_at, faraday_user.last_login_ip AS faraday_user_last_login_ip, faraday_user.current_login_ip AS faraday_user_current_login_ip, faraday_user.login_count AS faraday_user_login_count, faraday_user.active AS faraday_user_active, faraday_user.confirmed_at AS faraday_user_confirmed_at, faraday_user.state_otp AS faraday_user_state_otp, faraday_user.preferences AS faraday_user_preferences, faraday_user.fs_uniquifier AS faraday_user_fs_uniquifier, faraday_user.user_type AS faraday_user_user_type
db_1     |  FROM faraday_user
db_1     |  WHERE faraday_user.username = 'faraday') AS anon_1
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
app_1    |     self.dialect.do_execute(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
app_1    |     cursor.execute(statement, parameters)
app_1    | psycopg2.errors.UndefinedTable: relation "faraday_user" does not exist
app_1    | LINE 3: FROM faraday_user
app_1    |              ^
app_1    |
app_1    |
app_1    | The above exception was the direct cause of the following exception:
app_1    |
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/bin/faraday-manage", line 8, in <module>
app_1    |     sys.exit(cli())
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1130, in __call__
app_1    |     return self.main(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1055, in main
app_1    |     rv = self.invoke(ctx)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1655, in invoke
app_1    |     sub_ctx = cmd.make_context(cmd_name, args, parent=ctx)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 920, in make_context
app_1    |     self.parse_args(ctx, args)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1378, in parse_args
app_1    |     value, args = param.handle_parse_result(ctx, opts, args)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 2360, in handle_parse_result
app_1    |     value = self.process_value(ctx, value)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 2322, in process_value
app_1    |     value = self.callback(ctx, self, value)
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/manage.py", line 142, in validate_user_unique_field
app_1    |     if User.query.filter_by(**{param.name: value}).count():
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3803, in count
app_1    |     return self.from_self(col).scalar()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3523, in scalar
app_1    |     ret = self.one()
app_1    |   File "/usr/local/lib/python3.8/site-packages/nplusone/core/signals.py", line 23, in wrapped
app_1    |     ret = func(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3490, in one
app_1    |     ret = self.one_or_none()
app_1    |   File "/usr/local/lib/python3.8/site-packages/nplusone/core/signals.py", line 23, in wrapped
app_1    |     ret = func(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none
app_1    |     ret = list(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/nplusone/ext/sqlalchemy.py", line 99, in query_iter
app_1    |     ret, clone = itertools.tee(original_query_iter(self))
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
app_1    |     return self._execute_and_instances(context)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
app_1    |     result = conn.execute(querycontext.statement, self._params)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
app_1    |     return meth(self, multiparams, params)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
app_1    |     return connection._execute_clauseelement(self, multiparams, params)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
app_1    |     ret = self._execute_context(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
app_1    |     self._handle_dbapi_exception(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
app_1    |     util.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
app_1    |     self.dialect.do_execute(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
app_1    |     cursor.execute(statement, parameters)
app_1    | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "faraday_user" does not exist
app_1    | LINE 3: FROM faraday_user
app_1    |              ^
app_1    |
app_1    | [SQL: SELECT count(*) AS count_1
app_1    | FROM (SELECT faraday_user.otp_secret AS faraday_user_otp_secret, faraday_user.id AS faraday_user_id, faraday_user.username AS faraday_user_username, faraday_user.password AS faraday_user_password, faraday_user.email AS faraday_user_email, faraday_user.name AS faraday_user_name, faraday_user.last_login_at AS faraday_user_last_login_at, faraday_user.current_login_at AS faraday_user_current_login_at, faraday_user.last_login_ip AS faraday_user_last_login_ip, faraday_user.current_login_ip AS faraday_user_current_login_ip, faraday_user.login_count AS faraday_user_login_count, faraday_user.active AS faraday_user_active, faraday_user.confirmed_at AS faraday_user_confirmed_at, faraday_user.state_otp AS faraday_user_state_otp, faraday_user.preferences AS faraday_user_preferences, faraday_user.fs_uniquifier AS faraday_user_fs_uniquifier, faraday_user.user_type AS faraday_user_user_type
app_1    | FROM faraday_user
app_1    | WHERE faraday_user.username = %(username_1)s) AS anon_1]
app_1    | [parameters: {'username_1': 'faraday'}]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 14:15:52 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
db_1     | 2022-08-02 14:15:54.705 UTC [30] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:15:54.705 UTC [30] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app exited with code 1
app_1    | Tue Aug  2 14:15:56 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
db_1     | 2022-08-02 14:15:58.555 UTC [31] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:15:58.555 UTC [31] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 14:16:04.579 UTC [32] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:16:04.579 UTC [32] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | Tue Aug  2 14:16:09 UTC 2022 Running migrations ...
db_1     | 2022-08-02 14:16:11.743 UTC [33] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:16:11.743 UTC [33] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 14:16:17.917 UTC [35] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:16:17.917 UTC [35] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 14:16:26.770 UTC [36] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:16:26.770 UTC [36] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1

[aenima-x]

@jbauernberger please check that you delete the database volume.

Delete de database volume and delete again the .faraday from your home

[aenima-x]

db_1     | PostgreSQL Database directory appears to contain a database; Skipping initialization

That means that the db is already created, so the volume must be still there

[jbauernberger]

good point thanks, so this brings me to a different place:

 joachim ~/src/faraday  docker volume ls
DRIVER    VOLUME NAME
 joachim ~/src/faraday  ls -al ~/.faraday
ls: cannot access '/home/joachim/.faraday': No such file or directory
 (2) joachim ~/src/faraday  docker-compose up
Creating volume "faraday_db" with local driver
Pulling db (postgres:12.7-alpine)...
12.7-alpine: Pulling from library/postgres
29291e31a76a: Downloading [>                                                  ]  29.36kB/2.813MBb: Pulling fs layer
c7f8a1ea71cb: Downloading [=========================>                         ]     6c7f8a1ea71cb: Downloading [==================================================>]  1.2829291e31a76a: Downloading [=======================>                           ]  1.3029291e31a76a: Downloading [=================================================> ]  2.7929291e31a76a: Extracting [>                                                  ]  32.7729291e31a76a: Extracting [=========>                                         ]  557.129291e31a76a: Extracting [==============================================>    ]  2.62129291e31a76a: Extracting [==================================================>]  2.81329291e31a76a: Pull complete
c7f8a1ea71cb: Extracting [==================================================>]  1.284c7f8a1ea71cb: Extracting [==================================================>]  1.284c7f8a1ea71cb: Pull complete
64d8912b293d: Extracting [==================================================>]     1464d8912b293d: Extracting [==================================================>]     149B/149B
c5ea624bd2f9: Downloading [>                                                  ]    5364d8912b293d: Pull complete
6MB/72.31MB
c5ea624bd2f9: Downloading [==>                                                ]  3.76c5ea624bd2f9: Downloading [===>                                               ]  5.36c5ea624bd2f9: Downloading [====>                                              ]  6.43c5ea624bd2f9: Downloading [=====>                                             ]  8.05c5ea624bd2f9: Downloading [======>                                            ]   9.12MB/72.31MB
8b31ea9e78e2: Downloading [===>                                               ]     6c5ea624bd2f9: Downloading [=======>                                           ]  10.7c5ea624bd2f9: Downloading [========>                                          ]  12.3c5ea624bd2f9: Downloading [=========>                                         ]  13.9c5ea624bd2f9: Downloading [==========>                                        ]  15.5c5ea624bd2f9: Downloading [===========>                                       ]  17.1c5ea624bd2f9: Downloading [============>                                      ]  18.7c5ea624bd2f9: Downloading [=============>                                     ]  19.8c5ea624bd2f9: Downloading [==============>                                    ]  21.4c5ea624bd2f9: Downloading [===============>                                   ]  22.5c5ea624bd2f9: Downloading [================>                                  ]  23.6c5ea624bd2f9: Pull complete
8b31ea9e78e2: Pull complete
73b55a167823: Pull complete
182bdad89856: Pull complete
8106b49e33bd: Pull complete
Digest: sha256:8b4e93c283134e56936c0115e552e3dbac05f323c898b100408ed6df77f3e1b5
Status: Downloaded newer image for postgres:12.7-alpine
Pulling redis (redis:6.2-alpine)...
6.2-alpine: Pulling from library/redis
530afca65e2e: Pull complete
c550a3118f41: Pull complete
9b28aced8b95: Pull complete
6b06fa84bb68: Pull complete
8a9eaf20067f: Pull complete
2d7046f40b15: Pull complete
Digest: sha256:74193d1b6277bc6d3f776ed3680c453c06b6089d6fc67eb8490b7ad45b5d7d98
Status: Downloaded newer image for redis:6.2-alpine
Pulling app (index.docker.io/faradaysec/faraday:)...
latest: Pulling from faradaysec/faraday
ac2fb615420c: Pull complete
64d0f1d7987a: Pull complete
b650c79550ec: Pull complete
d49a7ac5e6c0: Pull complete
ac10782b0843: Pull complete
b7445b0a7352: Pull complete
d3e784120811: Pull complete
9e233aad457c: Pull complete
ed4ec6d2ce48: Pull complete
0090ed00d86a: Pull complete
ea8b4388bb0e: Pull complete
f13ae5776e29: Pull complete
4ddcb70b8e41: Pull complete
b759439fd226: Pull complete
82d9837ea912: Pull complete
Digest: sha256:b72f2fc38b64e144cdf24ac252b8ca870261acc322caafa4e33137f8ae2cdecb
Status: Downloaded newer image for faradaysec/faraday:latest
Creating faraday_db    ... done
Creating faraday_redis ... done
Creating faraday_app   ... done
Attaching to faraday_db, faraday_redis, faraday_app
app_1    | Tue Aug  2 14:31:59 UTC 2022 Creating server.ini
db_1     | The files belonging to this database system will be owned by user "postgres".
db_1     | This user must also own the server process.
db_1     |
db_1     | The database cluster will be initialized with locale "en_US.utf8".
db_1     | The default database encoding has accordingly been set to "UTF8".
db_1     | The default text search configuration will be set to "english".
db_1     |
db_1     | Data page checksums are disabled.
db_1     |
db_1     | fixing permissions on existing directory /var/lib/postgresql/data ... ok
db_1     | creating subdirectories ... ok
db_1     | selecting dynamic shared memory implementation ... posix
db_1     | selecting default max_connections ... 100
db_1     | selecting default shared_buffers ... 128MB
db_1     | selecting default time zone ... UTC
db_1     | creating configuration files ... ok
db_1     | running bootstrap script ... ok
db_1     | performing post-bootstrap initialization ... sh: locale: not found
db_1     | 2022-08-02 14:31:57.033 UTC [29] WARNING:  no usable system locales were found
db_1     | ok
redis_1  | 1:C 02 Aug 2022 14:31:56.487 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1  | 1:C 02 Aug 2022 14:31:56.487 # Redis version=6.2.7, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1  | 1:C 02 Aug 2022 14:31:56.487 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis_1  | 1:M 02 Aug 2022 14:31:56.487 * monotonic clock: POSIX clock_gettime
redis_1  | 1:M 02 Aug 2022 14:31:56.488 # A key '__redis__compare_helper' was added to Lua globals which is not on the globals allow list nor listed on the deny list.
redis_1  | 1:M 02 Aug 2022 14:31:56.488 * Running mode=standalone, port=6379.
redis_1  | 1:M 02 Aug 2022 14:31:56.488 # Server initialized
redis_1  | 1:M 02 Aug 2022 14:31:56.488 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1  | 1:M 02 Aug 2022 14:31:56.488 * Ready to accept connections
app_1    | Tue Aug  2 14:31:59 UTC 2022 Creating tables on database faraday...
app_1    | Creating tables
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | psycopg2.OperationalError: could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    |
app_1    | The above exception was the direct cause of the following exception:
app_1    |
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/bin/faraday-manage", line 8, in <module>
app_1    |     sys.exit(cli())
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1130, in __call__
app_1    |     return self.main(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1055, in main
app_1    |     rv = self.invoke(ctx)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1657, in invoke
app_1    |     return _process_result(sub_ctx.command.invoke(sub_ctx))
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1404, in invoke
app_1    |     return ctx.invoke(self.callback, **ctx.params)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 760, in invoke
app_1    |     return __callback(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/manage.py", line 208, in create_tables
app_1    |     InitDB()._create_tables(conn_string)
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/server/commands/initdb.py", line 432, in _create_tables
app_1    |     (result,) = list(db.session.execute("select to_regclass('alembic_version')"))
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py", line 163, in do
app_1    |     return getattr(self.registry(), name)(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1295, in execute
app_1    |     return self._connection_for_bind(bind, close_with_result=True).execute(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1150, in _connection_for_bind
app_1    |     return self.transaction._connection_for_bind(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 433, in _connection_for_bind
app_1    |     conn = bind._contextual_connect()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2302, in _contextual_connect
app_1    |     self._wrap_pool_connect(self.pool.connect, None),
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
app_1    |     Connection._handle_dbapi_exception_noconnection(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1583, in _handle_dbapi_exception_noconnection
app_1    |     util.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    | (Background on this error at: http://sqlalche.me/e/13/e3q8)
db_1     | syncing data to disk ... ok
db_1     |
db_1     |
db_1     | Success. You can now start the database server using:
db_1     |
db_1     |     pg_ctl -D /var/lib/postgresql/data -l logfile start
db_1     |
db_1     | initdb: warning: enabling "trust" authentication for local connections
db_1     | You can change this by editing pg_hba.conf or using the option -A, or
db_1     | --auth-local and --auth-host, the next time you run initdb.
db_1     | waiting for server to start....2022-08-02 14:32:04.220 UTC [34] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1     | 2022-08-02 14:32:04.230 UTC [34] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-02 14:32:04.301 UTC [35] LOG:  database system was shut down at 2022-08-02 14:31:57 UTC
db_1     | 2022-08-02 14:32:04.353 UTC [34] LOG:  database system is ready to accept connections
db_1     |  done
db_1     | server started
db_1     | CREATE DATABASE
db_1     |
db_1     |
db_1     | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
db_1     |
db_1     | 2022-08-02 14:32:05.345 UTC [34] LOG:  received fast shutdown request
db_1     | waiting for server to shut down....2022-08-02 14:32:05.351 UTC [34] LOG:  aborting any active transactions
db_1     | 2022-08-02 14:32:05.354 UTC [34] LOG:  background worker "logical replication launcher" (PID 41) exited with exit code 1
db_1     | 2022-08-02 14:32:05.354 UTC [36] LOG:  shutting down
db_1     | 2022-08-02 14:32:05.382 UTC [34] LOG:  database system is shut down
db_1     |  done
db_1     | server stopped
db_1     |
db_1     | PostgreSQL init process complete; ready for start up.
db_1     |
db_1     | 2022-08-02 14:32:05.459 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1     | 2022-08-02 14:32:05.460 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1     | 2022-08-02 14:32:05.460 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1     | 2022-08-02 14:32:05.466 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-02 14:32:05.486 UTC [48] LOG:  database system was shut down at 2022-08-02 14:32:05 UTC
db_1     | 2022-08-02 14:32:05.491 UTC [1] LOG:  database system is ready to accept connections
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 14:32:06.314 UTC [55] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:06.314 UTC [55] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
db_1     | 2022-08-02 14:32:09.507 UTC [56] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:09.507 UTC [56] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 14:32:13.079 UTC [57] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:13.079 UTC [57] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
db_1     | 2022-08-02 14:32:19.790 UTC [58] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:19.790 UTC [58] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
db_1     | 2022-08-02 14:32:24.381 UTC [59] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:24.381 UTC [59] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
db_1     | 2022-08-02 14:32:30.550 UTC [60] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:30.550 UTC [60] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app exited with code 1
db_1     | 2022-08-02 14:32:41.006 UTC [61] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:41.006 UTC [61] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app exited with code 1
app_1    | Tue Aug  2 14:31:59 UTC 2022 Creating server.ini
app_1    | Tue Aug  2 14:31:59 UTC 2022 Creating tables on database faraday...
app_1    | Creating tables
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | psycopg2.OperationalError: could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    |
app_1    | The above exception was the direct cause of the following exception:
app_1    |
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/bin/faraday-manage", line 8, in <module>
app_1    |     sys.exit(cli())
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1130, in __call__
app_1    |     return self.main(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1055, in main
app_1    |     rv = self.invoke(ctx)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1657, in invoke
app_1    |     return _process_result(sub_ctx.command.invoke(sub_ctx))
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1404, in invoke
app_1    |     return ctx.invoke(self.callback, **ctx.params)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 760, in invoke
app_1    |     return __callback(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/manage.py", line 208, in create_tables
app_1    |     InitDB()._create_tables(conn_string)
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/server/commands/initdb.py", line 432, in _create_tables
app_1    |     (result,) = list(db.session.execute("select to_regclass('alembic_version')"))
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py", line 163, in do
app_1    |     return getattr(self.registry(), name)(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1295, in execute
app_1    |     return self._connection_for_bind(bind, close_with_result=True).execute(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1150, in _connection_for_bind
app_1    |     return self.transaction._connection_for_bind(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 433, in _connection_for_bind
app_1    |     conn = bind._contextual_connect()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2302, in _contextual_connect
app_1    |     self._wrap_pool_connect(self.pool.connect, None),
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
app_1    |     Connection._handle_dbapi_exception_noconnection(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1583, in _handle_dbapi_exception_noconnection
app_1    |     util.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    | (Background on this error at: http://sqlalche.me/e/13/e3q8)
app_1    | Tue Aug  2 14:32:04 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 14:32:04 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 14:32:07 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 14:32:07 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 14:32:11 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 14:32:11 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 14:32:16 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 14:32:16 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 14:32:22 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 14:32:22 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 14:32:28 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 14:32:28 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Tue Aug  2 14:32:39 UTC 2022 Using existing server.ini
app_1    | Tue Aug  2 14:32:39 UTC 2022 Running migrations ...
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-02 14:32:57.024 UTC [62] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-02 14:32:57.024 UTC [62] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1

[ezk06eer]

Hi @jbauernberger , sorry about the inconvenience, you need to start over, please remove all the volumes, and the contents of ~/{your-user/.faraday and ~/faraday/.faraday. from the logs, it is picking up the existing file again.

app_1 | Tue Aug 2 14:32:04 UTC 2022 Using existing server.ini app_1 | Tue Aug 2 14:32:04 UTC 2022 Running migrations ...

The commands:

mkdir /tmp/faraday
cp /home/$(whoami)/.faraday /tmp/faraday/
rm -rf /home/$(whoami)/.faraday
docker-compose down
docker kill $(docker ps -q)
docker rm $(docker ps -a -q) ###this will remove all the containers you have running, run it wisely, if you have other containers don't run them like this
docker volume rm $(docker volume ls -q)
cd ~
wget https://raw.githubusercontent.com/infobyte/faraday/master/docker-compose.yaml
docker-compose up

please share the logs again to us. Cheers!

[aenima-x]

@jbauernberger I just tested a clean install and it works

docker-compose up
Creating volume "faraday_db" with local driver
Creating faraday_redis ... done
Creating faraday_db    ... done
Creating faraday_app   ... done
Attaching to faraday_db, faraday_redis, faraday_app
db_1     | The files belonging to this database system will be owned by user "postgres".
db_1     | This user must also own the server process.
db_1     |
db_1     | The database cluster will be initialized with locale "en_US.utf8".
db_1     | The default database encoding has accordingly been set to "UTF8".
db_1     | The default text search configuration will be set to "english".
db_1     |
db_1     | Data page checksums are disabled.
redis_1  | 1:C 02 Aug 2022 15:08:10.068 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1  | 1:C 02 Aug 2022 15:08:10.068 # Redis version=6.2.7, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1  | 1:C 02 Aug 2022 15:08:10.068 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
db_1     |
app_1    | Tue Aug  2 15:08:10 UTC 2022 Creating server.ini
redis_1  | 1:M 02 Aug 2022 15:08:10.068 * monotonic clock: POSIX clock_gettime
redis_1  | 1:M 02 Aug 2022 15:08:10.070 # A key '__redis__compare_helper' was added to Lua globals which is not on the globals allow list nor listed on the deny list.
redis_1  | 1:M 02 Aug 2022 15:08:10.070 * Running mode=standalone, port=6379.
redis_1  | 1:M 02 Aug 2022 15:08:10.070 # Server initialized
db_1     | fixing permissions on existing directory /var/lib/postgresql/data ... ok
redis_1  | 1:M 02 Aug 2022 15:08:10.071 * Ready to accept connections
db_1     | creating subdirectories ... ok
db_1     | selecting dynamic shared memory implementation ... posix
db_1     | selecting default max_connections ... 100
db_1     | selecting default shared_buffers ... 128MB
db_1     | selecting default time zone ... UTC
db_1     | creating configuration files ... ok
db_1     | running bootstrap script ... ok
app_1    | Tue Aug  2 15:08:10 UTC 2022 Creating tables on database faraday...
db_1     | performing post-bootstrap initialization ... sh: locale: not found
db_1     | 2022-08-02 15:08:10.810 UTC [30] WARNING:  no usable system locales were found
db_1     | ok
db_1     | syncing data to disk ... ok
db_1     |
db_1     |
db_1     | Success. You can now start the database server using:
db_1     |
db_1     |     pg_ctl -D /var/lib/postgresql/data -l logfile start
db_1     |
db_1     | initdb: warning: enabling "trust" authentication for local connections
db_1     | You can change this by editing pg_hba.conf or using the option -A, or
db_1     | --auth-local and --auth-host, the next time you run initdb.
db_1     | waiting for server to start....2022-08-02 15:08:11.578 UTC [35] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1     | 2022-08-02 15:08:11.579 UTC [35] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-02 15:08:11.592 UTC [36] LOG:  database system was shut down at 2022-08-02 15:08:11 UTC
db_1     | 2022-08-02 15:08:11.595 UTC [35] LOG:  database system is ready to accept connections
db_1     |  done
db_1     | server started
db_1     | CREATE DATABASE
db_1     |
db_1     |
db_1     | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
db_1     |
db_1     | 2022-08-02 15:08:11.828 UTC [35] LOG:  received fast shutdown request
db_1     | waiting for server to shut down....2022-08-02 15:08:11.829 UTC [35] LOG:  aborting any active transactions
db_1     | 2022-08-02 15:08:11.830 UTC [35] LOG:  background worker "logical replication launcher" (PID 42) exited with exit code 1
db_1     | 2022-08-02 15:08:11.831 UTC [37] LOG:  shutting down
db_1     | 2022-08-02 15:08:11.842 UTC [35] LOG:  database system is shut down
db_1     |  done
db_1     | server stopped
db_1     |
db_1     | PostgreSQL init process complete; ready for start up.
db_1     |
db_1     | 2022-08-02 15:08:11.936 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1     | 2022-08-02 15:08:11.936 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1     | 2022-08-02 15:08:11.937 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1     | 2022-08-02 15:08:11.940 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-02 15:08:11.957 UTC [49] LOG:  database system was shut down at 2022-08-02 15:08:11 UTC
db_1     | 2022-08-02 15:08:11.962 UTC [1] LOG:  database system is ready to accept connections
app_1    | Creating tables
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running stamp_revision  -> 99a740945c44
app_1    | Tables created successfully!
app_1    | Tue Aug  2 15:08:14 UTC 2022 Creating superuser...
app_1    | User faraday created successfully!
app_1    | Admin user created with username: faraday password: h78SL?Og+/(i/
app_1    | Tue Aug  2 15:08:17 UTC 2022 Running migrations ...
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | Tue Aug  2 15:08:19 UTC 2022 Starting application...
app_1    | 2022-08-02T15:08:20+0000 - alembic.runtime.migration - INFO {MainThread} [pid:32] [migration.py:204 - __init__()]  Context impl PostgresqlImpl.
app_1    | 2022-08-02T15:08:20+0000 - alembic.runtime.migration - INFO {MainThread} [pid:32] [migration.py:207 - __init__()]  Will assume transactional DDL.
app_1    | 2022-08-02T15:08:20+0000 - faraday.start_server - WARNING {MainThread} [pid:32] [start_server.py:53 - check_postgresql()]  No workspaces found
app_1    | 2022-08-02T15:08:20+0000 - faraday.server.web - INFO {MainThread} [pid:32] [web.py:87 - __init__()]  Starting web server at http://0.0.0.0:5985/
app_1    | 2022-08-02T15:08:20+0000 - faraday.server.threads.reports_processor - INFO {ReportsManager-Thread} [pid:32] [reports_processor.py:100 - run()]  Reports Manager Thread [Start]
app_1    | 2022-08-02T15:08:20+0000 - faraday.server.threads.ping_home - INFO {PingHomeThread} [pid:32] [ping_home.py:18 - run()]  Ping Home Thread [Start]
app_1    | 2022-08-02T15:08:20+0000 - faraday.server.web - INFO {MainThread} [pid:32] [web.py:155 - run()]  Starting webserver with 12 threads.
app_1    | 2022-08-02T15:08:20+0000 - faraday.server.web - INFO {MainThread} [pid:32] [web.py:105 - __build_websockets_resource()]  Starting websocket server at port 9000 with bind address 0.0.0.0.
app_1    | 2022-08-02T15:08:20+0000 - faraday.server.web - INFO {MainThread} [pid:32] [web.py:164 - run()]  Faraday Server is ready

[codesalatdev]

@aenima-x Nope. Never had Faraday installed, thoguht I'd give it a try and I have the exact same issue. Followed the steps @ezk06eer suggested, but as expected (since I installed docker just now), the state of my system is the same as it was before and so is the behaviour of Faraday:

faraday_db     | The files belonging to this database system will be owned by user "postgres".
faraday_db     | This user must also own the server process.
faraday_db     | 
faraday_db     | The database cluster will be initialized with locale "en_US.utf8".
faraday_db     | The default database encoding has accordingly been set to "UTF8".
faraday_db     | The default text search configuration will be set to "english".
faraday_db     | 
faraday_db     | Data page checksums are disabled.
faraday_db     | 
faraday_db     | fixing permissions on existing directory /var/lib/postgresql/data ... ok
faraday_db     | creating subdirectories ... ok
faraday_db     | selecting dynamic shared memory implementation ... posix
faraday_db     | selecting default max_connections ... 100
faraday_redis  | 1:C 03 Aug 2022 09:37:20.047 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
faraday_redis  | 1:C 03 Aug 2022 09:37:20.047 # Redis version=6.2.7, bits=64, commit=00000000, modified=0, pid=1, just started
faraday_redis  | 1:C 03 Aug 2022 09:37:20.047 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
faraday_redis  | 1:M 03 Aug 2022 09:37:20.048 * monotonic clock: POSIX clock_gettime
faraday_redis  | 1:M 03 Aug 2022 09:37:20.050 # A key '__redis__compare_helper' was added to Lua globals which is not on the globals allow list nor listed on the deny list.
faraday_redis  | 1:M 03 Aug 2022 09:37:20.050 * Running mode=standalone, port=6379.
faraday_redis  | 1:M 03 Aug 2022 09:37:20.051 # Server initialized
faraday_redis  | 1:M 03 Aug 2022 09:37:20.051 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
faraday_redis  | 1:M 03 Aug 2022 09:37:20.051 * Ready to accept connections
faraday_db     | selecting default shared_buffers ... 128MB
faraday_db     | selecting default time zone ... UTC
faraday_db     | creating configuration files ... ok
faraday_db     | running bootstrap script ... ok
faraday_app    | Wed Aug  3 09:37:20 UTC 2022 Creating server.ini
faraday_app    | Wed Aug  3 09:37:20 UTC 2022 Creating tables on database faraday...
faraday_db     | performing post-bootstrap initialization ... sh: locale: not found
faraday_db     | 2022-08-03 09:37:20.539 UTC [30] WARNING:  no usable system locales were found
faraday_db     | ok
faraday_app    | Creating tables
faraday_app    | Traceback (most recent call last):
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
faraday_app    |     return fn()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
faraday_app    |     return _ConnectionFairy._checkout(self)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
faraday_app    |     fairy = _ConnectionRecord.checkout(pool)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
faraday_app    |     rec = pool._do_get()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
faraday_app    |     self._dec_overflow()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
faraday_app    |     compat.raise_(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
faraday_app    |     raise exception
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
faraday_app    |     return self._create_connection()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
faraday_app    |     return _ConnectionRecord(self)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
faraday_app    |     self.__connect(first_connect_check=True)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
faraday_app    |     pool.logger.debug("Error on connect(): %s", e)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
faraday_app    |     compat.raise_(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
faraday_app    |     raise exception
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
faraday_app    |     connection = pool._invoke_creator(self)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
faraday_app    |     return dialect.connect(*cargs, **cparams)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
faraday_app    |     return self.dbapi.connect(*cargs, **cparams)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
faraday_app    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
faraday_app    | psycopg2.OperationalError: could not connect to server: Connection refused
faraday_app    |    Is the server running on host "db" (172.23.0.2) and accepting
faraday_app    |    TCP/IP connections on port 5432?
faraday_app    | 
faraday_app    | 
faraday_app    | The above exception was the direct cause of the following exception:
faraday_app    | 
faraday_app    | Traceback (most recent call last):
faraday_app    |   File "/usr/local/bin/faraday-manage", line 8, in <module>
faraday_app    |     sys.exit(cli())
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1130, in __call__
faraday_app    |     return self.main(*args, **kwargs)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1055, in main
faraday_app    |     rv = self.invoke(ctx)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1657, in invoke
faraday_app    |     return _process_result(sub_ctx.command.invoke(sub_ctx))
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1404, in invoke
faraday_app    |     return ctx.invoke(self.callback, **ctx.params)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 760, in invoke
faraday_app    |     return __callback(*args, **kwargs)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/faraday/manage.py", line 208, in create_tables
faraday_app    |     InitDB()._create_tables(conn_string)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/faraday/server/commands/initdb.py", line 432, in _create_tables
faraday_app    |     (result,) = list(db.session.execute("select to_regclass('alembic_version')"))
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py", line 163, in do
faraday_app    |     return getattr(self.registry(), name)(*args, **kwargs)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1295, in execute
faraday_app    |     return self._connection_for_bind(bind, close_with_result=True).execute(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1150, in _connection_for_bind
faraday_app    |     return self.transaction._connection_for_bind(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 433, in _connection_for_bind
faraday_app    |     conn = bind._contextual_connect()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2302, in _contextual_connect
faraday_app    |     self._wrap_pool_connect(self.pool.connect, None),
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
faraday_app    |     Connection._handle_dbapi_exception_noconnection(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1583, in _handle_dbapi_exception_noconnection
faraday_app    |     util.raise_(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
faraday_app    |     raise exception
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
faraday_app    |     return fn()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
faraday_app    |     return _ConnectionFairy._checkout(self)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
faraday_app    |     fairy = _ConnectionRecord.checkout(pool)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
faraday_app    |     rec = pool._do_get()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
faraday_app    |     self._dec_overflow()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
faraday_app    |     compat.raise_(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
faraday_app    |     raise exception
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
faraday_app    |     return self._create_connection()
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
faraday_app    |     return _ConnectionRecord(self)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
faraday_app    |     self.__connect(first_connect_check=True)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
faraday_app    |     pool.logger.debug("Error on connect(): %s", e)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
faraday_app    |     compat.raise_(
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
faraday_app    |     raise exception
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
faraday_app    |     connection = pool._invoke_creator(self)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
faraday_app    |     return dialect.connect(*cargs, **cparams)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
faraday_app    |     return self.dbapi.connect(*cargs, **cparams)
faraday_app    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
faraday_app    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
faraday_app    | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused
faraday_app    |    Is the server running on host "db" (172.23.0.2) and accepting
faraday_app    |    TCP/IP connections on port 5432?
faraday_app    | 
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/e3q8)
faraday_app exited with code 1
faraday_db     | syncing data to disk ... initdb: warning: enabling "trust" authentication for local connections
faraday_db     | You can change this by editing pg_hba.conf or using the option -A, or
faraday_db     | --auth-local and --auth-host, the next time you run initdb.
faraday_db     | ok
faraday_db     | 
faraday_db     | 
faraday_db     | Success. You can now start the database server using:
faraday_db     | 
faraday_db     |     pg_ctl -D /var/lib/postgresql/data -l logfile start
faraday_db     | 
faraday_db     | waiting for server to start....2022-08-03 09:37:24.623 UTC [35] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
faraday_db     | 2022-08-03 09:37:24.627 UTC [35] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
faraday_db     | 2022-08-03 09:37:24.652 UTC [36] LOG:  database system was shut down at 2022-08-03 09:37:20 UTC
faraday_db     | 2022-08-03 09:37:24.660 UTC [35] LOG:  database system is ready to accept connections
faraday_db     |  done
faraday_db     | server started
faraday_db     | CREATE DATABASE
faraday_db     | 
faraday_db     | 
faraday_db     | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
faraday_db     | 
faraday_db     | waiting for server to shut down...2022-08-03 09:37:25.891 UTC [35] LOG:  received fast shutdown request
faraday_db     | .2022-08-03 09:37:25.895 UTC [35] LOG:  aborting any active transactions
faraday_db     | 2022-08-03 09:37:25.896 UTC [35] LOG:  background worker "logical replication launcher" (PID 42) exited with exit code 1
faraday_db     | 2022-08-03 09:37:25.896 UTC [37] LOG:  shutting down
faraday_db     | 2022-08-03 09:37:25.925 UTC [35] LOG:  database system is shut down
faraday_db     |  done
faraday_db     | server stopped
faraday_db     | 
faraday_db     | PostgreSQL init process complete; ready for start up.
faraday_db     | 
faraday_db     | 2022-08-03 09:37:26.000 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
faraday_db     | 2022-08-03 09:37:26.000 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
faraday_db     | 2022-08-03 09:37:26.000 UTC [1] LOG:  listening on IPv6 address "::", port 5432
faraday_db     | 2022-08-03 09:37:26.010 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
faraday_db     | 2022-08-03 09:37:26.033 UTC [49] LOG:  database system was shut down at 2022-08-03 09:37:25 UTC
faraday_db     | 2022-08-03 09:37:26.039 UTC [1] LOG:  database system is ready to accept connections
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:37:26.241 UTC [56] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:37:26.241 UTC [56] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:37:28.764 UTC [57] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:37:28.764 UTC [57] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:37:31.521 UTC [58] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:37:31.521 UTC [58] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:37:34.710 UTC [59] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:37:34.710 UTC [59] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:37:38.765 UTC [60] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:37:38.765 UTC [60] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:37:44.340 UTC [61] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:37:44.340 UTC [61] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:37:53.060 UTC [62] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:37:53.060 UTC [62] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:38:08.187 UTC [63] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:38:08.187 UTC [63] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:38:36.077 UTC [65] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:38:36.077 UTC [65] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:39:29.629 UTC [67] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:39:29.629 UTC [67] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
faraday_app    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
faraday_db     | 2022-08-03 09:40:32.051 UTC [70] ERROR:  relation "vulnerability" does not exist
faraday_db     | 2022-08-03 09:40:32.051 UTC [70] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
faraday_app    | 
faraday_app    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
faraday_app    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1

Edit: Results of clearing faraday data

~ 
❯ rm -rf /home/$(whoami)/.faraday

~ 
❯ docker compose down 
Warning: No resource found to remove for project "noah".

~ 
❯ docker kill $(docker ps -q)
"docker kill" requires at least 1 argument.
See 'docker kill --help'.

Usage:  docker kill [OPTIONS] CONTAINER [CONTAINER...]

Kill one or more running containers

~ 
❯ docker rm $(docker ps -a -q)
"docker rm" requires at least 1 argument.
See 'docker rm --help'.

Usage:  docker rm [OPTIONS] CONTAINER [CONTAINER...]

Remove one or more containers

~ 
❯ docker volume rm $(docker volume ls -q)
"docker volume rm" requires at least 1 argument.
See 'docker volume rm --help'.

Usage:  docker volume rm [OPTIONS] VOLUME [VOLUME...]

Remove one or more volumes

IMO, this is what one would consider to be "clean".

Edit 2: Image versions:

REPOSITORY           TAG           IMAGE ID       CREATED         SIZE
faradaysec/faraday   latest        5168e59c82dd   5 days ago      698MB
redis                6.2-alpine    b6e4ce5f89f4   2 weeks ago     25.5MB
postgres             12.7-alpine   16537462de4a   12 months ago   190MB

[jbauernberger]

@aenima-x @ezk06eer

• have removed $HOME/.faraday
• /home/faraday no longer exists
• removed all docker containers, all images and all volumes.

then

 joachim ~/src/faraday  docker-compose up
Pulling db (postgres:12.7-alpine)...
12.7-alpine: Pulling from library/postgres
29291e31a76a: Pulling fs layer
c7f8a1ea71cb: Downloading [=========================>                         ]     6c7f8a1ea71cb: Downloading [==================================================>]  1.2829291e31a76a: Downloading [>                                                  ]  29.329291e31a76a: Downloading [===========================>                       ]   1.529291e31a76a: Extracting [>                                                  ]  32.7729291e31a76a: Extracting [=>                                                 ]   98.329291e31a76a: Extracting [==========================================>        ]  2.39229291e31a76a: Extracting [==================================================>]  2.81329291e31a76a: Pull complete
c7f8a1ea71cb: Extracting [==================================================>]  1.284c7f8a1ea71cb: Extracting [==================================================>]  1.284kB/1.284kB

c7f8a1ea71cb: Pull complete
8b31ea9e78e2: Downloading [===>                                               ]     664d8912b293d: Extracting [==================================================>]     1464d8912b293d: Extracting [==================================================>]     1464d8912b293d: Pull complete
73b55a167823: Download complete

c5ea624bd2f9: Pull complete
8b31ea9e78e2: Extracting [==================================================>]  8.6688b31ea9e78e2: Extracting [==================================================>]  8.6688b31ea9e78e2: Pull complete
73b55a167823: Extracting [==================================================>]     1673b55a167823: Extracting [==================================================>]     1673b55a167823: Pull complete
182bdad89856: Extracting [==================================================>]     19182bdad89856: Extracting [==================================================>]     19182bdad89856: Pull complete
8106b49e33bd: Extracting [==================================================>]  4.4068106b49e33bd: Extracting [==================================================>]  4.4068106b49e33bd: Pull complete
Digest: sha256:8b4e93c283134e56936c0115e552e3dbac05f323c898b100408ed6df77f3e1b5
Status: Downloaded newer image for postgres:12.7-alpine
Pulling redis (redis:6.2-alpine)...
6.2-alpine: Pulling from library/redis
530afca65e2e: Pull complete
c550a3118f41: Pull complete
9b28aced8b95: Pull complete
6b06fa84bb68: Pull complete
8a9eaf20067f: Pull complete
2d7046f40b15: Pull complete
Digest: sha256:2edb3aa2e850fd6ae7593f970a882fb7077a7d5468bb61f4fe6c3623bd51d6d7
Status: Downloaded newer image for redis:6.2-alpine
Pulling app (index.docker.io/faradaysec/faraday:)...
latest: Pulling from faradaysec/faraday
ac2fb615420c: Pull complete
64d0f1d7987a: Pull complete
b650c79550ec: Pull complete
d49a7ac5e6c0: Pull complete
ac10782b0843: Pull complete
b7445b0a7352: Pull complete
d3e784120811: Pull complete
9e233aad457c: Pull complete
ed4ec6d2ce48: Pull complete
0090ed00d86a: Pull complete
ea8b4388bb0e: Pull complete
f13ae5776e29: Pull complete
4ddcb70b8e41: Pull complete
b759439fd226: Pull complete
82d9837ea912: Pull complete
Digest: sha256:b72f2fc38b64e144cdf24ac252b8ca870261acc322caafa4e33137f8ae2cdecb
Status: Downloaded newer image for faradaysec/faraday:latest
Creating faraday_redis ... done
Creating faraday_db    ... done
Creating faraday_app   ... done
Attaching to faraday_redis, faraday_db, faraday_app
app_1    | Wed Aug  3 10:21:09 UTC 2022 Creating server.ini
db_1     | The files belonging to this database system will be owned by user "postgres".
db_1     | This user must also own the server process.
db_1     |
db_1     | The database cluster will be initialized with locale "en_US.utf8".
db_1     | The default database encoding has accordingly been set to "UTF8".
db_1     | The default text search configuration will be set to "english".
db_1     |
db_1     | Data page checksums are disabled.
db_1     |
db_1     | fixing permissions on existing directory /var/lib/postgresql/data ... ok
db_1     | creating subdirectories ... ok
db_1     | selecting dynamic shared memory implementation ... posix
db_1     | selecting default max_connections ... 100
db_1     | selecting default shared_buffers ... 128MB
db_1     | selecting default time zone ... UTC
db_1     | creating configuration files ... ok
db_1     | running bootstrap script ... ok
db_1     | performing post-bootstrap initialization ... sh: locale: not found
db_1     | 2022-08-03 10:21:07.907 UTC [30] WARNING:  no usable system locales were found
db_1     | ok
app_1    | Wed Aug  3 10:21:09 UTC 2022 Creating tables on database faraday...
redis_1  | 1:C 03 Aug 2022 10:21:07.433 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1  | 1:C 03 Aug 2022 10:21:07.433 # Redis version=6.2.7, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1  | 1:C 03 Aug 2022 10:21:07.433 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis_1  | 1:M 03 Aug 2022 10:21:07.433 * monotonic clock: POSIX clock_gettime
redis_1  | 1:M 03 Aug 2022 10:21:07.434 # A key '__redis__compare_helper' was added to Lua globals which is not on the globals allow list nor listed on the deny list.
redis_1  | 1:M 03 Aug 2022 10:21:07.434 * Running mode=standalone, port=6379.
redis_1  | 1:M 03 Aug 2022 10:21:07.434 # Server initialized
redis_1  | 1:M 03 Aug 2022 10:21:07.434 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1  | 1:M 03 Aug 2022 10:21:07.435 * Ready to accept connections
app_1    | Creating tables
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | psycopg2.OperationalError: could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    |
app_1    | The above exception was the direct cause of the following exception:
app_1    |
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/bin/faraday-manage", line 8, in <module>
app_1    |     sys.exit(cli())
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1130, in __call__
app_1    |     return self.main(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1055, in main
app_1    |     rv = self.invoke(ctx)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1657, in invoke
app_1    |     return _process_result(sub_ctx.command.invoke(sub_ctx))
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1404, in invoke
app_1    |     return ctx.invoke(self.callback, **ctx.params)
app_1    |   File "/usr/local/lib/python3.8/site-packages/click/core.py", line 760, in invoke
app_1    |     return __callback(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/manage.py", line 208, in create_tables
app_1    |     InitDB()._create_tables(conn_string)
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/server/commands/initdb.py", line 432, in _create_tables
app_1    |     (result,) = list(db.session.execute("select to_regclass('alembic_version')"))
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py", line 163, in do
app_1    |     return getattr(self.registry(), name)(*args, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1295, in execute
app_1    |     return self._connection_for_bind(bind, close_with_result=True).execute(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1150, in _connection_for_bind
app_1    |     return self.transaction._connection_for_bind(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 433, in _connection_for_bind
app_1    |     conn = bind._contextual_connect()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2302, in _contextual_connect
app_1    |     self._wrap_pool_connect(self.pool.connect, None),
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
app_1    |     Connection._handle_dbapi_exception_noconnection(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1583, in _handle_dbapi_exception_noconnection
app_1    |     util.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    | (Background on this error at: http://sqlalche.me/e/13/e3q8)
db_1     | syncing data to disk ... ok
db_1     |
db_1     |
db_1     | Success. You can now start the database server using:
db_1     |
db_1     |     pg_ctl -D /var/lib/postgresql/data -l logfile start
db_1     |
db_1     | initdb: warning: enabling "trust" authentication for local connections
db_1     | You can change this by editing pg_hba.conf or using the option -A, or
db_1     | --auth-local and --auth-host, the next time you run initdb.
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.OperationalError) could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    | (Background on this error at: http://sqlalche.me/e/13/e3q8)
app_1    | ERROR [faraday.manage] (psycopg2.OperationalError) could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    | (Background on this error at: http://sqlalche.me/e/13/e3q8)
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | psycopg2.OperationalError: could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    |
app_1    | The above exception was the direct cause of the following exception:
app_1    |
app_1    | Traceback (most recent call last):
app_1    |   File "/usr/local/lib/python3.8/site-packages/faraday/manage.py", line 235, in migrate
app_1    |     alembic.command.upgrade(config, revision)
app_1    |   File "/usr/local/lib/python3.8/site-packages/alembic/command.py", line 322, in upgrade
app_1    |     script.run_env()
app_1    |   File "/usr/local/lib/python3.8/site-packages/alembic/script/base.py", line 569, in run_env
app_1    |     util.load_python_file(self.dir, "env.py")
app_1    |   File "/usr/local/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
app_1    |     module = load_module_py(module_id, path)
app_1    |   File "/usr/local/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
app_1    |     spec.loader.exec_module(module)  # type: ignore
app_1    |   File "<frozen importlib._bootstrap_external>", line 843, in exec_module
app_1    |   File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
app_1    |   File "migrations/env.py", line 81, in <module>
app_1    |     run_migrations_online()
app_1    |   File "migrations/env.py", line 66, in run_migrations_online
app_1    |     with connectable.connect() as connection:
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2263, in connect
app_1    |     return self._connection_cls(self, **kwargs)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 104, in __init__
app_1    |     else engine.raw_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2369, in raw_connection
app_1    |     return self._wrap_pool_connect(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
app_1    |     Connection._handle_dbapi_exception_noconnection(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1583, in _handle_dbapi_exception_noconnection
app_1    |     util.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
app_1    |     return fn()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
app_1    |     return _ConnectionFairy._checkout(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
app_1    |     fairy = _ConnectionRecord.checkout(pool)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
app_1    |     rec = pool._do_get()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
app_1    |     self._dec_overflow()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
app_1    |     return self._create_connection()
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
app_1    |     return _ConnectionRecord(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
app_1    |     self.__connect(first_connect_check=True)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
app_1    |     pool.logger.debug("Error on connect(): %s", e)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
app_1    |     compat.raise_(
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
app_1    |     raise exception
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
app_1    |     connection = pool._invoke_creator(self)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_1    |     return dialect.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
app_1    |     return self.dbapi.connect(*cargs, **cparams)
app_1    |   File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
app_1    |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
app_1    | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused
app_1    |  Is the server running on host "db" (172.18.0.2) and accepting
app_1    |  TCP/IP connections on port 5432?
app_1    |
app_1    | (Background on this error at: http://sqlalche.me/e/13/e3q8)
app_1    | Please verify your configuration on server.ini or the hba configuration!
db_1     | waiting for server to start....2022-08-03 10:21:16.458 UTC [35] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
app_1    | Wed Aug  3 10:21:16 UTC 2022 Starting application...
db_1     | 2022-08-03 10:21:16.526 UTC [35] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-03 10:21:16.569 UTC [36] LOG:  database system was shut down at 2022-08-03 10:21:08 UTC
db_1     | 2022-08-03 10:21:16.578 UTC [35] LOG:  database system is ready to accept connections
db_1     |  done
db_1     | server started
db_1     | CREATE DATABASE
db_1     |
db_1     |
db_1     | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
db_1     |
db_1     | 2022-08-03 10:21:17.360 UTC [35] LOG:  received fast shutdown request
db_1     | waiting for server to shut down....2022-08-03 10:21:17.365 UTC [35] LOG:  aborting any active transactions
db_1     | 2022-08-03 10:21:17.367 UTC [35] LOG:  background worker "logical replication launcher" (PID 42) exited with exit code 1
db_1     | 2022-08-03 10:21:17.368 UTC [37] LOG:  shutting down
db_1     | 2022-08-03 10:21:17.857 UTC [35] LOG:  database system is shut down
db_1     |  done
db_1     | server stopped
db_1     |
db_1     | PostgreSQL init process complete; ready for start up.
db_1     |
db_1     | 2022-08-03 10:21:17.879 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1     | 2022-08-03 10:21:17.880 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1     | 2022-08-03 10:21:17.880 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1     | 2022-08-03 10:21:17.892 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1     | 2022-08-03 10:21:18.099 UTC [49] LOG:  database system was shut down at 2022-08-03 10:21:17 UTC
db_1     | 2022-08-03 10:21:18.110 UTC [1] LOG:  database system is ready to accept connections
app_1    | 2022-08-03T10:21:18+0000 - alembic.runtime.migration - INFO {MainThread} [pid:13] [migration.py:204 - __init__()]  Context impl PostgresqlImpl.
app_1    | 2022-08-03T10:21:18+0000 - alembic.runtime.migration - INFO {MainThread} [pid:13] [migration.py:207 - __init__()]  Will assume transactional DDL.
app_1    | 2022-08-03T10:21:18+0000 - faraday.start_server - WARNING {MainThread} [pid:13] [start_server.py:98 - check_alembic_version()]  You are using an unknown schema version. If you are a developer, this probably happened because you used branch with a schema migration not merged yet. If you are a normal user, consider reporting this bug back to us
db_1     | 2022-08-03 10:21:18.285 UTC [56] ERROR:  relation "workspace" does not exist at character 892
db_1     | 2022-08-03 10:21:18.285 UTC [56] STATEMENT:  SELECT count(*) AS count_1
db_1     |  FROM (SELECT NULL AS anon_2, NULL AS anon_3, NULL AS anon_4, NULL AS anon_5, NULL AS anon_6, NULL AS anon_7, NULL AS anon_8, NULL AS anon_9, 0 AS anon_10, 0 AS anon_11, 0 AS anon_12, NULL AS anon_13, NULL AS anon_14, NULL AS anon_15, NULL AS anon_16, NULL AS anon_17, NULL AS anon_18, NULL AS anon_19, workspace.create_date AS workspace_create_date, workspace.update_date AS workspace_update_date, workspace.id AS workspace_id, workspace.customer AS workspace_customer, workspace.description AS workspace_description, workspace.active AS workspace_active, workspace.readonly AS workspace_readonly, workspace.end_date AS workspace_end_date, workspace.name AS workspace_name, workspace.public AS workspace_public, workspace.start_date AS workspace_start_date, workspace.creator_id AS workspace_creator_id, workspace.update_user_id AS workspace_update_user_id
db_1     |  FROM workspace) AS anon_1
app_1    | 2022-08-03T10:21:18+0000 - faraday.start_server - ERROR {MainThread} [pid:13] [start_server.py:64 - check_postgresql()]
app_1    |
app_1    | nMissing migrations, please execute:
app_1    |
app_1    | faraday-manage migrate
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-03 10:21:21.900 UTC [57] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:21:21.900 UTC [57] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    |
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-03 10:21:27.175 UTC [58] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:21:27.175 UTC [58] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-03 10:21:32.082 UTC [59] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:21:32.082 UTC [59] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-03 10:21:40.088 UTC [60] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:21:40.088 UTC [60] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
db_1     | 2022-08-03 10:21:46.143 UTC [61] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:21:46.143 UTC [61] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-03 10:21:55.744 UTC [62] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:21:55.744 UTC [62] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-03 10:22:12.008 UTC [63] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:22:12.008 UTC [63] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | Migration failed! (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1
app_1    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
app_1    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
app_1    | INFO  [alembic.runtime.migration] Running upgrade  -> e61afb450465, Add custom fields
db_1     | 2022-08-03 10:22:40.924 UTC [65] ERROR:  relation "vulnerability" does not exist
db_1     | 2022-08-03 10:22:40.924 UTC [65] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
app_1    | Migration failed! ERROR [faraday.manage] Migration Error: (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
app_1    | (psycopg2.errors.UndefinedTable) relation "vulnerability" does not exist
app_1    |
app_1    | [SQL: ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB]
app_1    | (Background on this error at: http://sqlalche.me/e/13/f405)
faraday_app exited with code 1

[codesalatdev]

@aenima-x you're not giving postgres enough time to initialize. I can imagine this depends on the system Faraday is being run on, so I'd consider this a race condition.

@jbauernberger I got it to work by running postgres beforehand with the same volume name as Faraday uses for the DB, so everything is ready when docker-compose starts the app image:

1. Reset everything, like suggested above

2. docker run --rm --env "POSTGRES_USER=postgres" --env "POSTGRES_PASSWORD=postgres" --env "POSTGRES_DB=faraday" -v "<INSERT THE VOLUME NAME HERE (`$(whoami)_db` for me)>:/var/lib/postgresql/data:rw" postgres:12.7-alpine

   So in my case:

   docker run --rm --env "POSTGRES_USER=postgres" --env "POSTGRES_PASSWORD=postgres" --env "POSTGRES_DB=faraday" -v "noah_db:/var/lib/postgresql/data:rw" postgres:12.7-alpine

Wait for postgres to initialize the DB, then shutdown gracefully with Ctrl+C

3. Start Faraday with docker-compose
4. Profit:

   faraday_db     | 
   faraday_db     | PostgreSQL Database directory appears to contain a database; Skipping initialization
   faraday_db     | 
   faraday_db     | 2022-08-03 10:30:15.393 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
   faraday_db     | 2022-08-03 10:30:15.393 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
   faraday_db     | 2022-08-03 10:30:15.393 UTC [1] LOG:  listening on IPv6 address "::", port 5432
   faraday_db     | 2022-08-03 10:30:15.407 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
   faraday_redis  | 1:C 03 Aug 2022 10:30:15.414 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
   faraday_redis  | 1:C 03 Aug 2022 10:30:15.414 # Redis version=6.2.7, bits=64, commit=00000000, modified=0, pid=1, just started
   faraday_redis  | 1:C 03 Aug 2022 10:30:15.414 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
   faraday_redis  | 1:M 03 Aug 2022 10:30:15.415 * monotonic clock: POSIX clock_gettime
   faraday_redis  | 1:M 03 Aug 2022 10:30:15.417 # A key '__redis__compare_helper' was added to Lua globals which is not on the globals allow list nor listed on the deny list.
   faraday_redis  | 1:M 03 Aug 2022 10:30:15.417 * Running mode=standalone, port=6379.
   faraday_redis  | 1:M 03 Aug 2022 10:30:15.417 # Server initialized
   faraday_redis  | 1:M 03 Aug 2022 10:30:15.417 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
   faraday_redis  | 1:M 03 Aug 2022 10:30:15.417 * Ready to accept connections
   faraday_db     | 2022-08-03 10:30:15.449 UTC [21] LOG:  database system was shut down at 2022-08-03 10:30:02 UTC
   faraday_db     | 2022-08-03 10:30:15.458 UTC [1] LOG:  database system is ready to accept connections
   faraday_app    | Wed Aug  3 10:30:15 UTC 2022 Creating server.ini
   faraday_app    | Wed Aug  3 10:30:15 UTC 2022 Creating tables on database faraday...
   faraday_app    | Creating tables
   faraday_app    | INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
   faraday_app    | INFO  [alembic.runtime.migration] Will assume transactional DDL.
   faraday_app    | INFO  [alembic.runtime.migration] Running stamp_revision  -> 99a740945c44
   faraday_app    | Tables created successfully!
   faraday_app    | Wed Aug  3 10:30:20 UTC 2022 Creating superuser...
   faraday_app    | User faraday created successfully!

   

[aenima-x]

@codesalatdev Yes, yesterday I saw that in the logs. I will modify the entrypoint script to wait for the database

[aenima-x]

@codesalatdev @jbauernberger The new image is uploaded to docker. please pull and try the compose from scratch

[jbauernberger]

excellent thank you @aenima-x very much - this works now :)

[aenima-x]

Thanks to both of you