postgres - message table - flow id constain error with published flow

[egerszu]

Bug Description

Hi,

The published flow is using a made up flow id that cannot be inserted into the message table.

IntegrityError: (psycopg.errors.ForeignKeyViolation) insert or update on table
"message" violates foreign key constraint "message_flow_id_fkey"
DETAIL: Key (flow_id)=(1f89c99c-f7dd-5863-8974-56abc3a347d2) is not present in
table "flow".

I would like to contribute, but need a direction what you would prefer.
Remove the constrain or insert the flow id into the flow table, or something else?

Reproduction

Use postresql db instead of sqlite, publish a flow that saves a message.
Try to interact through the published flow.

Expected behavior

Message to be saved.

Who can help?

No response

Operating System

Ubuntu

Langflow Version

1.3.2

Python Version

None

Screenshot

No response

Flow File

No response

[dosubot]

Hi @egerszu! I'm Dosu, a bot here to help you with bugs, questions, and becoming a contributor. I'm happy to assist you while you wait for a human maintainer. Let’s get started!

To resolve the ForeignKeyViolation error in the message table when a published flow uses a non-existent flow ID, you should ensure that the flow ID exists in the flow table. This means you should insert the flow ID into the flow table rather than removing the constraint, as removing it would compromise data integrity. Maintaining referential integrity by ensuring the flow ID is present in the flow table is the recommended approach ^[1].

To continue talking to Dosu, mention @dosu.

---

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