search

inventree / InvenTree

Open Source Inventory Management System
https://docs.inventree.org
MIT License
4.26k stars 770 forks source link

cannot access Inventree #4859

Closed BinaryAlps closed 1 year ago

BinaryAlps commented 1 year ago

Deployment Method

Describe the problem*

I followed the docs for setting up Inventree with docker in production but once I run the docker compose up -d command I cannot access Inventree. I am installing Inventree from scratch, no update.

Looking at thee containers I can see that db, server and worker are up and running, however the logs do not really contain any useful information for me. Here is my docker-compose.yml file:

version: "3.8"

services:
    # Database service
    # Use PostgreSQL as the database backend
    inventree-db:
        container_name: inventree-db
        image: postgres:13
        expose:
            - ${INVENTREE_DB_PORT:-5433}/tcp
        environment:
            - PGDATA=/var/lib/postgresql/data/pgdb
            - POSTGRES_USER=${INVENTREE_DB_USER}
            - POSTGRES_PASSWORD=${INVENTREE_DB_PASSWORD}
            - POSTGRES_DB=${INVENTREE_DB_NAME}
        volumes:
            # Map 'data' volume such that postgres database is stored externally
            - inventree_data:/var/lib/postgresql/data/
        restart: unless-stopped
        command: -p ${INVENTREE_DB_PORT:-5433}
        ports:
            - "${INVENTREE_DB_PORT:-5433}:${INVENTREE_DB_PORT:-5433}"

    # redis acts as database cache manager
    # only runs under the "redis" profile : https://docs.docker.com/compose/profiles/
    inventree-cache:
        container_name: inventree-cache
        image: redis:7.0
        depends_on:
            - inventree-db
        env_file:
            - .env
        profiles:
            - redis
        expose:
            - ${INVENTREE_CACHE_PORT:-6379}
        restart: always

    # InvenTree web server service
    # Uses gunicorn as the web server
    inventree-server:
        container_name: inventree-server
        # If you wish to specify a particular InvenTree version, do so here
        image: inventree/inventree:${INVENTREE_TAG:-stable}
        expose:
            - ${INVENTREE_WEB_PORT:-1337}
        depends_on:
            - inventree-db
        env_file:
            - .env
        volumes:
            # Data volume must map to /home/inventree/data
            - inventree_data:/home/inventree/data
        restart: unless-stopped
        ports:
            - "${INVENTREE_WEB_PORT:-1337}:${INVENTREE_WEB_PORT:-1337}"

    # Background worker process handles long-running or periodic tasks
    inventree-worker:
        container_name: inventree-worker
        # If you wish to specify a particular InvenTree version, do so here
        image: inventree/inventree:${INVENTREE_TAG:-stable}
        command: invoke worker
        depends_on:
            - inventree-server
        env_file:
            - .env
        volumes:
            # Data volume must map to /home/inventree/data
            - inventree_data:/home/inventree/data
        restart: unless-stopped

volumes:
    # Persistent data, stored external to the container(s)
    inventree_data:
        driver: local
        driver_opts:
            type: none
            o: bind
            # This directory specified where InvenTree data are stored "outside" the docker containers
            device: ${INVENTREE_EXT_VOLUME}

networks:
  default:
    name: nginx-reverseproxy_default
    external: true

This is my .env file:

INVENTREE_EXT_VOLUME=/home/inventree/data
INVENTREE_WEB_PORT=1337
INVENTREE_DEBUG=False
INVENTREE_LOG_LEVEL=WARNING
INVENTREE_ADMIN_USER=administrator
INVENTREE_ADMIN_PASSWORD=superadminpassw0rd
INVENTREE_ADMIN_EMAIL=my@mail.com
INVENTREE_DB_ENGINE=postgresql
INVENTREE_DB_NAME=inventree
INVENTREE_DB_HOST=inventree-db
INVENTREE_DB_PORT=5433
INVENTREE_DB_USER=inventree-admin
INVENTREE_DB_PASSWORD=dbpassw0rd
INVENTREE_PLUGINS_ENABLED=False
INVENTREE_TAG=stable
COMPOSE_PROJECT_NAME=inventree-production

In my portainer overview I can see that the containers are up & running and the published ports are as intended:

image

Nevertheless the logfiles do not hint why I cannot access my installation.

Looking for some help here.

Steps to Reproduce

  1. follow the steps described in the docs

Relevant log output

db:
PostgreSQL Database directory appears to contain a database; Skipping initialization

2023-05-21 09:24:12.201 UTC [1] LOG:  starting PostgreSQL 13.11 (Debian 13.11-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2023-05-21 09:24:12.205 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5433
2023-05-21 09:24:12.205 UTC [1] LOG:  listening on IPv6 address "::", port 5433
2023-05-21 09:24:12.217 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5433"
2023-05-21 09:24:12.223 UTC [26] LOG:  database system was shut down at 2023-05-21 09:23:56 UTC
2023-05-21 09:24:12.232 UTC [1] LOG:  database system is ready to accept connections

server:
Loading config file : /home/inventree/data/config.yaml
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
09:24:30 [Q] INFO Enqueued 19289
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
09:24:30 [Q] INFO Enqueued 19290
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
09:24:30 [Q] INFO Enqueued 19291
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
09:24:31 [Q] INFO Enqueued 19292
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git

worker:
Loading config file : /home/inventree/data/config.yaml
Waiting for database...
Database connection sucessful!
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
09:24:29 [Q] INFO Enqueued 19288
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
09:24:30 [Q] INFO Q Cluster north-lake-louisiana-juliet starting.
09:24:30 [Q] INFO Process-1:1 ready for work at 78
09:24:30 [Q] INFO Process-1:2 ready for work at 79
09:24:30 [Q] INFO Process-1:3 ready for work at 80
09:24:30 [Q] INFO Process-1:4 ready for work at 81
09:24:30 [Q] INFO Process-1:5 monitoring at 82
09:24:30 [Q] INFO Process-1 guarding cluster north-lake-louisiana-juliet
09:24:30 [Q] INFO Process-1:6 pushing tasks at 83
09:24:30 [Q] INFO Q Cluster north-lake-louisiana-juliet running.
09:24:30 [Q] INFO Process-1:1 processing [carpet-edward-oklahoma-vegan]
09:24:30 [Q] INFO Process-1:2 processing [august-hotel-solar-sad]
09:24:30 [Q] INFO Process-1:3 processing [xray-may-georgia-four]
09:24:30 [Q] INFO Process-1:4 processing [mississippi-black-xray-south]
09:24:30 [Q] INFO Processed [carpet-edward-oklahoma-vegan]
09:24:30 [Q] INFO Processed [mississippi-black-xray-south]
09:24:30 [Q] INFO Processed [august-hotel-solar-sad]
09:24:30 [Q] INFO Processed [xray-may-georgia-four]
09:24:31 [Q] INFO Process-1:1 processing [skylark-thirteen-cold-uniform]
09:24:31 [Q] INFO Processed [skylark-thirteen-cold-uniform]
SchrodingersGat commented 1 year ago

I followed the docs for setting up Inventree with docker in production but once I run the docker compose up -d command I cannot access Inventree.

Can you please provide some more information about what you mean when you say you "cannot access inventree". Does the server not respond at all?

You should also remove your screenshot for your .env file as it contains a bare password. I hope it's not your real one!

In your .env file you have set INVENTREE_DEBUG=False - but you are using the development docker image

As per the production docker compose file you should have another container which is running nginx. This is required for serving media and static files

BinaryAlps commented 1 year ago

You should also remove your screenshot for your .env file as it contains a bare password. I hope it's not your real one!

no worries, those are made up just for here and are of course not my real ones.

As per the production docker compose file you should have another container which is running nginx. This is required for serving media and static files

I totally agree, I initially wanted to use my Nginx reverse proxy (that's why I had the network section added to the docker-compose.yml file and removed thee nginx section.

I have now started from scratch - removed my containers and also removed the volume binding as described in the docs.

I have added the docker-compose.yml, .env and nginx.prod.conf file to my inventree folder and run docker compose run inventree-server invoke update (which took some time) and then finally docker-compose up -d. When I try to access Inventree via http://ip:1337 (I defined 1337 as port) in the browser I get a 502:

image

This time I have more log information available. db log:

2023-05-21 14:43:15.477 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.477 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.480 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.480 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.482 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.482 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.484 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.484 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.486 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.486 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.488 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.488 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.489 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.489 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.492 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.492 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.494 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.494 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.503 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.503 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.506 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.506 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:15.991 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:15.991 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:16.554 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:16.554 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:20.237 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:20.237 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.424 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.424 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.450 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.450 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.461 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.461 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.471 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.471 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.482 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.482 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.499 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.499 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.522 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.522 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.526 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.526 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.529 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.529 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.531 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.531 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.534 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.534 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.537 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.537 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.541 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.541 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.544 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.544 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.548 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.548 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.552 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.552 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.555 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.555 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.559 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.559 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.562 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.562 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.566 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.566 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.570 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.570 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.574 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.574 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.586 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.586 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:21.590 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:21.590 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:22.142 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:22.142 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:22.766 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:22.766 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:27.605 UTC [75] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:27.605 UTC [75] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:27.609 UTC [75] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:27.609 UTC [75] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('PLUGIN_ON_STARTUP') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:27.648 UTC [75] ERROR:  relation "plugin_pluginconfig" does not exist at character 131
2023-05-21 14:43:27.648 UTC [75] STATEMENT:  SELECT "plugin_pluginconfig"."id", "plugin_pluginconfig"."key", "plugin_pluginconfig"."name", "plugin_pluginconfig"."active" FROM "plugin_pluginconfig" WHERE ("plugin_pluginconfig"."key" = 'inventreebarcode' AND "plugin_pluginconfig"."name" = 'InvenTreeBarcode') LIMIT 21
2023-05-21 14:43:28.462 UTC [75] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:28.462 UTC [75] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:35.085 UTC [76] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:35.085 UTC [76] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:35.089 UTC [76] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:35.089 UTC [76] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('PLUGIN_ON_STARTUP') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-21 14:43:35.127 UTC [76] ERROR:  relation "plugin_pluginconfig" does not exist at character 131
2023-05-21 14:43:35.127 UTC [76] STATEMENT:  SELECT "plugin_pluginconfig"."id", "plugin_pluginconfig"."key", "plugin_pluginconfig"."name", "plugin_pluginconfig"."active" FROM "plugin_pluginconfig" WHERE ("plugin_pluginconfig"."key" = 'inventreebarcode' AND "plugin_pluginconfig"."name" = 'InvenTreeBarcode') LIMIT 21
2023-05-21 14:43:35.772 UTC [76] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-21 14:43:35.772 UTC [76] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1

I connected to the db container and run a \qt on the inventree database - it shows me 98 rows:

inventree-# \dt
                          List of relations
 Schema |                Name                | Type  |     Owner
--------+------------------------------------+-------+----------------
 public | account_emailaddress               | table | inventree-admin
 public | account_emailconfirmation          | table | inventree-admin
 public | auth_group                         | table | inventree-admin
 public | auth_group_permissions             | table | inventree-admin
 public | auth_permission                    | table | inventree-admin
 public | auth_user                          | table | inventree-admin
 public | auth_user_groups                   | table | inventree-admin
 public | auth_user_user_permissions         | table | inventree-admin
 public | authtoken_token                    | table | inventree-admin
 public | build_build                        | table | inventree-admin
 public | build_builditem                    | table | inventree-admin
 public | build_buildorderattachment         | table | inventree-admin
 public | common_colortheme                  | table | inventree-admin
 public | common_inventreesetting            | table | inventree-admin
 public | common_inventreeusersetting        | table | inventree-admin
 public | common_newsfeedentry               | table | inventree-admin
 public | common_notificationentry           | table | inventree-admin
 public | common_notificationmessage         | table | inventree-admin
 public | common_webhookendpoint             | table | inventree-admin
 public | common_webhookmessage              | table | inventree-admin
 public | company_company                    | table | inventree-admin
 public | company_companyattachment          | table | inventree-admin
 public | company_contact                    | table | inventree-admin
 public | company_manufacturerpart           | table | inventree-admin
 public | company_manufacturerpartattachment | table | inventree-admin
 public | company_manufacturerpartparameter  | table | inventree-admin
 public | django_admin_log                   | table | inventree-admin
 public | django_content_type                | table | inventree-admin
 public | django_migrations                  | table | inventree-admin
 public | django_q_ormq                      | table | inventree-admin
 public | django_q_schedule                  | table | inventree-admin
 public | django_q_task                      | table | inventree-admin
 public | django_site                        | table | inventree-admin
 public | error_report_error                 | table | inventree-admin
 public | exchange_exchangebackend           | table | inventree-admin
 public | exchange_rate                      | table | inventree-admin
 public | label_partlabel                    | table | inventree-admin
 public | label_stockitemlabel               | table | inventree-admin
 public | label_stocklocationlabel           | table | inventree-admin
 public | order_purchaseorder                | table | inventree-admin
 public | order_purchaseorderattachment      | table | inventree-admin
 public | order_purchaseorderextraline       | table | inventree-admin
 public | order_purchaseorderlineitem        | table | inventree-admin
 public | order_returnorder                  | table | inventree-admin
 public | order_returnorderattachment        | table | inventree-admin
 public | order_returnorderextraline         | table | inventree-admin
 public | order_returnorderlineitem          | table | inventree-admin
 public | order_salesorder                   | table | inventree-admin
 public | order_salesorderallocation         | table | inventree-admin
 public | order_salesorderattachment         | table | inventree-admin
 public | order_salesorderextraline          | table | inventree-admin
 public | order_salesorderlineitem           | table | inventree-admin
 public | order_salesordershipment           | table | inventree-admin
 public | otp_static_staticdevice            | table | inventree-admin
 public | otp_static_statictoken             | table | inventree-admin
 public | otp_totp_totpdevice                | table | inventree-admin
 public | part_bomitem                       | table | inventree-admin
 public | part_bomitemsubstitute             | table | inventree-admin
 public | part_part                          | table | inventree-admin
 public | part_partattachment                | table | inventree-admin
 public | part_partcategory                  | table | inventree-admin
 public | part_partcategoryparametertemplate | table | inventree-admin
 public | part_partcategorystar              | table | inventree-admin
 public | part_partinternalpricebreak        | table | inventree-admin
 public | part_partparameter                 | table | inventree-admin
 public | part_partparametertemplate         | table | inventree-admin
 public | part_partpricing                   | table | inventree-admin
 public | part_partrelated                   | table | inventree-admin
 public | part_partsellpricebreak            | table | inventree-admin
 public | part_partstar                      | table | inventree-admin
 public | part_partstocktake                 | table | inventree-admin
 public | part_partstocktakereport           | table | inventree-admin
 public | part_parttesttemplate              | table | inventree-admin
 public | part_supplierpart                  | table | inventree-admin
 public | part_supplierpricebreak            | table | inventree-admin
 public | plugin_notificationusersetting     | table | inventree-admin
 public | plugin_pluginconfig                | table | inventree-admin
 public | plugin_pluginsetting               | table | inventree-admin
 public | report_billofmaterialsreport       | table | inventree-admin
 public | report_buildreport                 | table | inventree-admin
 public | report_purchaseorderreport         | table | inventree-admin
 public | report_reportasset                 | table | inventree-admin
 public | report_reportsnippet               | table | inventree-admin
 public | report_returnorderreport           | table | inventree-admin
 public | report_salesorderreport            | table | inventree-admin
 public | report_testreport                  | table | inventree-admin
 public | socialaccount_socialaccount        | table | inventree-admin
 public | socialaccount_socialapp            | table | inventree-admin
 public | socialaccount_socialapp_sites      | table | inventree-admin
 public | socialaccount_socialtoken          | table | inventree-admin
 public | stock_stockitem                    | table | inventree-admin
 public | stock_stockitemattachment          | table | inventree-admin
 public | stock_stockitemtestresult          | table | inventree-admin
 public | stock_stockitemtracking            | table | inventree-admin
 public | stock_stocklocation                | table | inventree-admin
 public | user_sessions_session              | table | inventree-admin
 public | users_owner                        | table | inventree-admin
 public | users_ruleset                      | table | inventree-admin
(98 rows)

server log:

Loading config file : /home/inventree/data/config.yaml
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
14:46:51 [Q] INFO Enqueued 3
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
14:46:51 [Q] INFO Enqueued 4
fatal: not a git repository (or any of the parent directories): .git
14:46:51 [Q] INFO Enqueued 5
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
14:46:51 [Q] INFO Enqueued 6
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git

worker logs:

    res = f(*task["args"], **task["kwargs"])
  File "/home/inventree/InvenTree/InvenTree/tasks.py", line 332, in delete_successful_tasks
    days = InvenTreeSetting.get_setting('INVENTREE_DELETE_TASKS_DAYS', 30)
  File "/home/inventree/InvenTree/common/models.py", line 432, in get_setting
    setting = cls.get_setting_object(key, **kwargs)
  File "/home/inventree/InvenTree/common/models.py", line 411, in get_setting_object
    setting.save(**kwargs)
  File "/home/inventree/InvenTree/common/models.py", line 871, in save
    super().save()
  File "/home/inventree/InvenTree/common/models.py", line 104, in save
    self.validate_unique(**kwargs)
  File "/home/inventree/InvenTree/common/models.py", line 616, in validate_unique
    raise ValidationError({'key': _('Key string must be unique')})
django.core.exceptions.ValidationError: {'key': ['Key string must be unique']}

14:47:21 [Q] INFO Process-1:1 processing [tennis-xray-seventeen-ink]
/root/.local/lib/python3.9/site-packages/django/db/models/fields/__init__.py:1416: RuntimeWarning: DateTimeField NotificationEntry.updated received a naive datetime (2023-02-20 14:47:21.764636) while time zone support is active.
  warnings.warn("DateTimeField %s received a naive datetime (%s)"
14:47:21 [Q] INFO Process-1:1 processing [freddie-foxtrot-tango-violet]
14:47:21 [Q] INFO Processed [august-queen-beryllium-lima]
14:47:21 [Q] INFO Processed [floor-kilo-yankee-fillet]
14:47:21 [Q] INFO Processed [winner-berlin-batman-five]
14:47:21 [Q] INFO Processed [lion-beryllium-foxtrot-salami]
14:47:21 [Q] INFO Process-1:4 processing [romeo-oranges-autumn-beryllium]
14:47:21 [Q] INFO Process-1:4 processing [fish-hamper-edward-cola]
14:47:21 [Q] INFO Processed [neptune-eighteen-mississippi-equal]
14:47:22 [Q] INFO Processed [stream-saturn-seventeen-cardinal]
14:47:22 [Q] INFO Processed [tennis-xray-seventeen-ink]
14:47:22 [Q] INFO Processed [potato-wisconsin-winner-florida]
14:47:22 [Q] INFO Processed [romeo-oranges-autumn-beryllium]
14:47:22 [Q] INFO Processed [fish-hamper-edward-cola]
14:47:22 [Q] INFO Processed [freddie-foxtrot-tango-violet]
14:47:22 [Q] INFO Processed [seventeen-robert-eleven-california]
14:47:25 [Q] INFO Processed [nuts-mountain-social-oregon]
14:49:21 [Q] INFO Process-1:4 processing [timing-aspen-nine-mexico]
14:49:21 [Q] INFO Processed [timing-aspen-nine-mexico]
14:51:22 [Q] INFO Enqueued 23
14:51:22 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
14:51:22 [Q] INFO Process-1:1 processing [iowa-ceiling-spaghetti-missouri]
14:51:22 [Q] INFO Processed [iowa-ceiling-spaghetti-missouri]
14:56:24 [Q] INFO Enqueued 24
14:56:24 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
14:56:24 [Q] INFO Process-1:3 processing [connecticut-indigo-lima-four]
14:56:24 [Q] INFO Processed [connecticut-indigo-lima-four]
15:01:25 [Q] INFO Enqueued 25
15:01:25 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:01:26 [Q] INFO Process-1:2 processing [mirror-hawaii-delaware-minnesota]
15:01:26 [Q] INFO Processed [mirror-hawaii-delaware-minnesota]
15:06:27 [Q] INFO Enqueued 26
15:06:27 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:06:27 [Q] INFO Process-1:4 processing [minnesota-bravo-cardinal-kansas]
15:06:27 [Q] INFO Processed [minnesota-bravo-cardinal-kansas]
15:10:59 [Q] INFO Enqueued 27
15:10:59 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:10:59 [Q] INFO Process-1:1 processing [finch-princess-low-solar]
15:10:59 [Q] INFO Processed [finch-princess-low-solar]
15:16:00 [Q] INFO Enqueued 28
15:16:00 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:16:01 [Q] INFO Process-1:3 processing [thirteen-papa-artist-william]
15:16:01 [Q] INFO Processed [thirteen-papa-artist-william]
15:21:02 [Q] INFO Enqueued 29
15:21:02 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:21:02 [Q] INFO Process-1:2 processing [october-oven-carpet-west]
15:21:02 [Q] INFO Processed [october-oven-carpet-west]
15:26:04 [Q] INFO Enqueued 30
15:26:04 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:26:04 [Q] INFO Process-1:4 processing [purple-pip-johnny-alanine]
15:26:04 [Q] INFO Processed [purple-pip-johnny-alanine]
15:31:06 [Q] INFO Enqueued 31
15:31:06 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:31:06 [Q] INFO Process-1:1 processing [muppet-juliet-three-fourteen]
15:31:06 [Q] INFO Processed [muppet-juliet-three-fourteen]
15:36:07 [Q] INFO Enqueued 32
15:36:07 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:36:08 [Q] INFO Process-1:3 processing [vegan-kitten-johnny-finch]
15:36:08 [Q] INFO Processed [vegan-kitten-johnny-finch]
15:41:09 [Q] INFO Enqueued 33
15:41:09 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:41:09 [Q] INFO Process-1:2 processing [magnesium-lamp-red-solar]
15:41:09 [Q] INFO Processed [magnesium-lamp-red-solar]
15:46:11 [Q] INFO Enqueued 34
15:46:11 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:46:11 [Q] INFO Process-1:4 processing [kentucky-carolina-winter-twelve]
15:46:11 [Q] INFO Processed [kentucky-carolina-winter-twelve]
15:51:13 [Q] INFO Enqueued 35
15:51:13 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:51:13 [Q] INFO Process-1:1 processing [magnesium-social-single-finch]
15:51:13 [Q] INFO Processed [magnesium-social-single-finch]
15:56:15 [Q] INFO Enqueued 36
15:56:15 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
15:56:15 [Q] INFO Process-1:3 processing [robin-summer-item-washington]
15:56:15 [Q] INFO Processed [robin-summer-item-washington]
16:01:16 [Q] INFO Enqueued 37
16:01:16 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
16:01:17 [Q] INFO Process-1:2 processing [jersey-alpha-don-ten]
16:01:17 [Q] INFO Processed [jersey-alpha-don-ten]
16:06:18 [Q] INFO Enqueued 38
16:06:18 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
16:06:18 [Q] INFO Process-1:4 processing [violet-kentucky-mississippi-juliet]
16:06:18 [Q] INFO Processed [violet-kentucky-mississippi-juliet]

proxy logs:

/docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
/docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
/docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
10-listen-on-ipv6-by-default.sh: info: can not modify /etc/nginx/conf.d/default.conf (read-only file system?)
/docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
/docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
/docker-entrypoint.sh: Configuration complete; ready for start up
2023/05/21 14:46:33 [notice] 1#1: using the "epoll" event method
2023/05/21 14:46:33 [notice] 1#1: nginx/1.24.0
2023/05/21 14:46:33 [notice] 1#1: built by gcc 10.2.1 20210110 (Debian 10.2.1-6) 
2023/05/21 14:46:33 [notice] 1#1: OS: Linux 5.4.0-107-generic
2023/05/21 14:46:33 [notice] 1#1: getrlimit(RLIMIT_NOFILE): 1048576:1048576
2023/05/21 14:46:33 [notice] 1#1: start worker processes
2023/05/21 14:46:33 [notice] 1#1: start worker process 21
2023/05/21 14:46:33 [notice] 1#1: start worker process 22
2023/05/21 14:47:17 [error] 21#21: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 193.83.108.244, server: , request: "GET / HTTP/1.1", upstream: "http://172.20.0.3:3737/", host: "serverip:1337"
193.83.108.244 - - [21/May/2023:14:47:17 +0000] "GET / HTTP/1.1" 502 559 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36" "-"
2023/05/21 14:47:17 [error] 21#21: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 193.83.108.244, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "http://172.20.0.3:3737/favicon.ico", host: "65.108.82.115:1337", referrer: "http://serverip:1337/"
193.83.108.244 - - [21/May/2023:14:47:17 +0000] "GET /favicon.ico HTTP/1.1" 502 559 "http://serverip:1337/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36" "-"

172.20.0.3 is the ip of the server container:

image

To me it looks like there is an issue with the database?

BR, Fabian

SchrodingersGat commented 1 year ago

Is it possible that you have multiple database instances, and the containers are connecting to the wrong one? If you have run invoke update (and it succeeded) then the messages about missing database relations does not make sense

BinaryAlps commented 1 year ago

Yes I have another stack that is running a postgres (also on another port). Within the stack I would assume that Inventree is connecting to the inventree-db container and not to any other container that is running a postgres.

Can I check to which postgres container/ip Inventree is trying to connect to?

SchrodingersGat commented 1 year ago

Can I check to which postgres container/ip Inventree is trying to connect to?

This is controlled by your .env file primarily - which looks fine from your post above. And you can see the "connection successful" message in the server logs.

If you are using a fresh install, can you try a complete purge and restart?

  1. docker compose down
  2. Delete the pgdb directory from your local volume
  3. docker compose run inventree-server invoke update
  4. docker compose up -d
BinaryAlps commented 1 year ago

Did all the four steps - still my inventree-db container is showing the same behavior in the logs.

Below the output of the four steps you suggested:

user@server:~# cd /home/inventree/
user@server:/home/inventree/data# ls data/
backup  config.yaml  media  pgdb  plugins.txt  secret_key.txt  static
user@server:/home/inventree# docker compose down
[+] Running 5/5
 ⠿ Container inventree-proxy             Removed                                                                                                                                                              0.4s
 ⠿ Container inventree-worker            Removed                                                                                                                                                             10.5s
 ⠿ Container inventree-server            Removed                                                                                                                                                             10.4s
 ⠿ Container inventree-db                Removed                                                                                                                                                              0.3s
 ⠿ Network inventree-production_default  Removed                                                                                                                                                              0.1s
user@server:/home/inventree# rm -r data/p
pgdb/        plugins.txt
user@server:/home/inventree# rm -r data/pgdb/
user@server:/home/inventree# ls data/
backup  config.yaml  media  plugins.txt  secret_key.txt  static
user@server:/home/inventree# docker compose run inventree-server invoke update
[+] Running 2/2
 ⠿ Network inventree-production_default  Created                                                                                                                                                              0.1s
 ⠿ Container inventree-db                Created                                                                                                                                                              0.1s
[+] Running 1/1
 ⠿ Container inventree-db  Started                                                                                                                                                                            0.8s
Loading config file : /home/inventree/data/config.yaml
Installing required python packages from 'requirements.txt'
Requirement already satisfied: pip in /usr/local/lib/python3.9/site-packages (23.1.2)
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
Requirement already satisfied: arrow==1.2.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 7)) (1.2.3)
Requirement already satisfied: asgiref==3.6.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 9)) (3.6.0)
Requirement already satisfied: babel==2.12.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 11)) (2.12.1)
Requirement already satisfied: bleach[css]==6.0.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 13)) (6.0.0)
Requirement already satisfied: blessed==1.20.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 15)) (1.20.0)
Requirement already satisfied: brotli==1.0.9 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 17)) (1.0.9)
Requirement already satisfied: certifi==2022.12.7 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 19)) (2022.12.7)
Requirement already satisfied: cffi==1.15.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 23)) (1.15.1)
Requirement already satisfied: charset-normalizer==3.1.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 27)) (3.1.0)
Requirement already satisfied: coreapi==2.3.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 29)) (2.3.3)
Requirement already satisfied: coreschema==0.0.4 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 31)) (0.0.4)
Requirement already satisfied: cryptography==40.0.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 33)) (40.0.1)
Requirement already satisfied: cssselect2==0.7.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 37)) (0.7.0)
Requirement already satisfied: defusedxml==0.7.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 39)) (0.7.1)
Requirement already satisfied: diff-match-patch==20200713 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 43)) (20200713)
Requirement already satisfied: django==3.2.18 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 45)) (3.2.18)
Requirement already satisfied: django-allauth==0.54.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 73)) (0.54.0)
Requirement already satisfied: django-allauth-2fa==0.10.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 77)) (0.10.0)
Requirement already satisfied: django-cleanup==7.0.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 79)) (7.0.0)
Requirement already satisfied: django-cors-headers==3.14.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 81)) (3.14.0)
Requirement already satisfied: django-crispy-forms==1.14.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 83)) (1.14.0)
Requirement already satisfied: django-dbbackup==4.0.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 85)) (4.0.2)
Requirement already satisfied: django-error-report==0.2.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 87)) (0.2.0)
Requirement already satisfied: django-filter==23.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 89)) (23.1)
Requirement already satisfied: django-formtools==2.4 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 91)) (2.4)
Requirement already satisfied: django-ical==1.8.4 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 93)) (1.8.4)
Requirement already satisfied: django-import-export==2.5.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 95)) (2.5.0)
Requirement already satisfied: django-js-asset==2.0.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 97)) (2.0.0)
Requirement already satisfied: django-maintenance-mode==0.18.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 99)) (0.18.0)
Requirement already satisfied: django-markdownify==0.9.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 101)) (0.9.3)
Requirement already satisfied: django-money==2.1.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 103)) (2.1.1)
Requirement already satisfied: django-mptt==0.11.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 105)) (0.11.0)
Requirement already satisfied: django-otp==1.1.6 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 107)) (1.1.6)
Requirement already satisfied: django-picklefield==3.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 109)) (3.1)
Requirement already satisfied: django-q==1.3.9 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 111)) (1.3.9)
Requirement already satisfied: django-q-sentry==0.1.6 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 113)) (0.1.6)
Requirement already satisfied: django-recurrence==1.11.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 115)) (1.11.1)
Requirement already satisfied: django-redis==5.2.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 117)) (5.2.0)
Requirement already satisfied: django-sql-utils==0.6.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 119)) (0.6.1)
Requirement already satisfied: django-sslserver==0.22 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 121)) (0.22)
Requirement already satisfied: django-stdimage==5.3.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 123)) (5.3.0)
Requirement already satisfied: django-user-sessions==2.0.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 125)) (2.0.0)
Requirement already satisfied: django-weasyprint==2.2.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 127)) (2.2.0)
Requirement already satisfied: django-xforwardedfor-middleware==2.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 129)) (2.0)
Requirement already satisfied: djangorestframework==3.14.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 131)) (3.14.0)
Requirement already satisfied: et-xmlfile==1.1.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 133)) (1.1.0)
Requirement already satisfied: feedparser==6.0.10 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 135)) (6.0.10)
Requirement already satisfied: fonttools[woff]==4.39.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 137)) (4.39.3)
Requirement already satisfied: gunicorn==20.1.0 in /usr/local/lib/python3.9/site-packages (from -r requirements.txt (line 139)) (20.1.0)
Requirement already satisfied: html5lib==1.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 141)) (1.1)
Requirement already satisfied: icalendar==5.0.4 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 143)) (5.0.4)
Requirement already satisfied: idna==3.4 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 145)) (3.4)
Requirement already satisfied: importlib-metadata==6.1.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 147)) (6.1.0)
Requirement already satisfied: itypes==1.2.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 149)) (1.2.0)
Requirement already satisfied: jinja2==3.1.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 151)) (3.1.2)
Requirement already satisfied: markdown==3.4.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 153)) (3.4.3)
Requirement already satisfied: markuppy==1.14 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 155)) (1.14)
Requirement already satisfied: markupsafe==2.1.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 157)) (2.1.2)
Requirement already satisfied: oauthlib==3.2.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 159)) (3.2.2)
Requirement already satisfied: odfpy==1.4.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 161)) (1.4.1)
Requirement already satisfied: openpyxl==3.1.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 163)) (3.1.2)
Requirement already satisfied: pdf2image==1.16.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 165)) (1.16.3)
Requirement already satisfied: pillow==9.5.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 167)) (9.5.0)
Requirement already satisfied: py-moneyed==1.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 175)) (1.2)
Requirement already satisfied: pycparser==2.21 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 179)) (2.21)
Requirement already satisfied: pydyf==0.6.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 181)) (0.6.0)
Requirement already satisfied: pyjwt[crypto]==2.6.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 183)) (2.6.0)
Requirement already satisfied: pyphen==0.14.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 185)) (0.14.0)
Requirement already satisfied: pypng==0.20220715.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 187)) (0.20220715.0)
Requirement already satisfied: python-barcode[images]==0.14.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 189)) (0.14.0)
Requirement already satisfied: python-dateutil==2.8.2 in /usr/local/lib/python3.9/site-packages (from -r requirements.txt (line 191)) (2.8.2)
Requirement already satisfied: python-fsutil==0.10.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 196)) (0.10.0)
Requirement already satisfied: python3-openid==3.2.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 198)) (3.2.0)
Requirement already satisfied: pytz==2023.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 200)) (2023.3)
Requirement already satisfied: pyyaml==6.0 in /usr/local/lib/python3.9/site-packages (from -r requirements.txt (line 206)) (6.0)
Requirement already satisfied: qrcode[pil]==7.4.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 208)) (7.4.2)
Requirement already satisfied: rapidfuzz==0.7.6 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 212)) (0.7.6)
Requirement already satisfied: redis==3.5.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 214)) (3.5.3)
Requirement already satisfied: regex==2023.3.23 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 218)) (2023.3.23)
Requirement already satisfied: requests==2.28.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 220)) (2.28.2)
Requirement already satisfied: requests-oauthlib==1.3.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 225)) (1.3.1)
Requirement already satisfied: sentry-sdk==1.18.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 227)) (1.18.0)
Requirement already satisfied: sgmllib3k==1.0.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 231)) (1.0.0)
Requirement already satisfied: six==1.16.0 in /usr/local/lib/python3.9/site-packages (from -r requirements.txt (line 233)) (1.16.0)
Requirement already satisfied: sqlparse==0.4.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 239)) (0.4.3)
Requirement already satisfied: tablib[html,ods,xls,xlsx,yaml]==3.4.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 243)) (3.4.0)
Requirement already satisfied: tinycss2==1.1.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 247)) (1.1.1)
Requirement already satisfied: typing-extensions==4.5.0 in /usr/local/lib/python3.9/site-packages (from -r requirements.txt (line 252)) (4.5.0)
Requirement already satisfied: uritemplate==4.1.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 254)) (4.1.1)
Requirement already satisfied: urllib3==1.26.15 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 256)) (1.26.15)
Requirement already satisfied: wcwidth==0.2.6 in /usr/local/lib/python3.9/site-packages (from -r requirements.txt (line 260)) (0.2.6)
Requirement already satisfied: weasyprint==54.3 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 262)) (54.3)
Requirement already satisfied: webencodings==0.5.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 266)) (0.5.1)
Requirement already satisfied: xlrd==2.0.1 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 272)) (2.0.1)
Requirement already satisfied: xlwt==1.3.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 274)) (1.3.0)
Requirement already satisfied: zipp==3.15.0 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 276)) (3.15.0)
Requirement already satisfied: zopfli==0.2.2 in /root/.local/lib/python3.9/site-packages (from -r requirements.txt (line 278)) (0.2.2)
Requirement already satisfied: setuptools in /usr/local/lib/python3.9/site-packages (from django-money==2.1.1->-r requirements.txt (line 103)) (65.6.3)
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
Backing up InvenTree database...
Backing Up Database: inventree
Writing file to default-bf2cec4e4442-2023-05-22-105836.psql.bin.gz
Backing up InvenTree media files...
Writing file to bf2cec4e4442-2023-05-22-105842.tar.gz
Running InvenTree database migrations...
========================================
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
No changes detected
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
Operations to perform:
  Apply all migrations: InvenTree, account, admin, auth, authtoken, build, common, company, contenttypes, django_q, error_report, exchange, label, order, otp_static, otp_totp, part, plugin, report, sites, socialaccount, stock, user_sessions, users
Running migrations:
  Applying InvenTree.0001_initial... OK
  Applying InvenTree.0002_auto_20230517_0458... OK
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... OK
  Applying account.0001_initial... OK
  Applying account.0002_email_max_length... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying admin.0003_logentry_add_action_flag_choices... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying auth.0002_alter_permission_name_max_length... OK
  Applying auth.0003_alter_user_email_max_length... OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null... OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying auth.0007_alter_validators_add_error_messages... OK
  Applying auth.0008_alter_user_username_max_length... OK
  Applying auth.0009_alter_user_last_name_max_length... OK
  Applying auth.0010_alter_group_name_max_length... OK
  Applying auth.0011_update_proxy_permissions... OK
  Applying auth.0012_alter_user_first_name_max_length... OK
  Applying authtoken.0001_initial... OK
  Applying authtoken.0002_auto_20160226_1747... OK
  Applying authtoken.0003_tokenproxy... OK
  Applying users.0001_initial... OK
  Applying users.0002_auto_20201004_0158... OK
  Applying users.0003_auto_20201005_2227... OK
  Applying users.0004_auto_20210113_1909... OK
  Applying users.0005_owner_model... OK
  Applying part.0001_initial... OK
  Applying company.0001_initial... OK
  Applying stock.0001_initial... OK
  Applying stock.0002_auto_20190525_2226... OK
  Applying stock.0003_auto_20190525_2303... OK
  Applying stock.0004_auto_20190525_2356... OK
  Applying stock.0005_auto_20190602_1944... OK
  Applying company.0002_auto_20190520_2204... OK
  Applying company.0003_remove_supplierpart_minimum... OK
  Applying company.0004_auto_20190525_2354... OK
  Applying company.0005_auto_20190525_2356... OK
  Applying order.0001_initial... OK
  Applying order.0002_auto_20190604_2224... OK
  Applying order.0003_auto_20190604_2226... OK
  Applying order.0004_purchaseorder_status... OK
  Applying order.0005_purchaseorderlineitem_part... OK
  Applying order.0006_auto_20190605_2056... OK
  Applying order.0007_auto_20190605_2138... OK
  Applying order.0008_auto_20190605_2140... OK
  Applying order.0009_auto_20190606_2133... OK
  Applying order.0010_purchaseorderlineitem_notes... OK
  Applying stock.0006_stockitem_purchase_order... OK
  Applying stock.0007_auto_20190618_0042... OK
  Applying stock.0008_stockitemtracking_url... OK
  Applying stock.0009_auto_20190715_2351... OK
  Applying build.0001_initial... OK
  Applying build.0002_auto_20190520_2204... OK
  Applying build.0003_auto_20190525_2355... OK
  Applying build.0004_auto_20190525_2356... OK
  Applying build.0005_auto_20190604_2217... OK
  Applying stock.0010_stockitem_build... OK
  Applying stock.0011_auto_20190908_0404... OK
  Applying stock.0012_auto_20190908_0405... OK
  Applying stock.0013_auto_20190908_0916... OK
  Applying stock.0014_auto_20190908_0918... OK
  Applying stock.0015_auto_20190913_1407... OK
  Applying stock.0016_auto_20191118_2146... OK
  Applying stock.0017_auto_20191118_2311... OK
  Applying stock.0018_auto_20200202_0103... OK
  Applying stock.0019_auto_20200202_1024... OK
  Applying stock.0020_auto_20200206_1213... OK
  Applying stock.0021_auto_20200215_2232... OK
  Applying stock.0022_auto_20200217_1109... OK
  Applying stock.0023_auto_20200318_1027... OK
  Applying stock.0024_auto_20200405_2239... OK
  Applying stock.0025_auto_20200405_2243... OK
  Applying stock.0026_stockitem_uid... OK
  Applying part.0002_auto_20190520_2204... OK
  Applying part.0003_auto_20190525_2226... OK
  Applying part.0004_auto_20190525_2356... OK
  Applying part.0005_auto_20190526_1119... OK
  Applying part.0006_auto_20190526_1215... OK
  Applying part.0007_auto_20190602_1944... OK
  Applying part.0008_auto_20190618_0042... OK
  Applying part.0009_part_virtual... OK
  Applying part.0010_auto_20190620_2135... OK
  Applying part.0011_part_revision... OK
  Applying part.0012_auto_20190627_2144... OK
  Applying part.0013_auto_20190628_0951... OK
  Applying part.0014_partparameter... OK
  Applying part.0015_auto_20190820_0251... OK
  Applying part.0016_auto_20190820_0257... OK
  Applying part.0017_bomitem_checksum... OK
  Applying part.0018_auto_20190907_0941... OK
  Applying part.0019_auto_20190908_0404... OK
  Applying part.0020_auto_20190908_0404... OK
  Applying part.0021_auto_20190908_0916... OK
  Applying part.0022_auto_20190908_0918... OK
  Applying part.0023_auto_20190913_1401... OK
  Applying part.0024_auto_20191118_2139... OK
  Applying part.0025_auto_20191118_2316... OK
  Applying part.0026_auto_20200131_1022... OK
  Applying part.0027_auto_20200202_1024... OK
  Applying part.0028_auto_20200203_1007... OK
  Applying part.0029_auto_20200223_0901... OK
  Applying part.0030_auto_20200318_1027... OK
  Applying part.0031_auto_20200318_1044... OK
  Applying part.0032_auto_20200322_0453... OK
  Applying part.0033_auto_20200404_0445... OK
  Applying part.0034_auto_20200404_1238... OK
  Applying part.0035_auto_20200406_0045... OK
  Applying order.0011_auto_20190615_1928... OK
  Applying order.0012_auto_20190617_1943... OK
  Applying order.0013_auto_20191118_2323... OK
  Applying order.0014_auto_20191118_2328... OK
  Applying order.0015_auto_20200201_2346... OK
  Applying order.0016_purchaseorderattachment... OK
  Applying order.0017_auto_20200331_1000... OK
  Applying order.0018_auto_20200406_0151... OK
  Applying order.0019_purchaseorder_supplier_reference... OK
  Applying common.0001_initial... OK
  Applying common.0002_auto_20190902_2304... OK
  Applying common.0003_auto_20190902_2310... OK
  Applying company.0006_supplierpricebreak_currency... OK
  Applying company.0007_remove_supplierpart_lead_time... OK
  Applying company.0008_auto_20190913_1407... OK
  Applying company.0009_auto_20191118_2323... OK
  Applying company.0010_auto_20200201_1231... OK
  Applying company.0011_auto_20200318_1114... OK
  Applying company.0012_auto_20200318_1114... OK
  Applying company.0013_auto_20200406_0131... OK
  Applying company.0014_auto_20200407_0116... OK
  Applying company.0015_company_is_manufacturer... OK
  Applying company.0016_auto_20200412_2330... OK
  Applying company.0017_auto_20200413_0320... OK
  Applying company.0018_supplierpart_manufacturer... OK
  Applying company.0019_auto_20200413_0642... OK
  Applying company.0020_auto_20200413_0839... OK
  Applying company.0021_remove_supplierpart_manufacturer_name... OK
  Applying order.0020_auto_20200420_0940... OK
  Applying order.0021_auto_20200420_1010... OK
  Applying order.0022_salesorderlineitem_part... OK
  Applying order.0023_auto_20200420_2309... OK
  Applying stock.0027_stockitem_sales_order... OK
  Applying stock.0028_auto_20200421_0724... OK
  Applying stock.0029_auto_20200421_2359... OK
  Applying stock.0030_auto_20200422_0015... OK
  Applying order.0024_salesorderallocation... OK
  Applying stock.0031_auto_20200422_0209... OK
  Applying order.0025_auto_20200422_0222... OK
  Applying order.0026_auto_20200422_0224... OK
  Applying order.0027_auto_20200422_0236... OK
  Applying order.0028_auto_20200423_0956... OK
  Applying order.0029_auto_20200423_1042... OK
  Applying build.0006_auto_20190913_1407... OK
  Applying build.0007_auto_20191118_2321... OK
  Applying build.0008_auto_20200201_1247... OK
  Applying build.0009_auto_20200210_1032... OK
  Applying build.0010_auto_20200318_1027... OK
  Applying build.0011_auto_20200406_0123... OK
  Applying build.0012_build_sales_order... OK
  Applying build.0013_auto_20200425_0507... OK
  Applying build.0014_auto_20200425_1243... OK
  Applying build.0015_auto_20200425_1350... OK
  Applying stock.0032_stockitem_build_order... OK
  Applying stock.0033_auto_20200426_0539... OK
  Applying order.0030_auto_20200426_0551... OK
  Applying build.0016_auto_20200426_0551... OK
  Applying stock.0034_auto_20200426_0602... OK
  Applying stock.0035_auto_20200502_2308... OK
  Applying stock.0036_stockitemattachment... OK
  Applying stock.0037_stockitemattachment_user... OK
  Applying stock.0038_stockitemattachment_upload_date... OK
  Applying stock.0039_auto_20200513_0016... OK
  Applying stock.0040_stockitemtestresult... OK
  Applying stock.0041_stockitemtestresult_notes... OK
  Applying stock.0042_auto_20200523_0121... OK
  Applying part.0036_partattachment_user... OK
  Applying part.0037_partattachment_upload_date... OK
  Applying part.0038_auto_20200513_0016... OK
  Applying part.0039_auto_20200515_1127... OK
  Applying part.0040_parttesttemplate... OK
  Applying part.0041_auto_20200517_0348... OK
  Applying part.0042_auto_20200518_0900... OK
  Applying stock.0043_auto_20200525_0420... OK
  Applying stock.0044_auto_20200528_1036... OK
  Applying stock.0045_stockitem_customer... OK
  Applying stock.0046_auto_20200605_0931... OK
  Applying stock.0047_auto_20200605_0932... OK
  Applying stock.0048_auto_20200807_2344... OK
  Applying part.0043_auto_20200527_0005... OK
  Applying part.0044_auto_20200605_0931... OK
  Applying part.0045_auto_20200605_0932... OK
  Applying company.0022_auto_20200613_1045... OK
  Applying company.0023_auto_20200808_0715... OK
  Applying stock.0049_auto_20200820_0454... OK
  Applying stock.0050_auto_20200821_1403... OK
  Applying stock.0051_auto_20200928_0928... OK
  Applying stock.0052_stockitem_is_building... OK
  Applying stock.0053_auto_20201110_0513... OK
  Applying stock.0054_remove_stockitem_build_order... OK
  Applying stock.0055_auto_20201117_1453... OK
  Applying stock.0056_stockitem_expiry_date... OK
  Applying stock.0057_stock_location_item_owner... OK
  Applying stock.0058_stockitem_packaging... OK
  Applying part.0046_auto_20200804_0107... OK
  Applying part.0047_auto_20200808_0715... OK
  Applying part.0048_auto_20200902_1404... OK
  Applying common.0004_inventreesetting... OK
  Applying common.0005_auto_20190915_1256... OK
  Applying common.0006_auto_20200203_0951... OK
  Applying common.0007_colortheme... OK
  Applying part.0049_partsellpricebreak... OK
  Applying part.0050_auto_20200917_2315... OK
  Applying part.0051_bomitem_optional... OK
  Applying part.0052_partrelated... OK
  Applying part.0054_auto_20201109_1246... OK
  Applying part.0055_auto_20201110_1001... OK
  Applying part.0056_auto_20201110_1125... OK
  Applying part.0057_remove_partsellpricebreak_currency... OK
  Applying part.0058_remove_partsellpricebreak_cost... OK
  Applying part.0059_auto_20201112_1112... OK
  Applying part.0053_partcategoryparametertemplate... OK
  Applying part.0060_merge_20201112_1722... OK
  Applying company.0024_unique_name_email_constraint... OK
  Applying company.0025_auto_20201110_1001... OK
  Applying company.0026_auto_20201110_1011... OK
  Applying company.0027_remove_supplierpricebreak_currency... OK
  Applying company.0028_remove_supplierpricebreak_cost... OK
  Applying company.0029_company_currency... OK
  Applying company.0030_auto_20201112_1112... OK
  Applying company.0031_auto_20210103_2215... OK
  Applying part.0061_auto_20210104_2331... OK
  Applying part.0061_auto_20210103_2313... OK
  Applying part.0062_merge_20210105_0056... OK
  Applying part.0063_bomitem_inherited... OK
  Applying part.0064_auto_20210404_2016... OK
  Applying part.0065_auto_20210505_2144... OK
  Applying part.0066_bomitem_allow_variants... OK
  Applying build.0017_auto_20200426_0612... OK
  Applying build.0018_build_reference... OK
  Applying build.0019_auto_20201019_1302... OK
  Applying build.0020_auto_20201019_1325... OK
  Applying build.0021_auto_20201020_0908_squashed_0026_auto_20201023_1228... OK
  Applying build.0022_buildorderattachment... OK
  Applying build.0023_auto_20201110_0911... OK
  Applying build.0024_auto_20201201_1023... OK
  Applying build.0025_build_target_date... OK
  Applying build.0026_auto_20210216_1539... OK
  Applying build.0027_auto_20210404_2016... OK
  Applying build.0028_builditem_bom_item... OK
  Applying build.0029_auto_20210601_1525... OK
  Applying build.0030_alter_build_reference... OK
  Applying build.0031_build_reference_int... OK
  Applying build.0032_auto_20211014_0632... OK
  Applying build.0033_auto_20211128_0151... OK
  Applying build.0034_alter_build_reference_int... OK
  Applying build.0035_alter_build_notes... OK
  Applying build.0036_auto_20220707_1101... OK
  Applying build.0037_build_priority... OK
  Applying build.0038_alter_build_responsible... OK
  Applying build.0039_auto_20230317_0816... OK
  Applying build.0040_auto_20230404_1310... OK
  Applying build.0041_alter_build_title... OK
  Applying common.0008_remove_inventreesetting_description... OK
  Applying common.0009_delete_currency... OK
  Applying common.0010_migrate_currency_setting... OK
  Applying common.0011_auto_20210722_2114... OK
  Applying common.0012_notificationentry... OK
  Applying common.0013_webhookendpoint_webhookmessage... OK
  Applying common.0014_notificationmessage... OK
  Applying common.0015_newsfeedentry... OK
  Applying common.0016_alter_notificationentry_updated... OK
  Applying company.0032_auto_20210403_1837... OK
  Applying company.0033_auto_20210410_1528... OK
  Applying company.0034_manufacturerpart... OK
  Applying company.0035_supplierpart_update_1... OK
  Applying company.0036_supplierpart_update_2... OK
  Applying company.0037_supplierpart_update_3... OK
  Applying company.0038_manufacturerpartparameter... OK
  Applying company.0039_auto_20210701_0509... OK
  Applying company.0040_alter_company_currency... OK
  Applying company.0041_alter_company_options... OK
  Applying company.0042_supplierpricebreak_updated... OK
  Applying company.0043_manufacturerpartattachment... OK
  Applying company.0044_auto_20220607_2204... OK
  Applying company.0045_alter_company_notes... OK
  Applying company.0046_alter_company_image... OK
  Applying company.0047_supplierpart_pack_size... OK
  Applying company.0048_auto_20220913_0312... OK
  Applying company.0049_company_metadata... OK
  Applying company.0050_alter_company_website... OK
  Applying company.0051_alter_supplierpricebreak_price... OK
  Applying company.0052_alter_supplierpricebreak_updated... OK
  Applying company.0053_supplierpart_updated... OK
  Applying company.0054_companyattachment... OK
  Applying company.0055_auto_20230317_0816... OK
  Applying django_q.0001_initial... OK
  Applying django_q.0002_auto_20150630_1624... OK
  Applying django_q.0003_auto_20150708_1326... OK
  Applying django_q.0004_auto_20150710_1043... OK
  Applying django_q.0005_auto_20150718_1506... OK
  Applying django_q.0006_auto_20150805_1817... OK
  Applying django_q.0007_ormq... OK
  Applying django_q.0008_auto_20160224_1026... OK
  Applying django_q.0009_auto_20171009_0915... OK
  Applying django_q.0010_auto_20200610_0856... OK
  Applying django_q.0011_auto_20200628_1055... OK
  Applying django_q.0012_auto_20200702_1608... OK
  Applying django_q.0013_task_attempt_count... OK
  Applying django_q.0014_schedule_cluster... OK
  Applying error_report.0001_initial... OK
  Applying exchange.0001_initial... OK
  Applying label.0001_initial... OK
  Applying label.0002_stockitemlabel_enabled... OK
  Applying label.0003_stocklocationlabel... OK
  Applying label.0004_auto_20210111_2302... OK
  Applying label.0005_auto_20210113_2302... OK
  Applying label.0006_auto_20210222_1535... OK
  Applying label.0007_auto_20210513_1327... OK
  Applying label.0008_auto_20210708_2106... OK
  Applying label.0009_auto_20230317_0816... OK
  Applying stock.0059_auto_20210404_2016... OK
  Applying stock.0060_auto_20210511_1713... OK
  Applying stock.0061_auto_20210511_0911... OK
  Applying stock.0062_auto_20210511_2151... OK
  Applying stock.0063_auto_20210511_2343... OK
  Applying stock.0064_auto_20210621_1724... OK
  Applying stock.0065_auto_20210701_0509... OK
  Applying stock.0066_stockitem_scheduled_for_deletion... OK
  Applying part.0067_partinternalpricebreak... OK
  Applying part.0068_part_unique_part... OK
  Applying part.0069_auto_20210701_0509... OK
  Applying part.0070_alter_part_variant_of... OK
  Applying part.0071_alter_partparametertemplate_name... OK
  Applying part.0072_bomitemsubstitute... OK
  Applying part.0073_auto_20211013_1048... OK
  Applying part.0074_partcategorystar... OK
  Applying stock.0067_alter_stockitem_part... OK
  Applying stock.0068_stockitem_serial_int... OK
  Applying stock.0069_auto_20211109_2347... OK
  Applying stock.0070_auto_20211128_0151... OK
  Applying stock.0071_auto_20211205_1733... OK
  Applying stock.0072_remove_stockitem_scheduled_for_deletion... OK
  Applying stock.0073_alter_stockitem_belongs_to... OK
  Applying stock.0074_alter_stockitem_batch... OK
  Applying stock.0075_auto_20220515_1440... OK
  Applying stock.0076_alter_stockitem_status... OK
  Applying stock.0077_alter_stockitem_notes... OK
  Applying stock.0078_alter_stockitem_supplier_part... OK
  Applying stock.0079_alter_stocklocation_name... OK
  Applying stock.0080_stocklocation_pathstring... OK
  Applying stock.0081_auto_20220801_0044... OK
  Applying stock.0082_alter_stockitem_link... OK
  Applying stock.0083_stocklocation_icon... OK
  Applying stock.0084_auto_20220903_0154... OK
  Applying stock.0085_auto_20220903_0225... OK
  Applying stock.0086_remove_stockitem_uid... OK
  Applying stock.0087_auto_20220912_2341... OK
  Applying stock.0088_remove_stockitem_infinite... OK
  Applying stock.0089_alter_stockitem_purchase_price... OK
  Applying stock.0090_stocklocation_structural... OK
  Applying stock.0091_alter_stockitem_delete_on_deplete... OK
  Applying stock.0092_alter_stockitem_updated... OK
  Applying stock.0093_auto_20230217_2140... OK
  Applying stock.0094_auto_20230220_0025... OK
  Applying stock.0095_stocklocation_external... OK
  Applying users.0006_alter_ruleset_name... OK
  Applying part.0075_auto_20211128_0151... OK
  Applying part.0076_auto_20220516_0819... OK
  Applying part.0077_alter_bomitem_unique_together... OK
  Applying part.0078_auto_20220606_0024... OK
  Applying part.0079_alter_part_notes... OK
  Applying order.0031_auto_20200426_0612... OK
  Applying order.0032_auto_20200427_0044... OK
  Applying order.0033_auto_20200512_1033... OK
  Applying order.0034_auto_20200512_1054... OK
  Applying order.0035_auto_20200513_0016... OK
  Applying order.0036_auto_20200831_0912... OK
  Applying order.0037_auto_20201110_0911... OK
  Applying order.0038_auto_20201112_1737... OK
  Applying order.0039_auto_20201112_2203... OK
  Applying order.0040_salesorder_target_date... OK
  Applying order.0041_auto_20210114_1728... OK
  Applying order.0042_auto_20210310_1619... OK
  Applying order.0043_auto_20210330_0013... OK
  Applying order.0044_auto_20210404_2016... OK
  Applying order.0045_auto_20210504_1946... OK
  Applying order.0046_purchaseorderlineitem_destination... OK
  Applying order.0047_auto_20210701_0509... OK
  Applying order.0048_auto_20210702_2321... OK
  Applying order.0049_alter_purchaseorderlineitem_unique_together... OK
  Applying order.0050_alter_purchaseorderlineitem_destination... OK
  Applying order.0051_auto_20211014_0623... OK
  Applying order.0052_auto_20211014_0631... OK
  Applying order.0053_auto_20211128_0151... OK
  Applying order.0053_salesordershipment... OK
  Applying order.0054_salesorderallocation_shipment... OK
  Applying order.0055_auto_20211025_0645... OK
  Applying order.0056_alter_salesorderallocation_shipment... OK
  Applying order.0057_salesorderlineitem_shipped... OK
  Applying order.0058_auto_20211126_1210... OK
  Applying order.0059_salesordershipment_tracking_number... OK
  Applying order.0060_auto_20211129_1339... OK
  Applying order.0054_auto_20211201_2139... OK
  Applying order.0061_merge_0054_auto_20211201_2139_0060_auto_20211129_1339... OK
  Applying order.0062_auto_20220228_0321... OK
  Applying order.0063_alter_purchaseorderlineitem_unique_together... OK
  Applying order.0064_purchaseorderextraline_salesorderextraline... OK
  Applying order.0065_alter_purchaseorderlineitem_part... OK
  Applying order.0066_alter_purchaseorder_supplier... OK
  Applying order.0067_auto_20220516_1120... OK
  Applying order.0068_alter_salesorderallocation_unique_together... OK
  Applying order.0069_auto_20220524_0508... OK
  Applying order.0070_auto_20220620_0728... OK
  Applying order.0071_auto_20220628_0133... OK
  Applying order.0072_alter_salesorder_reference... OK
  Applying order.0073_alter_purchaseorder_reference... OK
  Applying order.0074_auto_20220709_0108... OK
  Applying order.0075_auto_20221110_0108... OK
  Applying order.0076_auto_20221111_0153... OK
  Applying order.0077_auto_20230129_0154... OK
  Applying order.0078_auto_20230304_0721... OK
  Applying order.0079_auto_20230304_0904... OK
  Applying order.0080_auto_20230317_0816... OK
  Applying order.0081_auto_20230314_0725... OK
  Applying order.0082_auto_20230314_1259... OK
  Applying order.0083_returnorderextraline... OK
  Applying order.0084_auto_20230321_1111... OK
  Applying order.0085_auto_20230322_1056... OK
  Applying order.0086_auto_20230323_1108... OK
  Applying order.0087_alter_salesorder_status... OK
  Applying order.0088_auto_20230403_1402... OK
  Applying order.0089_auto_20230404_0030... OK
  Applying order.0090_auto_20230412_1752... OK
  Applying otp_static.0001_initial... OK
  Applying otp_static.0002_throttling... OK
  Applying otp_totp.0001_initial... OK
  Applying otp_totp.0002_auto_20190420_0723... OK
  Applying part.0080_alter_part_image... OK
  Applying part.0081_alter_partcategory_name... OK
  Applying part.0082_partcategory_pathstring... OK
  Applying part.0083_auto_20220731_2357... OK
  Applying part.0084_partcategory_icon... OK
  Applying part.0085_partparametertemplate_description... OK
  Applying part.0086_auto_20220912_0007... OK
  Applying part.0087_bomitem_consumable... OK
  Applying part.0088_alter_partparametertemplate_name... OK
  Applying part.0089_auto_20221112_0128... OK
  Applying part.0090_auto_20221115_0816... OK
  Applying part.0091_partstocktake... OK
  Applying part.0092_part_last_stocktake... OK
  Applying part.0093_auto_20230115_1404... OK
  Applying part.0094_alter_part_units... OK
  Applying part.0095_alter_part_responsible... OK
  Applying part.0096_auto_20230211_0029... OK
  Applying part.0097_partstocktakereport... OK
  Applying part.0098_auto_20230214_1115... OK
  Applying part.0099_alter_bomitem_inherited... OK
  Applying part.0100_alter_bomitem_reference... OK
  Applying part.0101_bomitem_validated... OK
  Applying part.0102_auto_20230314_0112... OK
  Applying part.0103_auto_20230317_0816... OK
  Applying part.0104_alter_part_description... OK
  Applying plugin.0001_initial... OK
  Applying plugin.0002_alter_pluginconfig_options... OK
  Applying plugin.0003_pluginsetting... OK
  Applying plugin.0004_alter_pluginsetting_key... OK
  Applying plugin.0005_notificationusersetting... OK
  Applying report.0001_initial... OK
  Applying report.0002_delete_reporttemplate... OK
  Applying report.0003_testreport_enabled... OK
  Applying report.0004_auto_20200823_1104... OK
  Applying report.0005_auto_20210119_0815... OK
  Applying report.0006_reportsnippet... OK
  Applying report.0007_auto_20210204_1617... OK
  Applying report.0008_auto_20210204_2100... OK
  Applying report.0009_testreport_revision... OK
  Applying report.0010_auto_20210205_1201... OK
  Applying report.0011_auto_20210212_2024... OK
  Applying report.0012_buildreport... OK
  Applying report.0013_testreport_include_installed... OK
  Applying report.0014_purchaseorderreport_salesorderreport... OK
  Applying report.0015_auto_20210403_1837... OK
  Applying report.0016_auto_20210513_1303... OK
  Applying report.0017_auto_20230317_0816... OK
  Applying report.0018_returnorderreport... OK
  Applying report.0019_returnorderreport_metadata... OK
  Applying sites.0001_initial... OK
  Applying sites.0002_alter_domain_unique... OK
  Applying socialaccount.0001_initial... OK
  Applying socialaccount.0002_token_max_lengths... OK
  Applying socialaccount.0003_extra_data_default_dict... OK
  Applying stock.0096_auto_20230330_1121... OK
  Applying user_sessions.0001_initial... OK
  Applying user_sessions.0002_auto_20151208_1536... OK
  Applying user_sessions.0003_auto_20161205_1516... OK
  Applying users.0007_alter_ruleset_name... OK
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
[PLUGIN] Encountered an error with /root/.local/lib/python3.9/site-packages/django/apps/registry.py:
App registry isn't ready yet.
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
Operations to perform:
  Synchronize unmigrated apps: allauth, allauth_2fa, corsheaders, crispy_forms, dbbackup, django_cleanup, django_filters, django_ical, django_otp, djmoney, formtools, import_export, maintenance_mode, markdownify, messages, mptt, rest_framework, staticfiles
  Apply all migrations: InvenTree, account, admin, auth, authtoken, build, common, company, contenttypes, django_q, error_report, exchange, label, order, otp_static, otp_totp, part, plugin, report, sites, socialaccount, stock, user_sessions, users
Synchronizing apps without migrations:
  Creating tables...
    Running deferred SQL...
Running migrations:
  No migrations to apply.
System check identified no issues (1 silenced).
========================================
InvenTree database migrations completed!
render modals.js
render filters.js
render helpers.js
render purchase_order.js
render table_filters.js
render attachment.js
render order.js
render part.js
render pricing.js
render search.js
render status_codes.js
render build.js
render bom.js
render report.js
render company.js
render forms.js
render tables.js
render model_renderers.js
render stock.js
render return_order.js
render news.js
render barcode.js
render api.js
render label.js
render charts.js
render sales_order.js
render plugin.js
render notification.js
rendered all files in /home/inventree/InvenTree/templates/js/translated
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git

784 static files copied to '/home/inventree/data/static', 2251 unmodified.
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
11:01:17 [Q] INFO Enqueued 1
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
File “/home/inventree/InvenTree/locale/zh/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/it/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/sv/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/ru/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/nl/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/es/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/el/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/en/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/th/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/vi/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/ko/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/fa/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/pt_br/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/cs/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/zh_Hans/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/he/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/id/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/no/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/da/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/tr/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/pl/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/de/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/es_MX/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/pt/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/fr/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/ja/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/hu/LC_MESSAGES/django.po” is already compiled and up to date.
File “/home/inventree/InvenTree/locale/sl/LC_MESSAGES/django.po” is already compiled and up to date.
InvenTree translation coverage: 24%
user@server:/home/inventree# docker compose up -d
[+] Running 4/4
 ⠿ Container inventree-db      Running                                                                                                                                                                        0.0s
 ⠿ Container inventree-server  Started                                                                                                                                                                        0.9s
 ⠿ Container inventree-proxy   Started                                                                                                                                                                        2.4s
 ⠿ Container inventree-worker  Started                                                                                                                                                                        2.3s
user@server:/home/inventree#
SchrodingersGat commented 1 year ago

From those logs it looks like the install / update process has worked as expected. But the server logs are still showing errors?

BinaryAlps commented 1 year ago

Yeah exactly. This are the inventree-db container logs:

2023-05-22 10:58:35.029 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.029 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.031 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.031 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.033 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.033 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.036 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.036 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.037 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.037 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.039 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.039 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.040 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.040 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.041 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.041 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.044 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.044 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.046 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.046 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.048 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.048 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.053 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.053 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.057 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.057 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:35.546 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:35.546 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:36.131 UTC [72] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:36.131 UTC [72] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:39.306 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:39.306 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.524 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.524 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.558 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.558 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.569 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.569 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.575 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.575 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.587 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.587 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.601 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.601 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.617 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.617 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.621 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.621 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.625 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.625 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.629 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.629 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.633 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.633 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.638 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.638 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.642 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.642 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.645 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.645 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.648 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.648 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.651 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.651 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.654 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.654 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.657 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.657 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.660 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.660 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.663 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.663 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.667 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.667 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.671 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.671 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.684 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.684 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:40.688 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:40.688 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_DEFAULT_CURRENCY') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:41.198 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:41.198 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:41.737 UTC [74] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:41.737 UTC [74] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:46.177 UTC [75] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:46.177 UTC [75] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:46.181 UTC [75] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:46.181 UTC [75] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('PLUGIN_ON_STARTUP') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:46.204 UTC [75] ERROR:  relation "plugin_pluginconfig" does not exist at character 131
2023-05-22 10:58:46.204 UTC [75] STATEMENT:  SELECT "plugin_pluginconfig"."id", "plugin_pluginconfig"."key", "plugin_pluginconfig"."name", "plugin_pluginconfig"."active" FROM "plugin_pluginconfig" WHERE ("plugin_pluginconfig"."key" = 'inventreebarcode' AND "plugin_pluginconfig"."name" = 'InvenTreeBarcode') LIMIT 21
2023-05-22 10:58:46.683 UTC [75] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:46.683 UTC [75] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:53.207 UTC [76] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:53.207 UTC [76] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('SERVER_RESTART_REQUIRED') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:53.213 UTC [76] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:53.213 UTC [76] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('PLUGIN_ON_STARTUP') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1
2023-05-22 10:58:53.251 UTC [76] ERROR:  relation "plugin_pluginconfig" does not exist at character 131
2023-05-22 10:58:53.251 UTC [76] STATEMENT:  SELECT "plugin_pluginconfig"."id", "plugin_pluginconfig"."key", "plugin_pluginconfig"."name", "plugin_pluginconfig"."active" FROM "plugin_pluginconfig" WHERE ("plugin_pluginconfig"."key" = 'inventreebarcode' AND "plugin_pluginconfig"."name" = 'InvenTreeBarcode') LIMIT 21
2023-05-22 10:58:53.835 UTC [76] ERROR:  relation "common_inventreesetting" does not exist at character 112
2023-05-22 10:58:53.835 UTC [76] STATEMENT:  SELECT "common_inventreesetting"."id", "common_inventreesetting"."value", "common_inventreesetting"."key" FROM "common_inventreesetting" WHERE UPPER("common_inventreesetting"."key"::text) = UPPER('INVENTREE_BASE_URL') ORDER BY "common_inventreesetting"."id" ASC LIMIT 1

inventree-server logs:

Loading config file : /home/inventree/data/config.yaml
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
11:04:07 [Q] INFO Enqueued 3
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
11:04:07 [Q] INFO Enqueued 4
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
11:04:08 [Q] INFO Enqueued 5
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
11:04:08 [Q] INFO Enqueued 6
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git
fatal: not a git repository (or any of the parent directories): .git

inventree-proxy logs:

/docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
/docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
/docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
10-listen-on-ipv6-by-default.sh: info: can not modify /etc/nginx/conf.d/default.conf (read-only file system?)
/docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
/docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
/docker-entrypoint.sh: Configuration complete; ready for start up
2023/05/22 11:03:48 [notice] 1#1: using the "epoll" event method
2023/05/22 11:03:48 [notice] 1#1: nginx/1.24.0
2023/05/22 11:03:48 [notice] 1#1: built by gcc 10.2.1 20210110 (Debian 10.2.1-6) 
2023/05/22 11:03:48 [notice] 1#1: OS: Linux 5.4.0-107-generic
2023/05/22 11:03:48 [notice] 1#1: getrlimit(RLIMIT_NOFILE): 1048576:1048576
2023/05/22 11:03:48 [notice] 1#1: start worker processes
2023/05/22 11:03:48 [notice] 1#1: start worker process 21
2023/05/22 11:03:48 [notice] 1#1: start worker process 22
2023/05/22 11:03:57 [error] 21#21: *1 connect() failed (111: Connection refused) while connecting to upstream, client: myip, server: , request: "GET / HTTP/1.1", upstream: "http://172.21.0.3:3737/", host: "serverip:1337"
myip - - [22/May/2023:11:03:57 +0000] "GET / HTTP/1.1" 502 559 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36" "-"
2023/05/22 11:03:57 [error] 21#21: *1 connect() failed (111: Connection refused) while connecting to upstream, client: myip, server: , request: "GET /favicon.ico HTTP/1.1", upstream: "http://172.21.0.3:3737/favicon.ico", host: "serverip:1337", referrer: "http://serverip:1337/"
myip - - [22/May/2023:11:03:57 +0000] "GET /favicon.ico HTTP/1.1" 502 559 "http://serverip:1337/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36" "-"
94.102.61.38 - - [22/May/2023:11:40:39 +0000] "GET / HTTP/1.1" 502 559 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36" "-"
2023/05/22 11:40:39 [error] 22#22: *4 connect() failed (111: Connection refused) while connecting to upstream, client: 94.102.61.38, server: , request: "GET / HTTP/1.1", upstream: "http://172.21.0.3:3737/", host: "serverip:1337"

inventree-worker logs:

11:16:40 [Q] INFO Enqueued 25
11:16:40 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:16:40 [Q] INFO Process-1:2 processing [missouri-solar-oxygen-mexico]
11:16:40 [Q] INFO Processed [missouri-solar-oxygen-mexico]
11:21:42 [Q] INFO Enqueued 26
11:21:42 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:21:42 [Q] INFO Process-1:4 processing [fruit-alpha-papa-floor]
11:21:42 [Q] INFO Processed [fruit-alpha-papa-floor]
11:26:43 [Q] INFO Enqueued 27
11:26:43 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:26:43 [Q] INFO Process-1:3 processing [xray-oxygen-illinois-salami]
11:26:44 [Q] INFO Processed [xray-oxygen-illinois-salami]
11:31:45 [Q] INFO Enqueued 28
11:31:45 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:31:45 [Q] INFO Process-1:1 processing [jersey-three-yellow-vegan]
11:31:45 [Q] INFO Processed [jersey-three-yellow-vegan]
11:36:46 [Q] INFO Enqueued 29
11:36:46 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:36:47 [Q] INFO Process-1:2 processing [uncle-paris-sixteen-equal]
11:36:47 [Q] INFO Processed [uncle-paris-sixteen-equal]
11:41:18 [Q] INFO Enqueued 30
11:41:18 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:41:18 [Q] INFO Process-1:4 processing [winter-victor-pip-magazine]
11:41:18 [Q] INFO Processed [winter-victor-pip-magazine]
11:46:20 [Q] INFO Enqueued 31
11:46:20 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:46:20 [Q] INFO Process-1:3 processing [robert-six-sodium-mexico]
11:46:20 [Q] INFO Processed [robert-six-sodium-mexico]
11:51:21 [Q] INFO Enqueued 32
11:51:21 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:51:21 [Q] INFO Process-1:1 processing [pip-undress-fanta-table]
11:51:22 [Q] INFO Processed [pip-undress-fanta-table]
11:56:23 [Q] INFO Enqueued 33
11:56:23 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
11:56:23 [Q] INFO Process-1:2 processing [tennessee-butter-football-black]
11:56:23 [Q] INFO Processed [tennessee-butter-football-black]
12:01:24 [Q] INFO Enqueued 34
12:01:24 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:01:25 [Q] INFO Process-1:4 processing [spaghetti-happy-island-tennis]
12:01:25 [Q] INFO Processed [spaghetti-happy-island-tennis]
12:06:26 [Q] INFO Enqueued 35
12:06:26 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:06:26 [Q] INFO Process-1:3 processing [fruit-july-glucose-coffee]
12:06:26 [Q] INFO Processed [fruit-july-glucose-coffee]
12:11:28 [Q] INFO Enqueued 36
12:11:28 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:11:28 [Q] INFO Process-1:1 processing [item-oxygen-saturn-papa]
12:11:28 [Q] INFO Processed [item-oxygen-saturn-papa]
12:16:29 [Q] INFO Enqueued 37
12:16:29 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:16:29 [Q] INFO Process-1:2 processing [green-pennsylvania-magazine-cola]
12:16:29 [Q] INFO Processed [green-pennsylvania-magazine-cola]
12:21:31 [Q] INFO Enqueued 38
12:21:31 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:21:31 [Q] INFO Process-1:4 processing [louisiana-artist-bulldog-video]
12:21:31 [Q] INFO Processed [louisiana-artist-bulldog-video]
12:26:32 [Q] INFO Enqueued 39
12:26:32 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:26:33 [Q] INFO Process-1:3 processing [white-sierra-seven-oven]
12:26:33 [Q] INFO Processed [white-sierra-seven-oven]
12:31:34 [Q] INFO Enqueued 40
12:31:34 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:31:34 [Q] INFO Process-1:1 processing [pizza-four-moon-massachusetts]
12:31:34 [Q] INFO Processed [pizza-four-moon-massachusetts]
12:36:36 [Q] INFO Enqueued 41
12:36:36 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:36:36 [Q] INFO Process-1:2 processing [sweet-india-green-neptune]
12:36:36 [Q] INFO Processed [sweet-india-green-neptune]
12:41:37 [Q] INFO Enqueued 42
12:41:37 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:41:38 [Q] INFO Process-1:4 processing [grey-carbon-item-angel]
12:41:38 [Q] INFO Processed [grey-carbon-item-angel]
12:46:39 [Q] INFO Enqueued 43
12:46:39 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:46:39 [Q] INFO Process-1:3 processing [burger-artist-virginia-robert]
12:46:39 [Q] INFO Processed [burger-artist-virginia-robert]
12:51:41 [Q] INFO Enqueued 44
12:51:41 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:51:41 [Q] INFO Process-1:1 processing [thirteen-blue-nineteen-golf]
12:51:41 [Q] INFO Processed [thirteen-blue-nineteen-golf]
12:56:42 [Q] INFO Enqueued 45
12:56:42 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
12:56:43 [Q] INFO Process-1:2 processing [delaware-beer-rugby-violet]
12:56:43 [Q] INFO Processed [delaware-beer-rugby-violet]
13:01:44 [Q] INFO Enqueued 46
13:01:44 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
13:01:44 [Q] INFO Process-1:4 processing [alabama-wolfram-cat-kentucky]
13:01:44 [Q] INFO Processed [alabama-wolfram-cat-kentucky]
13:06:46 [Q] INFO Enqueued 47
13:06:46 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
13:06:46 [Q] INFO Process-1:3 processing [april-lamp-table-missouri]
13:06:46 [Q] INFO Processed [april-lamp-table-missouri]
13:11:47 [Q] INFO Enqueued 48
13:11:47 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
13:11:47 [Q] INFO Process-1:1 processing [uranus-maine-nineteen-glucose]
13:11:48 [Q] INFO Processed [uranus-maine-nineteen-glucose]
13:16:19 [Q] INFO Enqueued 49
13:16:19 [Q] INFO Process-1 created a task from schedule [InvenTree.tasks.heartbeat]
13:16:19 [Q] INFO Process-1:2 processing [idaho-leopard-montana-july]
13:16:19 [Q] INFO Processed [idaho-leopard-montana-july]
SchrodingersGat commented 1 year ago

Did you use the provided nginx.conf file or modify it, or create your own?

BinaryAlps commented 1 year ago

Yeah it's the one from github, I just changed the port:

server {

    # Listen for connection on (internal) port 80
    listen 80;

    real_ip_header proxy_protocol;

    location / {

        proxy_set_header      Host              $http_host;
        proxy_set_header      X-Forwarded-By    $server_addr:$server_port;
        proxy_set_header      X-Forwarded-For   $remote_addr;
        proxy_set_header      X-Forwarded-Proto $scheme;
        proxy_set_header      X-Real-IP         $remote_addr;
        proxy_set_header      CLIENT_IP         $remote_addr;

        proxy_pass_request_headers on;

        proxy_redirect off;

        client_max_body_size 100M;

        proxy_buffering off;
        proxy_request_buffering off;

        # Change 'inventree-server' to the name of the inventree server container,
        # and '8000' to the INVENTREE_WEB_PORT (if not default)
        proxy_pass http://inventree-server:3737;
    }

    # Redirect any requests for static files
    location /static/ {
        alias /var/www/static/;
        autoindex on;

        # Caching settings
        expires 30d;
        add_header Pragma public;
        add_header Cache-Control "public";
    }

    # Redirect any requests for media files
    location /media/ {
        alias /var/www/media/;

        # Media files require user authentication
        auth_request /auth;

        # Content header to force download
        add_header Content-disposition "attachment";
    }

    # Use the 'user' API endpoint for auth
    location /auth {
        internal;

        proxy_pass http://inventree-server:3737/auth/;

        proxy_pass_request_body off;
        proxy_set_header Content-Length "";
        proxy_set_header X-Original-URI $request_uri;
    }

}
wolflu05 commented 1 year ago

Your web Port defined in your env file is 1337. but your reverse proxy redirects to 3737. this cannot work. And for accessing with your Webbrowser you need the Port that the Webserver container exposes (as port 80 internally for the Webserver container).

BinaryAlps commented 1 year ago

My inventree-server is running on port 3737 and my inventree-proxy is on port 1337. That's also why I adopted it in the nginx.prod.conf file to proxy_pass http://inventree-server:3737; - Shouldn't that be alright then?

wolflu05 commented 1 year ago

Can you please share your new docker config, this looks different on your initial post. If it's correct like this depends on how you set up the port exposing for your Webserver. (But first part with 3737 should be ok) - but why do you not try first how it's documented (because that setups definitely works) and if you want to change it, change it after you already have something working and also have a bit of docker knowledge?

BinaryAlps commented 1 year ago

That's my docker-compose.yml file: 

version: "3.8"

# Docker compose recipe for a production-ready InvenTree setup, with the following containers:
# - PostgreSQL as the database backend
# - gunicorn as the InvenTree web server
# - django-q as the InvenTree background worker process
# - nginx as a reverse proxy
# - redis as the cache manager (optional, disabled by default)

# ---------------------
# READ BEFORE STARTING!
# ---------------------

# -----------------------------
# Setting environment variables
# -----------------------------
# Shared environment variables should be stored in the .env file
# Changes made to this file are reflected across all containers!
#
# IMPORTANT NOTE:
# You should not have to change *anything* within this docker-compose.yml file!
# Instead, make any changes in the .env file!

# ------------------------
# InvenTree Image Versions
# ------------------------
# By default, this docker-compose script targets the STABLE version of InvenTree,
# image: inventree/inventree:stable
#
# To run the LATEST (development) version of InvenTree,
# change the INVENTREE_TAG variable (in the .env file) to "latest"
#
# Alternatively, you could target a specific tagged release version with (for example):
# INVENTREE_TAG=0.7.5
#

services:
    # Database service
    # Use PostgreSQL as the database backend
    inventree-db:
        container_name: inventree-db
        image: postgres:13
        expose:
            - ${INVENTREE_DB_PORT:-5433}/tcp
        environment:
            - PGDATA=/var/lib/postgresql/data/pgdb
            - POSTGRES_USER=${INVENTREE_DB_USER:?You must provide the 'INVENTREE_DB_USER' variable in the .env file}
            - POSTGRES_PASSWORD=${INVENTREE_DB_PASSWORD:?You must provide the 'INVENTREE_DB_PASSWORD' variable in the .env file}
            - POSTGRES_DB=${INVENTREE_DB_NAME:?You must provide the 'INVENTREE_DB_NAME' variable in the .env file}
        volumes:
            # Map 'data' volume such that postgres database is stored externally
            - inventree_data:/var/lib/postgresql/data/
        restart: unless-stopped
        command: -p ${INVENTREE_DB_PORT:-5433}
        ports:
            - "${INVENTREE_DB_PORT:-5433}:${INVENTREE_DB_PORT:-5433}"

    # redis acts as database cache manager
    # only runs under the "redis" profile : https://docs.docker.com/compose/profiles/
    inventree-cache:
        container_name: inventree-cache
        image: redis:7.0
        depends_on:
            - inventree-db
        profiles:
            - redis
        env_file:
            - .env
        expose:
            - ${INVENTREE_CACHE_PORT:-6379}
        restart: always

    # InvenTree web server service
    # Uses gunicorn as the web server
    inventree-server:
        container_name: inventree-server
        # If you wish to specify a particular InvenTree version, do so here
        image: inventree/inventree:${INVENTREE_TAG:-stable}
        expose:
            - 3737
        depends_on:
            - inventree-db
        env_file:
            - .env
        volumes:
            # Data volume must map to /home/inventree/data
            - inventree_data:/home/inventree/data
        restart: unless-stopped

    # Background worker process handles long-running or periodic tasks
    inventree-worker:
        container_name: inventree-worker
        # If you wish to specify a particular InvenTree version, do so here
        image: inventree/inventree:${INVENTREE_TAG:-stable}
        command: invoke worker
        depends_on:
            - inventree-server
        env_file:
            - .env
        volumes:
            # Data volume must map to /home/inventree/data
            - inventree_data:/home/inventree/data
        restart: unless-stopped

    # nginx acts as a reverse proxy
    # static files are served directly by nginx
    # media files are served by nginx, although authentication is redirected to inventree-server
    # web requests are redirected to gunicorn
    # NOTE: You will need to provide a working nginx.conf file!
    inventree-proxy:
        container_name: inventree-proxy
        image: nginx:stable
        depends_on:
            - inventree-server
        env_file:
            - .env
        ports:
            # Default web port is 1337 (can be changed in the .env file)
            - ${INVENTREE_WEB_PORT:-1337}:80
        volumes:
            # Provide nginx configuration file to the container
            # Refer to the provided example file as a starting point
            - ./nginx.prod.conf:/etc/nginx/conf.d/default.conf:ro
            # nginx proxy needs access to static and media files
            - inventree_data:/var/www
        restart: unless-stopped

volumes:
    # Persistent data, stored external to the container(s)
    inventree_data:
        driver: local
        driver_opts:
            type: none
            o: bind
            # This directory specified where InvenTree data are stored "outside" the docker containers
            device: ${INVENTREE_EXT_VOLUME}

I will give it a new try and set it up completely from scratch later that evening with all the files as it is from the docs but anyhow from my point of view the error I see in the inventree-db logs cannot come from the port changes that I made

SchrodingersGat commented 1 year ago

image

Leave this port fixed at 8000 - this is an internal port only for container-container connections.

The proxy container is the only one you want exposed to outside connections. You can set that port to whatever you like. But internally it must use port 8000 to connect to the inventree-server container.

BinaryAlps commented 1 year ago

Thanks! Changing the port ack to 8000 and also adopting it in my nginx.conf back to 8000 worked!

BR from Austria, Fabian

matmair commented 1 year ago

(Sarcasm) Always those Austrians;

Would a comment in the docker-compose have helped avoid this issue? Greetings from Innsbruck

BinaryAlps commented 1 year ago

Would a comment in the docker-compose have helped avoid this issue?

Absolutely! Specially the comment in the nginx.prod.conf is confusing here:

(if not default)

But as I learned it needs to be default 8000 in order to work.

Greetings from Carinthia, Fabian

matmair commented 1 year ago

I have changed the inline docs around this to make it clearer that this should not be changed - ref https://github.com/inventree/InvenTree/pull/4880. Cheers to the wet east

SchrodingersGat commented 1 year ago

@Hack4Life glad to hear that worked.

If you are finding this project useful, please consider sponsoring so we can continue to support users to debug cases like this! It can be quite time consuming :)