Replies: 1 comment
-
The error you're encountering, To resolve this issue, you should:
If your database schema incorrectly defines an Regarding the By making these adjustments, you should be able to resolve the error and ensure your application correctly interacts with the PostgreSQL database as expected by the LangChain framework.
|
Beta Was this translation helpful? Give feedback.
-
Checked other resources
Commit to Help
Example Code
Description
Have been getting this error for a while but don't know what is wrong, only could find one similar issue but didn't help, please help.
resume_download
is deprecated and will be removed in version 1.0.0. Downloads always resume when possible. If you want to force a new download, useforce_download=True
.warnings.warn(
D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\huggingface_hub\file_download.py:1132: FutureWarning:
resume_download
is deprecated and will be removed in version 1.0.0. Downloads always resume when possible. If you want to force a new download, useforce_download=True
.warnings.warn(
Traceback (most recent call last):
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\default.py", line 924, in do_execute
cursor.execute(statement, parameters)
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\psycopg\cursor.py", line 732, in execute
raise ex.with_traceback(None)
psycopg.errors.UndefinedColumn: column langchain_pg_embedding.id does not exist
LINE 1: SELECT langchain_pg_embedding.id AS langchain_pg_embedding_i...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "D:\Repos\ai-chat\ai-chat\redis_prub.py", line 70, in
user_input("hello")
File "D:\Repos\ai-chat\ai-chat\redis_prub.py", line 59, in user_input
docs = retriever.invoke(user_question)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_core\retrievers.py", line 194, in invoke
return self.get_relevant_documents(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_core_api\deprecation.py", line 148, in warning_emitting_wrapper
return wrapped(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_core\retrievers.py", line 323, in get_relevant_documents
raise e
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_core\retrievers.py", line 316, in get_relevant_documents
result = self._get_relevant_documents(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_core\vectorstores.py", line 696, in _get_relevant_documents
docs = self.vectorstore.similarity_search(query, **self.search_kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_postgres\vectorstores.py", line 547, in similarity_search
return self.similarity_search_by_vector(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_postgres\vectorstores.py", line 953, in similarity_search_by_vector
docs_and_scores = self.similarity_search_with_score_by_vector(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_postgres\vectorstores.py", line 595, in similarity_search_with_score_by_vector
results = self.__query_collection(embedding=embedding, k=k, filter=filter)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\langchain_postgres\vectorstores.py", line 931, in __query_collection
.all()
^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\orm\query.py", line 2673, in all
return self._iter().all() # type: ignore
^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\orm\query.py", line 2827, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 2351, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\orm\session.py", line 2236, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\orm\context.py", line 293, in orm_execute_statement
result = conn.execute(
^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1418, in execute
return meth(
^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\sql\elements.py", line 515, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1640, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1846, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 2353, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\sqlalchemy\engine\default.py", line 924, in do_execute
cursor.execute(statement, parameters)
File "D:\Repos\ai-chat\ai-chat.venv\Lib\site-packages\psycopg\cursor.py", line 732, in execute
raise ex.with_traceback(None)
sqlalchemy.exc.ProgrammingError: (psycopg.errors.UndefinedColumn) column langchain_pg_embedding.id does not exist
LINE 1: SELECT langchain_pg_embedding.id AS langchain_pg_embedding_i...
^
[SQL: SELECT langchain_pg_embedding.id AS langchain_pg_embedding_id, langchain_pg_embedding.collection_id AS langchain_pg_embedding_collection_id, langchain_pg_embedding.embedding AS langchain_pg_embedding_embedding, langchain_pg_embedding.document AS langchain_pg_embedding_document, langchain_pg_embedding.cmetadata AS langchain_pg_embedding_cmetadata, langchain_pg_embedding.embedding <=> %(embedding_1)s AS distance
hain_pg_embedding.collection_id = langchain_pg_collection.uuid
WHERE langchain_pg_embedding.collection_id = %(collection_id_1)s::UUID ORDER BY distance ASC
LIMIT %(param_1)s::INTEGER]
[parameters: {'embedding_1': '[-0.0627717524766922,0.05495881661772728,0.05216481536626816,0.08579003065824509,-0.08274894207715988,-0.07457299530506134,0.06855468451976776,0.0183 ... (7750 characters truncated) ... 886,-0.014873551204800606,-0.0467415452003479,-0.013411270454525948,0.06513477861881256,0.05090592801570892,0.05148357152938843,0.007092179264873266]', 'collection_id_1': UUID('8d3a2b8a-0df8-42ff-bec5-9686338750cd'), 'param_1': 4}]
System Info
System Information
Package Information
Packages not installed (Not Necessarily a Problem)
The following packages were not found:
Beta Was this translation helpful? Give feedback.
All reactions