Skip to content

Upserting documents in flowise 3.0.12 doesn't create the table when using PostgreSQL integration #5572

@NastySpaghetti

Description

@NastySpaghetti

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

  1. Go to "Document Stores"
  2. Prepare a datastore by pre-processing documents etc
  3. Go to the upsert documents
  4. Fill the 3 tabs: like so:
Image
  1. 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:

Image

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions