Error when searching embeddings

[VijinV]

Checked other resources

• I added a very descriptive title to this question.
• I searched the LangChain documentation with the integrated search.
• I used the GitHub search to find a similar question and didn't find it.

Commit to Help

• I commit to help with one of those options 👆

Example Code

import { OpenAIEmbeddings } from "@langchain/openai";
import { PrismaVectorStore } from '@langchain/community/vectorstores/prisma';
import { Embeddings, Prisma } from "@prisma/client";
import { client } from "./prisma";

export const embeddings = new OpenAIEmbeddings({ apiKey: process.env.OPEN_AI_KEY })

export const vectorStore = PrismaVectorStore.withModel<Embeddings>(client).create(
    embeddings,
    {
        prisma: Prisma,
        tableName: 'Embeddings',
        vectorColumnName: 'embedding',
        columns: {
            id: PrismaVectorStore.IdColumn,
            content: PrismaVectorStore.ContentColumn,
        },
    }
);


export async function searchEmbeddingsByDomain(query: string, domainId: string, k: number = 5) {
    try {
        console.log("Searching for query:", query, "in domain:", domainId);
        // Perform similarity search
        const results = await vectorStore.similaritySearch(query, k, { domainId:{equals:domainId} });

        if (!results || !Array.isArray(results)) {
            console.warn("No results found or unexpected response format.");
            return [];
        }

        // Extract and return relevant documents
        const relevantResults = results.map(result => result.pageContent ?? result);

        console.log("Relevant results:", relevantResults);
        return relevantResults;
    } catch (error) {
        console.error("Error searching embeddings:", error);
        return [];
    }
}

Description

Searching for query: hi in domain: ed5c6c28-fce7-4850-b743-f1983b3dbb0c
(node:4092) [DEP0040] DeprecationWarning: The punycode module is deprecated. Please use a userland alternative instead.
(Use node --trace-deprecation ... to show where the warning was created)
Error searching embeddings: PrismaClientKnownRequestError:
Invalid prisma.$queryRaw() invocation:

Raw query failed. Code: 42883. Message: ERROR: operator does not exist: uuid = text HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
at In.handleRequestError (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:122:6854)
at In.handleAndLogRequestError (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:122:6188)
at In.request (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:122:5896)
at async l (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:127:11167)
at async PrismaVectorStore.similaritySearchVectorWithScore (D:\WORK\Website-Chatbot.next\server\chunks\ssr\node_modules_7a5bee..js:18529:26)
at async PrismaVectorStore.similaritySearch (D:\WORK\Website-Chatbot.next\server\chunks\ssr\node_modules_7a5bee..js:18501:25)
at async searchEmbeddingsByDomain (D:\WORK\Website-Chatbot.next\server\chunks\ssr[root of the server]__c5e9b0._.js:1479:25) {
code: 'P2010',
clientVersion: '5.13.0',
meta: {
code: '42883',
message: 'ERROR: operator does not exist: uuid = text\n' +
'HINT: No operator matches the given name and argument types. You might need to add explicit type casts.'
}
}

##The issue happens when trying to filter by domainId in the similaritySearch function.

can anyone help me to solve this issue

System Info

Prisma version: 5.13.0
OS: Windows

[dosubot[bot]]

Hey @VijinV! 👋 I'm here to help you with your technical queries and bugs. I'm a bot that can assist you in solving issues, answering questions, and becoming a contributor. Let's tackle this bug together!

The error you're encountering is due to a type mismatch between the domainId field in your database and the value you're passing in the filter. The error message indicates that the domainId field is of type UUID, but you're passing a text type value, which causes the query to fail.

To resolve this issue, you need to ensure that the domainId value you pass in the filter is of the correct type. If domainId is a UUID in your database, you should ensure that the value you pass is also a UUID. Here's how you can modify your code:

1. Ensure that the domainId you pass to the similaritySearch function is a valid UUID. You can use a library like uuid to validate or convert the string to a UUID if necessary.

2. If the domainId is already a UUID string, you might need to explicitly cast it in your query. However, Prisma should handle this automatically if the types are correct.

Here's a quick check you can add to ensure the domainId is a valid UUID:

import { validate as isUuid } from 'uuid';

export async function searchEmbeddingsByDomain(query: string, domainId: string, k: number = 5) {
    try {
        if (!isUuid(domainId)) {
            throw new Error("Invalid domainId format. It must be a valid UUID.");
        }

        console.log("Searching for query:", query, "in domain:", domainId);
        const results = await vectorStore.similaritySearch(query, k, { domainId: { equals: domainId } });

        if (!results || !Array.isArray(results)) {
            console.warn("No results found or unexpected response format.");
            return [];
        }

        const relevantResults = results.map(result => result.pageContent ?? result);

        console.log("Relevant results:", relevantResults);
        return relevantResults;
    } catch (error) {
        console.error("Error searching embeddings:", error);
        return [];
    }
}

This code uses the uuid library to validate the domainId. Make sure to install the uuid package if you haven't already:

npm install uuid

By ensuring the domainId is a valid UUID, you should be able to avoid the type mismatch error.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[VijinV]

Still getting the same error.

Searching for query: hi in domain: ed5c6c28-fce7-4850-b743-f1983b3dbb0c
(node:19664) [DEP0040] DeprecationWarning: The punycode module is deprecated. Please use a userland alternative instead.
(Use node --trace-deprecation ... to show where the warning was created)
Error searching embeddings: PrismaClientKnownRequestError:
Invalid prisma.$queryRaw() invocation:

Raw query failed. Code: 42883. Message: ERROR: operator does not exist: uuid = text HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
at In.handleRequestError (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:122:6854)
at In.handleAndLogRequestError (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:122:6188)
at In.request (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:122:5896)
at async l (D:\WORK\Website-Chatbot\node_modules@prisma\client\runtime\library.js:127:11167)
at async PrismaVectorStore.similaritySearchVectorWithScore (D:\WORK\Website-Chatbot.next\server\chunks\ssr\node_modules_e7b047..js:24810:26)
at async PrismaVectorStore.similaritySearch (D:\WORK\Website-Chatbot.next\server\chunks\ssr\node_modules_e7b047..js:24782:25)
at async searchEmbeddingsByDomain (D:\WORK\Website-Chatbot.next\server\chunks\ssr[root of the server]__cf35c4._.js:2100:25) {
code: 'P2010',
clientVersion: '5.13.0',
meta: {
code: '42883',
message: 'ERROR: operator does not exist: uuid = text\n' +
'HINT: No operator matches the given name and argument types. You might need to add explicit type casts.'
}
}

[Charlesnorris509]

Hi @VijinV as mentionned by the @dosu. the Issue is due to typecasting mismatch indicating that You might need to add explicit type casts.
In order to resolve this issue you need to process three steps. Start By implementing explicit type casting, you should be able to do that by modifying the DomainId Class, Secondly you need to Ensure your Prisma schema is correctly defined. Finally Update your script to make sure that the domainId is correctly passed as a UUID type in the filter.

[dosubot[bot]]

Could you provide more details about how the domainId is defined in your Prisma schema? Additionally, are you using any specific database that might require a different approach to handle UUIDs? This information will help in identifying the root cause of the type mismatch issue.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}