column "metadata" does not exis #12264

Closed
opened 2026-02-21 19:06:38 -05:00 by yindo · 2 comments
Owner

Originally created by @lostz on GitHub (Mar 27, 2025).

Originally assigned to: @JohnJyong on GitHub.

Self Checks

  • This is only for bug report, if you would like to ask a question, please head to Discussions.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
  • [FOR CHINESE USERS] 请务必使用英文提交 Issue,否则会被关闭。谢谢!:)
  • Please do not modify this template :) and fill in all the required fields.

Dify version

1.13

Cloud or Self Hosted

Self Hosted (Docker)

VECTOR_STORE=pgvector

Steps to reproduce

Metadata Error in Workflow Knowledge Retrieval Despite Metadata Being Enabled

Image

Traceback (most recent call last):
File "/usr/local/lib/python3.12/threading.py", line 1075, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1012, in run
self._target(*self._args, **self._kwargs)
File "/app/api/core/rag/retrieval/dataset_retrieval.py", line 624, in _retriever
documents = RetrievalService.retrieve(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/api/core/rag/datasource/retrieval_service.py", line 106, in retrieve
raise ValueError(";\n".join(exceptions))
ValueError: column "metadata" does not exist
LINE 1: ..._8575a5ad_34fd_4419_8f5c_67e5029a8475_Node WHERE metadata->...
^
;
column "metadata" does not exist
LINE 4: AND metadata->>'document_id' in ('8c73d...
^

✔️ Expected Behavior

No response

Actual Behavior

No response

Originally created by @lostz on GitHub (Mar 27, 2025). Originally assigned to: @JohnJyong on GitHub. ### Self Checks - [x] This is only for bug report, if you would like to ask a question, please head to [Discussions](https://github.com/langgenius/dify/discussions/categories/general). - [x] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [x] I confirm that I am using English to submit this report (我已阅读并同意 [Language Policy](https://github.com/langgenius/dify/issues/1542)). - [x] [FOR CHINESE USERS] 请务必使用英文提交 Issue,否则会被关闭。谢谢!:) - [x] Please do not modify this template :) and fill in all the required fields. ### Dify version 1.13 ### Cloud or Self Hosted Self Hosted (Docker) VECTOR_STORE=pgvector ### Steps to reproduce Metadata Error in Workflow Knowledge Retrieval Despite Metadata Being Enabled <img width="413" alt="Image" src="https://github.com/user-attachments/assets/bb155ef2-d670-4840-ac19-430a99a85216" /> Traceback (most recent call last): File "/usr/local/lib/python3.12/threading.py", line 1075, in _bootstrap_inner self.run() File "/usr/local/lib/python3.12/threading.py", line 1012, in run self._target(*self._args, **self._kwargs) File "/app/api/core/rag/retrieval/dataset_retrieval.py", line 624, in _retriever documents = RetrievalService.retrieve( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/api/core/rag/datasource/retrieval_service.py", line 106, in retrieve raise ValueError(";\n".join(exceptions)) ValueError: column "metadata" does not exist LINE 1: ..._8575a5ad_34fd_4419_8f5c_67e5029a8475_Node WHERE metadata->... ^ ; column "metadata" does not exist LINE 4: AND metadata->>'document_id' in ('8c73d... ^ ### ✔️ Expected Behavior _No response_ ### ❌ Actual Behavior _No response_
yindo added the 🐞 bug label 2026-02-21 19:06:38 -05:00
yindo closed this issue 2026-02-21 19:06:38 -05:00
Author
Owner

@jacobapeng11 commented on GitHub (Apr 10, 2025):

same problem

@jacobapeng11 commented on GitHub (Apr 10, 2025): same problem
Author
Owner

@jacobapeng11 commented on GitHub (Jun 24, 2025):

这是来自QQ邮箱的假期自动回复邮件。
 
您好,我最近正在休假中,无法亲自回复您的邮件。我将在假期结束后,尽快给您回复。

@jacobapeng11 commented on GitHub (Jun 24, 2025): 这是来自QQ邮箱的假期自动回复邮件。   您好,我最近正在休假中,无法亲自回复您的邮件。我将在假期结束后,尽快给您回复。
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#12264