-
-
Notifications
You must be signed in to change notification settings - Fork 23.7k
Description
Describe the bug
After updating to 3.0.12, when we try to upsert to a new datastore. it doesn't create the datastore table, rolling back to 3.0.11, makes the behavior works as expected.
It works for an existing, table, so the issue is the creation of the table.
Flowise and the PostgreSQL server are two differents docker compose project but they share a network.
My embedding model is a local dockerized ollama instance on another machine running qwen3-embedding:8b
To Reproduce
- Go to "Document Stores"
- Prepare a datastore by pre-processing documents etc
- Go to the upsert documents
- Fill the 3 tabs: like so:
- We then have errors like so:
- In Flowise WebGUI: Status: 500
Error: documentStoreServices.insertIntoVectorStoreMiddleware - Error: documentStoreServices.insertIntoVectorStore - Error: documentStoreServices._insertIntoVectorStoreWorkerThread - Error: Error inserting
- In Flowise logs: one error in interesting:
flowise-1 | QueryFailedError: relation "foo_embeddings" does not exist
flowise-1 | at PostgresQueryRunner.query (/usr/local/lib/node_modules/flowise/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:216:19)
flowise-1 | at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
flowise-1 | at async SelectQueryBuilder.loadRawResults (/usr/local/lib/node_modules/flowise/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2231:25)
flowise-1 | at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/local/lib/node_modules/flowise/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2079:26)
flowise-1 | at async SelectQueryBuilder.getRawAndEntities (/usr/local/lib/node_modules/flowise/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29)
flowise-1 | at async SelectQueryBuilder.getMany (/usr/local/lib/node_modules/flowise/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25)
flowise-1 | at async /usr/local/lib/node_modules/flowise/node_modules/typeorm/persistence/SubjectDatabaseEntityLoader.js:88:28
flowise-1 | at async Promise.all (index 0)
flowise-1 | at async SubjectDatabaseEntityLoader.load (/usr/local/lib/node_modules/flowise/node_modules/typeorm/persistence/SubjectDatabaseEntityLoader.js:113:9)
flowise-1 | at async /usr/local/lib/node_modules/flowise/node_modules/typeorm/persistence/EntityPersistExecutor.js:93:17
flowise-1 | at async Promise.all (index 0)
flowise-1 | at async EntityPersistExecutor.execute (/usr/local/lib/node_modules/flowise/node_modules/typeorm/persistence/EntityPersistExecutor.js:59:31)
flowise-1 | at async instance.addVectors (/usr/local/lib/node_modules/flowise/node_modules/flowise-components/dist/nodes/vectorstores/Postgres/driver/TypeORM.js:101:21)
flowise-1 | at async index (/usr/local/lib/node_modules/flowise/node_modules/flowise-components/dist/src/indexing.js:194:13)
flowise-1 | at async Object.upsert (/usr/local/lib/node_modules/flowise/node_modules/flowise-components/dist/nodes/vectorstores/Postgres/Postgres.js:54:37)
flowise-1 | at async _insertIntoVectorStoreWorkerThread (/usr/local/lib/node_modules/flowise/dist/services/documentstore/index.js:1112:29) {
- In my postgre logs:
postgres-vector-1 | 2025-12-12 10:22:25.397 UTC [510] ERROR: relation "foo_embeddings" does not exist at character 240
postgres-vector-1 | 2025-12-12 10:22:25.397 UTC [510] STATEMENT: SELECT "foo_embeddings"."id" AS "foo_embeddings_id", "foo_embeddings"."pageContent" AS "foo_embeddings_pageContent", "foo_embeddings"."metadata" AS "foo_embeddings_metadata", "foo_embeddings"."embedding" AS "foo_embeddings_embedding" FROM "foo_embeddings" "foo_embeddings" WHERE "foo_embeddings"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100)
And pgadmin:
Expected behavior
The table gets created
Screenshots
No response
Flow
No response
Use Method
Docker
Flowise Version
3.0.11
Operating System
Linux
Browser
Firefox
Additional context
No response