Error / Internal Server Error about papermerge HOT 11 CLOSED

i will deploy both stacks and send you the log seperatly in 5 min

from papermerge.

Can you please attach full webapp's docker log ?

Issue may be related (or even the same?) to Issue#579. In case it is same problem - well, I am currently working on it!

from papermerge.

only Web App + Worker

_papermerge-web-1_logs.txt

from papermerge.

PostgreSQL compose

_papermerge-web-1_logs (1).txt

from papermerge.

In case of last logs there is an error:

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "core_user" does not exist
LINE 2: FROM core_user 
             ^

Which means that in your case tables were not created. Could you check if db postgresql://scott:tiger@db:5432/mydatabase is accessible (i.e. you can connect to it) and it has some tables in it (e.g. core_use) ?

It is interesting, because I literally just copy paste this docker compose:

  version: "3.9"

  x-backend: &common
    image: papermerge/papermerge:3.0.1
    environment:
        PAPERMERGE__SECURITY__SECRET_KEY: 12345
        PAPERMERGE__AUTH__USERNAME: john
        PAPERMERGE__AUTH__PASSWORD: hohoho
        PAPERMERGE__DATABASE__URL: postgresql://scott:tiger@db:5432/mydatabase
        PAPERMERGE__REDIS__URL: redis://redis:6379/0
    volumes:
      - index_db:/core_app/index_db
      - media:/core_app/media
  services:
    web:
      <<: *common
      ports:
       - "12000:80"
      depends_on:
        - redis
        - db
    worker:
      <<: *common
      command: worker
    redis:
      image: redis:6
    db:
      image: bitnami/postgresql:14.4.0
      volumes:
        - postgres_data:/var/lib/postgresql/data/
      environment:
        POSTGRES_USER: scott
        POSTGRES_PASSWORD: tiger
        POSTGRES_DB: mydatabase
  volumes:
    postgres_data:
    index_db:
    media:

And then docker compose up just works (means db is created, I can authenticate with username john).

from papermerge.

could you quickly tell me how i could test it.

here is the log from db
_papermerge-db-1_logs.txt

from papermerge.

I found the problem. The problem is that docker compose's "depends_on" waits only for the container to start, but not the service inside it; in other words "db" container may be up, while actual initialization of the postgres/mysql database is not yet ready!

I will fix that part. Thank you again for reporting the problem!

from papermerge.

@tobasium
I've published 3.0.2.
Also in documentation I've updated docker-compose examples to include healthcheck key - which ensures that webapp/workers will start only after database process (not just db container) is up and running. Please use update docker compose examples.

from papermerge.

Hi, tested, and found new error: MySQL / MariaDB compose
_papermerge-web-1_logs.txt

from papermerge.

Hi tested, Solr compose works. so that i can login into pm but solr container exits after start with following error:

Cannot write to /var/solr as 8983:8983
drwxr-xr-x 2 root root 2 Jan 21 17:02 /var/solr
Cannot write to /var/solr as 8983:8983
drwxr-xr-x 2 root root 2 Jan 21 17:02 /var/solr

from papermerge.

I am closing the ticket as original issue was solved (original issue was that app started before db service was up, which caused "core_user table not found exception" - fixed in 3.0.2).

from papermerge.