Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Postgres problem with the new 0.3.8 #3747

Closed
4 tasks done
madpin opened this issue Jul 9, 2024 · 3 comments
Closed
4 tasks done

Postgres problem with the new 0.3.8 #3747

madpin opened this issue Jul 9, 2024 · 3 comments

Comments

@madpin
Copy link

madpin commented Jul 9, 2024 •
edited
Loading

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!
@madpin
Copy link
Author

madpin commented 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        |

@tjbck
Copy link
Contributor

tjbck commented Jul 10, 2024 •
edited
Loading

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!

@madpin
Copy link
Author

madpin commented 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 madpin closed this as completed Jul 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@madpin @tjbck