RAG supabase error searching for documents: 42883 operator does not exist: extensions.vector <=> extensions.vector null

Describe the problem/error/question

What is the error message (if any)?

Hello everyone! I’m having trouble configuring the retrieval of information after the initial setup process has gone correctly. The database appears to have been populated correctly, but when I try to ask a simple question in the chat, it returns this error. I’ve tried everything and can’t solve it!!

{
“name”: “RAG - VECTOR SUPABASE”,
“nodes”: [
{
“parameters”: {
“formTitle”: “Enviar arquivo para o RAG”,
“formDescription”: “={{ $now.setZone(‘America/Boa_Vista’).setLocale(‘pt-BR’).toFormat(“cccc, ‘dia’ dd-MM-yyyy HH:mm”) }}\nFaça aqui a inserção do arquivo homologado pela UTIC:”,
“formFields”: {
“values”: [
{
“fieldLabel”: “Arquivo”,
“fieldType”: “file”,
“requiredField”: true
}
]
},
“options”: {
“appendAttribution”: false
}
},
“type”: “n8n-nodes-base.formTrigger”,
“typeVersion”: 2.3,
“position”: [
256,
0
],
“id”: “58796141-db22-4ac1-8035-e7f9a09b647b”,
“name”: “On form submission”,
“webhookId”: “8d8adbb6-4636-45d9-9851-b9ecba348ece”
},
{
“parameters”: {
“mode”: “insert”,
“tableName”: {
“__rl”: true,
“value”: “documents”,
“mode”: “list”,
“cachedResultName”: “documents”
},
“embeddingBatchSize”: 2000,
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.vectorStoreSupabase”,
“typeVersion”: 1.3,
“position”: [
528,
0
],
“id”: “bc0bb5f3-c941-453d-a575-05f19dc7c692”,
“name”: “Supabase Vector Store”,
“credentials”: {
“supabaseApi”: {
“id”: “liEA0IUwzFJ5cOeO”,
“name”: “supabaseCloudfy”
}
}
},
{
“parameters”: {
“dataType”: “binary”,
“options”: {
“metadata”: {
“metadataValues”: [
{
“name”: “file_id”
}
]
}
}
},
“type”: “@n8n/n8n-nodes-langchain.documentDefaultDataLoader”,
“typeVersion”: 1.1,
“position”: [
656,
176
],
“id”: “8d1f9c18-d341-447c-b4bc-9043be9d09ab”,
“name”: “Default Data Loader”
},
{
“parameters”: {
“content”: “### INDEX”,
“height”: 416,
“width”: 1024
},
“type”: “n8n-nodes-base.stickyNote”,
“position”: [
64,
-96
],
“typeVersion”: 1,
“id”: “21383bdc-30c5-4019-bb0b-cd4c3f84e1e0”,
“name”: “Sticky Note”
},
{
“parameters”: {
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.chatTrigger”,
“typeVersion”: 1.4,
“position”: [
-16,
448
],
“id”: “65f24c53-74f2-4a19-8853-4abd9eb98678”,
“name”: “When chat message received”,
“webhookId”: “ed379c91-e347-4a2a-8464-9d2f745d0466”
},
{
“parameters”: {
“promptType”: “define”,
“text”: “={{ $json.texto }}”,
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.agent”,
“typeVersion”: 3,
“position”: [
592,
448
],
“id”: “5220cbe8-e6cf-41f0-9cf3-54f309cf184c”,
“name”: “AI Agent”
},
{
“parameters”: {
“model”: {
“__rl”: true,
“value”: “gpt-4.1-mini”,
“mode”: “list”,
“cachedResultName”: “gpt-4.1-mini”
},
“builtInTools”: {},
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.lmChatOpenAi”,
“typeVersion”: 1.3,
“position”: [
464,
656
],
“id”: “e4801ab9-70ab-476b-8c33-82892ca3885c”,
“name”: “OpenAI Chat Model”,
“credentials”: {
“openAiApi”: {
“id”: “Z78e6dClbFPjxsiJ”,
“name”: “OpenAi-PLUS”
}
}
},
{
“parameters”: {},
“type”: “@n8n/n8n-nodes-langchain.memoryBufferWindow”,
“typeVersion”: 1.3,
“position”: [
608,
656
],
“id”: “e4c859af-2dd9-42e5-8b27-67558b129a21”,
“name”: “Simple Memory”
},
{
“parameters”: {
“mode”: “retrieve-as-tool”,
“toolDescription”: “use essa tool para acessar informações.”,
“tableName”: {
“__rl”: true,
“value”: “documents”,
“mode”: “list”,
“cachedResultName”: “documents”
},
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.vectorStoreSupabase”,
“typeVersion”: 1.3,
“position”: [
928,
592
],
“id”: “618ccc4f-7553-43b0-a437-a9657575af79”,
“name”: “Supabase Vector Store1”,
“credentials”: {
“supabaseApi”: {
“id”: “liEA0IUwzFJ5cOeO”,
“name”: “supabaseCloudfy”
}
}
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“id”: “b65d3e89-01ad-4dc0-8165-e3c06219a5a4”,
“name”: “texto”,
“value”: “={{ $json.input || $json.chatInput || “” }}”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
288,
448
],
“id”: “3b743c1f-112b-41de-9d2c-5a20a59f4f1e”,
“name”: “Edit Fields”
},
{
“parameters”: {
“modelName”: “models/gemini-embedding-001”
},
“type”: “@n8n/n8n-nodes-langchain.embeddingsGoogleGemini”,
“typeVersion”: 1,
“position”: [
448,
176
],
“id”: “1e774049-6ed3-44c5-b192-7592671fe232”,
“name”: “Embeddings Google Gemini”,
“credentials”: {
“googlePalmApi”: {
“id”: “7pPh0dvRXdRtkkyS”,
“name”: “Google Gemini(PaLM) - PRO”
}
}
},
{
“parameters”: {
“modelName”: “models/gemini-embedding-001”
},
“type”: “@n8n/n8n-nodes-langchain.embeddingsGoogleGemini”,
“typeVersion”: 1,
“position”: [
1008,
800
],
“id”: “2e88bea9-d3e5-4e12-bb05-50087b169879”,
“name”: “Embeddings Google Gemini1”,
“credentials”: {
“googlePalmApi”: {
“id”: “7pPh0dvRXdRtkkyS”,
“name”: “Google Gemini(PaLM) - PRO”
}
}
}
],
“pinData”: {},
“connections”: {
“On form submission”: {
“main”: [
[
{
“node”: “Supabase Vector Store”,
“type”: “main”,
“index”: 0
}
]
]
},
“Default Data Loader”: {
“ai_document”: [
[
{
“node”: “Supabase Vector Store”,
“type”: “ai_document”,
“index”: 0
}
]
]
},
“When chat message received”: {
“main”: [
[
{
“node”: “Edit Fields”,
“type”: “main”,
“index”: 0
}
]
]
},
“OpenAI Chat Model”: {
“ai_languageModel”: [
[
{
“node”: “AI Agent”,
“type”: “ai_languageModel”,
“index”: 0
}
]
]
},
“Simple Memory”: {
“ai_memory”: [
[
{
“node”: “AI Agent”,
“type”: “ai_memory”,
“index”: 0
}
]
]
},
“Supabase Vector Store1”: {
“ai_tool”: [
[
{
“node”: “AI Agent”,
“type”: “ai_tool”,
“index”: 0
}
]
]
},
“Edit Fields”: {
“main”: [
[
{
“node”: “AI Agent”,
“type”: “main”,
“index”: 0
}
]
]
},
“Embeddings Google Gemini”: {
“ai_embedding”: [
[
{
“node”: “Supabase Vector Store”,
“type”: “ai_embedding”,
“index”: 0
}
]
]
},
“Embeddings Google Gemini1”: {
“ai_embedding”: [
[
{
“node”: “Supabase Vector Store1”,
“type”: “ai_embedding”,
“index”: 0
}
]
]
}
},
“active”: false,
“settings”: {
“executionOrder”: “v1”
},
“versionId”: “dcc096c5-811f-40d3-8243-0a616092f0d9”,
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “9ac933ed51c741c45c1e0883c77ff4378b4f078faf3c97bbc14a22ff79117abb”
},
“id”: “0IzXYoESc1D8qr8D”,
“tags”:
}

Information about your n8n configuration

n8n version: 2.0.2

Database (default: SQLite): supabase

n8n EXECUTIONS_PROCESS configuration (default: own, main):

Running n8n via (Docker, npm, n8n cloud, desktop application): self host

I don’t know why this issue would occur with the standard Subapase Vector Store node, but here is a thread about the exact same response and a possible fix for the database:

1 Like

This happened to me once, it has something to do with supabase’s architecture. You need to create a function in Supabase for the RAG to work.

It happened with me two weeks ago. No questions asked.

Exporting the n8n-volume (including workflows + credentials etc) using ssh and leaving n8n via docker behind - quick vps coolify install - importing it to coolify (n8n + worker + postgres) was the only quickest solution.

Furthermore you can host a separate supabase instance on coolify for your work. That would be error free.

I know this is too much for one Supabase error. But trust me, it would save your thousands of hrs in the future for troubleshooting errors like this.

Let Coolify do the heavy-lifting for you.

The solution ended up being simpler than I imagined. I did some research in some forums and ended up finding a solution. I added lines 2 (create extension if not exists vector schema extensions;) and 24 (SET search_path = public, extensions).

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.