github-starred/open-webui
2
0
Fork 0
mirror of https://github.com/open-webui/open-webui.git synced 2026-11-13 17:58:56 -06:00
Code Issues 2.4k Packages Projects Releases 129 Wiki Activity

[GH-ISSUE #13885] issue: SSL SYSCALL EOF Error on app first startup when initializing PGVector Database (PGVector v0.8.0) #17062

New Issue
Closed
opened 2026-04-19 22:49:53 -05:00 by GiteaMirror · 0 comments
GiteaMirror commented 2026-04-19 22:49:53 -05:00
Owner
Copy Link
Copy Source

Originally created by @valentin-pringault on GitHub (May 14, 2025).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/13885

Check Existing Issues

  • I have searched the existing issues and discussions.
  • I am using the latest version of Open WebUI.

Installation Method

Git Clone

Open WebUI Version

0.6.9

Ollama Version (if applicable)

No response

Operating System

Linux (Azure WebApp)

Browser (if applicable)

No response

Confirmation

  • I have read and followed all instructions in README.md.
  • I am using the latest version of both Open WebUI and Ollama.
  • I have included the browser console logs.
  • I have included the Docker container logs.
  • I have listed steps to reproduce the bug in detail.

Expected Behavior

When using an Azure PGSQL database (PG v16.8, PGvector v0.8.0), the vector database is initiated properly when first booting the app.

Actual Behavior

The database init fails, and the app crashes. When removing the VECTOR_DB=pgvector variable (fallback to local chroma), the app starts properly.

The EOF issue also happens when calling the init queries from CLI.

Steps to Reproduce

Set the following env vars:
VECTOR_DB=pgvector
PGVECTOR_DATABASE_URL= posgtresql://xxxxxxx

Start the openwebui container, and wait for it to crash.

Logs & Screenshots

Docker logs :
ERROR [open_webui.retrieval.vector.dbs.pgvector] Error during initialization: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected
2025-05-14T12:48:54.026437990Z
2025-05-14T12:48:54.026444017Z [SQL: CREATE INDEX IF NOT EXISTS idx_document_chunk_vector ON document_chunk USING ivfflat (vector vector_cosine_ops) WITH (lists = 100);]
2025-05-14T12:48:54.026448878Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2025-05-14T12:48:54.026452925Z Traceback (most recent call last):
2025-05-14T12:48:54.026456970Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
2025-05-14T12:48:54.026461405Z self.dialect.do_execute(
2025-05-14T12:48:54.026465290Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
2025-05-14T12:48:54.026469299Z cursor.execute(statement, parameters)
2025-05-14T12:48:54.026473502Z psycopg2.OperationalError: SSL SYSCALL error: EOF detected
2025-05-14T12:48:54.026495552Z
2025-05-14T12:48:54.026499837Z
2025-05-14T12:48:54.026504204Z The above exception was the direct cause of the following exception:
2025-05-14T12:48:54.026508597Z
2025-05-14T12:48:54.026512466Z Traceback (most recent call last):
2025-05-14T12:48:54.026516497Z File "/app/backend/open_webui/retrieval/vector/dbs/pgvector.py", line 96, in init
2025-05-14T12:48:54.026520865Z self.session.execute(
2025-05-14T12:48:54.026525380Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/scoping.py", line 779, in execute
2025-05-14T12:48:54.026530204Z return self._proxied.execute(
2025-05-14T12:48:54.026534088Z ^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.026538573Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
2025-05-14T12:48:54.026543408Z return self._execute_internal(
2025-05-14T12:48:54.026547816Z ^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.026552137Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2260, in _execute_internal
2025-05-14T12:48:54.026556361Z result = conn.execute(
2025-05-14T12:48:54.026560361Z ^^^^^^^^^^^^^
2025-05-14T12:48:54.026564739Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
2025-05-14T12:48:54.026569369Z return meth(
2025-05-14T12:48:54.026573839Z ^^^^^
2025-05-14T12:48:54.026577917Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
2025-05-14T12:48:54.026583050Z return connection._execute_clauseelement(
2025-05-14T12:48:54.026587488Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.026591462Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
2025-05-14T12:48:54.026595809Z ret = self._execute_context(
2025-05-14T12:48:54.026599979Z ^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.026606386Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
2025-05-14T12:48:54.026611157Z return self._exec_single_context(
2025-05-14T12:48:54.026615480Z ^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.026620097Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
2025-05-14T12:48:54.026625077Z self._handle_dbapi_exception(
2025-05-14T12:48:54.026629614Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception
2025-05-14T12:48:54.026633759Z raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
2025-05-14T12:48:54.026645022Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
2025-05-14T12:48:54.026649534Z self.dialect.do_execute(
2025-05-14T12:48:54.026654134Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
2025-05-14T12:48:54.026659115Z cursor.execute(statement, parameters)
2025-05-14T12:48:54.026663653Z sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected
2025-05-14T12:48:54.026668341Z
2025-05-14T12:48:54.026672646Z [SQL: CREATE INDEX IF NOT EXISTS idx_document_chunk_vector ON document_chunk USING ivfflat (vector vector_cosine_ops) WITH (lists = 100);]
2025-05-14T12:48:54.026677131Z (Background on this error at: https://sqlalche.me/e/20/e3q8)
2025-05-14T12:48:54.028192300Z Traceback (most recent call last):
2025-05-14T12:48:54.028792221Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
2025-05-14T12:48:54.030710560Z self.dialect.do_execute(
2025-05-14T12:48:54.030774821Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
2025-05-14T12:48:54.030780119Z cursor.execute(statement, parameters)
2025-05-14T12:48:54.030784318Z psycopg2.OperationalError: SSL SYSCALL error: EOF detected
2025-05-14T12:48:54.030788269Z
2025-05-14T12:48:54.030792123Z
2025-05-14T12:48:54.030795624Z The above exception was the direct cause of the following exception:
2025-05-14T12:48:54.030799728Z
2025-05-14T12:48:54.030803247Z Traceback (most recent call last):
2025-05-14T12:48:54.030806943Z File "", line 198, in _run_module_as_main
2025-05-14T12:48:54.030811115Z File "", line 88, in _run_code
2025-05-14T12:48:54.030814997Z File "/usr/local/lib/python3.11/site-packages/uvicorn/__main__.py", line 4, in
2025-05-14T12:48:54.030819177Z uvicorn.main()
2025-05-14T12:48:54.030822808Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1442, in call
2025-05-14T12:48:54.030826722Z return self.main(*args, **kwargs)
2025-05-14T12:48:54.030830748Z ^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.030834876Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1363, in main
2025-05-14T12:48:54.030838915Z rv = self.invoke(ctx)
2025-05-14T12:48:54.030842633Z ^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.030846248Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1226, in invoke
2025-05-14T12:48:54.030850145Z return ctx.invoke(self.callback, **ctx.params)
2025-05-14T12:48:54.030957214Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.030967565Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 794, in invoke
2025-05-14T12:48:54.042718588Z return callback(*args, **kwargs)
2025-05-14T12:48:54.042735704Z ^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042739874Z File "/usr/local/lib/python3.11/site-packages/uvicorn/main.py", line 412, in main
2025-05-14T12:48:54.042750645Z run(
2025-05-14T12:48:54.042754740Z File "/usr/local/lib/python3.11/site-packages/uvicorn/main.py", line 579, in run
2025-05-14T12:48:54.042758765Z server.run()
2025-05-14T12:48:54.042762480Z File "/usr/local/lib/python3.11/site-packages/uvicorn/server.py", line 66, in run
2025-05-14T12:48:54.042766410Z return asyncio.run(self.serve(sockets=sockets))
2025-05-14T12:48:54.042770191Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042773846Z File "/usr/local/lib/python3.11/asyncio/runners.py", line 190, in run
2025-05-14T12:48:54.042777879Z return runner.run(main)
2025-05-14T12:48:54.042781581Z ^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042785209Z File "/usr/local/lib/python3.11/asyncio/runners.py", line 118, in run
2025-05-14T12:48:54.042788994Z return self._loop.run_until_complete(task)
2025-05-14T12:48:54.042792697Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042796305Z File "uvloop/loop.pyx", line 1518, in uvloop.loop.Loop.run_until_complete
2025-05-14T12:48:54.042800091Z File "/usr/local/lib/python3.11/site-packages/uvicorn/server.py", line 70, in serve
2025-05-14T12:48:54.042803919Z await self._serve(sockets)
2025-05-14T12:48:54.042807780Z File "/usr/local/lib/python3.11/site-packages/uvicorn/server.py", line 77, in serve
2025-05-14T12:48:54.042811747Z config.load()
2025-05-14T12:48:54.042815372Z File "/usr/local/lib/python3.11/site-packages/uvicorn/config.py", line 435, in load
2025-05-14T12:48:54.042819309Z self.loaded_app = import_from_string(self.app)
2025-05-14T12:48:54.042822966Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042826617Z File "/usr/local/lib/python3.11/site-packages/uvicorn/importer.py", line 19, in import_from_string
2025-05-14T12:48:54.042830496Z module = importlib.import_module(module_str)
2025-05-14T12:48:54.042834118Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042837963Z File "/usr/local/lib/python3.11/importlib/__init_.py", line 126, in import_module
2025-05-14T12:48:54.042841963Z return _bootstrap._gcd_import(name[level:], package, level)
2025-05-14T12:48:54.042845776Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042849621Z File "", line 1204, in _gcd_import
2025-05-14T12:48:54.042855937Z File "", line 1176, in _find_and_load
2025-05-14T12:48:54.042870931Z File "", line 1147, in _find_and_load_unlocked
2025-05-14T12:48:54.042874932Z File "", line 690, in _load_unlocked
2025-05-14T12:48:54.042878749Z File "", line 940, in exec_module
2025-05-14T12:48:54.042883635Z File "", line 241, in _call_with_frames_removed
2025-05-14T12:48:54.042887702Z File "/app/backend/open_webui/main.py", line 50, in
2025-05-14T12:48:54.042891766Z from open_webui.utils.audit import AuditLevel, AuditLoggingMiddleware
2025-05-14T12:48:54.042895610Z File "/app/backend/open_webui/utils/audit.py", line 28, in
2025-05-14T12:48:54.042922556Z from open_webui.utils.auth import get_current_user, get_http_authorization_cred
2025-05-14T12:48:54.042928075Z File "/app/backend/open_webui/utils/auth.py", line 16, in
2025-05-14T12:48:54.042931853Z from open_webui.models.users import Users
2025-05-14T12:48:54.042935322Z File "/app/backend/open_webui/models/users.py", line 7, in
2025-05-14T12:48:54.042939058Z from open_webui.models.chats import Chats
2025-05-14T12:48:54.042943951Z File "/app/backend/open_webui/models/chats.py", line 12, in
2025-05-14T12:48:54.042948188Z from open_webui.retrieval.vector.connector import VECTOR_DB_CLIENT
2025-05-14T12:48:54.042951448Z File "/app/backend/open_webui/retrieval/vector/connector.py", line 18, in
2025-05-14T12:48:54.042954773Z VECTOR_DB_CLIENT = PgvectorClient()
2025-05-14T12:48:54.042957990Z ^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042961446Z File "/app/backend/open_webui/retrieval/vector/dbs/pgvector.py", line 96, in init
2025-05-14T12:48:54.042964752Z self.session.execute(
2025-05-14T12:48:54.042968020Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/scoping.py", line 779, in execute
2025-05-14T12:48:54.042971620Z return self._proxied.execute(
2025-05-14T12:48:54.042974695Z ^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042977990Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2365, in execute
2025-05-14T12:48:54.042982015Z return self._execute_internal(
2025-05-14T12:48:54.042985696Z ^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.042996560Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2260, in _execute_internal
2025-05-14T12:48:54.043001200Z result = conn.execute(
2025-05-14T12:48:54.043005042Z ^^^^^^^^^^^^^
2025-05-14T12:48:54.043008677Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
2025-05-14T12:48:54.043012667Z return meth(
2025-05-14T12:48:54.043021832Z ^^^^^
2025-05-14T12:48:54.043025493Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
2025-05-14T12:48:54.043029675Z return connection._execute_clauseelement(
2025-05-14T12:48:54.043033581Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.043037434Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
2025-05-14T12:48:54.043041562Z ret = self._execute_context(
2025-05-14T12:48:54.043045303Z ^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.043049622Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
2025-05-14T12:48:54.043053537Z return self._exec_single_context(
2025-05-14T12:48:54.043057178Z ^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-05-14T12:48:54.043061144Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
2025-05-14T12:48:54.043065326Z self._handle_dbapi_exception(
2025-05-14T12:48:54.043069322Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception
2025-05-14T12:48:54.043073518Z raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
2025-05-14T12:48:54.043077354Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
2025-05-14T12:48:54.043081419Z self.dialect.do_execute(
2025-05-14T12:48:54.043085083Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute
2025-05-14T12:48:54.043089014Z cursor.execute(statement, parameters)
2025-05-14T12:48:54.043092943Z sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected
2025-05-14T12:48:54.043097155Z
2025-05-14T12:48:54.043100939Z [SQL: CREATE INDEX IF NOT EXISTS idx_document_chunk_vector ON document_chunk USING ivfflat (vector vector_cosine_ops) WITH (lists = 100);]
2025-05-14T12:48:54.043104568Z (Background on this error at: https://sqlalche.me/e/20/e3q8)

Additional Information

Hello;

First of all, thank you for this great project.

A bit of context: we are running PGVector on an Azure PaaS database with PGSQL 16.8 and PGVector 0.8.0.
The vector database fails to init, and the openwebui container crashes because of this.

Side note if that matters, we have another instance of OpenWebUI running on PGVector 0.7.0, without any issue, but we are not sure if v0.8.0 is the issue.

Originally created by @valentin-pringault on GitHub (May 14, 2025). Original GitHub issue: https://github.com/open-webui/open-webui/issues/13885 ### Check Existing Issues - [x] I have searched the existing issues and discussions. - [x] I am using the latest version of Open WebUI. ### Installation Method Git Clone ### Open WebUI Version 0.6.9 ### Ollama Version (if applicable) _No response_ ### Operating System Linux (Azure WebApp) ### Browser (if applicable) _No response_ ### Confirmation - [x] I have read and followed all instructions in `README.md`. - [x] I am using 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. - [x] I have listed steps to reproduce the bug in detail. ### Expected Behavior When using an Azure PGSQL database (PG v16.8, PGvector v0.8.0), the vector database is initiated properly when first booting the app. ### Actual Behavior The database init fails, and the app crashes. When removing the VECTOR_DB=pgvector variable (fallback to local chroma), the app starts properly. The EOF issue also happens when calling the init queries from CLI. ### Steps to Reproduce Set the following env vars: VECTOR_DB=pgvector PGVECTOR_DATABASE_URL= posgtresql://xxxxxxx Start the openwebui container, and wait for it to crash. ### Logs & Screenshots Docker logs : ERROR [open_webui.retrieval.vector.dbs.pgvector] Error during initialization: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected 2025-05-14T12:48:54.026437990Z 2025-05-14T12:48:54.026444017Z [SQL: CREATE INDEX IF NOT EXISTS idx_document_chunk_vector ON document_chunk USING ivfflat (vector vector_cosine_ops) WITH (lists = 100);] 2025-05-14T12:48:54.026448878Z (Background on this error at: https://sqlalche.me/e/20/e3q8) 2025-05-14T12:48:54.026452925Z Traceback (most recent call last): 2025-05-14T12:48:54.026456970Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context 2025-05-14T12:48:54.026461405Z self.dialect.do_execute( 2025-05-14T12:48:54.026465290Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute 2025-05-14T12:48:54.026469299Z cursor.execute(statement, parameters) 2025-05-14T12:48:54.026473502Z psycopg2.OperationalError: SSL SYSCALL error: EOF detected 2025-05-14T12:48:54.026495552Z 2025-05-14T12:48:54.026499837Z 2025-05-14T12:48:54.026504204Z The above exception was the direct cause of the following exception: 2025-05-14T12:48:54.026508597Z 2025-05-14T12:48:54.026512466Z Traceback (most recent call last): 2025-05-14T12:48:54.026516497Z File "/app/backend/open_webui/retrieval/vector/dbs/pgvector.py", line 96, in __init__ 2025-05-14T12:48:54.026520865Z self.session.execute( 2025-05-14T12:48:54.026525380Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/scoping.py", line 779, in execute 2025-05-14T12:48:54.026530204Z return self._proxied.execute( 2025-05-14T12:48:54.026534088Z ^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.026538573Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2365, in execute 2025-05-14T12:48:54.026543408Z return self._execute_internal( 2025-05-14T12:48:54.026547816Z ^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.026552137Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2260, in _execute_internal 2025-05-14T12:48:54.026556361Z result = conn.execute( 2025-05-14T12:48:54.026560361Z ^^^^^^^^^^^^^ 2025-05-14T12:48:54.026564739Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute 2025-05-14T12:48:54.026569369Z return meth( 2025-05-14T12:48:54.026573839Z ^^^^^ 2025-05-14T12:48:54.026577917Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection 2025-05-14T12:48:54.026583050Z return connection._execute_clauseelement( 2025-05-14T12:48:54.026587488Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.026591462Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement 2025-05-14T12:48:54.026595809Z ret = self._execute_context( 2025-05-14T12:48:54.026599979Z ^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.026606386Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context 2025-05-14T12:48:54.026611157Z return self._exec_single_context( 2025-05-14T12:48:54.026615480Z ^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.026620097Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context 2025-05-14T12:48:54.026625077Z self._handle_dbapi_exception( 2025-05-14T12:48:54.026629614Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception 2025-05-14T12:48:54.026633759Z raise sqlalchemy_exception.with_traceback(exc_info[2]) from e 2025-05-14T12:48:54.026645022Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context 2025-05-14T12:48:54.026649534Z self.dialect.do_execute( 2025-05-14T12:48:54.026654134Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute 2025-05-14T12:48:54.026659115Z cursor.execute(statement, parameters) 2025-05-14T12:48:54.026663653Z sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected 2025-05-14T12:48:54.026668341Z 2025-05-14T12:48:54.026672646Z [SQL: CREATE INDEX IF NOT EXISTS idx_document_chunk_vector ON document_chunk USING ivfflat (vector vector_cosine_ops) WITH (lists = 100);] 2025-05-14T12:48:54.026677131Z (Background on this error at: https://sqlalche.me/e/20/e3q8) 2025-05-14T12:48:54.028192300Z Traceback (most recent call last): 2025-05-14T12:48:54.028792221Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context 2025-05-14T12:48:54.030710560Z self.dialect.do_execute( 2025-05-14T12:48:54.030774821Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute 2025-05-14T12:48:54.030780119Z cursor.execute(statement, parameters) 2025-05-14T12:48:54.030784318Z psycopg2.OperationalError: SSL SYSCALL error: EOF detected 2025-05-14T12:48:54.030788269Z 2025-05-14T12:48:54.030792123Z 2025-05-14T12:48:54.030795624Z The above exception was the direct cause of the following exception: 2025-05-14T12:48:54.030799728Z 2025-05-14T12:48:54.030803247Z Traceback (most recent call last): 2025-05-14T12:48:54.030806943Z File "<frozen runpy>", line 198, in _run_module_as_main 2025-05-14T12:48:54.030811115Z File "<frozen runpy>", line 88, in _run_code 2025-05-14T12:48:54.030814997Z File "/usr/local/lib/python3.11/site-packages/uvicorn/__main__.py", line 4, in <module> 2025-05-14T12:48:54.030819177Z uvicorn.main() 2025-05-14T12:48:54.030822808Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1442, in __call__ 2025-05-14T12:48:54.030826722Z return self.main(*args, **kwargs) 2025-05-14T12:48:54.030830748Z ^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.030834876Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1363, in main 2025-05-14T12:48:54.030838915Z rv = self.invoke(ctx) 2025-05-14T12:48:54.030842633Z ^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.030846248Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 1226, in invoke 2025-05-14T12:48:54.030850145Z return ctx.invoke(self.callback, **ctx.params) 2025-05-14T12:48:54.030957214Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.030967565Z File "/usr/local/lib/python3.11/site-packages/click/core.py", line 794, in invoke 2025-05-14T12:48:54.042718588Z return callback(*args, **kwargs) 2025-05-14T12:48:54.042735704Z ^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042739874Z File "/usr/local/lib/python3.11/site-packages/uvicorn/main.py", line 412, in main 2025-05-14T12:48:54.042750645Z run( 2025-05-14T12:48:54.042754740Z File "/usr/local/lib/python3.11/site-packages/uvicorn/main.py", line 579, in run 2025-05-14T12:48:54.042758765Z server.run() 2025-05-14T12:48:54.042762480Z File "/usr/local/lib/python3.11/site-packages/uvicorn/server.py", line 66, in run 2025-05-14T12:48:54.042766410Z return asyncio.run(self.serve(sockets=sockets)) 2025-05-14T12:48:54.042770191Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042773846Z File "/usr/local/lib/python3.11/asyncio/runners.py", line 190, in run 2025-05-14T12:48:54.042777879Z return runner.run(main) 2025-05-14T12:48:54.042781581Z ^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042785209Z File "/usr/local/lib/python3.11/asyncio/runners.py", line 118, in run 2025-05-14T12:48:54.042788994Z return self._loop.run_until_complete(task) 2025-05-14T12:48:54.042792697Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042796305Z File "uvloop/loop.pyx", line 1518, in uvloop.loop.Loop.run_until_complete 2025-05-14T12:48:54.042800091Z File "/usr/local/lib/python3.11/site-packages/uvicorn/server.py", line 70, in serve 2025-05-14T12:48:54.042803919Z await self._serve(sockets) 2025-05-14T12:48:54.042807780Z File "/usr/local/lib/python3.11/site-packages/uvicorn/server.py", line 77, in _serve 2025-05-14T12:48:54.042811747Z config.load() 2025-05-14T12:48:54.042815372Z File "/usr/local/lib/python3.11/site-packages/uvicorn/config.py", line 435, in load 2025-05-14T12:48:54.042819309Z self.loaded_app = import_from_string(self.app) 2025-05-14T12:48:54.042822966Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042826617Z File "/usr/local/lib/python3.11/site-packages/uvicorn/importer.py", line 19, in import_from_string 2025-05-14T12:48:54.042830496Z module = importlib.import_module(module_str) 2025-05-14T12:48:54.042834118Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042837963Z File "/usr/local/lib/python3.11/importlib/__init__.py", line 126, in import_module 2025-05-14T12:48:54.042841963Z return _bootstrap._gcd_import(name[level:], package, level) 2025-05-14T12:48:54.042845776Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042849621Z File "<frozen importlib._bootstrap>", line 1204, in _gcd_import 2025-05-14T12:48:54.042855937Z File "<frozen importlib._bootstrap>", line 1176, in _find_and_load 2025-05-14T12:48:54.042870931Z File "<frozen importlib._bootstrap>", line 1147, in _find_and_load_unlocked 2025-05-14T12:48:54.042874932Z File "<frozen importlib._bootstrap>", line 690, in _load_unlocked 2025-05-14T12:48:54.042878749Z File "<frozen importlib._bootstrap_external>", line 940, in exec_module 2025-05-14T12:48:54.042883635Z File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed 2025-05-14T12:48:54.042887702Z File "/app/backend/open_webui/main.py", line 50, in <module> 2025-05-14T12:48:54.042891766Z from open_webui.utils.audit import AuditLevel, AuditLoggingMiddleware 2025-05-14T12:48:54.042895610Z File "/app/backend/open_webui/utils/audit.py", line 28, in <module> 2025-05-14T12:48:54.042922556Z from open_webui.utils.auth import get_current_user, get_http_authorization_cred 2025-05-14T12:48:54.042928075Z File "/app/backend/open_webui/utils/auth.py", line 16, in <module> 2025-05-14T12:48:54.042931853Z from open_webui.models.users import Users 2025-05-14T12:48:54.042935322Z File "/app/backend/open_webui/models/users.py", line 7, in <module> 2025-05-14T12:48:54.042939058Z from open_webui.models.chats import Chats 2025-05-14T12:48:54.042943951Z File "/app/backend/open_webui/models/chats.py", line 12, in <module> 2025-05-14T12:48:54.042948188Z from open_webui.retrieval.vector.connector import VECTOR_DB_CLIENT 2025-05-14T12:48:54.042951448Z File "/app/backend/open_webui/retrieval/vector/connector.py", line 18, in <module> 2025-05-14T12:48:54.042954773Z VECTOR_DB_CLIENT = PgvectorClient() 2025-05-14T12:48:54.042957990Z ^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042961446Z File "/app/backend/open_webui/retrieval/vector/dbs/pgvector.py", line 96, in __init__ 2025-05-14T12:48:54.042964752Z self.session.execute( 2025-05-14T12:48:54.042968020Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/scoping.py", line 779, in execute 2025-05-14T12:48:54.042971620Z return self._proxied.execute( 2025-05-14T12:48:54.042974695Z ^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042977990Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2365, in execute 2025-05-14T12:48:54.042982015Z return self._execute_internal( 2025-05-14T12:48:54.042985696Z ^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.042996560Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2260, in _execute_internal 2025-05-14T12:48:54.043001200Z result = conn.execute( 2025-05-14T12:48:54.043005042Z ^^^^^^^^^^^^^ 2025-05-14T12:48:54.043008677Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1416, in execute 2025-05-14T12:48:54.043012667Z return meth( 2025-05-14T12:48:54.043021832Z ^^^^^ 2025-05-14T12:48:54.043025493Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection 2025-05-14T12:48:54.043029675Z return connection._execute_clauseelement( 2025-05-14T12:48:54.043033581Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.043037434Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement 2025-05-14T12:48:54.043041562Z ret = self._execute_context( 2025-05-14T12:48:54.043045303Z ^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.043049622Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context 2025-05-14T12:48:54.043053537Z return self._exec_single_context( 2025-05-14T12:48:54.043057178Z ^^^^^^^^^^^^^^^^^^^^^^^^^^ 2025-05-14T12:48:54.043061144Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context 2025-05-14T12:48:54.043065326Z self._handle_dbapi_exception( 2025-05-14T12:48:54.043069322Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception 2025-05-14T12:48:54.043073518Z raise sqlalchemy_exception.with_traceback(exc_info[2]) from e 2025-05-14T12:48:54.043077354Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context 2025-05-14T12:48:54.043081419Z self.dialect.do_execute( 2025-05-14T12:48:54.043085083Z File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 942, in do_execute 2025-05-14T12:48:54.043089014Z cursor.execute(statement, parameters) 2025-05-14T12:48:54.043092943Z sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected 2025-05-14T12:48:54.043097155Z 2025-05-14T12:48:54.043100939Z [SQL: CREATE INDEX IF NOT EXISTS idx_document_chunk_vector ON document_chunk USING ivfflat (vector vector_cosine_ops) WITH (lists = 100);] 2025-05-14T12:48:54.043104568Z (Background on this error at: https://sqlalche.me/e/20/e3q8) ### Additional Information Hello; First of all, thank you for this great project. A bit of context: we are running PGVector on an Azure PaaS database with PGSQL 16.8 and PGVector 0.8.0. The vector database fails to init, and the openwebui container crashes because of this. Side note if that matters, we have another instance of OpenWebUI running on PGVector 0.7.0, without any issue, but we are not sure if v0.8.0 is the issue.
GiteaMirror added the bug label 2026-04-19 22:49:53 -05:00
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 bug
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#17062