docker compose file not work

[idlefire]

init postgresql error.
faraday_app container logs:

2025-10-18 18:28:33.384 | The files belonging to this database system will be owned by user "postgres".
2025-10-18 18:28:33.384 | This user must also own the server process.
2025-10-18 18:28:33.384 | 
2025-10-18 18:28:33.414 | The database cluster will be initialized with locale "en_US.utf8".
2025-10-18 18:28:33.414 | The default database encoding has accordingly been set to "UTF8".
2025-10-18 18:28:33.414 | The default text search configuration will be set to "english".
2025-10-18 18:28:33.414 | 
2025-10-18 18:28:33.414 | Data page checksums are disabled.
2025-10-18 18:28:33.414 | 
2025-10-18 18:28:33.414 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
2025-10-18 18:28:33.427 | creating subdirectories ... ok
2025-10-18 18:28:33.427 | selecting dynamic shared memory implementation ... posix
2025-10-18 18:28:33.488 | selecting default max_connections ... 100
2025-10-18 18:28:33.496 | selecting default shared_buffers ... 128MB
2025-10-18 18:28:33.990 | selecting default time zone ... UTC
2025-10-18 18:28:34.009 | creating configuration files ... ok
2025-10-18 18:28:34.112 | running bootstrap script ... ok
2025-10-18 18:28:34.237 | sh: locale: not found
2025-10-18 18:28:34.237 | 2025-10-18 10:28:34.237 UTC [30] WARNING:  no usable system locales were found
2025-10-18 18:28:34.587 | performing post-bootstrap initialization ... ok
2025-10-18 18:28:35.453 | syncing data to disk ... ok
2025-10-18 18:28:35.453 | 
2025-10-18 18:28:35.453 | 
2025-10-18 18:28:35.453 | Success. You can now start the database server using:
2025-10-18 18:28:35.453 | 
2025-10-18 18:28:35.453 |     pg_ctl -D /var/lib/postgresql/data -l logfile start
2025-10-18 18:28:35.453 | 
2025-10-18 18:28:35.453 | initdb: warning: enabling "trust" authentication for local connections
2025-10-18 18:28:35.453 | You can change this by editing pg_hba.conf or using the option -A, or
2025-10-18 18:28:35.453 | --auth-local and --auth-host, the next time you run initdb.
2025-10-18 18:28:35.485 | waiting for server to start....2025-10-18 10:28:35.485 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
2025-10-18 18:28:35.512 | 2025-10-18 10:28:35.512 UTC [35] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-10-18 18:28:35.621 | 2025-10-18 10:28:35.621 UTC [36] LOG:  database system was shut down at 2025-10-18 10:28:34 UTC
2025-10-18 18:28:35.655 | 2025-10-18 10:28:35.655 UTC [35] LOG:  database system is ready to accept connections
2025-10-18 18:28:35.660 |  done
2025-10-18 18:28:35.660 | server started
2025-10-18 18:28:37.133 | CREATE DATABASE
2025-10-18 18:28:37.133 | 
2025-10-18 18:28:37.133 | 
2025-10-18 18:28:37.133 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
2025-10-18 18:28:37.133 | 
2025-10-18 18:28:37.134 | waiting for server to shut down....2025-10-18 10:28:37.134 UTC [35] LOG:  received fast shutdown request
2025-10-18 18:28:37.179 | 2025-10-18 10:28:37.179 UTC [35] LOG:  aborting any active transactions
2025-10-18 18:28:37.179 | 2025-10-18 10:28:37.179 UTC [35] LOG:  background worker "logical replication launcher" (PID 42) exited with exit code 1
2025-10-18 18:28:37.179 | 2025-10-18 10:28:37.179 UTC [37] LOG:  shutting down
2025-10-18 18:28:37.455 | 2025-10-18 10:28:37.455 UTC [35] LOG:  database system is shut down
2025-10-18 18:28:37.535 |  done
2025-10-18 18:28:37.535 | server stopped
2025-10-18 18:28:37.535 | 
2025-10-18 18:28:37.535 | PostgreSQL init process complete; ready for start up.
2025-10-18 18:28:37.535 | 
2025-10-18 18:28:37.587 | 2025-10-18 10:28:37.587 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
2025-10-18 18:28:37.587 | 2025-10-18 10:28:37.587 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-10-18 18:28:37.587 | 2025-10-18 10:28:37.587 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-10-18 18:28:37.679 | 2025-10-18 10:28:37.679 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-10-18 18:28:37.821 | 2025-10-18 10:28:37.821 UTC [49] LOG:  database system was shut down at 2025-10-18 10:28:37 UTC
2025-10-18 18:28:37.863 | 2025-10-18 10:28:37.863 UTC [1] LOG:  database system is ready to accept connections
2025-10-18 18:28:46.704 | 2025-10-18 10:28:46.704 UTC [56] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:28:46.704 | 2025-10-18 10:28:46.704 UTC [56] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:28:54.964 | 2025-10-18 10:28:54.964 UTC [57] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:28:54.964 | 2025-10-18 10:28:54.964 UTC [57] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:29:03.120 | 2025-10-18 10:29:03.120 UTC [58] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:29:03.120 | 2025-10-18 10:29:03.120 UTC [58] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:29:11.227 | 2025-10-18 10:29:11.227 UTC [59] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:29:11.227 | 2025-10-18 10:29:11.227 UTC [59] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:29:19.467 | 2025-10-18 10:29:19.467 UTC [60] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:29:19.467 | 2025-10-18 10:29:19.467 UTC [60] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:29:28.456 | 2025-10-18 10:29:28.456 UTC [61] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:29:28.456 | 2025-10-18 10:29:28.456 UTC [61] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:29:38.988 | 2025-10-18 10:29:38.988 UTC [63] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:29:38.988 | 2025-10-18 10:29:38.988 UTC [63] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:29:52.761 | 2025-10-18 10:29:52.761 UTC [64] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:29:52.761 | 2025-10-18 10:29:52.761 UTC [64] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:30:12.873 | 2025-10-18 10:30:12.873 UTC [65] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:30:12.873 | 2025-10-18 10:30:12.873 UTC [65] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:30:52.548 | 2025-10-18 10:30:52.548 UTC [67] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:30:52.553 | 2025-10-18 10:30:52.548 UTC [67] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:31:00.642 | 2025-10-18 10:31:00.642 UTC [68] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:31:00.642 | 2025-10-18 10:31:00.642 UTC [68] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB
2025-10-18 18:31:08.864 | 2025-10-18 10:31:08.864 UTC [70] ERROR:  relation "vulnerability" does not exist
2025-10-18 18:31:08.864 | 2025-10-18 10:31:08.864 UTC [70] STATEMENT:  ALTER TABLE vulnerability ADD COLUMN custom_fields JSONB

[idlefire]

2025-10-18T10:54:25+0000 - passlib.handlers.bcrypt - WARNING {MainThread} [pid:43] [bcrypt.py:622 - _load_backend_mixin()]  (trapped) error reading bcrypt version
Traceback (most recent call last):
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 620, in _load_backend_mixin
    version = _bcrypt.__about__.__version__
              ^^^^^^^^^^^^^^^^^
AttributeError: module 'bcrypt' has no attribute '__about__'
Traceback (most recent call last):
  File "/usr/local/bin/faraday-manage", line 7, in <module>
    sys.exit(cli())
             ^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1462, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1383, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1850, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1246, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 814, in invoke
    return callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/faraday/manage.py", line 187, in create_superuser
    password=hash_password(password),
             ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask_security/utils.py", line 388, in hash_password
    return _pwd_context.hash(
           ^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/context.py", line 2258, in hash
    return record.hash(secret, **kwds)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 779, in hash
    self.checksum = self._calc_checksum(secret)
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 591, in _calc_checksum
    self._stub_requires_backend()
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2254, in _stub_requires_backend
    cls.set_backend()
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2156, in set_backend
    return owner.set_backend(name, dryrun=dryrun)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2163, in set_backend
    return cls.set_backend(name, dryrun=dryrun)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2188, in set_backend
    cls._set_backend(name, dryrun)
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2311, in _set_backend
    super(SubclassBackendMixin, cls)._set_backend(name, dryrun)
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2224, in _set_backend
    ok = loader(**kwds)
         ^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 626, in _load_backend_mixin
    return mixin_cls._finalize_backend_mixin(name, dryrun)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 421, in _finalize_backend_mixin
    if detect_wrap_bug(IDENT_2A):
       ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 380, in detect_wrap_bug
    if verify(secret, bug_hash):
       ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 792, in verify
    return consteq(self._calc_checksum(secret), chk)
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 655, in _calc_checksum
    hash = _bcrypt.hashpw(secret, config)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ValueError: password cannot be longer than 72 bytes, truncate manually if necessary (e.g. my_password[:72])

[idlefire]

python:3.11-slim-bookworm not work.
python:3.18-slim-bookworm is work

[idlefire]

2025-10-18T10:54:25+0000 - passlib.handlers.bcrypt - WARNING {MainThread} [pid:43] [bcrypt.py:622 - _load_backend_mixin()]  (trapped) error reading bcrypt version
Traceback (most recent call last):
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 620, in _load_backend_mixin
    version = _bcrypt.__about__.__version__
              ^^^^^^^^^^^^^^^^^
AttributeError: module 'bcrypt' has no attribute '__about__'
Traceback (most recent call last):
  File "/usr/local/bin/faraday-manage", line 7, in <module>
    sys.exit(cli())
             ^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1462, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1383, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1850, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1246, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/click/core.py", line 814, in invoke
    return callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/faraday/manage.py", line 187, in create_superuser
    password=hash_password(password),
             ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask_security/utils.py", line 388, in hash_password
    return _pwd_context.hash(
           ^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/context.py", line 2258, in hash
    return record.hash(secret, **kwds)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 779, in hash
    self.checksum = self._calc_checksum(secret)
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 591, in _calc_checksum
    self._stub_requires_backend()
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2254, in _stub_requires_backend
    cls.set_backend()
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2156, in set_backend
    return owner.set_backend(name, dryrun=dryrun)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2163, in set_backend
    return cls.set_backend(name, dryrun=dryrun)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2188, in set_backend
    cls._set_backend(name, dryrun)
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2311, in _set_backend
    super(SubclassBackendMixin, cls)._set_backend(name, dryrun)
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 2224, in _set_backend
    ok = loader(**kwds)
         ^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 626, in _load_backend_mixin
    return mixin_cls._finalize_backend_mixin(name, dryrun)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 421, in _finalize_backend_mixin
    if detect_wrap_bug(IDENT_2A):
       ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 380, in detect_wrap_bug
    if verify(secret, bug_hash):
       ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/utils/handlers.py", line 792, in verify
    return consteq(self._calc_checksum(secret), chk)
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/passlib/handlers/bcrypt.py", line 655, in _calc_checksum
    hash = _bcrypt.hashpw(secret, config)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ValueError: password cannot be longer than 72 bytes, truncate manually if necessary (e.g. my_password[:72])

pyca/bcrypt#1079
https://foss.heptapod.net/python-libs/passlib/-/issues/196

bcrypt 4.3.0 is ok

[idlefire]

https://docs.celeryq.dev/en/v5.5.3/history/whatsnew-5.4.html
celery 5.4.0 not support py3.11
This version is officially supported on CPython 3.8, 3.9 & 3.10 and is also supported on PyPy3.8+.

[maserde]

any update on this issue?

[ezk06eer]

Hi, @idlefire it seems you are not in a clean install, check what youre mounting on the persistent volume.
This means you already have a previous install.
"permissions on existing directory /var/lib/postgresql/data"

If your problem still persist, share the docker compose file.

Please startover with a clean install.

Cheers!

[efocareta-del]

I am on a clean install, i attempted on two different docker instances and both gave me the same issue.
Any update ?

[maserde]

I am also using the default docker-compose file, some containers are correctly deployed but the "app" container is having issue creating default admin account with this error:

ValueError: password cannot be longer than 72 bytes, truncate manually if necessary (e.g. my_password[:72])

[idlefire]

My solution is:

1. Use bcrypt version 4.3.0
2. Modify the Dockerfile to use python:3.8-slim-bookworm

[efocareta-del]

@idlefire thanks! it worked

I also attempted to force version 5.16.0 and it solved.

Thanks