github-starred/open-webui
2
0
Fork 0
mirror of https://github.com/open-webui/open-webui.git synced 2026-07-27 17:04:57 -05:00
Code Issues 2.4k Packages Projects Releases 129 Wiki Activity

Postgres problem with the new 0.3.8 #1476

New Issue
Closed
opened 2025-11-11 14:45:58 -06:00 by GiteaMirror · 3 comments
GiteaMirror commented 2025-11-11 14:45:58 -06:00
Owner
Copy Link
Copy Source

Originally created by @madpin on GitHub (Jul 9, 2024).

Bug Report

Description

Bug Summary:
The new version: 0.3.8 the website shows the error: "Internal Server Error"
And absolutely no logs in the terminal.
I'm using the docker-compose:

In my case:

  owui:
    image: ghcr.io/open-webui/open-webui:0.3.7
    container_name: owui
    user: 1002:1002
    networks:
      - caddy
      - infra
      - llm_infra
    environment:
      - PORT=8081
      - GLOBAL_LOG_LEVEL=DEBUG
    env_file:
      - owui.env
    volumes:
      - ${HOME}/configs/open-webui:/app/backend/data
    labels:
      caddy: owui.xxxxx.com
      caddy.reverse_proxy: "{{upstreams 8081}}"
    restart: unless-stopped

Steps to Reproduce:
With the postgres in another docker, I wasn't able to make it work.
If I turn off postgres, it was working fine with the sqlite.

Expected Behavior:
No errors :)

Actual Behavior:
[Describe what actually happened.]

Environment

  • Open WebUI Version: 0.3.8

  • Ollama (if applicable): NA

  • Operating System: Ubuntu, but actually Docker

  • Browser (if applicable): NA

Reproduction Details

Confirmation:

  • I have read and followed all the instructions provided in the README.md.
  • I am on the latest version of both Open WebUI and Ollama.
  • I have included the browser console logs.
  • I have included the Docker container logs.

Logs and Screenshots

Browser Console Logs:
[Include relevant browser console logs, if applicable]

Docker Container Logs:
[Include relevant Docker container logs, if applicable]

Screenshots (if applicable):
[Attach any relevant screenshots to help illustrate the issue]

Installation Method

[Describe the method you used to install the project, e.g., manual installation, Docker, package manager, etc.]

Additional Information

[Include any additional details that may help in understanding and reproducing the issue. This could include specific configurations, error messages, or anything else relevant to the bug.]

Note

If the bug report is incomplete or does not follow the provided instructions, it may not be addressed. Please ensure that you have followed the steps outlined in the README.md and troubleshooting.md documents, and provide all necessary information for us to reproduce and address the issue. Thank you!

Originally created by @madpin on GitHub (Jul 9, 2024). # Bug Report ## Description **Bug Summary:** The new version: 0.3.8 the website shows the error: "Internal Server Error" And absolutely no logs in the terminal. I'm using the docker-compose: In my case: ``` owui: image: ghcr.io/open-webui/open-webui:0.3.7 container_name: owui user: 1002:1002 networks: - caddy - infra - llm_infra environment: - PORT=8081 - GLOBAL_LOG_LEVEL=DEBUG env_file: - owui.env volumes: - ${HOME}/configs/open-webui:/app/backend/data labels: caddy: owui.xxxxx.com caddy.reverse_proxy: "{{upstreams 8081}}" restart: unless-stopped ``` **Steps to Reproduce:** With the postgres in another docker, I wasn't able to make it work. If I turn off postgres, it was working fine with the sqlite. **Expected Behavior:** No errors :) **Actual Behavior:** [Describe what actually happened.] ## Environment - **Open WebUI Version:** 0.3.8 - **Ollama (if applicable):** NA - **Operating System:** Ubuntu, but actually Docker - **Browser (if applicable):** NA ## Reproduction Details **Confirmation:** - [x] I have read and followed all the instructions provided in the README.md. - [x] I am on the latest version of both Open WebUI and Ollama. - [x] I have included the browser console logs. - [x] I have included the Docker container logs. ## Logs and Screenshots **Browser Console Logs:** [Include relevant browser console logs, if applicable] **Docker Container Logs:** [Include relevant Docker container logs, if applicable] **Screenshots (if applicable):** [Attach any relevant screenshots to help illustrate the issue] ## Installation Method [Describe the method you used to install the project, e.g., manual installation, Docker, package manager, etc.] ## Additional Information [Include any additional details that may help in understanding and reproducing the issue. This could include specific configurations, error messages, or anything else relevant to the bug.] ## Note If the bug report is incomplete or does not follow the provided instructions, it may not be addressed. Please ensure that you have followed the steps outlined in the README.md and troubleshooting.md documents, and provide all necessary information for us to reproduce and address the issue. Thank you!
GiteaMirror commented 2025-11-11 14:45:59 -06:00
Author
Owner
Copy Link
Copy Source

@madpin commented on GitHub (Jul 10, 2024):

The startup log:

owui3        | /app
owui3        | INFO:config:GLOBAL_LOG_LEVEL: DEBUG
owui3        | INFO:config:AUDIO_LOG_LEVEL: DEBUG
owui3        | INFO:config:COMFYUI_LOG_LEVEL: DEBUG
owui3        | INFO:config:CONFIG_LOG_LEVEL: DEBUG
owui3        | INFO:config:DB_LOG_LEVEL: DEBUG
owui3        | INFO:config:IMAGES_LOG_LEVEL: DEBUG
owui3        | INFO:config:MAIN_LOG_LEVEL: DEBUG
owui3        | INFO:config:MODELS_LOG_LEVEL: DEBUG
owui3        | INFO:config:OLLAMA_LOG_LEVEL: DEBUG
owui3        | INFO:config:OPENAI_LOG_LEVEL: DEBUG
owui3        | INFO:config:RAG_LOG_LEVEL: DEBUG
owui3        | INFO:config:WEBHOOK_LOG_LEVEL: DEBUG
owui3        | ERROR:root:An error occurred: [Errno 13] Permission denied: '/app/backend/static/favicon.png'
owui3        | ERROR:root:An error occurred: [Errno 13] Permission denied: '/app/backend/static/splash.png'
owui3        | INFO:config:Embedding model set: embeddings
owui3        | DEBUG:chromadb.config:Starting component System
owui3        | DEBUG:chromadb.config:Starting component Posthog
owui3        | DEBUG:chromadb.config:Starting component OpenTelemetryClient
owui3        | DEBUG:chromadb.config:Starting component FastAPI
owui3        | DEBUG:chromadb.config:Starting component System
owui3        | DEBUG:chromadb.config:Starting component Posthog
owui3        | DEBUG:chromadb.config:Starting component OpenTelemetryClient
owui3        | DEBUG:chromadb.config:Starting component FastAPI
owui3        | DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): chroma:8000
owui3        | DEBUG:urllib3.connectionpool:http://chroma:8000 "GET /api/v1/tenants/default_tenant HTTP/11" 200 25
owui3        | DEBUG:urllib3.connectionpool:http://chroma:8000 "GET /api/v1/databases/default_database?tenant=default_tenant HTTP/11" 200 97
owui3        | INFO:apps.webui.internal.wrappers:Connected to PostgreSQL database
owui3        | INFO:apps.webui.internal.db:Starting migrations
owui3        | DEBUG:peewee:('CREATE TABLE IF NOT EXISTS "migratehistory" ("id" SERIAL NOT NULL PRIMARY KEY, "name" VARCHAR(255) NOT NULL, "migrated_at" TIMESTAMP NOT NULL)', [])
owui3        | DEBUG:peewee:('SELECT "t1"."id", "t1"."name", "t1"."migrated_at" FROM "migratehistory" AS "t1" ORDER BY "t1"."id"', [])
owui3        | INFO:apps.webui.internal.db:There is nothing to migrate
owui3        | DEBUG:passlib.utils.compat:loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'>
owui3        | DEBUG:passlib.utils.compat:loaded lazy attr 'NativeStringIO': <class '_io.StringIO'>
owui3        | DEBUG:passlib.utils.compat:loaded lazy attr 'BytesIO': <class '_io.BytesIO'>
owui3        | INFO:apps.audio.main:whisper_device_type: cpu
owui3        | WARNING:langchain_community.utils.user_agent:USER_AGENT environment variable not set, consider setting it to identify your requests.
owui3        | INFO:     Started server process [1]
owui3        | INFO:     Waiting for application startup.
owui3        | 
owui3        |   ___                    __        __   _     _   _ ___ 
owui3        |  / _ \ _ __   ___ _ __   \ \      / /__| |__ | | | |_ _|
owui3        | | | | | '_ \ / _ \ '_ \   \ \ /\ / / _ \ '_ \| | | || | 
owui3        | | |_| | |_) |  __/ | | |   \ V  V /  __/ |_) | |_| || | 
owui3        |  \___/| .__/ \___|_| |_|    \_/\_/ \___|_.__/ \___/|___|
owui3        |       |_|                                               
owui3        | 
owui3        |       
owui3        | v0.3.8 - building the best open-source AI user interface.
owui3        | 
owui3        | https://github.com/open-webui/open-webui
owui3        |
@madpin commented on GitHub (Jul 10, 2024): The startup log: ``` owui3 | /app owui3 | INFO:config:GLOBAL_LOG_LEVEL: DEBUG owui3 | INFO:config:AUDIO_LOG_LEVEL: DEBUG owui3 | INFO:config:COMFYUI_LOG_LEVEL: DEBUG owui3 | INFO:config:CONFIG_LOG_LEVEL: DEBUG owui3 | INFO:config:DB_LOG_LEVEL: DEBUG owui3 | INFO:config:IMAGES_LOG_LEVEL: DEBUG owui3 | INFO:config:MAIN_LOG_LEVEL: DEBUG owui3 | INFO:config:MODELS_LOG_LEVEL: DEBUG owui3 | INFO:config:OLLAMA_LOG_LEVEL: DEBUG owui3 | INFO:config:OPENAI_LOG_LEVEL: DEBUG owui3 | INFO:config:RAG_LOG_LEVEL: DEBUG owui3 | INFO:config:WEBHOOK_LOG_LEVEL: DEBUG owui3 | ERROR:root:An error occurred: [Errno 13] Permission denied: '/app/backend/static/favicon.png' owui3 | ERROR:root:An error occurred: [Errno 13] Permission denied: '/app/backend/static/splash.png' owui3 | INFO:config:Embedding model set: embeddings owui3 | DEBUG:chromadb.config:Starting component System owui3 | DEBUG:chromadb.config:Starting component Posthog owui3 | DEBUG:chromadb.config:Starting component OpenTelemetryClient owui3 | DEBUG:chromadb.config:Starting component FastAPI owui3 | DEBUG:chromadb.config:Starting component System owui3 | DEBUG:chromadb.config:Starting component Posthog owui3 | DEBUG:chromadb.config:Starting component OpenTelemetryClient owui3 | DEBUG:chromadb.config:Starting component FastAPI owui3 | DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): chroma:8000 owui3 | DEBUG:urllib3.connectionpool:http://chroma:8000 "GET /api/v1/tenants/default_tenant HTTP/11" 200 25 owui3 | DEBUG:urllib3.connectionpool:http://chroma:8000 "GET /api/v1/databases/default_database?tenant=default_tenant HTTP/11" 200 97 owui3 | INFO:apps.webui.internal.wrappers:Connected to PostgreSQL database owui3 | INFO:apps.webui.internal.db:Starting migrations owui3 | DEBUG:peewee:('CREATE TABLE IF NOT EXISTS "migratehistory" ("id" SERIAL NOT NULL PRIMARY KEY, "name" VARCHAR(255) NOT NULL, "migrated_at" TIMESTAMP NOT NULL)', []) owui3 | DEBUG:peewee:('SELECT "t1"."id", "t1"."name", "t1"."migrated_at" FROM "migratehistory" AS "t1" ORDER BY "t1"."id"', []) owui3 | INFO:apps.webui.internal.db:There is nothing to migrate owui3 | DEBUG:passlib.utils.compat:loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'> owui3 | DEBUG:passlib.utils.compat:loaded lazy attr 'NativeStringIO': <class '_io.StringIO'> owui3 | DEBUG:passlib.utils.compat:loaded lazy attr 'BytesIO': <class '_io.BytesIO'> owui3 | INFO:apps.audio.main:whisper_device_type: cpu owui3 | WARNING:langchain_community.utils.user_agent:USER_AGENT environment variable not set, consider setting it to identify your requests. owui3 | INFO: Started server process [1] owui3 | INFO: Waiting for application startup. owui3 | owui3 | ___ __ __ _ _ _ ___ owui3 | / _ \ _ __ ___ _ __ \ \ / /__| |__ | | | |_ _| owui3 | | | | | '_ \ / _ \ '_ \ \ \ /\ / / _ \ '_ \| | | || | owui3 | | |_| | |_) | __/ | | | \ V V / __/ |_) | |_| || | owui3 | \___/| .__/ \___|_| |_| \_/\_/ \___|_.__/ \___/|___| owui3 | |_| owui3 | owui3 | owui3 | v0.3.8 - building the best open-source AI user interface. owui3 | owui3 | https://github.com/open-webui/open-webui owui3 | ```
GiteaMirror commented 2025-11-11 14:45:59 -06:00
Author
Owner
Copy Link
Copy Source

@tjbck commented on GitHub (Jul 10, 2024):

Are you using @ symbol for the password authentication by chance? That caused the issue for me with the migration, and I had to URL-encode the password. Keep us updated!

@tjbck commented on GitHub (Jul 10, 2024): Are you using `@` symbol for the password authentication by chance? That caused the issue for me with the migration, and I had to [URL-encode the password](https://docs.sqlalchemy.org/en/20/core/engines.html#escaping-special-characters-such-as-signs-in-passwords). Keep us updated!
GiteaMirror commented 2025-11-11 14:45:59 -06:00
Author
Owner
Copy Link
Copy Source

@madpin commented on GitHub (Jul 10, 2024):

Of cooourse I'm not using the "@" sign in my password....

Hahaha, the worst thing: I had this problem at my work a few months ago.

Thanks a million, @tjbck, that was exactly the problem. <3

@madpin commented on GitHub (Jul 10, 2024): Of cooourse I'm not using the "@" sign in my password.... Hahaha, the worst thing: I had this problem at my work a few months ago. Thanks a million, @tjbck, that was exactly the problem. <3
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
confirmed
confirmed issue
core
documentation
enhancement
good first issue
help wanted
non-core
pull-request
Mirrored from GitHub Pull Request
 python
question
testing wanted
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
GiteaMirror ninjasurge (Kaehlen Rog)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/open-webui#1476