Not able to run Langflow 1.7.1 with postgreSQL 14.20 in fresh docker install

[druellan]

Hi! I'm trying to run LangFlow 1.7.1 from a Docker compose instance, but when alembic is building the database structure in postgres 14.20, it stops with this error:

langflow-1  | LINE 13:  CONSTRAINT file_name_user_id_key UNIQUE NULLS DISTINCT (nam...
langflow-1  |                                                   ^
langflow-1  | [SQL:
langflow-1  | CREATE TABLE _alembic_tmp_file (
langflow-1  |   id UUID NOT NULL,
langflow-1  |   user_id UUID NOT NULL,
langflow-1  |   name VARCHAR NOT NULL,
langflow-1  |   path VARCHAR NOT NULL,
langflow-1  |   size INTEGER NOT NULL,
langflow-1  |   provider VARCHAR,
langflow-1  |   created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL,
langflow-1  |   updated_at TIMESTAMP WITHOUT TIME ZONE NOT NULL,
langflow-1  |   CONSTRAINT file_pkey PRIMARY KEY (id),
langflow-1  |   CONSTRAINT file_user_id_fkey FOREIGN KEY(user_id) REFERENCES "user" (id),
langflow-1  |   CONSTRAINT file_name_user_id_key UNIQUE NULLS DISTINCT (name, user_id)

Sounds to me that the script should not have NULLS but an user ID or something, and I'm probably messing up the .env variables.
Looking at the database, seems that it started to create the tables just fine, but stopped there, so, is similar to other issues with alembic but there is no migration involved, just a clean install.

This is my .env:

LANGFLOW_DATABASE_URL=postgresql://<user+path>
LANGFLOW_CONFIG_DIR=/app/data

LANGFLOW_SECRET_KEY=<secret_key>
LANGFLOW_AUTO_LOGIN=False
LANGFLOW_SUPERUSER=<superuser>
LANGFLOW_SUPERUSER_PASSWORD=<superuser_pass>
LANGFLOW_NEW_USER_IS_ACTIVE=False
LANGFLOW_ENABLE_SUPERUSER_CLI=False

LANGFLOW_CORS_ORIGINS=lineout.com

#LANGFLOW_LOG_LEVEL=critical

And the docker image I'm using:

services:
  langflow:
    image: langflowai/langflow:1.7.1
    pull_policy: always
    user: root
    ports:
      - "7860:7860"
    volumes:
      - langflow-data:/app/data
    env_file:
      - .env

volumes:
  langflow-data:

Thanks in advance!

[druellan]

Oh my! I just found I'm using an old Postgres version!