Target branch: Verify that the pull request targets the dev branch.
Description: Provided below.
Changelog: Included below.
Testing: Manually verified the UnboundLocalError no longer occurs when calling Oracle23aiClient.get().
Code review: Self-reviewed. Single-line move, no new dependencies.
Git Hygiene: Atomic, single-commit fix.
Changelog Entry
Description
Fixes#22664 — UnboundLocalError when calling Oracle23aiClient.get() because limit was referenced in log.info() before assignment.
Fixed
Moved limit = 1000 assignment before the log.info() call in Oracle23aiClient.get() so the variable is defined when first referenced.
Additional Information
Root cause: Python treats limit as local throughout the function scope due to the later assignment. The log.info() call on the line before the assignment triggers UnboundLocalError.
Impact: Hybrid search with Oracle 23ai was completely broken. Users enabling Hybrid Search and performing RAG queries would hit this crash.
Contributor License Agreement
By submitting this pull request, I confirm that I have read and fully agree to the Contributor License Agreement (CLA), and I am providing my contributions under its terms.
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.
## 📋 Pull Request Information
**Original PR:** https://github.com/open-webui/open-webui/pull/22771
**Author:** [@aayushbaluni](https://github.com/aayushbaluni)
**Created:** 3/17/2026
**Status:** ❌ Closed
**Base:** `dev` ← **Head:** `fix/22664-oracle23ai-limit-unbound`
---
### 📝 Commits (10+)
- [`fe6783c`](https://github.com/open-webui/open-webui/commit/fe6783c16699911c7be17392596d579333fb110c) Merge pull request #19030 from open-webui/dev
- [`fc05e0a`](https://github.com/open-webui/open-webui/commit/fc05e0a6c5d39da60b603b4d520f800d6e36f748) Merge pull request #19405 from open-webui/dev
- [`e3faec6`](https://github.com/open-webui/open-webui/commit/e3faec62c58e3a83d89aa3df539feacefa125e0c) Merge pull request #19416 from open-webui/dev
- [`9899293`](https://github.com/open-webui/open-webui/commit/9899293f050ad50ae12024cbebee7e018acd851e) Merge pull request #19448 from open-webui/dev
- [`140605e`](https://github.com/open-webui/open-webui/commit/140605e660b8186a7d5c79fb3be6ffb147a2f498) Merge pull request #19462 from open-webui/dev
- [`6f1486f`](https://github.com/open-webui/open-webui/commit/6f1486ffd0cb288d0e21f41845361924e0d742b3) Merge pull request #19466 from open-webui/dev
- [`d95f533`](https://github.com/open-webui/open-webui/commit/d95f533214e3fe5beb5e41ec1f349940bc4c7043) Merge pull request #19729 from open-webui/dev
- [`a727153`](https://github.com/open-webui/open-webui/commit/a7271532f8a38da46785afcaa7e65f9a45e7d753) 0.6.43 (#20093)
- [`6adde20`](https://github.com/open-webui/open-webui/commit/6adde203cd292a9e3af9c64a2ae36b603fed096a) Merge pull request #20394 from open-webui/dev
- [`f9b0534`](https://github.com/open-webui/open-webui/commit/f9b0534e0c442631d1cb7205169588b9b6204179) Merge pull request #20522 from open-webui/dev
### 📊 Changes
**1 file changed** (+1 additions, -1 deletions)
<details>
<summary>View changed files</summary>
📝 `backend/open_webui/retrieval/vector/dbs/oracle23ai.py` (+1 -1)
</details>
### 📄 Description
<!--
⚠️ CRITICAL CHECKS FOR CONTRIBUTORS (READ, DON'T DELETE) ⚠️
1. Target the `dev` branch. PRs targeting `main` will be automatically closed.
2. Do NOT delete the CLA section at the bottom. It is required for the bot to accept your PR.
-->
# Pull Request Checklist
- [x] **Target branch:** Verify that the pull request targets the `dev` branch.
- [x] **Description:** Provided below.
- [x] **Changelog:** Included below.
- [x] **Testing:** Manually verified the `UnboundLocalError` no longer occurs when calling `Oracle23aiClient.get()`.
- [x] **Code review:** Self-reviewed. Single-line move, no new dependencies.
- [x] **Git Hygiene:** Atomic, single-commit fix.
# Changelog Entry
### Description
Fixes #22664 — `UnboundLocalError` when calling `Oracle23aiClient.get()` because `limit` was referenced in `log.info()` before assignment.
### Fixed
- Moved `limit = 1000` assignment before the `log.info()` call in `Oracle23aiClient.get()` so the variable is defined when first referenced.
---
### Additional Information
- Root cause: Python treats `limit` as local throughout the function scope due to the later assignment. The `log.info()` call on the line before the assignment triggers `UnboundLocalError`.
- Impact: Hybrid search with Oracle 23ai was completely broken. Users enabling Hybrid Search and performing RAG queries would hit this crash.
### Contributor License Agreement
- [x] By submitting this pull request, I confirm that I have read and fully agree to the [Contributor License Agreement (CLA)](https://github.com/open-webui/open-webui/blob/main/CONTRIBUTOR_LICENSE_AGREEMENT), and I am providing my contributions under its terms.
Made with [Cursor](https://cursor.com)
---
<sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 Pull Request Information
Original PR: https://github.com/open-webui/open-webui/pull/22771
Author: @aayushbaluni
Created: 3/17/2026
Status: ❌ Closed
Base:
dev← Head:fix/22664-oracle23ai-limit-unbound📝 Commits (10+)
fe6783cMerge pull request #19030 from open-webui/devfc05e0aMerge pull request #19405 from open-webui/deve3faec6Merge pull request #19416 from open-webui/dev9899293Merge pull request #19448 from open-webui/dev140605eMerge pull request #19462 from open-webui/dev6f1486fMerge pull request #19466 from open-webui/devd95f533Merge pull request #19729 from open-webui/deva7271530.6.43 (#20093)6adde20Merge pull request #20394 from open-webui/devf9b0534Merge pull request #20522 from open-webui/dev📊 Changes
1 file changed (+1 additions, -1 deletions)
View changed files
📝
backend/open_webui/retrieval/vector/dbs/oracle23ai.py(+1 -1)📄 Description
Pull Request Checklist
devbranch.UnboundLocalErrorno longer occurs when callingOracle23aiClient.get().Changelog Entry
Description
Fixes #22664 —
UnboundLocalErrorwhen callingOracle23aiClient.get()becauselimitwas referenced inlog.info()before assignment.Fixed
limit = 1000assignment before thelog.info()call inOracle23aiClient.get()so the variable is defined when first referenced.Additional Information
limitas local throughout the function scope due to the later assignment. Thelog.info()call on the line before the assignment triggersUnboundLocalError.Contributor License Agreement
Made with Cursor
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.