Flowise icon indicating copy to clipboard operation
Flowise copied to clipboard

[BUG]The old content in the [document storage[ was not successfully cleared.

Open Arrding opened this issue 10 months ago • 5 comments

In the [document storage], I have successfully stored documents "file1, file2, file3" into the Postgres database via Flowise. Afterwards, I deleted "file1, file2, file3" and loaded "file4" in the [document storage] of Flowise, with the upsert chunks operation completing successfully. However, I logging into Postgres to check, it was found that the data of the old three files were still there. when I use [chatflows] for conversation, its responses also cite content from file1, file2, and file3.

I expected: when I delete f"file1, file2, file3", these files should also be deleted from Postgres, and chatflows should not reference the data that has been deleted during conversation.

Flowise Version:2.2.6-hotfix.1 Postgres version:17 OS:Centos7

Image

Image

Image

Arrding avatar Mar 10 '25 10:03 Arrding

This happens to me too... noticed in 2.2.4 and 2.2.7-patch.1.

Before changing documents on loaders, I always have to go to the database to clean up old content, despite the "added/updated/ignored/deleted" screen showing what I really want to happen.

It's easy to spot this bug by going to the "Retrieval Query" screen. After you query something, you can see repeated chunks on the right.

I hope Mr. @HenryHengZJ could help us!

Thanks! 🙏

almirb avatar Apr 01 '25 17:04 almirb

Hi! Any news on this?

Thanks!! :)

almirb avatar Apr 15 '25 11:04 almirb

The problem still hasn't been solved

Arrding avatar Apr 23 '25 13:04 Arrding

I think this is duplicate of #3570, there is a great explanation why this is happening.

mspasov avatar Apr 29 '25 23:04 mspasov

Hi, I also ran into this. Sadly this means Postgresql is pretty much unucable at this time. :(

lampyon-canada avatar May 06 '25 11:05 lampyon-canada

Fix: https://github.com/FlowiseAI/Flowise/pull/5536

HenryHengZJ avatar Nov 30 '25 01:11 HenryHengZJ